Thread 1 (gdb) bt #0 0xffffe002 in ?? () #1 0x0831f7e3 in write_core (sig=17884) at stacktrace.c:220 #2 0x081da9c1 in handle_segfault (sig=22) at mysqld.cc:2155 #3 #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 #5 0x083db893 in row_sel_push_cache_row_for_mysql (prebuilt=0x41322068, rec=0x44bc3053 "\200", offsets=0x6e257758) at row0sel.c:3074 #6 0x083dabbf in row_search_for_mysql (buf=0x8e9f130 "", mode=2, prebuilt=0x41322068, match_mode=1, direction=1) at row0sel.c:4152 #7 0x082accdd in ha_innobase::general_fetch(char*, unsigned, unsigned) (this=0x8e9f018, buf=0x8e9f130 "", direction=1, match_mode=1) at ha_innodb.cc:4064 #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 #9 0x08239cff in join_read_next_same (info=0x0) at sql_select.cc:10266 #10 0x08238d72 in sub_select(JOIN*, st_join_table*, bool) (join=0x8f51ad0, join_tab=0x8eaa308, end_of_records=11) at sql_select.cc:9696 #11 0x0823892c in do_select (join=0x8f51ad0, fields=0x0, table=0x8f41660, procedure=0x0) at sql_select.cc:9454 #12 0x08228ed5 in JOIN::exec() (this=0x8f51ad0) at sql_select.cc:1377 #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 #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 #15 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8e8dc40) at sql_parse.cc:2541 #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 #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 #18 0x081f1886 in do_command(THD*) (thd=0x8e8dc40) at sql_parse.cc:1548 #19 0x081f0b8f in handle_one_connection (arg=0x0) at sql_parse.cc:1190 #20 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 2 (gdb) thread 2 [Switching to thread 2 (process 17892)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x083b6206 in os_file_pread (file=3, buf=0x44d10000, n=16384, offset=363347968, offset_high=0) at os0file.c:1891 #2 0x083b630e in os_file_read (file=3, buf=0x44d10000, offset=0, offset_high=0, n=16384) at os0file.c:2124 #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 #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 #5 0x0836debf in buf_read_page_low (err=0x6e1c10a0, sync=1, mode=16384, space=0, tablespace_version=70369898725376, offset=22177) at buf0rea.c:143 #6 0x0836e2c9 in buf_read_page (space=0, offset=22177) at buf0rea.c:331 #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 #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 #9 0x0835c395 in btr_estimate_n_rows_in_range (index=0x41332e68, tuple1=0x44d10000, mode1=2, tuple2=0x41356468, mode2=1) at btr0cur.c:2718 #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 #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 #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 #13 0x0828914b in check_quick_select (param=0x6e1c2b58, idx=0, tree=0x8f43df0) at opt_range.cc:6640 #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 #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 #16 0x0822a614 in get_quick_record_count (thd=0x8ecfe48, select=0x8f3dad0, table=0x8f4b888, keys=0x4000, limit=7934233071769878527) at sql_select.cc:1976 #17 0x0822b6d9 in make_join_statistics (join=0x8f4d420, tables=0x0, conds=0x8f3d090, keyuse_array=0x8f4e140) at sql_select.cc:2304 #18 0x0822720b in JOIN::optimize() (this=0x8f4d420) at sql_select.cc:710 #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 #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 #21 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ecfe48) at sql_parse.cc:2541 #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 #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 #24 0x081f1886 in do_command(THD*) (thd=0x8ecfe48) at sql_parse.cc:1548 #25 0x081f0b8f in handle_one_connection (arg=0x4000) at sql_parse.cc:1190 #26 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 3 (gdb) thread 3 [Switching to thread 3 (process 17891)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x083b8ab2 in os_event_wait (event=0x87aae9c) at os0sync.c:336 #2 0x083e7a94 in sync_array_wait_event (arr=0x87aabd0, index=2) at sync0arr.c:480 #3 0x083e93c5 in rw_lock_x_lock_func (lock=0x41123c68, pass=0, file_name=0x85d855d "page0page.c", line=197) at sync0rw.c:539 #4 0x083bd60a in page_set_max_trx_id (page=0x435cc000 "F\216\217³", trx_id={high = 0, low = 203964}) at page0page.c:197 #5 0x083a48db in lock_rec_insert_check_and_lock (flags=0, rec=0x435cc07d "\200", index=0x41319668, thr=0x41338440, inherit=0x6e22659c) at page0page.ic:45 #6 0x0835ec4b in btr_cur_ins_lock_and_undo (flags=0, cursor=0xfffffffc, entry=0x4133a868, thr=0x41338440, inherit=0x6e22659c) at btr0cur.c:859 #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 #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 #9 0x083cb661 in row_ins_index_entry (index=0x41319668, entry=0x4133a868, ext_vec=0x0, n_ext_vec=0, thr=0x41338440) at row0ins.c:2174 #10 0x083cb745 in row_ins_index_entry_step (node=0x413380a8, thr=0x41338440) at row0ins.c:2253 #11 0x083cb908 in row_ins (node=0x413380a8, thr=0x41338440) at row0ins.c:2385 #12 0x083cba5c in row_ins_step (thr=0x41338440) at row0ins.c:2495 #13 0x083cd6ad in row_insert_for_mysql (mysql_rec=0x8f2f7d8 "ÿ\t", prebuilt=0x41336868) at row0mysql.c:1147 #14 0x082abf71 in ha_innobase::write_row(char*) (this=0x8f2f6c0, record=0x8f2f7d8 "ÿ\t") at ha_innodb.cc:3312 #15 0x0829b1e2 in handler::ha_write_row(char*) (this=0x8f2f6c0, buf=0x8f2f7d8 "ÿ\t") at handler.cc:3295 #16 0x082454db in write_record(THD*, st_table*, st_copy_info*) (thd=0x8e9d658, table=0x8f2f078, info=0x6e226f58) at sql_insert.cc:1131 #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 #18 0x081f520b in mysql_execute_command(THD*) (thd=0x8e9d658) at sql_parse.cc:3332 #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 #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 #21 0x081f1886 in do_command(THD*) (thd=0x8e9d658) at sql_parse.cc:1548 #22 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 #23 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 4 (gdb) thread 4 [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 93 sql_list.h: No such file or directory. in sql_list.h Current language: auto; currently c++ (gdb) bt #0 JOIN (this=0x8f4f780, thd_arg=0x8ee8a08, fields_arg=@0x8ee8d10, select_options_arg=2147764736, result_arg=0x8f14218) at sql_list.h:93 #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 #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 #3 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ee8a08) at sql_parse.cc:2541 #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 #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 #6 0x081f1886 in do_command(THD*) (thd=0x8ee8a08) at sql_parse.cc:1548 #7 0x081f0b8f in handle_one_connection (arg=0x8f503ac) at sql_parse.cc:1190 #8 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 5 (gdb) thread 5 [Switching to thread 5 (process 17889)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x083b8ab2 in os_event_wait (event=0x8da6834) at os0sync.c:336 #2 0x083a87de in log_write_up_to (lsn={high = 0, low = 2215994283}, wait=92, flush_to_disk=1) at log0log.c:1504 #3 0x083f9593 in trx_commit_off_kernel (trx=0x41353068) at trx0trx.c:931 #4 0x083fa532 in trx_commit_for_mysql (trx=0x41353068) at trx0trx.c:1609 #5 0x082aa38a in innobase_commit_low(trx_struct*) (trx=0x41353068) at ha_innodb.cc:1568 #6 0x082aa60d in innobase_commit (thd=0x8eac0c8, all=false) at ha_innodb.cc:1700 #7 0x0829670a in ha_commit_one_phase(THD*, bool) (thd=0x8eac0c8, all=false) at handler.cc:740 #8 0x082965e2 in ha_commit_trans(THD*, bool) (thd=0x8eac0c8, all=false) at handler.cc:710 #9 0x082969f5 in ha_autocommit_or_rollback(THD*, int) (thd=0x8eac0c8, error=0) at handler.cc:849 #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 #11 0x081f4fc2 in mysql_execute_command(THD*) (thd=0x8eac0c8) at sql_parse.cc:3257 #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 #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 #14 0x081f1886 in do_command(THD*) (thd=0x8eac0c8) at sql_parse.cc:1548 #15 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 #16 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 6 (gdb) thread 6 [Switching to thread 6 (process 17888)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x083b8ab2 in os_event_wait (event=0x87aae04) at os0sync.c:336 #2 0x083e7a94 in sync_array_wait_event (arr=0x87aabd0, index=1) at sync0arr.c:480 #3 0x083e93c5 in rw_lock_x_lock_func (lock=0x41123c68, pass=0, file_name=0x85d855d "page0page.c", line=197) at sync0rw.c:539 #4 0x083bd60a in page_set_max_trx_id (page=0x43514000 "¾7Qb", trx_id={high = 0, low = 203963}) at page0page.c:197 #5 0x083a48db in lock_rec_insert_check_and_lock (flags=0, rec=0x4351407d "\200", index=0x41319668, thr=0x41334440, inherit=0x6e31b59c) at page0page.ic:45 #6 0x0835ec4b in btr_cur_ins_lock_and_undo (flags=0, cursor=0xfffffffc, entry=0x41336068, thr=0x41334440, inherit=0x6e31b59c) at btr0cur.c:859 #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 #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 #9 0x083cb661 in row_ins_index_entry (index=0x41319668, entry=0x41336068, ext_vec=0x0, n_ext_vec=0, thr=0x41334440) at row0ins.c:2174 #10 0x083cb745 in row_ins_index_entry_step (node=0x413340a8, thr=0x41334440) at row0ins.c:2253 #11 0x083cb908 in row_ins (node=0x413340a8, thr=0x41334440) at row0ins.c:2385 #12 0x083cba5c in row_ins_step (thr=0x41334440) at row0ins.c:2495 #13 0x083cd6ad in row_insert_for_mysql (mysql_rec=0x8f273c8 "ÿ\006", prebuilt=0x41333268) at row0mysql.c:1147 #14 0x082abf71 in ha_innobase::write_row(char*) (this=0x8f272b0, record=0x8f273c8 "ÿ\006") at ha_innodb.cc:3312 #15 0x0829b1e2 in handler::ha_write_row(char*) (this=0x8f272b0, buf=0x8f273c8 "ÿ\006") at handler.cc:3295 #16 0x082454db in write_record(THD*, st_table*, st_copy_info*) (thd=0x8f06ea8, table=0x8f26468, info=0x6e31bf58) at sql_insert.cc:1131 #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 #18 0x081f520b in mysql_execute_command(THD*) (thd=0x8f06ea8) at sql_parse.cc:3332 #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 #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 #21 0x081f1886 in do_command(THD*) (thd=0x8f06ea8) at sql_parse.cc:1548 #22 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 #23 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 7 (gdb) thread 7 [Switching to thread 7 (process 17887)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x083b6206 in os_file_pread (file=3, buf=0x44d14000, n=16384, offset=354598912, offset_high=0) at os0file.c:1891 #2 0x083b630e in os_file_read (file=3, buf=0x44d14000, offset=0, offset_high=0, n=16384) at os0file.c:2124 #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 #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 #5 0x0836debf in buf_read_page_low (err=0x6e2ea240, sync=1, mode=16384, space=0, tablespace_version=70369898741760, offset=21643) at buf0rea.c:143 #6 0x0836e2c9 in buf_read_page (space=0, offset=21643) at buf0rea.c:331 #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 #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 #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 #10 0x083daab5 in row_search_for_mysql (buf=0x6e503ba0 "", mode=2, prebuilt=0x41347c68, match_mode=1, direction=0) at row0sel.c:4077 #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 #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 #13 0x0829a41f in handler::read_multi_range_first(st_key_multi_range**, st_key_multi_range*, unsigned, bool, st_handler_buffer*) (this=0x6e503a88, found_range_p=0x4000, ranges=0x6e548e68, range_count=16384, buffer=0x4000) at handler.cc:2788 #14 0x0828b1d1 in QUICK_RANGE_SELECT::get_next() (this=0x6e503988) at opt_range.cc:7732 #15 0x08292802 in rr_quick (info=0x6e547c0c) at records.cc:304 #16 0x08239e89 in join_init_read_record (tab=0x6e547bd0) at sql_select.cc:10324 #17 0x08238d57 in sub_select(JOIN*, st_join_table*, bool) (join=0x6e5465b0, join_tab=0x6e547bd0, end_of_records=false) at sql_select.cc:9690 #18 0x0823892c in do_select (join=0x6e5465b0, fields=0x0, table=0x6e54b910, procedure=0x0) at sql_select.cc:9454 #19 0x08228ed5 in JOIN::exec() (this=0x6e5465b0) at sql_select.cc:1377 #20 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=0x8ecc568, rref_pointer_array=0x8ecc90c, tables=0x8ef4d08, wild_num=0, fields=@0x8ecc870, conds=0x8ef5a78, og_num=2, order=0x8ef5cf0, group=0x8ef5bf8, having=0x0, proc_param=0x0, ---Type to continue, or q to quit--- select_options=2147764736, result=0x8ef5d78, unit=0x8ecc5b8, select_lex=0x8ecc7e8) at sql_select.cc:1933 #21 0x082261d2 in handle_select(THD*, st_lex*, select_result*, unsigned long) (thd=0x8ecc568, lex=0x8ecc5a8, result=0x8ef5d78, setup_tables_done_option=0) at sql_select.cc:238 #22 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ecc568) at sql_parse.cc:2541 #23 0x081fa6bf in mysql_parse(THD*, char*, unsigned) (thd=0x8ecc568, inBuf=0x8ef4300 "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 = 5 \t\t\t\tor PR.Project_Number = 65) \t\t\t\tand PR.EmployeeID = 8 \t\t\t\tand P"..., length=149734824) at sql_parse.cc:5899 #24 0x081f1ecb in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_QUERY, thd=0x8ecc568, packet=0x8ecc568 "(Ùd\b°nð\bÈÐë\b<Ùd\bà\233Tn\210Åì\b", packet_length=293) at sql_parse.cc:1762 #25 0x081f1886 in do_command(THD*) (thd=0x8ecc568) at sql_parse.cc:1548 #26 0x081f0b8f in handle_one_connection (arg=0x4000) at sql_parse.cc:1190 #27 0x40038332 in start_thread () from /lib/tls/libpthread.so. Thread 8 (gdb) thread 8 [Switching to thread 8 (process 17886)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x08385b5e in fil_flush (space_id=4294967280) at fil0fil.c:4246 #2 0x083a853b in log_write_up_to (lsn={high = 0, low = 2215994009}, wait=92, flush_to_disk=1) at log0log.c:1475 #3 0x083f9593 in trx_commit_off_kernel (trx=0x41345868) at trx0trx.c:931 #4 0x083fa532 in trx_commit_for_mysql (trx=0x41345868) at trx0trx.c:1609 #5 0x082aa38a in innobase_commit_low(trx_struct*) (trx=0x41345868) at ha_innodb.cc:1568 #6 0x082aa60d in innobase_commit (thd=0x8ebd0c8, all=false) at ha_innodb.cc:1700 #7 0x0829670a in ha_commit_one_phase(THD*, bool) (thd=0x8ebd0c8, all=false) at handler.cc:740 #8 0x082965e2 in ha_commit_trans(THD*, bool) (thd=0x8ebd0c8, all=false) at handler.cc:710 #9 0x082969f5 in ha_autocommit_or_rollback(THD*, int) (thd=0x8ebd0c8, error=0) at handler.cc:849 #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 #11 0x081f4fc2 in mysql_execute_command(THD*) (thd=0x8ebd0c8) at sql_parse.cc:3257 #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 #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 #14 0x081f1886 in do_command(THD*) (thd=0x8ebd0c8) at sql_parse.cc:1548 #15 0x081f0b8f in handle_one_connection (arg=0x0) at sql_parse.cc:1190 #16 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 9 (gdb) thread 9 [Switching to thread 9 (process 17885)]#0 0xffffe002 in ?? () (gdb) bt #0 0xffffe002 in ?? () #1 0x083b8ab2 in os_event_wait (event=0x87aad6c) at os0sync.c:336 #2 0x083e7a94 in sync_array_wait_event (arr=0x87aabd0, index=0) at sync0arr.c:480 #3 0x083e8e18 in rw_lock_s_lock_spin (lock=0x41123c68, pass=0, file_name=0x85cc0d4 "btr0sea.c", line=1131) at sync0rw.c:287 #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 #5 0x0835f8f7 in btr_search_info_update_slow (info=0x4131b068, cursor=0x41320468) at btr0sea.c:519 #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 #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 #8 0x083daab5 in row_search_for_mysql (buf=0x8ef9fc0 "", mode=2, prebuilt=0x4131da68, match_mode=1, direction=1) at row0sel.c:4077 #9 0x082accdd in ha_innobase::general_fetch(char*, unsigned, unsigned) (this=0x8ef9ea8, buf=0x8ef9fc0 "", direction=1, match_mode=1) at ha_innodb.cc:4064 #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 #11 0x08239cff in join_read_next_same (info=0xfffffffc) at sql_select.cc:10266 #12 0x08238d72 in sub_select(JOIN*, st_join_table*, bool) (join=0x8f3e070, join_tab=0x8ee6c30, end_of_records=134) at sql_select.cc:9696 #13 0x0823892c in do_select (join=0x8f3e070, fields=0x0, table=0x8f422b0, procedure=0x0) at sql_select.cc:9454 #14 0x08228ed5 in JOIN::exec() (this=0x8f3e070) at sql_select.cc:1377 #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 #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 #17 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8ebbb00) at sql_parse.cc:2541 #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 #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 #20 0x081f1886 in do_command(THD*) (thd=0x8ebbb00) at sql_parse.cc:1548 #21 0x081f0b8f in handle_one_connection (arg=0xfffffffc) at sql_parse.cc:1190 #22 0x40038332 in start_thread () from /lib/tls/libpthread.so.0 Thread 10 (gdb) thread 10 [Switching to thread 10 (process 17883)]#0 ha_insert_for_fold (table=0x42138000, fold=3892695265, data=0x44c51905) at ha0ha.c:150 150 ha0ha.c: No such file or directory. in ha0ha.c Current language: auto; currently c (gdb) bt #0 ha_insert_for_fold (table=0x42138000, fold=3892695265, data=0x44c51905) at ha0ha.c:150 #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 #2 0x0835f8f7 in btr_search_info_update_slow (info=0x4131b068, cursor=0x41332b68) at btr0sea.c:519 #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 #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 #5 0x083daab5 in row_search_for_mysql (buf=0x8e1b030 "", mode=2, prebuilt=0x41332868, match_mode=1, direction=1) at row0sel.c:4077 #6 0x082accdd in ha_innobase::general_fetch(char*, unsigned, unsigned) (this=0x8e1af18, buf=0x8e1b030 "", direction=1, match_mode=1) at ha_innodb.cc:4064 #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 #8 0x08239cff in join_read_next_same (info=0x41aa835c) at sql_select.cc:10266 #9 0x08238d72 in sub_select(JOIN*, st_join_table*, bool) (join=0x6e500e28, join_tab=0x8f23688, end_of_records=225) at sql_select.cc:9696 #10 0x0823892c in do_select (join=0x6e500e28, fields=0x0, table=0x6e505228, procedure=0x0) at sql_select.cc:9454 #11 0x08228ed5 in JOIN::exec() (this=0x6e500e28) at sql_select.cc:1377 #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 #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 #14 0x081f37a3 in mysql_execute_command(THD*) (thd=0x8f160f8) at sql_parse.cc:2541 #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 #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 #17 0x081f1886 in do_command(THD*) (thd=0x8f160f8) at sql_parse.cc:1548 #18 0x081f0b8f in handle_one_connection (arg=0x41aa835c) at sql_parse.cc:1190 #19 0x40038332 in start_thread () from /lib/tls/libpthread.so.0