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

Technical Support Community Manager
Staff member
Apr 11, 2011
47,902
2,227
363
cPanel Access Level
DataCenter Provider
Twitter
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

Registered
Aug 16, 2016
1
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
52
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

Technical Support Community Manager
Staff member
Apr 11, 2011
47,902
2,227
363
cPanel Access Level
DataCenter Provider
Twitter