mysql wont start: Getting WARNING - DB::query -> reconnect Can't connect to local MySQL server throu

Discussion in 'ISPConfig 3 Priority Support' started by webguyz, Sep 3, 2015.

  1. webguyz

    webguyz Active Member HowtoForge Supporter

    I ws doing a system update on all servers and its says they are all up to date but started getting this email

    WARNING - DB::query -> reconnect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

    Not sure what to. All websites on server are down.

    Help!
     
    webguyz, Sep 3, 2015
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Try to restart mysql and then check the syslog for mysql errors. It might be that the my.cnf file from mysql contains an outdated config setting that prevents the start of mysql.
     
    till, Sep 3, 2015
    #2
  3. webguyz

    webguyz Active Member HowtoForge Supporter

    Looks like I had a crash dump occurred on the MySQL db. I am trying to restore an image backup of this vm now.
     
    webguyz, Sep 3, 2015
    #3
  4. webguyz

    webguyz Active Member HowtoForge Supporter

    Looks like that server was having all kinds of read errors and MySQL dumps but was still serving up websites for days prior to the final crash. What was worse it copied over the errors to the last image backup we did. Had to go 2 weeks back to find a disk image from our weekly image backups that did not have db corruption reported in syslog.
     
    webguyz, Sep 4, 2015
    #4

Share This Page