Hi all, I have a problem with one of my tables. Error:

[0]: Partition '2022-10-08.1634154936' does not exist in table 'test_table' directory.

Run [ALTER TABLE test_table DROP PARTITION LIST '2022-10-08.1634154936'] to repair the table or restore the partition directory.

If I run

ALTER TABLE test_table DROP PARTITION LIST '2022-10-08.1634154936'

I get the following error:

table 'test_table' could not be altered:

[0]: Partition '2022-10-08.1634154936' does not exist in table 'test_table' directory.

Run [ALTER TABLE test_table DROP PARTITION LIST '2022-10-08.1634154936'] to repair the table

I can't find any errors in the logs. In the table are being saved records all the time with ILP and socket.sendall() Does any one have an idea how can I fix the table and what is the reason of the error on first place?

Hi Tihomir, You should run

ALTER TABLE test_table DROP PARTITION LIST '2022-10-08'

. The message is misleading

Hi Andrei, I am getting the same error msg

Did the ALTER TABLE statement execute successfully?

No,

ALTER TABLE test_table DROP PARTITION LIST '2022-10-08'

gives the same error:

table 'test_table' could not be altered:

[0]: Partition '2022-10-08.1634154936' does not exist in table 'test_table' directory.

Run [ALTER TABLE test_table DROP PARTITION LIST '2022-10-08.1634154936'] to repair the table

You need to stop ILP ingestion and wait for some time until the writer is released (or simply restart the database). Then you'll be able to drop the table

I have dropped the table already, If it happens again I will send you the data. Thanks for the help!