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)