Hallo,
habe vorhin auf meinen Server mit apt-get upgrade geupdated, seitdem startet mysql nicht mehr.
Im syslog steht folgendes:
Aug 4 15:24:58 server mysqld_safe[11121]: started
Aug 4 15:24:58 server mysqld[11124]: mysqld got signal 11;
Aug 4 15:24:58 server mysqld[11124]: This could be because you hit a bug. It is also possible that this binary
Aug 4 15:24:58 server mysqld[11124]: or one of the libraries it was linked against is corrupt, improperly built,
Aug 4 15:24:58 server mysqld[11124]: or misconfigured. This error can also be caused by malfunctioning hardware.
Aug 4 15:24:58 server mysqld[11124]: We will try our best to scrape up some info that will hopefully help diagnose
Aug 4 15:24:58 server mysqld[11124]: the problem, but since we have already crashed, something is definitely wrong
Aug 4 15:24:58 server mysqld[11124]: and this may fail.
Aug 4 15:24:58 server mysqld[11124]:
Aug 4 15:24:58 server mysqld[11124]: key_buffer_size=0
Aug 4 15:24:58 server mysqld[11124]: read_buffer_size=131072
Aug 4 15:24:58 server mysqld[11124]: max_used_connections=0
Aug 4 15:24:58 server mysqld[11124]: max_connections=100
Aug 4 15:24:58 server mysqld[11124]: threads_connected=0
Aug 4 15:24:58 server mysqld[11124]: It is possible that mysqld could use up to
Aug 4 15:24:58 server mysqld[11124]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 217599 K
Aug 4 15:24:58 server mysqld[11124]: bytes of memory
Aug 4 15:24:58 server mysqld[11124]: Hope that's ok; if not, decrease some variables in the equation.
Aug 4 15:24:58 server mysqld[11124]:
Aug 4 15:24:58 server mysqld[11124]: thd=(nil)
Aug 4 15:24:58 server mysqld[11124]: Attempting backtrace. You can use the following information to find out
Aug 4 15:24:58 server mysqld[11124]: where mysqld died. If you see no messages after this, something went
Aug 4 15:24:58 server mysqld[11124]: terribly wrong...
Aug 4 15:24:58 server mysqld[11124]: Cannot determine thread, fp=0xbfffc6f8, backtrace may not be correct.
Aug 4 15:24:58 server mysqld[11124]: Stack range sanity check OK, backtrace follows:
Aug 4 15:24:58 server mysqld[11124]: 0x81c06b9
Aug 4 15:24:58 server mysqld[11124]: 0x8358590
Aug 4 15:24:58 server mysqld[11124]: 0x82f0fd1
Aug 4 15:24:58 server mysqld[11124]: 0x8277fe7
Aug 4 15:24:58 server mysqld[11124]: 0x826d792
Aug 4 15:24:58 server mysqld[11124]: 0x81bf7a5
Aug 4 15:24:58 server mysqld[11124]: 0x81c2d85
Aug 4 15:24:58 server mysqld[11124]: 0xb7d31ea8
Aug 4 15:24:58 server mysqld[11124]: 0x8139de1
Aug 4 15:24:58 server mysqld[11124]: New value of fp=(nil) failed sanity check, terminating stack trace!
Aug 4 15:24:58 server mysqld[11124]: Please read http://dev.mysql.com/doc/mysql/en/us...ack-trace.html and follow inst
ructions on how to resolve the stack trace. Resolved
Aug 4 15:24:58 server mysqld[11124]: stack trace is much more helpful in diagnosing the problem, so please do
Aug 4 15:24:58 server mysqld[11124]: resolve it
Aug 4 15:24:58 server mysqld[11124]: The manual page at Search Results: Crashing.html contains
Aug 4 15:24:58 server mysqld[11124]: information that should help you find out what is causing the crash.
Aug 4 15:24:58 server mysqld_safe[11126]: ended
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/deb
ian.cnf ping' resulted in
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: error: 'Can't connect to local MySQL server through socket '/var/run/mysq
ld/mysqld.sock' (2)'
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld
.sock' exists!
Aug 4 15:25:13 server /etc/init.d/mysql[11266]:
Die Datei mysqld.sock existiert in der Tat nicht (aber die Dait wird doch vom init.d Skript erstellt!?). Die Rechte vom mysqld Verzeichniss stimmen und auch in der /etc/mysql/my.cnf sind die richtigen Pfade angegeben.
Wäre super wenn mir jemand weiterhelfen kann.
Gruß,
Till
habe vorhin auf meinen Server mit apt-get upgrade geupdated, seitdem startet mysql nicht mehr.
Im syslog steht folgendes:
Aug 4 15:24:58 server mysqld_safe[11121]: started
Aug 4 15:24:58 server mysqld[11124]: mysqld got signal 11;
Aug 4 15:24:58 server mysqld[11124]: This could be because you hit a bug. It is also possible that this binary
Aug 4 15:24:58 server mysqld[11124]: or one of the libraries it was linked against is corrupt, improperly built,
Aug 4 15:24:58 server mysqld[11124]: or misconfigured. This error can also be caused by malfunctioning hardware.
Aug 4 15:24:58 server mysqld[11124]: We will try our best to scrape up some info that will hopefully help diagnose
Aug 4 15:24:58 server mysqld[11124]: the problem, but since we have already crashed, something is definitely wrong
Aug 4 15:24:58 server mysqld[11124]: and this may fail.
Aug 4 15:24:58 server mysqld[11124]:
Aug 4 15:24:58 server mysqld[11124]: key_buffer_size=0
Aug 4 15:24:58 server mysqld[11124]: read_buffer_size=131072
Aug 4 15:24:58 server mysqld[11124]: max_used_connections=0
Aug 4 15:24:58 server mysqld[11124]: max_connections=100
Aug 4 15:24:58 server mysqld[11124]: threads_connected=0
Aug 4 15:24:58 server mysqld[11124]: It is possible that mysqld could use up to
Aug 4 15:24:58 server mysqld[11124]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 217599 K
Aug 4 15:24:58 server mysqld[11124]: bytes of memory
Aug 4 15:24:58 server mysqld[11124]: Hope that's ok; if not, decrease some variables in the equation.
Aug 4 15:24:58 server mysqld[11124]:
Aug 4 15:24:58 server mysqld[11124]: thd=(nil)
Aug 4 15:24:58 server mysqld[11124]: Attempting backtrace. You can use the following information to find out
Aug 4 15:24:58 server mysqld[11124]: where mysqld died. If you see no messages after this, something went
Aug 4 15:24:58 server mysqld[11124]: terribly wrong...
Aug 4 15:24:58 server mysqld[11124]: Cannot determine thread, fp=0xbfffc6f8, backtrace may not be correct.
Aug 4 15:24:58 server mysqld[11124]: Stack range sanity check OK, backtrace follows:
Aug 4 15:24:58 server mysqld[11124]: 0x81c06b9
Aug 4 15:24:58 server mysqld[11124]: 0x8358590
Aug 4 15:24:58 server mysqld[11124]: 0x82f0fd1
Aug 4 15:24:58 server mysqld[11124]: 0x8277fe7
Aug 4 15:24:58 server mysqld[11124]: 0x826d792
Aug 4 15:24:58 server mysqld[11124]: 0x81bf7a5
Aug 4 15:24:58 server mysqld[11124]: 0x81c2d85
Aug 4 15:24:58 server mysqld[11124]: 0xb7d31ea8
Aug 4 15:24:58 server mysqld[11124]: 0x8139de1
Aug 4 15:24:58 server mysqld[11124]: New value of fp=(nil) failed sanity check, terminating stack trace!
Aug 4 15:24:58 server mysqld[11124]: Please read http://dev.mysql.com/doc/mysql/en/us...ack-trace.html and follow inst
ructions on how to resolve the stack trace. Resolved
Aug 4 15:24:58 server mysqld[11124]: stack trace is much more helpful in diagnosing the problem, so please do
Aug 4 15:24:58 server mysqld[11124]: resolve it
Aug 4 15:24:58 server mysqld[11124]: The manual page at Search Results: Crashing.html contains
Aug 4 15:24:58 server mysqld[11124]: information that should help you find out what is causing the crash.
Aug 4 15:24:58 server mysqld_safe[11126]: ended
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/deb
ian.cnf ping' resulted in
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: error: 'Can't connect to local MySQL server through socket '/var/run/mysq
ld/mysqld.sock' (2)'
Aug 4 15:25:13 server /etc/init.d/mysql[11266]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld
.sock' exists!
Aug 4 15:25:13 server /etc/init.d/mysql[11266]:
Die Datei mysqld.sock existiert in der Tat nicht (aber die Dait wird doch vom init.d Skript erstellt!?). Die Rechte vom mysqld Verzeichniss stimmen und auch in der /etc/mysql/my.cnf sind die richtigen Pfade angegeben.
Wäre super wenn mir jemand weiterhelfen kann.
Gruß,
Till
Kommentar