https://questdb.io logo
Title
f

Franco Almonacid

03/14/2023, 5:46 PM
2023-03-14T17:45:29.125713Z C i.q.c.h.p.JsonQueryProcessorState [3009] error [q=`ALTER TABLE binance_dc DETACH PARTITION LIST '2023-03-13';`, msg=`could not detach partition [table=binance_dc, detachStatus=DETACH_ERR_ACTIVE, partitionTimestamp=2023-03-13T00:00:00.000Z, partitionBy=DAY]`, errno=-100]
i

Imre

03/14/2023, 6:33 PM
hi @Franco Almonacid, i think the error
DETACH_ERR_ACTIVE
suggests that the partition is still active, so cannot be detached.
i see that the table is partitioned by DAY so not sure how yesterday’s partition can still be active. maybe there is no data for
2023-03-14
in the table so
2023-03-13
is the last and active partition?
f

Franco Almonacid

03/14/2023, 6:41 PM
Hi @Imre that's right, there is no data for the
2023-03-14
partition
we managed to remove the
2023-03-13
partition using
DROP PARTITION
instead of
DETACH PARTITION
as we just wanted to delete the data
i

Imre

03/14/2023, 6:54 PM
đź‘Ť