Title
#users-public
t

Tihomir Dimov

10/09/2022, 11:49 AM
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?
Andrey Pechkurov

Andrey Pechkurov

10/09/2022, 12:31 PM
Hi Tihomir, You should run
ALTER TABLE test_table DROP PARTITION LIST '2022-10-08'
. The message is misleading
t

Tihomir Dimov

10/09/2022, 12:47 PM
Hi Andrei, I am getting the same error msg
Andrey Pechkurov

Andrey Pechkurov

10/09/2022, 1:53 PM
Did the ALTER TABLE statement execute successfully?
t

Tihomir Dimov

10/10/2022, 7:49 PM
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
8:02 PM
If I try
DROP TABLE 'test_table'
I am getting:
Could not lock 'test_table' [reason='tcpIlp']
Andrey Pechkurov

Andrey Pechkurov

10/10/2022, 8:09 PM
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
8:10 PM
As for the same error, if it's possible, could you share an archive with the contents of the table directory (thus, the data) with me? Of course, if doesn't contain anything sensitive
t

Tihomir Dimov

10/10/2022, 8:21 PM
I have dropped the table already, If it happens again I will send you the data. Thanks for the help!