Thread 24 (process 9853): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb77a98d1 in select () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #2 0x08533d6a in os_thread_sleep (tm=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0thread.c:274 t = { tv_sec = 0, tv_usec = 941968 } #3 0x0846e914 in srv_lock_timeout_thread (arg=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0srv.c:2228 slot = (srv_slot_t *) 0xb6d309b0 some_waits = 1 wait_time = 51 i = 10000 #4 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #5 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 23 (process 10760): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a30e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x085330de in os_event_wait_low (event=0x98ddb80, reset_sig_count=11355) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0sync.c:140 old_signal_count = 11355 #3 0x08477603 in sync_array_wait_event (arr=0x98948b8, index=1) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/sync/sync0arr.c:457 cell = (sync_cell_t *) 0xb6d6c034 event = (os_event_t) 0x98ddb80 #4 0x084792d5 in mutex_spin_wait (mutex=0x98ddb38, file_name=0x86a1918 "/export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/lock/lock0lock.c", line=3823) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/sync/sync0sync.c:621 index = 1 i = 0 #5 0x0851206a in pfs_mutex_enter_func (mutex=0x98ddb38, file_name=0x86a1918 "/export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/lock/lock0lock.c", line=3823) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/include/sync0sync.ic:222 locker = (struct PSI_mutex_locker *) 0x0 state = { m_flags = 167484076, m_mutex = 0xa95cc708, m_thread = 0x858b7a3, m_timer_start = 12002093078456425188, m_timer = 0x13, m_operation = 143366336, m_src_file = 0x88b98c0 "´k\213\bp&\216·à\207\215·\020?y·P0\212·`ú\211· 3\212·p)z·°\001\212·Ð\222o·ö\235\021\b \az·\200?\212·&\236\021\bP\002\212·\020Óo·V\236\021\bP¥r·v\236\021\b\206\236\021\bPw\212·¦\236\021\bPHt·", m_src_line = -1500390684, m_wait = 0xa95cc728 } #6 0x08518d7b in lock_table (flags=0, table=0xa96af018, mode=LOCK_IX, thr=0xa1c1130) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/lock/lock0lock.c:3823 trx = (trx_t *) 0xa06f858 err = #7 0x08461181 in row_search_for_mysql (buf=0xa168c38 "ÿ", mode=1, prebuilt=0xa04fbc0, match_mode=0, direction=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/row/row0sel.c:3733 index = (dict_index_t *) 0xa633a5a0 comp = 1 search_tuple = (const dtuple_t *) 0xa1c0f60 pcur = (btr_pcur_t *) 0x98d8ee8 trx = (trx_t *) 0xa06f858 clust_index = (dict_index_t *) 0xa633a5a0 thr = (que_thr_t *) 0xa1c1130 rec = (const rec_t *) 0x2a08
result_rec = (const rec_t *) 0x8566cc7 "\201Ãù+5" clust_rec = (const rec_t *) 0x5
err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = 0 moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = 1289790206 next_offs = 554082 same_user_rec = 2788402592 mtr = { memo = { heap = 0x0, used = 0, data = "7\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000Tat¦¬\232û\t¨È\\©\000\000\000\000\000\000\000\000\020\000\220¦X\"\021\nÀ\230\213\bÀ\230\213\bTat¦ÈÈ\\©ª±$\bTat¦À\230\213\bÈÈ\\©À\230\213\bÀ\230\213\b¸\031\021\n\bÉ\\©\000\000\000\000\000\000\000\000ð\016r¦¬\232û\t\000\000\000\000Qës·È_t¦ð\016r¦ÁùZ\bÎ\t\212·\216ü\200·\b\027\201\001À\230\213\bKÖÁN\a\000\000\000\000ª\226\b@\204\227\b\034\000\000\000ða\213\txÉ\\©§\231\024\bH\214\026\nP\214\026\nXÉ\\©R\033\026\b"..., base = { count = 168893356, start = 0x8978440, end = 0x9fb9aac }, list = { prev = 0xa5f0f338, next = 0x0 } }, log = { heap = 0x0, used = 0, data = "\220D\235¦¸Ê\\©R\033\026\b<\210\221¦\000\000\000\000\222\034\021\nÀ\217\227\b\020Ì\227\bU\234\225¦\000\000\000\000\000\000\000\000\025\000\000\000\220D\235¦XË\\©*(\026\bH\232û\td\000\000\000\004\000\000\000\006\000\000\200\006\000\000\000\f\000\000\000\023\000\000\000\027\000\000\000own \200\230\220\b\000\000\000\000\000\000\000\000\025\000\000\000fiel\b*\000\000st'\000H\232û\td\000\000\000\001\000\000\000§¬\031\b\b\000\000\000°\207\221¦xË\\©8È\025\bÄ¢û\t\036½2sHË\\©E¼!\b C\235¦\000\000\000\000\b\000\000\000\000\000\000\000À\230\213\b°\207\221¦xË\\©"..., base = { count = 3, start = 0xa95ccca8, end = 0x82cfbbd }, list = { prev = 0xa111bd8, next = 0xa111bd8 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 12203854455960050896, end_lsn = 725392694799327713 } heap = (mem_heap_t *) 0x0 offsets_ = {100, 1, 168893696, 1, 168893248, 2841431368, 137108529, 168893248, 169249872, 168892296, 0, 4294967295, 4294967295, 137191643, 143366336, 1, 168893528, 2841431368, 137202836, 168893648, 168893528, 168893612, 168893616, 1, 3078683790, 8460040, 1, 168893248, 167483976, 168893400, 137048721, 143693696, 1, 3, 143366336, 0, 168893400, 2841431768, 137313334, 168893528, 1, 168893616, 0, 2147483648, 168893620, 168893620, 2794455104, 0, 2793068280, 3077823860, 1006, 2, 2794455944, 2794455104, 139957348, 2795489848, 0, 2792808208, 2794455056, 3079277006, 2779881832, 3077835461, 2792816248, 120, 2794455056, 3, 143366336, 3079282780, 8040, 10760, 136429143, 1, 134217728, 0, 143366336, 0, 168172072, 2841431624, 140030746, 168172084, 2793068296, 2841431592, 137001567, 167483976, 137009288, 168172084, 138655034, 167483976, 168228952, 2841431704, 138657250, 169249872, 168228952, 2841431640, 136600655, 167483976, 143366336, 2841431736, 138657250, 169249872} offsets = (ulint *) 0xa95cccb4 table_lock_waited = 1 #8 0x0843df10 in ha_innobase::index_read (this=0xa168ae0, buf=0xa168c38 "ÿ", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:5653 mode = 1 index = match_mode = 0 error = ret = #9 0x0843c404 in ha_innobase::index_first (this=0xa168ae0, buf=0xa168c38 "ÿ") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:5955 error = #10 0x0843dbf6 in ha_innobase::rnd_next (this=0xa168ae0, buf=0xa168c38 "ÿ") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:6052 error = #11 0x0837e68c in rr_sequential (info=0xa95cd38c) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/records.cc:446 tmp = 0 #12 0x0839ac67 in mysql_delete (thd=0x9fb9a48, table_list=0xa111788, conds=0xa111c58, order_list=0x9fbafa0, limit=3, options=) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_delete.cc:297 will_batch = false error = 0 loc_error = table = (TABLE *) 0x9f16850 select = (SQL_SELECT *) 0xa111db8 info = { table = 0x9f16850, file = 0xa168ae0, forms = 0xa95cd38c, unlock_row = 0x81bdc20 , read_record = 0x837e660 , thd = 0x9fb9a48, select = 0xa111db8, cache_records = 0, ref_length = 6, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0xa168c38 "ÿ", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, io_cache = 0x0, print_error = true, ignore_not_found_rows = false } using_limit = true transactional_table = safe_update = false const_cond = const_cond_result = deleted = 0 reverse = false order = (ORDER *) 0x0 usable_index = select_lex = (SELECT_LEX *) 0x9fbaec0 killed_status = query_type = __FUNCTION__ = "mysql_delete" #13 0x081a0a01 in mysql_execute_command (thd=0x9fb9a48) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2916 res = 0 up_result = lex = (LEX *) 0x9fbaa24 select_lex = (SELECT_LEX *) 0x9fbaec0 first_table = (TABLE_LIST *) 0xa111788 all_tables = (TABLE_LIST *) 0xa111788 unit = (SELECT_LEX_UNIT *) 0x9fbaa88 have_table_map_for_update = __FUNCTION__ = "mysql_execute_command" #14 0x081a4361 in mysql_parse (thd=0x9fb9a48, rawbuf=0xa1116b8 "DELETE FROM `h` WHERE `F1` < RAND() LIMIT 3", length=43, parser_state=0xa95ce110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0x9fbaa24 err = __FUNCTION__ = "mysql_parse" #15 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0x9fb9a48, packet=0xa07bc11 " DELETE FROM `h` WHERE `F1` < RAND() LIMIT 3 ", packet_length=45) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0x9fb9a48, yylineno = 1, yytoklen = 1, yylval = 0xa95cdc00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0xa1116e4 "L ORDER BY `F1` LIMIT 2", m_tok_start = 0xa1116e4 "L ORDER BY `F1` LIMIT 2", m_tok_end = 0xa1116e4 "L ORDER BY `F1` LIMIT 2", m_end_of_query = 0xa1116e3 "", m_tok_start_prev = 0xa1116e3 "", m_buf = 0xa1116b8 "DELETE FROM `h` WHERE `F1` < RAND() LIMIT 3", m_buf_length = 43, m_echo = true, m_echo_saved = false, m_cpp_buf = 0xa111720 "DELETE FROM `h` WHERE `F1` < RAND() LIMIT 3", m_cpp_ptr = 0xa11174b "", m_cpp_tok_start = 0xa11174b "", m_cpp_tok_start_prev = 0xa11174b "", m_cpp_tok_end = 0xa11174b "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xa67da1ea "", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 2841436828, m_cpp_text_start = 0xa11174a "3", m_cpp_text_end = 0xa11174b "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #16 0x081a65df in do_command (thd=0x9fb9a48) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0xa07bc10 "\003 DELETE FROM `h` WHERE `F1` < RAND() LIMIT 3 " packet_length = net = (NET *) 0x9fb9b78 command = COM_QUERY #17 0x082448fd in do_handle_one_connection (thd_arg=0x9fb9a48) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0x9fb9a48 #18 0x082449df in handle_one_connection (arg=0x9fb9a48) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #19 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #20 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 22 (process 9854): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb77a98d1 in select () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #2 0x08533d6a in os_thread_sleep (tm=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0thread.c:274 t = { tv_sec = 0, tv_usec = 941750 } #3 0x0846ed57 in srv_error_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0srv.c:2398 fatal_cnt = 0 old_lsn = 4450373004 new_lsn = 4450373004 #4 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #5 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 21 (process 9856): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb77a98d1 in select () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #2 0x08533d6a in os_thread_sleep (tm=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0thread.c:274 t = { tv_sec = 0, tv_usec = 944147 } #3 0x084700ac in srv_master_thread (arg=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0srv.c:2662 cur_time = 1300017722 buf_stat = { n_page_gets = 384065549, n_pages_read = 144, n_pages_written = 1019424, n_pages_created = 2768, n_ra_pages_read = 0, n_ra_pages_evicted = 0, n_pages_made_young = 6415, n_pages_not_made_young = 0 } event = old_activity_count = 1487980 n_bytes_merged = 0 n_pages_flushed = 0 n_tables_to_drop = 0 next_itr_time = 1000 #4 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #5 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 20 (process 9849): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2868941556) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bdc) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 7 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 19 (process 10486): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a30e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x085330de in os_event_wait_low (event=0x98ddb80, reset_sig_count=11355) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0sync.c:140 old_signal_count = 11355 #3 0x08477603 in sync_array_wait_event (arr=0x98948b8, index=2) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/sync/sync0arr.c:457 cell = (sync_cell_t *) 0xb6d6c060 event = (os_event_t) 0x98ddb80 #4 0x084792d5 in mutex_spin_wait (mutex=0x98ddb38, file_name=0x8691cfc "/export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/trx/trx0trx.c", line=709) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/sync/sync0sync.c:621 index = 2 i = 0 #5 0x08490422 in trx_start (trx=0xa16db58, rseg_id=4294967295) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/include/sync0sync.ic:222 No locals. #6 0x0846131e in row_search_for_mysql (buf=0xa69437f0 "ÿÿÿ", mode=1, prebuilt=0xa67d1c48, match_mode=0, direction=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/include/trx0trx.ic:38 index = (dict_index_t *) 0xa96e5618 comp = search_tuple = (const dtuple_t *) 0xa679b2f8 pcur = (btr_pcur_t *) 0xa692e4c0 trx = (trx_t *) 0xa16db58 clust_index = thr = rec = result_rec = clust_rec = err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = moves_up = set_also_gap_locks = did_semi_consistent_read = next_offs = same_user_rec = mtr = { memo = { heap = 0x0, used = 0, data = "ËÕ$\bÀ\230\213\bp\017\f\n\000\000\000\000ØÙ_©\nä\025\bp\017\f\n\200rõ\t\2003á\001­.S\b@Û\215\tÜÞ_©p\017\f\nn\203Q\b@Û\215\t\001\000\000\000¸\016\225¦\000\000\000\000\030\000\000\0007\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000?ÝE\b\000\000\000\000Àñ®®p\200È°Àñ®®p\200È°¸\016\225¦\000\200È°w|T\bp\000\000\000\000\200È°p\200È°À\230\213\b\000\000\000\000Ðu\230¦Øß_©*\031F\b Ù_©XÛ\026\n\003\000\000\000\000\000\000\000¸W\021¦ Íh\b\026\017\000\000w|T\b"..., base = { count = 167080064, start = 0x88b98c0, end = 0x2 }, list = { prev = 0x9f57080, next = 0xa95fdcc8 } }, log = { heap = 0x0, used = 0, data = "\200põ\t0tõ\t\002\000\000\0000tõ\t\000\000\000\000\000\000\000\000\204uõ\t\001\000\000\000\001\000\000\000¤tõ\t\001\000\000\000¸Ü_©øwS¦\a\000\000\000\b3\215\b¸Ü_©\002\000\000\000\000\000\001\001\034", '\0' , "0tõ\t\001\000\000\000\001\000\000\000\0209\224¦¤tõ\t>\037\000\000\000\000\000\004\000\004\000\004\000\004\000\004\000\004\000\004\000\004\000\004\000\004\000\004\000\004;æ7\000\t\000\001?ýÿ\000\f°Æ\021\200\000\b>\000\000\000\n\231Ô·\000\000\005È\001\0206¦À\230\213\b\000\000\000\000À\227\227¦XÛ_©*(\026\bp\017\f\n\200qõ\tPvõ\t\001"..., base = { count = 2841632288, start = 0x1e13380, end = 0x5af9c1 }, list = { prev = 0x2a, next = 0x98b6260 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 12204716132104686416, end_lsn = 717608152474668523 } heap = (mem_heap_t *) 0x0 offsets_ = {100, 2842176024, 2841640976, 0, 143693952, 0, 1, 3079282780, 3079278977, 2841631912, 137190209, 167081264, 1157657715, 256, 4352, 0, 167081348, 2841631880, 135468788, 167081168, 1048576, 2841631912, 137165771, 167081168, 143366336, 2841631912, 143366336, 144165976, 167081384, 2841631992, 137191905, 167081384, 167081264, 2, 167081432, 2, 167081016, 2841632072, 137108529, 167081016, 2794731792, 167080064, 0, 4294967295, 4294967295, 137191643, 143366336, 2, 167081264, 2841632072, 137202836, 167081384, 167081264, 167081348, 167081352, 2, 3078683790, 8460040, 2, 167081016, 2930431392, 167081168, 137048721, 143693696, 1, 3, 143366336, 0, 167081168, 2841632472, 137313334, 167081264, 1, 167081348, 0, 0, 167081356, 167081356, 2841641024, 166733896, 2790273056, 3077823860, 1006, 3079282780, 3079278977, 2, 0, 1, 10, 2841632280, 138657250, 2794911536, 2781872144, 3077835461, 2791091976, 24, 2841640976, 3, 143366336, 3079282780} offsets = (ulint *) 0xa95fdc34 table_lock_waited = #7 0x0843df10 in ha_innobase::index_read (this=0xa6943698, buf=0xa69437f0 "ÿÿÿ", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:5653 mode = 1 index = match_mode = 0 error = ret = #8 0x0843c404 in ha_innobase::index_first (this=0xa6943698, buf=0xa69437f0 "ÿÿÿ") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:5955 error = #9 0x082a7caf in handler::read_range_first (this=0xa6943698, start_key=0x0, end_key=0xa658bd90, eq_range_arg=false, sorted=false) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:4253 result = #10 0x082a7dad in handler::read_multi_range_first (this=0xa6943698, found_range_p=0xa95fdf2c, ranges=0xa658bd80, range_count=1, sorted=false, buffer=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:4132 result = #11 0x08365c07 in QUICK_RANGE_SELECT::get_next (this=0xa6392c00) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/opt_range.cc:8692 count = 1 mrange_slot = (KEY_MULTI_RANGE *) 0xa658bd80 mrange_end = (KEY_MULTI_RANGE *) 0xa658bda8 result = mrange = (KEY_MULTI_RANGE *) 0x8172ae1 #12 0x0837e534 in rr_quick (info=0xa95fe38c) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/records.cc:335 tmp = 0 #13 0x0839ac67 in mysql_delete (thd=0xa0c0f70, table_list=0x9f57080, conds=0x9f57530, order_list=0xa0c24c8, limit=4, options=) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_delete.cc:297 will_batch = false error = 0 loc_error = table = (TABLE *) 0xa695b690 select = (SQL_SELECT *) 0x9f57690 info = { table = 0xa695b690, file = 0xa6943698, forms = 0xa95fe38c, unlock_row = 0x81bdc20 , read_record = 0x837e510 , thd = 0xa0c0f70, select = 0x9f57690, cache_records = 0, ref_length = 4, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0xa69437f0 "ÿÿÿ", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, io_cache = 0x0, print_error = true, ignore_not_found_rows = false } using_limit = true transactional_table = safe_update = false const_cond = const_cond_result = deleted = 0 reverse = false order = (ORDER *) 0x0 usable_index = select_lex = (SELECT_LEX *) 0xa0c23e8 killed_status = query_type = __FUNCTION__ = "mysql_delete" #14 0x081a0a01 in mysql_execute_command (thd=0xa0c0f70) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2916 res = 0 up_result = lex = (LEX *) 0xa0c1f4c select_lex = (SELECT_LEX *) 0xa0c23e8 first_table = (TABLE_LIST *) 0x9f57080 all_tables = (TABLE_LIST *) 0x9f57080 unit = (SELECT_LEX_UNIT *) 0xa0c1fb0 have_table_map_for_update = __FUNCTION__ = "mysql_execute_command" #15 0x081a4361 in mysql_parse (thd=0xa0c0f70, rawbuf=0x9f56fb8 "DELETE FROM `E` WHERE `pk` < 4 LIMIT 4", length=38, parser_state=0xa95ff110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0xa0c1f4c err = __FUNCTION__ = "mysql_parse" #16 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0xa0c0f70, packet=0xa010ef1 "DELETE FROM `E` WHERE `pk` < 4 LIMIT 4", packet_length=38) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0xa0c0f70, yylineno = 1, yytoklen = 1, yylval = 0xa95fec00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x9f56fdf ") VALUES ( 6 )", m_tok_start = 0x9f56fdf ") VALUES ( 6 )", m_tok_end = 0x9f56fdf ") VALUES ( 6 )", m_end_of_query = 0x9f56fde "", m_tok_start_prev = 0x9f56fde "", m_buf = 0x9f56fb8 "DELETE FROM `E` WHERE `pk` < 4 LIMIT 4", m_buf_length = 38, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x9f57020 "DELETE FROM `E` WHERE `pk` < 4 LIMIT 4", m_cpp_ptr = 0x9f57046 "", m_cpp_tok_start = 0x9f57046 "", m_cpp_tok_start_prev = 0x9f57046 "", m_cpp_tok_end = 0x9f57046 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 2841637532, m_cpp_text_start = 0x9f57045 "4", m_cpp_text_end = 0x9f57046 "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #17 0x081a65df in do_command (thd=0xa0c0f70) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0xa010ef0 "\003DELETE FROM `E` WHERE `pk` < 4 LIMIT 4" packet_length = net = (NET *) 0xa0c10a0 command = COM_QUERY #18 0x082448fd in do_handle_one_connection (thd_arg=0xa0c0f70) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0xa0c0f70 #19 0x082449df in handle_one_connection (arg=0xa0c0f70) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #20 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #21 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 18 (process 9842): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=3077350132) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bc0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 0 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 17 (process 9851): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2852156148) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992be4) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 9 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 16 (process 10802): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a60fb in read () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x085c0b18 in vio_read (vio=0xa0006e0, buf=0xa0929f0 "\001", size=4) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/vio/viosocket.c:44 No locals. #3 0x0812862b in my_real_read (net=0x9f9abc8, complen=0xa956c318) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/net_serv.cc:841 pos = (uchar *) 0xa0929f0 "\001" length = i = 0 retry_count = 0 len = 4294967295 alarmed = 1 '\001' net_blocking = 0 '\0' remain = 4 #4 0x08128a3b in my_net_read (net=0x9f9abc8) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/net_serv.cc:1038 len = complen = #5 0x081a6581 in do_command (thd=0x9f9aa98) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:715 return_value = packet = packet_length = net = (NET *) 0x9f9abc8 command = #6 0x082448fd in do_handle_one_connection (thd_arg=0x9f9aa98) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0x9f9aa98 #7 0x082449df in handle_one_connection (arg=0x9f9aa98) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #8 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #9 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 15 (process 9847): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2885726964) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bd4) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 5 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 14 (process 9848): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2877334260) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bd8) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 6 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 13 (process 9846): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2894119668) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bd0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 4 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 12 (process 9844): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2910905076) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bc8) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 2 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 11 (process 9845): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2902512372) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bcc) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 3 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 10 (process 10783): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a30e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x085330de in os_event_wait_low (event=0x98ddb80, reset_sig_count=11355) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0sync.c:140 old_signal_count = 11355 #3 0x08477603 in sync_array_wait_event (arr=0x98948b8, index=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/sync/sync0arr.c:457 cell = (sync_cell_t *) 0xb6d6c008 event = (os_event_t) 0x98ddb80 #4 0x084792d5 in mutex_spin_wait (mutex=0x98ddb38, file_name=0x868d680 "/export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0srv.c", line=1643) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/sync/sync0sync.c:621 index = 0 i = 0 #5 0x08472bbd in srv_suspend_mysql_thread (thr=0xa5f5f370) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/include/sync0sync.ic:222 slot = (srv_slot_t *) 0xb6cf60a8 event = (os_event_t) 0x99d2d50 wait_time = trx = (trx_t *) 0x9fedfa0 had_dict_lock = 0 was_declared_inside_innodb = 0 start_time = 1289790155540456 finish_time = diff_time = sec = 1289790155 ms = 540456 lock_wait_timeout = #6 0x0845487b in row_mysql_handle_errors (new_err=0xa60fdf5c, trx=0x9fedfa0, thr=0xa5f5f370, savept=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/row/row0mysql.c:594 err = 15 #7 0x084610e9 in row_search_for_mysql (buf=0xa69651f8 "ÿÿÿÿ", mode=2, prebuilt=0xa6941158, match_mode=0, direction=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/row/row0sel.c:4563 index = (dict_index_t *) 0xa6311c20 comp = 1 search_tuple = (const dtuple_t *) 0xa698e190 pcur = (btr_pcur_t *) 0xa67cbd40 trx = (trx_t *) 0x9fedfa0 clust_index = (dict_index_t *) 0xa6311c20 thr = (que_thr_t *) 0xa5f5f370 rec = (const rec_t *) 0xa60fd8b8 "ÈØ\017¦Ì*" result_rec = ( const rec_t *) 0x88b98c0 "´k\213\bp&\216·à\207\215·\020?y·P0\212·`ú\211· 3\212·p)z·°\001\212·Ð\222o·ö\235\021\b \az·\200?\212·&\236\021\bP\002\212·\020Óo·V\236\021\bP¥r·v\236\021\b\206\236\021\bPw\212·¦\236\021\bPHt·" clust_rec = ( const rec_t *) 0x88b98c0 "´k\213\bp&\216·à\207\215·\020?y·P0\212·`ú\211· 3\212·p)z·°\001\212·Ð\222o·ö\235\021\b \az·\200?\212·&\236\021\bP\002\212·\020Óo·V\236\021\bP¥r·v\236\021\b\206\236\021\bPw\212·¦\236\021\bPHt·" err = 15 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = 0 moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = 2786056392 next_offs = 10956 same_user_rec = 1 mtr = { memo = { heap = 0x0, used = 24, data = "7\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000HS\226¦8³\031\n\001\000\000\000\005\000\000\000¬Ï\213\b\b\211\a\nøÙ\017¦1\034,\b\b\211\a\nHS\226¦¸\203\a\n\000\000\000\000T\212\a\n\004\000\000\000¨Ù\017¦\004;,\b\002\000\000\000\000\212\a\nÈÙ\017¦Hñ.\b\000\212\a\n|à\017¦8³\031\nÀ\230\213\b\000\212\a\n \211\a\nØÙ\017¦\020ò.\b\000\212\a\n\000\212\a\nøÙ\017¦rõ.\b\000\212\a\n\001\000\000\000øÙ\017¦ô\026\023\bÀ\230\213\b\000\000\000\000\210Û\017¦6, 168267720, 168267600, 2, 168267768, 2, 168267352, 2786057784, 136965704, 2794869752, 168265832, 2786057816, 137036207, 2794869752, 4294967295, 1, 5, 143380396, 168265832, 2786057832, 137358361, 168266824, 2794869752, 2786057864, 137168408, 168266920, 4, 1, 2, 10, 168267192, 2786057896, 137294485, 168267192, 1, 11, 2898692, 2, 168267192, 2786057928, 137294152, 168267192, 169456440, 168267280, 143366336, 168267192, 168267048, 2786057944, 138764385, 168267192, 0, 2786058344, 137313334, 168267192, 1, 3, 143366336, 4, 2795037096, 2786058104, 138797952, 2795037096, 2794662032, 0, 2786700056, 4, 1, 3078690568, 141086152, 141086080} offsets = (ulint *) 0xa60fdd94 table_lock_waited = 0 #8 0x0843df10 in ha_innobase::index_read (this=0xa69650a0, buf=0xa69651f8 "ÿÿÿÿ", key_ptr=0xa619ab18 "\002", key_len=4, find_flag=HA_READ_KEY_OR_NEXT) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:5653 mode = 2 index = match_mode = 0 error = ret = #9 0x082ae481 in handler::index_read_map (this=0xa69650a0, buf=0xa69651f8 "ÿÿÿÿ", key=0xa619ab18 "\002", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.h:1488 key_len = #10 0x082a7c5f in handler::read_range_first (this=0xa69650a0, start_key=0xa5f04290, end_key=0x0, eq_range_arg=false, sorted=false) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:4258 result = #11 0x082a7dad in handler::read_multi_range_first (this=0xa69650a0, found_range_p=0xa60fe08c, ranges=0xa5f04290, range_count=1, sorted=false, buffer=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:4132 result = #12 0x08365c07 in QUICK_RANGE_SELECT::get_next (this=0xa6727140) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/opt_range.cc:8692 count = 1 mrange_slot = (KEY_MULTI_RANGE *) 0xa5f04290 mrange_end = (KEY_MULTI_RANGE *) 0xa5f042b8 result = mrange = (KEY_MULTI_RANGE *) 0x8172ae1 #13 0x0837e534 in rr_quick (info=0xa60fe390) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/records.cc:335 tmp = -1508908144 #14 0x08214f72 in mysql_update (thd=0xa19b338, table_list=0xa0783b8, fields=@0xa19c844, values=@0xa19ca58, conds=0xa078f50, order_num=1, order=0xa0790e0, limit=2, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xa60fec48, updated_return=0xa60fec40) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_update.cc:533 tempfile = { pos_in_file = 0, end_of_file = 18446744073709551615, read_pos = 0xa5f6e438 "", read_end = 0xa60fe3fc "À\230\213\b", buffer = 0xa5f6e438 "", request_pos = 0xa5f6e438 "", write_buffer = 0xa5f6e438 "", append_read_pos = 0x519
, write_pos = 0xa5f6e438 "", write_end = 0xa5f7e438 "\b", current_pos = 0xa60fe1b8, current_end = 0xa60fe1bc, append_buffer_lock = { m_mutex = { __m_reserved = 0, __m_count = 160035550, __m_owner = 0xa60fe400, __m_kind = 168266280, __m_lock = { __status = 168264552, __spinlock = 1163280723 } }, m_psi = 0x4e494f50 }, share = 0x0, read_function = 0x856d780 <_my_b_read>, write_function = 0x856f0e0 <_my_b_write>, type = WRITE_CACHE, pre_read = 0, post_read = 0, pre_close = 0, disk_writes = 0, arg = 0x0, file_name = 0x0, dir = 0xa6925260 "/tmp/bug55543/tmp", prefix = 0xa6773870 "MY", file = -1, seek_not_done = 0, error = 0, buffer_length = 65536, read_length = 65536, myflags = 16, alloced_buffer = 1 '\001' } safe_update = used_key_is_modified = false transactional_table = will_batch = res = error = 0 loc_error = used_index = dup_key_found = need_sort = false reverse = false want_privilege = 0 table_count = 1 updated = found = table = (TABLE *) 0xa69ad900 select = (SQL_SELECT *) 0xa079218 info = { table = 0xa69ad900, file = 0xa69650a0, forms = 0xa60fe390, unlock_row = 0x81bdc20 , read_record = 0x837e510 , thd = 0xa19b338, select = 0xa079218, cache_records = 0, ref_length = 4, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0xa69651f8 "ÿÿÿÿ", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, io_cache = 0x0, print_error = true, ignore_not_found_rows = false } select_lex = (SELECT_LEX *) 0xa19c7b0 id = all_fields = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa60fe3ec, elements = 0 }, } killed_status = __FUNCTION__ = "mysql_update" #15 0x081a0820 in mysql_execute_command (thd=0xa19b338) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2702 found = 0 updated = 0 res = up_result = lex = (LEX *) 0xa19c314 select_lex = (SELECT_LEX *) 0xa19c7b0 first_table = (TABLE_LIST *) 0xa0783b8 all_tables = (TABLE_LIST *) 0xa0783b8 unit = (SELECT_LEX_UNIT *) 0xa19c378 have_table_map_for_update = false __FUNCTION__ = "mysql_execute_command" #16 0x081a4361 in mysql_parse (thd=0xa19b338, rawbuf=0xa078250 "UPDATE `CC` SET `col_int_key` = `col_int_key` + IF(`pk` % 2 = 1 , 20, -20) WHERE `pk` >= 2 ORDER BY `pk` ASC LIMIT 2", length=116, parser_state=0xa60ff110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0xa19c314 err = __FUNCTION__ = "mysql_parse" #17 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0xa19b338, packet=0x9f1df61 " UPDATE `CC` SET `col_int_key` = `col_int_key` + IF(`pk` % 2 = 1 , 20, -20) WHERE `pk` >= 2 ORDER BY `pk` ASC LIMIT 2 ", packet_length=118) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0xa19b338, yylineno = 1, yytoklen = 1, yylval = 0xa60fec00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0xa0782c5 "Ç\031\nA", m_tok_start = 0xa0782c5 "Ç\031\nA", m_tok_end = 0xa0782c5 "Ç\031\nA", m_end_of_query = 0xa0782c4 "", m_tok_start_prev = 0xa0782c4 "", m_buf = 0xa078250 "UPDATE `CC` SET `col_int_key` = `col_int_key` + IF(`pk` % 2 = 1 , 20, -20) WHERE `pk` >= 2 ORDER BY `pk` ASC LIMIT 2", m_buf_length = 116, m_echo = true, m_echo_saved = false, m_cpp_buf = 0xa078308 "UPDATE `CC` SET `col_int_key` = `col_int_key` + IF(`pk` % 2 = 1 , 20, -20) WHERE `pk` >= 2 ORDER BY `pk` ASC LIMIT 2", m_cpp_ptr = 0xa07837c "", m_cpp_tok_start = 0xa07837c "", m_cpp_tok_start_prev = 0xa07837c "", m_cpp_tok_end = 0xa07837c "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 2786063004, m_cpp_text_start = 0xa07837b "2", m_cpp_text_end = 0xa07837c "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #18 0x081a65df in do_command (thd=0xa19b338) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0x9f1df60 "\003 UPDATE `CC` SET `col_int_key` = `col_int_key` + IF(`pk` % 2 = 1 , 20, -20) WHERE `pk` >= 2 ORDER BY `pk` ASC LIMIT 2 " packet_length = net = (NET *) 0xa19b468 command = COM_QUERY #19 0x082448fd in do_handle_one_connection (thd_arg=0xa19b338) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0xa19b338 #20 0x082449df in handle_one_connection (arg=0xa19b338) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #21 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #22 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 9 (process 11156): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a3412 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x0824c711 in MDL_wait::timed_wait (this=0x9f5ef44, thd=0x9f5eee0, abs_timeout=0xa6a61840, set_status_on_timeout=true, wait_state_name=0x8632138 "Waiting for table metadata lock") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/include/mysql/psi/mysql_thread.h:1009 old_msg = 0x8623e86 "Opening tables" wait_result = 0 #3 0x0824d8bc in MDL_context::acquire_lock (this=0x9f5ef44, mdl_request=0xa1916f8, lock_wait_timeout=) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mdl.cc:1788 lock = (MDL_lock *) 0xa6784948 ticket = (MDL_ticket *) 0x9f7f318 abs_timeout = { tv_sec = 1321326206, tv_nsec = 543861000 } wait_status = 167244568 #4 0x0815e3fa in open_table_get_mdl_lock (thd=0x9f5eee0, ot_ctx=0xa6a61f3c, mdl_request=0xa1916f8, flags=0, mdl_ticket=0xa6a61e84) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:2521 mdl_deadlock_handler = { = { _vptr.Internal_error_handler = 0x88bd028, m_prev_internal_handler = 0x0 }, members of MDL_deadlock_handler: m_ot_ctx = 0xa6a61f3c, m_is_active = false } result = mdl_request_shared = { type = 2795903672, next_in_list = 0x896aa00, prev_in_list = 0x8978440, ticket = 0x0, key = { m_length = 24, m_db_name_length = 0, m_ptr = "7\000\000\000À\230\213\b°ùZ\b,\031¦¦H\031¦¦Ú$\026\bÀ\214\227\b°`+\ny\030\031\nrrect date value: 'xlxtqtgn%' for column 'col_daÐÐ\213\b\020Ì\227\b' at \001\001\001ÁùZ\bÿ\000\000\000\b\000\000\000X\031¦¦úd+\b\t\000\000\000Xa\213\t\000ª\226\b@\204\227\b\200\227\220\b¸5n©\b\000\000\000À\230\213\b´Ü\231¦¨é\023¦h\031¦¦Z\034\026\bÀ\214\227\b@\024\031\nJ>b\bÀ\217\227\b\020Ì\227\b\000\000\000\001x\030\031\nÀ\230\213\b"..., static m_namespace_to_wait_state_name = {0x86320f0 "Waiting for global metadata lock", 0x8632114 "Waiting for schema metadata lock", 0x8632138 "Waiting for table metadata lock", 0x8632158 "Waiting for stored function metadata lock", 0x8632184 "Waiting for stored procedure metadata lock", 0x0} } } #5 0x0816655f in open_table (thd=0x9f5eee0, table_list=0xa1914f8, mem_root=0xa6a61f1c, ot_ctx=0xa6a61f3c) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:2827 table = (TABLE *) 0x0 key = "test\000r\000\001\000\000\0000\000\000\000®\030\n\b°\030\nä\a\000\000À\230\213\bð®\030\n|\tö\t\030\035¦¦\034)\030\b|\tö\t\b\000\000\000àjb\b\002\000\000\000¬\035¦¦¬\035¦¦\234\tö\tÀ\230\213\b\000\000\000\000¬\035¦¦X\035¦¦z(\027\b|\tö\tàîõ\t\024\005\000\000àjb\b\002\000\000\000¬\035¦¦ñ\037¦¦\000\000\000\000ô¿\202·\000\000\000\000\000\000\000\000À\230\213\bQës·\024\005\000\000\210\035¦¦«Ç\021\bàîõ\t\024\005\000\000àjb\b\002\000\000\000 Ô\202·\216ü\200·\b\027\201·.æ\200·zå\200·\024\005\000\000¸\037"... key_length = 7 alias = 0xa1914f0 "r" flags = mdl_ticket = error = share = hash_value = #6 0x08167a1d in open_tables (thd=0x9f5eee0, start=0xa6a61fc4, counter=0xa6a61fa8, flags=0, prelocking_strategy=0xa6a62404) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:4333 table_to_open = (TABLE_LIST **) 0xa6a61fc4 sroutine_to_open = (Sroutine_hash_entry **) 0x9f5ff08 tables = (TABLE_LIST *) 0xa1914f8 ot_ctx = { m_failed_table = 0x0, m_start_of_statement_svp = 0x0, m_timeout = 31536000, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false } error = 166 new_frm_mem = { free = 0xa0167d0, used = 0x0, pre_alloc = 0xa0167d0, min_malloc = 32, block_size = 7996, block_num = 4, first_block_usage = 0, error_handler = 0x8226a00 } has_prelocking_list = false __FUNCTION__ = "open_tables" #7 0x08167fee in open_and_lock_tables (thd=0x9f5eee0, tables=0xa1914f8, derived=true, flags=0, prelocking_strategy=0xa6a62404) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:5357 counter = mdl_savepoint = (class MDL_ticket *) 0x0 #8 0x08199cdc in execute_sqlcom_select (thd=0x9f5eee0, all_tables=0xa1914f8) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.h:476 lex = (LEX *) 0x9f5febc result = (class select_result *) 0x0 res = #9 0x0819f1c1 in mysql_execute_command (thd=0x9f5eee0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2065 privileges_requested = res = 0 up_result = lex = (LEX *) 0x9f5febc select_lex = (SELECT_LEX *) 0x9f60358 first_table = (TABLE_LIST *) 0xa1914f8 all_tables = (TABLE_LIST *) 0xa1914f8 unit = (SELECT_LEX_UNIT *) 0x9f5ff20 have_table_map_for_update = __FUNCTION__ = "mysql_execute_command" #10 0x081a4361 in mysql_parse (thd=0x9f5eee0, rawbuf=0xa1913a8 "SELECT `F1` FROM `r`", length=20, parser_state=0xa6a63110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0x9f5febc err = __FUNCTION__ = "mysql_parse" #11 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0x9f5eee0, packet=0xa1136c1 "SELECT `F1` FROM `r`", packet_length=20) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0x9f5eee0, yylineno = 1, yytoklen = 1, yylval = 0xa6a62c00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0xa1913bd "date_key` = CONVERT( 'then' USING UCS2 ) WHERE `col_datetime_key` ISELECT `F1` FROM `r`", m_tok_start = 0xa1913bd "date_key` = CONVERT( 'then' USING UCS2 ) WHERE `col_datetime_key` ISELECT `F1` FROM `r`", m_tok_end = 0xa1913bd "date_key` = CONVERT( 'then' USING UCS2 ) WHERE `col_datetime_key` ISELECT `F1` FROM `r`", m_end_of_query = 0xa1913bc "", m_tok_start_prev = 0xa1913bc "", m_buf = 0xa1913a8 "SELECT `F1` FROM `r`", m_buf_length = 20, m_echo = true, m_echo_saved = false, m_cpp_buf = 0xa191400 "SELECT `F1` FROM `r`", m_cpp_ptr = 0xa191414 "", m_cpp_tok_start = 0xa191414 "", m_cpp_tok_start_prev = 0xa191414 "", m_cpp_tok_end = 0xa191414 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 2795909788, m_cpp_text_start = 0xa191412 "r`", m_cpp_text_end = 0xa191413 "`", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #12 0x081a65df in do_command (thd=0x9f5eee0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0xa1136c0 "\003SELECT `F1` FROM `r`" packet_length = net = (NET *) 0x9f5f010 command = COM_QUERY #13 0x082448fd in do_handle_one_connection (thd_arg=0x9f5eee0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0x9f5eee0 #14 0x082449df in handle_one_connection (arg=0x9f5eee0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #15 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #16 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 8 (process 10599): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a3412 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x0824c711 in MDL_wait::timed_wait (this=0xa0e47bc, thd=0xa0e4758, abs_timeout=0xa9741038, set_status_on_timeout=false, wait_state_name=0x8632138 "Waiting for table metadata lock") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/include/mysql/psi/mysql_thread.h:1009 old_msg = 0x8623e86 "Opening tables" wait_result = 0 #3 0x0824d77d in MDL_context::acquire_lock (this=0xa0e47bc, mdl_request=0x9f235f0, lock_wait_timeout=) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mdl.cc:1772 abs_shortwait = { tv_sec = 1289790206, tv_nsec = 707465000 } lock = (MDL_lock *) 0xa6784948 ticket = (MDL_ticket *) 0xa6904e90 abs_timeout = { tv_sec = 1321326155, tv_nsec = 607691000 } wait_status = MDL_wait::EMPTY #4 0x0824dab3 in MDL_context::acquire_locks (this=0xa0e47bc, mdl_requests=0xa97412b0, lock_wait_timeout=31536000) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mdl.cc:1882 sort_buf = (MDL_request **) 0xa6770bf0 p_req = (MDL_request **) 0xa6770bf8 mdl_svp = (MDL_ticket *) 0x0 #5 0x0815e970 in lock_table_names (thd=0xa0e4758, tables_start=0x9f233f0, tables_end=0x0, lock_wait_timeout=31536000, flags=5605) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:4554 mdl_requests = { = { m_counter = 3 }, > = {}, members of I_P_List, I_P_List_counter, I_P_List_no_push_back >: m_first = 0xa97410e4 } table = global_request = { type = MDL_INTENTION_EXCLUSIVE, next_in_list = 0x9f23880, prev_in_list = 0xa97412b4, ticket = 0xa69c20e8, key = { m_length = 3, m_db_name_length = 0, m_ptr = "\000\000\000©*\033t©è\022t©ø\022t©d\000\000\000\002\000\000\000\000\000\000\000\001\000\000\000nul\000\000\000\000\001h7ò\t7\021t©\216ü\200·\b\027\201·¡å\200·zå\200·frm\000\020\000\220¦%\002\000\000¬\021t©\000\000\000\000<\000\220¦<\000\220¦\000\000\000\000@\000\220¦(\000\000\000@\210\212·\210Ö\215\t¨\021t©ëÍs·ô¿\202·L\023t©h\037\000\0004\022t©\215ìs·\000\000\000\000tÝs·O\\$\bÀ\230\213\bÈ1\a\n¨\021t©b\027\024\b@\224s¦\216ü\200·\b\027\201·.æ\200·zå\200·\b\027\201·¡å\200·x^÷¥"..., static m_namespace_to_wait_state_name = {0x86320f0 "Waiting for global metadata lock", 0x8632114 "Waiting for schema metadata lock", 0x8632138 "Waiting for table metadata lock", 0x8632158 "Waiting for stored function metadata lock", 0x8632184 "Waiting for stored procedure metadata lock", 0x0} } } schema_set = { m_hash = { key_offset = 0, key_length = 0, blength = 2, records = 1, flags = 0, array = { buffer = 0xa69368b8 "ÿÿÿÿð3ò\t", elements = 1, max_element = 8, alloc_increment = 1023, size_of_element = 8 }, get_key = 0x815bf60 , free = 0, charset = 0x8909780 } } #6 0x08167c3c in open_tables (thd=0xa0e4758, start=0xa97413f4, counter=0xa97413d8, flags=0, prelocking_strategy=0xa9741418) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:4731 table = table_to_open = (TABLE_LIST **) 0x88b98c0 sroutine_to_open = (Sroutine_hash_entry **) 0x0 tables = ot_ctx = { m_failed_table = 0x0, m_start_of_statement_svp = 0x0, m_timeout = 31536000, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false } error = 139 new_frm_mem = { free = 0xa5fb8008, used = 0x0, pre_alloc = 0xa5fb8008, min_malloc = 32, block_size = 7996, block_num = 4, first_block_usage = 0, error_handler = 0x8226a00 } has_prelocking_list = false __FUNCTION__ = "open_tables" #7 0x08167fee in open_and_lock_tables (thd=0xa0e4758, tables=0x9f233f0, derived=false, flags=0, prelocking_strategy=0xa9741418) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:5357 counter = mdl_savepoint = (class MDL_ticket *) 0x0 #8 0x082015bf in mysql_create_table (thd=0xa0e4758, create_table=0x9f233f0, create_info=0xa97418a0, alter_info=0xa9741500) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.h:476 result = is_trans = false #9 0x081a3e0b in mysql_execute_command (thd=0xa0e4758) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2481 link_to_local = select_tables = (TABLE_LIST *) 0x0 create_info = { table_charset = 0x0, default_table_charset = 0x0, connect_string = { str = 0x0, length = 0 }, password = 0x0, tablespace = 0x0, comment = { str = 0x0, length = 0 }, data_file_name = 0x0, index_file_name = 0x0, alias = 0x9f233e8 "r", max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 0, avg_row_length = 0, used_fields = 0, key_block_size = 0, merge_list = { = {}, members of SQL_I_List: elements = 0, first = 0x0, next = 0xa97418f8 }, db_type = 0x9894770, row_type = ROW_TYPE_DEFAULT, null_bits = 0, options = 2, merge_insert_method = 0, extra_size = 0, unused1 = HA_CHOICE_UNDEF, frm_only = false, varchar = false, storage_media = HA_SM_DEFAULT, unused2 = HA_CHOICE_UNDEF } alter_info = { drop_list = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa9741500, elements = 0 }, }, alter_list = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa974150c, elements = 0 }, }, key_list = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa9741518, elements = 0 }, }, create_list = { = { = {}, members of base_list: first = 0x9f23810, last = 0x9f23810, elements = 1 }, }, flags = 0, keys_onoff = LEAVE_AS_IS, tablespace_op = NO_TABLESPACE_OP, partition_names = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa974153c, elements = 0 }, }, num_parts = 0, change_level = ALTER_TABLE_METADATA_ONLY, datetime_field = 0x0, error_if_not_empty = false } res = 0 up_result = lex = (LEX *) 0xa0e5734 select_lex = (SELECT_LEX *) 0xa0e5bd0 first_table = (TABLE_LIST *) 0x9f233f0 all_tables = (TABLE_LIST *) 0x9f233f0 unit = (SELECT_LEX_UNIT *) 0xa0e5798 have_table_map_for_update = __FUNCTION__ = "mysql_execute_command" #10 0x081a4361 in mysql_parse (thd=0xa0e4758, rawbuf=0x9f23328 "CREATE TABLE IF NOT EXISTS r (F1 INTEGER)", length=41, parser_state=0xa9742110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0xa0e5734 err = __FUNCTION__ = "mysql_parse" #11 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0xa0e4758, packet=0xa1306e9 "CREATE TABLE IF NOT EXISTS r (F1 INTEGER)", packet_length=41) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0xa0e4758, yylineno = 1, yytoklen = 2, yylval = 0xa9741c00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x9f23352 "ROM information_schema.collations", m_tok_start = 0x9f23352 "ROM information_schema.collations", m_tok_end = 0x9f23352 "ROM information_schema.collations", m_end_of_query = 0x9f23351 "", m_tok_start_prev = 0x9f23351 "", m_buf = 0x9f23328 "CREATE TABLE IF NOT EXISTS r (F1 INTEGER)", m_buf_length = 41, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x9f23390 "CREATE TABLE IF NOT EXISTS r (F1 INTEGER)", m_cpp_ptr = 0x9f233b9 "", m_cpp_tok_start = 0x9f233b9 "", m_cpp_tok_start_prev = 0x9f233b9 "", m_cpp_tok_end = 0x9f233b9 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 2842960540, m_cpp_text_start = 0x9f233ae "F1 INTEGER)", m_cpp_text_end = 0x9f233b0 " INTEGER)", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #12 0x081a65df in do_command (thd=0xa0e4758) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0xa1306e8 "\003CREATE TABLE IF NOT EXISTS r (F1 INTEGER)" packet_length = net = (NET *) 0xa0e4888 command = COM_QUERY #13 0x082448fd in do_handle_one_connection (thd_arg=0xa0e4758) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0xa0e4758 #14 0x082449df in handle_one_connection (arg=0xa0e4758) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #15 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #16 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 7 (process 9839): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb77a6c07 in poll () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #2 0x08123f06 in handle_connections_sockets () at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mysqld.cc:5102 sock = 13 new_sock = 144165980 error_count = 0 thd = (class THD *) 0xa1af1a0 cAddr = { ss_family = 2, __ss_align = 16777343, __ss_padding = "\000\000\000\000\000\000\000\000\221\223àLÀ\230\213\bðû\230\b\000\000\000\000x\r\234¿;\0204\b\002\000\000\000?\005\212\tä\r\234¿\000\000\000\000\000\000\000\000À\230\213\b\230\r\234¿%u3\b\000M\211\t\002\000\000\000?\005\212\tä\r\234¿Î\t\212·\\Ì\227\b¸\r\234¿\225y3\bÀû\230\b\002\000\000\000\003\000\000\000ä\r\234¿\\ \212·À\230\213\b" } flags = 2 retval = vio_tmp = socket_count = fds = {{ fd = 13, events = 1, revents = 0 }, { fd = 14, events = 1, revents = 0 }} #3 0x0812665e in mysqld_main (argc=42, argv=0x9894240) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mysqld.cc:4572 ho_error = 0 all_early_options = { buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 25, size_of_element = 72 } #4 0x0811ade2 in main (argc=Cannot access memory at address 0x2 ) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/main.cc:24 No locals. Thread 6 (process 9857): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a7300 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x0811f484 in signal_hand (arg=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mysqld.cc:2704 error = -4 set = { __val = {548869, 0 } } sig = 135393883 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 5 (process 9855): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb77a98d1 in select () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #2 0x08533d6a in os_thread_sleep (tm=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/os/os0thread.c:274 t = { tv_sec = 1, tv_usec = 425313 } #3 0x08471ba6 in srv_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0srv.c:2082 time_elapsed = 0 current_time = 1289790203 last_table_monitor_time = 1289786257 last_tablespace_monitor_time = 1289786257 last_monitor_time = 1289790192 mutex_skipped = 0 last_srv_print_monitor = 0 #4 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #5 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 4 (process 9850): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2860548852) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992be0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 8 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 3 (process 9843): #0 0xb789676a in ?? () from /lib/libaio.so.1 No symbol table info available. #1 0x084f0925 in fil_aio_wait (segment=2919297780) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/fil/fil0fil.c:4455 ret = fil_node = message = type = #2 0x08474173 in io_handler_thread (arg=0x8992bc4) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/srv/srv0start.c:494 segment = 1 #3 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #4 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 2 (process 10809): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a3412 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x0824c711 in MDL_wait::timed_wait (this=0x9fc857c, thd=0x9fc8518, abs_timeout=0xa9539980, set_status_on_timeout=true, wait_state_name=0x8632138 "Waiting for table metadata lock") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/include/mysql/psi/mysql_thread.h:1009 old_msg = 0x8623e86 "Opening tables" wait_result = 0 #3 0x0824d8bc in MDL_context::acquire_lock (this=0x9fc857c, mdl_request=0xa063b70, lock_wait_timeout=) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mdl.cc:1788 lock = (MDL_lock *) 0xa6784948 ticket = (MDL_ticket *) 0xa69f4058 abs_timeout = { tv_sec = 1321326155, tv_nsec = 694163000 } wait_status = 2795454552 #4 0x0815e3fa in open_table_get_mdl_lock (thd=0x9fc8518, ot_ctx=0xa953a07c, mdl_request=0xa063b70, flags=0, mdl_ticket=0xa9539fc4) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:2521 mdl_deadlock_handler = { = { _vptr.Internal_error_handler = 0x88bd028, m_prev_internal_handler = 0xa953a094 }, members of MDL_deadlock_handler: m_ot_ctx = 0xa953a07c, m_is_active = false } result = mdl_request_shared = { type = 2795489872, next_in_list = 0xa95399f8, prev_in_list = 0x81825b7, ticket = 0xa69fcb40, key = { m_length = 39644, m_db_name_length = 43347, m_ptr = "H\232S©À\230\213\bð\000\000\000\"\000\000\000À\214\227\bd\224W\bPÊ\237¦´\237ü\t\030\232S©~&\030\bPÊ\237¦hË\237¦ä\a\000\000À\230\213\bPÊ\237¦´\237ü\tH\232S©\034)\030\b´\237ü\t\b\000\000\000t¨b\b\002\000\000\000Ü\232S©Ü\232S©Ô\237ü\tÀ\230\213\b\000\000\000\000Ü\232S©\210\232S©z(\027\b´\237ü\t\030\205ü\t\036\004\000\000t¨b\b\002\000\000\000Ü\232S©(Bb\b\000\000\000\000|\205ü\t 2\006\n\000\000\000\000À\230\213\b\030\205ü\t\036\004\000\000¸\232S©«Ç\021\b\030\205ü\t\036\004\000\000t¨b\b\002\000\000\000"..., static m_namespace_to_wait_state_name = {0x86320f0 "Waiting for global metadata lock", 0x8632114 "Waiting for schema metadata lock", 0x8632138 "Waiting for table metadata lock", 0x8632158 "Waiting for stored function metadata lock", 0x8632184 "Waiting for stored procedure metadata lock", 0x0} } } #5 0x0816655f in open_table (thd=0x9fc8518, table_list=0xa063970, mem_root=0xa953a05c, ot_ctx=0xa953a07c) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:2827 table = (TABLE *) 0x0 key = "test\000r\000\001\000\000\000+\000\000\000\225ü\t\000\000\000\000hß!\nÀ\230\213\b\200ZP¦\b\000\004\000\005test\000c\000\030\205ü\tÀ\230\213\b\216ü\200·\b\027\201·¡å\200·zå\200·\206½u·\020\000\220¦e\000\000\000\000\000\000\000¸«g\b<\000\220¦<\000\220¦\000\000\000\000@\000\220¦0\000\000\000h7\006\n°8\006\nÈ\236S©ëÍs·ô¿\202·\\ S©h\037\000\000D\237S©\215ìs·\b\000\000\000\001\000\000\000À\230\213\bIg\"\bÀ\230\213\bÈ\236S©d\224W\b¸\004\227¦\216ü\200·\b\027\201·.æ\200·zå\200·\2104\006\n\030\237"... key_length = 7 alias = 0xa063d17 "r" flags = mdl_ticket = error = share = hash_value = #6 0x08167659 in open_tables (thd=0x9fc8518, start=0xa953a434, counter=0xa953a408, flags=0, prelocking_strategy=0xa953a190) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:4328 table_to_open = (TABLE_LIST **) 0xa062fec sroutine_to_open = (Sroutine_hash_entry **) 0x9fc9540 tables = (TABLE_LIST *) 0xa063970 ot_ctx = { m_failed_table = 0x0, m_start_of_statement_svp = 0xa6742db8, m_timeout = 31536000, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = true } error = false new_frm_mem = { free = 0xa69f9c58, used = 0x0, pre_alloc = 0xa69f9c58, min_malloc = 32, block_size = 7996, block_num = 4, first_block_usage = 0, error_handler = 0x8226a00 } has_prelocking_list = false __FUNCTION__ = "open_tables" #7 0x08213d8f in mysql_update (thd=0x9fc8518, table_list=0xa062fe8, fields=@0x9fc9a24, values=@0x9fc9c38, conds=0x0, order_num=1, order=0xa063730, limit=1, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xa953ac48, updated_return=0xa953ac40) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.h:455 safe_update = used_key_is_modified = transactional_table = will_batch = res = error = loc_error = used_index = dup_key_found = need_sort = true reverse = false want_privilege = table_count = 2 updated = found = table = select = info = { table = 0xa062fe8, file = 0x9fc8518, forms = 0xa953a3d8, unlock_row = 0x81994c0 , read_record = 0x9fc8518, thd = 0x4, select = 0xa062fe8, cache_records = 0, ref_length = 1, struct_length = 0, reclength = 0, rec_cache_size = 137659375, error_offset = 144166036, index = 0, ref_pos = 0x9fc8e34 "©\235a\bÈ_\026\n8fÿ\troot", record = 0x88b98c0 "´k\213\bp&\216·à\207\215·\020?y·P0\212·`ú\211· 3\212·p)z·°\001\212·Ð\222o·ö\235\021\b \az·\200?\212·&\236\021\bP\002\212·\020Óo·V\236\021\bP¥r·v\236\021\b\206\236\021\bPw\212·¦\236\021\bPHt·", rec_buf = 0xa062fe8 "", cache = 0x9fc8518 "HÓ\213\bèîõ\t\230ªù\tdÓ\213\bh7\006\n\224\237ü\t\003", cache_pos = 0xa953a408 "\002", cache_end = 0x819955b "\204ÀuY\203~p\001\031À÷Ð!ð\213v\004\205ö\017\204\204", read_positions = 0x9fc8518 "HÓ\213\bèîõ\t\230ªù\tdÓ\213\bh7\006\n\224\237ü\t\003", io_cache = 0x4, print_error = 232, ignore_not_found_rows = 47 } select_lex = id = all_fields = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa953a3ec, elements = 0 }, } killed_status = __FUNCTION__ = "mysql_update" #8 0x081a0820 in mysql_execute_command (thd=0x9fc8518) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2702 found = 0 updated = 0 res = up_result = lex = (LEX *) 0x9fc94f4 select_lex = (SELECT_LEX *) 0x9fc9990 first_table = (TABLE_LIST *) 0xa062fe8 all_tables = (TABLE_LIST *) 0xa062fe8 unit = (SELECT_LEX_UNIT *) 0x9fc9558 have_table_map_for_update = false __FUNCTION__ = "mysql_execute_command" #9 0x081a4361 in mysql_parse (thd=0x9fc8518, rawbuf=0xa062e88 "UPDATE `DD` SET `col_datetime_nokey` = LOAD_FILE('/randgen/randgen/data/earth1886kb.jpg') ORDER BY RAND() LIMIT 1", length=113, parser_state=0xa953b110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0x9fc94f4 err = __FUNCTION__ = "mysql_parse" #10 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0x9fc8518, packet=0xa08e9e1 "UPDATE `DD` SET `col_datetime_nokey` = LOAD_FILE('/randgen/randgen/data/earth1886kb.jpg') ORDER BY RAND() LIMIT 1", packet_length=113) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0x9fc8518, yylineno = 1, yytoklen = 1, yylval = 0xa953ac00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0xa062efa "pg') )", m_tok_start = 0xa062efa "pg') )", m_tok_end = 0xa062efa "pg') )", m_end_of_query = 0xa062ef9 "", m_tok_start_prev = 0xa062ef9 "", m_buf = 0xa062e88 "UPDATE `DD` SET `col_datetime_nokey` = LOAD_FILE('/randgen/randgen/data/earth1886kb.jpg') ORDER BY RAND() LIMIT 1", m_buf_length = 113, m_echo = true, m_echo_saved = false, m_cpp_buf = 0xa062f38 "UPDATE `DD` SET `col_datetime_nokey` = LOAD_FILE('/randgen/randgen/data/earth1886kb.jpg') ORDER BY RAND() LIMIT 1", m_cpp_ptr = 0xa062fa9 "", m_cpp_tok_start = 0xa062fa9 "", m_cpp_tok_start_prev = 0xa062fa9 "", m_cpp_tok_end = 0xa062fa9 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 3078683790, m_cpp_text_start = 0xa062fa8 "1", m_cpp_text_end = 0xa062fa9 "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #11 0x081a65df in do_command (thd=0x9fc8518) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0xa08e9e0 "\003UPDATE `DD` SET `col_datetime_nokey` = LOAD_FILE('/randgen/randgen/data/earth1886kb.jpg') ORDER BY RAND() LIMIT 1" packet_length = net = (NET *) 0x9fc8648 command = COM_QUERY #12 0x082448fd in do_handle_one_connection (thd_arg=0x9fc8518) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0x9fc8518 #13 0x082449df in handle_one_connection (arg=0x9fc8518) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #14 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #15 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. Thread 1 (process 11525): #0 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #1 0xb78a41c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #2 0x085854ab in my_write_core (sig=6) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/mysys/stacktrace.c:328 No locals. #3 0x0811cc6f in handle_segfault (sig=143366336) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/mysqld.cc:2511 curr_time = 1289790206 tm = { tm_sec = 26, tm_min = 3, tm_hour = 6, tm_mday = 15, tm_mon = 10, tm_year = 110, tm_wday = 1, tm_yday = 318, tm_isdst = 0, tm_gmtoff = 10800, tm_zone = 0x9895478 "GMT" } thd = #4 No symbol table info available. #5 0xb78c4430 in __kernel_vsyscall () No symbol table info available. #6 0xb76f86d0 in raise () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #7 0xb76fa098 in abort () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #8 0x08517b75 in lock_remove_all_on_table (table=0xa6536898, remove_also_table_sx_locks=1) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/lock/lock0lock.c:3666 lock = (ib_lock_t *) 0xa1518f0 prev_lock = (ib_lock_t *) 0x0 #9 0x0845819b in row_drop_table_for_mysql (name=0xa959a734 "test/t10#P#p0", trx=0xa96be9e0, drop_db=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/row/row0mysql.c:3252 foreign = table = (dict_table_t *) 0xa6536898 space_id = err = table_name = namelen = locked_dictionary = 1 info = #10 0x0844196a in ha_innobase::delete_table (this=0xa968d998, name=0xa959b19c "./test/t10#P#p0") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/storage/innobase/handler/ha_innodb.cc:7175 error = parent_trx = trx = (trx_t *) 0xa96be9e0 thd = (class THD *) 0xa1af1a0 norm_name = "test/t10#P#p0\000\t\nÜ*ð\t ê\t\nè\206`©H\000`©\030\000\000\000¸öi©\020\000`©\001\000\000\000¸öi©p>\000\000\001\000\000\000H\000`©Ð\a\000\000W\000\000\000\001\000\000\000\000\000\000\0000´4¦@\000`©@\000`©Qës·\000\000\000\000\000\000\000\000ô¿\202·\020\000`©¸öi©È§Y©¶æs·\\ \212·¸öi©\000\000`©\000\000\000\000\001\000\000\000`f\220\bاY©À\230\213\bÎ\t\212·\030\000\000\0008¨Y©\000\032X\b,\211\231\b¸öi©\003\000\000\000À\230\213\b\\ \212·,\211\231\b\005-\000\000"... #11 0x082ac381 in handler::ha_delete_table (this=0xa968d998, name=0xa959b19c "./test/t10#P#p0") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:3374 No locals. #12 0x08563a02 in ha_partition::del_ren_cre_table (this=0xa968d790, from=0xa959c12b "./test/t10", to=0x0, table_arg=0x0, create_info=0x0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/ha_partition.cc:1933 save_error = 0 error = 27 from_buff = "./test/t10#P#p0\000À\230\213\bì²Y©<\f\033\nرY©u\226W\b<\f\033\nì²Y©6\000\000\000]\022X\bÀ\230\213\b m[¦\b²Y©·%\030\b\220n[¦ì²Y©X²Y©À\230\213\bð\000\000\0006\000\000\000À\214\227\bd\224W\b m[¦<\f\033\n(²Y©~&\030\b m[¦Èn[¦\216ü\200·\b\027\201·¡å\200·zå\200·X²Y©\020\000`©\205\000\000\000\b\000\000\000àjb\b<\000`©<\000`©\000\000\000\000@\000`©@\000\000\000\000\000\000\000ì²Y©\230²Y©ëÍs·ô¿\202·"... to_buff = "À\230\213\b\005-\000\000\000\000\000\000\000\000\000\000À\230\213\b\000\000\000\000\030Áx¦\030°Y©/FJ\b Áx¦\n\000\000\000\2303i\b\000@\r\000\034´Y©\000\000\000\000Ȭh\b0y¨®\\ \212·", '\0' , "\001\000\000\000°\024½\tl\024½\tÀ\230\213\b", '\0' , "À\230\213\b\034´Y©\000\000\000\000\230²Y©ÁÄ\021\b0y¨®¸Àx¦puh©\004\000\000\000\210²Y©\204²Y©\200²Y©|²Y©ä²Y©0Ci\b\000\000\000\0008Áx¦ Áx¦\030Áx¦àÿÿÿ0y¨®\000\000\000\000\000\000\000\000"... from_lc_buff = "À\230\213\b\bpf©00d©Ø¿Y©\020$D\b00d©´a÷®H\000\000\000d\000\000\000\001\000\000\000\006\000\000\200\004\000\000\000$\020H\b\024®Y©´a÷®\034\033\231\b\001\000\000\000\\ \212·\201\021\212·P\005i\b\000\000\000\000\001", '\0' , "À\230\213\b\000\000\000\000\000\000\000\000\030®Y©­.S\bì*®®À\230\213\b\230®Y©Ý\207G\bì*®®\000\000\000\000\000\000\000\000À\230\213\b\000\000\000\000\220*®®\230®Y©ÿ\234K\b\\ \212·\000\000\000\000\220ÛY©ä*®®ì*®®\220ÛY©\004+®®d\000\000\000\001\000\000\000\b"... to_lc_buff = "\231\200\236°\033\000\000\000\006\000\000\000\006\000\000\000\234\200\236°$ºY©\004\000\000\000\000\000\000\200$\234T\bU×k¯`®Y©\f\000\000\000\001\000\000\000\001\000\000\000\\®Y©8¬Y\006\004\000\000\000\034k\231\b\003\005\000\000\004\000\000\000²\al¯\000\000\000\000\006\000\000\000àó\223\b", '\0' , "¼­Y©÷\226S\bpuh©\000\000\000\000^×k¯\004\000\000\000[×k¯ôUj\b³\001\000\000À\230\213\b^×k¯¸Àx¦\030°Y©!SS\bpuh©^×k¯\\®Y©\b°Y©\004°Y©ôUj\b³\001\000\000ÑýB\t\001\000\000\000áý"... name_buffer_ptr = 0xa96ff928 "p0" from_path = 0xa959c12b "./test/t10" to_path = 0x0 i = 0 file = (class handler **) 0xa9650bc0 #13 0x08563b7c in ha_partition::delete_table (this=0xa968d790, name=0xa959c12b "./test/t10") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/ha_partition.cc:434 No locals. #14 0x082ac381 in handler::ha_delete_table (this=0xa968d790, name=0xa959c12b "./test/t10") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:3374 No locals. #15 0x082ac465 in ha_delete_table (thd=0xa1af1a0, table_type=0x9f134f8, path=0xa959c12b "./test/t10", db=0xa06a390 "test", alias=0xa069fc8 "t10", generate_warning=false) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/handler.cc:2011 file = tmp_path = "test\000¦i©\000\000\000\000 ê\t\n0§i©\005-\000\000\005\000\000\000\000\000\000\000À\230\213\b\000\000\000\000ÔDR¦h¿Y©\177EM\bÜDR¦\224¿Y©¸¿Y©êfE\b\000`a© ê\t\ntÝs·\000\000\000\000\025\000\000\000\001\000\000\000\000\000\000\000\000`a©\\ \212·d\000\000\000\b}`©\020\000`©\004\000\000\000\020\000Ð¥\000\000\000\000Ð}`©È\000\000\000\000\000\000\000tÝs·\020\000`©ÜDR¦\020\000Ð¥\230¿Y©¸+R¦X\000\000\000\234\000\000\000À4k©\020\000`©\020\000`©\020\000Ð¥¸¿Y© 8k©Ð\002\000\000"... error = dummy_table = { s = 0xa959bcdc, file = 0x0, next = 0x0, prev = 0x0, share_next = 0x0, share_prev = 0x0, in_use = 0x0, field = 0x0, record = {0x0, 0x0}, write_row_record = 0x0, insert_values = 0x0, covering_keys = { map = 0 }, quick_keys = { map = 0 }, merge_keys = { map = 0 }, keys_in_use_for_query = { map = 0 }, keys_in_use_for_group_by = { map = 0 }, keys_in_use_for_order_by = { map = 0 }, key_info = 0x0, next_number_field = 0x0, found_next_number_field = 0x0, timestamp_field = 0x0, triggers = 0x0, pos_in_table_list = 0x0, pos_in_locked_tables = 0x0, group = 0x0, alias = 0x0, null_flags = 0x0, bitmap_init_value = 0x0, def_read_set = { bitmap = 0x0, n_bits = 0, last_word_mask = 0, last_word_ptr = 0x0, mutex = 0x0 }, def_write_set = { bitmap = 0x0, n_bits = 0, last_word_mask = 0, last_word_ptr = 0x0, mutex = 0x0 }, tmp_set = { bitmap = 0x0, n_bits = 0, last_word_mask = 0, last_word_ptr = 0x0, mutex = 0x0 }, read_set = 0x0, write_set = 0x0, query_id = 0, quick_rows = {0 }, const_key_parts = {0 }, quick_key_parts = {0 }, quick_n_ranges = {0 }, quick_condition_rows = 0, timestamp_field_type = TIMESTAMP_NO_AUTO_SET, map = 0, lock_position = 0, lock_data_start = 0, lock_count = 0, tablenr = 0, used_fields = 0, temp_pool_slot = 0, status = 0, db_stat = 0, derived_select_number = 0, current_lock = 0, copy_blobs = 0 '\0', maybe_null = 0, null_row = 0 '\0', force_index = 0 '\0', force_index_order = 0 '\0', force_index_group = 0 '\0', distinct = 0 '\0', const_table = 0 '\0', no_rows = 0 '\0', key_read = 0 '\0', no_keyread = 0 '\0', locked_by_logger = 0 '\0', no_replicate = 0 '\0', locked_by_name = 0 '\0', fulltext_searched = 0 '\0', no_cache = 0 '\0', open_by_handler = 0 '\0', auto_increment_field_not_null = 0 '\0', insert_or_update = 0 '\0', alias_name_used = 0 '\0', get_fields_in_item_tree = 0 '\0', m_needs_reopen = 0 '\0', reginfo = { join_tab = 0x0, lock_type = TL_UNLOCK, not_exists_optimize = false, impossible_range = false }, mem_root = { free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, error_handler = 0 }, grant = { grant_table = 0x0, version = 0, privilege = 0, want_privilege = 0, orig_want_privilege = 0, m_internal = { m_schema_lookup_done = false, m_schema_access = 0x0, m_table_lookup_done = false, m_table_access = 0x0 } }, sort = { io_cache = 0x0, sort_keys = 0x0, buffpek = 0x0, buffpek_len = 0, addon_buf = 0x0, addon_length = 0, addon_field = 0x0, unpack = 0, record_pointers = 0x0, found_records = 0 }, part_info = 0x0, no_partitions_used = false, mdl_ticket = 0x0 } dummy_share = { table_category = TABLE_UNKNOWN_CATEGORY, name_hash = { key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = { buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0 }, get_key = 0, free = 0, charset = 0x0 }, mem_root = { free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, error_handler = 0 }, keynames = { count = 0, name = 0x0, type_names = 0x0, type_lengths = 0x0 }, fieldnames = { count = 0, name = 0x0, type_names = 0x0, type_lengths = 0x0 }, intervals = 0x0, LOCK_ha_data = { m_mutex = { __m_reserved = 0, __m_count = 0, __m_owner = 0x0, __m_kind = 0, __m_lock = { __status = 0, __spinlock = 0 } }, m_psi = 0x0 }, next = 0x0, prev = 0x0, used_tables = { = {}, > = {}, members of I_P_List >: m_first = 0x0 }, free_tables = { = {}, > = {}, members of I_P_List >: m_first = 0x0 }, field = 0x0, found_next_number_field = 0x0, timestamp_field = 0x0, key_info = 0x0, blob_field = 0x0, default_values = 0x0, comment = { str = 0x0, length = 0 }, table_charset = 0x0, all_set = { bitmap = 0x0, n_bits = 0, last_word_mask = 0, last_word_ptr = 0x0, mutex = 0x0 }, table_cache_key = { str = 0x0, length = 0 }, db = { str = 0x0, length = 0 }, table_name = { str = 0x0, length = 0 }, path = { str = 0x0, length = 0 }, normalized_path = { str = 0x0, length = 0 }, connect_string = { str = 0x0, length = 0 }, keys_in_use = { map = 0 }, keys_for_keyread = { map = 0 }, min_rows = 0, max_rows = 0, avg_row_length = 0, version = 0, mysql_version = 0, reclength = 0, db_plugin = 0x0, row_type = ROW_TYPE_DEFAULT, tmp_table = NO_TMP_TABLE, ref_count = 0, blob_ptr_size = 0, key_block_size = 0, null_bytes = 0, last_null_bit_pos = 0, fields = 0, rec_buff_length = 0, keys = 0, key_parts = 0, max_key_length = 0, max_unique_length = 0, total_key_length = 0, uniques = 0, null_fields = 0, blob_fields = 0, timestamp_field_offset = 0, varchar_fields = 0, db_create_options = 0, db_options_in_use = 0, db_record_offset = 0, rowid_field_offset = 0, primary_key = 0, next_number_index = 0, next_number_key_offset = 0, next_number_keypart = 0, error = 0, open_errno = 0, errarg = 0, column_bitmap_size = 0, frm_version = 0 '\0', null_field_first = false, system = false, crypted = false, db_low_byte_first = false, crashed = false, is_view = false, table_map_id = 0, cached_row_logging_check = 0, auto_partitioned = false, partition_info_str = 0x0, partition_info_str_len = 0, partition_info_buffer_size = 0, default_part_db_type = 0x0, table_field_def_cache = 0x0, ha_data = 0x0, ha_data_destroy = 0, ha_part_data = 0x0, ha_part_data_destroy = 0, m_psi = 0x0, m_flush_tickets = { = {}, > = {}, members of I_P_List, I_P_List_null_counter, I_P_List_no_push_back >: m_first = 0x0 } } #16 0x08204791 in quick_rm_table (base=0x9f134f8, db=0xa06a390 "test", table_name=0xa069fc8 "t10", flags=) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_table.cc:2387 path = "./test/t10\000frm\000v#ô¿\202·\020\000`©0x8¦hÁY©¶æs·\\ \212·0x8¦\000\0000¦\000\000\000\000\001\000\000\000\000\000\000\000xÁY©À\230\213\bàá\227\b\000\000\000\000hÃY©dQ\026\bàá\227\bªÁY©\t\000\000\000À\230\213\b\000\000\000\000ÿÿÿÿÈÁY\000\025ª\034\bpìd©\001\000\000\000\000\000test\000t10\000\000\000\000\000\000\000\000\001\001À\230\213\b\000\000\000\000ÿÿÿÿøÁY©Ë¬\034\bpìd©h\be©\000\000\000\000\fzb\bpìd©\220i\034\b\000\000\000ÀÀ\230\213\b\000\000\000"... error = false path_length = 10 #17 0x081653b8 in drop_open_table (thd=0xa1af1a0, table=0xa6387830, db_name=0xa06a390 "test", table_name=0xa069fc8 "t10") at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_base.cc:2281 table_type = (handlerton *) 0x9f134f8 #18 0x08186a03 in select_create::abort_result_set (this=0xa06b088) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_insert.cc:4117 No locals. #19 0x081e184a in handle_select (thd=0xa1af1a0, lex=0xa1b017c, result=0xa06b088, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_select.cc:302 res = true select_lex = (SELECT_LEX *) 0xa1b0618 #20 0x081a401d in mysql_execute_command (thd=0xa1af1a0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:2458 link_to_local = select_tables = (TABLE_LIST *) 0xa06a8b0 create_info = { table_charset = 0x0, default_table_charset = 0x893f9e0, connect_string = { str = 0x0, length = 0 }, password = 0x0, tablespace = 0x0, comment = { str = 0x0, length = 0 }, data_file_name = 0x0, index_file_name = 0x0, alias = 0xa069fe8 "t10", max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 8, avg_row_length = 0, used_fields = 0, key_block_size = 0, merge_list = { = {}, members of SQL_I_List: elements = 0, first = 0x0, next = 0xa959c8f8 }, db_type = 0x9f134f8, row_type = ROW_TYPE_DEFAULT, null_bits = 3, options = 2, merge_insert_method = 0, extra_size = 58, unused1 = HA_CHOICE_UNDEF, frm_only = false, varchar = false, storage_media = HA_SM_DEFAULT, unused2 = HA_CHOICE_UNDEF } alter_info = { drop_list = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa959c500, elements = 0 }, }, alter_list = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa959c50c, elements = 0 }, }, key_list = { = { = {}, members of base_list: first = 0xa06ac60, last = 0xa06ac60, elements = 1 }, }, create_list = { = { = {}, members of base_list: first = 0xa06ac70, last = 0xa06b398, elements = 3 }, }, flags = 0, keys_onoff = LEAVE_AS_IS, tablespace_op = NO_TABLESPACE_OP, partition_names = { = { = {}, members of base_list: first = 0x897e9e0, last = 0xa959c53c, elements = 0 }, }, num_parts = 0, change_level = ALTER_TABLE_METADATA_ONLY, datetime_field = 0x0, error_if_not_empty = false } res = 0 up_result = lex = (LEX *) 0xa1b017c select_lex = (SELECT_LEX *) 0xa1b0618 first_table = (TABLE_LIST *) 0xa069ff0 all_tables = (TABLE_LIST *) 0xa069ff0 unit = (SELECT_LEX_UNIT *) 0xa1b01e0 have_table_map_for_update = __FUNCTION__ = "mysql_execute_command" #21 0x081a4361 in mysql_parse (thd=0xa1af1a0, rawbuf=0xa069e00 "CREATE TABLE IF NOT EXISTS t10 ( `pk` INTEGER NOT NULL AUTO_INCREMENT , `col_int` INTEGER , PRIMARY KEY ( `pk` ) ) PARTITION BY HASH ( `pk` ) PARTITIONS 5 SELECT `pk` , `col_int_key` FROM D", length=189, parser_state=0xa959d110) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:5499 found_semicolon = lex = (LEX *) 0xa1b017c err = __FUNCTION__ = "mysql_parse" #22 0x081a5f7f in dispatch_command (command=COM_QUERY, thd=0xa1af1a0, packet=0xa1f4df1 "CREATE TABLE IF NOT EXISTS t10 ( `pk` INTEGER NOT NULL AUTO_INCREMENT , `col_int` INTEGER , PRIMARY KEY ( `pk` ) ) PARTITION BY HASH ( `pk` ) PARTITIONS 5 SELECT `pk` , `col_int_key` FROM D", packet_length=189) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:1029 parser_state = { m_lip = { m_thd = 0xa1af1a0, yylineno = 1, yytoklen = 1, yylval = 0xa959cc00, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0xa069ebe "", m_tok_start = 0xa069ebe "", m_tok_end = 0xa069ebe "", m_end_of_query = 0xa069ebd "", m_tok_start_prev = 0xa069ebd "", m_buf = 0xa069e00 "CREATE TABLE IF NOT EXISTS t10 ( `pk` INTEGER NOT NULL AUTO_INCREMENT , `col_int` INTEGER , PRIMARY KEY ( `pk` ) ) PARTITION BY HASH ( `pk` ) PARTITIONS 5 SELECT `pk` , `col_int_key` FROM D", m_buf_length = 189, m_echo = true, m_echo_saved = false, m_cpp_buf = 0xa069f00 "CREATE TABLE IF NOT EXISTS t10 ( `pk` INTEGER NOT NULL AUTO_INCREMENT , `col_int` INTEGER , PRIMARY KEY ( `pk` ) ) PARTITION BY HASH ( `pk` ) PARTITIONS 5 SELECT `pk` , `col_int_key` FROM D", m_cpp_ptr = 0xa069fbd "", m_cpp_tok_start = 0xa069fbd "", m_cpp_tok_start_prev = 0xa069fbd "", m_cpp_tok_end = 0xa069fbd "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xa967f214 "", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 2841236124, m_cpp_text_start = 0xa069fbc "D", m_cpp_text_end = 0xa069fbd "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = error = __FUNCTION__ = "dispatch_command" #23 0x081a65df in do_command (thd=0xa1af1a0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_parse.cc:769 return_value = packet = 0xa1f4df0 "\003CREATE TABLE IF NOT EXISTS t10 ( `pk` INTEGER NOT NULL AUTO_INCREMENT , `col_int` INTEGER , PRIMARY KEY ( `pk` ) ) PARTITION BY HASH ( `pk` ) PARTITIONS 5 SELECT `pk` , `col_int_key` FROM D" packet_length = net = (NET *) 0xa1af2d0 command = COM_QUERY #24 0x082448fd in do_handle_one_connection (thd_arg=0xa1af1a0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:745 thd = (class THD *) 0xa1af1a0 #25 0x082449df in handle_one_connection (arg=0xa1af1a0) at /export/home/pb2/build/sb_0-2482024-1288735491.41/mysql-5.5.7-rc/sql/sql_connect.cc:684 No locals. #26 0xb789f4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #27 0xb77b15ee in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available.