Forums

Tables not getting deleted from DB

Hello Pythonanywhere Team,

I was working with Pythonanywhere PostgreSQL DB from my local machine. There was a power outage when I was inserting data into DB.

Now I am not able to delete tables from DB. Whenever I call DROP TABLE table_name query, it just hangs.

Can you please look into it?

Regards, William

It sounds like there is still some kind of query running in your database server that is locking the tables in question; this Stack Overflow post has some good hints on how to track down what it is and how to kill it.