# 12:43:18 Core was generated by `/home/miguel/dbs/5.1/libexec/mysqld --no-defaults --basedir=/home/miguel/dbs/5.'. # 12:43:18 Program terminated with signal 6, Aborted. # 12:43:18 #0 0x000000334320c61c in pthread_kill () from /lib64/libpthread.so.0 # 12:43:18 # 12:43:18 Thread 21 (Thread 8494): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1925198, mp=0x1925120, file=0xcf1922 "os/os0sync.c", line=422) at thr_mutex.c:237 # 12:43:18 #2 0x00000000009988ed in os_event_wait_low (event=0x1925120, reset_sig_count=0) at os/os0sync.c:422 # 12:43:18 #3 0x00000000009c291b in srv_master_thread (arg=0x0) at srv/srv0srv.c:2736 # 12:43:18 #4 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #5 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 20 (Thread 8516): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xc87be0 "sql_base.cc", line=2727) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x00000000007153a9 in open_table (thd=0x20c0bd8, table_list=0x7f611c005318, mem_root=0x7f6127ffce70, refresh=0x7f6127ffceff, # 12:43:18 flags=0) at sql_base.cc:2727 # 12:43:18 #5 0x00000000007193ee in open_tables (thd=0x20c0bd8, start=0x7f6127ffcf70, counter=0x7f6127ffcfb4, flags=0) at sql_base.cc:4621 # 12:43:18 #6 0x000000000071a1e8 in open_and_lock_tables_derived (thd=0x20c0bd8, tables=0x7f611c005318, derived=true) at sql_base.cc:5039 # 12:43:18 #7 0x00000000006d7922 in open_and_lock_tables (thd=0x20c0bd8, tables=0x7f611c005318) at mysql_priv.h:1522 # 12:43:18 #8 0x00000000006d06cd in execute_sqlcom_select (thd=0x20c0bd8, all_tables=0x7f611c005318) at sql_parse.cc:5073 # 12:43:18 #9 0x00000000006c7a06 in mysql_execute_command (thd=0x20c0bd8) at sql_parse.cc:2292 # 12:43:18 #10 0x00000000006d2d5d in mysql_parse (thd=0x20c0bd8, # 12:43:18 rawbuf=0x7f611c004bc8 "SELECT * FROM (test . `u` AS table1 INNER JOIN mysql . `time_zone_leap_second` AS table2 ON ( table2 . `Correction` = table1 . `pk` ) ) WHERE table2 . `Transition_time` <> table2 . `Transition_time` "..., length=262, # 12:43:18 found_semicolon=0x7f6127ffec40) at sql_parse.cc:6032 # 12:43:18 #11 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20c0bd8, # 12:43:18 packet=0x20c35d9 " SELECT * FROM (test . `u` AS table1 INNER JOIN mysql . `time_zone_leap_second` AS table2 ON ( table2 . `Correction` = table1 . `pk` ) ) WHERE table2 . `Transition_time` <> table2 . `Transition_time`"..., packet_length=264) # 12:43:18 at sql_parse.cc:1260 # 12:43:18 #12 0x00000000006c41ba in do_command (thd=0x20c0bd8) at sql_parse.cc:888 # 12:43:18 #13 0x00000000006c2449 in handle_one_connection (arg=0x20c0bd8) at sql_connect.cc:1136 # 12:43:18 #14 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #15 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 19 (Thread 8518): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xc87be0 "sql_base.cc", line=1194) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x0000000000711b71 in close_open_tables (thd=0x20c7618) at sql_base.cc:1194 # 12:43:18 #5 0x0000000000711fd8 in close_thread_tables (thd=0x20c7618) at sql_base.cc:1357 # 12:43:18 #6 0x000000000071b392 in close_tables_for_reopen (thd=0x20c7618, tables=0x7f613f72dbb8) at sql_base.cc:5541 # 12:43:18 #7 0x0000000000847c94 in get_all_tables (thd=0x20c7618, tables=0x7f61140053f0, cond=0x0) at sql_show.cc:3527 # 12:43:18 #8 0x0000000000853f87 in get_schema_tables_result (join=0x7f611408b2d8, executed_place=PROCESSED_BY_JOIN_EXEC) # 12:43:18 at sql_show.cc:6174 # 12:43:18 #9 0x000000000073832d in JOIN::exec (this=0x7f611408b2d8) at sql_select.cc:1845 # 12:43:18 #10 0x000000000073aa38 in mysql_select (thd=0x20c7618, rref_pointer_array=0x20c9700, tables=0x7f61140053f0, wild_num=1, # 12:43:18 fields=..., conds=0x7f6114006a78, og_num=1, order=0x7f6114012ac0, group=0x0, having=0x0, proc_param=0x0, # 12:43:18 select_options=2684635648, result=0x7f6114013990, unit=0x20c9108, select_lex=0x20c9530) at sql_select.cc:2517 # 12:43:18 #11 0x000000000073264e in handle_select (thd=0x20c7618, lex=0x20c9068, result=0x7f6114013990, setup_tables_done_option=0) # 12:43:18 at sql_select.cc:269 # 12:43:18 #12 0x00000000006d091f in execute_sqlcom_select (thd=0x20c7618, all_tables=0x7f61140053f0) at sql_parse.cc:5108 # 12:43:18 #13 0x00000000006c7a06 in mysql_execute_command (thd=0x20c7618) at sql_parse.cc:2292 # 12:43:18 #14 0x00000000006d2d5d in mysql_parse (thd=0x20c7618, # 12:43:18 rawbuf=0x7f6114004bc8 "SELECT * FROM (INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table1 LEFT OUTER JOIN test . `D` AS table2 ON ( table2 . `col_date_key` = table1 . `TABLE_SCHEMA` ) ) WHERE ( table1 . `CONSTRAINT_CATALOG` "..., length=330, # 12:43:18 found_semicolon=0x7f613f72fc40) at sql_parse.cc:6032 # 12:43:18 #15 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20c7618, # 12:43:18 packet=0x20ca019 " SELECT * FROM (INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table1 LEFT OUTER JOIN test . `D` AS table2 ON ( table2 . `col_date_key` = table1 . `TABLE_SCHEMA` ) ) WHERE ( table1 . `CONSTRAINT_CATALOG`"..., packet_length=331) # 12:43:18 at sql_parse.cc:1260 # 12:43:18 #16 0x00000000006c41ba in do_command (thd=0x20c7618) at sql_parse.cc:888 # 12:43:18 #17 0x00000000006c2449 in handle_one_connection (arg=0x20c7618) at sql_connect.cc:1136 # 12:43:18 #18 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #19 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 18 (Thread 8510): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xc87be0 "sql_base.cc", line=2727) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x00000000007153a9 in open_table (thd=0x20acd18, table_list=0x7f613f7f0cf0, mem_root=0x20af678, refresh=0x7f613f7f0c5e, # 12:43:18 flags=2) at sql_base.cc:2727 # 12:43:18 #5 0x00000000007232a7 in open_system_tables_for_read (thd=0x20acd18, table_list=0x7f613f7f0cf0, backup=0x7f613f7f10d0) # 12:43:18 at sql_base.cc:8993 # 12:43:18 #6 0x00000000008ac9fe in open_proc_table_for_read (thd=0x20acd18, backup=0x7f613f7f10d0) at sp.cc:431 # 12:43:18 #7 0x00000000008ad053 in db_find_routine (thd=0x20acd18, type=2, name=0x7f6128004c78, sphp=0x7f613f7f13a0) at sp.cc:567 # 12:43:18 #8 0x00000000008afbb2 in sp_find_routine (thd=0x20acd18, type=2, name=0x7f6128004c78, cp=0x20ae700, cache_only=false) # 12:43:18 at sp.cc:1484 # 12:43:18 #9 0x00000000008af5dd in sp_show_create_routine (thd=0x20acd18, type=2, name=0x7f6128004c78) at sp.cc:1375 # 12:43:18 #10 0x00000000006cefcc in mysql_execute_command (thd=0x20acd18) at sql_parse.cc:4636 # 12:43:18 #11 0x00000000006d2d5d in mysql_parse (thd=0x20acd18, rawbuf=0x7f6128004bc8 "SHOW CREATE PROCEDURE c", length=23, # 12:43:18 found_semicolon=0x7f613f7f2c40) at sql_parse.cc:6032 # 12:43:18 #12 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20acd18, packet=0x20af719 "SHOW CREATE PROCEDURE c", # 12:43:18 packet_length=23) at sql_parse.cc:1260 # 12:43:18 #13 0x00000000006c41ba in do_command (thd=0x20acd18) at sql_parse.cc:888 # 12:43:18 #14 0x00000000006c2449 in handle_one_connection (arg=0x20acd18) at sql_connect.cc:1136 # 12:43:18 #15 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #16 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 17 (Thread 8514): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1185660, mp=0x1184b60, file=0xc87be0 "sql_base.cc", line=2183) at thr_mutex.c:237 # 12:43:18 #2 0x0000000000714018 in wait_for_condition (thd=0x20ba198, mutex=0x1184b60, cond=0x1185660) at sql_base.cc:2183 # 12:43:18 #3 0x0000000000715636 in open_table (thd=0x20ba198, table_list=0x7f612008ee30, mem_root=0x7f613f76ee70, refresh=0x7f613f76eeff, # 12:43:18 flags=0) at sql_base.cc:2850 # 12:43:18 #4 0x00000000007193ee in open_tables (thd=0x20ba198, start=0x7f613f76ef70, counter=0x7f613f76efb4, flags=0) at sql_base.cc:4621 # 12:43:18 #5 0x000000000071a1e8 in open_and_lock_tables_derived (thd=0x20ba198, tables=0x7f6120005810, derived=true) at sql_base.cc:5039 # 12:43:18 #6 0x00000000006d7922 in open_and_lock_tables (thd=0x20ba198, tables=0x7f6120005810) at mysql_priv.h:1522 # 12:43:18 #7 0x00000000006d06cd in execute_sqlcom_select (thd=0x20ba198, all_tables=0x7f6120005810) at sql_parse.cc:5073 # 12:43:18 #8 0x00000000006c7a06 in mysql_execute_command (thd=0x20ba198) at sql_parse.cc:2292 # 12:43:18 #9 0x00000000006d2d5d in mysql_parse (thd=0x20ba198, # 12:43:18 rawbuf=0x7f6120004bc8 "SELECT * FROM (test . `u` AS table1 INNER JOIN test . `C` AS table2 ON ( table2 . `col_date_key` = table1 . `col_time_nokey` ) ) WHERE ( (NOT ( ( ( (NOT (NOT (NOT ( ( table2 . `pk` > table1 . `col_ti"..., length=897, # 12:43:18 found_semicolon=0x7f613f770c40) at sql_parse.cc:6032 # 12:43:18 #10 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20ba198, # 12:43:18 packet=0x20bcb99 " SELECT * FROM (test . `u` AS table1 INNER JOIN test . `C` AS table2 ON ( table2 . `col_date_key` = table1 . `col_time_nokey` ) ) WHERE ( (NOT ( ( ( (NOT (NOT (NOT ( ( table2 . `pk` > table1 . `col_t"..., packet_length=898) # 12:43:18 at sql_parse.cc:1260 # 12:43:18 #11 0x00000000006c41ba in do_command (thd=0x20ba198) at sql_parse.cc:888 # 12:43:18 #12 0x00000000006c2449 in handle_one_connection (arg=0x20ba198) at sql_connect.cc:1136 # 12:43:18 #13 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #14 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 16 (Thread 8522): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xcb5740 "sql_show.cc", line=3232) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x00000000008470e1 in fill_schema_table_from_frm (thd=0x20d5138, table=0x7f610c05e078, schema_table=0x1075680, # 12:43:18 db_name=0x7f610c09af48, table_name=0x7f610c0f69a8, schema_table_idx=SCH_COLUMNS) at sql_show.cc:3232 # 12:43:18 #5 0x0000000000847a47 in get_all_tables (thd=0x20d5138, tables=0x7f610c005af8, cond=0x7f610c0bb9e0) at sql_show.cc:3464 # 12:43:18 #6 0x0000000000853f87 in get_schema_tables_result (join=0x7f610c0b5cf8, executed_place=PROCESSED_BY_JOIN_EXEC) # 12:43:18 at sql_show.cc:6174 # 12:43:18 #7 0x000000000073832d in JOIN::exec (this=0x7f610c0b5cf8) at sql_select.cc:1845 # 12:43:18 #8 0x000000000073aa38 in mysql_select (thd=0x20d5138, rref_pointer_array=0x20d7220, tables=0x7f610c005740, wild_num=1, # 12:43:18 fields=..., conds=0x7f610c05a388, og_num=2, order=0x7f610c034140, group=0x0, having=0x7f610c033b68, proc_param=0x0, # 12:43:18 select_options=2684635648, result=0x7f610c035fa8, unit=0x20d6c28, select_lex=0x20d7050) at sql_select.cc:2517 # 12:43:18 #9 0x000000000073264e in handle_select (thd=0x20d5138, lex=0x20d6b88, result=0x7f610c035fa8, setup_tables_done_option=0) # 12:43:18 at sql_select.cc:269 # 12:43:18 #10 0x00000000006d091f in execute_sqlcom_select (thd=0x20d5138, all_tables=0x7f610c005740) at sql_parse.cc:5108 # 12:43:18 #11 0x00000000006c7a06 in mysql_execute_command (thd=0x20d5138) at sql_parse.cc:2292 # 12:43:18 #12 0x00000000006d2d5d in mysql_parse (thd=0x20d5138, # 12:43:18 rawbuf=0x7f610c004bc8 "SELECT * FROM (INFORMATION_SCHEMA . `SCHEMATA` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA . `COLUMNS` AS table2 ON ( table2 . `TABLE_NAME` = table1 . `SCHEMA_NAME` ) ) WHERE ( table2 . `PRIVILEGES`"..., length=771, # 12:43:18 found_semicolon=0x7f613f6adc40) at sql_parse.cc:6032 # 12:43:18 #13 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20d5138, # 12:43:18 packet=0x20d81f9 " SELECT * FROM (INFORMATION_SCHEMA . `SCHEMATA` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA . `COLUMNS` AS table2 ON ( table2 . `TABLE_NAME` = table1 . `SCHEMA_NAME` ) ) WHERE ( table2 . `PRIVILEGES"..., packet_length=772) # 12:43:18 at sql_parse.cc:1260 # 12:43:18 #14 0x00000000006c41ba in do_command (thd=0x20d5138) at sql_parse.cc:888 # 12:43:18 #15 0x00000000006c2449 in handle_one_connection (arg=0x20d5138) at sql_connect.cc:1136 # 12:43:18 #16 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #17 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 15 (Thread 8512): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xcb5740 "sql_show.cc", line=3232) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x00000000008470e1 in fill_schema_table_from_frm (thd=0x20b3758, table=0x7f612c0afff8, schema_table=0x1075680, # 12:43:18 db_name=0x7f612c05ff78, table_name=0x7f612c0f1080, schema_table_idx=SCH_COLUMNS) at sql_show.cc:3232 # 12:43:18 #5 0x0000000000847a47 in get_all_tables (thd=0x20b3758, tables=0x7f612c005848, cond=0x7f612c0b94e0) at sql_show.cc:3464 # 12:43:18 #6 0x0000000000853f87 in get_schema_tables_result (join=0x7f612c0b1728, executed_place=PROCESSED_BY_JOIN_EXEC) # 12:43:18 at sql_show.cc:6174 # 12:43:18 #7 0x000000000073832d in JOIN::exec (this=0x7f612c0b1728) at sql_select.cc:1845 # 12:43:18 #8 0x000000000073aa38 in mysql_select (thd=0x20b3758, rref_pointer_array=0x20b5840, tables=0x7f612c005490, wild_num=1, # 12:43:18 fields=..., conds=0x7f612c006558, og_num=0, order=0x0, group=0x0, having=0x7f612c001490, proc_param=0x0, # 12:43:18 select_options=2684635648, result=0x7f612c0aed68, unit=0x20b5248, select_lex=0x20b5670) at sql_select.cc:2517 # 12:43:18 #9 0x000000000073264e in handle_select (thd=0x20b3758, lex=0x20b51a8, result=0x7f612c0aed68, setup_tables_done_option=0) # 12:43:18 at sql_select.cc:269 # 12:43:18 #10 0x00000000006d091f in execute_sqlcom_select (thd=0x20b3758, all_tables=0x7f612c005490) at sql_parse.cc:5108 # 12:43:18 #11 0x00000000006c7a06 in mysql_execute_command (thd=0x20b3758) at sql_parse.cc:2292 # 12:43:18 #12 0x00000000006d2d5d in mysql_parse (thd=0x20b3758, # 12:43:18 rawbuf=0x7f612c004bc8 "SELECT * FROM (INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table1 LEFT JOIN INFORMATION_SCHEMA . `COLUMNS` AS table2 ON ( table2 . `NUMERIC_PRECISION` = table1 . `REFERENCED_TABLE_NAME` ) ) WHERE tab"..., length=410, # 12:43:18 found_semicolon=0x7f613f7b1c40) at sql_parse.cc:6032 # 12:43:18 #13 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20b3758, # 12:43:18 packet=0x20b6159 " SELECT * FROM (INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table1 LEFT JOIN INFORMATION_SCHEMA . `COLUMNS` AS table2 ON ( table2 . `NUMERIC_PRECISION` = table1 . `REFERENCED_TABLE_NAME` ) ) WHERE ta"..., packet_length=412) # 12:43:18 at sql_parse.cc:1260 # 12:43:18 #14 0x00000000006c41ba in do_command (thd=0x20b3758) at sql_parse.cc:888 # 12:43:18 #15 0x00000000006c2449 in handle_one_connection (arg=0x20b3758) at sql_connect.cc:1136 # 12:43:18 #16 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #17 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 14 (Thread 8493): # 12:43:18 #0 0x0000003342eda043 in select () from /lib64/libc.so.6 # 12:43:18 #1 0x000000000099906f in os_thread_sleep (tm=5000000) at os/os0thread.c:281 # 12:43:18 #2 0x00000000009c1868 in srv_monitor_thread (arg=0x0) at srv/srv0srv.c:1950 # 12:43:18 #3 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #4 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 13 (Thread 8492): # 12:43:18 #0 0x0000003342eda043 in select () from /lib64/libc.so.6 # 12:43:18 #1 0x000000000099906f in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 12:43:18 #2 0x00000000009c1f42 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2247 # 12:43:18 #3 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #4 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 12 (Thread 8508): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1185660, mp=0x1184b60, file=0xc87be0 "sql_base.cc", line=2183) at thr_mutex.c:237 # 12:43:18 #2 0x0000000000714018 in wait_for_condition (thd=0x20a62d8, mutex=0x1184b60, cond=0x1185660) at sql_base.cc:2183 # 12:43:18 #3 0x00000000006ae61d in wait_for_locked_table_names (thd=0x20a62d8, table_list=0x7f6134008d70) at lock.cc:1103 # 12:43:18 #4 0x00000000006ae70d in lock_table_names (thd=0x20a62d8, table_list=0x7f6134008d70) at lock.cc:1144 # 12:43:18 #5 0x00000000008b40b1 in mysql_create_or_drop_trigger (thd=0x20a62d8, tables=0x7f6134008d70, create=true) at sql_trigger.cc:465 # 12:43:18 #6 0x00000000006cf3cc in mysql_execute_command (thd=0x20a62d8) at sql_parse.cc:4716 # 12:43:18 #7 0x00000000006d2d5d in mysql_parse (thd=0x20a62d8, # 12:43:18 rawbuf=0x7f6134008b88 "CREATE TRIGGER n BEFORE INSERT ON `CC` FOR EACH ROW BEGIN INSERT INTO `CC` SELECT * FROM `E` LIMIT 0 ; END", length=106, found_semicolon=0x7f6148058c40) at sql_parse.cc:6032 # 12:43:18 #8 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20a62d8, # 12:43:18 packet=0x20a8cd9 "CREATE TRIGGER n BEFORE INSERT ON `CC` FOR EACH ROW BEGIN INSERT INTO `CC` SELECT * FROM `E` LIMIT 0 ; END ;", packet_length=108) at sql_parse.cc:1260 # 12:43:18 #9 0x00000000006c41ba in do_command (thd=0x20a62d8) at sql_parse.cc:888 # 12:43:18 #10 0x00000000006c2449 in handle_one_connection (arg=0x20a62d8) at sql_connect.cc:1136 # 12:43:18 #11 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #12 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 11 (Thread 8491): # 12:43:18 #0 0x0000003342eda043 in select () from /lib64/libc.so.6 # 12:43:18 #1 0x000000000099906f in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 12:43:18 #2 0x00000000009c1bcc in srv_lock_timeout_thread (arg=0x0) at srv/srv0srv.c:2092 # 12:43:18 #3 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #4 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 10 (Thread 8495): # 12:43:18 #0 0x000000334320f1e5 in sigwait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000000006b5c98 in signal_hand (arg=0x0) at mysqld.cc:2808 # 12:43:18 #2 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 9 (Thread 8485): # 12:43:18 #0 0x0000003342eda043 in select () from /lib64/libc.so.6 # 12:43:18 #1 0x00000000006b94fd in handle_connections_sockets (arg=0x0) at mysqld.cc:5103 # 12:43:18 #2 0x00000000006b8836 in main (argc=45, argv=0x7fffd9d478a8) at mysqld.cc:4587 # 12:43:18 # 12:43:18 Thread 8 (Thread 8490): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1fc2b38, mp=0x1fc2ac0, file=0xcf1922 "os/os0sync.c", line=422) at thr_mutex.c:237 # 12:43:18 #2 0x00000000009988ed in os_event_wait_low (event=0x1fc2ac0, reset_sig_count=0) at os/os0sync.c:422 # 12:43:18 #3 0x00000000009977d4 in os_aio_simulated_handle (global_segment=3, message1=0x7f6142bfce58, message2=0x7f6142bfce50, # 12:43:18 type=0x7f6142bfce48) at os/os0file.c:4270 # 12:43:18 #4 0x000000000096fa96 in fil_aio_wait (segment=3) at fil/fil0fil.c:4251 # 12:43:18 #5 0x00000000009c2fc0 in io_handler_thread (arg=0x1197398) at srv/srv0start.c:421 # 12:43:18 #6 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #7 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 7 (Thread 8489): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1fc2a58, mp=0x1fc29e0, file=0xcf1922 "os/os0sync.c", line=422) at thr_mutex.c:237 # 12:43:18 #2 0x00000000009988ed in os_event_wait_low (event=0x1fc29e0, reset_sig_count=0) at os/os0sync.c:422 # 12:43:18 #3 0x00000000009977d4 in os_aio_simulated_handle (global_segment=2, message1=0x7f61435fde58, message2=0x7f61435fde50, # 12:43:18 type=0x7f61435fde48) at os/os0file.c:4270 # 12:43:18 #4 0x000000000096fa96 in fil_aio_wait (segment=2) at fil/fil0fil.c:4251 # 12:43:18 #5 0x00000000009c2fc0 in io_handler_thread (arg=0x1197390) at srv/srv0start.c:421 # 12:43:18 #6 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #7 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 6 (Thread 8488): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1fc2978, mp=0x1fc2900, file=0xcf1922 "os/os0sync.c", line=422) at thr_mutex.c:237 # 12:43:18 #2 0x00000000009988ed in os_event_wait_low (event=0x1fc2900, reset_sig_count=0) at os/os0sync.c:422 # 12:43:18 #3 0x00000000009977d4 in os_aio_simulated_handle (global_segment=1, message1=0x7f6143ffee58, message2=0x7f6143ffee50, # 12:43:18 type=0x7f6143ffee48) at os/os0file.c:4270 # 12:43:18 #4 0x000000000096fa96 in fil_aio_wait (segment=1) at fil/fil0fil.c:4251 # 12:43:18 #5 0x00000000009c2fc0 in io_handler_thread (arg=0x1197388) at srv/srv0start.c:421 # 12:43:18 #6 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #7 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 5 (Thread 8496): # 12:43:18 #0 0x000000334320e48d in read () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b034f4 in vio_read (vio=0x209c9f8, buf=0x20a2298 "\a", size=4) at viosocket.c:44 # 12:43:18 #2 0x00000000006a7984 in my_real_read (net=0x204da20, complen=0x7f6148099d78) at net_serv.cc:816 # 12:43:18 #3 0x00000000006a812b in my_net_read (net=0x204da20) at net_serv.cc:1011 # 12:43:18 #4 0x00000000006c4003 in do_command (thd=0x204d938) at sql_parse.cc:830 # 12:43:18 #5 0x00000000006c2449 in handle_one_connection (arg=0x204d938) at sql_connect.cc:1136 # 12:43:18 #6 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #7 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 4 (Thread 8526): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xc87be0 "sql_base.cc", line=2727) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x00000000007153a9 in open_table (thd=0x20e3578, table_list=0x7f6104039d10, mem_root=0x7f613f629600, refresh=0x7f613f62968f, # 12:43:18 flags=2) at sql_base.cc:2727 # 12:43:18 #5 0x00000000007193ee in open_tables (thd=0x20e3578, start=0x7f613f629700, counter=0x7f613f62973c, flags=2) at sql_base.cc:4621 # 12:43:18 #6 0x000000000071a437 in open_normal_and_derived_tables (thd=0x20e3578, tables=0x7f6104039d10, flags=2) at sql_base.cc:5088 # 12:43:18 #7 0x0000000000847b82 in get_all_tables (thd=0x20e3578, tables=0x7f61040056d8, cond=0x0) at sql_show.cc:3491 # 12:43:18 #8 0x0000000000853f87 in get_schema_tables_result (join=0x7f6104025f38, executed_place=PROCESSED_BY_JOIN_EXEC) # 12:43:18 at sql_show.cc:6174 # 12:43:18 #9 0x000000000073832d in JOIN::exec (this=0x7f6104025f38) at sql_select.cc:1845 # 12:43:18 #10 0x000000000073aa38 in mysql_select (thd=0x20e3578, rref_pointer_array=0x20e5660, tables=0x7f6104005310, wild_num=1, # 12:43:18 fields=..., conds=0x7f6104006580, og_num=1, order=0x7f6104006818, group=0x0, having=0x0, proc_param=0x0, # 12:43:18 select_options=2684635648, result=0x7f610405e078, unit=0x20e5068, select_lex=0x20e5490) at sql_select.cc:2517 # 12:43:18 #11 0x000000000073264e in handle_select (thd=0x20e3578, lex=0x20e4fc8, result=0x7f610405e078, setup_tables_done_option=0) # 12:43:18 at sql_select.cc:269 # 12:43:18 #12 0x00000000006d091f in execute_sqlcom_select (thd=0x20e3578, all_tables=0x7f6104005310) at sql_parse.cc:5108 # 12:43:18 #13 0x00000000006c7a06 in mysql_execute_command (thd=0x20e3578) at sql_parse.cc:2292 # 12:43:18 #14 0x00000000006d2d5d in mysql_parse (thd=0x20e3578, # 12:43:18 rawbuf=0x7f6104004bc8 "SELECT * FROM (test . `CC` AS table1 RIGHT OUTER JOIN INFORMATION_SCHEMA . `PARTITIONS` AS table2 ON ( table2 . `NODEGROUP` = table1 . `col_int_nokey` ) ) WHERE NOT table1 . `col_varchar_key` <> '2005"..., length=256, # 12:43:18 found_semicolon=0x7f613f62bc40) at sql_parse.cc:6032 # 12:43:18 #15 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20e3578, # 12:43:18 packet=0x20e6639 " SELECT * FROM (test . `CC` AS table1 RIGHT OUTER JOIN INFORMATION_SCHEMA . `PARTITIONS` AS table2 ON ( table2 . `NODEGROUP` = table1 . `col_int_nokey` ) ) WHERE NOT table1 . `col_varchar_key` <> '200"..., packet_length=257) # 12:43:18 at sql_parse.cc:1260 # 12:43:18 #16 0x00000000006c41ba in do_command (thd=0x20e3578) at sql_parse.cc:888 # 12:43:18 #17 0x00000000006c2449 in handle_one_connection (arg=0x20e3578) at sql_connect.cc:1136 # 12:43:18 #18 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #19 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 3 (Thread 8487): # 12:43:18 #0 0x000000334320b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b357a4 in safe_cond_wait (cond=0x1fc2898, mp=0x1fc2820, file=0xcf1922 "os/os0sync.c", line=422) at thr_mutex.c:237 # 12:43:18 #2 0x00000000009988ed in os_event_wait_low (event=0x1fc2820, reset_sig_count=0) at os/os0sync.c:422 # 12:43:18 #3 0x00000000009977d4 in os_aio_simulated_handle (global_segment=0, message1=0x7f614986be58, message2=0x7f614986be50, # 12:43:18 type=0x7f614986be48) at os/os0file.c:4270 # 12:43:18 #4 0x000000000096fa96 in fil_aio_wait (segment=0) at fil/fil0fil.c:4251 # 12:43:18 #5 0x00000000009c2fc0 in io_handler_thread (arg=0x1197380) at srv/srv0start.c:421 # 12:43:18 #6 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #7 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 2 (Thread 8524): # 12:43:18 #0 0x000000334320dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 # 12:43:18 #1 0x00000033432092fb in _L_lock_1021 () from /lib64/libpthread.so.0 # 12:43:18 #2 0x000000334320927e in pthread_mutex_lock () from /lib64/libpthread.so.0 # 12:43:18 #3 0x0000000000b353f9 in safe_mutex_lock (mp=0x1184b60, try_lock=0 '\000', file=0xc87be0 "sql_base.cc", line=1194) # 12:43:18 at thr_mutex.c:149 # 12:43:18 #4 0x0000000000711b71 in close_open_tables (thd=0x20dc358) at sql_base.cc:1194 # 12:43:18 #5 0x0000000000711fd8 in close_thread_tables (thd=0x20dc358) at sql_base.cc:1357 # 12:43:18 #6 0x000000000071b392 in close_tables_for_reopen (thd=0x20dc358, tables=0x7f613f66abb8) at sql_base.cc:5541 # 12:43:18 #7 0x0000000000847c94 in get_all_tables (thd=0x20dc358, tables=0x7f6110004ed0, cond=0x7f6110005410) at sql_show.cc:3527 # 12:43:18 #8 0x0000000000853f87 in get_schema_tables_result (join=0x7f6110029648, executed_place=PROCESSED_BY_JOIN_EXEC) # 12:43:18 at sql_show.cc:6174 # 12:43:18 #9 0x000000000073832d in JOIN::exec (this=0x7f6110029648) at sql_select.cc:1845 # 12:43:18 #10 0x000000000073aa38 in mysql_select (thd=0x20dc358, rref_pointer_array=0x20de440, tables=0x7f6110004ed0, wild_num=1, # 12:43:18 fields=..., conds=0x7f6110005410, og_num=1, order=0x7f61100056d0, group=0x0, having=0x0, proc_param=0x0, # 12:43:18 select_options=2684635648, result=0x7f6110006358, unit=0x20dde48, select_lex=0x20de270) at sql_select.cc:2517 # 12:43:18 #11 0x000000000073264e in handle_select (thd=0x20dc358, lex=0x20ddda8, result=0x7f6110006358, setup_tables_done_option=0) # 12:43:18 at sql_select.cc:269 # 12:43:18 #12 0x00000000006d091f in execute_sqlcom_select (thd=0x20dc358, all_tables=0x7f6110004ed0) at sql_parse.cc:5108 # 12:43:18 #13 0x00000000006c7a06 in mysql_execute_command (thd=0x20dc358) at sql_parse.cc:2292 # 12:43:18 #14 0x00000000006d2d5d in mysql_parse (thd=0x20dc358, # 12:43:18 rawbuf=0x7f6110004bc8 "SELECT * FROM INFORMATION_SCHEMA . `VIEWS` AS table1 WHERE table1 . `IS_UPDATABLE` < '2001-11-27 13:21:20' ORDER BY table1 . `CHARACTER_SET_CLIENT`", length=150, found_semicolon=0x7f613f66cc40) at sql_parse.cc:6032 # 12:43:18 #15 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20dc358, # 12:43:18 packet=0x20df419 " SELECT * FROM INFORMATION_SCHEMA . `VIEWS` AS table1 WHERE table1 . `IS_UPDATABLE` < '2001-11-27 13:21:20' ORDER BY table1 . `CHARACTER_SET_CLIENT`", packet_length=151) at sql_parse.cc:1260 # 12:43:18 #16 0x00000000006c41ba in do_command (thd=0x20dc358) at sql_parse.cc:888 # 12:43:18 #17 0x00000000006c2449 in handle_one_connection (arg=0x20dc358) at sql_connect.cc:1136 # 12:43:18 #18 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #19 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 # 12:43:18 Thread 1 (Thread 8520): # 12:43:18 #0 0x000000334320c61c in pthread_kill () from /lib64/libpthread.so.0 # 12:43:18 #1 0x0000000000b29e0b in my_write_core (sig=6) at stacktrace.c:331 # 12:43:18 #2 0x00000000006b51f2 in handle_segfault (sig=6) at mysqld.cc:2606 # 12:43:18 #3 # 12:43:18 #4 0x0000003342e329a5 in raise () from /lib64/libc.so.6 # 12:43:18 #5 0x0000003342e34185 in abort () from /lib64/libc.so.6 # 12:43:18 #6 0x0000003342e2b935 in __assert_fail () from /lib64/libc.so.6 # 12:43:18 #7 0x0000000000715550 in open_table (thd=0x20ce058, table_list=0x7f6118081a58, mem_root=0x7f613f6ec600, refresh=0x7f613f6ec68f, # 12:43:18 flags=2) at sql_base.cc:2804 # 12:43:18 #8 0x00000000007193ee in open_tables (thd=0x20ce058, start=0x7f613f6ec700, counter=0x7f613f6ec73c, flags=2) at sql_base.cc:4621 # 12:43:18 #9 0x000000000071a437 in open_normal_and_derived_tables (thd=0x20ce058, tables=0x7f6118081a58, flags=2) at sql_base.cc:5088 # 12:43:18 #10 0x0000000000847b82 in get_all_tables (thd=0x20ce058, tables=0x7f6118004eb0, cond=0x7f61180053c0) at sql_show.cc:3491 # 12:43:18 #11 0x0000000000853f87 in get_schema_tables_result (join=0x7f61180521b8, executed_place=PROCESSED_BY_JOIN_EXEC) # 12:43:18 at sql_show.cc:6174 # 12:43:18 #12 0x000000000073832d in JOIN::exec (this=0x7f61180521b8) at sql_select.cc:1845 # 12:43:18 #13 0x000000000073aa38 in mysql_select (thd=0x20ce058, rref_pointer_array=0x20d0140, tables=0x7f6118004eb0, wild_num=1, # 12:43:18 fields=..., conds=0x7f61180053c0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684635648, # 12:43:18 result=0x7f61180063c0, unit=0x20cfb48, select_lex=0x20cff70) at sql_select.cc:2517 # 12:43:18 #14 0x000000000073264e in handle_select (thd=0x20ce058, lex=0x20cfaa8, result=0x7f61180063c0, setup_tables_done_option=0) # 12:43:18 at sql_select.cc:269 # 12:43:18 #15 0x00000000006d091f in execute_sqlcom_select (thd=0x20ce058, all_tables=0x7f6118004eb0) at sql_parse.cc:5108 # 12:43:18 #16 0x00000000006c7a06 in mysql_execute_command (thd=0x20ce058) at sql_parse.cc:2292 # 12:43:18 #17 0x00000000006d2d5d in mysql_parse (thd=0x20ce058, # 12:43:18 rawbuf=0x7f6118004bc8 "SELECT * FROM INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table1 WHERE table1 . `CONSTRAINT_CATALOG` != 'h'", length=107, found_semicolon=0x7f613f6eec40) at sql_parse.cc:6032 # 12:43:18 #18 0x00000000006c5265 in dispatch_command (command=COM_QUERY, thd=0x20ce058, # 12:43:18 packet=0x20d0fd9 " SELECT * FROM INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table1 WHERE table1 . `CONSTRAINT_CATALOG` != 'h' ", packet_length=111) at sql_parse.cc:1260 # 12:43:18 #19 0x00000000006c41ba in do_command (thd=0x20ce058) at sql_parse.cc:888 # 12:43:18 #20 0x00000000006c2449 in handle_one_connection (arg=0x20ce058) at sql_connect.cc:1136 # 12:43:18 #21 0x0000003343207761 in start_thread () from /lib64/libpthread.so.0 # 12:43:18 #22 0x0000003342ee14ed in clone () from /lib64/libc.so.6 # 12:43:18 Waiting for mysqld with pid 8485 to terminate... # 12:43:18 ... waiting complete. # 12:43:18 Test completed with failure status 101. # 12:43:18 gentest.pl exited with exit status 101 Fri Sep 3 12:43:18 2010 [8465] runall.pl will exit with exit status 101 [miguel@tikal randgen]$