Title
#users-public
j

Justin Bojarski

11/03/2022, 1:42 PM
Hi I'm getting a bit of a quirky error I was hoping someone could help with... For some reason my questdb started throwing this error when I try to run a query on a particular table... Partition '2022-03-16.17' does not exist in table 'NFT_HISTORICAL_DATA' directory. Run [ALTER TABLE NFT_HISTORICAL_DATA DROP PARTITION LIST '2022-03-16.17'] to repair the table or restore the partition directory. But that date isn't valid, and when I try to drop that partition I get another error of 'YYYY-MM-DD' expected[errno=0] Any ideas how I can force this drop and correct the problem? Also I'm not even sure how this cropped up in the first place since it's clearly an invalid date so that's another problem
Andrey Pechkurov

Andrey Pechkurov

11/03/2022, 1:54 PM
Hi Justin, The message is wrong. It's a known bug: https://github.com/questdb/questdb/issues/2619 You should specify
2022-03-16
, not
2022-03-16.17
in your drop SQL.
1:55 PM
Were you running
kill -9
or force stopping the database previously? I wonder how you ended up in a situation when we have the partition in metadata, but it's absent on disk
j

Justin Bojarski

11/03/2022, 2:27 PM
I'm been throwing a ton of data at it over the last few weeks. It's possible there was a crash and reboot at some point, albeit not initiated by me. What's odd is I seem to somehow have gotten data corruption from that point onwards in my data 2022-03-16. Once I dropped that partition, I got subsequent requests to drop from every day after
2:28 PM
It was an easy enough dataset to rebuild so I just dropped the table and am in the process of reloading the data... But still not knowing the root cause of that is a little concerning
2:29 PM
When I tried pulling those rows up in the web GUI, they were all blanks after 2022-03-16
Andrey Pechkurov

Andrey Pechkurov

11/03/2022, 2:45 PM
But still not knowing the root cause of that is a little concerning
Yeah, if you face it once again, knowing the reproducer would be super helpful
j

Justin Bojarski

11/03/2022, 3:07 PM
I'll keep an eye on it and flag if I see anything funky. Hopefully it's just a one-off. Appreciate your help!