Hi Yectli, In mysql configuration file (my.cnf) you have given
key_buffer_size = 5G For 32bit OS it should be less than or equal to 4GB and for 64bit it can be greater than 4GB. Reduce the key_buffer_size to 3GB and try. _Kirshna On Fri, Aug 13, 2010 at 3:02 AM, Yectli Huerta <yhue...@msi.umn.edu> wrote: > 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.htmlcontains > 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=prajapat...@gmail.com > >
