Python Forum
Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
#1
Hi,

I am trying to update a database table and I keep getting this error:

'sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked'

None of the solutions online have helped and I am more confused than ever. Any help here would be greatly appreciated. Otherwise, I will have to remake the db.
Reply
#2
read: https://www.sqlite.org/lockingv3.html
Some will tell you that sqlite is not concurrent, however it is fully ACID compliant an can handle up to 50,000 inserts per second.
You should use transaction processing.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Flask error sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint pythonpaul32 2 3,709 Feb-21-2023, 03:13 AM
Last Post: noisefloor
  Flask and SQLAlchemy question: Database is being created but tables aren't adding pythonpaul32 3 4,740 Feb-07-2023, 10:48 AM
Last Post: pythonpaul32
  Flask/non-flask database sharing MorganSamage 2 1,197 Feb-03-2023, 12:05 PM
Last Post: MorganSamage
  Error updating one to many relationship in Flask/ SQLAlchemy atindra 0 3,346 Apr-15-2021, 10:29 PM
Last Post: atindra
  Django : OperationalError no such column: Utilisateurs_videos.user_id Adem 0 3,049 Mar-20-2021, 06:11 PM
Last Post: Adem
  Flask migrate sqlalchemy not found TomasAm 2 3,512 Dec-01-2020, 10:04 AM
Last Post: TomasAm
  python 3.7 on windows using flask and flask-sqlalchemy. Alpy 2 4,017 Aug-12-2020, 07:24 PM
Last Post: Alpy
  Flask export/upload database table in cvs/xlsx format steve87bg 4 6,870 Jun-19-2020, 01:46 PM
Last Post: steve87bg
  Flask-Sqlalchemy count products in specific category imawesome 2 30,052 Mar-12-2020, 08:14 PM
Last Post: imawesome
  Flask-SqlAlchemy - Relationship failed to locate a name - Please Help howardrwb 0 5,223 Jan-31-2020, 08:38 PM
Last Post: howardrwb

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020