Tach,
wir haben einen Rootserver bei Hetzner (OSebian / Confixx 3.3) , der aus unerfindlichen Gründen meistens am Wochende zur vollen Stunde crasht.
chkrootkit + logcheck haben nichts verdächtiges gefunden. Im auth.log steht auch nichts von verdächtigen Logins.
lediglich im daemon.log wird auf corrupt tables hingewiesen_
Kann der Systemcrash eventuell was mit kaputten Datenbanken zu tun haben , weil z.B. Backupprozesse oder Confixx damit nicht klar kommt ?
Antwort / Hinweise wie man weiter auf Fehlersuche gehen könnte wären super nett ?
Dank euch im voraus !!!
Gruß
Heinz
Gruß
wir haben einen Rootserver bei Hetzner (OSebian / Confixx 3.3) , der aus unerfindlichen Gründen meistens am Wochende zur vollen Stunde crasht.
chkrootkit + logcheck haben nichts verdächtiges gefunden. Im auth.log steht auch nichts von verdächtigen Logins.
lediglich im daemon.log wird auf corrupt tables hingewiesen_
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: WARNING: mysqlcheck has found corrupt tables
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: confixx.allgemein
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: confixx.register
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: confixx.zeiten
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_1.cache_pagesection
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_14.cache_pagesection
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstatcounter
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstatmaintable
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstatplugins
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstatreferer
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstattrack
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 2 clients are using or haven't closed the table properlyOct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstattransfer
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 2 clients are using or haven't closed the table properlyOct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstatuseronline
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 2 clients are using or haven't closed the table properlyOct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_19.bstatvisitors
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 2 clients are using or haven't closed the table properlyOct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_24.tracker
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_3.cache_hash
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_3.cache_pages
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_3.cache_pagesection
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 2 clients are using or haven't closed the table properlyOct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_3.tx_realurl_errorlog
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_3.tx_realurl_urldecodecache
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web1_3.tx_realurl_urlencodecache
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: usr_web2_1.cache_pages
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: warning : 1 client is using or hasn't closed the table properly
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]:
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: Improperly closed tables are also reported if clients are accessing
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: the tables *now*. A list of current connections is below.
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]:
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: +----+------------------+-----------+------------+---------+------+-------+------------------+
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: | Id | User | Host | db | Command | Time | State | Info |
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: +----+------------------+-----------+------------+---------+------+-------+------------------+
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: | 9 | web1 | localhost | usr_web1_3 | Sleep | 1 | | |
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: | 10 | web1 | localhost | usr_web1_3 | Sleep | 3 | | |
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: | 11 | web1 | localhost | usr_web1_3 | Sleep | 1 | | |
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: | 13 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: +----+------------------+-----------+------------+---------+------+-------+------------------+
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3681]: Uptime: 18446744073709548081 Threads: 4 Questions: 1433 Slow queries: 1 Opens: 1366 Flush tables: 1 Open tables: 64 Queries per second avg: 0.000
Oct 20 13:04:53 localhost /etc/mysql/debian-start[3692]: Upgrading MySQL tables if necessary.
Kann der Systemcrash eventuell was mit kaputten Datenbanken zu tun haben , weil z.B. Backupprozesse oder Confixx damit nicht klar kommt ?
Antwort / Hinweise wie man weiter auf Fehlersuche gehen könnte wären super nett ?
Dank euch im voraus !!!
Gruß
Heinz
Gruß