Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

DBD::mysql::st execute failed: Lost connection to MySQL server

Discussion in 'Database Discussion' started by bloatedstoat, Mar 22, 2014.

  1. bloatedstoat

    bloatedstoat Well-Known Member

    Joined:
    Jun 14, 2012
    Messages:
    127
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Victoria, Australia
    cPanel Access Level:
    Root Administrator
    Hello,

    Last night the data centre had an issue with a switch which apparently led to the filesystem on our server being rendered read only.
    After the switch issue was resolved we rebooted our server and all appears to be running as expected except for the following where we receive errors every 4 hours.

    DBD::mysql::st execute failed: Lost connection to MySQL server during query at bin/update_db_cache line 334.
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at bin/update_db_cache line 334.

    Has anyone come across this before? Is there a fix for this?

    Thanks in advance for any help.

    ----
    CENTOS 6.5 x86_64 xenpv
    WHM 11.42.0 (build 22)
    Load Averages: 0.07 0.17 0.14
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Do you notice any error messages in /var/lib/mysql/$hostname.err when restarting the MySQL service or when running "/usr/local/cpanel/scripts/update_db_cache" manually?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Code:
    140608 00:31:50 mysqld_safe Number of processes running now: 0
    140608 00:31:50 mysqld_safe mysqld restarted
    140608  0:31:50 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
    140608  0:31:50 [Note] Plugin 'FEDERATED' is disabled.
    140608  0:31:50  InnoDB: Initializing buffer pool, size = 1.2G
    140608  0:31:51  InnoDB: Completed initialization of buffer pool
    InnoDB: Log scan progressed past the checkpoint lsn 22 4199971154
    140608  0:31:51  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 22 4199973037
    140608  0:31:51  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
    InnoDB: Apply batch completed
    140608  0:31:52  InnoDB: Started; log sequence number 22 4199973037
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    575
    Likes Received:
    20
    Trophy Points:
    143
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    The above log error shows some possible InnoDB corruption. It also however shows that it may have been repaired. Are you still having issues with running "/usr/local/cpanel/scripts/update_db_cache" manually?

    If so, please feel free to open a support ticket using the link in my signature. Please post the ticket number in this thread so we can update it accordingly.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Still occurs.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice