(gdb) set args --console --skip-grant-tables --innodb_lock_wait_timeout=1 --innodb_flush_log_at_trx_commit=0 --innodb_buffer_pool_size=250M --log-bin --sync-binlog=0 --binlo g-format=statement --skip-name-resolve --basedir=. --datadir=./data (gdb) run Starting program: /home/sbester/mysql/5.1/mysql-advanced-gpl-5.1.41-linux-x86_64-glibc23/bin/mysqld-debug --console --skip-grant-tables --innodb_lock_wait_timeout=1 --innodb_flush_log_at_trx_commit=0 --innodb_buffer_pool_size=250M --log-bin --sync-binlog=0 --binlog-format=statement --skip-name-resolve --basedir=. --datadir=./data [Thread debugging using libthread_db enabled] [New Thread 47358567547344 (LWP 1121)] [New Thread 1082132800 (LWP 1122)] [Thread 1082132800 (zombie) exited] 091202 13:41:48 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=box2-bin' to avoid this problem. 091202 13:41:48 [Note] Plugin 'FEDERATED' is disabled. [New Thread 1082132800 (LWP 1123)] [New Thread 1090525504 (LWP 1124)] [New Thread 1098918208 (LWP 1125)] [New Thread 1107310912 (LWP 1126)] InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 091202 13:41:48 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 091202 13:41:48 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 091202 13:41:48 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... [New Thread 1115703616 (LWP 1127)] [New Thread 1124096320 (LWP 1128)] InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created [New Thread 1132489024 (LWP 1129)] 091202 13:41:49 InnoDB: Started; log sequence number 0 0 [New Thread 1132755264 (LWP 1130)] 091202 13:41:49 [Note] /home/sbester/mysql/5.1/mysql-advanced-gpl-5.1.41-linux-x86_64-glibc23/bin/mysqld-debug: ready for connections. Version: '5.1.41-enterprise-gpl-advanced-debug-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition Debug (GPL) [New Thread 1133021504 (LWP 1131)] [Thread 1133021504 (zombie) exited] [New Thread 1133021504 (LWP 1142)] [Thread 1133021504 (zombie) exited] [New Thread 1133021504 (LWP 1148)] [New Thread 1133287744 (LWP 1149)] [New Thread 1133553984 (LWP 1150)] [New Thread 1133820224 (LWP 1151)] [New Thread 1134086464 (LWP 1152)] InnoDB: Error: MySQL is trying to perform a consistent read InnoDB: but the read view is not assigned! TRANSACTION 0 901, ACTIVE 0 sec, process no 1121, OS thread id 1133553984 starting index read, thread declared inside InnoDB 0 mysql tables in use 3, locked 1 MySQL thread id 5, query id 175 127.0.0.1 root Sending data SELECT INSTRUMENT.SYMBOL as symbol, INSTRUMENT.INSTRUMENT_TYPE AS instrumentType, PRICING.CLOSE_PRICE AS closePrice, PRICING.LAST_TRADED_PRICE AS tradePrice, PRICING.BID_PRICE AS bidPrice, PRICING.ASK_PRICE AS askPrice FROM tbl_i INSTRUMENT, tbl_s PRICING WHERE INSTRUMENT.INSTRUMENT_ID = PRICING.INSTRUMENT_ID AND INSTRUMENT.STATUS= 'Active' AND INSTRUMENT.INSTRUMENT_TYPE = 'Option' AND INSTRUMENT.SYMBOL IN ('CKOXG', 'CBIAE', 'DISAF', 'DVNDO', 'UNYWL', 'IBMKF', 'AJLKV', 'RQEEB', 'BQBXB', 'RJFKE', 'SLVKR', 'HQIKL', 'IAQP 091202 13:43:58 InnoDB: Assertion failure in thread 1133553984 in file row/row0sel.c line 3642 InnoDB: Failing assertion: 0 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. Program received signal SIGABRT, Aborted. [Switching to Thread 1133553984 (LWP 1150)] 0x00002b1286675535 in raise () from /lib64/libc.so.6 (gdb) set pagination off (gdb) set print pretty on (gdb) thread apply all bt Thread 17 (Thread 1134086464 (LWP 1152)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb0998, mp=0xfb0920, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0920, reset_sig_count=) at os/os0sync.c:422 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5e1478) at srv/srv0srv.c:1497 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x4398a3c8, trx=0x2aaaab5d30b8, thr=0x2aaaab5e1478, savept=0x4398a3d0) at row/row0mysql.c:496 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x2028510 "Á½\023\237Þè", prebuilt=0x2aaaab5d0cb8) at row/row0mysql.c:1170 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x2028320, record=0x2028510 "Á½\023\237Þè") at handler/ha_innodb.cc:3920 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x2028320, buf=0x2028510 "Á½\023\237Þè") at handler.cc:4650 #8 0x00000000006510a5 in write_record (thd=0x200b940, table=0x2027a70, info=0x2022368) at sql_insert.cc:1354 #9 0x0000000000651502 in select_insert::send_data (this=0x2022328, values=@0x200d8d8) at sql_insert.cc:3153 #10 0x0000000000631b1e in end_send (join=0x2042f80, join_tab=, end_of_records=false) at sql_select.cc:12142 #11 0x000000000062ce5e in evaluate_join_record (join=0x2042f80, join_tab=0x2045508, error=) at sql_select.cc:11365 #12 0x000000000062fb5f in sub_select (join=0x2042f80, join_tab=0x2045508, end_of_records=) at sql_select.cc:11239 #13 0x000000000062ce5e in evaluate_join_record (join=0x2042f80, join_tab=0x20452b0, error=) at sql_select.cc:11365 #14 0x000000000062fb5f in sub_select (join=0x2042f80, join_tab=0x20452b0, end_of_records=) at sql_select.cc:11239 #15 0x0000000000647ea3 in do_select (join=0x2042f80, fields=0x200d8d8, table=0x0, procedure=0x0) at sql_select.cc:10995 #16 0x000000000064a54f in JOIN::exec (this=0x2042f80) at sql_select.cc:2246 #17 0x000000000064ac38 in mysql_select (thd=0x200b940, rref_pointer_array=0x200d9a0, tables=0x20212f0, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x2022328, unit=0x200d3a8, select_lex=0x200d7d0) at sql_select.cc:2435 #18 0x000000000064dce0 in handle_select (thd=0x200b940, lex=0x200d308, result=0x2022328, setup_tables_done_option=1073741824) at sql_select.cc:269 #19 0x00000000005df74d in mysql_execute_command (thd=0x200b940) at sql_parse.cc:3233 #20 0x00000000005e42a3 in mysql_parse (thd=0x200b940, inBuf=0x2032fb0 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x4398bfc8) at sql_parse.cc:5970 #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x200b940, packet=, packet_length=425) at sql_parse.cc:1231 #22 0x00000000005e6366 in do_command (thd=0x200b940) at sql_parse.cc:872 #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 #26 0x0000000000000000 in ?? () Thread 16 (Thread 1133820224 (LWP 1151)): #0 0x00002b1285b89937 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc2ef in safe_cond_timedwait (cond=0x43948eb0, mp=0xd2f760, abstime=0x43948ee0, file=0xffffffffffffff92
, line=3788) at thr_mutex.c:275 #2 0x000000000054e5ff in Item_func_sleep::val_int (this=) at item_func.cc:3788 #3 0x00000000005281a0 in Item::send (this=0x201c740, protocol=0x1feb890, buffer=0x43949290) at item.cc:5555 #4 0x00000000005be44e in select_send::send_data (this=0x201c8c8, items=) at sql_class.cc:1644 #5 0x00000000006483e3 in JOIN::exec (this=0x201c8e8) at sql_select.cc:1724 #6 0x000000000064ac38 in mysql_select (thd=0x1feb4c0, rref_pointer_array=0x1fed520, tables=0x0, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x201c8c8, unit=0x1fecf28, select_lex=0x1fed350) at sql_select.cc:2435 #7 0x000000000064dce0 in handle_select (thd=0x1feb4c0, lex=0x1fece88, result=0x201c8c8, setup_tables_done_option=0) at sql_select.cc:269 #8 0x00000000005d8b4e in execute_sqlcom_select (thd=0x1feb4c0, all_tables=0x0) at sql_parse.cc:5051 #9 0x00000000005e3228 in mysql_execute_command (thd=0x1feb4c0) at sql_parse.cc:2246 #10 0x00000000005e42a3 in mysql_parse (thd=0x1feb4c0, inBuf=0x201c2c0 "select sleep(abs(-420392769)%5)", length=31, found_semicolon=0x4394afc8) at sql_parse.cc:5970 #11 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1feb4c0, packet=, packet_length=31) at sql_parse.cc:1231 #12 0x00000000005e6366 in do_command (thd=0x1feb4c0) at sql_parse.cc:872 #13 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #14 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #15 0x00002b12867064cd in clone () from /lib64/libc.so.6 #16 0x0000000000000000 in ?? () Thread 15 (Thread 1133553984 (LWP 1150)): #0 0x00002b1286675535 in raise () from /lib64/libc.so.6 #1 0x00002b1286676990 in abort () from /lib64/libc.so.6 #2 0x0000000000816297 in row_search_for_mysql (buf=0x1fee200 "Á½\023\237Þè", mode=2, prebuilt=0x2aaaab5d78b8, match_mode=1, direction=46912507838648) at row/row0sel.c:3642 #3 0x00000000007922eb in ha_innobase::index_read (this=0x1fee010, buf=0x1fee200 "Á½\023\237Þè", key_ptr=, key_len=12, find_flag=) at handler/ha_innodb.cc:4601 #4 0x00000000006ce36a in handler::index_read_map (this=0x1fee010, buf=0x1fee200 "Á½\023\237Þè", key=0x204bf48 "w.²Ôè", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1401 #5 0x000000000063d1db in join_read_always_key (tab=0x204bcf0) at sql_select.cc:11836 #6 0x000000000062fb52 in sub_select (join=0x2034fd0, join_tab=0x47e, end_of_records=6) at sql_select.cc:11238 #7 0x000000000062ce5e in evaluate_join_record (join=0x2034fd0, join_tab=0x204ba98, error=) at sql_select.cc:11365 #8 0x000000000062fb77 in sub_select (join=0x2034fd0, join_tab=0x204ba98, end_of_records=) at sql_select.cc:11245 #9 0x0000000000647ea3 in do_select (join=0x2034fd0, fields=0x1fe4af8, table=0x0, procedure=0x0) at sql_select.cc:10995 #10 0x000000000064a54f in JOIN::exec (this=0x2034fd0) at sql_select.cc:2246 #11 0x000000000064ac38 in mysql_select (thd=0x1fe2b60, rref_pointer_array=0x1fe4bc0, tables=0x20173e8, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x2021118, unit=0x1fe45c8, select_lex=0x1fe49f0) at sql_select.cc:2435 #12 0x000000000064dce0 in handle_select (thd=0x1fe2b60, lex=0x1fe4528, result=0x2021118, setup_tables_done_option=0) at sql_select.cc:269 #13 0x00000000005d8b4e in execute_sqlcom_select (thd=0x1fe2b60, all_tables=0x20173e8) at sql_parse.cc:5051 #14 0x00000000005e3228 in mysql_execute_command (thd=0x1fe2b60) at sql_parse.cc:2246 #15 0x00000000005e42a3 in mysql_parse (thd=0x1fe2b60, inBuf=0x2016290 "SELECT INSTRUMENT.SYMBOL as symbol, INSTRUMENT.INSTRUMENT_TYPE AS instrumentType, PRICING.CLOSE_PRICE AS closePrice, PRICING.LAST_TRADED_PRICE AS tradePrice, PRICING.BID_PRICE AS bidPr"..., length=1211, found_semicolon=0x43909fc8) at sql_parse.cc:5970 #16 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1fe2b60, packet=, packet_length=1212) at sql_parse.cc:1231 #17 0x00000000005e6366 in do_command (thd=0x1fe2b60) at sql_parse.cc:872 #18 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #19 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #20 0x00002b12867064cd in clone () from /lib64/libc.so.6 #21 0x0000000000000000 in ?? () Thread 14 (Thread 1133287744 (LWP 1149)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb08b8, mp=0xfb0840, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0840, reset_sig_count=) at os/os0sync.c:422 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5dc478) at srv/srv0srv.c:1497 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x438c73c8, trx=0x2aaaab5f38b8, thr=0x2aaaab5dc478, savept=0x438c73d0) at row/row0mysql.c:496 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x203bed0 "Á½\023\237Þè", prebuilt=0x2aaaab5d3cb8) at row/row0mysql.c:1170 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x203bce0, record=0x203bed0 "Á½\023\237Þè") at handler/ha_innodb.cc:3920 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x203bce0, buf=0x203bed0 "Á½\023\237Þè") at handler.cc:4650 #8 0x00000000006510a5 in write_record (thd=0x1fdc230, table=0x203b430, info=0x2038038) at sql_insert.cc:1354 #9 0x0000000000651502 in select_insert::send_data (this=0x2037ff8, values=@0x1fde1c8) at sql_insert.cc:3153 #10 0x0000000000631b1e in end_send (join=0x203df20, join_tab=, end_of_records=false) at sql_select.cc:12142 #11 0x000000000062ce5e in evaluate_join_record (join=0x203df20, join_tab=0x2040168, error=) at sql_select.cc:11365 #12 0x000000000062fb5f in sub_select (join=0x203df20, join_tab=0x2040168, end_of_records=) at sql_select.cc:11239 #13 0x000000000062ce5e in evaluate_join_record (join=0x203df20, join_tab=0x203ff10, error=) at sql_select.cc:11365 #14 0x000000000062fb5f in sub_select (join=0x203df20, join_tab=0x203ff10, end_of_records=) at sql_select.cc:11239 #15 0x0000000000647ea3 in do_select (join=0x203df20, fields=0x1fde1c8, table=0x0, procedure=0x0) at sql_select.cc:10995 #16 0x000000000064a54f in JOIN::exec (this=0x203df20) at sql_select.cc:2246 #17 0x000000000064ac38 in mysql_select (thd=0x1fdc230, rref_pointer_array=0x1fde290, tables=0x2036fc0, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x2037ff8, unit=0x1fddc98, select_lex=0x1fde0c0) at sql_select.cc:2435 #18 0x000000000064dce0 in handle_select (thd=0x1fdc230, lex=0x1fddbf8, result=0x2037ff8, setup_tables_done_option=1073741824) at sql_select.cc:269 #19 0x00000000005df74d in mysql_execute_command (thd=0x1fdc230) at sql_parse.cc:3233 #20 0x00000000005e42a3 in mysql_parse (thd=0x1fdc230, inBuf=0x1ff6770 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x438c8fc8) at sql_parse.cc:5970 #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1fdc230, packet=, packet_length=425) at sql_parse.cc:1231 #22 0x00000000005e6366 in do_command (thd=0x1fdc230) at sql_parse.cc:872 #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 #26 0x0000000000000000 in ?? () Thread 13 (Thread 1133021504 (LWP 1148)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb0a78, mp=0xfb0a00, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0a00, reset_sig_count=) at os/os0sync.c:422 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5e0478) at srv/srv0srv.c:1497 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x438863c8, trx=0x2aaaab5c50b8, thr=0x2aaaab5e0478, savept=0x438863d0) at row/row0mysql.c:496 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x203d450 "ÁVU¢Þè", prebuilt=0x2aaaab5d44b8) at row/row0mysql.c:1170 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x203d260, record=0x203d450 "ÁVU¢Þè") at handler/ha_innodb.cc:3920 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x203d260, buf=0x203d450 "ÁVU¢Þè") at handler.cc:4650 #8 0x00000000006510a5 in write_record (thd=0x1fc72f0, table=0x203c990, info=0x2006a08) at sql_insert.cc:1354 #9 0x0000000000651502 in select_insert::send_data (this=0x20069c8, values=@0x1fc9288) at sql_insert.cc:3153 #10 0x0000000000631b1e in end_send (join=0x1ff98d0, join_tab=, end_of_records=false) at sql_select.cc:12142 #11 0x000000000062ce5e in evaluate_join_record (join=0x1ff98d0, join_tab=0x1ffbe58, error=) at sql_select.cc:11365 #12 0x000000000062fb5f in sub_select (join=0x1ff98d0, join_tab=0x1ffbe58, end_of_records=) at sql_select.cc:11239 #13 0x000000000062ce5e in evaluate_join_record (join=0x1ff98d0, join_tab=0x1ffbc00, error=) at sql_select.cc:11365 #14 0x000000000062fb77 in sub_select (join=0x1ff98d0, join_tab=0x1ffbc00, end_of_records=) at sql_select.cc:11245 #15 0x0000000000647ea3 in do_select (join=0x1ff98d0, fields=0x1fc9288, table=0x0, procedure=0x0) at sql_select.cc:10995 #16 0x000000000064a54f in JOIN::exec (this=0x1ff98d0) at sql_select.cc:2246 #17 0x000000000064ac38 in mysql_select (thd=0x1fc72f0, rref_pointer_array=0x1fc9350, tables=0x2005990, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x20069c8, unit=0x1fc8d58, select_lex=0x1fc9180) at sql_select.cc:2435 #18 0x000000000064dce0 in handle_select (thd=0x1fc72f0, lex=0x1fc8cb8, result=0x20069c8, setup_tables_done_option=1073741824) at sql_select.cc:269 #19 0x00000000005df74d in mysql_execute_command (thd=0x1fc72f0) at sql_parse.cc:3233 #20 0x00000000005e42a3 in mysql_parse (thd=0x1fc72f0, inBuf=0x1fca920 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x43887fc8) at sql_parse.cc:5970 #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1fc72f0, packet=, packet_length=425) at sql_parse.cc:1231 #22 0x00000000005e6366 in do_command (thd=0x1fc72f0) at sql_parse.cc:872 #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 #26 0x0000000000000000 in ?? () Thread 10 (Thread 1132755264 (LWP 1130)): #0 0x00002b1285b8ce18 in do_sigwait () from /lib64/libpthread.so.0 #1 0x00002b1285b8cebd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000005ccaec in signal_hand (arg=) at mysqld.cc:2772 #3 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #4 0x00002b12867064cd in clone () from /lib64/libc.so.6 #5 0x0000000000000000 in ?? () Thread 9 (Thread 1132489024 (LWP 1129)): #0 0x00002b1286700302 in __select_nocancel () from /lib64/libc.so.6 #1 0x00000000007f5d95 in os_thread_sleep (tm=) at os/os0thread.c:281 #2 0x00000000008212f3 in srv_master_thread (arg=) at srv/srv0srv.c:2279 #3 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #4 0x00002b12867064cd in clone () from /lib64/libc.so.6 #5 0x0000000000000000 in ?? () Thread 8 (Thread 1124096320 (LWP 1128)): #0 0x00002b1286700302 in __select_nocancel () from /lib64/libc.so.6 #1 0x00000000007f5d95 in os_thread_sleep (tm=) at os/os0thread.c:281 #2 0x0000000000822fa4 in srv_error_monitor_thread (arg=) at srv/srv0srv.c:2148 #3 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #4 0x00002b12867064cd in clone () from /lib64/libc.so.6 #5 0x0000000000000000 in ?? () Thread 7 (Thread 1115703616 (LWP 1127)): #0 0x00002b1286700302 in __select_nocancel () from /lib64/libc.so.6 #1 0x00000000007f5d95 in os_thread_sleep (tm=) at os/os0thread.c:281 #2 0x000000000082238c in srv_lock_timeout_and_monitor_thread (arg=) at srv/srv0srv.c:1922 #3 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #4 0x00002b12867064cd in clone () from /lib64/libc.so.6 #5 0x0000000000000000 in ?? () Thread 6 (Thread 1107310912 (LWP 1126)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0x1419098, mp=0x1419020, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0x1419020, reset_sig_count=) at os/os0sync.c:422 #3 0x00000000007f3ddb in os_aio_simulated_handle (global_segment=3, message1=0x420030f0, message2=0x420030e8, type=0x420030e0) at os/os0file.c:4207 #4 0x00000000007c264f in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #5 0x00000000008255ca in io_handler_thread (arg=) at srv/srv0start.c:435 #6 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #7 0x00002b12867064cd in clone () from /lib64/libc.so.6 #8 0x0000000000000000 in ?? () Thread 5 (Thread 1098918208 (LWP 1125)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0x1418fb8, mp=0x1418f40, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0x1418f40, reset_sig_count=) at os/os0sync.c:422 #3 0x00000000007f3ddb in os_aio_simulated_handle (global_segment=2, message1=0x418020f0, message2=0x418020e8, type=0x418020e0) at os/os0file.c:4207 #4 0x00000000007c264f in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #5 0x00000000008255ca in io_handler_thread (arg=) at srv/srv0start.c:435 #6 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #7 0x00002b12867064cd in clone () from /lib64/libc.so.6 #8 0x0000000000000000 in ?? () Thread 4 (Thread 1090525504 (LWP 1124)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0x1418ed8, mp=0x1418e60, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0x1418e60, reset_sig_count=) at os/os0sync.c:422 #3 0x00000000007f3ddb in os_aio_simulated_handle (global_segment=1, message1=0x410010f0, message2=0x410010e8, type=0x410010e0) at os/os0file.c:4207 #4 0x00000000007c264f in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #5 0x00000000008255ca in io_handler_thread (arg=) at srv/srv0start.c:435 #6 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #7 0x00002b12867064cd in clone () from /lib64/libc.so.6 #8 0x0000000000000000 in ?? () Thread 3 (Thread 1082132800 (LWP 1123)): #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0x1418df8, mp=0x1418d80, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0x1418d80, reset_sig_count=) at os/os0sync.c:422 #3 0x00000000007f3ddb in os_aio_simulated_handle (global_segment=0, message1=0x408000f0, message2=0x408000e8, type=0x408000e0) at os/os0file.c:4207 #4 0x00000000007c264f in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #5 0x00000000008255ca in io_handler_thread (arg=) at srv/srv0start.c:435 #6 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #7 0x00002b12867064cd in clone () from /lib64/libc.so.6 #8 0x0000000000000000 in ?? () Thread 1 (Thread 47358567547344 (LWP 1121)): #0 0x00002b1286700302 in __select_nocancel () from /lib64/libc.so.6 #1 0x00000000005d1a3d in handle_connections_sockets (arg=) at mysqld.cc:5033 #2 0x00000000005d35ca in main (argc=, argv=) at mysqld.cc:4517 #0 0x00002b1286675535 in raise () from /lib64/libc.so.6 (gdb) (gdb) thread 15 [Switching to thread 15 (Thread 1133553984 (LWP 1150))]#0 0x00002b1286675535 in raise () from /lib64/libc.so.6 (gdb) bt full #0 0x00002b1286675535 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x00002b1286676990 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x0000000000816297 in row_search_for_mysql (buf=0x1fee200 "Á½\023\237Þè", mode=2, prebuilt=0x2aaaab5d78b8, match_mode=1, direction=46912507838648) at row/row0sel.c:3642 index = (dict_index_t *) 0x2aaaab5c00b8 comp = 1 search_tuple = (dtuple_t *) 0x2aaaab5d80b8 pcur = (btr_pcur_t *) 0x2aaaab5d76b8 trx = (trx_t *) 0x2aaaab5cf0b8 clust_index = (dict_index_t *) 0x2aaaab5bccb8 thr = (que_thr_t *) 0x2aaaab5ec448 rec = (rec_t *) 0x2aaab238759e "\200" result_rec = clust_rec = err = 10 unique_search = 0 unique_search_from_clust_index = 0 mtr_has_extra_clust_latch = moves_up = 1 set_also_gap_locks = 1 did_semi_consistent_read = next_offs = same_user_rec = mtr = { state = 0, memo = { heap = 0x0, used = 48, data = "7", '\0' , "\003\000\000\000\000\000\000\000ð\027H»ª*\000\000\001\000\000\000\000\000\000\000P8r»ª*\000\000\001", '\0' , "ÐO\003\002\000\000\000\000X\000\000\000\000\000\000\000 \000\000\000\000\000\000\0008Tþ\001\000\000\000\000`+þ\001\000\000\000\000à \003\000\002\000\000\000x¿\004\002\000\000\000\000P¿\004\002", '\0' , "0\000\000\000p}\220C\000\000\000\000\220|\220C\001\000\000\000\177É\213\000\001\000\000\000ð¼\004\002\000\000\000\000 ¿\004\002\000\000\000\000H\036\b\002\000\000\000\000À¤ü\001\000\000\000\000¯l \000\000\000\000\000rë\213\000\000\000\000\000"..., base = { count = 0, start = 0x2036590, end = 0x2018140 }, list = { prev = 0x0, next = 0x0 } }, log = { heap = 0x0, used = 0, data = "ÿÿÿÿÿÿÿÿ\002\000\000\000\002", '\0' , "\003\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000ð´\004\002\000\000\000\000X®\004\002\000\000\000\000\b³\004\002", '\0' , "`+þ\001\000\000\000\000hP\003\002\000\000\000\000à~\220C\000\000\000\000ð´\004\002\000\000\000\000\b\000\000\000\000\000\000\000X®\004\002\000\000\000\000\213Þ\213\000\000\000\000\000À¤ü\001\000\000\000\000à¤\003\002\000\000\000\0008Tþ\001\000\000\000\000\177É\213", '\0' , "À¤ü\001\000\000\000\000X®\004\002\000\000\000\000°°\004\002", '\0' , "à\177\220C\000\000\000\000"..., base = { count = 0, start = 0x15, end = 0x8 }, list = { prev = 0x8, next = 0x2aaaab5d80f0 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = { high = 12, low = 33865544 }, end_lsn = { high = 46912507740344, low = 110 }, magic_n = 33795600 } heap = (mem_heap_t *) 0x0 offsets_ = {100, 9161087, 33874560, 33334464, 10392810, 9169778, 206158430216, 1133541840, 1133541616, 9161087, 33854992, 0, 47358555017856, 33498688, 1133537304, 1133537300, 33874560, 0, 4294967295, 0, 33860736, 6586631, 1133541752, 47253806731, 33852272, 9161087, 33434464, 9166475, 33334464, 9169161, 1133542144, 33852272, 33854992, 33854992, 0, 33434464, 33793248, 6595024, 1133542136, 9169161, 0, 1, 1, 1, 33874560, 4329049784, 33860592, 13835058055282163713, 33434464, 33334464, 10811407, 9169778, 206158430216, 1133542208, 1133541984, 33688672, 33860736, 33866008, 47358555017856, 33498688, 1133542232, 1133542228, 33854992, 9161087, 33852520, 9161087, 33334464, 9166475, 33334464, 9169161, 1133542176, 33852520, 33689288, 9161087, 10390053, 9166475, 33334464, 9169161, 1133542744, 33689288, 33689056, 33442288, 10390053, 33434464, 33793248, 5824154, 1133542736, 10389949, 10391528, 0, 136, 0, 16, 1, 0, 0, 0, 0, 16, 1} offsets = (ulint *) 0x439078a0 #3 0x00000000007922eb in ha_innobase::index_read (this=0x1fee010, buf=0x1fee200 "Á½\023\237Þè", key_ptr=, key_len=12, find_flag=) at handler/ha_innodb.cc:4601 mode = 2 index = match_mode = 1 error = ret = 48 _db_func_ = 0x9e9378 "do_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 9 _db_framep_ = (char **) 0x2003268 #4 0x00000000006ce36a in handler::index_read_map (this=0x1fee010, buf=0x1fee200 "Á½\023\237Þè", key=0x204bf48 "w.²Ôè", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1401 key_len = 4294967295 #5 0x000000000063d1db in join_read_always_key (tab=0x204bcf0) at sql_select.cc:11836 i = 2 error = table = (TABLE *) 0x203a4e0 #6 0x000000000062fb52 in sub_select (join=0x2034fd0, join_tab=0x47e, end_of_records=6) at sql_select.cc:11238 error = rc = info = (READ_RECORD *) 0x204bd70 #7 0x000000000062ce5e in evaluate_join_record (join=0x2034fd0, join_tab=0x204ba98, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x204c5c0 #8 0x000000000062fb77 in sub_select (join=0x2034fd0, join_tab=0x204ba98, end_of_records=) at sql_select.cc:11245 error = 0 rc = info = (READ_RECORD *) 0x204bb18 #9 0x0000000000647ea3 in do_select (join=0x2034fd0, fields=0x1fe4af8, table=0x0, procedure=0x0) at sql_select.cc:10995 rc = error = join_tab = (JOIN_TAB *) 0x204ba98 _db_func_ = 0x9e93f2 "JOIN::exec" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x8000008c1 end_select = (Next_select_func) 0x631a6d __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" #10 0x000000000064a54f in JOIN::exec (this=0x2034fd0) at sql_select.cc:2246 columns_list = tmp_error = _db_func_ = 0x9e952c "mysql_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x700000008 curr_join = (JOIN *) 0x2034fd0 curr_all_fields = (List *) 0x20365b0 curr_fields_list = (List *) 0x1fe4af8 curr_tmp_table = (TABLE *) 0xc000000000000003 __PRETTY_FUNCTION__ = "void JOIN::exec()" #11 0x000000000064ac38 in mysql_select (thd=0x1fe2b60, rref_pointer_array=0x1fe4bc0, tables=0x20173e8, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x2021118, unit=0x1fe45c8, select_lex=0x1fe49f0) at sql_select.cc:2435 err = false free_join = true _db_func_ = 0x9e96ea "handle_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8bea30 join = (JOIN *) 0x2034fd0 #12 0x000000000064dce0 in handle_select (thd=0x1fe2b60, lex=0x1fe4528, result=0x2021118, setup_tables_done_option=0) at sql_select.cc:269 unit = (SELECT_LEX_UNIT *) 0x1fe45c8 res = select_lex = (SELECT_LEX *) 0x1fe49f0 _db_func_ = 0x99552a "mysql_execute_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 5 _db_framep_ = (char **) 0x99552a #13 0x00000000005d8b4e in execute_sqlcom_select (thd=0x1fe2b60, all_tables=0x20173e8) at sql_parse.cc:5051 lex = (LEX *) 0x1fe4528 result = (class select_result *) 0x2021118 res = 24 #14 0x00000000005e3228 in mysql_execute_command (thd=0x1fe2b60) at sql_parse.cc:2246 sp_result = sp = chistics = { comment = { str = 0x2018140 "0§\224", length = 10 }, suid = 5, detistic = false, daccess = 13442008 } res = 0 need_start_waiting = dwarf2_read_address: Corrupted DWARF expression. (gdb) (gdb) thread 17 [Switching to thread 17 (Thread 1134086464 (LWP 1152))]#0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 (gdb) bt full #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb0998, mp=0xfb0920, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 error = #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0920, reset_sig_count=) at os/os0sync.c:422 old_signal_count = 1 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5e1478) at srv/srv0srv.c:1497 slot = (srv_slot_t *) 0x2aaaab73d120 event = (os_event_t) 0xfb0920 wait_time = trx = (trx_t *) 0x2aaaab5d30b8 had_dict_lock = 0 was_declared_inside_innodb = 1 start_time = 1259754237670283 finish_time = diff_time = sec = 1259754237 ms = 670283 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x4398a3c8, trx=0x2aaaab5d30b8, thr=0x2aaaab5e1478, savept=0x4398a3d0) at row/row0mysql.c:496 err = 14 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x2028510 "Á½\023\237Þè", prebuilt=0x2aaaab5d0cb8) at row/row0mysql.c:1170 savept = { least_undo_no = { high = 0, low = 0 } } thr = (que_thr_t *) 0x2aaaab5e1478 err = 14 was_lock_wait = trx = (trx_t *) 0x2aaaab5d30b8 node = (ins_node_t *) 0x2aaaab5e1168 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x2028320, record=0x2028510 "Á½\023\237Þè") at handler/ha_innodb.cc:3920 error = error_result = 1134077280 auto_inc_used = 0 sql_command = 41 trx = (trx_t *) 0x2aaaab5d30b8 _db_func_ = 0xa0156b "handler::ha_write_row" _db_file_ = 0x92001d "handler.cc" _db_level_ = 13 _db_framep_ = (char **) 0x8bea30 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x2028320, buf=0x2028510 "Á½\023\237Þè") at handler.cc:4650 error = _db_func_ = 0xa4a75e "write_record" _db_file_ = 0x9eae30 "sql_insert.cc" _db_level_ = 12 _db_framep_ = (char **) 0x201fff620 #8 0x00000000006510a5 in write_record (thd=0x200b940, table=0x2027a70, info=0x2022368) at sql_insert.cc:1354 res = key_nr = is_duplicate_key_error = error = 6494829 trg_error = key = 0x0 save_read_set = (MY_BITMAP *) 0x2027b58 save_write_set = (MY_BITMAP *) 0x2027b78 prev_insert_id = 0 insert_id_for_cur_row = 0 _db_func_ = 0x9eaecc "select_insert::send_data" _db_file_ = 0x9eae30 "sql_insert.cc" _db_level_ = 11 _db_framep_ = (char **) 0x7f5473 __PRETTY_FUNCTION__ = "int write_record(THD*, TABLE*, COPY_INFO*)" #9 0x0000000000651502 in select_insert::send_data (this=0x2022328, values=@0x200d8d8) at sql_insert.cc:3153 _db_func_ = 0x9e8b25 "end_send" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 10 _db_framep_ = (char **) 0x2042f80 error = #10 0x0000000000631b1e in end_send (join=0x2042f80, join_tab=, end_of_records=false) at sql_select.cc:12142 error = _db_func_ = 0x9e9378 "do_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 9 _db_framep_ = (char **) 0x8bde8b #11 0x000000000062ce5e in evaluate_join_record (join=0x2042f80, join_tab=0x2045508, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x2021d78 #12 0x000000000062fb5f in sub_select (join=0x2042f80, join_tab=0x2045508, end_of_records=) at sql_select.cc:11239 error = -4 rc = info = (READ_RECORD *) 0x2045588 #13 0x000000000062ce5e in evaluate_join_record (join=0x2042f80, join_tab=0x20452b0, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x2022190 #14 0x000000000062fb5f in sub_select (join=0x2042f80, join_tab=0x20452b0, end_of_records=) at sql_select.cc:11239 error = -4 rc = info = (READ_RECORD *) 0x2045330 #15 0x0000000000647ea3 in do_select (join=0x2042f80, fields=0x200d8d8, table=0x0, procedure=0x0) at sql_select.cc:10995 rc = error = join_tab = (JOIN_TAB *) 0x20452b0 _db_func_ = 0x9e93f2 "JOIN::exec" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x8c1 end_select = (Next_select_func) 0x631a6d __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" #16 0x000000000064a54f in JOIN::exec (this=0x2042f80) at sql_select.cc:2246 columns_list = tmp_error = _db_func_ = 0x9e952c "mysql_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x700000008 curr_join = (JOIN *) 0x2042f80 curr_all_fields = (List *) 0x2044560 curr_fields_list = (List *) 0x200d8d8 curr_tmp_table = (TABLE *) 0xc000000000000003 __PRETTY_FUNCTION__ = "void JOIN::exec()" #17 0x000000000064ac38 in mysql_select (thd=0x200b940, rref_pointer_array=0x200d9a0, tables=0x20212f0, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x2022328, unit=0x200d3a8, select_lex=0x200d7d0) at sql_select.cc:2435 err = false free_join = true _db_func_ = 0x9e96ea "handle_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8bea30 join = (JOIN *) 0x2042f80 #18 0x000000000064dce0 in handle_select (thd=0x200b940, lex=0x200d308, result=0x2022328, setup_tables_done_option=1073741824) at sql_select.cc:269 unit = (SELECT_LEX_UNIT *) 0x200d3a8 res = select_lex = (SELECT_LEX *) 0x200d7d0 _db_func_ = 0x99552a "mysql_execute_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 5 _db_framep_ = (char **) 0x5b8d7c #19 0x00000000005df74d in mysql_execute_command (thd=0x200b940) at sql_parse.cc:3233 second_table = sel_result = (class select_result *) 0x2022328 res = 0 need_start_waiting = true up_result = lex = (LEX *) 0x200d308 select_lex = (SELECT_LEX *) 0x200d7d0 first_table = (TABLE_LIST *) 0x20333b0 all_tables = (TABLE_LIST *) 0x20333b0 unit = (SELECT_LEX_UNIT *) 0x200d3a8 have_table_map_for_update = _db_func_ = 0x99573f "mysql_parse" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x200b940 __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" #20 0x00000000005e42a3 in mysql_parse (thd=0x200b940, inBuf=0x2032fb0 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x4398bfc8) at sql_parse.cc:5970 lex = (LEX *) 0x200d308 parser_state = { m_lip = { m_thd = 0x200b940, yylineno = 1, yytoklen = 3, yylval = 0x4398b420, m_ptr = 0x203315a "Ò", m_tok_start = 0x203315a "Ò", m_tok_end = 0x203315a "Ò", m_end_of_query = 0x2033159 "", m_tok_start_prev = 0x2033159 "", m_buf = 0x2032fb0 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., m_buf_length = 425, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x20331c8 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., m_cpp_ptr = 0x2033371 "", m_cpp_tok_start = 0x2033371 "", m_cpp_tok_start_prev = 0x2033371 "", m_cpp_tok_end = 0x2033371 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x200d198 "\001", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 9169161, m_cpp_text_start = 0x203336d "NEW'", m_cpp_text_end = 0x2033370 "'", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0 } } err = _db_func_ = 0x9957b4 "dispatch_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x200ba28 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, const char*, uint, const char**)" #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x200b940, packet=, packet_length=425) at sql_parse.cc:1231 packet_end = 0x2033159 "" end_of_stmt = 0x0 net = (NET *) 0x200ba28 error = _db_func_ = 0x99584c "do_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x4398bfe0 #22 0x00000000005e6366 in do_command (thd=0x200b940) at sql_parse.cc:872 return_value = packet = 0x200e260 "\003replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b."... packet_length = 426 net = (NET *) 0x200ba28 command = COM_QUERY _db_func_ = 0xa581f4 "?func" _db_file_ = 0xa581fa "?file" _db_level_ = 1 _db_framep_ = (char **) 0x200cda8 __PRETTY_FUNCTION__ = "bool do_command(THD*)" #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 thd = (class THD *) 0x200b940 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 No symbol table info available. #26 0x0000000000000000 in ?? () No symbol table info available. (gdb) (gdb) thread 14 [Switching to thread 14 (Thread 1133287744 (LWP 1149))]#0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 (gdb) bt full #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb08b8, mp=0xfb0840, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 error = #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0840, reset_sig_count=) at os/os0sync.c:422 old_signal_count = 2 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5dc478) at srv/srv0srv.c:1497 slot = (srv_slot_t *) 0x2aaaab73d0e0 event = (os_event_t) 0xfb0840 wait_time = trx = (trx_t *) 0x2aaaab5f38b8 had_dict_lock = 0 was_declared_inside_innodb = 1 start_time = 1259754237202207 finish_time = diff_time = sec = 1259754237 ms = 202207 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x438c73c8, trx=0x2aaaab5f38b8, thr=0x2aaaab5dc478, savept=0x438c73d0) at row/row0mysql.c:496 err = 14 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x203bed0 "Á½\023\237Þè", prebuilt=0x2aaaab5d3cb8) at row/row0mysql.c:1170 savept = { least_undo_no = { high = 0, low = 0 } } thr = (que_thr_t *) 0x2aaaab5dc478 err = 14 was_lock_wait = trx = (trx_t *) 0x2aaaab5f38b8 node = (ins_node_t *) 0x2aaaab5dc168 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x203bce0, record=0x203bed0 "Á½\023\237Þè") at handler/ha_innodb.cc:3920 error = error_result = 1133278560 auto_inc_used = 0 sql_command = 41 trx = (trx_t *) 0x2aaaab5f38b8 _db_func_ = 0xa0156b "handler::ha_write_row" _db_file_ = 0x92001d "handler.cc" _db_level_ = 13 _db_framep_ = (char **) 0x8bea30 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x203bce0, buf=0x203bed0 "Á½\023\237Þè") at handler.cc:4650 error = _db_func_ = 0xa4a75e "write_record" _db_file_ = 0x9eae30 "sql_insert.cc" _db_level_ = 12 _db_framep_ = (char **) 0x201fc5c10 #8 0x00000000006510a5 in write_record (thd=0x1fdc230, table=0x203b430, info=0x2038038) at sql_insert.cc:1354 res = key_nr = is_duplicate_key_error = error = 6494829 trg_error = key = 0x0 save_read_set = (MY_BITMAP *) 0x203b518 save_write_set = (MY_BITMAP *) 0x203b538 prev_insert_id = 0 insert_id_for_cur_row = 0 _db_func_ = 0x9eaecc "select_insert::send_data" _db_file_ = 0x9eae30 "sql_insert.cc" _db_level_ = 11 _db_framep_ = (char **) 0x7f5473 __PRETTY_FUNCTION__ = "int write_record(THD*, TABLE*, COPY_INFO*)" #9 0x0000000000651502 in select_insert::send_data (this=0x2037ff8, values=@0x1fde1c8) at sql_insert.cc:3153 _db_func_ = 0x9e8b25 "end_send" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 10 _db_framep_ = (char **) 0x203df20 error = #10 0x0000000000631b1e in end_send (join=0x203df20, join_tab=, end_of_records=false) at sql_select.cc:12142 error = _db_func_ = 0x9e9378 "do_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 9 _db_framep_ = (char **) 0x8bde8b #11 0x000000000062ce5e in evaluate_join_record (join=0x203df20, join_tab=0x2040168, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x2037a48 #12 0x000000000062fb5f in sub_select (join=0x203df20, join_tab=0x2040168, end_of_records=) at sql_select.cc:11239 error = -4 rc = info = (READ_RECORD *) 0x20401e8 #13 0x000000000062ce5e in evaluate_join_record (join=0x203df20, join_tab=0x203ff10, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x2037e60 #14 0x000000000062fb5f in sub_select (join=0x203df20, join_tab=0x203ff10, end_of_records=) at sql_select.cc:11239 error = -4 rc = info = (READ_RECORD *) 0x203ff90 #15 0x0000000000647ea3 in do_select (join=0x203df20, fields=0x1fde1c8, table=0x0, procedure=0x0) at sql_select.cc:10995 rc = error = join_tab = (JOIN_TAB *) 0x203ff10 _db_func_ = 0x9e93f2 "JOIN::exec" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x8c1 end_select = (Next_select_func) 0x631a6d __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" #16 0x000000000064a54f in JOIN::exec (this=0x203df20) at sql_select.cc:2246 columns_list = tmp_error = _db_func_ = 0x9e952c "mysql_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x700000008 curr_join = (JOIN *) 0x203df20 curr_all_fields = (List *) 0x203f500 curr_fields_list = (List *) 0x1fde1c8 curr_tmp_table = (TABLE *) 0xc000000000000003 __PRETTY_FUNCTION__ = "void JOIN::exec()" #17 0x000000000064ac38 in mysql_select (thd=0x1fdc230, rref_pointer_array=0x1fde290, tables=0x2036fc0, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x2037ff8, unit=0x1fddc98, select_lex=0x1fde0c0) at sql_select.cc:2435 err = false free_join = true _db_func_ = 0x9e96ea "handle_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8bea30 join = (JOIN *) 0x203df20 #18 0x000000000064dce0 in handle_select (thd=0x1fdc230, lex=0x1fddbf8, result=0x2037ff8, setup_tables_done_option=1073741824) at sql_select.cc:269 unit = (SELECT_LEX_UNIT *) 0x1fddc98 res = select_lex = (SELECT_LEX *) 0x1fde0c0 _db_func_ = 0x99552a "mysql_execute_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 5 _db_framep_ = (char **) 0x5b8d7c #19 0x00000000005df74d in mysql_execute_command (thd=0x1fdc230) at sql_parse.cc:3233 second_table = sel_result = (class select_result *) 0x2037ff8 res = 0 need_start_waiting = true up_result = lex = (LEX *) 0x1fddbf8 select_lex = (SELECT_LEX *) 0x1fde0c0 first_table = (TABLE_LIST *) 0x1ff6b70 all_tables = (TABLE_LIST *) 0x1ff6b70 unit = (SELECT_LEX_UNIT *) 0x1fddc98 have_table_map_for_update = _db_func_ = 0x99573f "mysql_parse" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x1fdc230 __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" #20 0x00000000005e42a3 in mysql_parse (thd=0x1fdc230, inBuf=0x1ff6770 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x438c8fc8) at sql_parse.cc:5970 lex = (LEX *) 0x1fddbf8 parser_state = { m_lip = { m_thd = 0x1fdc230, yylineno = 1, yytoklen = 3, yylval = 0x438c8420, m_ptr = 0x1ff691a "", m_tok_start = 0x1ff691a "", m_tok_end = 0x1ff691a "", m_end_of_query = 0x1ff6919 "", m_tok_start_prev = 0x1ff6919 "", m_buf = 0x1ff6770 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., m_buf_length = 425, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x1ff6988 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., m_cpp_ptr = 0x1ff6b31 "", m_cpp_tok_start = 0x1ff6b31 "", m_cpp_tok_start_prev = 0x1ff6b31 "", m_cpp_tok_end = 0x1ff6b31 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x1fdda88 "\001", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 9169161, m_cpp_text_start = 0x1ff6b2d "NEW'", m_cpp_text_end = 0x1ff6b30 "'", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0 } } err = _db_func_ = 0x9957b4 "dispatch_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x1fdc318 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, const char*, uint, const char**)" #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1fdc230, packet=, packet_length=425) at sql_parse.cc:1231 packet_end = 0x1ff6919 "" end_of_stmt = 0x0 net = (NET *) 0x1fdc318 error = _db_func_ = 0x99584c "do_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x438c8fe0 #22 0x00000000005e6366 in do_command (thd=0x1fdc230) at sql_parse.cc:872 return_value = packet = 0x1fdeb50 "\003replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b."... packet_length = 426 net = (NET *) 0x1fdc318 command = COM_QUERY _db_func_ = 0xa581f4 "?func" _db_file_ = 0xa581fa "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1fdd698 __PRETTY_FUNCTION__ = "bool do_command(THD*)" #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 thd = (class THD *) 0x1fdc230 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 No symbol table info available. #26 0x0000000000000000 in ?? () No symbol table info available. (gdb) (gdb) thread 13 [Switching to thread 13 (Thread 1133021504 (LWP 1148))]#0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 (gdb) bt full #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb0a78, mp=0xfb0a00, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 error = #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0a00, reset_sig_count=) at os/os0sync.c:422 old_signal_count = 1 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5e0478) at srv/srv0srv.c:1497 slot = (srv_slot_t *) 0x2aaaab73d160 event = (os_event_t) 0xfb0a00 wait_time = trx = (trx_t *) 0x2aaaab5c50b8 had_dict_lock = 0 was_declared_inside_innodb = 1 start_time = 1259754238355962 finish_time = diff_time = sec = 1259754238 ms = 355962 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x438863c8, trx=0x2aaaab5c50b8, thr=0x2aaaab5e0478, savept=0x438863d0) at row/row0mysql.c:496 err = 14 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x203d450 "ÁVU¢Þè", prebuilt=0x2aaaab5d44b8) at row/row0mysql.c:1170 savept = { least_undo_no = { high = 0, low = 36950 } } thr = (que_thr_t *) 0x2aaaab5e0478 err = 14 was_lock_wait = trx = (trx_t *) 0x2aaaab5c50b8 node = (ins_node_t *) 0x2aaaab5e0168 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x203d260, record=0x203d450 "ÁVU¢Þè") at handler/ha_innodb.cc:3920 error = error_result = 1133012320 auto_inc_used = 0 sql_command = 41 trx = (trx_t *) 0x2aaaab5c50b8 _db_func_ = 0xa0156b "handler::ha_write_row" _db_file_ = 0x92001d "handler.cc" _db_level_ = 13 _db_framep_ = (char **) 0x8bea30 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x203d260, buf=0x203d450 "ÁVU¢Þè") at handler.cc:4650 error = _db_func_ = 0xa4a75e "write_record" _db_file_ = 0x9eae30 "sql_insert.cc" _db_level_ = 12 _db_framep_ = (char **) 0x201fcfc50 #8 0x00000000006510a5 in write_record (thd=0x1fc72f0, table=0x203c990, info=0x2006a08) at sql_insert.cc:1354 res = key_nr = is_duplicate_key_error = error = 6494829 trg_error = key = 0x0 save_read_set = (MY_BITMAP *) 0x203ca78 save_write_set = (MY_BITMAP *) 0x203ca98 prev_insert_id = 0 insert_id_for_cur_row = 0 _db_func_ = 0x9eaecc "select_insert::send_data" _db_file_ = 0x9eae30 "sql_insert.cc" _db_level_ = 11 _db_framep_ = (char **) 0x7f5473 __PRETTY_FUNCTION__ = "int write_record(THD*, TABLE*, COPY_INFO*)" #9 0x0000000000651502 in select_insert::send_data (this=0x20069c8, values=@0x1fc9288) at sql_insert.cc:3153 _db_func_ = 0x9e8b25 "end_send" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 10 _db_framep_ = (char **) 0x1ff98d0 error = #10 0x0000000000631b1e in end_send (join=0x1ff98d0, join_tab=, end_of_records=false) at sql_select.cc:12142 error = _db_func_ = 0x9e9378 "do_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 9 _db_framep_ = (char **) 0x8bde8b #11 0x000000000062ce5e in evaluate_join_record (join=0x1ff98d0, join_tab=0x1ffbe58, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x2006418 #12 0x000000000062fb5f in sub_select (join=0x1ff98d0, join_tab=0x1ffbe58, end_of_records=) at sql_select.cc:11239 error = 0 rc = info = (READ_RECORD *) 0x1ffbed8 #13 0x000000000062ce5e in evaluate_join_record (join=0x1ff98d0, join_tab=0x1ffbc00, error=) at sql_select.cc:11365 rc = found = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x2006830 #14 0x000000000062fb77 in sub_select (join=0x1ff98d0, join_tab=0x1ffbc00, end_of_records=) at sql_select.cc:11245 error = 0 rc = info = (READ_RECORD *) 0x1ffbc80 #15 0x0000000000647ea3 in do_select (join=0x1ff98d0, fields=0x1fc9288, table=0x0, procedure=0x0) at sql_select.cc:10995 rc = error = join_tab = (JOIN_TAB *) 0x1ffbc00 _db_func_ = 0x9e93f2 "JOIN::exec" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 8 _db_framep_ = (char **) 0x8c1 end_select = (Next_select_func) 0x631a6d __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" #16 0x000000000064a54f in JOIN::exec (this=0x1ff98d0) at sql_select.cc:2246 columns_list = tmp_error = _db_func_ = 0x9e952c "mysql_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x700000008 curr_join = (JOIN *) 0x1ff98d0 curr_all_fields = (List *) 0x1ffaeb0 curr_fields_list = (List *) 0x1fc9288 curr_tmp_table = (TABLE *) 0xc000000000000003 __PRETTY_FUNCTION__ = "void JOIN::exec()" #17 0x000000000064ac38 in mysql_select (thd=0x1fc72f0, rref_pointer_array=0x1fc9350, tables=0x2005990, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x20069c8, unit=0x1fc8d58, select_lex=0x1fc9180) at sql_select.cc:2435 err = false free_join = true _db_func_ = 0x9e96ea "handle_select" _db_file_ = 0x9e89bd "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8bea30 join = (JOIN *) 0x1ff98d0 #18 0x000000000064dce0 in handle_select (thd=0x1fc72f0, lex=0x1fc8cb8, result=0x20069c8, setup_tables_done_option=1073741824) at sql_select.cc:269 unit = (SELECT_LEX_UNIT *) 0x1fc8d58 res = select_lex = (SELECT_LEX *) 0x1fc9180 _db_func_ = 0x99552a "mysql_execute_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 5 _db_framep_ = (char **) 0x5b8d7c #19 0x00000000005df74d in mysql_execute_command (thd=0x1fc72f0) at sql_parse.cc:3233 second_table = sel_result = (class select_result *) 0x20069c8 res = 0 need_start_waiting = true up_result = lex = (LEX *) 0x1fc8cb8 select_lex = (SELECT_LEX *) 0x1fc9180 first_table = (TABLE_LIST *) 0x1fcad20 all_tables = (TABLE_LIST *) 0x1fcad20 unit = (SELECT_LEX_UNIT *) 0x1fc8d58 have_table_map_for_update = _db_func_ = 0x99573f "mysql_parse" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x1fc72f0 __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" #20 0x00000000005e42a3 in mysql_parse (thd=0x1fc72f0, inBuf=0x1fca920 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x43887fc8) at sql_parse.cc:5970 lex = (LEX *) 0x1fc8cb8 parser_state = { m_lip = { m_thd = 0x1fc72f0, yylineno = 1, yytoklen = 3, yylval = 0x43887420, m_ptr = 0x1fcaaca "ND INSTRUMENT.SYMBOL IN ('CKOXG', 'CBIAE', 'DISAF', 'DVNDO', 'UNYWL', 'IBMKF', àÿÒ", m_tok_start = 0x1fcaaca "ND INSTRUMENT.SYMBOL IN ('CKOXG', 'CBIAE', 'DISAF', 'DVNDO', 'UNYWL', 'IBMKF', àÿÒ", m_tok_end = 0x1fcaaca "ND INSTRUMENT.SYMBOL IN ('CKOXG', 'CBIAE', 'DISAF', 'DVNDO', 'UNYWL', 'IBMKF', àÿÒ", m_end_of_query = 0x1fcaac9 "", m_tok_start_prev = 0x1fcaac9 "", m_buf = 0x1fca920 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., m_buf_length = 425, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x1fcab38 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., m_cpp_ptr = 0x1fcace1 "", m_cpp_tok_start = 0x1fcace1 "", m_cpp_tok_start_prev = 0x1fcace1 "", m_cpp_tok_end = 0x1fcace1 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x1fc8b48 "\001", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 9169161, m_cpp_text_start = 0x1fcacdd "NEW'", m_cpp_text_end = 0x1fcace0 "'", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0 } } err = _db_func_ = 0x9957b4 "dispatch_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x1fc73d8 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, const char*, uint, const char**)" #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1fc72f0, packet=, packet_length=425) at sql_parse.cc:1231 packet_end = 0x1fcaac9 "" end_of_stmt = 0x0 net = (NET *) 0x1fc73d8 error = _db_func_ = 0x99584c "do_command" _db_file_ = 0x995178 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x43887fe0 #22 0x00000000005e6366 in do_command (thd=0x1fc72f0) at sql_parse.cc:872 return_value = packet = 0x1fd4210 "\003replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b."... packet_length = 426 net = (NET *) 0x1fc73d8 command = COM_QUERY _db_func_ = 0xa581f4 "?func" _db_file_ = 0xa581fa "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1fc8758 __PRETTY_FUNCTION__ = "bool do_command(THD*)" #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 thd = (class THD *) 0x1fc72f0 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 No symbol table info available. #26 0x0000000000000000 in ?? () No symbol table info available. (gdb) (gdb) thread 17 [Switching to thread 17 (Thread 1134086464 (LWP 1152))]#0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 (gdb) bt #0 0x00002b1285b89746 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008bc489 in safe_cond_wait (cond=0xfb0998, mp=0xfb0920, file=0xa36851 "os/os0sync.c", line=422) at thr_mutex.c:237 #2 0x00000000007f5a90 in os_event_wait_low (event=0xfb0920, reset_sig_count=) at os/os0sync.c:422 #3 0x0000000000823381 in srv_suspend_mysql_thread (thr=0x2aaaab5e1478) at srv/srv0srv.c:1497 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x4398a3c8, trx=0x2aaaab5d30b8, thr=0x2aaaab5e1478, savept=0x4398a3d0) at row/row0mysql.c:496 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x2028510 "Á½\023\237Þè", prebuilt=0x2aaaab5d0cb8) at row/row0mysql.c:1170 #6 0x0000000000791d95 in ha_innobase::write_row (this=0x2028320, record=0x2028510 "Á½\023\237Þè") at handler/ha_innodb.cc:3920 #7 0x00000000006cc9b5 in handler::ha_write_row (this=0x2028320, buf=0x2028510 "Á½\023\237Þè") at handler.cc:4650 #8 0x00000000006510a5 in write_record (thd=0x200b940, table=0x2027a70, info=0x2022368) at sql_insert.cc:1354 #9 0x0000000000651502 in select_insert::send_data (this=0x2022328, values=@0x200d8d8) at sql_insert.cc:3153 #10 0x0000000000631b1e in end_send (join=0x2042f80, join_tab=, end_of_records=false) at sql_select.cc:12142 #11 0x000000000062ce5e in evaluate_join_record (join=0x2042f80, join_tab=0x2045508, error=) at sql_select.cc:11365 #12 0x000000000062fb5f in sub_select (join=0x2042f80, join_tab=0x2045508, end_of_records=) at sql_select.cc:11239 #13 0x000000000062ce5e in evaluate_join_record (join=0x2042f80, join_tab=0x20452b0, error=) at sql_select.cc:11365 #14 0x000000000062fb5f in sub_select (join=0x2042f80, join_tab=0x20452b0, end_of_records=) at sql_select.cc:11239 #15 0x0000000000647ea3 in do_select (join=0x2042f80, fields=0x200d8d8, table=0x0, procedure=0x0) at sql_select.cc:10995 #16 0x000000000064a54f in JOIN::exec (this=0x2042f80) at sql_select.cc:2246 #17 0x000000000064ac38 in mysql_select (thd=0x200b940, rref_pointer_array=0x200d9a0, tables=0x20212f0, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489942016, result=0x2022328, unit=0x200d3a8, select_lex=0x200d7d0) at sql_select.cc:2435 #18 0x000000000064dce0 in handle_select (thd=0x200b940, lex=0x200d308, result=0x2022328, setup_tables_done_option=1073741824) at sql_select.cc:269 #19 0x00000000005df74d in mysql_execute_command (thd=0x200b940) at sql_parse.cc:3233 #20 0x00000000005e42a3 in mysql_parse (thd=0x200b940, inBuf=0x2032fb0 "replace into tbl_s ( pricing_id, instrument_id, business_day, close_price, last_traded_price, bid_price, ask_price )select b.pricing_id, i.instrument_id, cast( b.business_day as char ), ifnull( b.c"..., length=425, found_semicolon=0x4398bfc8) at sql_parse.cc:5970 #21 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x200b940, packet=, packet_length=425) at sql_parse.cc:1231 #22 0x00000000005e6366 in do_command (thd=0x200b940) at sql_parse.cc:872 #23 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #24 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #25 0x00002b12867064cd in clone () from /lib64/libc.so.6 #26 0x0000000000000000 in ?? () (gdb) frame 4 #4 0x000000000080b25d in row_mysql_handle_errors (new_err=0x4398a3c8, trx=0x2aaaab5d30b8, thr=0x2aaaab5e1478, savept=0x4398a3d0) at row/row0mysql.c:496 496 srv_suspend_mysql_thread(thr); Current language: auto; currently c (gdb) print trx $1 = (trx_t *) 0x2aaaab5d30b8 (gdb) print *trx $2 = { magic_n = 91118598, op_info = 0xa385a8 "inserting", is_purge = 0, conc_state = 2, start_time = 1259754237, isolation_level = 3, check_foreigns = 1, check_unique_secondary = 1, id = { high = 0, low = 899 }, xid = { formatID = -1, gtrid_length = 0, bqual_length = 0, data = '\0' }, support_xa = 1, no = { high = 4294967295, low = 4294967295 }, flush_log_later = 0, must_flush_log_later = 0, commit_lsn = { high = 7607154505249456128, low = 358824305391988 }, dict_operation = 0, table_id = { high = 0, low = 0 }, duplicates = 3, active_trans = 1, mysql_thd = 0x200b940, mysql_query_str = 0x0, mysql_log_file_name = 0xd3aa98 "./box2-bin.000001", mysql_log_offset = 58142617, mysql_thread_id = 1134086464, mysql_process_no = 1121, n_mysql_tables_in_use = 3, mysql_n_tables_locked = 3, dict_operation_lock_mode = 0, has_search_latch = 0, search_latch_timeout = 10000, declared_to_be_inside_innodb = 0, n_tickets_to_enter_innodb = 0, auto_inc_lock = 0x0, trx_list = { prev = 0x2aaaab5cf0b8, next = 0x2aaaab5f38b8 }, mysql_trx_list = { prev = 0x2aaaab5d88b8, next = 0x2aaaab5cf0b8 }, error_state = 10, error_info = 0x0, sess = 0x2aaaab5af6b8, que_state = 2, graph = 0x0, n_active_thrs = 0, handling_signals = 0, graph_before_signal_handling = 0x0, sig = { type = 0, sender = 0, receiver = 0x0, savept = { least_undo_no = { high = 46912507817360, low = 46912507818736 } }, signals = { prev = 0x0, next = 0x10000ea }, reply_signals = { prev = 0x300030030990026, next = 0x8320088001800000 } }, signals = { count = 0, start = 0x0, end = 0x0 }, reply_signals = { count = 0, start = 0x0, end = 0x0 }, wait_lock = 0x2aaaab5f8630, was_chosen_as_deadlock_victim = 0, wait_started = 1259754237, wait_thrs = { count = 1, start = 0x2aaaab5e1478, end = 0x2aaaab5e1478 }, deadlock_mark = 0, lock_heap = 0x2aaaab5d2448, trx_locks = { count = 7, start = 0x2aaaab5d24b8, end = 0x2aaaab5f8630 }, global_read_view_heap = 0x2aaaab5d2648, global_read_view = 0x0, read_view = 0x0, trx_savepoints = { count = 0, start = 0x0, end = 0x0 }, undo_mutex = { event = 0x203af30, lock_word = 0, os_fast_mutex = { global = { __m_reserved = 0, __m_count = 0, __m_owner = 0x0, __m_kind = 2, __m_lock = { __status = 0, __spinlock = 0 } }, mutex = { __m_reserved = 0, __m_count = 0, __m_owner = 0x0, __m_kind = 3, __m_lock = { __status = 0, __spinlock = 0 } }, file = 0xa36851 "os/os0sync.c", line = 665, count = 0, thread = 0 }, waiters = 0, list = { prev = 0x2aaaab5d8bc8, next = 0x2aaaab5cf3c8 }, cfile_name = 0xa4003b "trx/trx0trx.c", cline = 143, count_os_wait = 0 }, undo_no = { high = 0, low = 0 }, last_sql_stat_start = { least_undo_no = { high = 0, low = 0 } }, rseg = 0x2aaaab5aa2b8, insert_undo = 0x0, update_undo = 0x0, roll_limit = { high = 0, low = 0 }, pages_undone = 0, undo_no_arr = 0x0, n_autoinc_rows = 0, detailed_error = '\0' , "¸0]«ª*\000\000(5]«ª*\000\000\000\000\000\000\000\000\000\000Þ\000\000\001\000\000\000\000&\000\2310\000\003\000\003\000\000\200\001\200\b!\024\026RX\001\200\000\000èÔÚî¨&\000\2310\000\003\000\003\000\000\200\001\200\b!)\026SX\001\200\000\000èÔÚî­&\000\2310\000\003\000\003\000\000\200\001\200\b!>\030MIX\001\200\000\000èÔÚî³&\000\2310\000\003\000\003\000\000\200\001\200\b!S\026PX\001\200\000\000èÔÚî¸&\000\2310\000\003\000\003\000\000\200\001\200\b!h\026SX\001\200\000\000èÔÚî¾&\000\2310\000\003\000\003\000\000\200" } (gdb) (gdb) frame 5 #5 0x000000000080bc9d in row_insert_for_mysql (mysql_rec=0x2028510 "Á½\023\237Þè", prebuilt=0x2aaaab5d0cb8) at row/row0mysql.c:1170 1170 was_lock_wait = row_mysql_handle_errors(&err, trx, thr, (gdb) print *prebuilt $3 = { magic_n = 78540783, table = 0x2aaaab5bdcb8, trx = 0x2aaaab5d30b8, sql_stat_start = 0, mysql_has_locked = 1, clust_index_was_generated = 0, index = 0x2aaaab5c00b8, read_just_key = 0, used_in_HANDLER = 0, template_type = 0, n_template = 7, null_bitmap_len = 1, need_to_access_clustered = 1, templ_contains_blob = 0, mysql_template = 0x2aaaab5df4b8, heap = 0x2aaaab5d0848, ins_node = 0x2aaaab5e1168, ins_upd_rec_buff = 0x2aaaab5e1228 "", default_rec = 0x2002bf0 "ÿ", hint_need_to_fetch_extra_cols = 0, upd_node = 0x0, ins_graph = 0x2aaaab5e1380, upd_graph = 0x0, pcur = 0x2aaaab5d0ab8, clust_pcur = 0x2aaaab5d10b8, sel_graph = 0x2aaaab5d1c10, search_tuple = 0x2aaaab5d18b8, row_id = "\000\000\000\000\000", clust_ref = 0x2aaaab5d1ad0, select_lock_type = 5, stored_select_lock_type = 5, row_read_type = 0, new_rec_locks = 0, mysql_prefix_len = 48, mysql_row_len = 48, n_rows_fetched = 0, fetch_direction = 844437818218752, fetch_cache = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, keep_other_fields_on_keyread = 0, fetch_cache_first = 0, n_fetch_cached = 0, blob_heap = 0x0, old_vers_heap = 0x0, autoinc_last_value = 0, autoinc_increment = 1, autoinc_offset = 0, autoinc_error = 0, magic_n2 = 78540783 } (gdb) (gdb) thread 15 [Switching to thread 15 (Thread 1133553984 (LWP 1150))]#0 0x00002b1286675535 in raise () from /lib64/libc.so.6 (gdb) bt #0 0x00002b1286675535 in raise () from /lib64/libc.so.6 #1 0x00002b1286676990 in abort () from /lib64/libc.so.6 #2 0x0000000000816297 in row_search_for_mysql (buf=0x1fee200 "Á½\023\237Þè", mode=2, prebuilt=0x2aaaab5d78b8, match_mode=1, direction=46912507838648) at row/row0sel.c:3642 #3 0x00000000007922eb in ha_innobase::index_read (this=0x1fee010, buf=0x1fee200 "Á½\023\237Þè", key_ptr=, key_len=12, find_flag=) at handler/ha_innodb.cc:4601 #4 0x00000000006ce36a in handler::index_read_map (this=0x1fee010, buf=0x1fee200 "Á½\023\237Þè", key=0x204bf48 "w.²Ôè", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1401 #5 0x000000000063d1db in join_read_always_key (tab=0x204bcf0) at sql_select.cc:11836 #6 0x000000000062fb52 in sub_select (join=0x2034fd0, join_tab=0x47e, end_of_records=6) at sql_select.cc:11238 #7 0x000000000062ce5e in evaluate_join_record (join=0x2034fd0, join_tab=0x204ba98, error=) at sql_select.cc:11365 #8 0x000000000062fb77 in sub_select (join=0x2034fd0, join_tab=0x204ba98, end_of_records=) at sql_select.cc:11245 #9 0x0000000000647ea3 in do_select (join=0x2034fd0, fields=0x1fe4af8, table=0x0, procedure=0x0) at sql_select.cc:10995 #10 0x000000000064a54f in JOIN::exec (this=0x2034fd0) at sql_select.cc:2246 #11 0x000000000064ac38 in mysql_select (thd=0x1fe2b60, rref_pointer_array=0x1fe4bc0, tables=0x20173e8, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x2021118, unit=0x1fe45c8, select_lex=0x1fe49f0) at sql_select.cc:2435 #12 0x000000000064dce0 in handle_select (thd=0x1fe2b60, lex=0x1fe4528, result=0x2021118, setup_tables_done_option=0) at sql_select.cc:269 #13 0x00000000005d8b4e in execute_sqlcom_select (thd=0x1fe2b60, all_tables=0x20173e8) at sql_parse.cc:5051 #14 0x00000000005e3228 in mysql_execute_command (thd=0x1fe2b60) at sql_parse.cc:2246 #15 0x00000000005e42a3 in mysql_parse (thd=0x1fe2b60, inBuf=0x2016290 "SELECT INSTRUMENT.SYMBOL as symbol, INSTRUMENT.INSTRUMENT_TYPE AS instrumentType, PRICING.CLOSE_PRICE AS closePrice, PRICING.LAST_TRADED_PRICE AS tradePrice, PRICING.BID_PRICE AS bidPr"..., length=1211, found_semicolon=0x43909fc8) at sql_parse.cc:5970 #16 0x00000000005e5408 in dispatch_command (command=COM_QUERY, thd=0x1fe2b60, packet=, packet_length=1212) at sql_parse.cc:1231 #17 0x00000000005e6366 in do_command (thd=0x1fe2b60) at sql_parse.cc:872 #18 0x00000000005d6cc1 in handle_one_connection (arg=) at sql_connect.cc:1127 #19 0x00002b1285b8509e in start_thread () from /lib64/libpthread.so.0 #20 0x00002b12867064cd in clone () from /lib64/libc.so.6 #21 0x0000000000000000 in ?? () (gdb) frame 2 #2 0x0000000000816297 in row_search_for_mysql (buf=0x1fee200 "Á½\023\237Þè", mode=2, prebuilt=0x2aaaab5d78b8, match_mode=1, direction=46912507838648) at row/row0sel.c:3642 3642 ut_a(0); Current language: auto; currently c (gdb) print *prebuilt $4 = { magic_n = 78540783, table = 0x2aaaab5bdcb8, trx = 0x2aaaab5cf0b8, sql_stat_start = 0, mysql_has_locked = 1, clust_index_was_generated = 0, index = 0x2aaaab5c00b8, read_just_key = 0, used_in_HANDLER = 0, template_type = 1, n_template = 6, null_bitmap_len = 1, need_to_access_clustered = 1, templ_contains_blob = 0, mysql_template = 0x2aaaab5eacb8, heap = 0x2aaaab5d7448, ins_node = 0x2aaaab5d8320, ins_upd_rec_buff = 0x2aaaab5d83e0 "", default_rec = 0x2002bf0 "ÿ", hint_need_to_fetch_extra_cols = 0, upd_node = 0x0, ins_graph = 0x2aaaab5ec0b8, upd_graph = 0x0, pcur = 0x2aaaab5d76b8, clust_pcur = 0x2aaaab5d7cb8, sel_graph = 0x2aaaab5ec350, search_tuple = 0x2aaaab5d80b8, row_id = "\230y]«ª*", clust_ref = 0x2aaaab5d82d0, select_lock_type = 0, stored_select_lock_type = 0, row_read_type = 0, new_rec_locks = 0, mysql_prefix_len = 48, mysql_row_len = 48, n_rows_fetched = 0, fetch_direction = 612491198589829888, fetch_cache = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, keep_other_fields_on_keyread = 0, fetch_cache_first = 0, n_fetch_cached = 0, blob_heap = 0x0, old_vers_heap = 0x0, autoinc_last_value = 0, autoinc_increment = 1, autoinc_offset = 0, autoinc_error = 0, magic_n2 = 78540783 } (gdb)