OperationalError: database is locked in SQLite3

Question

I'm trying to access the history of chrome browser which is a SQLite file. My code was working fine but recently I'm facing this error- sqlite3.OperationalError: database is locked

Is there any solution?

Error message

Possible duplicate of [Python SQLite: database is locked](https://stackoverflow.com/questions/2740806/python-sqlite-database-is-locked) — Dadep, Apr 26 '18 at 12:21

score 1 · Answer 1 · answered Apr 26 '18 at 12:23

1

Set the timeout parameter:

connection = sqlite.connect('name.db', timeout=1)

answered Apr 26 '18 at 12:23

Aniket Bote

3,456
3
15
33

1

I'd guess Chrome locks the DB longer than one millisecond. – CL. Apr 26 '18 at 16:18
That may cause the problem if Chrome locks the DB. Is there any tricks to get away from it? – zeroFighter Apr 28 '18 at 03:28

score 0 · Accepted Answer · answered Oct 09 '18 at 08:56

0

Chrome locks the database when it is open. I have closed it and its started working.

answered Oct 09 '18 at 08:56

zeroFighter

123
2
13

OperationalError: database is locked in SQLite3

2 Answers2