Title
#users-public
a

Ajay Pilaniya

10/31/2022, 2:09 PM
I am getting below error when trying to drop a table :
Could not lock 'content_analytics' [reason='insert']
Although no insertion being done in this table. One insertion was being done but it was force stopped midway. Could that be the reason for this? Is there any way I can force drop this table?
Bolek Ziobrowski

Bolek Ziobrowski

10/31/2022, 2:31 PM
It's possible that the connection that did insert in transaction is holding lock on the table . Lock should clear on restart .
a

Ajay Pilaniya

10/31/2022, 4:01 PM
Ok will try that..
Bolek Ziobrowski

Bolek Ziobrowski

10/31/2022, 4:33 PM
By the way - questdb doesn't support cancellation of queries in progress (e.g. in psql) .