sqlite3 database is locked

falgi

Registered
Aug 11, 2016
4
0
1
Jakarta
cPanel Access Level
Root Administrator
Hello all, i want ask. Sorry if my english is bad

I got this error message "Error: sql dict: commit failed: database is locked" "failed: database is locked (5)"

What should i do ?

Thanks for the answers :)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello,

Internal case CPANEL-7835 should help to address this issue. It's included with cPanel version 58.0.17 and newer:

Fixed case CPANEL-7835: Split dovecot lastlogin tracking into a seperate sqlite db.

Could you let us know if the issue persists after updating to a version of cPanel that includes this resolution?

Thank you.
 

falgi

Registered
Aug 11, 2016
4
0
1
Jakarta
cPanel Access Level
Root Administrator
Hello,

Internal case CPANEL-7835 should help to address this issue. It's included with cPanel version 58.0.17 and newer:

Fixed case CPANEL-7835: Split dovecot lastlogin tracking into a seperate sqlite db.

Could you let us know if the issue persists after updating to a version of cPanel that includes this resolution?

Thank you.
I'm not really sure that this issue persists after updating. Please help me :)
 

Pedro Marques

Member
Aug 16, 2016
6
0
1
Porto
cPanel Access Level
Root Administrator
Hi,

Having same issue with my server (WHM 58.0 (build 20)).

Here's a sample error message found constantly in /var/log/maillog:

Aug 15 16:54:10 xxx dovecot: dict(9185): Error: sqlite: exec(INSERT INTO lastlogin (login_stamp,username) VALUES ('1471276449','[email protected]')) failed: database is locked (5)
 

Tony Castaneda

Registered
Aug 17, 2016
2
1
3
Mesa Az
cPanel Access Level
Root Administrator
Same issue
Code:
/usr/local/cpanel/cpanel -V
58.0 (build 20)

/var/log/maillog
Aug 17 18:21:53 mail dovecot: dict(537): Error: sqlite: exec(INSERT INTO lastlogin (login_stamp,username) VALUES ('1471458112','[email protected]')) failed: database is locked (5)
Aug 17 18:21:53 mail dovecot: dict(537): Error: sql dict: commit failed: database is locked
 

Tony Castaneda

Registered
Aug 17, 2016
2
1
3
Mesa Az
cPanel Access Level
Root Administrator
** Update
Found out that the customer was connecting to 8 other boxes on the server at the same time and had ~25 connections from the same IP.

I changed the WHM > Mailserver Configuration to 50 and that fixed the issue.
 
  • Like
Reactions: Infopro

maquinadigital

Well-Known Member
Aug 10, 2006
57
1
158
cPanel Access Level
DataCenter Provider
I'm also getting tons of these log line @ maillog,
Error: sqlite: exec(INSERT INTO lastlogin (login_stamp,username) VALUES...failed: database is locked (5)

Any help with this?

I'm using CPanel 11.58.0.20
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363