The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

sqlite3 database is locked

Discussion in 'Database Discussions' started by falgi, Aug 11, 2016.

Tags:
  1. falgi

    falgi Registered

    Joined:
    Aug 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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 :)
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    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.
     
  3. falgi

    falgi Registered

    Joined:
    Aug 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Jakarta
    cPanel Access Level:
    Root Administrator
    I'm not really sure that this issue persists after updating. Please help me :)
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,451
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    What version of cPanel is your server running?
     
  5. falgi

    falgi Registered

    Joined:
    Aug 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Jakarta
    cPanel Access Level:
    Root Administrator
    I use WHM 58.0 (build 20)

    Here is some of another error message

    Error: dict-client: server returned failure:
     
  6. Pedro Marques

    Pedro Marques Registered

    Joined:
    Aug 16, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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','xxx@xxx.xxx')) failed: database is locked (5)
     
  7. Tony Castaneda

    Tony Castaneda Registered

    Joined:
    Aug 17, 2016
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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','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
    
     
  8. Tony Castaneda

    Tony Castaneda Registered

    Joined:
    Aug 17, 2016
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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.
     
    Infopro likes this.
  9. bloatedstoat

    bloatedstoat Well-Known Member

    Joined:
    Jun 14, 2012
    Messages:
    78
    Likes Received:
    6
    Trophy Points:
    8
    Location:
    Victoria, Australia
    cPanel Access Level:
    Root Administrator
    Which setting did you change to 50 @Tony Castenada?
     
  10. maquinadigital

    maquinadigital Well-Known Member

    Joined:
    Aug 10, 2006
    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    8
    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
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page