pandas-dev / pandas

Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more
https://pandas.pydata.org
BSD 3-Clause "New" or "Revised" License
42.62k stars 17.57k forks source link

database is locked #59149

Open Happiness-in-Danger opened 4 days ago

Happiness-in-Danger commented 4 days ago

Research

Link to question on StackOverflow

https://stackoverflow.com/questions/3172929/operationalerror-database-is-locked

Question about pandas

Image_1719753762358

The picture is error log

My program transfers the downloaded data to the database by to_sql.The programe is closed like Ctrl+C and closed terminal ,and when I restart my programe,the datebase is locked.Even though I've tried to delay retrying.I close the cursor and connection of the data through the atexit module when the program is closed.But The problem remains. I don't know how to solve this problem. She has been bothering me for a long time.Thanks