mysqld beendet sich regelmäßig?

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?
 
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... :/
 

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.
 

Werbung

Top