mysqld beendet sich regelmäßig?

#1
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
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
#3
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