060314 18:46:28 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.20-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1131862960 (LWP 6502)] [Thread 1131862960 (zombie) exited] [New Thread 1131862960 (LWP 6505)] 060314 19:03:50 InnoDB: WARNING: over 4 / 5 of the buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index! Check that your InnoDB: transactions do not set too many row locks. InnoDB: Your buffer pool size is 8 MB. Maybe you should make InnoDB: the buffer pool bigger? InnoDB: Starting the InnoDB Monitor to print diagnostics, including InnoDB: lock heap and hash index sizes. ===================================== 060314 19:04:04 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 2 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 718, signal count 717 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 1483, OS waits 694; RW-excl spins 31, OS waits 24 ------------ TRANSACTIONS ------------ Trx id counter 0 1312 Purge done for trx's n:o < 0 1283 undo n:o < 0 0 History list length 1 Total number of lock structs in row lock hash table 82310 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1311, ACTIVE 358 sec, process no 6487, OS thread id 1131862960 inserting mysql tables in use 2, locked 2 82313 lock struct(s), heap size 6974784, undo log entries 4317324 MySQL thread id 2, query id 94 localhost root Sending data insert into t1 (N) select N from t1 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2676 OS file reads, 6335 OS file writes, 2886 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 15.49 writes/s, 8.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 1, node heap has 1 buffer(s) 15166.42 hash searches/s, 132.43 non-hash searches/s --- LOG --- Log sequence number 0 712328555 Log flushed up to 0 712176016 Last checkpoint at 0 712119045 0 pending log writes, 0 pending chkp writes 3307 log i/o's done, 6.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19963734; in additional pool allocated 895616 Buffer pool size 512 Free buffers 0 Database pages 86 Modified db pages 16 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 29361, created 33182, written 34156 0.00 reads/s, 40.48 creates/s, 64.97 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 6487, id 1108081584, state: sleeping Number of rows inserted 12705931, updated 0, deleted 0, read 16777215 15245.88 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 060314 19:04:20 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 725, signal count 724 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 1499, OS waits 701; RW-excl spins 31, OS waits 24 ------------ TRANSACTIONS ------------ Trx id counter 0 1312 Purge done for trx's n:o < 0 1283 undo n:o < 0 0 History list length 1 Total number of lock structs in row lock hash table 86020 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1311, ACTIVE 374 sec, process no 6487, OS thread id 1131862960 inserting mysql tables in use 2, locked 2 86023 lock struct(s), heap size 7269696, undo log entries 4553979 MySQL thread id 2, query id 94 localhost root Sending data insert into t1 (N) select N from t1 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2694 OS file reads, 6494 OS file writes, 2961 OS fsyncs 1.12 reads/s, 16384 avg bytes/read, 9.94 writes/s, 4.69 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 1, node heap has 1 buffer(s) 14712.77 hash searches/s, 128.80 non-hash searches/s --- LOG --- Log sequence number 0 726106179 Log flushed up to 0 725953457 Last checkpoint at 0 720974388 0 pending log writes, 0 pending chkp writes 3374 log i/o's done, 4.19 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19963734; in additional pool allocated 895616 Buffer pool size 512 Free buffers 0 Database pages 68 Modified db pages 16 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 29379, created 33813, written 34842 1.12 reads/s, 39.44 creates/s, 42.87 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 6487, id 1108081584, state: sleeping Number of rows inserted 12942586, updated 0, deleted 0, read 16777215 14790.01 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 060314 19:04:36 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 737, signal count 736 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 1526, OS waits 713; RW-excl spins 31, OS waits 24 ------------ TRANSACTIONS ------------ Trx id counter 0 1312 Purge done for trx's n:o < 0 1283 undo n:o < 0 0 History list length 1 Total number of lock structs in row lock hash table 89640 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1311, ACTIVE 390 sec, process no 6487, OS thread id 1131862960 inserting mysql tables in use 2, locked 2 89643 lock struct(s), heap size 7548224, undo log entries 4784881 MySQL thread id 2, query id 94 localhost root Sending data insert into t1 (N) select N from t1 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2701 OS file reads, 6705 OS file writes, 3069 OS fsyncs 0.44 reads/s, 51492 avg bytes/read, 13.19 writes/s, 6.75 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 1, node heap has 1 buffer(s) 14355.10 hash searches/s, 125.62 non-hash searches/s --- LOG --- Log sequence number 0 739549478 Log flushed up to 0 739193101 Last checkpoint at 0 738251402 0 pending log writes, 0 pending chkp writes 3454 log i/o's done, 5.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19963734; in additional pool allocated 895616 Buffer pool size 512 Free buffers 0 Database pages 51 Modified db pages 26 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 29401, created 34413, written 35524 1.37 reads/s, 37.50 creates/s, 42.62 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 6487, id 1108081584, state: sleeping Number of rows inserted 13173488, updated 0, deleted 0, read 16777215 14430.47 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 060314 19:04:37 InnoDB: ERROR: over 9 / 10 of the buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index! Check that your InnoDB: transactions do not set too many row locks. InnoDB: Your buffer pool size is 8 MB. Maybe you should make InnoDB: the buffer pool bigger? InnoDB: We intentionally generate a seg fault to print a stack trace InnoDB: on Linux! 060314 19:04:37InnoDB: Assertion failure in thread 1131862960 in file buf0lru.c line 356 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1131862960 (LWP 6505)] 0x08477531 in buf_LRU_get_free_block () at buf0lru.c:356 356 ut_error; Current language: auto; currently c (gdb) bt full #0 0x08477531 in buf_LRU_get_free_block () at buf0lru.c:356 block = (buf_block_t *) 0x0 freed = 29 n_iterations = 1 mon_value_was = 0 started_monitor = 0 #1 0x084741dc in buf_page_create (space=0, offset=27550, mtr=0x4376b120) at buf0buf.c:1721 frame = (buf_frame_t *) 0x3c
block = (buf_block_t *) 0x7 free_block = (buf_block_t *) 0x0 #2 0x084869d0 in fseg_alloc_free_page_low (space=0, seg_inode=0x408212f2 "", hint=27550, direction=111 'o', mtr=0x4376b120) at fsp0fsp.c:2513 space_header = (fsp_header_t *) 0x40a34026 "" space_size = 138959926 seg_id = {high = 0, low = 29} used = 22974 reserved = 23008 descr = (xdes_t *) 0x40be1bc6 "" ret_page = 27550 ret_descr = (xdes_t *) 0x40be1bc6 "" page = (ib_page_t *) 0x404d4000 "³\a\225-x0trx.c" frag_page_allocated = 0 success = 1131851272 n = 138877301 #3 0x08486b76 in fseg_alloc_free_page_general (seg_header=0x4057004a "", hint=27550, direction=111 'o', has_done_reservation=1, mtr=0x4376b120) at fsp0fsp.c:2601 inode = (fseg_inode_t *) 0x408212f2 "" space = 0 latch = (rw_lock_t *) 0x403864b0 success = 1131852064 page_no = 1087029248 n_reserved = 138758499 #4 0x08454e4f in btr_page_alloc (tree=0x40398c68, hint_page_no=27550, file_direction=111 'o', level=0, mtr=0x4376b120) at btr0btr.c:342 seg_header = (fseg_header_t *) 0x4057004a "" root = (ib_page_t *) 0x40570000 "\203¯\005Ö" new_page = (ib_page_t *) 0x40cac000 "wX1ª" new_page_no = 1 #5 0x0845676d in btr_page_split_and_insert (cursor=0x4376b584, tuple=0x40396c68, mtr=0x4376b120) at btr0btr.c:1631 tree = (dict_tree_t *) 0x40398c68 ---Type to continue, or q to quit--- page = (ib_page_t *) 0x40cac000 "wX1ª" page_no = 27549 direction = 111 'o' hint_page_no = 27550 new_page = (ib_page_t *) 0x4
split_rec = (rec_t *) 0x0 left_page = (ib_page_t *) 0x4376af18 "X¯vC£¨E\b\204µvChl9@ ±vCé\\B\bha9@\003" right_page = (ib_page_t *) 0x40d06118 "#¥y\002Õ" insert_page = (ib_page_t *) 0x404d4000 "³\a\225-x0trx.c" page_cursor = (page_cur_t *) 0x32 first_rec = (rec_t *) 0x4376af18 "X¯vC£¨E\b\204µvChl9@ ±vCé\\B\bha9@\003" buf = (unsigned char *) 0x0 move_limit = (rec_t *) 0x40d06118 "#¥y\002Õ" insert_will_fit = 4 n_iterations = 0 rec = (rec_t *) 0x845a7aa "\203Ä \211Eô\203}ô" heap = (mem_heap_t *) 0x4039b028 n_uniq = 1 offsets = (ulint *) 0x0 #6 0x0845a8a3 in btr_cur_pessimistic_insert (flags=0, cursor=0x4376b584, entry=0x40396c68, rec=0x4376b580, big_rec=0x4376b57c, thr=0x40398260, mtr=0x4376b120) at btr0cur.c:1202 index = (dict_index_t *) 0x40396168 big_rec_vec = (big_rec_t *) 0x0 page = (ib_page_t *) 0x40cac000 "wX1ª" err = 10 dummy_inh = 1 success = 1 n_extents = 3 n_reserved = 3 #7 0x0843a07f in row_ins_index_entry_low (mode=33, index=0x40396168, entry=0x40396c68, ext_vec=0x0, n_ext_vec=0, thr=0x40398260) at row0ins.c:2071 cursor = {index = 0x40396168, page_cur = {rec = 0x40cafaaf ""}, left_page = 0x4376b6bc "", thr = 0x40398260, flag = 3, tree_height = 3, up_match = 0, up_bytes = 0, low_match = 0, low_bytes = 3, n_fields = 0, n_bytes = 1, fold = 3292845719, path_arr = 0x40396168} ignore_sec_unique = 0 modify = 0 insert_rec = (rec_t *) 0x40cafaaf "" rec = (rec_t *) 0x4376dbb0 "°ÛvC´4æ\b°ÛvC\001" err = 1000 ---Type to continue, or q to quit--- n_unique = 1 big_rec = (big_rec_t *) 0x0 mtr = {state = 1077513420, memo = {heap = 0x0, used = 104, data = "8\000\000\000¼\2149@\003\000\000\000\230ªÍ@\003\000\000\000\030ªÏ@\003\000\000\000\030aÐ@\002\000\000\000\230MÐ@\002\000\000\000\030aÐ@8\000\000\000°d8@\002\000\000\000\030tÏ@\002\000\000\000\230ªÍ@8\000\000\000°d8@\002\000\000\000\230¬Î@\002\000\000\000\030tÏ@\002\000\000\000\230\024Ð@\003\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000"..., base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}}, log = {heap = 0x0, used = 0, data = "¦\000Àk\235\000\004\000\001\200\004\200\006\200\a\200\004:\225$å\000\000\000\000\005\037\200\000\000ka\026¸\000\000\000\001\001À@&\000\004\000\001\200\004\200\006\200\a\200\004$æ\f4¨\000\000k\235\004\000Àk\233\000\fÀk\234\004\000Àk\234\000\b¸³vC\\×\034\b\000(è\b\235\002\000Àk\234\000@\000\004\000Àk\235\000\bÀk\234\004\b·vC²¡0\bå\035è\b1)è\b\004\000\000\000\000Àk\234\000\004\000\001\200\004\200\006\200\001\200\004\000p&\000Àk\235\000\004\000\001\200\004\200\006\200\a\200\004\000c+\000\005\005\000É4¨\000\000\000\000\005\037\200\000\000k`4Ç\000\000\000\001\037\037\004\000À@"..., base = {count = 3, start = 0x4376b340, end = 0x4039e068}, list = {prev = 0x0, next = 0x40399468}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 0, low = 740323441}, end_lsn = {high = 0, low = 740323479}, magic_n = 1131853528} heap = (mem_heap_t *) 0x0 offsets_ = {100, 0, 1075293447, 1131851704, 0, 1131851688, 1075294448, 1131851752, 140229525, 1077425772, 1131862960, 1131851752, 140229317, 100, 4, 2147483653, 4, 10, 17, 21, 0, 1131851752, 1075294448, 1131851816, 140229525, 1087286476, 1131862960, 1131851832, 140229317, 1131851784, 1075293447, 1131851848, 0, 0, 1075293447, 1131851832, 0, 1131851816, 1075294448, 1131851880, 140229525, 1087220428, 1131862960, 617, 140229317, 1087286476, 1075293447, 1131851880, 0, 1131851864, 1075294448, 1131851928, 140229525, 1077513424, 1131862960, 1131851912, 140229317, 1087220428, 141211272, 617, 139096269, 0, 0, 1131851944, 139141508, 0, 0, 1131851960, 139144342, 1077513424, 141211272, 617, 139096269, 1077513424, 1131851976, 1131851992, 139096415, 1077513424, 1087286424, 1131852024, 139091998, 1087220424, 0, 1131852024, 139096478, 1077513488, 1131852024, 139096489, 1077513420, 1082266542, 0, 1131852072, 139091808, 1077513420, 141201168, 361, 350, 1082266354, 0, 1131852088} offsets = (ulint *) 0x4376af8c #8 0x0843a24c in row_ins_index_entry (index=0x40396168, entry=0x40396c68, ext_vec=0x0, n_ext_vec=0, thr=0x40398260) at row0ins.c:2154 err = 1000 #9 0x0843a3a1 in row_ins_index_entry_step (node=0x40398068, thr=0x40398260) at row0ins.c:2224 err = 1077510373 #10 0x0843a58c in row_ins (node=0x40398068, thr=0x40398260) at row0ins.c:2356 err = 1 #11 0x0843a727 in row_ins_step (thr=0x40398260) at row0ins.c:2460 node = (ins_node_t *) 0x40398068 parent = (que_node_t *) 0x40398260 sel_node = (sel_node_t *) 0x0 trx = (trx_t *) 0x40397c68 err = 4798181 #12 0x0843c03d in row_insert_for_mysql (mysql_rec=0x8e81de0 "ÿæ6É", prebuilt=0x40397268) at row0mysql.c:1141 ---Type to continue, or q to quit--- savept = {least_undo_no = {high = 0, low = 4798181}} thr = (que_thr_t *) 0x40398260 err = 0 was_lock_wait = 32872 trx = (trx_t *) 0x40397c68 node = (ins_node_t *) 0x40398068 #13 0x082dd646 in ha_innobase::write_row (this=0x8e81cb8, record=0x8e81de0 "ÿæ6É") at ha_innodb.cc:3495 auto_inc = 13186789 _db_func_ = 0x8e9a2d8 "0ªé\b0ªé\b\001" _db_file_ = 0x4376b701 "" prebuilt = (row_prebuilt_t *) 0x40397268 error = 10 dummy = 641228481319498120 auto_inc_used = 1 _db_level_ = 0 _db_framep_ = (char **) 0xe82698 #14 0x08261c25 in write_record (thd=0x8e619e8, table=0x8e815a8, info=0x8e99528) at sql_insert.cc:1101 key = 0x0 _db_func_ = 0x1
_db_file_ = 0x8e9a2d8 "0ªé\b0ªé\b\001" error = 0 trg_error = 0 _db_level_ = 149516680 _db_framep_ = (char **) 0x8e619e8 __PRETTY_FUNCTION__ = "int write_record(THD*, TABLE*, COPY_INFO*)" #15 0x08265ed9 in select_insert::send_data (this=0x8e99508, values=@0x8e9a2d8) at sql_insert.cc:2282 _db_func_ = 0x865e888 "end_send" _db_file_ = 0x824e58e "\203Ä \212EÔ\203ð\001\204À\017\204\022\004" _db_level_ = 1131853992 _db_framep_ = (char **) 0x0 error = false #16 0x0824e682 in end_send (join=0x8e99570, join_tab=0x8e9abb0, end_of_records=false) at sql_select.cc:10551 error = 0 _db_func_ = 0x8e82028 "4%è\bp)è\b" _db_file_ = 0x4376b89c "uü\024\bø5æ\b@ªé\b\b¹vC~®$\bp\225é\b°«é\b" _db_level_ = 1131853984 _db_framep_ = (char **) 0x4376b8a4 #17 0x0824ae7e in evaluate_join_record (join=0x8e99570, join_tab=0x8e9aa40, error=0, report_error=0x8e62454 "") at sql_select.cc:9875 rc = NESTED_LOOP_OK ---Type to continue, or q to quit--- found = true not_exists_optimize = false not_used_in_distinct = false found_records = 8388608 select_cond = (COND *) 0x0 #18 0x0824b248 in sub_select (join=0x8e99570, join_tab=0x8e9aa40, end_of_records=false) at sql_select.cc:9766 error = 0 rc = NESTED_LOOP_OK report_error = (my_bool *) 0x8e62454 "" info = (READ_RECORD *) 0x8e9aa7c #19 0x0824b55b in do_select (join=0x8e99570, fields=0x8e9a2d8, table=0x0, procedure=0x0) at sql_select.cc:9523 join_tab = (JOIN_TAB *) 0x8e9aa40 _db_func_ = 0x0 _db_file_ = 0x0 rc = 0 error = NESTED_LOOP_OK _db_level_ = 1131854244 _db_framep_ = (char **) 0x4376b9a8 #20 0x0825da6b in JOIN::exec (this=0x8e99570) at sql_select.cc:1737 _db_func_ = 0x8e9a300 "<9~\b" _db_file_ = 0x0 _db_level_ = 149516088 _db_framep_ = (char **) 0x8e99570 tmp_error = 0 curr_join = (JOIN *) 0x8e99570 curr_fields_list = (List *) 0x8e9a2d8 columns_list = (List *) 0x8e96fc0 curr_all_fields = (List *) 0x8e9a2b4 curr_tmp_table = (TABLE *) 0x8e82028 __PRETTY_FUNCTION__ = "void JOIN::exec()" #21 0x0825dd55 in mysql_select (thd=0x8e619e8, rref_pointer_array=0x8e9705c, tables=0x8eab830, wild_num=0, fields=@0x8e96fc0, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3498461696, result=0x8e99508, unit=0x8e96d10, select_lex=0x8e96f38) at sql_select.cc:1901 err = false free_join = true _db_func_ = 0x4376baf8 "" _db_file_ = 0x86c87b6 "my_alloc.c" join = (JOIN *) 0x8e99570 _db_level_ = 141330464 ---Type to continue, or q to quit--- _db_framep_ = (char **) 0x85a13cd #22 0x0825dff1 in handle_select (thd=0x8e619e8, lex=0x8e96d00, result=0x8e99508, setup_tables_done_option=1073741824) at sql_select.cc:250 unit = (SELECT_LEX_UNIT *) 0x8e96d10 select_lex = (SELECT_LEX *) 0x8e96f38 _db_func_ = 0x0 _db_file_ = 0x14ce83
res = 8 _db_level_ = 1131854680 _db_framep_ = (char **) 0x8e99508 #23 0x08203138 in mysql_execute_command (thd=0x8e619e8) at sql_parse.cc:3316 second_table = (TABLE_LIST *) 0x8eab830 result = (class select_result *) 0x8e99508 res = false lex = (LEX *) 0x8e96d00 _db_func_ = 0x8e85ff8 "\b¡^\b" _db_file_ = 0x4376c34c "\227\027Z\bL\210l\b\200\224é\b\030" _db_level_ = 1131856720 _db_framep_ = (char **) 0x13b result = 0 select_lex = (SELECT_LEX *) 0x8e96f38 first_table = (TABLE_LIST *) 0x8eab510 all_tables = (TABLE_LIST *) 0x8eab510 unit = (SELECT_LEX_UNIT *) 0x8e96d10 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #24 0x0835d483 in sp_instr_stmt::exec_core (this=0x8eab9d0, thd=0x8e619e8, nextp=0x4376c5f0) at sp_head.cc:2337 res = 149444808 #25 0x0835d28c in sp_lex_keeper::reset_lex_and_exec_core (this=0x8eab9f8, thd=0x8e619e8, nextp=0x4376c5f0, open_tables=false, instr=0x8eab9d0) at sp_head.cc:2216 res = 0 __PRETTY_FUNCTION__ = "int sp_lex_keeper::reset_lex_and_exec_core(THD*, uint*, bool, sp_instr*)" #26 0x0835ffd8 in sp_instr_stmt::execute (this=0x8eab9d0, thd=0x8e619e8, nextp=0x4376c5f0) at sp_head.cc:2290 _db_func_ = 0x4376c638 "\bÇvCv²5\bÈ¢ê\bè\031æ\b" _db_file_ = 0x8e62d28 ",-æ\b" query = 0x8e84df8 "call Proc()" query_length = 11 res = 0 _db_level_ = 149301900 _db_framep_ = (char **) 0x820b3be #27 0x0835a078 in sp_head::execute (this=0x8eaa2c8, thd=0x8e619e8) at sp_head.cc:1059 ---Type to continue, or q to quit--- i = (sp_instr *) 0x8eab9d0 hip = 220 _db_func_ = 0x8e86080 '\217' ... _db_file_ = 0x8e858c8 "ÈÅvCÈ¢ê\b" olddb = "\002ù\024\b\220ÅvC\000\000\000\000\000\000\000\000]ý\024\b\001\000\000\000è_è\bxÅvCÍ\023Z\b \210l\b¶\207l\bxÅvC\205Æ\027@ø_è\bð_è\bXÅvC@ö\025\b\001\000\000\000¶\207l\bxÅvCZþ\024\b0`è\b \v~\bxÅvC¥þ\024\b`¦ê\b\000\000\000\000\000\000\000\000\205Æ\027@è\031æ\b\000\000\000\000ØÅvC" err_status = false execute_arena = {_vptr.Query_arena = 0x8613788, free_list = 0x0, mem_root = 0x4376c57c, is_backup_arena = false, state = INITIALIZED_FOR_SP} old_change_list = { = {first = 0x8e62d2c, last = {_vptr.ilink = 0x8614100, prev = 0x8e62d28, next = 0x0}}, } old_packet = {Ptr = 0x8ea6298 "\003def", str_length = 57, Alloced_length = 16384, alloced = true, str_charset = 0x87e0ba0} _db_level_ = 1 _db_framep_ = (char **) 0x1 dbchanged = false save_sql_mode = 0 ctx = (sp_rcontext *) 0x8e858c8 old_arena = (class Query_arena *) 0x8e619f4 execute_mem_root = {free = 0x8e99498, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 5, first_block_usage = 0, error_handler = 0} backup_arena = {_vptr.Query_arena = 0x8613788, free_list = 0x8e85ff8, mem_root = 0x8e61a08, is_backup_arena = true, state = CONVENTIONAL_EXECUTION} old_query_id = 18 old_lex = (LEX *) 0x8e61a28 ip = 6 old_derived_tables = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "bool sp_head::execute(THD*)" #28 0x0835b276 in sp_head::execute_procedure (this=0x8eaa2c8, thd=0x8e619e8, args=0x8e61ebc) at sp_head.cc:1499 err_status = false params = 0 save_spcont = (sp_rcontext *) 0x0 octx = (sp_rcontext *) 0x8e85110 _db_func_ = 0x74
_db_file_ = 0x0 nctx = (sp_rcontext *) 0x8e858c8 _db_level_ = 0 _db_framep_ = (char **) 0x0 #29 0x08206844 in mysql_execute_command (thd=0x8e619e8) at sql_parse.cc:4394 ---Type to continue, or q to quit--- save_ctx = (Security_context *) 0x0 select_limit = 18446744073709551615 bits_to_be_cleared = 0 nsok = 0 '\0' sp = (class sp_head *) 0x8eaa2c8 res = false lex = (LEX *) 0x8e61a28 _db_func_ = 0x85bbb95 "\203Ä\020\213Eø\213]üÉÃU\211åS\203ì\024\213E\f\203ì\fPèÕ·¸ÿ\203Ä\020\213E\f\213@8\205Àu/¡l7~\bÿu\024ÿu\020h̺l\bPèr±¸ÿ\203Ä\020¡l7~\b\203ì\fPèÁ±¸ÿ\203Ä\020èI¶¸ÿ\213E\f\213X<è\016º¸ÿ\203ì\bSPè¤À¸ÿ\203Ä\020\205ÀuA\213E\f\213P4\213E\f\213@0\213\rl7~\b\203ì\bRPÿu\024ÿu\020h\020»l\bQè\025±¸ÿ\203Ä ¡l7~\b\203ì\fPèd±¸ÿ\203Ä\020è쵸ÿ\213E\f\213@8\215Pÿ\213E\f\211P8\213E"... _db_file_ = 0x87e393c "<9~\b" _db_level_ = 149298320 _db_framep_ = (char **) 0x8e84e38 result = 0 select_lex = (SELECT_LEX *) 0x8e61c60 first_table = (TABLE_LIST *) 0x0 all_tables = (TABLE_LIST *) 0x0 unit = (SELECT_LEX_UNIT *) 0x8e61a38 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #30 0x082086cb in mysql_parse (thd=0x8e619e8, inBuf=0x8e84df8 "call Proc()", length=11) at sql_parse.cc:5697 lex = (LEX *) 0x8e61a28 _db_func_ = 0x87e8560 "\b f\b" _db_file_ = 0x8208f8f "\203Ä ¡\024û~\b\205Àt/\203ì\bh/Bb\bh³\006" _db_level_ = 1131860760 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #31 0x0820900e in dispatch_command (command=COM_QUERY, thd=0x8e619e8, packet=0x8e79179 "call Proc()", packet_length=12) at sql_parse.cc:1720 packet_end = 0x8e84e03 "" net = (NET *) 0x8e621ec _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16793441 _db_framep_ = (char **) 0x8e62ae8 #32 0x0820a39c in do_command (thd=0x8e619e8) at sql_parse.cc:1516 packet = 0x8e79178 "\003call Proc()" old_timeout = 30 packet_length = 12 net = (NET *) 0x8e621ec ---Type to continue, or q to quit--- command = COM_QUERY _db_func_ = 0x4376d378 "XÔvC¨§ \bè\031æ\b\001" _db_file_ = 0x8e62c04 "\030nè\b" _db_level_ = 149450264 _db_framep_ = (char **) 0x1010 #33 0x0820a7a8 in handle_one_connection (arg=0x8e619e8) at sql_parse.cc:1159 error = 0 net = (NET *) 0x8e621ec sctx = (Security_context *) 0x8e629cc thd = (class THD *) 0x8e619e8 launch_time = 0 set = {__val = {0 }} #34 0x40179297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #35 0x402b437e in clone () from /lib/tls/libc.so.6 No symbol table info available. #36 0x4376dbb0 in ?? () No symbol table info available. (gdb)