Hello, I compiled a version of mysql 5.1.49 and it crashed a couple of times already. I recompiled it with debug enabled and this is the error I got. Do any of you guys/gals have any suggestions?
thanks, this is from the trace file: do_select: info: select cond 0xb7e088 do_select: info: select cond 0xb7e088 do_select: info: select cond 0xb7e088 do_select: info: select cond 0xb7e088 do_select: info: select cond 0xb7e088 intern_plugin_unlock: info: unlocking plugin, name= MyISAM, ref_count= 72 ~THD(): info: freeing security context below are the messages from the error log file do_select: info: select cond 0xb7e088 do_select: info: select cond 0x2aabee71ed48 do_select: info: select cond 0xb7e088 do_select: info: select cond 0x2aabee71ed48 do_select: info: select cond 0xb7e088 *** glibc detected *** /opt/mysql/libexec/mysqld: corrupted double-linked list: 0x00002aabf301a720 *** ======= Backtrace: ========= /lib64/libc.so.6[0x2b4fc154e6de] /lib64/libc.so.6[0x2b4fc154f91d] /lib64/libc.so.6(__libc_free+0x6c)[0x2b4fc154fd5c] /opt/mysql/libexec/mysqld(my_no_flags_free+0x7b)[0x78356b] /opt/mysql/libexec/mysqld(_ZN3THDD0Ev+0x3c1)[0x575dc7] /opt/mysql/libexec/mysqld(_Z10unlink_thdP3THD+0xc7)[0x587dc9] /opt/mysql/libexec/mysqld(_Z29one_thread_per_connection_endP3THDb+0x3f)[0x587e27] /opt/mysql/libexec/mysqld(handle_one_connection+0xc31)[0x58d20f] /lib64/libpthread.so.0[0x2b4fc0f6f193] /lib64/libc.so.6(__clone+0x6d)[0x2b4fc15a3dfd] ======= Memory map: ======== 00400000-00944000 r-xp 00000000 fd:00 8440267 /opt/mysql-5.1.49/libexec/mysqld 00a44000-00a96000 rw-p 00544000 fd:00 8440267 /opt/mysql-5.1.49/libexec/mysqld 00a96000-00c6c000 rw-p 00a96000 00:00 0 [heap] 40000000-40001000 ---p 40000000 00:00 0 40001000-40801000 rw-p 40001000 00:00 0 40801000-40802000 ---p 40801000 00:00 0 40802000-40842000 rw-p 40802000 00:00 0 40842000-40843000 ---p 40842000 00:00 0 40843000-40883000 rw-p 40843000 00:00 0 40883000-40884000 ---p 40883000 00:00 0 40884000-408c4000 rw-p 40884000 00:00 0 408c4000-408c5000 ---p 408c4000 00:00 0 408c5000-40905000 rw-p 408c5000 00:00 0 40905000-40906000 ---p 40905000 00:00 0 40906000-40946000 rw-p 40906000 00:00 0 40946000-40947000 ---p 40946000 00:00 0 40947000-40987000 rw-p 40947000 00:00 0 40987000-40988000 ---p 40987000 00:00 0 40988000-409c8000 rw-p 40988000 00:00 0 409c8000-409c9000 ---p 409c8000 00:00 0 409c9000-40a09000 rw-p 409c9000 00:00 0 40a09000-40a0a000 ---p 40a09000 00:00 0 40a0a000-40a4a000 rw-p 40a0a000 00:00 0 2aaaaaaad000-2aaaabe4c000 r--s 00000000 fd:04 62914806 /var/run/nscd/passwd 2aaaabe4c000-2aaaac334000 r--s 00000000 fd:04 62914812 /var/run/nscd/group 2aaaac334000-2aabee331000 rw-p 2aaaac334000 00:00 0 2aabee700000-2aabee7cb000 rw-p 2aabee700000 00:00 0 2aabee7cb000-2aabee800000 ---p 2aabee7cb000 00:00 0 2aabee800000-2aabf0b36000 rw-p 2aabee800000 00:00 0 2aabf1803000-2aabf2804000 rw-p 2aabf1803000 00:00 0 2aabf3000000-2aabf30e6000 rw-p 2aabf3000000 00:00 0 2aabf30e6000-2aabf3100000 ---p 2aabf30e6000 00:00 0 2aabf3100000-2aabf4aa7000 rw-p 2aabf3100000 00:00 0 2b4fc0e4d000-2b4fc0e68000 r-xp 00000000 fd:01 16818349 /lib64/ld-2.4.so 2b4fc0e68000-2b4fc0e6a000 rw-p 2b4fc0e68000 00:00 0 2b4fc0f67000-2b4fc0f69000 rw-p 0001a000 fd:01 16818349 /lib64/ld-2.4.so 2b4fc0f69000-2b4fc0f7d000 r-xp 00000000 fd:01 16818344 /lib64/libpthread-2.4.so 2b4fc0f7d000-2b4fc107c000 ---p 00014000 fd:01 16818344 /lib64/libpthread-2.4.so 2b4fc107c000-2b4fc107e000 rw-p 00013000 fd:01 16818344 /lib64/libpthread-2.4.so 2b4fc107e000-2b4fc1082000 rw-p 2b4fc107e000 00:00 0 2b4fc1082000-2b4fc1165000 r-xp 00000000 fd:03 37804570 /usr/lib64/libstdc++.so.6.0.8 2b4fc1165000-2b4fc1265000 ---p 000e3000 fd:03 37804570 /usr/lib64/libstdc++.so.6.0.8 2b4fc1265000-2b4fc126b000 r--p 000e3000 fd:03 37804570 /usr/lib64/libstdc++.so.6.0.8 2b4fc126b000-2b4fc126e000 rw-p 000e9000 fd:03 37804570 /usr/lib64/libstdc++.so.6.0.8 2b4fc126e000-2b4fc1280000 rw-p 2b4fc126e000 00:00 0 2b4fc1280000-2b4fc128d000 r-xp 00000000 fd:01 16818324 /lib64/libgcc_s.so.1 2b4fc128d000-2b4fc138c000 ---p 0000d000 fd:01 16818324 /lib64/libgcc_s.so.1 2b4fc138c000-2b4fc138d000 rw-p 0000c000 fd:01 16818324 /lib64/libgcc_s.so.1 2b4fc138d000-2b4fc138e000 rw-p 2b4fc138d000 00:00 0 2b4fc138e000-2b4fc13e2000 r-xp 00000000 fd:01 16818414 /lib64/libm-2.4.so 2b4fc13e2000-2b4fc14e1000 ---p 00054000 fd:01 16818414 /lib64/libm-2.4.so 2b4fc14e1000-2b4fc14e3000 rw-p 00053000 fd:01 16818414 /lib64/libm-2.4.so 2b4fc14e3000-2b4fc1619000 r-xp 00000000 fd:01 16818318 /lib64/libc-2.4.so 2b4fc1619000-2b4fc1719000 ---p 00136000 fd:01 16818318 /lib64/libc-2.4.so 2b4fc1719000-2b4fc171c000 r--p 00136000 fd:01 16818318 /lib64/libc-2.4.so 2b4fc171c000-2b4fc171e000 rw-p 00139000 fd:01 16818318 /lib64/libc-2.4.so 2b4fc171e000-2b4fc1723000 rw-p 2b4fc171e000 00:00 0 2b4fc1723000-2b4fc1737000 r-xp 00000000 fd:01 16818407 /lib64/libz.so.1.2.3 2b4fc1737000-2b4fc1836000 ---p 00014000 fd:01 16818407 /lib64/libz.so.1.2.3 2b4fc1836000-2b4fc1837000 rw-p 00013000 fd:01 16818407 /lib64/libz.so.1.2.3 2b4fc1837000-2b4fc1838000 rw-p 2b4fc1837000 00:00 0 2b4fc1838000-2b4fc183a000 r-xp 00000000 fd:01 16818411 /lib64/libdl-2.4.so 2b4fc183a000-2b4fc193a000 ---p 00002000 fd:01 16818411 /lib64/libdl-2.4.so 2b4fc193a000-2b4fc193c000 rw-p 00002000 fd:01 16818411 /lib64/libdl-2.4.so 2b4fc193c000-2b4fc1945000 r-xp 00000000 fd:01 16818362 /lib64/libcrypt-2.4.so 2b4fc1945000-2b4fc1a44000 ---p 00009000 fd:01 16818362 /lib64/libcrypt-2.4.so 2b4fc1a44000-2b4fc1a47000 rw-p 00008000 fd:01 16818362 /lib64/libcrypt-2.4.so 2b4fc1a47000-2b4fc1a75000 rw-p 2b4fc1a47000 00:00 0 2b4fc1a75000-2b4fc1a88000 r-xp 00000000 fd:01 16818417 /lib64/libnsl-2.4.so 2b4fc1a88000-2b4fc1b87000 ---p 00013000 fd:01 16818417 /lib64/libnsl-2.4.so 2b4fc1b87000-2b4fc1b89000 rw-p 00012000 fd:01 16818417 /lib64/libnsl-2.4.so 2b4fc1b89000-2b4fc1b8d000 rw-p 2b4fc1b89000 00:00 0 7fff18d6b000-7fff18d80000 rw-p 7fff18d6b000 00:00 0 [stack] 7fff18dff000-7fff18e00000 r-xp 7fff18dff000 00:00 0 ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vdso] 100812 13:53:59 - 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=5368709120 read_buffer_size=16777216 max_used_connections=8 max_threads=151 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 10192416 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x2aabf3017d90 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... stack_bottom = 0x408c3168 thread_stack 0x40000 /opt/mysql/libexec/mysqld(my_print_stacktrace+0x24) [0x7973c4] /opt/mysql/libexec/mysqld(handle_segfault+0x23e) [0x582810] /lib64/libpthread.so.0 [0x2b4fc0f76d60] /lib64/libc.so.6(gsignal+0x35) [0x2b4fc1512f45] /lib64/libc.so.6(abort+0x110) [0x2b4fc1514340] /lib64/libc.so.6 [0x2b4fc15496eb] /lib64/libc.so.6 [0x2b4fc154e6de] /lib64/libc.so.6 [0x2b4fc154f91d] /lib64/libc.so.6(__libc_free+0x6c) [0x2b4fc154fd5c] /opt/mysql/libexec/mysqld(my_no_flags_free+0x7b) [0x78356b] /opt/mysql/libexec/mysqld(THD::~THD()+0x3c1) [0x575dc7] /opt/mysql/libexec/mysqld(unlink_thd(THD*)+0xc7) [0x587dc9] /opt/mysql/libexec/mysqld(one_thread_per_connection_end(THD*, bool)+0x3f) [0x587e27] /opt/mysql/libexec/mysqld(handle_one_connection+0xc31) [0x58d20f] /lib64/libpthread.so.0 [0x2b4fc0f6f193] /lib64/libc.so.6(__clone+0x6d) [0x2b4fc15a3dfd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is an invalid pointer thd->thread_id=2086 thd->killed=KILL_CONNECTION The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. -- Yectli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
