search

savelov / radar-wms

radar product wms viewer
GNU Lesser General Public License v3.0
9 stars 5 forks source link

resolve database is locked issue #30

Open savelov opened 4 years ago

savelov commented 4 years ago

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked 1) prevent journal to be left - handle the exception correctly? https://stackoverflow.com/questions/2740806/python-sqlite-database-is-locked 2) add timeout=10? 3) add retry on error?

savelov commented 4 years ago

fixed by ensuring rollback() after exception in commit() - this prevents keep sqlite database journal open after aborting https://ru.stackoverflow.com/questions/433166/%D0%A0%D0%B0%D0%B1%D0%BE%D1%82%D0%B0-%D1%81%D0%B0%D0%B9%D1%82%D0%B0-%D0%BD%D0%B0-sqlalchemy-%D0%BE%D1%81%D1%82%D0%B0%D0%BD%D0%BE%D0%B2%D0%B8%D0%BB%D0%B0%D1%81%D1%8C-%D0%B8%D0%B7-%D0%B7%D0%B0-%D0%BE%D0%B4%D0%BD%D0%BE%D0%B9-%D1%81%D0%BB%D1%83%D1%87%D0%B0%D0%B9%D0%BD%D0%BE%D0%B9-%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%B8-%D0%9F%D1%80%D0%B0%D0%B2%D0%B8%D0%BB%D1%8C%D0%BD%D0%BE

savelov commented 4 years ago

https://piotr.banaszkiewicz.org/blog/2014/02/22/how-to-bite-flask-sqlalchemy-and-pytest-all-at-once/#how-does-sqlalchemy-handle-sessions