Database is locked #26

New Issue

Closed

opened 2022-07-08 22:27:49 +00:00 by Miroslavsckaya · 2 comments

Miroslavsckaya commented

2022-07-08 22:27:49 +00:00

Owner

Find out why the database is locked and solve this


File "/home/mitsuha_s/tg_rss_bot/database.py", line 136, in update_feed_items
    self.cur.execute('DELETE FROM feeds_last_items WHERE feed_id = ?', [feed_id])
sqlite3.OperationalError: database is locked

Find out why the database is locked and solve this ``` File "/home/mitsuha_s/tg_rss_bot/database.py", line 136, in update_feed_items self.cur.execute('DELETE FROM feeds_last_items WHERE feed_id = ?', [feed_id]) sqlite3.OperationalError: database is locked ```

Miroslavsckaya added the

bug

label 2022-07-08 22:28:58 +00:00

skobkin commented

2022-07-08 22:29:18 +00:00

Collaborator

Check this out and think if we need global thread lock:
https://gist.github.com/rianhunter/10bfcff17c18d112de16?permalink_comment_id=3122052#gistcomment-3122052

Also this could probably be caused by two scripts running with the same database open simultaneously:
https://docs.pyrogram.org/faq/sqlite3-operationalerror-database-is-locked

Check this out and think if we need global thread lock: https://gist.github.com/rianhunter/10bfcff17c18d112de16?permalink_comment_id=3122052#gistcomment-3122052 Also this could probably be caused by two scripts running with the same database open simultaneously: https://docs.pyrogram.org/faq/sqlite3-operationalerror-database-is-locked

Miroslavsckaya self-assigned this 2022-07-08 22:29:36 +00:00

Miroslavsckaya added this to the RSS Bot Kanban Perdoling project 2022-07-08 22:32:23 +00:00

Miroslavsckaya commented

2022-07-09 13:35:47 +00:00

Author

Owner

Closed in favor of #15. PostgreSQL is much more compatible with multiple simultaneous clients.

👍 1

Miroslavsckaya closed this issue

2022-07-09 13:35:49 +00:00

Miroslavsckaya added the

wontfix