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
  Webscrape using RPi and SQlite database, always write the last value in database Armond 0 1,544 Jul-19-2023, 09:11 PM
Last Post: Armond
  Flask error sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint pythonpaul32 2 10,258 Feb-21-2023, 03:13 AM
Last Post: noisefloor
  Flask and SQLAlchemy question: Database is being created but tables aren't adding pythonpaul32 3 13,504 Feb-07-2023, 10:48 AM
Last Post: pythonpaul32
  Flask/non-flask database sharing MorganSamage 2 2,748 Feb-03-2023, 12:05 PM
Last Post: MorganSamage
  Error updating one to many relationship in Flask/ SQLAlchemy atindra 0 4,574 Apr-15-2021, 10:29 PM
Last Post: atindra
  Django : OperationalError no such column: Utilisateurs_videos.user_id Adem 0 5,147 Mar-20-2021, 06:11 PM
Last Post: Adem
  Flask migrate sqlalchemy not found TomasAm 2 5,541 Dec-01-2020, 10:04 AM
Last Post: TomasAm
  python 3.7 on windows using flask and flask-sqlalchemy. Alpy 2 5,677 Aug-12-2020, 07:24 PM
Last Post: Alpy
  Flask export/upload database table in cvs/xlsx format steve87bg 4 11,556 Jun-19-2020, 01:46 PM
Last Post: steve87bg
  Flask-Sqlalchemy count products in specific category imawesome 2 47,661 Mar-12-2020, 08:14 PM
Last Post: imawesome

Forum Jump:

User Panel Messages

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