Replies: 1 comment
-
Sorry to hear of the crash! We're actively working on allowing to drop active partition. Likely next release will have it |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We had a server crash yesterday. When the server was rebooted and questdb restarted, we found the active partition on one of the tables was corrupted. As a result, all
INSERT
s were failing.We could generally
SELECT
data prior to the current day but there were statements that would cause the questdb worker to crash. Examples:Since we
...PARTITION BY DAY...
, I thought we'd only have to wait until 00:00 UTC, expecting QuestDB to create a new partition but it didn't.INSERT
s continued to fail and I could notALTER TABLE DROP PARTITION
because the active partition was still the corrupted one.My restoration process became:
What's the rationale behind not allowing the active partiton to be detached or dropped, given that there's no similar limitation to drop the entire table? (Being able to drop the active partition could have saved me a few steps.)
Beta Was this translation helpful? Give feedback.
All reactions