# GDB stack trace from crash during stress_tx_rr, 8 clients, mysql-6.0-falcon-team @ March 13 2009. # Assert in thread 1. (gdb) thread apply all bt Thread 23 (process 14907): #0 0x08846795 in _checkchunk (irem=0x8a1e4b2, filename=0x8a1e4b2 "mf_iocache.c", lineno=241) at safemalloc.c:465 #1 0x08846a2e in _sanity (filename=0x8a1e4b2 "mf_iocache.c", lineno=241) at safemalloc.c:517 #2 0x088458c0 in _mymalloc (size=65536, filename=0x8a1e4b2 "mf_iocache.c", lineno=241, MyFlags=4) at safemalloc.c:130 #3 0x0883f922 in init_io_cache (info=0xae582794, file=-1, cachesize=65536, type=WRITE_CACHE, seek_offset=0, use_async_io=0 '\0', cache_myflags=20) at mf_iocache.c:238 #4 0x08843f1e in open_cached_file (cache=0xae582794, dir=0xaa0d080 "/home/johnemb/dev/mysql/bzr-repos/mysql-6.0-falcon-team-jsandbox/mysql-test/var/tmp", prefix=0x898fe1b "MY", cache_size=65536, cache_myflags=16) at mf_cache.c:69 #5 0x083ffcc9 in filesort (thd=0xada26bf8, table=0xad1e850, sortorder=0xadb5100, s_length=1, select=0xadb4fd8, max_rows=987654321, sort_positions=false, examined_rows=0xae5829ec) at filesort.cc:238 #6 0x083443a8 in create_sort_index (thd=0xada26bf8, join=0xad59000, order=0xad49798, filesort_limit=987654321, select_limit=987654321, is_order_by=false) at sql_select.cc:19023 #7 0x08365130 in JOIN::exec (this=0xad59000) at sql_select.cc:2824 #8 0x0835fee8 in mysql_select (thd=0xada26bf8, rref_pointer_array=0xada27f08, tables=0xad49088, wild_num=1, fields=@0xada27e98, conds=0xad495d8, og_num=1, order=0xad49798, group=0x0, having=0x0, proc_param=0x0, select_options=2426161664, result=0xad499f0, unit=0xada27b74, select_lex=0xada27e04) at sql_select.cc:3062 #9 0x083656cf in handle_select (thd=0xada26bf8, lex=0xada27b18, result=0xad499f0, setup_tables_done_option=0) at sql_select.cc:314 #10 0x082cc0c4 in mysql_execute_command (thd=0xada26bf8) at sql_parse.cc:2603 #11 0x082d3bb8 in mysql_parse (thd=0xada26bf8, inBuf=0xad486c0 "CREATE TEMPORARY TABLE tmp3 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key` LIMIT 987654"..., length=203, found_semicolon=0xae583be8) at sql_parse.cc:5763 #12 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada26bf8, packet=0xada306b1 "CREATE TEMPORARY TABLE tmp3 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key` LIMIT 987654"..., packet_length=203) at sql_parse.cc:1009 #13 0x082d5cfe in do_command (thd=0xada26bf8) at sql_parse.cc:691 #14 0x082c3074 in handle_one_connection (arg=0xada26bf8) at sql_connect.cc:1146 #15 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #16 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 22 (process 14868): #0 0x08871822 in DoTrace (cs=0xac727e8) at dbug.c:1753 #1 0x088709cd in _db_enter_ (_func_=0x8a1d3d6 "find_key_block", _file_=0x8a1ccef "mf_keycache.c", _line_=1692, _stack_frame_=0xae613ee0) at dbug.c:1181 #2 0x0883a349 in find_key_block (keycache=0xaa03ea8, file=67, filepos=5120, init_hits_left=3, wrmode=0, page_st=0xae613f70) at mf_keycache.c:1692 #3 0x0883bf45 in key_cache_read (keycache=0xaa03ea8, file=67, filepos=5120, level=3, buff=0xae614040 "\200a", length=1024, block_length=1024, return_buffer=0) at mf_keycache.c:2624 #4 0x0850c6df in _mi_fetch_keypage (info=0xadfdce8, keyinfo=0xadf584c, page=5120, level=3, buff=0xae614040 "\200a", return_buffer=0) at mi_page.c:31 #5 0x0851e13a in w_search (info=0xadfdce8, keyinfo=0xadf584c, comp_flag=131137, key=0xadfe79d "\001", key_length=5, page=5120, father_buff=0x0, father_keypos=0x0, father_page=0, insert_last=1 '\001') at mi_write.c:360 #6 0x0851dd65 in _mi_ck_real_write_btree (info=0xadfdce8, keyinfo=0xadf584c, key=0xadfe79d "\001", key_length=5, root=0xadf5e60, comp_flag=131137) at mi_write.c:302 #7 0x0851dc42 in _mi_ck_write_btree (info=0xadfdce8, keynr=1, key=0xadfe79d "\001", key_length=5) at mi_write.c:283 #8 0x0851db53 in _mi_ck_write (info=0xadfdce8, keynr=1, key=0xadfe79d "\001", key_length=5) at mi_write.c:254 #9 0x0851d489 in mi_write (info=0xadfdce8, record=0xac4a408 "\001ð6\003") at mi_write.c:125 #10 0x084f3306 in ha_myisam::write_row (this=0xac4a298, buf=0xac4a408 "\001ð6\003") at ha_myisam.cc:708 #11 0x08403064 in handler::ha_write_row (this=0xac4a298, buf=0xac4a408 "\001ð6\003") at handler.cc:5505 #12 0x0836c9c6 in write_record (thd=0xada488b8, table=0xac49a00, info=0xabeee20) at sql_insert.cc:1610 #13 0x0836cda2 in select_insert::send_data (this=0xabeee00, values=@0xada49b58) at sql_insert.cc:3167 #14 0x083366a6 in end_send (join=0xabfea68, join_tab=0xadf4ae8, end_of_records=false) at sql_select.cc:17218 #15 0x083416cd in evaluate_join_record (join=0xabfea68, join_tab=0xadf4948, error=0) at sql_select.cc:16490 #16 0x08341aa2 in sub_select (join=0xabfea68, join_tab=0xadf4948, end_of_records=false) at sql_select.cc:16257 #17 0x0834e3e8 in do_select (join=0xabfea68, fields=0xada49b58, table=0x0, procedure=0x0) at sql_select.cc:15786 #18 0x083653d3 in JOIN::exec (this=0xabfea68) at sql_select.cc:2881 #19 0x0835fee8 in mysql_select (thd=0xada488b8, rref_pointer_array=0xada49bc8, tables=0xabee800, wild_num=1, fields=@0xada49b58, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2417773056, result=0xabeee00, unit=0xada49834, select_lex=0xada49ac4) at sql_select.cc:3062 #20 0x083656cf in handle_select (thd=0xada488b8, lex=0xada497d8, result=0xabeee00, setup_tables_done_option=0) at sql_select.cc:314 #21 0x082cc0c4 in mysql_execute_command (thd=0xada488b8) at sql_parse.cc:2603 #22 0x082d3bb8 in mysql_parse (thd=0xada488b8, inBuf=0xabedea8 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", length=149, found_semicolon=0xae616be8) at sql_parse.cc:5763 #23 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada488b8, packet=0xada287c9 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", packet_length=149) at sql_parse.cc:1009 #24 0x082d5cfe in do_command (thd=0xada488b8) at sql_parse.cc:691 #25 0x082c3074 in handle_one_connection (arg=0xada488b8) at sql_connect.cc:1146 #26 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #27 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 21 (process 14848): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8086d09 in __lll_lock_wait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0xb8082154 in _L_lock_936 () from /lib/tls/i686/cmov/libpthread.so.0 #3 0xb808207e in pthread_mutex_lock () from /lib/tls/i686/cmov/libpthread.so.0 #4 0x0886990e in safe_mutex_lock (mp=0xaa03f0c, my_flags=0, file=0x8a1ccef "mf_keycache.c", line=2581) at thr_mutex.c:226 #5 0x0883be15 in key_cache_read (keycache=0xaa03ea8, file=65, filepos=18432, level=3, buff=0xae5e1a60 "\003ö\001", length=1024, block_length=1024, return_buffer=0) at mf_keycache.c:2581 #6 0x0850c6df in _mi_fetch_keypage (info=0xad1d4e0, keyinfo=0xac6cfa8, page=18432, level=3, buff=0xae5e1a60 "\003ö\001", return_buffer=0) at mi_page.c:31 #7 0x0851e13a in w_search (info=0xad1d4e0, keyinfo=0xac6cfa8, comp_flag=131137, key=0xad1df95 "\001ÿÿþÎ", key_length=5, page=18432, father_buff=0xae5e3040 "\201\a", father_keypos=0xae5e30f7 "\001ÿÿÿ\v", father_page=7168, insert_last=0 '\0') at mi_write.c:360 #8 0x0851e731 in w_search (info=0xad1d4e0, keyinfo=0xac6cfa8, comp_flag=131137, key=0xad1df95 "\001ÿÿþÎ", key_length=5, page=7168, father_buff=0x0, father_keypos=0x0, father_page=0, insert_last=0 '\0') at mi_write.c:424 #9 0x0851dd65 in _mi_ck_real_write_btree (info=0xad1d4e0, keyinfo=0xac6cfa8, key=0xad1df95 "\001ÿÿþÎ", key_length=5, root=0xac6d580, comp_flag=131137) at mi_write.c:302 #10 0x0851dc42 in _mi_ck_write_btree (info=0xad1d4e0, keynr=2, key=0xad1df95 "\001ÿÿþÎ", key_length=5) at mi_write.c:283 #11 0x0851db53 in _mi_ck_write (info=0xad1d4e0, keynr=2, key=0xad1df95 "\001ÿÿþÎ", key_length=5) at mi_write.c:254 #12 0x0851d489 in mi_write (info=0xad1d4e0, record=0xac79d00 "\001ð2\001") at mi_write.c:125 #13 0x084f3306 in ha_myisam::write_row (this=0xac79b90, buf=0xac79d00 "\001ð2\001") at ha_myisam.cc:708 #14 0x08403064 in handler::ha_write_row (this=0xac79b90, buf=0xac79d00 "\001ð2\001") at handler.cc:5505 #15 0x0836c9c6 in write_record (thd=0xada1cc90, table=0xae3c7d8, info=0xaca2e30) at sql_insert.cc:1610 #16 0x0836cda2 in select_insert::send_data (this=0xaca2e10, values=@0xada1df30) at sql_insert.cc:3167 #17 0x083366a6 in end_send (join=0xade48d8, join_tab=0xadead80, end_of_records=false) at sql_select.cc:17218 #18 0x083416cd in evaluate_join_record (join=0xade48d8, join_tab=0xadeabe0, error=0) at sql_select.cc:16490 #19 0x08341aa2 in sub_select (join=0xade48d8, join_tab=0xadeabe0, end_of_records=false) at sql_select.cc:16257 #20 0x0834e3e8 in do_select (join=0xade48d8, fields=0xada1df30, table=0x0, procedure=0x0) at sql_select.cc:15786 #21 0x083653d3 in JOIN::exec (this=0xade48d8) at sql_select.cc:2881 #22 0x0835fee8 in mysql_select (thd=0xada1cc90, rref_pointer_array=0xada1dfa0, tables=0xaca2810, wild_num=1, fields=@0xada1df30, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2417773056, result=0xaca2e10, unit=0xada1dc0c, select_lex=0xada1de9c) at sql_select.cc:3062 #23 0x083656cf in handle_select (thd=0xada1cc90, lex=0xada1dbb0, result=0xaca2e10, setup_tables_done_option=0) at sql_select.cc:314 #24 0x082cc0c4 in mysql_execute_command (thd=0xada1cc90) at sql_parse.cc:2603 #25 0x082d3bb8 in mysql_parse (thd=0xada1cc90, inBuf=0xaca1eb8 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", length=149, found_semicolon=0xae5e5be8) at sql_parse.cc:5763 #26 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada1cc90, packet=0xada445f1 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", packet_length=149) at sql_parse.cc:1009 #27 0x082d5cfe in do_command (thd=0xada1cc90) at sql_parse.cc:691 #28 0x082c3074 in handle_one_connection (arg=0xada1cc90) at sql_connect.cc:1146 #29 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #30 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 20 (process 14908): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8086d09 in __lll_lock_wait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0xb8082154 in _L_lock_936 () from /lib/tls/i686/cmov/libpthread.so.0 #3 0xb808207e in pthread_mutex_lock () from /lib/tls/i686/cmov/libpthread.so.0 #4 0x0886990e in safe_mutex_lock (mp=0x94d7000, my_flags=0, file=0x8a1ee2c "safemalloc.c", line=510) at thr_mutex.c:226 #5 0x088469db in _sanity (filename=0x89adc80 "sql_plugin.cc", lineno=936) at safemalloc.c:510 #6 0x08846050 in _myfree (ptr=0xab0d088, filename=0x89adc80 "sql_plugin.cc", lineno=936, myflags=16) at safemalloc.c:267 #7 0x084c5adb in intern_plugin_unlock (lex=0x0, plugin=0xab0d088) at sql_plugin.cc:936 #8 0x084c6712 in plugin_unlock_list (thd=0x0, list=0xada418fc, count=5) at sql_plugin.cc:993 #9 0x081d519b in lex_end (lex=0xada413f8) at sql_lex.cc:390 #10 0x082a04d2 in THD::end_statement (this=0xada404d8) at sql_class.cc:2550 #11 0x082d3cd4 in mysql_parse (thd=0xada404d8, inBuf=0xad0b228 "CREATE TEMPORARY TABLE tmpSelectLimitNoLimit (a INT, b VARCHAR(255), c TIMESTAMP, KEY(a))", length=89, found_semicolon=0xae5b4be8) at sql_parse.cc:5783 #12 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada404d8, packet=0xada4e5d9 "CREATE TEMPORARY TABLE tmpSelectLimitNoLimit (a INT, b VARCHAR(255), c TIMESTAMP, KEY(a))", packet_length=89) at sql_parse.cc:1009 #13 0x082d5cfe in do_command (thd=0xada404d8) at sql_parse.cc:691 #14 0x082c3074 in handle_one_connection (arg=0xada404d8) at sql_connect.cc:1146 #15 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #16 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 19 (process 15088): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8086d09 in __lll_lock_wait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0xb8082154 in _L_lock_936 () from /lib/tls/i686/cmov/libpthread.so.0 #3 0xb808207e in pthread_mutex_lock () from /lib/tls/i686/cmov/libpthread.so.0 #4 0x0886990e in safe_mutex_lock (mp=0xaa03f0c, my_flags=0, file=0x8a1ccef "mf_keycache.c", line=3075) at thr_mutex.c:226 #5 0x0883cda9 in key_cache_write (keycache=0xaa03ea8, file=63, filepos=4096, level=3, buff=0xae643a60 "\003F\001", length=1024, block_length=1024, dont_write=1, post_write_arg=0xad23540) at mf_keycache.c:3075 #6 0x0850cb5b in _mi_write_keypage (info=0xae3bcc0, keyinfo=0xad23934, page=4096, level=3, buff=0xae643a60 "\003F\001") at mi_page.c:97 #7 0x0851e7fb in w_search (info=0xae3bcc0, keyinfo=0xad23934, comp_flag=131137, key=0xae3c775 "\001", key_length=5, page=4096, father_buff=0xae645040 "\200w", father_keypos=0xae645087 "\001", father_page=5120, insert_last=0 '\0') at mi_write.c:430 #8 0x0851e731 in w_search (info=0xae3bcc0, keyinfo=0xad23934, comp_flag=131137, key=0xae3c775 "\001", key_length=5, page=5120, father_buff=0x0, father_keypos=0x0, father_page=0, insert_last=0 '\0') at mi_write.c:424 #9 0x0851dd65 in _mi_ck_real_write_btree (info=0xae3bcc0, keyinfo=0xad23934, key=0xae3c775 "\001", key_length=5, root=0xad23f48, comp_flag=131137) at mi_write.c:302 #10 0x0851dc42 in _mi_ck_write_btree (info=0xae3bcc0, keynr=1, key=0xae3c775 "\001", key_length=5) at mi_write.c:283 #11 0x0851db53 in _mi_ck_write (info=0xae3bcc0, keynr=1, key=0xae3c775 "\001", key_length=5) at mi_write.c:254 #12 0x0851d489 in mi_write (info=0xae3bcc0, record=0xac87b38 "\001ðë\006") at mi_write.c:125 #13 0x084f3306 in ha_myisam::write_row (this=0xac879c8, buf=0xac87b38 "\001ðë\006") at ha_myisam.cc:708 #14 0x08403064 in handler::ha_write_row (this=0xac879c8, buf=0xac87b38 "\001ðë\006") at handler.cc:5505 #15 0x0836c9c6 in write_record (thd=0xada14488, table=0xac6db58, info=0xac48ca8) at sql_insert.cc:1610 #16 0x0836cda2 in select_insert::send_data (this=0xac48c88, values=@0xada15728) at sql_insert.cc:3167 #17 0x083366a6 in end_send (join=0xae36e90, join_tab=0xae309c0, end_of_records=false) at sql_select.cc:17218 #18 0x083416cd in evaluate_join_record (join=0xae36e90, join_tab=0xae30820, error=0) at sql_select.cc:16490 #19 0x08341aa2 in sub_select (join=0xae36e90, join_tab=0xae30820, end_of_records=false) at sql_select.cc:16257 #20 0x0834e3e8 in do_select (join=0xae36e90, fields=0xada15728, table=0x0, procedure=0x0) at sql_select.cc:15786 #21 0x083653d3 in JOIN::exec (this=0xae36e90) at sql_select.cc:2881 #22 0x0835fee8 in mysql_select (thd=0xada14488, rref_pointer_array=0xada15798, tables=0xac48388, wild_num=1, fields=@0xada15728, conds=0xac488d8, og_num=1, order=0xac48a98, group=0x0, having=0x0, proc_param=0x0, select_options=2417773056, result=0xac48c88, unit=0xada15404, select_lex=0xada15694) at sql_select.cc:3062 #23 0x083656cf in handle_select (thd=0xada14488, lex=0xada153a8, result=0xac48c88, setup_tables_done_option=0) at sql_select.cc:314 #24 0x082cc0c4 in mysql_execute_command (thd=0xada14488) at sql_parse.cc:2603 #25 0x082d3bb8 in mysql_parse (thd=0xada14488, inBuf=0xac479e0 "CREATE TEMPORARY TABLE tmp1 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key`", length=187, found_semicolon=0xae647be8) at sql_parse.cc:5763 #26 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada14488, packet=0xada3c481 "CREATE TEMPORARY TABLE tmp1 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key`", packet_length=187) at sql_parse.cc:1009 #27 0x082d5cfe in do_command (thd=0xada14488) at sql_parse.cc:691 #28 0x082c3074 in handle_one_connection (arg=0xada14488) at sql_connect.cc:1146 #29 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #30 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 18 (process 14926): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8086d09 in __lll_lock_wait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0xb8082154 in _L_lock_936 () from /lib/tls/i686/cmov/libpthread.so.0 #3 0xb808207e in pthread_mutex_lock () from /lib/tls/i686/cmov/libpthread.so.0 #4 0x0886990e in safe_mutex_lock (mp=0xaa03f0c, my_flags=0, file=0x8a1ccef "mf_keycache.c", line=2581) at thr_mutex.c:226 #5 0x0883be15 in key_cache_read (keycache=0xaa03ea8, file=69, filepos=9216, level=3, buff=0xae51f040 "\200g", length=1024, block_length=1024, return_buffer=0) at mf_keycache.c:2581 #6 0x0850c6df in _mi_fetch_keypage (info=0xadb0958, keyinfo=0xada8478, page=9216, level=3, buff=0xae51f040 "\200g", return_buffer=0) at mi_page.c:31 #7 0x0851e13a in w_search (info=0xadb0958, keyinfo=0xada8478, comp_flag=131137, key=0xadb140d "", key_length=4, page=9216, father_buff=0x0, father_keypos=0x0, father_page=0, insert_last=1 '\001') at mi_write.c:360 #8 0x0851dd65 in _mi_ck_real_write_btree (info=0xadb0958, keyinfo=0xada8478, key=0xadb140d "", key_length=4, root=0xada8ac8, comp_flag=131137) at mi_write.c:302 #9 0x0851dc42 in _mi_ck_write_btree (info=0xadb0958, keynr=0, key=0xadb140d "", key_length=4) at mi_write.c:283 #10 0x0851db53 in _mi_ck_write (info=0xadb0958, keynr=0, key=0xadb140d "", key_length=4) at mi_write.c:254 #11 0x0851d489 in mi_write (info=0xadb0958, record=0xac6c638 "\001ðª\001") at mi_write.c:125 #12 0x084f3306 in ha_myisam::write_row (this=0xac6c4c8, buf=0xac6c638 "\001ðª\001") at ha_myisam.cc:708 #13 0x08403064 in handler::ha_write_row (this=0xac6c4c8, buf=0xac6c638 "\001ðª\001") at handler.cc:5505 #14 0x0836c9c6 in write_record (thd=0xada2c7f0, table=0xac4ae40, info=0xad47570) at sql_insert.cc:1610 #15 0x0836cda2 in select_insert::send_data (this=0xad47550, values=@0xada2da90) at sql_insert.cc:3167 #16 0x083366a6 in end_send (join=0xac9d078, join_tab=0xac6b378, end_of_records=false) at sql_select.cc:17218 #17 0x083416cd in evaluate_join_record (join=0xac9d078, join_tab=0xac6b1d8, error=0) at sql_select.cc:16490 #18 0x08341aa2 in sub_select (join=0xac9d078, join_tab=0xac6b1d8, end_of_records=false) at sql_select.cc:16257 #19 0x0834e3e8 in do_select (join=0xac9d078, fields=0xada2da90, table=0x0, procedure=0x0) at sql_select.cc:15786 #20 0x083653d3 in JOIN::exec (this=0xac9d078) at sql_select.cc:2881 #21 0x0835fee8 in mysql_select (thd=0xada2c7f0, rref_pointer_array=0xada2db00, tables=0xad46f50, wild_num=1, fields=@0xada2da90, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2417773056, result=0xad47550, unit=0xada2d76c, select_lex=0xada2d9fc) at sql_select.cc:3062 #22 0x083656cf in handle_select (thd=0xada2c7f0, lex=0xada2d710, result=0xad47550, setup_tables_done_option=0) at sql_select.cc:314 #23 0x082cc0c4 in mysql_execute_command (thd=0xada2c7f0) at sql_parse.cc:2603 #24 0x082d3bb8 in mysql_parse (thd=0xada2c7f0, inBuf=0xad465f8 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", length=149, found_semicolon=0xae521be8) at sql_parse.cc:5763 #25 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada2c7f0, packet=0xada22bb1 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", packet_length=149) at sql_parse.cc:1009 #26 0x082d5cfe in do_command (thd=0xada2c7f0) at sql_parse.cc:691 #27 0x082c3074 in handle_one_connection (arg=0xada2c7f0) at sql_connect.cc:1146 #28 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #29 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 17 (process 3529): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb80843a2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x086643e4 in Synchronize::sleep (this=0xb70c8d28, milliseconds=1000, callersMutex=0x0) at Synchronize.cpp:183 #3 0x086641df in Synchronize::sleep (this=0xb70c8d28, milliseconds=1000) at Synchronize.cpp:136 #4 0x085bf6f5 in Database::ticker (this=0xb72c2648) at Database.cpp:1947 #5 0x085bf72b in Database::ticker (database=0xb72c2648) at Database.cpp:1936 #6 0x085926a8 in Thread::thread (this=0xb70c8d28) at Thread.cpp:166 #7 0x085928cd in Thread::thread (parameter=0xb70c8d28) at Thread.cpp:145 #8 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #9 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 16 (process 3531): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70c8ee8) at Synchronize.cpp:123 #3 0x085c0081 in Database::scavengerThreadMain (this=0xb72c2648) at Database.cpp:1974 #4 0x085c00c3 in Database::scavengerThreadMain (database=0xb72c2648) at Database.cpp:1958 #5 0x085926a8 in Thread::thread (this=0xb70c8ee8) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70c8ee8) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 15 (process 3551): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70cd430) at Synchronize.cpp:123 #3 0x08678663 in Gopher::gopherThread (this=0xb70c2dc8) at Gopher.cpp:58 #4 0x08678837 in Gopher::gopherThread (arg=0xb70c2dc8) at Gopher.cpp:37 #5 0x085926a8 in Thread::thread (this=0xb70cd430) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70cd430) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 14 (process 3508): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb7e80c01 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x082b9df6 in handle_connections_sockets () at mysqld.cc:5188 #3 0x082bdef5 in main (argc=30, argv=0xbf9c9344) at mysqld.cc:4696 Thread 13 (process 3557): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb80843a2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x086643e4 in Synchronize::sleep (this=0xb70cfe60, milliseconds=22000, callersMutex=0x0) at Synchronize.cpp:183 #3 0x086641df in Synchronize::sleep (this=0xb70cfe60, milliseconds=22000) at Synchronize.cpp:136 #4 0x08623f6c in Scheduler::schedule (this=0xb70c8180) at Scheduler.cpp:150 #5 0x08623fd5 in Scheduler::schedule (lpParameter=0xb70c8180) at Scheduler.cpp:159 #6 0x085926a8 in Thread::thread (this=0xb70cfe60) at Thread.cpp:166 #7 0x085928cd in Thread::thread (parameter=0xb70cfe60) at Thread.cpp:145 #8 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #9 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 12 (process 3511): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70c1e30) at Synchronize.cpp:123 #3 0x085a94c2 in Cache::ioThread (this=0xb70c1ad8) at Cache.cpp:985 #4 0x085a96c1 in Cache::ioThread (arg=0xb70c1ad8) at Cache.cpp:775 #5 0x085926a8 in Thread::thread (this=0xb70c1e30) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70c1e30) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 11 (process 3512): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70c1f10) at Synchronize.cpp:123 #3 0x085a94c2 in Cache::ioThread (this=0xb70c1ad8) at Cache.cpp:985 #4 0x085a96c1 in Cache::ioThread (arg=0xb70c1ad8) at Cache.cpp:775 #5 0x085926a8 in Thread::thread (this=0xb70c1f10) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70c1f10) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 10 (process 3530): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70c8e08) at Synchronize.cpp:123 #3 0x085be7ae in Database::cardinalityThreadMain (this=0xb72c2648) at Database.cpp:2473 #4 0x085be7ed in Database::cardinalityThreadMain (database=0xb72c2648) at Database.cpp:2460 #5 0x085926a8 in Thread::thread (this=0xb70c8e08) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70c8e08) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 9 (process 3532): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70c8fc8) at Synchronize.cpp:123 #3 0x0860b266 in PageWriter::writer (this=0xb70c2df0) at PageWriter.cpp:171 #4 0x0860b395 in PageWriter::writer (arg=0xb70c2df0) at PageWriter.cpp:160 #5 0x085926a8 in Thread::thread (this=0xb70c8fc8) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70c8fc8) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 8 (process 3552): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70cd510) at Synchronize.cpp:123 #3 0x08678663 in Gopher::gopherThread (this=0xb70c2da0) at Gopher.cpp:58 #4 0x08678837 in Gopher::gopherThread (arg=0xb70c2da0) at Gopher.cpp:37 #5 0x085926a8 in Thread::thread (this=0xb70cd510) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70cd510) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 7 (process 3554): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70cd5f0) at Synchronize.cpp:123 #3 0x08678663 in Gopher::gopherThread (this=0xb70c2d78) at Gopher.cpp:58 #4 0x08678837 in Gopher::gopherThread (arg=0xb70c2d78) at Gopher.cpp:37 #5 0x085926a8 in Thread::thread (this=0xb70cd5f0) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70cd5f0) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 6 (process 3555): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70cd6d0) at Synchronize.cpp:123 #3 0x08678663 in Gopher::gopherThread (this=0xb70c2d50) at Gopher.cpp:58 #4 0x08678837 in Gopher::gopherThread (arg=0xb70c2d50) at Gopher.cpp:37 #5 0x085926a8 in Thread::thread (this=0xb70cd6d0) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70cd6d0) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 5 (process 3556): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70cd7b0) at Synchronize.cpp:123 #3 0x08678663 in Gopher::gopherThread (this=0xb70c2d28) at Gopher.cpp:58 #4 0x08678837 in Gopher::gopherThread (arg=0xb70c2d28) at Gopher.cpp:37 #5 0x085926a8 in Thread::thread (this=0xb70cd7b0) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70cd7b0) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 4 (process 3558): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8084075 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08664547 in Synchronize::sleep (this=0xb70d5cb0) at Synchronize.cpp:123 #3 0x08623f83 in Scheduler::schedule (this=0xb70c80e8) at Scheduler.cpp:152 #4 0x08623fd5 in Scheduler::schedule (lpParameter=0xb70c80e8) at Scheduler.cpp:159 #5 0x085926a8 in Thread::thread (this=0xb70d5cb0) at Thread.cpp:166 #6 0x085928cd in Thread::thread (parameter=0xb70d5cb0) at Thread.cpp:145 #7 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 3 (process 3559): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb80843a2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0886a441 in safe_cond_timedwait (cond=0x94d09e0, mp=0x94d0980, abstime=0xae3f6368, file=0x8a18a0e "ma_checkpoint.c", line=715) at thr_mutex.c:478 #3 0x0881e6d7 in ma_checkpoint_background (arg=0x1e) at ma_checkpoint.c:715 #4 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #5 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 2 (process 3560): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8088310 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x082b85a5 in signal_hand (arg=0x0) at mysqld.cc:2892 #3 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #4 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 1 (process 14733): #0 0xb80cc430 in __kernel_vsyscall () #1 0xb8085158 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08864e6e in my_write_core (sig=6) at stacktrace.c:309 #3 0x082b94de in handle_segfault (sig=6) at mysqld.cc:2690 #4 #5 0xb80cc430 in __kernel_vsyscall () #6 0xb80884c0 in raise () from /lib/tls/i686/cmov/libpthread.so.0 #7 0x085d66f4 in Error::debugBreak () at Error.cpp:94 #8 0x085d678e in Error::error (string=0x89cc91c "assertion (%s) failed at line %d in file %s\n") at Error.cpp:71 #9 0x085d6837 in Error::assertionFailed (text=0x89d17da "useCount > 0", fileName=0x89d17a5 "Record.cpp", line=551) at Error.cpp:78 #10 0x0860f2d8 in Record::release (this=0xb0162948) at Record.cpp:551 #11 0x08570cd3 in StorageDatabase::nextRow (this=0xb70c1158, storageTable=0xb7445cc0, recordNumber=-286331154, lockForUpdate=false) at StorageDatabase.cpp:315 #12 0x085775a0 in StorageTable::next (this=0xb7445cc0, recordNumber=2679, lockForUpdate=false) at StorageTable.cpp:158 #13 0x085685e4 in StorageInterface::rnd_next (this=0xac0d658, buf=0xac0d828 "\001ðµ\005") at ha_falcon.cpp:651 #14 0x083fb68e in rr_sequential (info=0xac04db4) at records.cc:390 #15 0x083419e1 in sub_select (join=0xad30850, join_tab=0xac04d70, end_of_records=false) at sql_select.cc:16245 #16 0x0834e3e8 in do_select (join=0xad30850, fields=0xada378d8, table=0x0, procedure=0x0) at sql_select.cc:15786 #17 0x083653d3 in JOIN::exec (this=0xad30850) at sql_select.cc:2881 #18 0x0835fee8 in mysql_select (thd=0xada36638, rref_pointer_array=0xada37948, tables=0xad38fb0, wild_num=1, fields=@0xada378d8, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2417773056, result=0xad395b0, unit=0xada375b4, select_lex=0xada37844) at sql_select.cc:3062 #19 0x083656cf in handle_select (thd=0xada36638, lex=0xada37558, result=0xad395b0, setup_tables_done_option=0) at sql_select.cc:314 #20 0x082cc0c4 in mysql_execute_command (thd=0xada36638) at sql_parse.cc:2603 #21 0x082d3bb8 in mysql_parse (thd=0xada36638, inBuf=0xad38658 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", length=149, found_semicolon=0xae4f0be8) at sql_parse.cc:5763 #22 0x082d473a in dispatch_command (command=COM_QUERY, thd=0xada36638, packet=0xada0a429 "CREATE TEMPORARY TABLE tmp2 (PRIMARY KEY (`pk`), KEY (`int1_key`), KEY (`int2_key`), UNIQUE (`int1_unique`), UNIQUE (`int2_unique`)) SELECT * from t1", packet_length=149) at sql_parse.cc:1009 #23 0x082d5cfe in do_command (thd=0xada36638) at sql_parse.cc:691 #24 0x082c3074 in handle_one_connection (arg=0xada36638) at sql_connect.cc:1146 #25 0xb808050f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #26 0xb7e887ee in clone () from /lib/tls/i686/cmov/libc.so.6 (gdb) info threads 23 process 14907 0x08846795 in _checkchunk (irem=0x8a1e4b2, filename=0x8a1e4b2 "mf_iocache.c", lineno=241) at safemalloc.c:465 22 process 14868 0x08871822 in DoTrace (cs=0xac727e8) at dbug.c:1753 21 process 14848 0xb80cc430 in __kernel_vsyscall () 20 process 14908 0xb80cc430 in __kernel_vsyscall () 19 process 15088 0xb80cc430 in __kernel_vsyscall () 18 process 14926 0xb80cc430 in __kernel_vsyscall () 17 process 3529 0xb80cc430 in __kernel_vsyscall () 16 process 3531 0xb80cc430 in __kernel_vsyscall () 15 process 3551 0xb80cc430 in __kernel_vsyscall () 14 process 3508 0xb80cc430 in __kernel_vsyscall () 13 process 3557 0xb80cc430 in __kernel_vsyscall () 12 process 3511 0xb80cc430 in __kernel_vsyscall () 11 process 3512 0xb80cc430 in __kernel_vsyscall () 10 process 3530 0xb80cc430 in __kernel_vsyscall () 9 process 3532 0xb80cc430 in __kernel_vsyscall () 8 process 3552 0xb80cc430 in __kernel_vsyscall () 7 process 3554 0xb80cc430 in __kernel_vsyscall () 6 process 3555 0xb80cc430 in __kernel_vsyscall () 5 process 3556 0xb80cc430 in __kernel_vsyscall () 4 process 3558 0xb80cc430 in __kernel_vsyscall () 3 process 3559 0xb80cc430 in __kernel_vsyscall () 2 process 3560 0xb80cc430 in __kernel_vsyscall () * 1 process 14733 0xb80cc430 in __kernel_vsyscall ()