sqlite3 database is locked

falgi

• August 11, 2016 20:17

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

  • August 15, 2016 20:06

  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.

  0
• 

  falgi

  • August 16, 2016 00:56

  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 :)

  0
• 

  Infopro

  • August 16, 2016 01:57

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

  
  What version of cPanel is your server running?

  0
• 

  falgi

  • August 16, 2016 02:17

  I use WHM 58.0 (build 20) Here is some of another error message Error: dict-client: server returned failure:

  0
• 

  Pedro Marques

  • August 16, 2016 15:58

  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','xxx@xxx.xxx')) failed: database is locked (5)

  0
• 

  Tony Castaneda

  • August 17, 2016 18:55

  Same issue
  /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','REMOVED@REMOVED.com')) failed: database is locked (5) Aug 17 18:21:53 mail dovecot: dict(537): Error: sql dict: commit failed: database is locked
  

  0
• 

  Tony Castaneda

  • August 18, 2016 17:06

  ** 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.

  0
• 

  bloatedstoat

  • August 19, 2016 02:14

  ** Update I changed the WHM > Mailserver Configuration to 50 and that fixed the issue.

  
  Which setting did you change to 50 @Tony Castenada?

  0
• 

  maquinadigital

  • August 23, 2016 14:21

  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

  0
• 

  cPanelMichael

  • August 23, 2016 21:44

  Hello, An additional case, CPANEL-7770, should correct this problem in cPanel 58.0.24: Fixed case CPANEL-7770: Switch to posix fs for dovecot lastlogin tracking You can review the full change log, information on updating cPanel/WHM, and information on the build/release process at:

  0

Please sign in to leave a comment.