Description:
MySQL Crashes 2x but recovers after getting error 4006
Upon restarting both slow_query and general_log are corrupt.
061117 16:24:17 mysqld started
061117 16:24:18 InnoDB: Started; log sequence number 0 46403
061117 16:24:28 [Note] Starting MySQL Cluster Binlog Thread
061117 16:24:28 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.11-beta-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
061117 16:24:28 [Note] SCHEDULER: Manager thread booting
061117 16:24:28 [Note] SCHEDULER: Loaded 0 events
061117 16:24:28 [Note] SCHEDULER: Suspending operations
061121 14:18:46 [ERROR] Got error 4006 when reading table './ccmt/cpeservice'
061121 14:36:30 [ERROR] Got error 4006 when reading table './ccmt/isplistforipaddresspool'
--- multiple lines deleted ---
061121 14:36:31 [ERROR] Got error 4006 when reading table './ccmt/isplistforrtrncapgrp'
061121 14:36:32 [ERROR] Got error 4006 when reading table './ccmt/serviceproxy'
061121 14:36:33 [ERROR] Got error 4006 when reading table './ccmt/isplistforrtrncapgrp'
061121 14:36:34 [ERROR] Got error 4006 when reading table './ccmt/shapingconfig'
061121 14:36:34 [ERROR] Got error 4006 when reading table './ccmt/isplistforipaddresspool'
061121 14:36:36 [ERROR] Got error 4006 when reading table 061121 15:15:16 [ERROR] Got error 4006 when reading table './ccmt/cpeconfig'
061121 15:22:02 [ERROR] Got error 4006 when reading table './ccmt/vpnconfig'
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=8388600
read_buffer_size=1044480
max_used_connections=45
max_connections=100
threads_connected=17
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 212591 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0xf43f1e80
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x530e61c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81d9210 handle_segfault + 416
0x5ee8b8 (?)
(nil)
0x828c51e _Z19ha_commit_one_phaseP3THDb + 110
0x828c322 _Z15ha_commit_transP3THDb + 386
0x81f015f _Z9end_transP3THD25enum_mysql_completiontype + 95
0x81f52b6 _Z21mysql_execute_commandP3THD + 13382
Stack trace seems successful - bottom reached
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how
to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xf3d345e8 is invalid pointer
thd->thread_id=38664
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
mysqld: my_new.cc:51: int __cxa_pure_virtual(): Assertion `"Pure virtual method called." == "Aborted
"' failed.
Fatal signal 6 while backtracing
Number of processes running now: 0
061121 15:22:02 mysqld restarted
061121 15:22:03 InnoDB: Started; log sequence number 0 46403
061121 15:22:13 [Note] Starting MySQL Cluster Binlog Thread
/usr/sbin/mysqld: Table 'general_log' is marked as crashed and should be repaired
Management server closed connection early. It is probably being shut down (or has crashed). We will
retry the connection.
/usr/sbin/mysqld: Table 'slow_log' is marked as crashed and should be repaired
061121 15:24:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.11-beta-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
061121 15:24:06 [Note] SCHEDULER: Manager thread booting
061121 15:24:06 [Note] SCHEDULER: Loaded 0 events
061121 15:24:07 [Note] SCHEDULER: Suspending operations
061121 15:29:58 [ERROR] Got error 4006 when reading table './ccmt/cpeconfig'
061121 15:33:30 [ERROR] Got error 4006 when reading table './ccmt/vpnconfig'
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=8388600
read_buffer_size=1044480
max_used_connections=14
max_connections=100
threads_connected=13
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 212591 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0xf5b66338
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x49861c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81d9210 handle_segfault + 416
0x5a58b8 (?)
(nil)
0x828c51e _Z19ha_commit_one_phaseP3THDb + 110
0x828c322 _Z15ha_commit_transP3THDb + 386
0x81f015f _Z9end_transP3THD25enum_mysql_completiontype + 95
0x81f52b6 _Z21mysql_execute_commandP3THD + 13382
0x81f9abb _Z11mysql_parseP3THDPcj + 347
0x81f07e3 _Z16dispatch_command19enum_server_commandP3THDPcj + 1123
0x81f032d _Z10do_commandP3THD + 141
0x81ef85f handle_one_connection + 655
0x5a0080 (?)
0xc1523e (?)
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how
to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xa2fbce8 = commit
thd->thread_id=68
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
061121 15:33:31 mysqld restarted
061121 15:33:31 InnoDB: Started; log sequence number 0 46403
061121 15:33:32 [Note] Starting MySQL Cluster Binlog Thread
/usr/sbin/mysqld: Table 'general_log' is marked as crashed and should be repaired
/usr/sbin/mysqld: Table 'slow_log' is marked as crashed and should be repaired
061121 15:35:02 [Note] /usr/sbin/mysqld: ready for connections.
How to repeat:
Looks like 24480 , is on same databae, but it's not an identical crash.
