【求助】大家帮忙看看mysql崩溃日志 什么原因

xinxin415415

120211 12:59:43 - mysqld got signal 6;
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=402653184
read_buffer_size=4190208
max_used_connections=44
max_connections=2000
threads_connected=23
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 4186288 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x8b101b0
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=0x9ad81938, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81b9a61
0xffffe410
0xb7e1cea3
0xb7e50f8b
0xb7e56911
0xb7e57f84
0x8260b5f
0x820d272
0x81ffcfb
0x8200b2b
0x81fbf44
0x81cf0de
0x81d5a43
0x81cda9e
0x81cd59c
0x81ccc14
0xb7f8634b
0xb7eb065e
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 0x8b17370 = SELECT EMAIL_ID from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='zhangxianfeng'  and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by SEND_TIME,TO_ID2 order by SEND_TIME desc limit 0,3
thd->thread_id=7
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.
120211 13:00:50 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown


Number of processes running now: 0
120211 13:01:20  mysqld restarted
120211 13:01:20  InnoDB: Started; log sequence number 0 43665
120211 13:01:20 [Note] Recovering after a crash using mysql-bin
120211 13:01:20 [Note] Starting crash recovery...
120211 13:01:20 [Note] Crash recovery finished.
120211 13:01:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/tmp/mysql.sock'  port: 3336  MySQL Community Server (GPL)
A mysqld process already exists at  Sat Feb 11 13:01:26 CST 2012
*** glibc detected *** /usr/local/mysql/bin/mysqld: double free or corruption (!prev): 0x08bb5ba0 ***
======= Backtrace: =========
/lib/libc.so.6[0xb7e60911]
/lib/libc.so.6(__libc_free+0x84)[0xb7e61f84]
/usr/local/mysql/bin/mysqld(_Z8filesortP3THDP8st_tableP13st_sort_fieldjP10SQL_SELECTyPy+0x37f)[0x8260b5f]
/usr/local/mysql/bin/mysqld[0x820d272]
/usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x104f)[0x81ffcfb]
/usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1d3)[0x8200b2b]
/usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x124)[0x81fbf44]
/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2a6)[0x81cf0de]
/usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0xe7)[0x81d5a43]
/usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x4c6)[0x81cda9e]
/usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x90)[0x81cd59c]
/usr/local/mysql/bin/mysqld(handle_one_connection+0x29[0x81ccc14]
/lib/libpthread.so.0[0xb7f9034b]
/lib/libc.so.6(__clone+0x5e)[0xb7eba65e]
======= Memory map: ========
08048000-08556000 r-xp 00000000 08:02 182519     /usr/local/mysql/bin/mysqld
08556000-086a9000 rw-p 0050d000 08:02 182519     /usr/local/mysql/bin/mysqld
086a9000-08cd6000 rw-p 086a9000 00:00 0          [heap]
9a33a000-9a33b000 rw-p 9ad5d000 00:00 0
9a400000-9a424000 rw-p 9a400000 00:00 0
9a424000-9a500000 ---p 9a424000 00:00 0
9a615000-9a616000 ---p 9a615000 00:00 0
9a616000-9a646000 rw-p 9a616000 00:00 0
9a646000-9a647000 ---p 9a646000 00:00 0
9a647000-9a677000 rw-p 9a647000 00:00 0
9a677000-9a678000 ---p 9a677000 00:00 0
9a678000-9a6a8000 rw-p 9a678000 00:00 0
9a6a8000-9a6a9000 ---p 9a6a8000 00:00 0
9a6a9000-9a6d9000 rw-p 9a6a9000 00:00 0
9a6d9000-9a6da000 ---p 9a6d9000 00:00 0
9a6da000-9a70a000 rw-p 9a6da000 00:00 0
9a70a000-9a70b000 ---p 9a70a000 00:00 0
9a70b000-9a73b000 rw-p 9a70b000 00:00 0
9a73b000-9a73c000 ---p 9a73b000 00:00 0
9a73c000-9a76c000 rw-p 9a73c000 00:00 0
9a76c000-9a76d000 ---p 9a76c000 00:00 0
9a76d000-9a79d000 rw-p 9a76d000 00:00 0
9a79d000-9a79e000 ---p 9a79d000 00:00 0
9a79e000-9a7ce000 rw-p 9a79e000 00:00 0
9a7ce000-9a7cf000 ---p 9a7ce000 00:00 0
9a7cf000-9a7ff000 rw-p 9a7cf000 00:00 0
9a81a000-9a81b000 ---p 9a81a000 00:00 0
9a81b000-9a84b000 rw-p 9a81b000 00:00 0
9a84b000-9a84c000 ---p 9a84b000 00:00 0
9a84c000-9a87c000 rw-p 9a84c000 00:00 0
9a87c000-9a87d000 ---p 9a87c000 00:00 0
9a87d000-9a8ad000 rw-p 9a87d000 00:00 0
9a8ad000-9a8ae000 ---p 9a8ad000 00:00 0
9a8ae000-9a8de000 rw-p 9a8ae000 00:00 0
9a8de000-9a8df000 ---p 9a8de000 00:00 0
9a8df000-9a90f000 rw-p 9a8df000 00:00 0
9a90f000-9a910000 ---p 9a90f000 00:00 0
9a910000-9a940000 rw-p 9a910000 00:00 0
9a940000-9a941000 ---p 9a940000 00:00 0
9a941000-9a971000 rw-p 9a941000 00:00 0
9a971000-9a972000 ---p 9a971000 00:00 0
9a972000-9a9a2000 rw-p 9a972000 00:00 0
9a9a2000-9a9a3000 ---p 9a9a2000 00:00 0
9a9a3000-9a9d3000 rw-p 9a9a3000 00:00 0
9a9d3000-9a9d4000 ---p 9a9d3000 00:00 0
9a9d4000-9aa04000 rw-p 9a9d4000 00:00 0
9aa04000-9aa05000 ---p 9aa04000 00:00 0
9aa05000-9aa35000 rw-p 9aa05000 00:00 0
9aa35000-9aa36000 ---p 9aa35000 00:00 0
9aa36000-9aa66000 rw-p 9aa36000 00:00 0
9aa78000-9aa79000 ---p 9aa78000 00:00 0
9aa79000-9aaa9000 rw-p 9aa79000 00:00 0
9aaa9000-9aaaa000 ---p 9aaa9000 00:00 0
9aaaa000-9aada000 rw-p 9aaaa000 00:00 0
9aada000-9aadb000 ---p 9aada000 00:00 0
9aadb000-9ab0b000 rw-p 9aadb000 00:00 0
9ab0b000-9ab0c000 ---p 9ab0b000 00:00 0
9ab0c000-9ab3c000 rw-p 9ab0c000 00:00 0
9ab3c000-9ab3d000 ---p 9ab3c000 00:00 0
9ab3d000-9ab6d000 rw-p 9ab3d000 00:00 0
9ab6d000-9ab6e000 ---p 9ab6d000 00:00 0
9ab6e000-9ab9e000 rw-p 9ab6e000 00:00 0
9ab9e000-9ab9f000 ---p 9ab9e000 00:00 0
9ab9f000-9abcf000 rw-p 9ab9f000 00:00 0
9abcf000-9abd0000 ---p 9abcf000 00:00 0
9abd0000-9acea000 rw-p 9abd0000 00:00 0
9acea000-9ad00000 ---p 9acea000 00:00 0
9ad2c000-9ad2d000 ---p 9ad2c000 00:00 0
9ad2d000-9ad5d000 rw-p 9ad2d000 00:00 0
9ad64000-9ad69000 rw-p b5011000 00:00 0
9ad8e000-9ad8f000 ---p 9ad8e000 00:00 0
9ad8f000-9adbf000 rw-p 9ad8f000 00:00 0
9adbf000-9adc0000 ---p 9adbf000 00:00 0
9adc0000-b2df1000 rw-p 9adc0000 00:00 0
b2df1000-b2df2000 ---p b2df1000 00:00 0
b2df2000-b35f2000 rw-p b2df2000 00:00 0
b35f2000-b35f3000 ---p b35f2000 00:00 0
b35f3000-b3df3000 rw-p b35f3000 00:00 0
b3df3000-b3df4000 ---p b3df3000 00:00 0
b3df4000-b45f4000 rw-p b3df4000 00:00 0
b45f4000-b45f5000 ---p b45f4000 00:00 0
b45f5000-b4ffb000 rw-p b45f5000 00:00 0
b5007000-b5008000 rw-p b5007000 00:00 0
b5038000-b5039000 ---p b5038000 00:00 0
b5039000-b5069000 rw-p b5039000 00:00 0
b5069000-b506a000 ---p b5069000 00:00 0
b506a000-b509a000 rw-p b506a000 00:00 0
b509a000-b509b000 ---p b509a000 00:00 0
b509b000-b50cb000 rw-p b509b000 00:00 0
b50cb000-b50cc000 ---p b50cb000 00:00 0
b50cc000-b50fc000 rw-p b50cc000 00:00 0
b50fc000-b50fd000 ---p b50fc000 00:00 0
b50fd000-b512d000 rw-p b50fd000 00:00 0
b512d000-b512e000 ---p b512d000 00:00 0
b512e000-b515e000 rw-p b512e000 00:00 0
b515e000-b515f000 ---p b515e000 00:00 0
b515f000-b518f000 rw-p b515f000 00:00 0
b518f000-b5190000 ---p b518f000 00:00 0
b5190000-b51c0000 rw-p b5190000 00:00 0
b51c0000-b51c1000 ---p b51c0000 00:00 0
b51c1000-b51f1000 rw-p b51c1000 00:00 0
b51f1000-b51f2000 ---p b51f1000 00:00 0
b5223000-b5253000 rw-p b5223000 00:00 0
b5253000-b5254000 ---p b5253000 00:00 0
b5254000-b5284000 rw-p b5254000 00:00 0
b5284000-b5285000 ---p b5284000 00:00 0
b5285000-b5a85000 rw-p b5285000 00:00 0
b5a85000-b5a86000 ---p b5a85000 00:00 0
b5a86000-b6286000 rw-p b5a86000 00:00 0
b6286000-b6287000 ---p b6286000 00:00 0
b6287000-b7586000 rw-p b6287000 00:00 0
b7586000-b75bb000 r--s 00000000 08:02 189355     /var/run/nscd/group
b75bb000-b75f0000 r--s 00000000 08:02 189301     /var/run/nscd/passwd
b75f0000-b75fa000 r-xp 00000000 08:02 18011      /lib/libgcc_s.so.1
b75fa000-b75fb000 rw-p 00009000 08:02 18011      /lib/libgcc_s.so.1
b75fb000-b75fc000 ---p b75fb000 00:00 0
b75fc000-b7dfd000 rw-p b75fc000 00:00 0
b7dfd000-b7f16000 r-xp 00000000 08:02 14138      /lib/libc-2.4.so
b7f16000-b7f18000 r--p 00118000 08:02 14138      /lib/libc-2.4.so
b7f18000-b7f1a000 rw-p 0011a000 08:02 14138      /lib/libc-2.4.so
b7f1a000-b7f1d000 rw-p b7f1a000 00:00 0
b7f1d000-b7f40000 r-xp 00000000 08:02 14146      /lib/libm-2.4.so
b7f40000-b7f42000 rw-p 00022000 08:02 14146      /lib/libm-2.4.so
b7f42000-b7f53000 r-xp 00000000 08:02 14149      /lib/libnsl-2.4.so
b7f53000-b7f55000 rw-p 00010000 08:02 14149      /lib/libnsl-2.4.so
b7f55000-b7f58000 rw-p b7f55000 00:00 0
b7f58000-b7f61000 r-xp 00000000 08:02 14142      /lib/libcrypt-2.4.so
b7f61000-b7f64000 rw-p 00008000 08:02 14142      /lib/libcrypt-2.4.so
b7f64000-b7f8b000 rw-p b7f64000 00:00 0
b7f8b000-b7f9b000 r-xp 00000000 08:02 14164      /lib/libpthread-2.4.so
b7f9b000-b7f9d000 rw-p 0000f000 08:02 14164      /lib/libpthread-2.4.so
b7f9d000-b7f9f000 rw-p b7f9d000 00:00 0
b7f9f000-b7fa1000 r-xp 00000000 08:02 14144      /lib/libdl-2.4.so
b7fa1000-b7fa3000 rw-p 00001000 08:02 14144      /lib/libdl-2.4.so
b7fa3000-b7faa000 r-xp 00000000 08:02 14168      /lib/librt-2.4.so
b7faa000-b7fac000 rw-p 00006000 08:02 14168      /lib/librt-2.4.so
b7fbd000-b7fc2000 rw-p b7fbd000 00:00 0
b7fc2000-b7fdc000 r-xp 00000000 08:02 14131      /lib/ld-2.4.so
b7fdc000-b7fde000 rw-p 00019000 08:02 14131      /lib/ld-2.4.so
bf821000-bf836000 rw-p bf821000 00:00 0          [stack]
ffffe000-fffff000 ---p 00000000 00:00 0          [vdso]
120211 14:15:02 - mysqld got signal 6;
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=402653184
read_buffer_size=4190208
max_used_connections=44
max_connections=2000
threads_connected=34
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 4186288 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x8c18570
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=0x9a848938, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81b9a61
0xffffe410
0xb7e26ea3
0xb7e5af8b
0xb7e60911
0xb7e61f84
0x8260b5f
0x820d272
0x81ffcfb
0x8200b2b
0x81fbf44
0x81cf0de
0x81d5a43
0x81cda9e
0x81cd59c
0x81ccc14
0xb7f9034b
0xb7eba65e
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 0x8c82d28 = SELECT EMAIL_ID from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='zhangxianfeng'  and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by SEND_TIME,TO_ID2 order by SEND_TIME desc limit 1,3
thd->thread_id=891
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.
120211 14:22:03 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

xinxin415415

Number of processes running now: 0
120211 14:22:23  mysqld restarted
120211 14:22:23  InnoDB: Started; log sequence number 0 43665
120211 14:22:23 [Note] Recovering after a crash using mysql-bin
120211 14:22:23 [Note] Starting crash recovery...
120211 14:22:23 [Note] Crash recovery finished.
120211 14:22:23 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/tmp/mysql.sock'  port: 3336  MySQL Community Server (GPL)
A mysqld process already exists at  Sat Feb 11 14:22:28 CST 2012
*** glibc detected *** /usr/local/mysql/bin/mysqld: double free or corruption (!prev): 0x08b83e90 ***
======= Backtrace: =========
/lib/libc.so.6[0xb7e0e911]
/lib/libc.so.6(__libc_free+0x84)[0xb7e0ff84]
/usr/local/mysql/bin/mysqld(_Z8filesortP3THDP8st_tableP13st_sort_fieldjP10SQL_SELECTyPy+0x37f)[0x8260b5f]
/usr/local/mysql/bin/mysqld[0x820d272]
/usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x104f)[0x81ffcfb]
/usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1d3)[0x8200b2b]
/usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x124)[0x81fbf44]
/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2a6)[0x81cf0de]
/usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0xe7)[0x81d5a43]
/usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x4c6)[0x81cda9e]
/usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x90)[0x81cd59c]
/usr/local/mysql/bin/mysqld(handle_one_connection+0x29[0x81ccc14]
/lib/libpthread.so.0[0xb7f3e34b]
/lib/libc.so.6(__clone+0x5e)[0xb7e6865e]
======= Memory map: ========
08048000-08556000 r-xp 00000000 08:02 182519     /usr/local/mysql/bin/mysqld
08556000-086a9000 rw-p 0050d000 08:02 182519     /usr/local/mysql/bin/mysqld
086a9000-08c60000 rw-p 086a9000 00:00 0          [heap]
9a356000-9a357000 ---p 9a356000 00:00 0
9a357000-9a387000 rw-p 9a357000 00:00 0
9a4de000-9a631000 rw-p 9a4de000 00:00 0
9a631000-9a632000 ---p 9a631000 00:00 0
9a632000-9a662000 rw-p 9a632000 00:00 0
9a662000-9a663000 ---p 9a662000 00:00 0
9a663000-9a693000 rw-p 9a663000 00:00 0
9a693000-9a694000 ---p 9a693000 00:00 0
9a694000-9a6c4000 rw-p 9a694000 00:00 0
9a6c4000-9a6c5000 ---p 9a6c4000 00:00 0
9a6c5000-9a6f5000 rw-p 9a6c5000 00:00 0
9a6f5000-9a6f6000 ---p 9a6f5000 00:00 0
9a6f6000-9a726000 rw-p 9a6f6000 00:00 0
9a726000-9a727000 ---p 9a726000 00:00 0
9a727000-9a757000 rw-p 9a727000 00:00 0
9a757000-9a758000 ---p 9a757000 00:00 0
9a758000-9a789000 rw-p 9a758000 00:00 0
9a7b9000-9a7ba000 ---p 9a7b9000 00:00 0
9a7ba000-9a7ea000 rw-p 9a7ba000 00:00 0
9a7f3000-9a817000 rw-p 9a7f3000 00:00 0
9a817000-9a818000 ---p 9a817000 00:00 0
9a818000-9a848000 rw-p 9a818000 00:00 0
9a848000-9a849000 ---p 9a848000 00:00 0
9a849000-9a879000 rw-p 9a849000 00:00 0
9a879000-9a87a000 ---p 9a879000 00:00 0
9a87a000-9a8aa000 rw-p 9a87a000 00:00 0
9a8aa000-9a8ab000 ---p 9a8aa000 00:00 0
9a8ab000-9a8db000 rw-p 9a8ab000 00:00 0
9a8db000-9a8dc000 ---p 9a8db000 00:00 0
9a8dc000-9a90c000 rw-p 9a8dc000 00:00 0
9a90c000-9a90d000 ---p 9a90c000 00:00 0
9a90d000-9a93d000 rw-p 9a90d000 00:00 0
9a93d000-9a93e000 ---p 9a93d000 00:00 0
9a93e000-9a96e000 rw-p 9a93e000 00:00 0
9a96e000-9a96f000 ---p 9a96e000 00:00 0
9a96f000-9a99f000 rw-p 9a96f000 00:00 0
9a99f000-9a9a0000 ---p 9a99f000 00:00 0
9a9a0000-9a9d0000 rw-p 9a9a0000 00:00 0
9a9d0000-9a9d1000 ---p 9a9d0000 00:00 0
9a9d1000-9aa01000 rw-p 9a9d1000 00:00 0
9aa01000-9aa02000 ---p 9aa01000 00:00 0
9aa02000-9aa32000 rw-p 9aa02000 00:00 0
9aa32000-9aa33000 ---p 9aa32000 00:00 0
9aa33000-9aa63000 rw-p 9aa33000 00:00 0
9aa63000-9aa64000 ---p 9aa63000 00:00 0
9aa64000-9aa94000 rw-p 9aa64000 00:00 0
9aa94000-9aa95000 ---p 9aa94000 00:00 0
9aa95000-9aac5000 rw-p 9aa95000 00:00 0
9aac5000-9aac6000 ---p 9aac5000 00:00 0
9aac6000-9aaf6000 rw-p 9aac6000 00:00 0
9aaf6000-9aaf7000 ---p 9aaf6000 00:00 0
9aaf7000-9ab27000 rw-p 9aaf7000 00:00 0
9ab27000-9ab28000 ---p 9ab27000 00:00 0
9ab28000-9ab58000 rw-p 9ab28000 00:00 0
9ab58000-9ab59000 ---p 9ab58000 00:00 0
9ab59000-9ab89000 rw-p 9ab59000 00:00 0
9ab89000-9ab8a000 ---p 9ab89000 00:00 0
9ab8a000-9abba000 rw-p 9ab8a000 00:00 0
9abba000-9abbb000 ---p 9abba000 00:00 0
9abbb000-9abeb000 rw-p 9abbb000 00:00 0
9abeb000-9abec000 ---p 9abeb000 00:00 0
9abec000-9ac1c000 rw-p 9abec000 00:00 0
9ac1c000-9ac1d000 ---p 9ac1c000 00:00 0
9ac1d000-9ac4d000 rw-p 9ac1d000 00:00 0
9ac54000-9ac78000 rw-p 9ac54000 00:00 0
9ac78000-9ac79000 ---p 9ac78000 00:00 0
9ac79000-9aca9000 rw-p 9ac79000 00:00 0
9aca9000-9acaa000 ---p 9aca9000 00:00 0
9acaa000-9acda000 rw-p 9acaa000 00:00 0
9acda000-9acdb000 ---p 9acda000 00:00 0
9acdb000-9ad0b000 rw-p 9acdb000 00:00 0
9ad0b000-9ad0c000 ---p 9ad0b000 00:00 0
9ad0c000-9ad3c000 rw-p 9ad0c000 00:00 0
9ad3c000-9ad3d000 ---p 9ad3c000 00:00 0
9ad3d000-9ad6d000 rw-p 9ad3d000 00:00 0
9ad6d000-9ad6e000 ---p 9ad6d000 00:00 0
9ad6e000-b2d9f000 rw-p 9ad6e000 00:00 0
b2d9f000-b2da0000 ---p b2d9f000 00:00 0
b2da0000-b35a0000 rw-p b2da0000 00:00 0
b35a0000-b35a1000 ---p b35a0000 00:00 0
b35a1000-b3da1000 rw-p b35a1000 00:00 0
b3da1000-b3da2000 ---p b3da1000 00:00 0
b3da2000-b45a2000 rw-p b3da2000 00:00 0
b45a2000-b45a3000 ---p b45a2000 00:00 0
b45a3000-b4fa9000 rw-p b45a3000 00:00 0
b4fa9000-b4faa000 ---p b4fa9000 00:00 0
b4faa000-b4fda000 rw-p b4faa000 00:00 0
b4fda000-b4fdb000 ---p b4fda000 00:00 0
b4fdb000-b500b000 rw-p b4fdb000 00:00 0
b500b000-b500c000 ---p b500b000 00:00 0
b500c000-b503c000 rw-p b500c000 00:00 0
b503c000-b503d000 ---p b503c000 00:00 0
b503d000-b506d000 rw-p b503d000 00:00 0
b506d000-b506e000 ---p b506d000 00:00 0
b506e000-b509e000 rw-p b506e000 00:00 0
b509e000-b509f000 ---p b509e000 00:00 0
b509f000-b50cf000 rw-p b509f000 00:00 0
b50cf000-b50d0000 ---p b50cf000 00:00 0
b50d0000-b51e3000 rw-p b50d0000 00:00 0
b51e3000-b5200000 ---p b51e3000 00:00 0
b5201000-b5202000 ---p b5201000 00:00 0
b5202000-b5232000 rw-p b5202000 00:00 0
b5232000-b5233000 ---p b5232000 00:00 0
b5233000-b5a33000 rw-p b5233000 00:00 0
b5a33000-b5a34000 ---p b5a33000 00:00 0
b5a34000-b6234000 rw-p b5a34000 00:00 0
b6234000-b6235000 ---p b6234000 00:00 0
b6235000-b7534000 rw-p b6235000 00:00 0
b7534000-b7569000 r--s 00000000 08:02 189355     /var/run/nscd/group
b7569000-b759e000 r--s 00000000 08:02 189301     /var/run/nscd/passwd
b759e000-b75a8000 r-xp 00000000 08:02 18011      /lib/libgcc_s.so.1
b75a8000-b75a9000 rw-p 00009000 08:02 18011      /lib/libgcc_s.so.1
b75a9000-b75aa000 ---p b75a9000 00:00 0
b75aa000-b7dab000 rw-p b75aa000 00:00 0
b7dab000-b7ec4000 r-xp 00000000 08:02 14138      /lib/libc-2.4.so
b7ec4000-b7ec6000 r--p 00118000 08:02 14138      /lib/libc-2.4.so
b7ec6000-b7ec8000 rw-p 0011a000 08:02 14138      /lib/libc-2.4.so
b7ec8000-b7ecb000 rw-p b7ec8000 00:00 0
b7ecb000-b7eee000 r-xp 00000000 08:02 14146      /lib/libm-2.4.so
b7eee000-b7ef0000 rw-p 00022000 08:02 14146      /lib/libm-2.4.so
b7ef0000-b7f01000 r-xp 00000000 08:02 14149      /lib/libnsl-2.4.so
b7f01000-b7f03000 rw-p 00010000 08:02 14149      /lib/libnsl-2.4.so
b7f03000-b7f06000 rw-p b7f03000 00:00 0
b7f06000-b7f0f000 r-xp 00000000 08:02 14142      /lib/libcrypt-2.4.so
b7f0f000-b7f12000 rw-p 00008000 08:02 14142      /lib/libcrypt-2.4.so
b7f12000-b7f39000 rw-p b7f12000 00:00 0
b7f39000-b7f49000 r-xp 00000000 08:02 14164      /lib/libpthread-2.4.so
b7f49000-b7f4b000 rw-p 0000f000 08:02 14164      /lib/libpthread-2.4.so
b7f4b000-b7f4d000 rw-p b7f4b000 00:00 0
b7f4d000-b7f4f000 r-xp 00000000 08:02 14144      /lib/libdl-2.4.so
b7f4f000-b7f51000 rw-p 00001000 08:02 14144      /lib/libdl-2.4.so
b7f51000-b7f58000 r-xp 00000000 08:02 14168      /lib/librt-2.4.so
b7f58000-b7f5a000 rw-p 00006000 08:02 14168      /lib/librt-2.4.so
b7f6b000-b7f70000 rw-p b7f6b000 00:00 0
b7f70000-b7f8a000 r-xp 00000000 08:02 14131      /lib/ld-2.4.so
b7f8a000-b7f8c000 rw-p 00019000 08:02 14131      /lib/ld-2.4.so
bfeca000-bfedf000 rw-p bfeca000 00:00 0          [stack]
ffffe000-fffff000 ---p 00000000 00:00 0          [vdso]
120211 14:25:24 - mysqld got signal 6;
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=402653184
read_buffer_size=4190208
max_used_connections=44
max_connections=2000
threads_connected=23
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 4186288 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0xb51543c8
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=0xb4fd7938, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81b9a61
0xffffe410
0xb7dd4ea3
0xb7e08f8b
0xb7e0e911
0xb7e0ff84
0x8260b5f
0x820d272
0x81ffcfb
0x8200b2b
0x81fbf44
0x81cf0de
0x81d5a43
0x81cda9e
0x81cd59c
0x81ccc14
0xb7f3e34b
0xb7e6865e
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 0x8b27220 = SELECT EMAIL_ID from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='zhangxianfeng'  and SEND_FLAG='1' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by SEND_TIME,TO_ID2 order by SEND_TIME desc limit 1,3
thd->thread_id=30
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
120211 14:27:47  mysqld restarted
120211 14:27:47  InnoDB: Started; log sequence number 0 43665
120211 14:27:47 [Note] Recovering after a crash using mysql-bin
120211 14:27:47 [Note] Starting crash recovery...
120211 14:27:47 [Note] Crash recovery finished.
120211 14:27:47 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.45-log'  socket: '/tmp/mysql.sock'  port: 3336  MySQL Community Server (GPL)
A mysqld process already exists at  Sat Feb 11 14:27:51 CST 2012

ruochen

这种信息基本没什么用处的

新部署的mysql？ 还是使用过程中出现crash？
建议第一先检查内存方面的配置参数是否合理