mysqld beendet sich regelmäßig?

Dieses Thema im Forum "Allgemein" wurde erstellt von neovanmatix, 27. Jan. 2015.

  1. neovanmatix

    neovanmatix Member

    Hallo,
    meine kuriosen Probleme gehen weiter :)
    Habe einen Debian ISPConfig mit Apache2 nach dem PerfectServer-HowTo aufgezogen. VM hat 1,8 GB RAM.
    Mein Problem ist, dass sich alle paar Tage der mysqld-Dienst beendet und natürlich nicht wieder autom. startet.
    Ich habe aber Probleme rauszufinden, warum das passiert: Die Log-Dateien, auch die gepackten unter /var/log/ betreffend MySQL sind alle leer.
    Hat jemand einen Tipp, wie ich der Sache weiter auf den Grund gehen kann?
     
  2. neovanmatix

    neovanmatix Member

    Hallo,
    habe im syslog folgendes gefunden:
    Code:
    should be repaired
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [Warning] Checking table:   './c03bm/wp2_wfScanners'
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [ERROR] /usr/sbin/mysqld: Table './c03bm/wp2_wfStatus' is marked as crashed and should be repaired
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [Warning] Checking table:   './c03bm/wp2_wfStatus'
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [ERROR] /usr/sbin/mysqld: Table './c03bm/wp2_wfVulnScanners' is marked as crashed and should be repaired
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [Warning] Checking table:   './c03bm/wp2_wfVulnScanners'
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wbb1_1_thread' is marked as crashed and should be repaired
    Jan 27 08:03:38 web1 mysqld: 150127  8:03:38 [Warning] Checking table:   './c0wdh/wbb1_1_thread'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_captcha' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_captcha'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_cronjobs' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_cronjobs'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_cronjobs_log' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_cronjobs_log'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_feed_entry' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_feed_entry'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_feed_source' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_feed_source'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_package_update_fromversion' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_package_update_fromversion'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_package_update_requirement' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_package_update_requirement'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_package_update_server' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_package_update_server'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_search' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_search'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_session_data' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_session_data'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_user' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_user'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './c0wdh/wcf1_user_failed_login' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './c0wdh/wcf1_user_failed_login'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/monitor_data' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/monitor_data'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/server' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/server'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/sys_datalog' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/sys_datalog'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/sys_ini' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/sys_ini'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/sys_remoteaction' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/sys_remoteaction'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/sys_session' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/sys_session'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/sys_user' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/sys_user'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/web_backup' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/web_backup'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/web_domain' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/web_domain'
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [ERROR] /usr/sbin/mysqld: Table './dbispconfig/web_traffic' is marked as crashed and should be repaired
    Jan 27 08:03:39 web1 mysqld: 150127  8:03:39 [Warning] Checking table:   './dbispconfig/web_traffic'

    Daraufhin habe ich den mysql-Dienst beendet, und folgendes in jedem der Ordner ausgeführt:
    myisamchk -r --safe-recover *.MYI

    Nach einem Neustart des Dienstes erscheinen auch keine Fehlermeldungen mehr im Log. Während die Tabellen als "gecrashed" markiert waren, haben aber die Websiten ganz normal funktioniert - ich werd's wohl beobachten müssen... :/
     
  3. Till

    Till Administrator

    Installier Dir mal munin und monit. das eine dient dem Überwachen der MySQL Erreichbarkeit inkl. neustart und das andere zeichnet Systemparameter auf und hilft Dir bei der Fehlersuche.
     

Diese Seite empfehlen