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.

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

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

  1. bloatedstoat

    bloatedstoat Well-Known Member

    Joined:
    Jun 14, 2012
    Messages:
    76
    Likes Received:
    6
    Trophy Points:
    8
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    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
     
  4. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    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.
     
  5. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Still occurs.
     
Loading...

Share This Page