*** glibc detected *** /opt/mysql-5.1.30/libexec/mysqld: double free or corruption (out): 0x00002aab10da90e0 *** ======= Backtrace: ========= /lib/libc.so.6[0x2b135cb87f0d] /lib/libc.so.6(cfree+0x76)[0x2b135cb89c06] /opt/mysql-5.1.30/libexec/mysqld[0x58df05] /opt/mysql-5.1.30/libexec/mysqld(_ZN22Item_func_set_user_var6updateEv+0x91)[0x595b71] /opt/mysql-5.1.30/libexec/mysqld(_ZN12set_var_user6updateEP3THD+0xd)[0x63284d] /opt/mysql-5.1.30/libexec/mysqld(_Z17sql_set_variablesP3THDP4ListI12set_var_baseE+0x7d)[0x63b46d] /opt/mysql-5.1.30/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x362e)[0x62b08e] /opt/mysql-5.1.30/libexec/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1c)[0x76a7ac] /opt/mysql-5.1.30/libexec/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0xf7)[0x76d1d7] /opt/mysql-5.1.30/libexec/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x589)[0x76f5a9] /opt/mysql-5.1.30/libexec/mysqld(_ZN7sp_head7executeEP3THD+0x441)[0x76e041] /opt/mysql-5.1.30/libexec/mysqld(_ZN7sp_head15execute_triggerEP3THDPK19st_mysql_lex_stringS4_P13st_grant_info+0x1b7)[0x76e527] /opt/mysql-5.1.30/libexec/mysqld(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0xe2)[0x778f82] /opt/mysql-5.1.30/libexec/mysqld(_Z36fill_record_n_invoke_before_triggersP3THDR4ListI4ItemES4_bP19Table_triggers_list14trg_event_type+0x137)[0x664267] /opt/mysql-5.1.30/libexec/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x890)[0x6a2430] /opt/mysql-5.1.30/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x1eab)[0x62990b] /opt/mysql-5.1.30/libexec/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x227)[0x62f5b7] /opt/mysql-5.1.30/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x3f0)[0x62f9b0] /opt/mysql-5.1.30/libexec/mysqld(_Z10do_commandP3THD+0xe4)[0x6309c4] /opt/mysql-5.1.30/libexec/mysqld(handle_one_connection+0x663)[0x621793] /lib/libpthread.so.0[0x2b135b3450a7] /lib/libc.so.6(clone+0x6d)[0x2b135cbdcdbd] /lib/libc.so.6(clone+0x6d)[0x2b135cbdcdbd] /lib/libc.so.6(clone+0x6d)[0x2b135cbdcdbd] .... ======= Memory map: ======== 00400000-00bf8000 r-xp 00000000 08:01 2180630513 /opt/mysql-5.1.30/libexec/mysqld 00df8000-00e07000 r--p 007f8000 08:01 2180630513 /opt/mysql-5.1.30/libexec/mysqld 00e07000-00e7a000 rw-p 00807000 08:01 2180630513 /opt/mysql-5.1.30/libexec/mysqld 00e7a000-08fb5000 rw-p 00e7a000 00:00 0 [heap] 40000000-40001000 ---p 40000000 00:00 0 40001000-40801000 rwxp 40001000 00:00 0 40801000-40802000 ---p 40801000 00:00 0 40802000-41002000 rwxp 40802000 00:00 0 41002000-41003000 ---p 41002000 00:00 0 41003000-41803000 rwxp 41003000 00:00 0 41803000-41804000 ---p 41803000 00:00 0 41804000-42004000 rwxp 41804000 00:00 0 42004000-42005000 ---p 42004000 00:00 0 42005000-42805000 rwxp 42005000 00:00 0 42805000-42806000 ---p 42805000 00:00 0 42806000-43006000 rwxp 42806000 00:00 0 43006000-43007000 ---p 43006000 00:00 0 43007000-43807000 rwxp 43007000 00:00 0 43807000-43808000 ---p 43807000 00:00 0 43808000-44008000 rwxp 43808000 00:00 0 44008000-44009000 ---p 44008000 00:00 0 44009000-44049000 rwxp 44009000 00:00 0 44049000-4404a000 ---p 44049000 00:00 0 4404a000-4408a000 rwxp 4404a000 00:00 0 4408a000-4408b000 ---p 4408a000 00:00 0 4408b000-440cb000 rwxp 4408b000 00:00 0 440cb000-440cc000 ---p 440cb000 00:00 0 440cc000-4410c000 rwxp 440cc000 00:00 0 4410c000-4410d000 ---p 4410c000 00:00 0 4410d000-4414d000 rwxp 4410d000 00:00 0 4414d000-4414e000 ---p 4414d000 00:00 0 4414e000-4418e000 rwxp 4414e000 00:00 0 4418e000-4418f000 ---p 4418e000 00:00 0 4418f000-441cf000 rwxp 4418f000 00:00 0 441cf000-441d0000 ---p 441cf000 00:00 0 441d0000-44210000 rwxp 441d0000 00:00 0 44210000-44211000 ---p 44210000 00:00 0 44211000-44251000 rwxp 44211000 00:00 0 44251000-44252000 ---p 44251000 00:00 0 44252000-44292000 rwxp 44252000 00:00 0 44292000-44293000 ---p 44292000 00:00 0 44293000-442d3000 rwxp 44293000 00:00 0 442d3000-442d4000 ---p 442d3000 00:00 0 442d4000-44314000 rwxp 442d4000 00:00 0 44314000-44315000 ---p 44314000 00:00 0 44315000-44355000 rwxp 44315000 00:00 0 44355000-44356000 ---p 44355000 00:00 0 44356000-44396000 rwxp 44356000 00:00 0 44396000-44397000 ---p 44396000 00:00 0 44397000-443d7000 rwxp 44397000 00:00 0 443d7000-443d8000 ---p 443d7000 00:00 0 443d8000-44418000 rwxp 443d8000 00:00 0 44418000-44419000 ---p 44418000 00:00 0 44419000-44459000 rwxp 44419000 00:00 0 44459000-4445a000 ---p 44459000 00:00 0 4445a000-4449a000 rwxp 4445a000 00:00 0 4449a000-4449b000 ---p 4449a000 00:00 0 4449b000-444db000 rwxp 4449b000 00:00 0 444db000-444dc000 ---p 444db000 00:00 0 444dc000-4451c000 rwxp 444dc000 00:00 0 4451c000-4451d000 ---p 4451c000 00:00 0 4451d000-4455d000 rwxp 4451d000 00:00 0 4455d000-4455e000 ---p 4455d000 00:00 0 4455e000-4459e000 rwxp 4455e000 00:00 0 4459e000-4459f000 ---p 4459e000 00:00 0 4459f000-445df000 rwxp 4459f000 00:00 0 445df000-445e0000 ---p 445df000 00:00 0 445e0000-44620000 rwxp 445e0000 00:00 0 44620000-44621000 ---p 44620000 00:00 0 44621000-44661000 rwxp 44621000 00:00 0 44661000-44662000 ---p 44661000 00:00 0 44662000-446a2000 rwxp 44662000 00:00 0 446a2000-446a3000 ---p 446a2000 00:00 0 446a3000-446e3000 rwxp 446a3000 00:00 0 446e3000-446e4000 ---p 446e3000 00:00 0 446e4000-44724000 rwxp 446e4000 00:00 0 44724000-44725000 ---p 44724000 00:00 0 44725000-44765000 rwxp 44725000 00:00 0 44765000-44766000 ---p 44765000 00:00 0 44766000-447a6000 rwxp 44766000 00:00 0 447a6000-447a7000 ---p 447a6000 00:00 0 447a7000-447e7000 rwxp 447a7000 00:00 0 447e7000-447e8000 ---p 447e7000 00:00 0 447e8000-44828000 rwxp 447e8000 00:00 0 44828000-44829000 ---p 44828000 00:00 0 44829000-44869000 rwxp 44829000 00:00 0 2aaaaaaab000-2aaaaaaac000 rw-p 2aaaaaaab000 00:00 0 2aaaaaab3000-2aaaaaaba000 r-xp 00000000 08:01 1073743900 /lib64/libnss_compat-2.7.so 2aaaaaaba000-2aaaaacb9000 ---p 00007000 08:01 1073743900 /lib64/libnss_compat-2.7.so 2aaaaacb9000-2aaaaacba000 r--p 00006000 08:01 1073743900 /lib64/libnss_compat-2.7.so 2aaaaacba000-2aaaaacbb000 rw-p 00007000 08:01 1073743900 /lib64/libnss_compat-2.7.so 2aaaaacc0000-2aaaaacc9000 r-xp 00000000 08:01 1073743901 /lib64/libnss_nis-2.7.so 2aaaaacc9000-2aaaaaec9000 ---p 00009000 08:01 1073743901 /lib64/libnss_nis-2.7.so 2aaaaaec9000-2aaaaaeca000 r--p 00009000 08:01 1073743901 /lib64/libnss_nis-2.7.so 2aaaaaeca000-2aaaaaecb000 rw-p 0000a000 08:01 1073743901 /lib64/libnss_nis-2.7.so 2aaaaaecb000-2aaaaaed5000 r-xp 00000000 08:01 1073744718 /lib64/libnss_files-2.7.so 2aaaaaed5000-2aaaab0d4000 ---p 0000a000 08:01 1073744718 /lib64/libnss_files-2.7.so 2aaaab0d4000-2aaaab0d5000 r--p 00009000 08:01 1073744718 /lib64/libnss_files-2.7.so 2aaaab0d5000-2aaaab0d6000 rw-p 0000a000 08:01 1073744718 /lib64/libnss_files-2.7.so 2aaaab0d6000-2aaafb00f000 rw-p 2aaaab0d6000 00:00 0 2aaafb014000-2aaafb018000 r-xp 00000000 08:01 1073744653 /lib64/libnss_dns-2.7.so 2aaafb018000-2aaafb217000 ---p 00004000 08:01 1073744653 /lib64/libnss_dns-2.7.so 2aaafb217000-2aaafb218000 r--p 00003000 08:01 1073744653 /lib64/libnss_dns-2.7.so 2aaafb218000-2aaafb219000 rw-p 00004000 08:01 1073744653 /lib64/libnss_dns-2.7.so 2aaafb219000-2aaafb229000 r-xp 00000000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb229000-2aaafb429000 ---p 00010000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb429000-2aaafb42a000 r--p 00010000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb42a000-2aaafb42b000 rw-p 00011000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb219000-2aaafb229000 r-xp 00000000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb229000-2aaafb429000 ---p 00010000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb429000-2aaafb42a000 r--p 00010000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb42a000-2aaafb42b000 rw-p 00011000 08:01 1073743895 /lib64/libresolv-2.7.so 2aaafb42b000-2aaafb42d000 rw-p 2aaafb42b000 00:00 0 2aaafb42d000-2aaafb42e000 rw-s 00000000 08:01 12885519 /tmp/#sql31c5_98318_0.MYD 2aab0391c000-2aab03f5c000 rw-p 2aab0391c000 00:00 0 2aab04000000-2aab07fe5000 rw-p 2aab04000000 00:00 0 2aab07fe5000-2aab08000000 ---p 2aab07fe5000 00:00 0 2aab08000000-2aab0bf83000 rw-p 2aab08000000 00:00 0 2aab0bf83000-2aab0c000000 ---p 2aab0bf83000 00:00 0 2aab10000000-2aab13ff4000 rw-p 2aab10000000 00:00 0 2aab13ff4000-2aab14000000 ---p 2aab13ff4000 00:00 0 2aab1c000000-2aab1fff0000 rw-p 2aab1c000000 00:00 0 2aab1fff0000-2aab20000000 ---p 2aab1fff0000 00:00 0 2b135b123000-2b135b13e000 r-xp 00000000 08:01 1073743899 /lib64/ld-2.7.so 2b135b13e000-2b135b13f000 rw-p 2b135b13e000 00:00 0 2b135b144000-2b135b145000 rw-p 2b135b144000 00:00 0 2b135b33d000-2b135b33e000 r--p 0001a000 08:01 1073743899 /lib64/ld-2.7.so 2b135b33e000-2b135b33f000 rw-p 0001b000 08:01 1073743899 /lib64/ld-2.7.so 2b135b33f000-2b135b355000 r-xp 00000000 08:01 1073744647 /lib64/libpthread-2.7.so 2b135b355000-2b135b554000 ---p 00016000 08:01 1073744647 /lib64/libpthread-2.7.so 2b135b554000-2b135b555000 r--p 00015000 08:01 1073744647 /lib64/libpthread-2.7.so 2b135b555000-2b135b556000 rw-p 00016000 08:01 1073744647 /lib64/libpthread-2.7.so 2b135b556000-2b135b55a000 rw-p 2b135b556000 00:00 0 2b135b55a000-2b135b56e000 r-xp 00000000 08:01 1073743879 /lib64/libz.so.1.2.3 2b135b56e000-2b135b76d000 ---p 00014000 08:01 1073743879 /lib64/libz.so.1.2.3 2b135b76d000-2b135b76e000 r--p 00013000 08:01 1073743879 /lib64/libz.so.1.2.3 2b135b76e000-2b135b76f000 rw-p 00014000 08:01 1073743879 /lib64/libz.so.1.2.3 2b135b76f000-2b135b771000 r-xp 00000000 08:01 1073744652 /lib64/libdl-2.7.so 2b135b771000-2b135b971000 ---p 00002000 08:01 1073744652 /lib64/libdl-2.7.so 2b135b971000-2b135b972000 r--p 00002000 08:01 1073744652 /lib64/libdl-2.7.so 2b135b972000-2b135b973000 rw-p 00003000 08:01 1073744652 /lib64/libdl-2.7.so 2b135b973000-2b135b974000 rw-p 2b135b973000 00:00 0 2b135b974000-2b135b9b7000 r-xp 00000000 08:01 3247852835 /usr/lib64/libssl.so.0.9.8 2b135b9b7000-2b135bbb6000 ---p 00043000 08:01 3247852835 /usr/lib64/libssl.so.0.9.8 2b135bbb6000-2b135bbb8000 r--p 00042000 08:01 3247852835 /usr/lib64/libssl.so.0.9.8 2b135bbb8000-2b135bbbd000 rw-p 00044000 08:01 3247852835 /usr/lib64/libssl.so.0.9.8 2b135bbbd000-2b135bd11000 r-xp 00000000 08:01 3247852847 /usr/lib64/libcrypto.so.0.9.8 2b135bd11000-2b135bf11000 ---p 00154000 08:01 3247852847 /usr/lib64/libcrypto.so.0.9.8 2b135bf11000-2b135bf1e000 r--p 00154000 08:01 3247852847 /usr/lib64/libcrypto.so.0.9.8 2b135bf1e000-2b135bf35000 rw-p 00161000 08:01 3247852847 /usr/lib64/libcrypto.so.0.9.8 2b135bf35000-2b135bf38000 rw-p 2b135bf35000 00:00 0 2b135bf38000-2b135bf40000 r-xp 00000000 08:01 1073744739 /lib64/libcrypt-2.7.so 2b135bf40000-2b135c13f000 ---p 00008000 08:01 1073744739 /lib64/libcrypt-2.7.so 2b135c13f000-2b135c140000 r--p 00007000 08:01 1073744739 /lib64/libcrypt-2.7.so 2b135c140000-2b135c141000 rw-p 00008000 08:01 1073744739 /lib64/libcrypt-2.7.so 2b135c141000-2b135c170000 rw-p 2b135c141000 00:00 0 2b135c170000-2b135c184000 r-xp 00000000 08:01 1073744648 /lib64/libnsl-2.7.so 2b135c184000-2b135c383000 ---p 00014000 08:01 1073744648 /lib64/libnsl-2.7.so 2b135c383000-2b135c384000 r--p 00013000 08:01 1073744648 /lib64/libnsl-2.7.so 2b135c384000-2b135c385000 rw-p 00014000 08:01 1073744648 /lib64/libnsl-2.7.so 2b135c385000-2b135c387000 rw-p 2b135c385000 00:00 0 2b135c387000-2b135c46f000 r-xp 00000000 08:01 3248039904 /usr/lib64/gcc/x86_64-pc-linux-gnu/4.1.2/libstdc++.so.6.0.8 2b135c46f000-2b135c66f000 ---p 000e8000 08:01 3248039904 /usr/lib64/gcc/x86_64-pc-linux-gnu/4.1.2/libstdc++.so.6.0.8 2b135c66f000-2b135c676000 r--p 000e8000 08:01 3248039904 /usr/lib64/gcc/x86_64-pc-linux-gnu/4.1.2/libstdc++.so.6.0.8 2b135c676000-2b135c678000 rw-p 000ef000 08:01 3248039904 /usr/lib64/gcc/x86_64-pc-linux-gnu/4.1.2/libstdc++.so.6.0.8 2b135c678000-2b135c68a000 rw-p 2b135c678000 00:00 0 2b135c68a000-2b135c70a000 r-xp 00000000 08:01 1073743894 /lib64/libm-2.7.so 2b135c70a000-2b135c909000 ---p 00080000 08:01 1073743894 /lib64/libm-2.7.so 2b135c909000-2b135c90a000 r--p 0007f000 08:01 1073743894 /lib64/libm-2.7.so 2b135c90a000-2b135c90b000 rw-p 00080000 08:01 1073743894 /lib64/libm-2.7.so 2b135c90b000-2b135c90c000 rw-p 2b135c90b000 00:00 0 2b135c90c000-2b135c919000 r-xp 00000000 08:01 1073743796 /lib64/libgcc_s.so.1 2b135c919000-2b135cb18000 ---p 0000d000 08:01 1073743796 /lib64/libgcc_s.so.1 2b135cb18000-2b135cb19000 r--p 0000c000 08:01 1073743796 /lib64/libgcc_s.so.1 2b135cb19000-2b135cb1a000 rw-p 0000d000 08:01 1073743796 /lib64/libgcc_s.so.1 2b135cb1a000-2b135cc55000 r-xp 00000000 08:01 1073744646 /lib64/libc-2.7.so 2b135cc55000-2b135ce55000 ---p 0013b000 08:01 1073744646 /lib64/libc-2.7.so 2b135ce55000-2b135ce59000 r--p 0013b000 08:01 1073744646 /lib64/libc-2.7.so 2b135ce59000-2b135ce5a000 rw-p 0013f000 08:01 1073744646 /lib64/libc-2.7.so 2b135ce5a000-2b135ce61000 rw-p 2b135ce5a000 00:00 0 7fff4f972000-7fff4f987000 rwxp 7fff4f972000 00:00 0 [stack] ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso] 090218 16:30:22 - 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=33554432 read_buffer_size=33554432 max_used_connections=32 max_threads=50 threads_connected=4 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3310075 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x445db00 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 = 0x4410b0e0 thread_stack 0x40000 /opt/mysql-5.1.30/libexec/mysqld(my_print_stacktrace+0x24) [0x965414] /opt/mysql-5.1.30/libexec/mysqld(handle_segfault+0x320) [0x619850] /lib/libpthread.so.0 [0x2b135b34d5b0] /lib/libc.so.6(gsignal+0x3b) [0x2b135cb4ab6b] /lib/libc.so.6(abort+0x10e) [0x2b135cb4bf1e] /lib/libc.so.6 [0x2b135cb82e86] /lib/libc.so.6 [0x2b135cb87f0d] /lib/libc.so.6(cfree+0x76) [0x2b135cb89c06] /opt/mysql-5.1.30/libexec/mysqld [0x58df05] /opt/mysql-5.1.30/libexec/mysqld(Item_func_set_user_var::update()+0x91) [0x595b71] /opt/mysql-5.1.30/libexec/mysqld(set_var_user::update(THD*)+0xd) [0x63284d] /opt/mysql-5.1.30/libexec/mysqld(sql_set_variables(THD*, List*)+0x7d) [0x63b46d] /opt/mysql-5.1.30/libexec/mysqld(mysql_execute_command(THD*)+0x362e) [0x62b08e] /opt/mysql-5.1.30/libexec/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x1c) [0x76a7ac] /opt/mysql-5.1.30/libexec/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0xf7) [0x76d1d7] /opt/mysql-5.1.30/libexec/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x589) [0x76f5a9] /opt/mysql-5.1.30/libexec/mysqld(sp_head::execute(THD*)+0x441) [0x76e041] /opt/mysql-5.1.30/libexec/mysqld(sp_head::execute_trigger(THD*, st_mysql_lex_string const*, st_mysql_lex_string const*, st_grant_info*)+0x1b7) [0x76e527] /opt/mysql-5.1.30/libexec/mysqld(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool)+0xe2) [0x778f82] /opt/mysql-5.1.30/libexec/mysqld(fill_record_n_invoke_before_triggers(THD*, List&, List&, bool, Table_triggers_list*, trg_event_type)+0x137) [0x664267] /opt/mysql-5.1.30/libexec/mysqld(mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool)+0x890) [0x6a2430] /opt/mysql-5.1.30/libexec/mysqld(mysql_execute_command(THD*)+0x1eab) [0x62990b] /opt/mysql-5.1.30/libexec/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x227) [0x62f5b7] /opt/mysql-5.1.30/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x3f0) [0x62f9b0] /opt/mysql-5.1.30/libexec/mysqld(do_command(THD*)+0xe4) [0x6309c4] /opt/mysql-5.1.30/libexec/mysqld(handle_one_connection+0x663) [0x621793] /lib/libpthread.so.0 [0x2b135b3450a7] /lib/libc.so.6(clone+0x6d) [0x2b135cbdcdbd] /lib/libc.so.6(clone+0x6d) [0x2b135cbdcdbd] /lib/libc.so.6(clone+0x6d) [0x2b135cbdcdbd] ... Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x2aab114cb830 is an invalid pointer thd->thread_id=623384 thd->killed=NOT_KILLED 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.