Core was generated by `./bin/mysqld-debug --no-defaults --basedir=. --datadir=mysql-test/var/master-da'. Program terminated with signal 11, Segmentation fault. #0 0xffffe002 in ?? () [Switching to thread 1 (process 17884)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x0831f7e3 in write_core (sig=17884) at stacktrace.c:220 No locals. #2 0x081da9c1 in handle_segfault (sig=22) at mysqld.cc:2155 thd = (class THD *) 0x8e8dc40 #3 No symbol table info available. #4 0x083d842b in row_sel_store_mysql_rec (mysql_rec=0x41322068 "ïo®\004h03Ah¤2A", prebuilt=0x44bc3053, rec=0x6e257758 "d", offsets=0x6e2578e8) at row0sel.c:2641 templ = (mysql_row_templ_t *) 0x4132a468 extern_field_heap = (mem_heap_t *) 0xbbf data = (unsigned char *) 0x44bc3065 "\200" len = 1847950688 i = 1847949144 #5 0x083db893 in row_sel_push_cache_row_for_mysql (prebuilt=0x41322068, rec=0x44bc3053 "\200", offsets=0x6e257758) at row0sel.c:3074 i = 1847950688 #6 0x083dabbf in row_search_for_mysql (buf=0x8e9f130 "", mode=2, prebuilt=0x41322068, match_mode=1, direction=1) at row0sel.c:4152 index = (dict_index_t *) 0x41332e68 comp = 1 search_tuple = (dtuple_t *) 0x41325068 pcur = (btr_pcur_t *) 0x41332f68 trx = (trx_t *) 0x4132a468 clust_index = (dict_index_t *) 0x41333768 thr = (que_thr_t *) 0x413411c8 rec = (rec_t *) 0x44b9167d "\200" result_rec = (rec_t *) 0x44bc3053 "\200" clust_rec = (rec_t *) 0x44bc3053 "\200" err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = 1 moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = 0 next_offs = 3007 same_user_rec = 1 mtr = {state = 0, memo = {heap = 0x0, used = 40, data = "\001\000\000\000\030q£g7\000\000\000\000\000\000\000\003\000\000\000\030A£g\003\000\000\000\030V£g\001\000\000\000\030\203£g\001\000\000\000\000\000\000\0005­\003@0\004ô\b\000\000\000\000Py%n5­\003@0\004ô\b\000\000\000\000`y%n¥@N\b\000\000\000\000\000\000\000\000py%n5­\003@ÀXð\b\000\000\000\000\200y%n¥@N\b\000\000\000\000\000\000\000\000\220y%n¥@N\b\000\000\000\000à\023é\b y%n¹NN\bà\023é\b\002\000\000\000Ày%n5­\003@\030Yð\b\000\000\000\000Ày%n5­\003@\000\000\000\000\000\000\000\000Ðy%n¥@N\b\000\000\000\000"..., base = {count = 149478464, start = 0x0, end = 0x0}, list = {prev = 0x6e257e60, next = 0x823757d}}, log = {heap = 0x0, used = 0, data = "\f|%n\020|%n\000\000\000\000\001\000\000\000@{%nP\037ô\b\000¥ê\b\000\000\000\000P{%n¹NN\b4\037ô\b\002\000\000\000\000\000\000\000x ô\b\0240õ\b\030\003ô\bE\003ô\b ^\001\000\000îY\b\t\000\000\0000|%n\234Òé\b\b£ê\bH³á\b0|%n\005\000\000\000\000\000\000\000-\000\000\000\001", '\0' , "ûÿÿÿ\000\000\000\000\000\000\000\000\001\000\000\000\003\000\000\000\005\000\000\000\005\000\000\000`Üè\bÿÿÿÿÿÿÿÿ\000J\004\200\000\000\000\000\200¤\000\000(ôY\bdîY\b\b\000\000\000ð{%n(ôY\bdîY\b\b"..., base = {count = 1847950640, start = 0x84e40a5, end = 0x0}, list = {prev = 0x15, next = 0x6e257d40}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 1847950672, low = 139349689}, end_lsn = {high = 149492704, low = 2}, magic_n = 1847950688} heap = (mem_heap_t *) 0x0 offsets_ = {100, 13, 2147483653, 5, 11, 18, 22, 26, 58, 66, 70, 90, 140, 144, 148, 152, 148531008, 140342953, 617, 1091723368, 1091723444, 0, 1847949264, 138120910, 1091723448, 140342953, 617, 1091723368, 1091723444, 3, 1847949344, 138053474, 1091723448, 1, 1847949344, 138053384, 1091761776, 0, 1847949344, 139344069, 1091707244, 1091723444, 1379328, 139344000, 0, 2215985873, 1091761772, 1073982773, 150210072, 0, 1847949376, 1073982773, 149968368, 0, 1847949392, 139346085, 0, 0, 1847949408, 1073982773, 150210072, 0, 1847949424, 1073982773, 149968568, 0, 1847949440, 139346085, 0, 0, 1847949456, 1073982773, 150210072, 0, 1847949472, 139346085, 0, 2, 1847949504, 139353509, 1073993993, 149492704, 1847949504, 139349689, 149492704, 2, 1847949536, 1073982773, 150209584, 0, 1847949536, 139346085, 0, 0, 1847949552, 139346085, 0, 0, 40, 1} offsets = (ulint *) 0x6e257758 #7 0x082accdd in ha_innobase::general_fetch(char*, unsigned, unsigned) (this=0x8e9f018, buf=0x8e9f130 "", direction=1, match_mode=1) at ha_innodb.cc:4064 prebuilt = (row_prebuilt_t *) 0x41322068 ret = 149549080 error = 149549080 _db_func_ = 0x859f581 "do_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x6e257de0 #8 0x082acdd3 in ha_innobase::index_next_same(char*, char const*, unsigned) (this=0x8e9f018, buf=0x8e9f130 "", key=0x8eaa478 "\002", keylen=8) at ha_innodb.cc:4120 No locals. #9 0x08239cff in join_read_next_same (info=0x0) at sql_select.cc:10266 error = 0 table = (TABLE *) 0x8ebb318 tab = (JOIN_TAB *) 0xb #10 0x08238d72 in sub_select(JOIN*, st_join_table*, bool) (join=0x8f51ad0, join_tab=0x8eaa308, end_of_records=11) at sql_select.cc:9696 error = 0 rc = 11 report_error = (my_bool *) 0x8e8e6f8 "" info = (READ_RECORD *) 0x8eaa344 #11 0x0823892c in do_select (join=0x8f51ad0, fields=0x0, table=0x8f41660, procedure=0x0) at sql_select.cc:9454 rc = 0 error = NESTED_LOOP_OK join_tab = (JOIN_TAB *) 0x8eaa308 _db_func_ = 0x859f016 "JOIN::exec" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x6e257e90 #12 0x08228ed5 in JOIN::exec() (this=0x8f51ad0) at sql_select.cc:1377 columns_list = (List *) 0x8f51ad0 tmp_error = 150280912 _db_func_ = 0x859f111 "mysql_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8e8dfe4 curr_join = (JOIN *) 0x8f51ad0 curr_all_fields = (List *) 0x8f52808 curr_fields_list = (List *) 0x8e8df48 curr_tmp_table = (TABLE *) 0x8f41660 #13 0x0822a4cc in mysql_select(THD*, Item***, st_table_list*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*, st_select_lex_unit*, st_select_lex*) ( thd=0x8e8dc40, rref_pointer_array=0x8e8dfe4, tables=0x8ea90e0, wild_num=0, fields=@0x8e8df48, conds=0x8ea97c0, og_num=2, order=0x8ea9a28, group=0x8ea9938, having=0x0, proc_param=0x0, select_options=2147764736, result=0x8ea9ab0, unit=0x8e8dc90, select_lex=0x8e8dec0) at sql_select.cc:1933 err = false free_join = true _db_func_ = 0x859ee72 "handle_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e257f60 join = (JOIN *) 0x8f51ad0 #14 0x082261d2 in handle_select(THD*, st_lex*, select_result*, unsigned long) (thd=0x8e8dc40, lex=0x8e8dc80, result=0x8ea9ab0, setup_tables_done_option=0) at sql_select.cc:238 unit = (SELECT_LEX_UNIT *) 0x8e8dc90 res = 144 select_lex = (SELECT_LEX *) 0x8e8dec0 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x6e257fd0 #15 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8e8dc40) at sql_parse.cc:2541 result = (class select_result *) 0x8ea9ab0 res = false result = 149592752 lex = (LEX *) 0x8e8dc80 select_lex = (SELECT_LEX *) 0x8ea9ab0 first_table = (TABLE_LIST *) 0x8ea90e0 all_tables = (TABLE_LIST *) 0x8ea90e0 unit = (SELECT_LEX_UNIT *) 0x8e8dc90 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e258138 #16 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8e8dc40, inBuf=0x8ea8788 "select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 2 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 90 group by Model order by Model", length=149478528) at sql_parse.cc:5899 lex = (LEX *) 0x8e8dc80 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e25851c #17 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8e8dc40, packet=0x8e8dc40 "(Ùd\b\b»ë\bø`ñ\b<Ùd\bp.õ\b`Üè\b", packet_length=174) at sql_parse.cc:1762 packet_end = 0x8ea8835 "" net = (NET *) 0x8e8e490 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #18 0x081f1886 in do_command(THD*) (thd=0x8e8dc40) at sql_parse.cc:1548 packet = 0x8ea0758 "\003select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 2 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 90 group by Model order by Model" old_timeout = 30 packet_length = 174 net = (NET *) 0x8e8e490 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #19 0x081f0b8f in handle_one_connection (arg=0x0) at sql_parse.cc:1190 error = 0 net = (NET *) 0x8e8e490 sctx = (Security_context *) 0x8e8eca8 thd = (class THD *) 0x8e8dc40 launch_time = 0 set = {__val = {0 }} #20 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 2 (process 17892)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x083b6206 in os_file_pread (file=3, buf=0x44d10000, n=16384, offset=363347968, offset_high=0) at os0file.c:1891 offs = 7934233067474911235 n_bytes = 3 #2 0x083b630e in os_file_read (file=3, buf=0x44d10000, offset=0, offset_high=0, n=16384) at os0file.c:2124 retry = 16384 ret = 16384 #3 0x083b72a5 in os_aio (type=10, mode=24, name=0x41126768 "./ibdata1", file=3, buf=0x44d10000, offset=363347968, offset_high=0, n=16384, message1=0x41126668, message2=0x67a40118) at os0file.c:3376 array = (os_aio_array_t *) 0x15a84000 slot = (os_aio_slot_t *) 0x0 retry = 16384 wake_later = 0 #4 0x0838548b in fil_io (type=10, sync=1, space_id=0, block_offset=0, byte_offset=0, len=16384, buf=0x44d10000, message=0x67a40118) at fil0fil.c:4024 system = (fil_system_t *) 0x41123668 mode = 24 space = (fil_space_t *) 0x15a84000 node = (fil_node_t *) 0x41126668 offset_high = 0 offset_low = 363347968 ret = 16384 is_log = 363347968 wake_later = 0 #5 0x0836debf in buf_read_page_low (err=0x6e1c10a0, sync=1, mode=16384, space=0, tablespace_version=70369898725376, offset=22177) at buf0rea.c:143 block = (buf_block_t *) 0x67a40118 wake_later = 0 #6 0x0836e2c9 in buf_read_page (space=0, offset=22177) at buf0rea.c:331 tablespace_version = 7934233067474911233 count = 0 count2 = 1 err = 10 #7 0x0836645e in buf_page_get_gen (space=0, offset=22177, rw_latch=1, guess=0x0, mode=10, file=0x85cb9f3 "btr0cur.c", line=424, mtr=0x6e1c13c8) at buf0buf.c:1160 block = (buf_block_t *) 0x0 accessed = 1847333744 fix_type = 16384 success = 16384 must_read = 1091713640 #8 0x0835713d in btr_cur_search_to_nth_level (index=0x41332e68, level=0, tuple=0x41356468, mode=1, latch_mode=1, cursor=0x6e1c1828, has_search_latch=0, mtr=0x6e1c13c8) at btr0cur.c:422 tree = (dict_tree_t *) 0x41319e68 page_cursor = (page_cur_t *) 0x6e1c182c page = (ib_page_t *) 0x4
guess = (ib_page_t *) 0x0 page_no = 22177 space = 0 up_match = 1 up_bytes = 3 low_match = 2 low_bytes = 0 height = 0 savepoint = 0 rw_latch = 1 page_mode = 4 insert_planned = 0 buf_mode = 10 estimate = 1024 ignore_sec_unique = 0 root_height = 2 info = (btr_search_t *) 0x41327cd8 heap = (mem_heap_t *) 0x0 offsets_ = {100, 5, 2147483653, 4, 8, 12, 17, 21, 0 , 1091713644, 1847333584, 139344278, 1091713644, 1847352624, 0, 0, 0, 0, 1847333616, 1091713640, 0, 1738759192, 1847333616, 138120910, 1091713644, 140342953, 617, 1091713640, 1847333836, 1738759192, 1847333680, 138104166, 1091713644, 140294675, 43, 0, 0, 0, 0, 1738800328, 1738800328, 0, 1091713640, 1847333852, 1847333836, 1847333832, 1847333712, 138104671, 1738759192, 3, 1847333832, 0, 0, 0, 1847333760, 138102004} offsets = (ulint *) 0x6e1c11c8 #9 0x0835c395 in btr_estimate_n_rows_in_range (index=0x41332e68, tuple1=0x44d10000, mode1=2, tuple2=0x41356468, mode2=1) at btr0cur.c:2718 path1 = {{nth_rec = 1, n_recs = 5}, {nth_rec = 162, n_recs = 306}, {nth_rec = 5, n_recs = 558}, { nth_rec = 4294967295, n_recs = 0}, {nth_rec = 0, n_recs = 0} , {nth_rec = 0, n_recs = 1073982773}, {nth_rec = 150223952, n_recs = 0}, {nth_rec = 1847338320, n_recs = 139346085}, { nth_rec = 0, n_recs = 0}, {nth_rec = 1847338336, n_recs = 139346085}, {nth_rec = 0, n_recs = 0}, { nth_rec = 1847338352, n_recs = 139349689}, {nth_rec = 149925952, n_recs = 2}, {nth_rec = 1847338384, n_recs = 1073982773}, {nth_rec = 150224736, n_recs = 0}, {nth_rec = 1847338384, n_recs = 139346085}, { nth_rec = 0, n_recs = 150224736}, {nth_rec = 1847338384, n_recs = 150223952}, {nth_rec = 56, n_recs = 150224736}, {nth_rec = 1847338416, n_recs = 139349689}, {nth_rec = 149925952, n_recs = 2}, { nth_rec = 1847338448, n_recs = 139353509}, {nth_rec = 1073993993, n_recs = 149925952}, { nth_rec = 1847338448, n_recs = 139353632}, {nth_rec = 140149612, n_recs = 14}, {nth_rec = 4, n_recs = 150224736}, {nth_rec = 150224728, n_recs = 150261320}, {nth_rec = 1847339360, n_recs = 136866540}, {nth_rec = 5386, n_recs = 1847338520}, {nth_rec = 1847338524, n_recs = 1847338528}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 1847348184}, { nth_rec = 150224736, n_recs = 0}, {nth_rec = 0, n_recs = 0}, {nth_rec = 140150644, n_recs = 140149612}, { nth_rec = 13, n_recs = 0}, {nth_rec = 0, n_recs = 0} , {nth_rec = 0, n_recs = 12}, { nth_rec = 0, n_recs = 143857592}, {nth_rec = 1847338768, n_recs = 138090970}, {nth_rec = 13, n_recs = 143857448}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 11}, { nth_rec = 0, n_recs = 143857580}, {nth_rec = 1847338816, n_recs = 138090970}, {nth_rec = 12, n_recs = 143857464}, {nth_rec = 1847338832, n_recs = 139344278}, {nth_rec = 143857464, n_recs = 1847352624}, {nth_rec = 0, n_recs = 10}, {nth_rec = 0, n_recs = 0}, {nth_rec = 1847338864, n_recs = 1094018072}, {nth_rec = 143857460, n_recs = 143857448}, {nth_rec = 1847338864, n_recs = 138120910}, {nth_rec = 143857464, n_recs = 140342953}, {nth_rec = 617, n_recs = 143857460}, { nth_rec = 10, n_recs = 143857448}, {nth_rec = 1847338912, n_recs = 138092229}, {nth_rec = 143857464, n_recs = 140294675}, {nth_rec = 43, n_recs = 138413337}, {nth_rec = 1094018092, n_recs = 140304660}, { nth_rec = 8, n_recs = 500}, {nth_rec = 1094018088, n_recs = 0}, {nth_rec = 1847338960, n_recs = 138089531}, {nth_rec = 1094018092, n_recs = 140304656}, {nth_rec = 8, n_recs = 139349689}, {nth_rec = 149925952, n_recs = 2}, {nth_rec = 1847338992, n_recs = 4}, {nth_rec = 1094018212, n_recs = 4}, {nth_rec = 1847339040, n_recs = 138247305}, {nth_rec = 1094018212, n_recs = 149554636}, {nth_rec = 1847339040, n_recs = 138247589}, {nth_rec = 1094018152, n_recs = 2}, {nth_rec = 1847339024, n_recs = 137850585}, { nth_rec = 2, n_recs = 1847344294}, {nth_rec = 0, n_recs = 0}} path2 = {{nth_rec = 1, n_recs = 5}, {nth_rec = 163, n_recs = 306}, {nth_rec = 0, n_recs = 0} , {nth_rec = 0, n_recs = 1073982773}, {nth_rec = 0, n_recs = 0}, { nth_rec = 1847336080, n_recs = 139346085}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, { nth_rec = 0, n_recs = 0}, {nth_rec = 1847336112, n_recs = 139349689}, {nth_rec = 149925952, n_recs = 2}, { nth_rec = 1847336144, n_recs = 139353509}, {nth_rec = 1073993993, n_recs = 149925952}, { nth_rec = 1847336144, n_recs = 139353632}, {nth_rec = 149749248, n_recs = 150262816}, { nth_rec = 1847336240, n_recs = 0}, {nth_rec = 150262816, n_recs = 150266200}, {nth_rec = 1847336240, n_recs = 1073982773}, {nth_rec = 150192848, n_recs = 0}, {nth_rec = 1847336192, n_recs = 139346085}, { nth_rec = 0, n_recs = 0}, {nth_rec = 16777216, n_recs = 150197472}, {nth_rec = 140150945, n_recs = 140149612}, {nth_rec = 1847336224, n_recs = 139349689}, {nth_rec = 149925952, n_recs = 2}, { nth_rec = 1847336256, n_recs = 139353509}, {nth_rec = 1073993993, n_recs = 149925952}, { nth_rec = 1847336256, n_recs = 139353632}, {nth_rec = 1091154500, n_recs = 150262816}, { nth_rec = 1847339728, n_recs = 150192848}, {nth_rec = 150197460, n_recs = 150262816}, { nth_rec = 1847339728, n_recs = 136893192}, {nth_rec = 8511, n_recs = 1847336600}, {nth_rec = 1847336604, n_recs = 1847336608}, {nth_rec = 0, n_recs = 0} , {nth_rec = 0, n_recs = 65536}, { nth_rec = 150255752, n_recs = 149749320}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, { nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, {nth_rec = 0, n_recs = 0}, { nth_rec = 0, n_recs = 0}, {nth_rec = 140149765, n_recs = 140149612}, {nth_rec = 10, n_recs = 0}, { nth_rec = 149750096, n_recs = 149750096}, {nth_rec = 0, n_recs = 0} } cursor = {index = 0x41332e68, page_cur = {rec = 0x44b750f1 "\200"}, left_page = 0x0, thr = 0x0, flag = 3, tree_height = 3, up_match = 2, up_bytes = 0, low_match = 0, low_bytes = 3, n_fields = 0, n_bytes = 0, fold = 0, path_arr = 0x6e1c1868} slot1 = (btr_path_t *) 0x44d10000 slot2 = (btr_path_t *) 0x6e1c13c8 diverged = 0 diverged_lot = 0 divergence_level = 0 n_rows = 0 i = 0 mtr = {state = 0, memo = {heap = 0x0, used = 24, data = "7\000\000\000¼\2361A\003\000\000\000\030\\£g\003\000\000\000\230f£g\001", '\0' , base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}}, log = {heap = 0x0, used = 0, data = '\0' , base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 0, low = 0}, end_lsn = {high = 0, low = 0}, magic_n = 0} #10 0x082ae468 in ha_innobase::records_in_range(unsigned, st_key_range*, st_key_range*) (this=0x8f4c868, keynr=1093873256, min_key=0x6e1c28f8, max_key=0x6e1c28e8) at ha_innodb.cc:5224 prebuilt = (row_prebuilt_t *) 0x41353668 key = (KEY *) 0x8f4d06c index = (dict_index_t *) 0x41332e68 key_val_buff2 = (mysql_byte *) 0x8ea05c8 "\200" buff2_len = 255 range_start = (dtuple_t *) 0x41356068 range_end = (dtuple_t *) 0x41356468 n_rows = 7934233067625173100 mode1 = 16384 heap1 = (void *) 0x41356028 heap2 = (void *) 0x41356428 _db_func_ = 0x85a87c0 "check_quick_select" _db_file_ = 0x85a836c "opt_range.cc" _db_level_ = 12 _db_framep_ = (char **) 0x0 #11 0x08289830 in check_quick_keys (param=0x6e1c2b58, idx=0, key_tree=0x8f43f60, min_key=0x6e1c2da4 "", min_key_flag=0, max_key=0x6e1c3ca2 "", max_key_flag=0) at opt_range.cc:6830 min_range = {key = 0x6e1c2da0 "\n", length = 8, flag = HA_READ_KEY_EXACT} max_range = {key = 0x6e1c3c9e "\n", length = 8, flag = HA_READ_AFTER_KEY} records = 0 tmp = 605050975203377152 tmp_min_flag = 0 tmp_max_flag = 0 keynr = 1 min_key_length = 8 max_key_length = 8 tmp_min_key = 0x6e1c2da8 "" tmp_max_key = 0x6e1c3ca6 "" #12 0x082894b4 in check_quick_keys (param=0x6e1c2b58, idx=0, key_tree=0x8f43df0, min_key=0x6e1c2da0 "\n", min_key_flag=0, max_key=0x6e1c3c9e "\n", max_key_flag=0) at opt_range.cc:6746 records = 0 tmp = 7934283292822487040 tmp_min_flag = 0 tmp_max_flag = 0 keynr = 0 min_key_length = 4 max_key_length = 4 tmp_min_key = 0x6e1c2da4 "" tmp_max_key = 0x6e1c3ca2 "" #13 0x0828914b in check_quick_select (param=0x6e1c2b58, idx=0, tree=0x8f43df0) at opt_range.cc:6640 records = 643927061735659785 cpk_scan = false key = 1 _db_func_ = 0x85a86de "get_key_scans_params" _db_file_ = 0x85a836c "opt_range.cc" _db_level_ = 11 _db_framep_ = (char **) 0x8f3dad0 #14 0x08284df5 in get_key_scans_params (param=0x6e1c2b58, tree=0x8f43cb8, index_read_must_be_used=false, read_time=210504.5) at opt_range.cc:4441 keynr = 1 read_index_only = false cpu_cost = 2.3050807586525758e-269 found_records = 7934233069322251096 found_read_time = 2.5453637994706503e+222 idx = 0 key = (SEL_ARG **) 0x8f43cbc end = (SEL_ARG **) 0x8f43cc0 key_to_read = (SEL_ARG **) 0x0 best_records = 7934263426151099016 read_plan = (TRP_RANGE *) 0x0 pk_is_clustered = true _db_func_ = 0x85a8405 "SQL_SELECT::test_quick_select" _db_file_ = 0x85a836c "opt_range.cc" _db_level_ = 10 _db_framep_ = (char **) 0x8280d40 #15 0x08281565 in SQL_SELECT::test_quick_select(THD*, Bitmap<64>, unsigned long long, unsigned long long, bool) (this=0x8f3dad0, thd=0x8ecfe48, keys_to_use={map = 2}, prev_tables=0, limit=7934233067474911232, force_quick_range=false) at opt_range.cc:1999 range_trp = (TRP_RANGE *) 0x4000 rori_trp = (TRP_ROR_INTERSECT *) 0x4000 can_build_covering = false alloc = {free = 0x8f43c50, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2020, block_num = 5, first_block_usage = 0, error_handler = 0x81a2e08 } tree = (SEL_TREE *) 0x8f43cb8 key_parts = (KEY_PART *) 0x8f43c9c param = { = {thd = 0x8ecfe48, table = 0x8f4b888, cond = 0x8f3d6e8, prev_tables = 0, read_tables = 0, current_table = 1, key_parts = 0x8f43c60, key_parts_end = 0x8f43c9c, mem_root = 0x6e1c4bd8, old_root = 0x8ecfe68, keys = 1, using_real_indexes = true, remove_jump_scans = true, real_keynr = {1, 143857464, 140342953, 617, 0, 9, 143857448, 1847340000, 138092229, 143857464, 143857448, 43, 138413337, 1093776428, 140384361, 8, 256, 1093776424, 0, 1847340048, 138089531, 1093776428, 140384359, 8, 1093775960, 0, 1091707240, 1847340064, 0, 0, 1091707240, 1847340096, 138392343, 0, 1091707244, 1847340112, 139344278, 1091707244, 1847352624, 43, 139344000, 1093775960, 1093775464, 1847340144, 1073982773, 1093767272, 0, 1847340144, 139346085, 0, 0, 0, 0, 0, 0, 1847340176, 139349689, 149509680, 0, 1847340208, 139353509, 1073993993, 149509680, 1847340208}}, key = {0x8f43c60, 0x0, 0x8f06ab8, 0x6e1c2cb0, 0x41319068, 0x2, 0x0, 0x6e1c3ed0, 0x82aec3d, 0x15c8, 0x6e1c2ce8, 0x6e1c2cec, 0x6e1c2cf0, 0xa, 0x0, 0x0, 0x1, 0x41318068, 0x41319068, 0x0, 0x42174000, 0x85ae0c2, 0x85adf66, 0xc, 0x0, 0x1, 0x8931738, 0x6e1c2d30, 0x84e3996, 0x8931738, 0x6e1c5d30, 0x0, 0x0, 0x0, 0x0, 0x6e1c2d50, 0x41354c18, 0x8931734, 0x8931728, 0x6e1c2d50, 0x83b8ece, 0x8931738, 0x85d76a9, 0x269, 0x0, 0x9, 0x8931728, 0x6e1c2d80, 0x83b1ec5, 0x8931738, 0x8931728, 0x2b, 0x8400519, 0x41354c2c, 0x85e1869, 0x8, 0x100, 0x41354c28, 0x0, 0x6e1c2db0, 0x83b143b, 0x41354c2c, 0x85e1867, 0x8}, baseflag = 4301980, max_key_part = 1, range_count = 1, min_key = "\n", '\0' , "h!\022Aà-\034n\027³?\b\000\000\000\000l!\022Að-\034n\2269N\bl!\022A0]\034n+\000\000\000(.\034nXJ5AhH5A\020.\034n5­\003@h65A\000\000\000\000\020.\034n¥@N\b\000\000\000\000\000\000\000\000ª\223", '\0' , "0.\034n¹NN\b@°ï\b\026\000\000\000P.\034n¥]N\b\tÙ\003@@°ï\bP.\034n ^N\b\000\000\000\000hÈô\bP.\034nh65A\003\000\000\000\000\000\000\000p@\034n=ì*\bÈ\025\000\000\210.\034n\214.\034n\220.\034n, "@=\034n_\001\000\000È\201\224g¸\201\224g@=\034nÎ\216;\bÌ\201\224g©v]\bi\002\000\000È\201\224g\000\000\000\000Ì\201\224gp=\034n\2269N\bÌ\201\224g0]\034nò2]\b\2008N\b\230\201\224g\000\000\000\000\220=\034nÈ\201\224"..., quick = 8, fields_bitmap_size = 4, needed_fields = {bitmap = 0x8f43cb0, n_bits = 32, last_word_mask = 0, last_word_ptr = 0x8f43cb0, mutex = 0x0}, needed_reg = 0x8f3dbb8, imerge_cost_buff = 0x8efb040, imerge_cost_buff_size = 0, is_ror_scan = false, n_ranges = 1} best_trp = (TABLE_READ_PLAN *) 0x0 best_read_time = 2.5355894705660884e+222 key_info = (KEY *) 0x0 group_trp = (TRP_GROUP_MIN_MAX *) 0x4000 idx = 150198992 scan_time = 200028.39999999999 _db_func_ = 0x859f11e "get_quick_record_count" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 9 _db_framep_ = (char **) 0x0 #16 0x0822a614 in get_quick_record_count (thd=0x8ecfe48, select=0x8f3dad0, table=0x8f4b888, keys=0x4000, limit=7934233071769878527) at sql_select.cc:1976 error = 16384 _db_func_ = 0x859f135 "make_join_statistics" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x1 #17 0x0822b6d9 in make_join_statistics (join=0x8f4d420, tables=0x0, conds=0x8f3d090, keyuse_array=0x8f4e140) at sql_select.cc:2304 records = 645096288198590480 select = (SQL_SELECT *) 0x8f3dad0 error = 0 table = (TABLE *) 0x8f4b888 i = 1 table_count = 1 const_count = 0 key = 150198200 found_const_table_map = 0 all_table_map = 1 found_ref = 0 refs = 0 const_ref = {map = 3} eq_part = {map = 3} table_vector = (TABLE **) 0x8f3da20 stat = (JOIN_TAB *) 0x8f3d7b8 stat_end = (JOIN_TAB *) 0x8f3d928 s = (JOIN_TAB *) 0x8f3d7b8 stat_ref = (JOIN_TAB **) 0x8f3d928 keyuse = (KEYUSE *) 0x8f4d420 start_keyuse = (KEYUSE *) 0x8f4f3f8 outer_join = 0 stat_vector = {0x8f3d7b8, 0x0, 0x6e1c4dd0, 0x8234197, 0x8f3d6e8, 0x6e1c4da8, 0x6e1c4d90, 0x84e4eb9, 0x8f3d758, 0x8778270, 0x0, 0x0, 0x6e1c4db0, 0x8778270, 0x0, 0x8f3d6e8, 0x8f4d420, 0x8f4e154, 0x6e1c4e40, 0x8234cde, 0x8ecfe48, 0x8f3d6e8, 0x6e1c4e14, 0x8f3d780, 0x8f3d100, 0x8778270, 0x0, 0x8f3d090, 0x8f3d090, 0x0, 0x6e1c4e40, 0x4003ad35, 0x0, 0x0, 0x6e1c4e00, 0x84e40a5, 0x0, 0x0, 0x6e1c4e10, 0x84e40a5, 0x0, 0x6e1c4e08, 0x6e1c4e20, 0x84e4eb9, 0x8efb040, 0x2, 0x6e1c4e40, 0x84e5da5, 0x4003d909, 0x8efb040, 0x6e1c4e40, 0x84e5e20, 0x0, 0x0, 0x6e1c4e40, 0x0, 0x0, 0x0, 0x6e1c4e80, 0x823e600, 0x31a2, 0x6e1c4e60} _db_func_ = 0x859eee3 "JOIN::optimize" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x875ce20 ref_changed = 0 #18 0x0822720b in JOIN::optimize() (this=0x8f4d420) at sql_select.cc:710 _db_func_ = 0x859f111 "mysql_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8ed00c8 sel = (SELECT_LEX *) 0x8f4b888 #19 0x0822a46f in mysql_select(THD*, Item***, st_table_list*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*, st_select_lex_unit*, st_select_lex*) ( thd=0x8ecfe48, rref_pointer_array=0x8ed01ec, tables=0x8f3c9b0, wild_num=0, fields=@0x8ed0150, conds=0x8f3d090, og_num=2, order=0x8f3d2f8, group=0x8f3d208, having=0x0, proc_param=0x0, select_options=2147764736, result=0x8f3d380, unit=0x8ecfe98, select_lex=0x8ed00c8) at sql_select.cc:1919 err = false free_join = true _db_func_ = 0x859ee72 "handle_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e1c4f60 join = (JOIN *) 0x8f4d420 #20 0x082261d2 in handle_select(THD*, st_lex*, select_result*, unsigned long) (thd=0x8ecfe48, lex=0x8ecfe88, result=0x8f3d380, setup_tables_done_option=0) at sql_select.cc:238 unit = (SELECT_LEX_UNIT *) 0x8ecfe98 res = 152 select_lex = (SELECT_LEX *) 0x8ed00c8 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x6e1c4fd0 #21 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ecfe48) at sql_parse.cc:2541 result = (class select_result *) 0x8f3d380 res = false result = 150197120 lex = (LEX *) 0x8ecfe88 select_lex = (SELECT_LEX *) 0x8f3d380 first_table = (TABLE_LIST *) 0x8f3c9b0 all_tables = (TABLE_LIST *) 0x8f3c9b0 unit = (SELECT_LEX_UNIT *) 0x8ecfe98 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e1c5138 #22 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8ecfe48, inBuf=0x8f3c058 "select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 10 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 60 group by Model order by Model", length=149749384) at sql_parse.cc:5899 lex = (LEX *) 0x8ecfe88 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e1c551c #23 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8ecfe48, packet=0x8ecfe48 "(Ùd\bØ\230w\bXÖé\b<Ùd\bèÖó\bØK\034n", packet_length=175) at sql_parse.cc:1762 packet_end = 0x8f3c106 "" net = (NET *) 0x8ed0698 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #24 0x081f1886 in do_command(THD*) (thd=0x8ecfe48) at sql_parse.cc:1548 packet = 0x8ed3410 "\003select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 10 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 60 group by Model order by Model" old_timeout = 30 packet_length = 175 net = (NET *) 0x8ed0698 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #25 0x081f0b8f in handle_one_connection (arg=0x4000) at sql_parse.cc:1190 error = 16384 net = (NET *) 0x8ed0698 sctx = (Security_context *) 0x8ed0eb0 thd = (class THD *) 0x8ecfe48 launch_time = 16384 set = {__val = {0 }} #26 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 3 (process 17891)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x083b8ab2 in os_event_wait (event=0x87aae9c) at os0sync.c:336 old_signal_count = 7705171329024 #2 0x083e7a94 in sync_array_wait_event (arr=0x87aabd0, index=2) at sync0arr.c:480 cell = (sync_cell_t *) 0x400ac078 event = 0xfffffffc #3 0x083e93c5 in rw_lock_x_lock_func (lock=0x41123c68, pass=0, file_name=0x85d855d "page0page.c", line=197) at sync0rw.c:539 index = 2 state = 1091714168 i = 0 #4 0x083bd60a in page_set_max_trx_id (page=0x435cc000 "F\216\217³", trx_id={high = 0, low = 203964}) at page0page.c:197 block = (buf_block_t *) 0x679b4798 #5 0x083a48db in lock_rec_insert_check_and_lock (flags=0, rec=0x435cc07d "\200", index=0x41319668, thr=0x41338440, inherit=0x6e22659c) at page0page.ic:45 next_rec = (rec_t *) 0x435cc070 "supremum" trx = (trx_t *) 0x41357068 err = 138128825 #6 0x0835ec4b in btr_cur_ins_lock_and_undo (flags=0, cursor=0xfffffffc, entry=0x4133a868, thr=0x41338440, inherit=0x6e22659c) at btr0cur.c:859 index = (dict_index_t *) 0x41319668 err = 4294967292 roll_ptr = {high = 1091713644, low = 140342953} #7 0x08358788 in btr_cur_optimistic_insert (flags=0, cursor=0x6e226bf8, entry=0x4133a868, rec=0x6e226600, big_rec=0x6e226604, thr=0x41338440, mtr=0x6e226798) at btr0cur.c:1021 big_rec_vec = (big_rec_t *) 0x0 index = (dict_index_t *) 0x41319668 page = (ib_page_t *) 0x435cc000 "F\216\217³" max_size = 16231 dummy_rec = (rec_t *) 0x0 level = 0 reorg = 138120910 inherit = 0 rec_size = 20 type = 0 err = 140 #8 0x083cb417 in row_ins_index_entry_low (mode=2, index=0x41319668, entry=0x4133a868, ext_vec=0x0, n_ext_vec=0, thr=0x41338440) at row0ins.c:2090 cursor = {index = 0x41319668, page_cur = {rec = 0x435cc07d "\200"}, left_page = 0x6e226c20 "@l\"n¹NN\b¨Áî\b\026", thr = 0x41338440, flag = 3, tree_height = 2, up_match = 1, up_bytes = 4, low_match = 2, low_bytes = 3, n_fields = 1847749696, n_bytes = 139349689, fold = 149864872, path_arr = 0x16} ignore_sec_unique = 0 modify = 0 insert_rec = (rec_t *) 0x44b0e199 "" err = 10 big_rec = (big_rec_t *) 0x0 mtr = {state = 52698, memo = {heap = 0x0, used = 24, data = "7\000\000\000\000\000\000\000\003\000\000\000\030\\\224g\002\000\000\000\230G\233g\002\000\000\000\000\000\000\000h`\022A´`\022A\000\000\000\000 h\"nÞ\207:\bØgÚ\b\023º\\\b+\000\000\000\036õ?\bpö\022A\000\000\000\000 h\"nÅ8N\bl!\022A´`\022A h\"n\2008N\b\000\000\000\000c?\025\204lö\022Ah!\022A\000\000\000\000h!\022AÐl\"n}\226?\bhP2A\000\000\000\000+\000\000\000\001\000\000\000\000\000\000\000\003\000\000\000\000\000\000\0005­\003@\203k\"n\000\000\000\000ph\"n5­\003@\bi\"n\000\000\000\000\200h\"n¥@N\b\000\000\000\000"..., base = {count = 139353509, start = 0x4003d909, end = 0x8eec1a8}, list = {prev = 0x6e2269d0, next = 0x84e5e20}}, log = {heap = 0x0, used = 0, data = "¦\000À\214g\000\016\000\001\200\006\200\006\200\a\200\004\200\004\200\005\200 \200\b\200\004\200\024\2002\200\004\200\004\200\004 ö\2012<\000\000\000\003\034¼\200\000\001\000(\001\020\200\000\000\t\200\000\000\005\200\000\000\000\000Hammer", ' ' , "®Gáz\024®\"@\200\000\000\004in the morning Works well with nails", ' ' , "\200\000\000\b\200\000\000\003\200\000\000\002\"n`ýò\b`ýò\b\000\000\000\000ðj\"nü³!\b¢\017\000\000¸j\"n¼j\"nÀj\"n ´ï"..., base = {count = 1847749664, start = 0x6e226bf8, end = 0x6e226d60}, list = {prev = 0x6e226c30, next = 0x6e226c50}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 0, low = 2215993235}, end_lsn = {high = 0, low = 2215993445}, magic_n = 1847749648} heap = (mem_heap_t *) 0x0 offsets_ = {100, 1847754032, 1, 139344000, 1074446360, 1074446408, 1847754528, 148461104, 0, 5632, 1847748176, 138120910, 148461016, 140342953, 617, 0, 2048, 0, 1847748208, 138120361, 148461016, 5632, 1847748240, 138109618, 8, 2048, 1847748240, 138109660, 148461104, 0, 1073987506, 0, 118822400, 2048, 1847748304, 138110048, 8, 1753822208, 2048, 118822400, 0, 524283904, 1, 0, 0, 0, 118822336, 0, 118822336, 0, 0, 0, 118822336, 1737776972, 1847748368, 139344278, 1737776972, 1847754032, 524283904, 0, 1847748400, 0, 1847748400, 351, 1737776968, 1737776952, 1073987506, 138120910, 1737776972, 140342953, 617, 1737776968, 1847754528, 1847754032, 148531236, 148531236, 0, 1847748512, 1073980533, 148531184, 148531236, 148531160, 1847748480, 139344278, 148531160, 1847754032, 1073980344, 0, 148531160, 0, 1847748512, 148531160, 52698, 0, 1847748512, 138120910, 148531160, 140342953, 617, 148531160} offsets = (ulint *) 0x6e226608 #9 0x083cb661 in row_ins_index_entry (index=0x41319668, entry=0x4133a868, ext_vec=0x0, n_ext_vec=0, thr=0x41338440) at row0ins.c:2174 err = 4294967292 #10 0x083cb745 in row_ins_index_entry_step (node=0x413380a8, thr=0x41338440) at row0ins.c:2253 err = 4294967292 #11 0x083cb908 in row_ins (node=0x413380a8, thr=0x41338440) at row0ins.c:2385 err = 4294967292 #12 0x083cba5c in row_ins_step (thr=0x41338440) at row0ins.c:2495 node = (ins_node_t *) 0x413380a8 parent = (que_node_t *) 0x41338440 sel_node = (sel_node_t *) 0x0 trx = (trx_t *) 0x41357068 err = 4294967292 #13 0x083cd6ad in row_insert_for_mysql (mysql_rec=0x8f2f7d8 "ÿ\t", prebuilt=0x41336868) at row0mysql.c:1147 savept = {least_undo_no = {high = 0, low = 0}} thr = (que_thr_t *) 0x41338440 err = 149864872 was_lock_wait = 4294967292 trx = (trx_t *) 0x41357068 node = (ins_node_t *) 0x413380a8 #14 0x082abf71 in ha_innobase::write_row(char*) (this=0x8f2f6c0, record=0x8f2f7d8 "ÿ\t") at ha_innodb.cc:3312 prebuilt = (row_prebuilt_t *) 0x41336868 error = 1094021224 auto_inc = 4294967292 dummy = 586002260222438896 auto_inc_used = 0 _db_func_ = 0x85ebea4 "write_record" _db_file_ = 0x85a04c0 "sql_insert.cc" _db_level_ = 6 _db_framep_ = (char **) 0x16 #15 0x0829b1e2 in handler::ha_write_row(char*) (this=0x8f2f6c0, buf=0x8f2f7d8 "ÿ\t") at handler.cc:3295 error = 1794 #16 0x082454db in write_record(THD*, st_table*, st_copy_info*) (thd=0x8e9d658, table=0x8f2f078, info=0x6e226f58) at sql_insert.cc:1131 error = 149743600 trg_error = 0 key = 0x0 _db_func_ = 0x85a04ce "mysql_insert" _db_file_ = 0x85a04c0 "sql_insert.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e226fc0 #17 0x08244488 in mysql_insert(THD*, st_table_list*, List&, List >&, List&, List&, enum_duplicates, bool) (thd=0x8e9d658, table_list=0x8ecdf90, fields=@0x8e9db30, values_list=@0x8e9db54, update_fields=@0x8e9db48, update_values=@0x8e9db3c, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:519 error = 1 res = -4 log_on = true transactional_table = 240 joins_freed = false changed = 144 value_count = 11 counter = 1 id = 0 info = {records = 1, deleted = 0, updated = 0, copied = 0, error_count = 643664725133220105, handle_duplicates = DUP_ERROR, escape_char = 139353632, last_errno = 149542552, ignore = false, update_fields = 0x8e9db48, update_values = 0x8e9db3c, view = 0x0} table = (TABLE *) 0x8f2f078 its = { = {list = 0x8e9db54, el = 0x8eceee8, prev = 0x0, current = 0x0}, } values = (List_item *) 0x8ece7f0 context = (Name_resolution_context *) 0x1 ctx_state = {save_table_list = 0x8ecdf90, save_first_name_resolution_table = 0x8ecdf90, save_next_name_resolution_table = 0x0, save_resolve_in_select_list = false, save_next_local = 0x0} query = 0x8ecde40 "insert into SH_InsertTable(Project_Number,Model,ProductID,Product_Name,Price,Class,Evaluations,Description,EmployeeID,Type,VendorID) \t\tvalues (9,5,0,'Hammer',9.34,4,'in the morning','Works well with n"... lock_type = TL_WRITE_CONCURRENT_INSERT unused_conds = (class Item *) 0x0 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x0 #18 0x081f520b in mysql_execute_command(THD*) (thd=0x8e9d658) at sql_parse.cc:3332 res = false result = 0 lex = (LEX *) 0x8e9d698 select_lex = (SELECT_LEX *) 0x8e9d8d8 first_table = (TABLE_LIST *) 0x8ecdf90 all_tables = (TABLE_LIST *) 0x8ecdf90 unit = (SELECT_LEX_UNIT *) 0x8e9d6a8 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e227138 #19 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8e9d658, inBuf=0x8ecde40 "insert into SH_InsertTable(Project_Number,Model,ProductID,Product_Name,Price,Class,Evaluations,Description,EmployeeID,Type,VendorID) \t\tvalues (9,5,0,'Hammer',9.34,4,'in the morning','Works well with n"..., length=149542552) at sql_parse.cc:5899 lex = (LEX *) 0x8e9d698 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e22751c #20 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8e9d658, packet=0x8e9d658 "(Ùd\bPþì\b\b\212î\b<Ùd\b`îì\bxÖé\b", packet_length=213) at sql_parse.cc:1762 packet_end = 0x8ecdf14 "" net = (NET *) 0x8e9dea8 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #21 0x081f1886 in do_command(THD*) (thd=0x8e9d658) at sql_parse.cc:1548 packet = 0x8eb1990 "\003insert into SH_InsertTable(Project_Number,Model,ProductID,Product_Name,Price,Class,Evaluations,Description,EmployeeID,Type,VendorID) \t\tvalues (9,5,0,'Hammer',9.34,4,'in the morning','Works well with "... old_timeout = 30 packet_length = 213 net = (NET *) 0x8e9dea8 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #22 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 error = -4 net = (NET *) 0x8e9dea8 sctx = (Security_context *) 0x8e9e6c0 thd = (class THD *) 0x8e9d658 launch_time = 4294967292 set = {__val = {0 }} #23 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 4 (process 17890)]#0 JOIN (this=0x8f4f780, thd_arg=0x8ee8a08, fields_arg=@0x8ee8d10, select_options_arg=2147764736, result_arg=0x8f14218) at sql_list.h:93 in sql_list.h #0 JOIN (this=0x8f4f780, thd_arg=0x8ee8a08, fields_arg=@0x8ee8d10, select_options_arg=2147764736, result_arg=0x8f14218) at sql_list.h:93 No locals. #1 0x0822a3ec in mysql_select(THD*, Item***, st_table_list*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*, st_select_lex_unit*, st_select_lex*) ( thd=0x8ee8a08, rref_pointer_array=0x8ee8dac, tables=0x8f131a8, wild_num=0, fields=@0x8ee8d10, conds=0x8f13f18, og_num=2, order=0x8f14190, group=0x8f14098, having=0x0, proc_param=0x0, select_options=2147764736, result=0x8f14218, unit=0x8ee8a58, select_lex=0x8ee8c88) at sql_list.h:28 err = 128 free_join = true _db_func_ = 0x859ee72 "handle_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e1f5f60 join = (JOIN *) 0x8ee8c88 #2 0x082261d2 in handle_select(THD*, st_lex*, select_result*, unsigned long) (thd=0x8ee8a08, lex=0x8ee8a48, result=0x8f14218, setup_tables_done_option=0) at sql_select.cc:238 unit = (SELECT_LEX_UNIT *) 0x8ee8a58 res = 88 select_lex = (SELECT_LEX *) 0x8ee8c88 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x6e1f5fd0 #3 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ee8a08) at sql_parse.cc:2541 result = (class select_result *) 0x8f14218 res = false result = 150028824 lex = (LEX *) 0x8ee8a48 select_lex = (SELECT_LEX *) 0x8f14218 first_table = (TABLE_LIST *) 0x8f131a8 all_tables = (TABLE_LIST *) 0x8f131a8 unit = (SELECT_LEX_UNIT *) 0x8ee8a58 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e1f6138 #4 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8ee8a08, inBuf=0x8f127a0 "select PR.Model,avg(P.Price),min(P.Price),max(P.Price),count(*) \t\t\t from SH_Product PR,SH_Part P \t\t\t\twhere (PR.Project_Number = 8 \t\t\t\tor PR.Project_Number = 68) \t\t\t\tand PR.EmployeeID = 3 \t\t\t\tand P"..., length=149850696) at sql_parse.cc:5899 lex = (LEX *) 0x8ee8a48 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e1f651c #5 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8ee8a08, packet=0x8ee8a08 "(Ùd\b`Öé\bÈÀê\b<Ùd\bÀAñ\b(\212î\b", packet_length=293) at sql_parse.cc:1762 packet_end = 0x8f128c4 "" net = (NET *) 0x8ee9258 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #6 0x081f1886 in do_command(THD*) (thd=0x8ee8a08) at sql_parse.cc:1548 packet = 0x8f0a770 "\003select PR.Model,avg(P.Price),min(P.Price),max(P.Price),count(*) \t\t\t from SH_Product PR,SH_Part P \t\t\t\twhere (PR.Project_Number = 8 \t\t\t\tor PR.Project_Number = 68) \t\t\t\tand PR.EmployeeID = 3 \t\t\t\tand "... old_timeout = 30 packet_length = 293 net = (NET *) 0x8ee9258 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #7 0x081f0b8f in handle_one_connection (arg=0x8f503ac) at sql_parse.cc:1190 error = 150274988 net = (NET *) 0x8ee9258 sctx = (Security_context *) 0x8ee9a70 thd = (class THD *) 0x8ee8a08 launch_time = 150274988 set = {__val = {0 }} #8 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 5 (process 17889)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x083b8ab2 in os_event_wait (event=0x8da6834) at os0sync.c:336 old_signal_count = 631179803885568 #2 0x083a87de in log_write_up_to (lsn={high = 0, low = 2215994283}, wait=92, flush_to_disk=1) at log0log.c:1504 group = (log_group_t *) 0x411260b4 start_offset = 138120910 area_start = 0 area_end = 1849153440 #3 0x083f9593 in trx_commit_off_kernel (trx=0x41353068) at trx0trx.c:931 update_hdr_page = (ib_page_t *) 0xfffffffc
lsn = {high = 0, low = 2215994283} rseg = (trx_rseg_t *) 0x0 undo = (trx_undo_t *) 0x41130468 must_flush_log = 1 mtr = {state = 150253576, memo = {heap = 0x0, used = 16, data = "\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\200\001\001\001\222ÅY\b¼¾Y\b\a\000\000\000h!\022A\000\000\000\000h!\022AÐÜ7n}\226?\bhP3A\000\000\000\000\b\000\000\000\002\000\000\000\000\000\000\000\000\226é\b Ù7n·¶!\bÈÀê\b\000\226é\b \231é\b\t\000\000\000 \231é\b\000\000\000\000\000\000\000\000\\\232é\b\001\000\000\000\001\000\000\000\224\231é\b\001\000\000\000¤Ø7n\000\000\000\000 Ø7n¹NN\b`éë\b\000\000\000\001\t\000\000\000 \231é\b\000\000\000\000\b°ô\bÀØ\001\001\000\226é\b\022Ù7n"..., base = {count = 0, start = 0x8e999c0, end = 0x8e99a10}, list = {prev = 0x6e37db30, next = 0x81784f3}}, log = {heap = 0x0, used = 108, data = "\002\000ÀÀ\002\0008\002\004\000ÀÀ\002\030Tðÿÿÿÿ\002\000ÀÀ\002\030X\000\004\000ÀÀ\002\030ZÀÀ\002\002\000ÀÀ\002\030^\227h\004\000\006\0002ÀÀ\002\002\000\006\0006\230T\004\000ÀÀ\002\027hÀÀ\002\002\000ÀÀ\002\027l\230T\004\000\006\000.\017\b\000ÀÀ\002\030:\000\000\003\034¿\002\000ÀÀ\002\030B\000\0372\200\004\200\004\200\004\002\001\000\000\000À\002\030ì\000\000\003\034¹\017Ò\000\001\b\024", 'u' , "\000\000\000\000\000ÀÚ7n¥@N\b\000\000\000\000`éë\bÐÚ7n¹NN\b`éë\b\002\000\000\000ðÚ7n5­\003@ð±ô\b\000\000\000\000ðÚ"..., base = { count = 1849154608, start = 0x4134cd18, end = 0x8931734}, list = {prev = 0x8931728, next = 0x6e37dc30}}, modifications = 1, n_log_recs = 12, log_mode = 21, start_lsn = {high = 0, low = 2215994175}, end_lsn = { high = 0, low = 2215994283}, magic_n = 1849154656} #4 0x083fa532 in trx_commit_for_mysql (trx=0x41353068) at trx0trx.c:1609 No locals. #5 0x082aa38a in innobase_commit_low(trx_struct*) (trx=0x41353068) at ha_innodb.cc:1568 No locals. #6 0x082aa60d in innobase_commit (thd=0x8eac0c8, all=false) at ha_innodb.cc:1700 trx = (trx_t *) 0x41353068 _db_func_ = 0x85aa5a0 "ha_commit_one_phase" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 8 _db_framep_ = (char **) 0x82966ea #7 0x0829670a in ha_commit_one_phase(THD*, bool) (thd=0x8eac0c8, all=false) at handler.cc:740 err = -4 error = 0 trans = (THD_TRANS *) 0x8ead298 is_real_trans = true ht = (handlerton **) 0x8ead2a0 _db_func_ = 0x85aa51d "ha_commit_trans" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 7 _db_framep_ = (char **) 0x6e37dd20 #8 0x082965e2 in ha_commit_trans(THD*, bool) (thd=0x8eac0c8, all=false) at handler.cc:710 error = 0 cookie = 0 trans = (THD_TRANS *) 0x8ead298 is_real_trans = true ht = (handlerton **) 0x8ead2a0 xid = 202951 _db_func_ = 0x85aa5c6 "ha_autocommit_or_rollback" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 6 _db_framep_ = (char **) 0x84e5d3e #9 0x082969f5 in ha_autocommit_or_rollback(THD*, int) (thd=0x8eac0c8, error=0) at handler.cc:849 _db_func_ = 0x85a15a3 "mysql_update" _db_file_ = 0x85a1595 "sql_update.cc" _db_level_ = 5 _db_framep_ = (char **) 0x8e99b20 #10 0x0824fb89 in mysql_update(THD*, st_table_list*, List&, List&, Item*, unsigned, st_order*, unsigned long long, enum_duplicates, bool) (thd=0x8eac0c8, table_list=0x8e99600, fields=@0x8eac3d0, values=@0x8eac5ac, conds=0x8e99a10, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:678 using_limit = false safe_update = false used_key_is_modified = false transactional_table = true will_batch = false res = -4 error = -1 loc_error = 150248704 used_index = 0 dup_key_found = 0 need_sort = true want_privilege = 149527328 table_count = 1 query_id = 202951 timestamp_query_id = 7942062827364783616 updated = 1 found = 1 old_used_keys = {map = 3} table = (TABLE *) 0x8f49d00 select = (SQL_SELECT *) 0x8e99b20 info = {table = 0x0, file = 0x8f4ace0, forms = 0x6e37df38, read_record = 0x82927ac , thd = 0x8eac0c8, select = 0x8e99b20, cache_records = 0, ref_length = 5, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0x8f4adf8 "", 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 *) 0x8eac348 need_reopen = false _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x84e5e20 #11 0x081f4fc2 in mysql_execute_command(THD*) (thd=0x8eac0c8) at sql_parse.cc:3257 res = false result = 0 lex = (LEX *) 0x8eac108 select_lex = (SELECT_LEX *) 0x8eac348 first_table = (TABLE_LIST *) 0x8e99600 all_tables = (TABLE_LIST *) 0x8e99600 unit = (SELECT_LEX_UNIT *) 0x8eac118 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e37e138 #12 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8eac0c8, inBuf=0x8e99538 "update SH_Product set Evaluations = '", 'u' , "' where ProductID = 66025", length=149602568) at sql_parse.cc:5899 lex = (LEX *) 0x8eac108 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e37e51c #13 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8eac0c8, packet=0x8eac0c8 "(Ùd\b\020\212î\b¨nð\b<Ùd\b\020\232é\bèÀê\b", packet_length=83) at sql_parse.cc:1762 packet_end = 0x8e9958a "" net = (NET *) 0x8eac918 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #14 0x081f1886 in do_command(THD*) (thd=0x8eac0c8) at sql_parse.cc:1548 packet = 0x8e91508 "\003update SH_Product set Evaluations = '", 'u' , "' where ProductID = 66025" old_timeout = 30 packet_length = 83 net = (NET *) 0x8eac918 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #15 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 error = -4 net = (NET *) 0x8eac918 sctx = (Security_context *) 0x8ead130 thd = (class THD *) 0x8eac0c8 launch_time = 4294967292 set = {__val = {0 }} #16 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 6 (process 17888)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x083b8ab2 in os_event_wait (event=0x87aae04) at os0sync.c:336 old_signal_count = 18970870546432 #2 0x083e7a94 in sync_array_wait_event (arr=0x87aabd0, index=1) at sync0arr.c:480 cell = (sync_cell_t *) 0x400ac048 event = 0xfffffffc #3 0x083e93c5 in rw_lock_x_lock_func (lock=0x41123c68, pass=0, file_name=0x85d855d "page0page.c", line=197) at sync0rw.c:539 index = 1 state = 1091714168 i = 0 #4 0x083bd60a in page_set_max_trx_id (page=0x43514000 "¾7Qb", trx_id={high = 0, low = 203963}) at page0page.c:197 block = (buf_block_t *) 0x679b0298 #5 0x083a48db in lock_rec_insert_check_and_lock (flags=0, rec=0x4351407d "\200", index=0x41319668, thr=0x41334440, inherit=0x6e31b59c) at page0page.ic:45 next_rec = (rec_t *) 0x43514070 "supremum" trx = (trx_t *) 0x41356868 err = 138128825 #6 0x0835ec4b in btr_cur_ins_lock_and_undo (flags=0, cursor=0xfffffffc, entry=0x41336068, thr=0x41334440, inherit=0x6e31b59c) at btr0cur.c:859 index = (dict_index_t *) 0x41319668 err = 4294967292 roll_ptr = {high = 1091713644, low = 140342953} #7 0x08358788 in btr_cur_optimistic_insert (flags=0, cursor=0x6e31bbf8, entry=0x41336068, rec=0x6e31b600, big_rec=0x6e31b604, thr=0x41334440, mtr=0x6e31b798) at btr0cur.c:1021 big_rec_vec = (big_rec_t *) 0x0 index = (dict_index_t *) 0x41319668 page = (ib_page_t *) 0x43514000 "¾7Qb" max_size = 16231 dummy_rec = (rec_t *) 0x0 level = 0 reorg = 138120910 inherit = 0 rec_size = 20 type = 0 err = 140 #8 0x083cb417 in row_ins_index_entry_low (mode=2, index=0x41319668, entry=0x41336068, ext_vec=0x0, n_ext_vec=0, thr=0x41334440) at row0ins.c:2090 cursor = {index = 0x41319668, page_cur = {rec = 0x4351407d "\200"}, left_page = 0x6e31bc20 "@¼1n¹NN\bH¦ð\b\026", thr = 0x41334440, flag = 3, tree_height = 2, up_match = 1, up_bytes = 4, low_match = 2, low_bytes = 3, n_fields = 1848753216, n_bytes = 139349689, fold = 149988936, path_arr = 0x16} ignore_sec_unique = 0 modify = 0 insert_rec = (rec_t *) 0x44b0e0f6 "" err = 10 big_rec = (big_rec_t *) 0x0 mtr = {state = 52698, memo = {heap = 0x0, used = 24, data = "7\000\000\000\000\000\000\000\003\000\000\000\030\\\224g\002\000\000\000\230\002\233g\002\000\000\000\000\000\000\000h`\022A´`\022A\000\000\000\000 ¸1nÞ\207:\bØgÚ\b\023º\\\b+\000\000\000\036õ?\bpö\022A\000\000\000\000 ¸1nÅ8N\bl!\022A´`\022A ¸1n\2008N\b\000\000\000\000\027=\025\204lö\022Ah!\022A\000\000\000\000h!\022Aм1n}\226?\bhä2A\000\000\000\000+\000\000\000\001\000\000\000\000\000\000\000\003\000\000\000\000\000\000\0005­\003@\203»1n\000\000\000\000p¸1n5­\003@\b¹1n\000\000\000\000\200¸1n¥@N\b\000\000\000\000"..., base = {count = 139353509, start = 0x4003d909, end = 0x8f0a648}, list = {prev = 0x6e31b9d0, next = 0x84e5e20}}, log = {heap = 0x0, used = 0, data = "¦\000À\214g\000\016\000\001\200\006\200\006\200\a\200\004\200\004\200\005\200 \200\b\200\004\200\024\2002\200\004\200\004\200\004 S\2012;\000\000\000\003\034»\200\000\001\0000\001\020\200\000\000\006\200\000\000\005\200\000\000\000\000Hammer", ' ' , "®Gáz\024®\"@\200\000\000\004in the morning Works well with nails", ' ' , "\200\000\000\b\200\000\000\003\200\000\000\0021nPyò\bPyò\b\000\000\000\000ðº1nü³!\b¢\017\000\000¸º1n¼º1nÀº1n\200\217í"..., base = {count = 1848753184, start = 0x6e31bbf8, end = 0x6e31bd60}, list = {prev = 0x6e31bc30, next = 0x6e31bc50}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 0, low = 2215992986}, end_lsn = {high = 0, low = 2215993180}, magic_n = 1848753168} heap = (mem_heap_t *) 0x0 offsets_ = {100, 1848757552, 1, 139344000, 1074446360, 1074446408, 1848758048, 148461104, 0, 5632, 1848751696, 138120910, 148461016, 140342953, 617, 0, 2560, 0, 1848751728, 138120361, 148461016, 5632, 1848751760, 138109618, 8, 2560, 1848751760, 138109660, 148461104, 0, 1073987506, 0, 118838784, 2560, 1848751824, 138110048, 8, 1753845760, 2560, 118838784, 0, 524283904, 1, 0, 0, 0, 118838867, 0, 118838867, 0, 0, 0, 118838867, 1737778892, 1848751888, 139344278, 1737778892, 1848757552, 524283904, 0, 1848751920, 0, 1848751920, 351, 1737778888, 1737778872, 1073987506, 138120910, 1737778892, 140342953, 617, 1737778888, 1848758048, 1848757552, 148531236, 148531236, 0, 1848752032, 1073980533, 148531184, 148531236, 148531160, 1848752000, 139344278, 148531160, 1848757552, 1073980344, 0, 148531160, 0, 1848752032, 148531160, 52698, 0, 1848752032, 138120910, 148531160, 140342953, 617, 148531160} offsets = (ulint *) 0x6e31b608 #9 0x083cb661 in row_ins_index_entry (index=0x41319668, entry=0x41336068, ext_vec=0x0, n_ext_vec=0, thr=0x41334440) at row0ins.c:2174 err = 4294967292 #10 0x083cb745 in row_ins_index_entry_step (node=0x413340a8, thr=0x41334440) at row0ins.c:2253 err = 4294967292 #11 0x083cb908 in row_ins (node=0x413340a8, thr=0x41334440) at row0ins.c:2385 err = 4294967292 #12 0x083cba5c in row_ins_step (thr=0x41334440) at row0ins.c:2495 node = (ins_node_t *) 0x413340a8 parent = (que_node_t *) 0x41334440 sel_node = (sel_node_t *) 0x0 trx = (trx_t *) 0x41356868 err = 4294967292 #13 0x083cd6ad in row_insert_for_mysql (mysql_rec=0x8f273c8 "ÿ\006", prebuilt=0x41333268) at row0mysql.c:1147 savept = {least_undo_no = {high = 0, low = 0}} thr = (que_thr_t *) 0x41334440 err = 149988936 was_lock_wait = 4294967292 trx = (trx_t *) 0x41356868 node = (ins_node_t *) 0x413340a8 #14 0x082abf71 in ha_innobase::write_row(char*) (this=0x8f272b0, record=0x8f273c8 "ÿ\006") at ha_innodb.cc:3312 prebuilt = (row_prebuilt_t *) 0x41333268 error = 1094019176 auto_inc = 4294967292 dummy = 586002260223442416 auto_inc_used = 0 _db_func_ = 0x85ebea4 "write_record" _db_file_ = 0x85a04c0 "sql_insert.cc" _db_level_ = 6 _db_framep_ = (char **) 0x16 #15 0x0829b1e2 in handler::ha_write_row(char*) (this=0x8f272b0, buf=0x8f273c8 "ÿ\006") at handler.cc:3295 error = 4417 #16 0x082454db in write_record(THD*, st_table*, st_copy_info*) (thd=0x8f06ea8, table=0x8f26468, info=0x6e31bf58) at sql_insert.cc:1131 error = 149962496 trg_error = 0 key = 0x0 _db_func_ = 0x85a04ce "mysql_insert" _db_file_ = 0x85a04c0 "sql_insert.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e31bfc0 #17 0x08244488 in mysql_insert(THD*, st_table_list*, List&, List >&, List&, List&, enum_duplicates, bool) (thd=0x8f06ea8, table_list=0x8f036a0, fields=@0x8f07380, values_list=@0x8f073a4, update_fields=@0x8f07398, update_values=@0x8f0738c, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:519 error = 1 res = -4 log_on = true transactional_table = false joins_freed = false changed = 144 value_count = 11 counter = 1 id = 0 info = {records = 1, deleted = 0, updated = 0, copied = 0, error_count = 644197575955831049, handle_duplicates = DUP_ERROR, escape_char = 139353632, last_errno = 149974760, ignore = false, update_fields = 0x8f07398, update_values = 0x8f0738c, view = 0x0} table = (TABLE *) 0x8f26468 its = { = {list = 0x8f073a4, el = 0x8f045f8, prev = 0x0, current = 0x0}, } values = (List_item *) 0x8f03f00 context = (Name_resolution_context *) 0x1 ctx_state = {save_table_list = 0x8f036a0, save_first_name_resolution_table = 0x8f036a0, save_next_name_resolution_table = 0x0, save_resolve_in_select_list = false, save_next_local = 0x0} query = 0x8f03550 "insert into SH_InsertTable(Project_Number,Model,ProductID,Product_Name,Price,Class,Evaluations,Description,EmployeeID,Type,VendorID) \t\tvalues (6,5,0,'Hammer',9.34,4,'in the morning','Works well with n"... lock_type = TL_WRITE_CONCURRENT_INSERT unused_conds = (class Item *) 0x0 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x0 #18 0x081f520b in mysql_execute_command(THD*) (thd=0x8f06ea8) at sql_parse.cc:3332 res = false result = 0 lex = (LEX *) 0x8f06ee8 select_lex = (SELECT_LEX *) 0x8f07128 first_table = (TABLE_LIST *) 0x8f036a0 all_tables = (TABLE_LIST *) 0x8f036a0 unit = (SELECT_LEX_UNIT *) 0x8f06ef8 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e31c138 #19 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8f06ea8, inBuf=0x8f03550 "insert into SH_InsertTable(Project_Number,Model,ProductID,Product_Name,Price,Class,Evaluations,Description,EmployeeID,Type,VendorID) \t\tvalues (6,5,0,'Hammer',9.34,4,'in the morning','Works well with n"..., length=149974760) at sql_parse.cc:5899 lex = (LEX *) 0x8f06ee8 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e31c51c #20 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8f06ea8, packet=0x8f06ea8 "(Ùd\bÐÀê\bhÅì\b<Ùd\bpEð\bÈnð\b", packet_length=213) at sql_parse.cc:1762 packet_end = 0x8f03624 "" net = (NET *) 0x8f076f8 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #21 0x081f1886 in do_command(THD*) (thd=0x8f06ea8) at sql_parse.cc:1548 packet = 0x8efb520 "\003insert into SH_InsertTable(Project_Number,Model,ProductID,Product_Name,Price,Class,Evaluations,Description,EmployeeID,Type,VendorID) \t\tvalues (6,5,0,'Hammer',9.34,4,'in the morning','Works well with "... old_timeout = 30 packet_length = 213 net = (NET *) 0x8f076f8 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #22 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 error = -4 net = (NET *) 0x8f076f8 sctx = (Security_context *) 0x8f07f10 thd = (class THD *) 0x8f06ea8 launch_time = 4294967292 set = {__val = {0 }} #23 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 7 (process 17887)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x083b6206 in os_file_pread (file=3, buf=0x44d14000, n=16384, offset=354598912, offset_high=0) at os0file.c:1891 offs = 7939459733436497923 n_bytes = 3 #2 0x083b630e in os_file_read (file=3, buf=0x44d14000, offset=0, offset_high=0, n=16384) at os0file.c:2124 retry = 16384 ret = 16384 #3 0x083b72a5 in os_aio (type=10, mode=24, name=0x41126768 "./ibdata1", file=3, buf=0x44d14000, offset=354598912, offset_high=0, n=16384, message1=0x41126668, message2=0x67a40298) at os0file.c:3376 array = (os_aio_array_t *) 0x1522c000 slot = (os_aio_slot_t *) 0x0 retry = 16384 wake_later = 0 #4 0x0838548b in fil_io (type=10, sync=1, space_id=0, block_offset=0, byte_offset=0, len=16384, buf=0x44d14000, message=0x67a40298) at fil0fil.c:4024 system = (fil_system_t *) 0x41123668 mode = 24 space = (fil_space_t *) 0x1522c000 node = (fil_node_t *) 0x41126668 offset_high = 0 offset_low = 354598912 ret = 16384 is_log = 354598912 wake_later = 0 #5 0x0836debf in buf_read_page_low (err=0x6e2ea240, sync=1, mode=16384, space=0, tablespace_version=70369898741760, offset=21643) at buf0rea.c:143 block = (buf_block_t *) 0x67a40298 wake_later = 0 #6 0x0836e2c9 in buf_read_page (space=0, offset=21643) at buf0rea.c:331 tablespace_version = 7939459733436497921 count = 0 count2 = 1 err = 10 #7 0x0836645e in buf_page_get_gen (space=0, offset=21643, rw_latch=1, guess=0x0, mode=10, file=0x85cb9f3 "btr0cur.c", line=424, mtr=0x6e2ea7f8) at buf0buf.c:1160 block = (buf_block_t *) 0x0 accessed = 1848550672 fix_type = 16384 success = 16384 must_read = 1091713640 #8 0x0835713d in btr_cur_search_to_nth_level (index=0x41333768, level=0, tuple=0x41349068, mode=4, latch_mode=1, cursor=0x41347e68, has_search_latch=0, mtr=0x6e2ea7f8) at btr0cur.c:422 tree = (dict_tree_t *) 0x4131b468 page_cursor = (page_cur_t *) 0x41347e6c page = (ib_page_t *) 0x1
guess = (ib_page_t *) 0x0 page_no = 21643 space = 0 up_match = 0 up_bytes = 3 low_match = 0 low_bytes = 4 height = 0 savepoint = 32 rw_latch = 1 page_mode = 4 insert_planned = 0 buf_mode = 10 estimate = 0 ignore_sec_unique = 0 root_height = 2 info = (btr_search_t *) 0x4131b068 heap = (mem_heap_t *) 0x0 offsets_ = {100, 2, 2147483653, 5, 9, 4, 2147483653, 4, 8, 12, 17, 0, 3, 0, 2, 3, 100, 5, 2147483653, 4, 8, 12, 17, 21, 5, 0, 1848550384, 139346085, 0, 1850766272, 1848550400, 139349689, 149740808, 0, 1848550416, 139349689, 149740808, 2, 1848550448, 139353509, 1073993993, 149904796, 1848550504, 139283432, 1848551640, 1848550504, 511, 5, 149904796, 5, 1848551056, 139283069, 1848551640, 1848550504, 1848550492, 1848550496, 0, 0, 1848550512, 139346085, 140539082, 140539070, 9, 136937261, 1886221359, 1848508463, 1848550544, 0, 149740808, 0, 1848550576, 139353509, 1073993993, 1108489888, 1848550576, 1073982773, 1850755032, 0, 1848550592, 139346085, 0, 2, 1848550640, 543784397, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1091707244, 1848550672, 139344278, 1091707244, 1848556848, 3, 1850755032} offsets = (ulint *) 0x6e2ea368 #9 0x083d866c in row_sel_get_clust_rec_for_mysql (prebuilt=0x41347c68, sec_index=0x41332e68, rec=0x44cf8209 "\200", thr=0x413491c8, out_rec=0x6e2ea648, offsets=0x6e2ea660, offset_heap=0x6e2ea664, mtr=0x6e2ea7f8) at btr0pcur.ic:535 clust_index = (dict_index_t *) 0x41333768 clust_rec = (rec_t *) 0x41347e68 "h73A×\227´D" old_vers = (rec_t *) 0x6e2ea668 "d" err = 16384 trx = (trx_t *) 0x41348868 #10 0x083daab5 in row_search_for_mysql (buf=0x6e503ba0 "", mode=2, prebuilt=0x41347c68, match_mode=1, direction=0) at row0sel.c:4077 index = (dict_index_t *) 0x41332e68 comp = 1 search_tuple = (dtuple_t *) 0x41348068 pcur = (btr_pcur_t *) 0x41345f68 trx = (trx_t *) 0x41348868 clust_index = (dict_index_t *) 0x41333768 thr = (que_thr_t *) 0x413491c8 rec = (rec_t *) 0x44cf8209 "\200" result_rec = (rec_t *) 0x21f
clust_rec = (rec_t *) 0x0 err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = 1 moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = 0 next_offs = 543 same_user_rec = 139349689 mtr = {state = 1091707244, memo = {heap = 0x0, used = 56, data = "7\000\000\000\000\000\000\000\003\000\000\000\030\\£g\003\000\000\000\230f£g\001\000\000\000\030ø£g7\000\000\000¼´1A\003\000\000\000\030A£g\003\000\000\000\030V£g\000\000\000\000`¨.n5­\003@Ð\216Tn\000\000\000\000p¨.n5­\003@°ÆTn\000\000\000\000\200¨.n¥@N\b\000\000\000\000\000\000\000\000\220¨.n5­\003@Ð\216Tn\000\000\000\000 ¨.n¥@N\b\000\000\000\000\002\000\000\000À¨.n¥]N\b\tÙ\003@\bÝì\bÀ¨.n¹NN\b\bÝì\b\002\000\000\000à¨.n5­\003@è\214Tn\000\000\000\000à¨.n¥@N\b\000\000\000\000"..., base = {count = 139349689, start = 0x8ecdd08, end = 0x2}, list = { prev = 0x6e2eaa40, next = 0x84e5da5}}, log = {heap = 0x0, used = 0, data = "@ª.n5­\003@\001\000\000\000\000\000\000\000Pª.n¥@N\b\000\000\000\000\005\000\000\000\220ª.n-\177)\b\001\006\000\000tª.npª.n¹NN\b\bÝì\b\002\000\000\000\220ª.n¥]N\b\tÙ\003@\bÝì\b\220ª.n ^N\b\001\000\000\000è\214TnÀª.n\001\000\000\000è\214Tnø[ï\bÀª.n5­\003@hÅì\b\000\000\000\000Àª.n¥@N\b\000\000\000\000dîY\b\b\000\000\000(ôY\b\020¹Tn\020\211Tnàª.n¹NN\b\bÝì\b\002\000\000\000\000«.n¥]N\b\tÙ\003@\bÝì\b\000«.n ^N\b"..., base = { count = 1848552528, start = 0x41348868, end = 0x41162068}, list = {prev = 0x41162068, next = 0x6e2eac50}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 617, low = 1093961832}, end_lsn = {high = 1091969128, low = 1091969128}, magic_n = 1848552576} heap = (mem_heap_t *) 0x0 offsets_ = {100, 4, 2147483653, 4, 8, 12, 17, 1848551128, 11, 1848551128, 1848552176, 139278117, 109, 1848551112, 1848551116, 1848551120, 0, 524283904, 1, 6, 0, 0, 140128645, 1848552488, 140112936, 140111460, 8, 0, 1819374371, 1647653983, 1848860464, 139723407, 118841187, 0, 524283904, 0, 1848551216, 0, 1848551216, 0, 0, 0, 0, 0, 0, 0, 524283904, 0, 0, 1091712620, 1848551264, 139344278, 1091712620, 1848556848, 1073987355, 138045905, 118841187, 0, 1848551296, 1091712616, 0, 148531008, 1848551312, 139344278, 148531008, 1848556848, 617, 139344000, 8, 1091723448, 1848551344, 139344278, 1091723448, 1848556848, 1848551344, 138120910, 148531008, 140342953, 617, 1091723368, 1091723444, 0, 1848551376, 138120910, 1091723448, 140342953, 617, 1091723368, 1091723444, 3, 1848551456, 138053474, 1091723448, 1073988193, 1091707244, 1848556848, 1091707244, 0, 1848551456, 139344069} offsets = (ulint *) 0x6e2ea668 #11 0x082aca22 in ha_innobase::index_read(char*, char const*, unsigned, ha_rkey_function) (this=0x6e503a88, buf=0x6e503ba0 "", key_ptr=0x6e549150 "\005", key_len=12, find_flag=HA_READ_KEY_EXACT) at ha_innodb.cc:3910 prebuilt = (row_prebuilt_t *) 0x41347c68 mode = 2 index = (dict_index_t *) 0x1 match_mode = 1 error = 1 ret = 1 _db_func_ = 0x85aa8e2 "handler::read_range_first" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 11 _db_framep_ = (char **) 0x6e2eacc0 #12 0x0829a6ab in handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool) ( this=0x6e503a88, start_key=0x6e548e68, end_key=0x6e548e74) at handler.cc:2916 eq_range_arg = [Switching to thread 8 (process 17886)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x08385b5e in fil_flush (space_id=4294967280) at fil0fil.c:4246 system = (fil_system_t *) 0x8 space = (fil_space_t *) 0x41127068 node = (fil_node_t *) 0x41127268 file = 8 old_mod_counter = 55432 #2 0x083a853b in log_write_up_to (lsn={high = 0, low = 2215994009}, wait=92, flush_to_disk=1) at log0log.c:1475 group = (log_group_t *) 0x41127468 start_offset = 1391479 area_start = 1391104 area_end = 1392128 #3 0x083f9593 in trx_commit_off_kernel (trx=0x41345868) at trx0trx.c:931 update_hdr_page = (ib_page_t *) 0x0 lsn = {high = 0, low = 2215994009} rseg = (trx_rseg_t *) 0x0 undo = (trx_undo_t *) 0x41130468 must_flush_log = 1 mtr = {state = 149925256, memo = {heap = 0x0, used = 16, data = "\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\200\001\001\001\222ÅY\b¼¾Y\b\a\000\000\000h!\022A\000\000\000\000h!\022AÐÌ4n}\226?\bhx2A\000\000\000\000\b\000\000\000\002\000\000\000\000\000\000\000Ølì\b É4n·¶!\bÈÐë\bØlì\bøoì\b\t\000\000\000øoì\b\000\000\000\000\000\000\000\0004qì\b\001\000\000\000\001\000\000\000lpì\b\001\000\000\000¤È4n\000\000\000\000 È4n¹NN\bhèë\b\000\000\000\001\t\000\000\000øoì\b\000\000\000\000\210­ï\bÀÈ\001\001Ølì\b\022É4n"..., base = { count = 0, start = 0x8ec7098, end = 0x8ec70e8}, list = {prev = 0x6e34cb30, next = 0x81784f3}}, log = { heap = 0x0, used = 108, data = "\002\000ÀÀ\002\0008\002\004\000ÀÀ\002\027hðÿÿÿÿ\002\000ÀÀ\002\027l\000\004\000ÀÀ\002\027nÀÀ\002\002\000ÀÀ\002\027r\226|\004\000\006\0002ÀÀ\002\002\000\006\0006\227h\004\000ÀÀ\002\026|ÀÀ\002\002\000ÀÀ\002\026\200\227h\004\000\006\000.\016\b\000ÀÀ\002\027N\000\000\003\034¾\002\000ÀÀ\002\027V\000\0372\200\004\200\004\200\004\002\001\000\000\000À\002\030\000\000\000\003\034º,¥\000\001\b\024", 'u' , "\000\000\000\000\000ÀÊ4n¥@N\b\000\000\000\000hèë\bÐÊ4n¹NN\bhèë\b\026\000\000\000ðÊ4n5­\003@\220{í\b\000\000\000\000ðÊ"..., base = { count = 1848953904, start = 0x4134a398, end = 0x8931734}, list = {prev = 0x8931728, next = 0x6e34cc30}}, modifications = 1, n_log_recs = 12, log_mode = 21, start_lsn = {high = 0, low = 2215993901}, end_lsn = { high = 0, low = 2215994009}, magic_n = 1848953952} #4 0x083fa532 in trx_commit_for_mysql (trx=0x41345868) at trx0trx.c:1609 No locals. #5 0x082aa38a in innobase_commit_low(trx_struct*) (trx=0x41345868) at ha_innodb.cc:1568 No locals. #6 0x082aa60d in innobase_commit (thd=0x8ebd0c8, all=false) at ha_innodb.cc:1700 trx = (trx_t *) 0x41345868 _db_func_ = 0x85aa5a0 "ha_commit_one_phase" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 8 _db_framep_ = (char **) 0x82966ea #7 0x0829670a in ha_commit_one_phase(THD*, bool) (thd=0x8ebd0c8, all=false) at handler.cc:740 err = 0 error = 0 trans = (THD_TRANS *) 0x8ebe298 is_real_trans = true ht = (handlerton **) 0x8ebe2a0 _db_func_ = 0x85aa51d "ha_commit_trans" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 7 _db_framep_ = (char **) 0x6e34cd20 #8 0x082965e2 in ha_commit_trans(THD*, bool) (thd=0x8ebd0c8, all=false) at handler.cc:710 error = 0 cookie = 0 trans = (THD_TRANS *) 0x8ebe298 is_real_trans = true ht = (handlerton **) 0x8ebe2a0 xid = 202954 _db_func_ = 0x85aa5c6 "ha_autocommit_or_rollback" _db_file_ = 0x85424fa "handler.cc" _db_level_ = 6 _db_framep_ = (char **) 0x84e5d3e #9 0x082969f5 in ha_autocommit_or_rollback(THD*, int) (thd=0x8ebd0c8, error=0) at handler.cc:849 _db_func_ = 0x85a15a3 "mysql_update" _db_file_ = 0x85a1595 "sql_update.cc" _db_level_ = 5 _db_framep_ = (char **) 0x8ec71f8 #10 0x0824fb89 in mysql_update(THD*, st_table_list*, List&, List&, Item*, unsigned, st_order*, unsigned long long, enum_duplicates, bool) (thd=0x8ebd0c8, table_list=0x8ec6cd8, fields=@0x8ebd3d0, values=@0x8ebd5ac, conds=0x8ec70e8, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:678 using_limit = false safe_update = 32 used_key_is_modified = 32 transactional_table = true will_batch = false res = 0 error = -1 loc_error = 149779488 used_index = 0 dup_key_found = 0 need_sort = true want_privilege = 149713400 table_count = 1 query_id = 202954 timestamp_query_id = 7941200810248793304 updated = 1 found = 1 old_used_keys = {map = 3} table = (TABLE *) 0x8ed7420 select = (SQL_SELECT *) 0x8ec71f8 info = {table = 0x0, file = 0x8efaa60, forms = 0x6e34cf38, read_record = 0x82927ac , thd = 0x8ebd0c8, select = 0x8ec71f8, cache_records = 0, ref_length = 5, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0x8efab78 "", 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 *) 0x8ebd348 need_reopen = false _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x84e5e20 #11 0x081f4fc2 in mysql_execute_command(THD*) (thd=0x8ebd0c8) at sql_parse.cc:3257 res = false result = 0 lex = (LEX *) 0x8ebd108 select_lex = (SELECT_LEX *) 0x8ebd348 first_table = (TABLE_LIST *) 0x8ec6cd8 all_tables = (TABLE_LIST *) 0x8ec6cd8 unit = (SELECT_LEX_UNIT *) 0x8ebd118 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e34d138 #12 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8ebd0c8, inBuf=0x8ec6c10 "update SH_Product set Evaluations = '", 'u' , "' where ProductID = 32760", length=149672200) at sql_parse.cc:5899 lex = (LEX *) 0x8ebd108 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e34d51c #13 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8ebd0c8, packet=0x8ebd0c8 "(Ùd\bpÅì\b", packet_length=83) at sql_parse.cc:1762 packet_end = 0x8ec6c62 "" net = (NET *) 0x8ebd918 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #14 0x081f1886 in do_command(THD*) (thd=0x8ebd0c8) at sql_parse.cc:1548 packet = 0x8ebebe0 "\003update SH_Product set Evaluations = '", 'u' , "' where ProductID = 32760" old_timeout = 30 packet_length = 83 net = (NET *) 0x8ebd918 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #15 0x081f0b8f in handle_one_connection (arg=0x0) at sql_parse.cc:1190 error = 0 net = (NET *) 0x8ebd918 sctx = (Security_context *) 0x8ebe130 thd = (class THD *) 0x8ebd0c8 launch_time = 0 set = {__val = {0 }} #16 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 9 (process 17885)]#0 0xffffe002 in ?? () #0 0xffffe002 in ?? () No symbol table info available. #1 0x083b8ab2 in os_event_wait (event=0x87aad6c) at os0sync.c:336 old_signal_count = 63247688400896 #2 0x083e7a94 in sync_array_wait_event (arr=0x87aabd0, index=0) at sync0arr.c:480 cell = (sync_cell_t *) 0x400ac018 event = 0xfffffffc #3 0x083e8e18 in rw_lock_s_lock_spin (lock=0x41123c68, pass=0, file_name=0x85cc0d4 "btr0sea.c", line=1131) at sync0rw.c:287 index = 0 i = 1091714168 #4 0x08361733 in btr_search_build_page_hash_index (index=0x41333768, page=0x44bd4000 "T2=ê", n_fields=1, n_bytes=0, side=2) at sync0rw.ic:254 table = (hash_table_t *) 0x41123e68 block = (buf_block_t *) 0x67a38a98 rec = (rec_t *) 0x0 next_rec = (rec_t *) 0x41123c78 "" fold = 1848349176 next_fold = 4294967292 tree_id = {high = 1153268259, low = 1153269702} n_cached = 1153268259 n_recs = 0 folds = (ulint *) 0x4134ca68 recs = (rec_t **) 0x4 i = 1091714152 heap = (mem_heap_t *) 0x0 offsets_ = {100, 1153268416, 23, 23, 24, 0, 4, 0, 100, 1, 2147483653, 5, 1091723448, 140342953, 617, 351715328, 1154203644, 1154187264, 1848349248, 138062698, 1091723448, 140331029, 2368045711, 1221685459, 1154187264, 1091713644, 1848349296, 139344278, 1091713644, 1848356144, 1848349312, 139344000, 1091724904, 0, 1848349328, 1091713640, 1738793016, 1738792984, 1848349328, 138120910, 1091713644, 140342953, 617, 1091713640, 1738793032, 1091713644, 1848349376, 139344278, 1091713644, 143857464, 1848349392, 139344278, 143857464, 1848356144, 1848349408, 1091713640, 1737723928, 0, 1848349424, 1093978520, 143857460, 143857448, 1848349424, 138120910, 143857464, 140342953, 617, 143857460, 7, 143857448, 1848349472, 138092229, 143857464, 140294675, 43, 138413337, 1093978540, 140296406, 8, 12, 1093978536, 0, 1848349520, 138089531, 1093978540, 140296404, 8, 1738771128, 1738771096, 1738771144, 1848349616, 0, 0, 1093775464, 1848349568, 137773708, 0, 12, 0, 0} offsets = (ulint *) 0x6e2b91d8 #5 0x0835f8f7 in btr_search_info_update_slow (info=0x4131b068, cursor=0x41320468) at btr0sea.c:519 block = (buf_block_t *) 0x67a38a98 build_index = 1 params2 = (ulint *) 0xfffffffc #6 0x083576b5 in btr_cur_search_to_nth_level (index=0x41333768, level=0, tuple=0x41344068, mode=4, latch_mode=1, cursor=0x41320468, has_search_latch=0, mtr=0x6e2b98e8) at btr0sea.ic:66 tree = (dict_tree_t *) 0x4131b468 page_cursor = (page_cur_t *) 0x4132046c page = (ib_page_t *) 0x44bd4000 "T2=ê" guess = (ib_page_t *) 0x0 page_no = 21371 space = 0 up_match = 0 up_bytes = 4 low_match = 1 low_bytes = 0 height = 0 savepoint = 8 rw_latch = 1 page_mode = 4 insert_planned = 0 buf_mode = 10 estimate = 0 ignore_sec_unique = 0 root_height = 2 info = (btr_search_t *) 0x4131b068 heap = (mem_heap_t *) 0x0 offsets_ = {100, 2, 2147483653, 5, 9, 4, 2147483653, 4, 8, 12, 17, 8, 0, 143857544, 1848349888, 138090970, 9, 143857464, 1848349904, 139344278, 143857464, 1848356144, 1848349936, 7, 0, 143857532, 1848349936, 1093978136, 143857460, 143857448, 1848349936, 138120910, 143857464, 140342953, 617, 0, 7, 1738765772, 1848349984, 139344278, 1738765772, 1738765772, 1848350000, 139344278, 1738765772, 1848356144, 1848350016, 1738765752, 1738765768, 0, 1848350032, 1738765752, 1738765768, 1738765720, 1848350032, 138120910, 1738765772, 140342953, 617, 1738765752, 1738765768, 1738765720, 1848350160, 137784832, 1738765772, 140294675, 43, 139344278, 1738765772, 1738765772, 1848350112, 139344278, 1738765772, 1848356144, 1848350128, 1738765768, 1738765752, 0, 1848350144, 1738765768, 1738765752, 0, 1738765768, 1, 247, 140390992, 1091713640, 1, 0, 0, 1848350208, 1153024000, 1153024367, 1, 1848350224, 138456312, 1, 1738765720, 1153024000, 0} offsets = (ulint *) 0x6e2b9458 #7 0x083d866c in row_sel_get_clust_rec_for_mysql (prebuilt=0x4131da68, sec_index=0x41332e68, rec=0x44b9d67d "\200", thr=0x413441c8, out_rec=0x6e2b9738, offsets=0x6e2b9750, offset_heap=0x6e2b9754, mtr=0x6e2b98e8) at btr0pcur.ic:535 clust_index = (dict_index_t *) 0x41333768 clust_rec = (rec_t *) 0x41320468 "h73A#z½D" old_vers = (rec_t *) 0x6e2b9758 "d" err = 4294967292 trx = (trx_t *) 0x41337868 #8 0x083daab5 in row_search_for_mysql (buf=0x8ef9fc0 "", mode=2, prebuilt=0x4131da68, match_mode=1, direction=1) at row0sel.c:4077 index = (dict_index_t *) 0x41332e68 comp = 1 search_tuple = (dtuple_t *) 0x41343068 pcur = (btr_pcur_t *) 0x4131d968 trx = (trx_t *) 0x41337868 clust_index = (dict_index_t *) 0x41333768 thr = (que_thr_t *) 0x413441c8 rec = (rec_t *) 0x44b9d67d "\200" result_rec = (rec_t *) 0xbbf
clust_rec = (rec_t *) 0x0 err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = 1 moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = 0 next_offs = 3007 same_user_rec = 1 mtr = {state = 0, memo = {heap = 0x0, used = 40, data = "\001\000\000\000\230u£g7\000\000\000\000\000\000\000\003\000\000\000\030A£g\003\000\000\000\030V£g\001\000\000\000\230\212£g\001\000\000\000\000\000\000\0005­\003@\210\211í\b\000\000\000\000P\231+n5­\003@\210\211í\b\000\000\000\000`\231+n¥@N\b\000\000\000\000\000\000\000\000p\231+n5­\003@°\005ô\b\000\000\000\000\200\231+n¥@N\b\000\000\000\000\000\000\000\000\220\231+n¥@N\b\000\000\000\0000\236ï\b \231+n¹NN\b0\236ï\b\002\000\000\000À\231+n5­\003@\b\006ô\b\000\000\000\000À\231+n5­\003@\000\000\000\000\000\000\000\000Ð\231+n¥@N\b\000\000\000\000"..., base = {count = 149666560, start = 0x0, end = 0x0}, list = {prev = 0x6e2b9e60, next = 0x823757d}}, log = { heap = 0x0, used = 0, data = "\f\234+n\020\234+n\000\000\000\000\001\000\000\000@\233+n +ô\b(nî\b\000\000\000\000P\233+n¹NN\b\204+ô\b\002\000\000\000\000\000\000\000È,ô\b´õó\bp\210í\b\235\210í\b ^\001\000\000îY\b\t\000\000\0000\234+n¬¦ï\b0lî\b\200\202í\b0\234+n\005\000\000\000\000\000\000\000-\000\000\000\002", '\0' , "ûÿÿÿ\000\000\000\000\000\000\000\000\001\000\000\000\003\000\000\000\005\000\000\000\005\000\000\000 »ë\bÿÿÿÿÿÿÿÿ\000J\004\200\000\000\000\000¨m\000\000(ôY\bdîY\b\b\000\000\000ð\233+n(ôY\bdîY\b\b"..., base = {count = 1848352048, start = 0x84e40a5, end = 0x0}, list = {prev = 0x15, next = 0x6e2b9d40}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 1848352080, low = 139349689}, end_lsn = {high = 149921328, low = 2}, magic_n = 1848352096} heap = (mem_heap_t *) 0x0 offsets_ = {100, 4, 2147483653, 4, 8, 12, 17, 26, 58, 66, 70, 90, 140, 144, 148, 152, 148531008, 140342953, 617, 1091723368, 1091723444, 0, 1848350672, 138120910, 1091723448, 140342953, 617, 1091723368, 1091723444, 3, 1848350752, 138053474, 1091723448, 1, 1848350752, 138053384, 1091761776, 0, 1848350752, 139344069, 1091707244, 1091723444, 1378304, 139344000, 0, 2215985293, 1091761772, 1073982773, 149785456, 0, 1848350784, 1073982773, 149785616, 0, 1848350800, 139346085, 0, 0, 1848350816, 1073982773, 149785456, 0, 1848350832, 1073982773, 149785816, 0, 1848350848, 139346085, 0, 0, 1848350864, 1073982773, 149785456, 0, 1848350880, 139346085, 0, 2, 1848350912, 139353509, 1073993993, 149921328, 1848350912, 139349689, 149921328, 2, 1848350944, 1073982773, 149784968, 0, 1848350944, 139346085, 0, 0, 1848350960, 139346085, 0, 0, 40, 1} offsets = (ulint *) 0x6e2b9758 #9 0x082accdd in ha_innobase::general_fetch(char*, unsigned, unsigned) (this=0x8ef9ea8, buf=0x8ef9fc0 "", direction=1, match_mode=1) at ha_innodb.cc:4064 prebuilt = (row_prebuilt_t *) 0x4131da68 ret = 149921448 error = 149921448 _db_func_ = 0x859f581 "do_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x6e2b9de0 #10 0x082acdd3 in ha_innobase::index_next_same(char*, char const*, unsigned) (this=0x8ef9ea8, buf=0x8ef9fc0 "", key=0x8ee6da0 "\003", keylen=8) at ha_innodb.cc:4120 No locals. #11 0x08239cff in join_read_next_same (info=0xfffffffc) at sql_select.cc:10266 error = -4 table = (TABLE *) 0x8f05d40 tab = (JOIN_TAB *) 0x3986 #12 0x08238d72 in sub_select(JOIN*, st_join_table*, bool) (join=0x8f3e070, join_tab=0x8ee6c30, end_of_records=134) at sql_select.cc:9696 error = -4 rc = 14726 report_error = (my_bool *) 0x8ebc5b8 "" info = (READ_RECORD *) 0x8ee6c6c #13 0x0823892c in do_select (join=0x8f3e070, fields=0x0, table=0x8f422b0, procedure=0x0) at sql_select.cc:9454 rc = 0 error = NESTED_LOOP_OK join_tab = (JOIN_TAB *) 0x8ee6c30 _db_func_ = 0x859f016 "JOIN::exec" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x6e2b9e90 #14 0x08228ed5 in JOIN::exec() (this=0x8f3e070) at sql_select.cc:1377 columns_list = (List *) 0x8f3e070 tmp_error = 150200432 _db_func_ = 0x859f111 "mysql_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8ebbea4 curr_join = (JOIN *) 0x8f3e070 curr_all_fields = (List *) 0x8f3eda8 curr_fields_list = (List *) 0x8ebbe08 curr_tmp_table = (TABLE *) 0x8f422b0 #15 0x0822a4cc in mysql_select(THD*, Item***, st_table_list*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*, st_select_lex_unit*, st_select_lex*) ( thd=0x8ebbb00, rref_pointer_array=0x8ebbea4, tables=0x8ee5a08, wild_num=0, fields=@0x8ebbe08, conds=0x8ee60e8, og_num=2, order=0x8ee6350, group=0x8ee6260, having=0x0, proc_param=0x0, select_options=2147764736, result=0x8ee63d8, unit=0x8ebbb50, select_lex=0x8ebbd80) at sql_select.cc:1933 err = false free_join = true _db_func_ = 0x859ee72 "handle_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e2b9f60 join = (JOIN *) 0x8f3e070 #16 0x082261d2 in handle_select(THD*, st_lex*, select_result*, unsigned long) (thd=0x8ebbb00, lex=0x8ebbb40, result=0x8ee63d8, setup_tables_done_option=0) at sql_select.cc:238 unit = (SELECT_LEX_UNIT *) 0x8ebbb50 res = 80 select_lex = (SELECT_LEX *) 0x8ebbd80 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x6e2b9fd0 #17 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ebbb00) at sql_parse.cc:2541 result = (class select_result *) 0x8ee63d8 res = false result = 149840856 lex = (LEX *) 0x8ebbb40 select_lex = (SELECT_LEX *) 0x8ee63d8 first_table = (TABLE_LIST *) 0x8ee5a08 all_tables = (TABLE_LIST *) 0x8ee5a08 unit = (SELECT_LEX_UNIT *) 0x8ebbb50 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e2ba138 #18 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8ebbb00, inBuf=0x8ee50b0 "select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 3 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 90 group by Model order by Model", length=149666624) at sql_parse.cc:5899 lex = (LEX *) 0x8ebbb40 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e2ba51c #19 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8ebbb00, packet=0x8ebbb00 "(Ùd\bÐÐë\b@Üè\b<Ùd\b\020ôó\b »ë\b", packet_length=174) at sql_parse.cc:1762 packet_end = 0x8ee515d "" net = (NET *) 0x8ebc350 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #20 0x081f1886 in do_command(THD*) (thd=0x8ebbb00) at sql_parse.cc:1548 packet = 0x8edd080 "\003select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 3 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 90 group by Model order by Model" old_timeout = 30 packet_length = 174 net = (NET *) 0x8ebc350 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #21 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 error = -4 net = (NET *) 0x8ebc350 sctx = (Security_context *) 0x8ebcb68 thd = (class THD *) 0x8ebbb00 launch_time = 4294967292 set = {__val = {0 }} #22 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. [Switching to thread 10 (process 17883)]#0 ha_insert_for_fold (table=0x42138000, fold=3892695265, data=0x44c51905) at ha0ha.c:150 in ha0ha.c Current language: auto; currently c #0 ha_insert_for_fold (table=0x42138000, fold=3892695265, data=0x44c51905) at ha0ha.c:150 cell = (hash_cell_t *) 0x41aa835c node = (ha_node_t *) 0x434d1d60 prev_node = (ha_node_t *) 0x0 prev_block = (buf_block_t *) 0x42138000 #1 0x08362106 in btr_search_build_page_hash_index (index=0x41333768, page=0x44c50000 ",Óà`", n_fields=1, n_bytes=0, side=2) at btr0sea.c:1258 table = (hash_table_t *) 0x41123e68 block = (buf_block_t *) 0x67a3b918 rec = (rec_t *) 0x44c53ac0 "\200" next_rec = (rec_t *) 0x44c50070 "supremum" fold = 3907854616 next_fold = 1101693788 tree_id = {high = 0, low = 81} n_cached = 96 n_recs = 1153776320 folds = (ulint *) 0x41357a68 recs = (rec_t **) 0x4134ca68 i = 40 heap = (mem_heap_t *) 0x0 offsets_ = {100, 1, 2147483653, 5, 17, 0, 4, 0, 100, 1, 2147483653, 5, 1091723448, 140342953, 617, 347258880, 1154367484, 1154351104, 1848148544, 138062698, 1091723448, 140331029, 4053060036, 2943048304, 1154351104, 1091713644, 1848148592, 139344278, 1091713644, 1848155440, 1848148608, 139344000, 1091724904, 0, 1848148624, 1091713640, 1738796856, 1738796824, 1848148624, 138120910, 1091713644, 140342953, 617, 1091713640, 1738796872, 1091713644, 1848148672, 139344278, 1091713644, 143857464, 1848148688, 139344278, 143857464, 1848155440, 1848148704, 1091713640, 1737723928, 0, 1848148720, 1093978264, 143857460, 143857448, 1848148720, 138120910, 143857464, 140342953, 617, 143857460, 7, 143857448, 1848148768, 138092229, 143857464, 140294675, 43, 138413337, 1093978284, 140296406, 8, 12, 1093978280, 0, 1848148816, 138089531, 1093978284, 140296404, 8, 1738783032, 1738783000, 1738783048, 1848148912, 0, 0, 1093775464, 1848148864, 137773708, 0, 12, 0, 0} offsets = (ulint *) 0x6e2881d8 #2 0x0835f8f7 in btr_search_info_update_slow (info=0x4131b068, cursor=0x41332b68) at btr0sea.c:519 block = (buf_block_t *) 0x67a3b918 build_index = 1 params2 = (ulint *) 0x41aa835c #3 0x083576b5 in btr_cur_search_to_nth_level (index=0x41333768, level=0, tuple=0x41342068, mode=4, latch_mode=1, cursor=0x41332b68, has_search_latch=0, mtr=0x6e2888e8) at btr0sea.ic:66 tree = (dict_tree_t *) 0x4131b468 page_cursor = (page_cur_t *) 0x41332b6c page = (ib_page_t *) 0x44c50000 ",Óà`" guess = (ib_page_t *) 0x0 page_no = 21236 space = 0 up_match = 0 up_bytes = 4 low_match = 1 low_bytes = 0 height = 0 savepoint = 8 rw_latch = 1 page_mode = 4 insert_planned = 0 buf_mode = 10 estimate = 0 ignore_sec_unique = 0 root_height = 2 info = (btr_search_t *) 0x4131b068 heap = (mem_heap_t *) 0x0 offsets_ = {100, 2, 2147483653, 5, 9, 4, 2147483653, 4, 8, 12, 17, 138090970, 13, 143857448, 2147483653, 4, 8, 143857464, 1848149200, 139344278, 143857464, 1848155440, 1848149216, 138090970, 12, 0, 1848149232, 1093883288, 143857460, 143857448, 1848149232, 138120910, 143857464, 140342953, 617, 143857460, 7, 1073988193, 1091713668, 1152991232, 1091713640, 1738765004, 1848149296, 139344278, 1738765004, 1848155440, 1091713644, 1848155440, 1073977734, 0, 1848149328, 1738764984, 1738765000, 1738764952, 1848149328, 138120910, 1738765004, 140342953, 617, 1738764984, 1738765000, 1738764952, 1848149456, 137784832, 1738765004, 140294675, 43, 139344278, 1738765004, 1738765004, 1848149408, 139344278, 1738765004, 1848155440, 1848149424, 1738765000, 1738764984, 0, 1848149440, 1738765000, 1738764984, 0, 1738765000, 1, 247, 140390992, 1091713640, 1, 0, 0, 1848149504, 1152991232, 1152996087, 1, 1848149520, 138456312, 1, 1738764952, 1152991232, 0} offsets = (ulint *) 0x6e288458 #4 0x083d866c in row_sel_get_clust_rec_for_mysql (prebuilt=0x41332868, sec_index=0x41332e68, rec=0x44b9605f "\200", thr=0x413421c8, out_rec=0x6e288738, offsets=0x6e288750, offset_heap=0x6e288754, mtr=0x6e2888e8) at btr0pcur.ic:535 clust_index = (dict_index_t *) 0x41333768 clust_rec = (rec_t *) 0x41332b68 "h73A½'ÅD" old_vers = (rec_t *) 0x6e288758 "d" err = 1101693788 trx = (trx_t *) 0x41327868 #5 0x083daab5 in row_search_for_mysql (buf=0x8e1b030 "", mode=2, prebuilt=0x41332868, match_mode=1, direction=1) at row0sel.c:4077 index = (dict_index_t *) 0x41332e68 comp = 1 search_tuple = (dtuple_t *) 0x41340868 pcur = (btr_pcur_t *) 0x41332a68 trx = (trx_t *) 0x41327868 clust_index = (dict_index_t *) 0x41333768 thr = (que_thr_t *) 0x413421c8 rec = (rec_t *) 0x44b9605f "\200" result_rec = (rec_t *) 0x3859
clust_rec = (rec_t *) 0x0 err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = 1 moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = 0 next_offs = 14425 same_user_rec = 1 mtr = {state = 0, memo = {heap = 0x0, used = 40, data = "\001\000\000\000\230r£g7\000\000\000\000\000\000\000\003\000\000\000\030A£g\003\000\000\000\030V£g\001\000\000\000\030¹£g\001\000\000\000\000\000\000\0005­\003@`5Pn\000\000\000\000P\211(n5­\003@`5Pn\000\000\000\000`\211(n¥@N\b\000\000\000\000\000\000\000\000p\211(n5­\003@ÐaPn\000\000\000\000\200\211(n¥@N\b\000\000\000\000\000\000\000\000\220\211(n¥@N\b\000\000\000\0000ïò\b \211(n¹NN\b0ïò\b\002\000\000\000À\211(n5­\003@(bPn\000\000\000\000à\211(ncÜ\e\b\205ëQ¸\036Ýc@Ð\211(n\023p\034\bà±á\b"..., base = {count = 150036728, start = 0x0, end = 0x0}, list = {prev = 0x6e288e60, next = 0x823757d}}, log = {heap = 0x0, used = 0, data = "\f\214(n\020\214(n\000\000\000\000\001\000\000\000@\213(n\030[Pn\2008ò\b\000\000\000\000P\213(n¹NN\büZPn\002\000\000\000\000\000\000\000@\\PnÙ~\rB\231´\rB\024\032\023B[e\aB\000pRn\000\000\002\000\003\000\000\0005­\003@\000\000\000\000\000\000\000\000\220\213(n¥@N\b\000\000\000\000\000\000\000\000 \213(n¥@N\b\000\000\000\000ÿ\017\000\000°\213(n5­\003@\020\000\000\000\000\000\000\000À\213(n5­\003@_\002_\002\000\000\000\000Ð\213(n¥@N\b\000\000\000\000\000\000\000\000à\213(n¥@N\b\000\000\000\000M4Pnð\213(n¹NN\b"..., base = {count = 1848151344, start = 0x84e40a5, end = 0x0}, list = {prev = 0x2, next = 0x6e288d50}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 1848151376, low = 139349689}, end_lsn = {high = 150138672, low = 2}, magic_n = 1848151392} heap = (mem_heap_t *) 0x0 offsets_ = {100, 4, 2147483653, 4, 8, 12, 17, 26, 58, 66, 70, 90, 140, 144, 148, 152, 52698, 0, 1848149968, 138119811, 148531160, 148531160, 140342953, 336, 1091723448, 140342953, 617, 1091723368, 1091723444, 0, 1848150048, 138053598, 148531160, 140294675, 43, 138409246, 1091761776, 0, 1848150048, 139344069, 1091707244, 1091723444, 1848150048, 139344000, 0, 2215984109, 1091761772, 1073982773, 1850750792, 0, 1848150080, 1073982773, 1850760960, 0, 1848150096, 139346085, 0, 0, 1848150112, 1073982773, 1850750792, 0, 1848150128, 1073982773, 1850761160, 0, 1848150144, 139346085, 0, 0, 1848150160, 1073982773, 1850750792, 0, 1848150176, 139346085, 0, 2, 1848150208, 139353509, 1073993993, 150138672, 1848150208, 139349689, 150138672, 2, 1848150240, 1073982773, 1850750304, 0, 1848150240, 139346085, 0, 0, 1848150256, 139346085, 0, 0, 40, 1} offsets = (ulint *) 0x6e288758 #6 0x082accdd in ha_innobase::general_fetch(char*, unsigned, unsigned) (this=0x8e1af18, buf=0x8e1b030 "", direction=1, match_mode=1) at ha_innodb.cc:4064 prebuilt = (row_prebuilt_t *) 0x41332868 ret = 149008152 error = 149008152 _db_func_ = 0x859f581 "do_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x6e288de0 #7 0x082acdd3 in ha_innobase::index_next_same(char*, char const*, unsigned) (this=0x8e1af18, buf=0x8e1b030 "", key=0x8f237f8 "\001", keylen=8) at ha_innodb.cc:4120 No locals. #8 0x08239cff in join_read_next_same (info=0x41aa835c) at sql_select.cc:10266 error = 1101693788 table = (TABLE *) 0x8edb7b8 tab = (JOIN_TAB *) 0xe805d0e1 #9 0x08238d72 in sub_select(JOIN*, st_join_table*, bool) (join=0x6e500e28, join_tab=0x8f23688, end_of_records=225) at sql_select.cc:9696 error = 1101693788 rc = -402272031 report_error = (my_bool *) 0x8f16bb0 "" info = (READ_RECORD *) 0x8f236c4 #10 0x0823892c in do_select (join=0x6e500e28, fields=0x0, table=0x6e505228, procedure=0x0) at sql_select.cc:9454 rc = 0 error = NESTED_LOOP_OK join_tab = (JOIN_TAB *) 0x8f23688 _db_func_ = 0x859f016 "JOIN::exec" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x6e288e90 #11 0x08228ed5 in JOIN::exec() (this=0x6e500e28) at sql_select.cc:1377 columns_list = (List *) 0x6e500e28 tmp_error = 1850740264 _db_func_ = 0x859f111 "mysql_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8f1649c curr_join = (JOIN *) 0x6e500e28 curr_all_fields = (List *) 0x6e501b60 curr_fields_list = (List *) 0x8f16400 curr_tmp_table = (TABLE *) 0x6e505228 #12 0x0822a4cc in mysql_select(THD*, Item***, st_table_list*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*, st_select_lex_unit*, st_select_lex*) ( thd=0x8f160f8, rref_pointer_array=0x8f1649c, tables=0x8f22460, wild_num=0, fields=@0x8f16400, conds=0x8f22b40, og_num=2, order=0x8f22da8, group=0x8f22cb8, having=0x0, proc_param=0x0, select_options=2147764736, result=0x8f22e30, unit=0x8f16148, select_lex=0x8f16378) at sql_select.cc:1933 err = false free_join = true _db_func_ = 0x859ee72 "handle_select" _db_file_ = 0x859ee64 "sql_select.cc" _db_level_ = 5 _db_framep_ = (char **) 0x6e288f60 join = (JOIN *) 0x6e500e28 #13 0x082261d2 in handle_select(THD*, st_lex*, select_result*, unsigned long) (thd=0x8f160f8, lex=0x8f16138, result=0x8f22e30, setup_tables_done_option=0) at sql_select.cc:238 unit = (SELECT_LEX_UNIT *) 0x8f16148 res = 72 select_lex = (SELECT_LEX *) 0x8f16378 _db_func_ = 0x855f6d7 "mysql_execute_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x6e288fd0 #14 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8f160f8) at sql_parse.cc:2541 result = (class select_result *) 0x8f22e30 res = false result = 150089264 lex = (LEX *) 0x8f16138 select_lex = (SELECT_LEX *) 0x8f22e30 first_table = (TABLE_LIST *) 0x8f22460 all_tables = (TABLE_LIST *) 0x8f22460 unit = (SELECT_LEX_UNIT *) 0x8f16148 _db_func_ = 0x855f87c "mysql_parse" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x6e289138 #15 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8f160f8, inBuf=0x8f21b08 "select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 1 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 70 group by Model order by Model", length=150036792) at sql_parse.cc:5899 lex = (LEX *) 0x8f16138 _db_func_ = 0x855f60c "dispatch_command" _db_file_ = 0x855f403 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x6e28951c #16 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8f160f8, packet=0x8f160f8 "(Ùd\bHÜè\b\b|ò\b<Ùd\bÈ!Pn\030añ\b", packet_length=174) at sql_parse.cc:1762 packet_end = 0x8f21bb5 "" net = (NET *) 0x8f16948 error = false _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0xffffffff #17 0x081f1886 in do_command(THD*) (thd=0x8f160f8) at sql_parse.cc:1548 packet = 0x8f19ad8 "\003select Model,avg(Price),min(Price),max(Price),count(*) \t\t\t from SH_Product where Project_Number = 1 and \t\t\t\tEmployeeID = 0 and \t\t\t\tType = 70 group by Model order by Model" old_timeout = 30 packet_length = 174 net = (NET *) 0x8f16948 command = COM_QUERY _db_func_ = 0x860bfb4 "?func" _db_file_ = 0x860bfba "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #18 0x081f0b8f in handle_one_connection (arg=0x41aa835c) at sql_parse.cc:1190 error = 1101693788 net = (NET *) 0x8f16948 sctx = (Security_context *) 0x8f17160 thd = (class THD *) 0x8f160f8 launch_time = 1101693788 set = {__val = {0 }} #19 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available.