Thread 28 (Thread 0x7f7790669700 (LWP 7059)): #0 0x000000391a8e106d in fdatasync () from /lib64/libc.so.6 No symbol table info available. #1 0x0000000000a6255c in my_sync (fd=38, my_flags=16) at my_sync.c:64 res = 0 _db_func_ = 0xc25968 "sql_create_definition_file" _db_file_ = 0xc2590e "parse_file.cc" _db_level_ = 8 _db_framep_ = 0x800a50b1f #2 0x0000000000860fc8 in sql_create_definition_file (dir=0x7f7790667340, file_name=0x7f7790667330, type=0xfa0650, base=0x7f774c004c08 "", parameters=0xfa04e0) at parse_file.cc:273 handler = 38 _db_func_ = 0xc1d395 "mysql_register_view" _db_file_ = 0xc1d1df "sql_view.cc" _db_level_ = 7 _db_framep_ = 0x8 dbug_violation_helper = {_entered = true} file = {pos_in_file = 0, end_of_file = 16567, read_pos = 0x0, read_end = 0x7f774c0e37a0 "", buffer = 0x0, request_pos = 0x7f774c0e37a0 "", write_buffer = 0x7f774c0e57a0 "null` AS `col_text_latin1_unique_default_null`,`rqg1`.`table100_innodb_dynamic`.`col_blob_unique_default_null` AS `col_blob_unique_default_null` from `rqg1`.`table100_innodb_dynamic`\n_name=latin1\nconn"..., append_read_pos = 0x7f774c0e57a0 "null` AS `col_text_latin1_unique_default_null`,`rqg1`.`table100_innodb_dynamic`.`col_blob_unique_default_null` AS `col_blob_unique_default_null` from `rqg1`.`table100_innodb_dynamic`\n_name=latin1\nconn"..., write_pos = 0x7f774c0e57a0 "null` AS `col_text_latin1_unique_default_null`,`rqg1`.`table100_innodb_dynamic`.`col_blob_unique_default_null` AS `col_blob_unique_default_null` from `rqg1`.`table100_innodb_dynamic`\n_name=latin1\nconn"..., write_end = 0x7f774c0e76e9 "table100_innodb_dynamic`.`col_int` AS `col_int`,`rqg1`.`table100_innodb_dynamic`.`col_int_unique` AS `col_int_unique`,`rqg1`.`table100_innodb_dynamic`.`col_text_latin1_unique_default_", current_pos = 0x7f7790664a80, current_end = 0x7f7790664a88, append_buffer_lock = {global = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = -1, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' "\377, \377\377\377", '\000' , __align = 0}, mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = -1, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' "\377, \377\377\377", '\000' , __align = 0}, file = 0x0, line = 1727, count = 0, thread = 0}, share = 0x0, read_function = 0xa502e5 <_my_b_seq_read>, write_function = 0, type = TYPE_NOT_SET, pre_read = 0, post_read = 0, pre_close = 0, disk_writes = 3, arg = 0x0, file_name = 0xc1d395 "mysql_register_view", dir = 0x7f774c0e17a0 "select `rqg1`.`table100_innodb_dynamic`.`col_char_latin1_unique_default_null` AS `col_char_latin1_unique_default_null`,`rqg1`.`table100_innodb_dynamic`.`col_blob` AS `col_blob`,`rqg1`.`table100_innodb"..., prefix = 0x1fbe
, file = 38, seek_not_done = 0, error = 0, buffer_length = 8192, read_length = 8192, myflags = 16, alloced_buffer = 0 '\000'} param = 0xfa0630 path = "./rqg1/i.frm~\000\000\000\064Gf\220w\177\000\000\360\243\247\000\000\000\000\000} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 n = 256 i = 256 now = 1389305293 #4 0x00000000009c8481 in fil_aio_wait (segment=5) at fil/fil0fil.c:5480 ret = 0 fil_node = 0x0 message = 0x0 type = 0 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48e8) at srv/srv0start.c:476 segment = 5 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 25 (Thread 0x7f77906aa700 (LWP 7057)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x10b5580, mp=0x10b4880, file=0xbd4f81 "sql_base.cc", line=996) at thr_mutex.c:239 error = 995 #2 0x00000000006b40ae in close_cached_tables (thd=0x3ba0d70, tables=0x0, have_lock=false, wait_for_refresh=true, wait_for_placeholders=false) at sql_base.cc:996 table = 0x7f775400a9c0 idx = 0 found = true _db_func_ = 0xb81991 "mysql_execute_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool close_cached_tables(THD*, TABLE_LIST*, bool, bool, bool)" result = false _db_level_ = 5 _db_framep_ = 0x810661 #3 0x0000000000675458 in reload_acl_and_cache (thd=0x3ba0d70, options=4, tables=0x0, write_to_binlog=0x7f77906a8f9c) at sql_parse.cc:7366 result = false tmp_write_to_binlog = 1 __PRETTY_FUNCTION__ = "bool reload_acl_and_cache(THD*, ulong, TABLE_LIST*, int*)" #4 0x000000000066d0c1 in mysql_execute_command (thd=0x3ba0d70) at sql_parse.cc:4299 write_to_binlog = 1 up_result = 0 select_lex = 0x3ba2fe0 unit = 0x3ba2bb8 _db_func_ = 0xb82559 "mysql_parse" _db_file_ = 0xb81380 "sql_parse.cc" __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" have_table_map_for_update = false _db_level_ = 4 _db_framep_ = 0x7f77540009d0 lex = 0x3ba2b08 first_table = 0x0 dbug_violation_helper = {_entered = true} res = 0 need_start_waiting = false all_tables = 0x0 #5 0x0000000000672e78 in mysql_parse (thd=0x3ba0d70, rawbuf=0x7f7754004ac0 "FLUSH TABLES", length=12, found_semicolon=0x7f77906a9c20) at sql_parse.cc:6350 lex = 0x3ba2b08 parser_state = {m_lip = {m_thd = 0x3ba0d70, yylineno = 1, yytoklen = 0, yylval = 0x7f77906a7b30, m_ptr = 0x7f7754004acd "\004", m_tok_start = 0x7f7754004acd "\004", m_tok_end = 0x7f7754004acd "\004", m_end_of_query = 0x7f7754004acc "", m_tok_start_prev = 0x7f7754004acc "", m_buf = 0x7f7754004ac0 "FLUSH TABLES", m_buf_length = 12, m_echo = true, m_echo_saved = 127, m_cpp_buf = 0x7f7754004b48 "FLUSH TABLES", m_cpp_ptr = 0x7f7754004b54 "", m_cpp_tok_start = 0x7f7754004b54 "", m_cpp_tok_start_prev = 0x7f7754004b54 "", m_cpp_tok_end = 0x7f7754004b54 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xb81452 "query", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 60 '<', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 10986480, m_cpp_text_start = 0x7f77906a93a0 "", m_cpp_text_end = 0xa7c055 "H\211E\370H\203}", , m_underscore_cs = 0x0}, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0}} err = false _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" tp = {tv_sec = 140151500739644, tv_nsec = 140151500739648} end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, const char**)" _db_level_ = 3 _db_framep_ = 0x7f77906a9430 end_time = {tv_sec = 140151500739656, tv_usec = 2143201129201} start_usecs = 0 cputime_error = 0 dbug_violation_helper = {_entered = true} end_time_error = 0 start_time = {tv_sec = 62528552, tv_usec = 140151500739631} end_usecs = 0 start_time_error = 0 start_cpu_nsecs = 0 #6 0x0000000000664aaa in dispatch_command (command=COM_QUERY, thd=0x3ba0d70, packet=0x3bcf281 "FLUSH TABLES", packet_length=12) at sql_parse.cc:1319 packet_end = 0x7f7754004acc "" end_of_stmt = 0x0 net = 0x3ba0ed8 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f77906a9d50 #7 0x000000000066386f in do_command (thd=0x3ba0d70) at sql_parse.cc:908 return_value = false packet = 0x3bcf280 "\003FLUSH TABLES" command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 13 net = 0x3ba0ed8 #8 0x000000000066196f in handle_one_connection (arg=0x3ba0d70) at sql_connect.cc:2099 net = 0x3ba0ed8 create_user = true thd = 0x3ba0d70 #9 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #10 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 24 (Thread 0x7f77904a2700 (LWP 7073)): #0 0x000000391b00e054 in __lll_lock_wait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000391b0093be in _L_lock_995 () from /lib64/libpthread.so.0 No symbol table info available. #2 0x000000391b009326 in pthread_mutex_lock () from /lib64/libpthread.so.0 No symbol table info available. #3 0x0000000000a7958d in safe_mutex_lock (mp=0x10b4880, try_lock=0 '\000', file=0xbd4f81 "sql_base.cc", line=1201) at thr_mutex.c:151 error = 0 #4 0x00000000006b4797 in close_open_tables (thd=0x3bfa6a0) at sql_base.cc:1201 found_old_table = false __PRETTY_FUNCTION__ = "void close_open_tables(THD*)" #5 0x00000000006b4b71 in close_thread_tables (thd=0x3bfa6a0) at sql_base.cc:1364 _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "void close_thread_tables(THD*)" table = 0x7f7738004ae0 prelocked_mode = NON_PRELOCKED _db_level_ = 3 _db_framep_ = 0xb81380 #6 0x0000000000665c7c in dispatch_command (command=COM_QUERY, thd=0x3bfa6a0, packet=0x3bfd421 "", packet_length=79) at sql_parse.cc:1734 net = 0x3bfa808 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f77904a1d50 #7 0x000000000066386f in do_command (thd=0x3bfa6a0) at sql_parse.cc:908 return_value = false packet = 0x3bfd420 "\a" command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 80 net = 0x3bfa808 #8 0x000000000066196f in handle_one_connection (arg=0x3bfa6a0) at sql_connect.cc:2099 net = 0x3bfa808 create_user = true thd = 0x3bfa6a0 #9 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #10 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 23 (Thread 0x7f77828ad700 (LWP 6696)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x36557a8, mp=0x3655730, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x3655730, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 1 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=4, message1=0x7f77828ace40, message2=0x7f77828ace38, type=0x7f77828ace30, space_id=0x7f77828ace28) at os/os0file.c:4421 array = 0x3642b60 slot = 0x364a608 slot2 = 0x0 consecutive_ios = {0x0 } lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 n = 256 i = 256 now = 1389305293 #4 0x00000000009c8481 in fil_aio_wait (segment=4) at fil/fil0fil.c:5480 ret = 0 fil_node = 0x0 message = 0x0 type = 0 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48e0) at srv/srv0start.c:476 segment = 4 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 22 (Thread 0x7f777f6a8700 (LWP 6701)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x3655b68, mp=0x3655af0, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x3655af0, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 325 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=9, message1=0x7f777f6a7e40, message2=0x7f777f6a7e38, type=0x7f777f6a7e30, space_id=0x7f777f6a7e28) at os/os0file.c:4421 array = 0x364a690 slot = 0x3652138 slot2 = 0x7f777f6a7d90 consecutive_ios = {0x0, 0x3650ba8, 0x3650c20, 0x3650c98, 0x3650d10, 0x3650d88, 0x3650e00, 0x3650e78, 0x3650ef0, 0x364e9e8, 0x364ea60, 0x364ead8, 0x364eb50, 0x364ebc8, 0x364b040, 0x364b0b8, 0x364b130, 0x364b1a8, 0x364b220, 0x364b298, 0x364b310, 0x364b388, 0x364b400, 0x364b478, 0x364b4f0, 0x364b568, 0x364b5e0, 0x364b658, 0x364b6d0, 0x364b748, 0x364b7c0, 0x364b838, 0x364b8b0, 0x364b928, 0x364b9a0, 0x364ba18, 0x364ba90, 0x364bb08, 0x364bb80, 0x364bbf8, 0x364bc70, 0x364bce8, 0x364bd60, 0x364bdd8, 0x364be50, 0xa79662, 0x364bf40, 0xa797e2, 0x2bd0364c030, 0x2cc00c470b0, 0xc470b0, 0x10cb900, 0x7f777f6a7d30, 0x10cb910, 0x7f777f6a7d30, 0x996977, 0xc5926f, 0x10cb900, 0x7f777f6a7d60, 0x99799f, 0x0, 0x7f7783ffec20, 0x990653, 0x7f7783ffecd8} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 140151215521280 offs = 10049558 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 1 combined_buf = 0x7f7783ffecd8 "\360\221\256\003" combined_buf2 = 0x203655c28
ret = 140151215521280 n = 256 i = 256 now = 1389305502 #4 0x00000000009c8481 in fil_aio_wait (segment=9) at fil/fil0fil.c:5480 ret = 9738095 fil_node = 0x7f777f6a7e60 message = 0x10c4890 type = 140151215521376 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c4908) at srv/srv0start.c:476 segment = 9 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 21 (Thread 0x7f77832ae700 (LWP 6695)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x36556e8, mp=0x3655670, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x3655670, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 1 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=3, message1=0x7f77832ade40, message2=0x7f77832ade38, type=0x7f77832ade30, space_id=0x7f77832ade28) at os/os0file.c:4421 array = 0x3642b60 slot = 0x364a608 slot2 = 0x0 consecutive_ios = {0x0 } lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 n = 256 i = 256 now = 1389305293 #4 0x00000000009c8481 in fil_aio_wait (segment=3) at fil/fil0fil.c:5480 ret = 0 fil_node = 0x0 message = 0x0 type = 0 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48d8) at srv/srv0start.c:476 segment = 3 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 20 (Thread 0x7f77904e3700 (LWP 7071)): #0 0x000000391b00e054 in __lll_lock_wait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000391b0093be in _L_lock_995 () from /lib64/libpthread.so.0 No symbol table info available. #2 0x000000391b009326 in pthread_mutex_lock () from /lib64/libpthread.so.0 No symbol table info available. #3 0x0000000000a7958d in safe_mutex_lock (mp=0x10b4880, try_lock=0 '\000', file=0xbd4f81 "sql_base.cc", line=2756) at thr_mutex.c:151 error = 0 #4 0x00000000006b804d in open_table (thd=0x3bf3910, table_list=0x7f7734004dc0, mem_root=0x7f77904e0f20, refresh=0x7f77904e0faf, flags=0) at sql_base.cc:2756 table = 0x0 key = "rqg1\000table100_innodb_compressed_int\000\001\000\000\000\022\000\000\000w\177\000\000\060\rN\220w\177\000\000\200\322\001\064w\177\000\000\320\t\000\064w\177\000\000\360\243\247\000\000\000\000\000P\rN\220w\177\000\000\260\t\005\064w\177\000\000z\016\307\000\000\000\000\000\240\202!\033\071\000\000\000\201O\275\000\000\000\000\000\360\243\247\000\000\000\000\000\200\rN\220w\177\000\000U\300\247\000\000\000\000\000\\\016N\220w\177\000\000\360\243\247\000\000\000\000\000\\\016N\220w\177\000\000\360\243\247\000\000\000\000\000\260\rN\220w\177\000\000U\300\247\000\000\000\000\000\320\t\000\064w\177\000\000\320\t\000\064w\177\000\000\224\017N\220w\177\000\000\360\243\247\000\000\000\000\000\340\rN\220w\177\000\000U\300\247\000\000\000\000\000\320Q\275\000\000\000\000\000\320"... alias = 0x7f7734004da0 "table100_innodb_compressed_int" _db_func_ = 0xbd609e "open_tables" _db_file_ = 0xbd4f81 "sql_base.cc" _db_level_ = 7 _db_framep_ = 0x7f77904e0f94 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "TABLE* open_table(THD*, TABLE_LIST*, MEM_ROOT*, bool*, uint)" state = 32631 key_length = 36 #5 0x00000000006bc38f in open_tables (thd=0x3bf3910, start=0x7f77904e1020, counter=0x7f77904e1064, flags=0) at sql_base.cc:4755 refresh = false safe_to_ignore_table = false _db_func_ = 0xbd6242 "open_and_lock_tables_derived" _db_file_ = 0xbd4f81 "sql_base.cc" _db_level_ = 6 _db_framep_ = 0xa7c055 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "int open_tables(THD*, TABLE_LIST**, uint*, uint)" query_tables_last_own = 0x0 tables = 0x7f7734004dc0 result = 0 new_frm_mem = {free = 0x7f77340509b0, used = 0x0, pre_alloc = 0x7f77340509b0, min_malloc = 32, block_size = 7992, block_num = 4, first_block_usage = 0, error_handler = 0x5ee300 } #6 0x00000000006bd189 in open_and_lock_tables_derived (thd=0x3bf3910, tables=0x7f7734004dc0, derived=true) at sql_base.cc:5173 _db_func_ = 0xb81991 "mysql_execute_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} counter = 1 need_reopen = false _db_level_ = 5 _db_framep_ = 0x3bf3910 #7 0x0000000000677e42 in open_and_lock_tables (thd=0x3bf3910, tables=0x7f7734004dc0) at mysql_priv.h:1728 No locals. #8 0x000000000067069b in execute_sqlcom_select (thd=0x3bf3910, all_tables=0x7f7734004dc0) at sql_parse.cc:5356 lex = 0x3bf56a8 result = 0x7f7734005168 res = false #9 0x0000000000667525 in mysql_execute_command (thd=0x3bf3910) at sql_parse.cc:2474 up_result = 0 select_lex = 0x3bf5b80 unit = 0x3bf5758 _db_func_ = 0xb82559 "mysql_parse" _db_file_ = 0xb81380 "sql_parse.cc" __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" have_table_map_for_update = false _db_level_ = 4 _db_framep_ = 0x3bf3910 lex = 0x3bf56a8 first_table = 0x7f7734004dc0 dbug_violation_helper = {_entered = true} res = 0 need_start_waiting = false all_tables = 0x7f7734004dc0 #10 0x0000000000672e78 in mysql_parse (thd=0x3bf3910, rawbuf=0x7f7734004ae0 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7070.tmp'", length=82, found_semicolon=0x7f77904e2c20) at sql_parse.cc:6350 lex = 0x3bf56a8 parser_state = {m_lip = {m_thd = 0x3bf3910, yylineno = 1, yytoklen = 20, yylval = 0x7f77904e0b30, m_ptr = 0x7f7734004b33 "\004", m_tok_start = 0x7f7734004b33 "\004", m_tok_end = 0x7f7734004b33 "\004", m_end_of_query = 0x7f7734004b32 "", m_tok_start_prev = 0x7f7734004b32 "", m_buf = 0x7f7734004ae0 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7070.tmp'", m_buf_length = 82, m_echo = true, m_echo_saved = 127, m_cpp_buf = 0x7f7734004ba8 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7070.tmp'", m_cpp_ptr = 0x7f7734004bfa "", m_cpp_tok_start = 0x7f7734004bfa "", m_cpp_tok_start_prev = 0x7f7734004bfa "", m_cpp_tok_end = 0x7f7734004bfa "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xb81452 "query", 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 = 10986480, m_cpp_text_start = 0x7f7734004be5 "/tmp/gentest7070.tmp'", m_cpp_text_end = 0x7f7734004bf9 "'", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0}} err = false _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" tp = {tv_sec = 140151498875964, tv_nsec = 140151498875968} end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, const char**)" _db_level_ = 3 _db_framep_ = 0x7f77904e2430 end_time = {tv_sec = 140151498875976, tv_usec = 2143201129201} start_usecs = 0 cputime_error = 0 dbug_violation_helper = {_entered = true} end_time_error = 0 start_time = {tv_sec = 62867400, tv_usec = 140151498875951} end_usecs = 0 start_time_error = 0 start_cpu_nsecs = 0 #11 0x0000000000664aaa in dispatch_command (command=COM_QUERY, thd=0x3bf3910, packet=0x3bf6691 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7070.tmp' ", packet_length=83) at sql_parse.cc:1319 packet_end = 0x7f7734004b32 "" end_of_stmt = 0x0 net = 0x3bf3a78 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f77904e2d50 #12 0x000000000066386f in do_command (thd=0x3bf3910) at sql_parse.cc:908 return_value = false packet = 0x3bf6690 "\003SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7070.tmp' " command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 84 net = 0x3bf3a78 #13 0x000000000066196f in handle_one_connection (arg=0x3bf3910) at sql_connect.cc:2099 net = 0x3bf3a78 create_user = true thd = 0x3bf3910 #14 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #15 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 19 (Thread 0x7f77931ff720 (LWP 6689)): #0 0x000000391a8dea63 in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x00000000006568a2 in handle_connections_sockets (arg=0x0) at mysqld.cc:5197 sock = 10 retval = 1 fds = {{fd = 10, events = 1, revents = 0}, {fd = 12, events = 1, revents = 0}} _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x7fff160f57dc flags = 2 dbug_violation_helper = {_entered = true} new_sock = 22 error_count = 0 thd = 0x3bfa6a0 cAddr = {sin_family = 2, sin_port = 47809, sin_addr = {s_addr = 16777343}, sin_zero = "\000\000\000\000\000\000\000"} vio_tmp = 0x3b91f60 socket_count = 2 #2 0x0000000000655d65 in main (argc=3, argv=0x7fff160f5928) at mysqld.cc:4649 No locals. Thread 18 (Thread 0x7f77906eb700 (LWP 7055)): #0 0x000000391b00e054 in __lll_lock_wait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000391b0093be in _L_lock_995 () from /lib64/libpthread.so.0 No symbol table info available. #2 0x000000391b009326 in pthread_mutex_lock () from /lib64/libpthread.so.0 No symbol table info available. #3 0x0000000000a7958d in safe_mutex_lock (mp=0x10b4880, try_lock=0 '\000', file=0xbd4f81 "sql_base.cc", line=1201) at thr_mutex.c:151 error = 0 #4 0x00000000006b4797 in close_open_tables (thd=0x3b9c0f0) at sql_base.cc:1201 found_old_table = false __PRETTY_FUNCTION__ = "void close_open_tables(THD*)" #5 0x00000000006b4b71 in close_thread_tables (thd=0x3b9c0f0) at sql_base.cc:1364 _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "void close_thread_tables(THD*)" table = 0x7f775e587930 prelocked_mode = NON_PRELOCKED _db_level_ = 3 _db_framep_ = 0xb81380 #6 0x0000000000665c7c in dispatch_command (command=COM_QUERY, thd=0x3b9c0f0, packet=0x3beb8f1 "", packet_length=56) at sql_parse.cc:1734 net = 0x3b9c258 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f77906ead50 #7 0x000000000066386f in do_command (thd=0x3b9c0f0) at sql_parse.cc:908 return_value = false packet = 0x3beb8f0 "." command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 57 net = 0x3b9c258 #8 0x000000000066196f in handle_one_connection (arg=0x3b9c0f0) at sql_connect.cc:2099 net = 0x3b9c258 create_user = true thd = 0x3b9c0f0 #9 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #10 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 17 (Thread 0x7f77800a9700 (LWP 6700)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x3655aa8, mp=0x3655a30, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x3655a30, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 325 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=8, message1=0x7f77800a8e40, message2=0x7f77800a8e38, type=0x7f77800a8e30, space_id=0x7f77800a8e28) at os/os0file.c:4421 array = 0x364a690 slot = 0x3652138 slot2 = 0x7f77800a8d90 consecutive_ios = {0x0, 0x364aaa0, 0x364ade8, 0x364ae60, 0x364aed8, 0x364af50, 0x364afc8, 0x364b040, 0x364b0b8, 0x364b130, 0x364b1a8, 0x364b220, 0x364b298, 0x364b310, 0x364b388, 0x364b400, 0x364b478, 0x364b4f0, 0x364b568, 0x364b5e0, 0x364b658, 0x364b6d0, 0x364b748, 0x364b7c0, 0x364b838, 0x364b8b0, 0x364b928, 0x364b9a0, 0x364ba18, 0x364ba90, 0x364bb08, 0x364bb80, 0x364bbf8, 0x364bc70, 0x364bce8, 0x364bd60, 0x364bdd8, 0x364be50, 0x364bec8, 0x364bf40, 0x62e221d286e7c02e, 0x364c030, 0x40, 0x7f77800a8e40, 0x7f77800a8ce0, 0xa79662, 0x364c288, 0xa797e2, 0x2bd800a8d10, 0x2cc00c470b0, 0xc470b0, 0x3aead90, 0x7f77800a8d30, 0x10cb910, 0x7f77800a8d30, 0x7f77800a8e40, 0x7f77800a8d40, 0x8fae99, 0x7f77800a8d60, 0x3aead90, 0x7f77800a8d60, 0x8fa4d9, 0x990653, 0x7f7783fd9050} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 140151226011136 offs = 10049558 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 1 combined_buf = 0x7f7783fd9050 "\260\\\253\003" combined_buf2 = 0x203655c28
ret = 140151226011136 n = 256 i = 256 now = 1389305502 #4 0x00000000009c8481 in fil_aio_wait (segment=8) at fil/fil0fil.c:5480 ret = 9738095 fil_node = 0x7f77800a8e60 message = 0x10c4890 type = 140151226011232 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c4900) at srv/srv0start.c:476 segment = 8 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 16 (Thread 0x7f7790628700 (LWP 7061)): #0 0x000000391b00e054 in __lll_lock_wait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000391b0093be in _L_lock_995 () from /lib64/libpthread.so.0 No symbol table info available. #2 0x000000391b009326 in pthread_mutex_lock () from /lib64/libpthread.so.0 No symbol table info available. #3 0x0000000000a7958d in safe_mutex_lock (mp=0x10b4880, try_lock=0 '\000', file=0xbd4f81 "sql_base.cc", line=2756) at thr_mutex.c:151 error = 0 #4 0x00000000006b804d in open_table (thd=0x3bd9b60, table_list=0x7f7750004d68, mem_root=0x7f7790625e60, refresh=0x7f7790625eef, flags=0) at sql_base.cc:2756 table = 0x0 key = "rqg1\000table500_innodb_compressed_int\000\001\000\000\000\r\000\000\000w\177\000\000p\\b\220w\177\000\000\360\243\247\000\000\000\000\000\320\t\000Pw\177\000\000\360\243\247\000\000\000\000\000\220\\b\220w\177\000\000\000\322\rPw\177\000\000z\016\307\000\000\000\000\000\240\202!\033\071\000\000\000\201O\275\000\000\000\000\000\360\243\247\000\000\000\000\000\300\\b\220w\177\000\000U\300\247\000\000\000\000\000\234]b\220w\177\000\000\360\243\247\000\000\000\000\000\234]b\220w\177\000\000\360\243\247\000\000\000\000\000\360\\b\220w\177\000\000U\300\247\000\000\000\000\000\320\t\000Pw\177\000\000\320\t\000Pw\177\000\000\324^b\220w\177\000\000\360\243\247\000\000\000\000\000 ]b\220w\177\000\000U\300\247\000\000\000\000\000\320Q\275\000\000\000\000\000\320\t"... alias = 0x7f7750004d48 "table500_innodb_compressed_int" _db_func_ = 0xbd609e "open_tables" _db_file_ = 0xbd4f81 "sql_base.cc" _db_level_ = 8 _db_framep_ = 0x7f7790625ed4 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "TABLE* open_table(THD*, TABLE_LIST*, MEM_ROOT*, bool*, uint)" state = 32631 key_length = 36 #5 0x00000000006bc38f in open_tables (thd=0x3bd9b60, start=0x7f7790625f60, counter=0x7f7790625fa4, flags=0) at sql_base.cc:4755 refresh = false safe_to_ignore_table = false _db_func_ = 0xbd6242 "open_and_lock_tables_derived" _db_file_ = 0xbd4f81 "sql_base.cc" _db_level_ = 7 _db_framep_ = 0xa7c055 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "int open_tables(THD*, TABLE_LIST**, uint*, uint)" query_tables_last_own = 0x0 tables = 0x7f7750004d68 result = 0 new_frm_mem = {free = 0x7f77500dd200, used = 0x0, pre_alloc = 0x7f77500dd200, min_malloc = 32, block_size = 7992, block_num = 4, first_block_usage = 0, error_handler = 0x5ee300 } #6 0x00000000006bd189 in open_and_lock_tables_derived (thd=0x3bd9b60, tables=0x7f7750004d68, derived=true) at sql_base.cc:5173 _db_func_ = 0xbe62e3 "mysql_delete" _db_file_ = 0xbe62d5 "sql_delete.cc" dbug_violation_helper = {_entered = true} counter = 1 need_reopen = 144 _db_level_ = 6 _db_framep_ = 0x7f77500009d0 #7 0x0000000000677e42 in open_and_lock_tables (thd=0x3bd9b60, tables=0x7f7750004d68) at mysql_priv.h:1728 No locals. #8 0x000000000072957b in mysql_delete (thd=0x3bd9b60, table_list=0x7f7750004d68, conds=0x7f77500052f0, order=0x3bdbf78, limit=18446744073709551615, options=0, reset_auto_increment=false) at sql_delete.cc:63 safe_update = 127 _db_func_ = 0xb81991 "mysql_execute_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} skip_record = false __PRETTY_FUNCTION__ = "bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List*, ha_rows, ulonglong, bool)" will_batch = 144 transactional_table = 119 const_cond_result = false query_type = THD::ROW_QUERY_TYPE triggers_applicable = 144 select_lex = 0x3bdbdd0 table = 0x7f7790626510 usable_index = 64 _db_level_ = 5 _db_framep_ = 0x7f77906264dc save_binlog_row_based = 3 loc_error = 32631 select = 0x0 info = {table = 0x7f7750004f88, file = 0x7f7750005098, forms = 0x8, read_record = 0x603bd9b60, unlock_row = 0xb81380, thd = 0xb82898, select = 0x0, cache_records = 0, ref_length = 0, struct_length = 62761968, reclength = 0, rec_cache_size = 2422367356, error_offset = 1, index = 8, ref_pos = 0xde73c3f
, record = 0x0, rec_buf = 0x8
, cache = 0xa0
, cache_pos = 0x7f77906289c0 "\300\231f\220w\177", cache_end = 0x7f7790626450 "\220db\220w\177", read_positions = 0x670a62 "\204\300t\a\270\001", io_cache = 0x7f7700000000, print_error = 99, ignore_not_found_rows = 217} const_cond = false deleted = 0 error = 22 using_limit = false killed_status = THD::NOT_KILLED #9 0x000000000066ab5c in mysql_execute_command (thd=0x3bd9b60) at sql_parse.cc:3623 up_result = 0 select_lex = 0x3bdbdd0 unit = 0x3bdb9a8 _db_func_ = 0xb82559 "mysql_parse" _db_file_ = 0xb81380 "sql_parse.cc" __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" have_table_map_for_update = false _db_level_ = 4 _db_framep_ = 0x1 lex = 0x3bdb8f8 first_table = 0x7f7750004d68 dbug_violation_helper = {_entered = true} res = 0 need_start_waiting = true all_tables = 0x7f7750004d68 #10 0x0000000000672e78 in mysql_parse (thd=0x3bd9b60, rawbuf=0x7f7750004ae0 "DELETE FROM `table500_innodb_compressed_int` WHERE `col_text_latin1_default_null` != '2003-06-05 14:04:49.032366' ORDER BY `col_text_latin1_unique_default_null`", length=160, found_semicolon=0x7f7790627c20) at sql_parse.cc:6350 lex = 0x3bdb8f8 parser_state = {m_lip = {m_thd = 0x3bd9b60, yylineno = 1, yytoklen = 35, yylval = 0x7f7790625b30, m_ptr = 0x7f7750004b81 "\004", m_tok_start = 0x7f7750004b81 "\004", m_tok_end = 0x7f7750004b81 "\004", m_end_of_query = 0x7f7750004b80 "", m_tok_start_prev = 0x7f7750004b80 "", m_buf = 0x7f7750004ae0 "DELETE FROM `table500_innodb_compressed_int` WHERE `col_text_latin1_default_null` != '2003-06-05 14:04:49.032366' ORDER BY `col_text_latin1_unique_default_null`", m_buf_length = 160, m_echo = true, m_echo_saved = 127, m_cpp_buf = 0x7f7750004bf8 "DELETE FROM `table500_innodb_compressed_int` WHERE `col_text_latin1_default_null` != '2003-06-05 14:04:49.032366' ORDER BY `col_text_latin1_unique_default_null`", m_cpp_ptr = 0x7f7750004c98 "", m_cpp_tok_start = 0x7f7750004c98 "", m_cpp_tok_start_prev = 0x7f7750004c98 "", m_cpp_tok_end = 0x7f7750004c98 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xb81452 "query", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 63 '?', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 10986480, m_cpp_text_start = 0x7f7750004c74 "col_text_latin1_unique_default_null`", m_cpp_text_end = 0x7f7750004c97 "`", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0}} err = false _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" tp = {tv_sec = 140151500207164, tv_nsec = 140151500207168} end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, const char**)" _db_level_ = 3 _db_framep_ = 0x7f7790627430 end_time = {tv_sec = 140151500207176, tv_usec = 2143201129201} start_usecs = 0 cputime_error = 0 dbug_violation_helper = {_entered = true} end_time_error = 0 start_time = {tv_sec = 62761496, tv_usec = 140151500207151} end_usecs = 0 start_time_error = 0 start_cpu_nsecs = 0 #11 0x0000000000664aaa in dispatch_command (command=COM_QUERY, thd=0x3bd9b60, packet=0x3bdc8e1 "DELETE FROM `table500_innodb_compressed_int` WHERE `col_text_latin1_default_null` != '2003-06-05 14:04:49.032366' ORDER BY `col_text_latin1_unique_default_null` ", packet_length=161) at sql_parse.cc:1319 packet_end = 0x7f7750004b80 "" end_of_stmt = 0x0 net = 0x3bd9cc8 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f7790627d50 #12 0x000000000066386f in do_command (thd=0x3bd9b60) at sql_parse.cc:908 return_value = false packet = 0x3bdc8e0 "\003DELETE FROM `table500_innodb_compressed_int` WHERE `col_text_latin1_default_null` != '2003-06-05 14:04:49.032366' ORDER BY `col_text_latin1_unique_default_null` " command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 162 net = 0x3bd9cc8 #13 0x000000000066196f in handle_one_connection (arg=0x3bd9b60) at sql_connect.cc:2099 net = 0x3bd9cc8 create_user = true thd = 0x3bd9b60 #14 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #15 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 15 (Thread 0x7f77931fd700 (LWP 6692)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x36554a8, mp=0x3655430, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x3655430, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 1 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=0, message1=0x7f77931fce40, message2=0x7f77931fce38, type=0x7f77931fce30, space_id=0x7f77931fce28) at os/os0file.c:4421 array = 0x3073680 slot = 0x363b018 slot2 = 0x7f77931fce30 consecutive_ios = {0x0, 0x391a409296, 0x0, 0x7f77931fcc20, 0x0, 0x7f77931fcc20, 0xd, 0x7f7793202120, 0xb3e3f58e, 0x391a409ba7, 0x0, 0x2cf8fd6, 0xe, 0x391a8032b8, 0x0, 0x7f77931fcda0, 0x391a803c48, 0x391a80cdf8, 0x7f77931fce50, 0x7f77931fdd70, 0x7f77931fcc20, 0x391b00dcc0, 0x3, 0x3921410254, 0x7f7793223658, 0x0, 0x7f7793202428, 0x7f77932034c8, 0x391b002ed1, 0x391a810740, 0x391b0013c8, 0x500000000, 0x100000612, 0x0, 0x0, 0x7f77932239b0, 0x7f77931fcdf0, 0x7f77931fce18, 0x7f7793223658, 0x7f7793202428, 0xb3e3f58e, 0x391a409e3a, 0x0, 0x7f7793202428, 0x5, 0x0, 0x1, 0x7f7793223658, 0x4000000000000000, 0x0, 0x0, 0x0, 0x0, 0x7f77932239b0, 0x7f77931fcda0, 0x7f77931fce20, 0x7f77931fcdb8, 0x1931fce28, 0x0, 0x391b002ed1, 0x7f77931fce50, 0x0, 0x0, 0x0} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 140151546170968 offs = 0 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 4294967295 combined_buf = 0x0 combined_buf2 = 0x5
ret = 245268316512 n = 256 i = 256 now = 1389305293 #4 0x00000000009c8481 in fil_aio_wait (segment=0) at fil/fil0fil.c:5480 ret = 245253621397 fil_node = 0x7f77931fd9c0 message = 0x7fff160f5740 type = 0 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48c0) at srv/srv0start.c:476 segment = 0 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 14 (Thread 0x7f77905e7700 (LWP 7063)): #0 0x000000391b00e054 in __lll_lock_wait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000391b0093be in _L_lock_995 () from /lib64/libpthread.so.0 No symbol table info available. #2 0x000000391b009326 in pthread_mutex_lock () from /lib64/libpthread.so.0 No symbol table info available. #3 0x0000000000a7958d in safe_mutex_lock (mp=0x10b4880, try_lock=0 '\000', file=0xbd4f81 "sql_base.cc", line=1201) at thr_mutex.c:151 error = 0 #4 0x00000000006b4797 in close_open_tables (thd=0x3bc08c0) at sql_base.cc:1201 found_old_table = false __PRETTY_FUNCTION__ = "void close_open_tables(THD*)" #5 0x00000000006b4b71 in close_thread_tables (thd=0x3bc08c0) at sql_base.cc:1364 _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "void close_thread_tables(THD*)" table = 0x7f7744004ae0 prelocked_mode = NON_PRELOCKED _db_level_ = 3 _db_framep_ = 0xb81380 #6 0x0000000000665c7c in dispatch_command (command=COM_QUERY, thd=0x3bc08c0, packet=0x3bc3641 "", packet_length=66) at sql_parse.cc:1734 net = 0x3bc0a28 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f77905e6d50 #7 0x000000000066386f in do_command (thd=0x3bc08c0) at sql_parse.cc:908 return_value = false packet = 0x3bc3640 "K" command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 67 net = 0x3bc0a28 #8 0x000000000066196f in handle_one_connection (arg=0x3bc08c0) at sql_connect.cc:2099 net = 0x3bc0a28 create_user = true thd = 0x3bc08c0 #9 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #10 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 13 (Thread 0x7f777d8a4700 (LWP 6704)): #0 0x000000391b00b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79af2 in safe_cond_timedwait (cond=0x3442128, mp=0x34420b0, abstime=0x7f777d8a3dc0, file=0xc470b0 "os/os0sync.c", line=471) at thr_mutex.c:277 error = 0 #2 0x00000000008fa9e8 in os_event_wait_time (event=0x34420b0, wtime=5000000) at os/os0sync.c:470 err = 266399 ret = 0 tmp = 5266401 old_count = 1 tv_start = {tv_sec = 1389305504, tv_usec = 266401} timeout = {tv_sec = 1389305509, tv_nsec = 266401000} #3 0x0000000000946f4b in srv_monitor_thread (arg=0x0) at srv/srv0srv.c:2326 time_elapsed = 10 current_time = 1389305504 last_table_monitor_time = 1389305294 last_tablespace_monitor_time = 1389305294 last_monitor_time = 1389305494 mutex_skipped = 0 last_srv_print_monitor = 0 #4 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 12 (Thread 0x7f77775fe700 (LWP 6707)): #0 0x000000391b00b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79af2 in safe_cond_timedwait (cond=0x3442128, mp=0x34420b0, abstime=0x7f77775fdde0, file=0xc470b0 "os/os0sync.c", line=471) at thr_mutex.c:277 error = 0 #2 0x00000000008fa9e8 in os_event_wait_time (event=0x34420b0, wtime=10000000) at os/os0sync.c:470 err = 61815632 ret = 0 tmp = 10810391 old_count = 1 tv_start = {tv_sec = 1389305498, tv_usec = 810391} timeout = {tv_sec = 1389305508, tv_nsec = 810391000} #3 0x00000000009494a3 in srv_purge_thread (arg=0x0) at srv/srv0srv.c:3683 n_pages_purged = 0 n_pages_purged_sum = 2 history_len = 2 sleep_ms = 10000 can_be_last = 0 #4 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 11 (Thread 0x7f77905a6700 (LWP 7065)): #0 0x000000391b00e054 in __lll_lock_wait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000391b0093be in _L_lock_995 () from /lib64/libpthread.so.0 No symbol table info available. #2 0x000000391b009326 in pthread_mutex_lock () from /lib64/libpthread.so.0 No symbol table info available. #3 0x0000000000a7958d in safe_mutex_lock (mp=0x10b4880, try_lock=0 '\000', file=0xbd4f81 "sql_base.cc", line=2756) at thr_mutex.c:151 error = 0 #4 0x00000000006b804d in open_table (thd=0x3bc7650, table_list=0x7f7748004dc0, mem_root=0x7f77905a3f20, refresh=0x7f77905a3faf, flags=0) at sql_base.cc:2756 table = 0x0 key = "rqg1\000table100_innodb_compressed_int\000\001\000\000\000\017\000\000\000w\177\000\000\060=Z\220w\177\000\000\265\213\207\032\071\000\000\000\320\t\000Hw\177\000\000h\037\000\000\000\000\000\000\210\000\000Hw\177\000\000\000\270\004Hw\177\000\000z\016\307\000\000\000\000\000\240\202!\033\071\000\000\000\201O\275\000\000\000\000\000\360\243\247\000\000\000\000\000\200=Z\220w\177\000\000U\300\247\000\000\000\000\000\\>Z\220w\177\000\000\360\243\247\000\000\000\000\000\\>Z\220w\177\000\000\360\243\247\000\000\000\000\000\260=Z\220w\177\000\000U\300\247\000\000\000\000\000\320\t\000Hw\177\000\000\320\t\000Hw\177\000\000\224?Z\220w\177\000\000\360\243\247\000\000\000\000\000\340=Z\220w\177\000\000U\300\247\000\000\000\000\000\320Q\275\000\000\000\000\000\320"... alias = 0x7f7748004da0 "table100_innodb_compressed_int" _db_func_ = 0xbd609e "open_tables" _db_file_ = 0xbd4f81 "sql_base.cc" _db_level_ = 7 _db_framep_ = 0x7f77905a3f94 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "TABLE* open_table(THD*, TABLE_LIST*, MEM_ROOT*, bool*, uint)" state = 32631 key_length = 36 #5 0x00000000006bc38f in open_tables (thd=0x3bc7650, start=0x7f77905a4020, counter=0x7f77905a4064, flags=0) at sql_base.cc:4755 refresh = false safe_to_ignore_table = false _db_func_ = 0xbd6242 "open_and_lock_tables_derived" _db_file_ = 0xbd4f81 "sql_base.cc" _db_level_ = 6 _db_framep_ = 0xa7c055 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "int open_tables(THD*, TABLE_LIST**, uint*, uint)" query_tables_last_own = 0x0 tables = 0x7f7748004dc0 result = 0 new_frm_mem = {free = 0x7f774804b800, used = 0x0, pre_alloc = 0x7f774804b800, min_malloc = 32, block_size = 7992, block_num = 4, first_block_usage = 0, error_handler = 0x5ee300 } #6 0x00000000006bd189 in open_and_lock_tables_derived (thd=0x3bc7650, tables=0x7f7748004dc0, derived=true) at sql_base.cc:5173 _db_func_ = 0xb81991 "mysql_execute_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} counter = 1 need_reopen = false _db_level_ = 5 _db_framep_ = 0x3bc7650 #7 0x0000000000677e42 in open_and_lock_tables (thd=0x3bc7650, tables=0x7f7748004dc0) at mysql_priv.h:1728 No locals. #8 0x000000000067069b in execute_sqlcom_select (thd=0x3bc7650, all_tables=0x7f7748004dc0) at sql_parse.cc:5356 lex = 0x3bc93e8 result = 0x7f7748005168 res = false #9 0x0000000000667525 in mysql_execute_command (thd=0x3bc7650) at sql_parse.cc:2474 up_result = 0 select_lex = 0x3bc98c0 unit = 0x3bc9498 _db_func_ = 0xb82559 "mysql_parse" _db_file_ = 0xb81380 "sql_parse.cc" __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" have_table_map_for_update = false _db_level_ = 4 _db_framep_ = 0x1 lex = 0x3bc93e8 first_table = 0x7f7748004dc0 dbug_violation_helper = {_entered = true} res = 0 need_start_waiting = false all_tables = 0x7f7748004dc0 #10 0x0000000000672e78 in mysql_parse (thd=0x3bc7650, rawbuf=0x7f7748004ae0 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7064.tmp'", length=82, found_semicolon=0x7f77905a5c20) at sql_parse.cc:6350 lex = 0x3bc93e8 parser_state = {m_lip = {m_thd = 0x3bc7650, yylineno = 1, yytoklen = 20, yylval = 0x7f77905a3b30, m_ptr = 0x7f7748004b33 "\004", m_tok_start = 0x7f7748004b33 "\004", m_tok_end = 0x7f7748004b33 "\004", m_end_of_query = 0x7f7748004b32 "", m_tok_start_prev = 0x7f7748004b32 "", m_buf = 0x7f7748004ae0 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7064.tmp'", m_buf_length = 82, m_echo = true, m_echo_saved = 127, m_cpp_buf = 0x7f7748004ba8 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7064.tmp'", m_cpp_ptr = 0x7f7748004bfa "", m_cpp_tok_start = 0x7f7748004bfa "", m_cpp_tok_start_prev = 0x7f7748004bfa "", m_cpp_tok_end = 0x7f7748004bfa "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xb81452 "query", 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 = 10986480, m_cpp_text_start = 0x7f7748004be5 "/tmp/gentest7064.tmp'", m_cpp_text_end = 0x7f7748004bf9 "'", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0}} err = false _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" tp = {tv_sec = 140151499674684, tv_nsec = 140151499674688} end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, const char**)" _db_level_ = 3 _db_framep_ = 0x7f77905a5430 end_time = {tv_sec = 140151499674696, tv_usec = 2143201129201} start_usecs = 0 cputime_error = 0 dbug_violation_helper = {_entered = true} end_time_error = 0 start_time = {tv_sec = 62686472, tv_usec = 140151499674671} end_usecs = 0 start_time_error = 0 start_cpu_nsecs = 0 #11 0x0000000000664aaa in dispatch_command (command=COM_QUERY, thd=0x3bc7650, packet=0x3ba4961 "SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7064.tmp' ", packet_length=83) at sql_parse.cc:1319 packet_end = 0x7f7748004b32 "" end_of_stmt = 0x0 net = 0x3bc77b8 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f77905a5d50 #12 0x000000000066386f in do_command (thd=0x3bc7650) at sql_parse.cc:908 return_value = false packet = 0x3ba4960 "\003SELECT * FROM `table100_innodb_compressed_int` INTO OUTFILE '/tmp/gentest7064.tmp' " command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 84 net = 0x3bc77b8 #13 0x000000000066196f in handle_one_connection (arg=0x3bc7650) at sql_connect.cc:2099 net = 0x3bc77b8 create_user = true thd = 0x3bc7650 #14 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #15 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 10 (Thread 0x7f77814ab700 (LWP 6698)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x3655928, mp=0x36558b0, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x36558b0, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 325 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=6, message1=0x7f77814aae40, message2=0x7f77814aae38, type=0x7f77814aae30, space_id=0x7f77814aae28) at os/os0file.c:4421 array = 0x364a690 slot = 0x3652138 slot2 = 0x7f77814aad90 consecutive_ios = {0x0, 0x364e718, 0x3651058, 0x36510d0, 0x3651148, 0x36511c0, 0x364b298, 0x364b310, 0x364b388, 0x364b400, 0x364b478, 0x364b4f0, 0x364b568, 0x364b5e0, 0x364b658, 0x364b6d0, 0x364b748, 0x364b7c0, 0x364b838, 0x364b8b0, 0x364b928, 0x364b9a0, 0x364ba18, 0x364ba90, 0x364bb08, 0x364bb80, 0x364bbf8, 0x364bc70, 0x364bce8, 0x364bd60, 0x364bdd8, 0x364be50, 0x364bec8, 0x364bf40, 0x364bfb8, 0x364c030, 0x364c0a8, 0x364c120, 0x364c198, 0x364c210, 0x6423429bc0269d02, 0x364c300, 0x40, 0x7f77814aae40, 0x7f77814aace0, 0x94ea7b, 0x364c558, 0x6423429bc0269d02, 0x7f77814aad10, 0x94eaaa, 0x6, 0x10cb900, 0x7f77814aad30, 0x10cb910, 0x7f77814aad30, 0x996977, 0xc5926f, 0x10cb900, 0x7f77814aad60, 0x99799f, 0x0, 0x7f7783ef5dc8, 0x990653, 0x7f7783ef5e80} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 140151246990848 offs = 10049558 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 1 combined_buf = 0x7f7783ef5e80 "0\024\230\003" combined_buf2 = 0x203655c28
ret = 140151246990848 n = 256 i = 256 now = 1389305502 #4 0x00000000009c8481 in fil_aio_wait (segment=6) at fil/fil0fil.c:5480 ret = 9738095 fil_node = 0x7f77814aae60 message = 0x10c4890 type = 140151246990944 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48f0) at srv/srv0start.c:476 segment = 6 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 9 (Thread 0x7f777cea3700 (LWP 6705)): #0 0x000000391b00b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79af2 in safe_cond_timedwait (cond=0x3442128, mp=0x34420b0, abstime=0x7f777cea2e00, file=0xc470b0 "os/os0sync.c", line=471) at thr_mutex.c:277 error = 0 #2 0x00000000008fa9e8 in os_event_wait_time (event=0x34420b0, wtime=5000000) at os/os0sync.c:470 err = 266783 ret = 0 tmp = 5266784 old_count = 1 tv_start = {tv_sec = 1389305504, tv_usec = 266784} timeout = {tv_sec = 1389305509, tv_nsec = 266784000} #3 0x00000000009477eb in srv_LRU_dump_restore_thread (arg=0x0) at srv/srv0srv.c:2718 auto_lru_dump = 0 last_dump_time = 1389305294 time_elapsed = 210 #4 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 8 (Thread 0x7f777eca6700 (LWP 6702)): #0 0x000000391b00b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79af2 in safe_cond_timedwait (cond=0x3442128, mp=0x34420b0, abstime=0x7f777eca5de0, file=0xc470b0 "os/os0sync.c", line=471) at thr_mutex.c:277 error = 0 #2 0x00000000008fa9e8 in os_event_wait_time (event=0x34420b0, wtime=1000000) at os/os0sync.c:470 err = 50880584 ret = 0 tmp = 1306957 old_count = 1 tv_start = {tv_sec = 1389305508, tv_usec = 306957} timeout = {tv_sec = 1389305509, tv_nsec = 306957000} #3 0x00000000009472b7 in srv_lock_timeout_thread (arg=0x0) at srv/srv0srv.c:2468 slot = 0x7f7791ec2358 some_waits = 1 wait_time = 3 i = 10000 #4 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 7 (Thread 0x7f777e2a5700 (LWP 6703)): #0 0x000000391b00b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79af2 in safe_cond_timedwait (cond=0x3442128, mp=0x34420b0, abstime=0x7f777e2a4dc0, file=0xc470b0 "os/os0sync.c", line=471) at thr_mutex.c:277 error = 0 #2 0x00000000008fa9e8 in os_event_wait_time (event=0x34420b0, wtime=1000000) at os/os0sync.c:470 err = 0 ret = 0 tmp = 1368294 old_count = 1 tv_start = {tv_sec = 1389305508, tv_usec = 368294} timeout = {tv_sec = 1389305509, tv_nsec = 368294000} #3 0x000000000094776d in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2672 fatal_cnt = 0 old_lsn = 907212235 new_lsn = 907212235 waiter = 140151500478208 old_waiter = 140151500478208 sema = 0x3af4618 old_sema = 0x3af4618 #4 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 6 (Thread 0x7f779072c700 (LWP 6708)): #0 0x000000391b00f2a5 in sigwait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000652f70 in signal_hand (arg=0x0) at mysqld.cc:2717 error = 0 sig = 14 _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" dbug_violation_helper = {_entered = true} set = {__val = {548869, 0 }} _db_level_ = 1 _db_framep_ = 0x0 #2 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #3 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 5 (Thread 0x7f7783caf700 (LWP 6694)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x3655628, mp=0x36555b0, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x36555b0, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 1 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=2, message1=0x7f7783caee40, message2=0x7f7783caee38, type=0x7f7783caee30, space_id=0x7f7783caee28) at os/os0file.c:4421 array = 0x3642b60 slot = 0x364a608 slot2 = 0x0 consecutive_ios = {0x0 } lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 n = 256 i = 256 now = 1389305293 #4 0x00000000009c8481 in fil_aio_wait (segment=2) at fil/fil0fil.c:5480 ret = 0 fil_node = 0x0 message = 0x0 type = 0 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48d0) at srv/srv0start.c:476 segment = 2 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 4 (Thread 0x7f7777fff700 (LWP 6706)): #0 0x000000391b00b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79af2 in safe_cond_timedwait (cond=0x3442128, mp=0x34420b0, abstime=0x7f7777ffecd0, file=0xc470b0 "os/os0sync.c", line=471) at thr_mutex.c:277 error = 0 #2 0x00000000008fa9e8 in os_event_wait_time (event=0x34420b0, wtime=981000) at os/os0sync.c:470 err = 9896775 ret = 0 tmp = 1306236 old_count = 1 tv_start = {tv_sec = 1389305508, tv_usec = 325236} timeout = {tv_sec = 1389305509, tv_nsec = 306236000} #3 0x0000000000947c9c in srv_master_thread (arg=0x0) at srv/srv0srv.c:2973 cur_time = 1389305508325 event = 0x3086200 old_activity_count = 22014 n_pages_purged = 0 n_bytes_merged = 0 n_pages_flushed = 0 n_pages_flushed_prev = 0 n_bytes_archived = 0 n_tables_to_drop = 0 n_ios = 20387 n_ios_old = 20387 n_ios_very_old = 20371 n_pend_ios = 1 next_itr_time = 1389305509306 prev_adaptive_checkpoint = 2 inner_loop = 0 skip_sleep = 0 i = 3 prev_flush_info = {count = 0, space = 0, offset = 0, oldest_modification = 0} lsn_old = 907208910 oldest_lsn = 906642654 #4 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 3 (Thread 0x7f7780aaa700 (LWP 6699)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x36559e8, mp=0x3655970, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x3655970, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 325 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=7, message1=0x7f7780aa9e40, message2=0x7f7780aa9e38, type=0x7f7780aa9e30, space_id=0x7f7780aa9e28) at os/os0file.c:4421 array = 0x364a690 slot = 0x3652138 slot2 = 0x7f7780aa9d90 consecutive_ios = {0x0, 0x364ac08, 0x364e6a0, 0x364e718, 0x364e790, 0x364e808, 0x364e880, 0x364e8f8, 0x364e970, 0x364e9e8, 0x364ea60, 0x364ead8, 0x364eb50, 0x364ebc8, 0x364ec40, 0x364ecb8, 0x364ed30, 0x364eda8, 0x364ee20, 0x364ee98, 0x364ef10, 0x364ef88, 0x364f000, 0x364f078, 0x364f0f0, 0x364f168, 0x364f1e0, 0x364f258, 0x364f2d0, 0x364f348, 0x364f3c0, 0x364f438, 0x364f4b0, 0x364f528, 0x364f5a0, 0x364f618, 0x364f690, 0x364f708, 0x364f780, 0x364f7f8, 0x7d3b3a6f035330d8, 0x364f8e8, 0x40, 0x7f7780aa9e40, 0x7f7780aa9ce0, 0xa79662, 0x364fb40, 0xa797e2, 0x2bd80aa9d10, 0x2cc00c470b0, 0xc470b0, 0x10cb900, 0x7f7780aa9d30, 0x10cb910, 0x7f7780aa9d30, 0x996977, 0xc5926f, 0x10cb900, 0x7f7780aa9d60, 0x99799f, 0x0, 0x7f7783ffedc8, 0x990653, 0x7f7783ffee80} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 140151236500992 offs = 10049558 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 1 combined_buf = 0x7f7783ffee80 "0\224\256\003" combined_buf2 = 0x203655c28
ret = 140151236500992 n = 256 i = 256 now = 1389305502 #4 0x00000000009c8481 in fil_aio_wait (segment=7) at fil/fil0fil.c:5480 ret = 9738095 fil_node = 0x7f7780aa9e60 message = 0x10c4890 type = 140151236501088 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48f8) at srv/srv0start.c:476 segment = 7 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 2 (Thread 0x7f7791332700 (LWP 6693)): #0 0x000000391b00b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a79938 in safe_cond_wait (cond=0x3655568, mp=0x36554f0, file=0xc470b0 "os/os0sync.c", line=402) at thr_mutex.c:239 error = 0 #2 0x00000000008fa8c5 in os_event_wait_low (event=0x36554f0, reset_sig_count=0) at os/os0sync.c:402 old_signal_count = 177 #3 0x00000000008f9602 in os_aio_simulated_handle (global_segment=1, message1=0x7f7791331e40, message2=0x7f7791331e38, type=0x7f7791331e30, space_id=0x7f7791331e28) at os/os0file.c:4421 array = 0x3084720 slot = 0x3642ad8 slot2 = 0x7f7791331d90 consecutive_ios = {0x0 , 0x3aec548, 0x0, 0x391b00a6f7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0xa79662, 0x0, 0xa797e2, 0x2bd00000000, 0x2cc00c470b0, 0xc470b0, 0x3087dc0, 0x2bd00000000, 0x1b00b4d6, 0x3e00000000, 0x3aec348, 0x7f7791331c90, 0x8fae99, 0xc470b0, 0x3087dc0, 0x7f7791331cb0, 0x8fac42, 0x3aec520, 0x3087960, 0x7f7791331ce0, 0x94cdc1, 0x7f7791331ce0, 0x3085600, 0xc786350ad825eed3, 0x1, 0x40, 0x7f7791331e40, 0x7f7791331d10, 0xa79662, 0x0, 0xa797e2, 0x2bd91331d40, 0x2cc00c470b0, 0xc470b0, 0x3aec760, 0x0, 0x142f, 0x0, 0x7f7791331e40, 0x7f7791331d70, 0x8fae99} lowest_request = 0x0 oldest_request = 0x0 n_consecutive = 0 total_len = 140151513882032 offs = 61784920 lowest_offset = 18446744073709551614 oldest_offset = 18446744073709551614 biggest_age = 0 age = 61784904 combined_buf = 0x7f7791331dd0 "" combined_buf2 = 0x8e5adb "\017\266\005\066\333}" ret = 140151513882112 n = 256 i = 256 now = 1389305502 #4 0x00000000009c8481 in fil_aio_wait (segment=1) at fil/fil0fil.c:5480 ret = 9738095 fil_node = 0x7f7791331e60 message = 0x10c4890 type = 140151513882208 space_id = 0 #5 0x000000000094a2c7 in io_handler_thread (arg=0x10c48c8) at srv/srv0start.c:476 segment = 1 #6 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 1 (Thread 0x7f7790565700 (LWP 7067)): #0 0x000000391b00c69c in pthread_kill () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a6ea60 in my_write_core (sig=11) at stacktrace.c:437 No locals. #2 0x00000000007c403e in handle_fatal_signal (sig=11) at signal_handler.cc:249 curr_time = 1389305508 thrs = 385918 mins = 11 hrs_buf = "22" hrs = 22 mins_buf = "11" secs_buf = "48" tmins = 23155091 secs = 48 thd = 0x3bca3d0 #3 No symbol table info available. #4 0x00000000008b7a64 in build_template (prebuilt=0x7f773407dd38, thd=0x3bca3d0, table=0x7f77340091c0, templ_type=0) at handler/ha_innodb.cc:5298 field = 0x7f773400c6e0 n_fields = 90 fetch_primary_key_cols = 0 n_requested_fields = 31 fetch_all_in_key = 0 mysql_prefix_len = 154 index = 0x7f7734083498 clust_index = 0x7f7734083498 templ = 0x7f7734016948 i = 30 #5 0x00000000008ba1d0 in ha_innobase::change_active_index (this=0x7f7734009e70, keynr=0) at handler/ha_innodb.cc:6511 _db_func_ = 0xaff15f "ha_rnd_init" _db_file_ = 0xaff11f "handler.h" dbug_violation_helper = {_entered = true} _db_level_ = 11 _db_framep_ = 0x7f773c0009d0 #6 0x00000000008ba889 in ha_innobase::rnd_init (this=0x7f7734009e70, scan=true) at handler/ha_innodb.cc:6722 err = 32631 #7 0x0000000000568d33 in handler::ha_rnd_init (this=0x7f7734009e70, scan=true) at handler.h:1225 _db_func_ = 0xbfc8d8 "init_read_record" _db_file_ = 0xbfc8cd "records.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "int handler::ha_rnd_init(bool)" result = 265 _db_level_ = 10 _db_framep_ = 0x7f773c0008c0 #8 0x000000000079f004 in init_read_record (info=0x7f773c0526d0, thd=0x3bca3d0, table=0x7f77340091c0, select=0x7f773c052a48, use_record_cache=1, print_error=true, disable_rr_cache=false) at records.cc:267 tempfile = 0x0 _db_func_ = 0xbdbb06 "do_select" _db_file_ = 0xbdad16 "sql_select.cc" dbug_violation_helper = {_entered = true} _db_level_ = 9 _db_framep_ = 0xa7c055 #9 0x00000000006f6c5f in join_init_read_record (tab=0x7f773c052650) at sql_select.cc:12246 No locals. #10 0x00000000006f5034 in sub_select (join=0x7f773c050c80, join_tab=0x7f773c052650, end_of_records=false) at sql_select.cc:11515 error = 12431739 rc = NESTED_LOOP_OK info = 0x7f773c0526d0 #11 0x00000000006f53d7 in evaluate_join_record (join=0x7f773c050c80, join_tab=0x7f773c0523f8, error=0) at sql_select.cc:11642 rc = 32631 found = true not_used_in_distinct = false found_records = 0 select_cond = 0x0 select_cond_result = true #12 0x00000000006f507c in sub_select (join=0x7f773c050c80, join_tab=0x7f773c0523f8, end_of_records=false) at sql_select.cc:11522 error = 0 rc = NESTED_LOOP_OK info = 0x7f773c052478 #13 0x00000000006f4b75 in do_select (join=0x7f773c050c80, fields=0x7f77905634b0, table=0x0, procedure=0x0) at sql_select.cc:11274 _db_func_ = 0xbdb076 "JOIN::exec" _db_file_ = 0xbdad16 "sql_select.cc" _db_level_ = 8 _db_framep_ = 0xa7a3f0 dbug_violation_helper = {_entered = true} end_select = 0x6f7211 __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" rc = 0 error = NESTED_LOOP_OK join_tab = 0x7f773c0523f8 #14 0x00000000006dd572 in JOIN::exec (this=0x7f773c050c80) at sql_select.cc:2377 _db_func_ = 0xbdb1ad "mysql_select" _db_file_ = 0xbdad16 "sql_select.cc" _db_level_ = 7 _db_framep_ = 0x0 dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "void JOIN::exec()" tmp_error = 0 curr_join = 0x7f773c050c80 curr_fields_list = 0x7f77905634b0 columns_list = 0x7f77905634b0 curr_all_fields = 0x7f773c052270 curr_tmp_table = 0x0 #15 0x00000000006dddf8 in mysql_select (thd=0x3bca3d0, rref_pointer_array=0x3bcc828, tables=0x7f773c004d48, wild_num=0, fields=..., conds=0x7f773c005858, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f773c0059e0, unit=0x3bcc218, select_lex=0x3bcc640) at sql_select.cc:2587 err = false free_join = true _db_func_ = 0xbe58e8 "mysql_multi_update" _db_file_ = 0xbe56b9 "sql_update.cc" dbug_violation_helper = {_entered = true} join = 0x7f773c050c80 _db_level_ = 6 _db_framep_ = 0x7f77905634b0 #16 0x000000000072613e in mysql_multi_update (thd=0x3bca3d0, table_list=0x7f773c004d48, fields=0x3bcc750, values=0x3bccb50, conds=0x7f773c005858, options=0, handle_duplicates=DUP_ERROR, ignore=true, unit=0x3bcc218, select_lex=0x3bcc640) at sql_update.cc:1286 _db_func_ = 0xb81991 "mysql_execute_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} result = 0x7f773c0059e0 res = false _db_level_ = 5 _db_framep_ = 0xb81380 total_list = { = { = {}, first = 0x10b24a0, last = 0x7f77905634b0, elements = 0}, } #17 0x000000000066a182 in mysql_execute_command (thd=0x3bca3d0) at sql_parse.cc:3431 up_result = 0 select_lex = 0x3bcc640 unit = 0x3bcc218 _db_func_ = 0xb82559 "mysql_parse" _db_file_ = 0xb81380 "sql_parse.cc" __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" have_table_map_for_update = false _db_level_ = 4 _db_framep_ = 0x7f773c0009d0 lex = 0x3bcc168 first_table = 0x7f773c004d48 dbug_violation_helper = {_entered = true} res = 0 need_start_waiting = true all_tables = 0x7f773c004d48 #18 0x0000000000672e78 in mysql_parse (thd=0x3bca3d0, rawbuf=0x7f773c004ae0 "UPDATE IGNORE `table100_innodb_compressed` t1, `table500_innodb_dynamic_int` t2 SET t1.`col_int_unsigned` = 0 WHERE t1.`col_char_latin1_default_null` <= NULL", length=158, found_semicolon=0x7f7790564c20) at sql_parse.cc:6350 lex = 0x3bcc168 parser_state = {m_lip = {m_thd = 0x3bca3d0, yylineno = 1, yytoklen = 28, yylval = 0x7f7790562b30, m_ptr = 0x7f773c004b7f "\004", m_tok_start = 0x7f773c004b7f "\004", m_tok_end = 0x7f773c004b7f "\004", m_end_of_query = 0x7f773c004b7e "", m_tok_start_prev = 0x7f773c004b7e "", m_buf = 0x7f773c004ae0 "UPDATE IGNORE `table100_innodb_compressed` t1, `table500_innodb_dynamic_int` t2 SET t1.`col_int_unsigned` = 0 WHERE t1.`col_char_latin1_default_null` <= NULL", m_buf_length = 158, m_echo = true, m_echo_saved = 127, m_cpp_buf = 0x7f773c004bf8 "UPDATE IGNORE `table100_innodb_compressed` t1, `table500_innodb_dynamic_int` t2 SET t1.`col_int_unsigned` = 0 WHERE t1.`col_char_latin1_default_null` <= NULL", m_cpp_ptr = 0x7f773c004c96 "", m_cpp_tok_start = 0x7f773c004c96 "", m_cpp_tok_start_prev = 0x7f773c004c96 "", m_cpp_tok_end = 0x7f773c004c96 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0xb81452 "query", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 60 '<', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 10986480, m_cpp_text_start = 0x7f773c004c71 "col_char_latin1_default_null` <= NULL", m_cpp_text_end = 0x7f773c004c8d "` <= NULL", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0}} err = false _db_func_ = 0xb81581 "dispatch_command" _db_file_ = 0xb81380 "sql_parse.cc" tp = {tv_sec = 140151499408444, tv_nsec = 140151499408448} end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, const char**)" _db_level_ = 3 _db_framep_ = 0x7f7790564430 end_time = {tv_sec = 140151499408456, tv_usec = 2143201129201} start_usecs = 0 cputime_error = 0 dbug_violation_helper = {_entered = true} end_time_error = 0 start_time = {tv_sec = 62698120, tv_usec = 140151499408431} end_usecs = 0 start_time_error = 0 start_cpu_nsecs = 0 #19 0x0000000000664aaa in dispatch_command (command=COM_QUERY, thd=0x3bca3d0, packet=0x3ba8971 "UPDATE IGNORE `table100_innodb_compressed` t1, `table500_innodb_dynamic_int` t2 SET t1.`col_int_unsigned` = 0 WHERE t1.`col_char_latin1_default_null` <= NULL", packet_length=158) at sql_parse.cc:1319 packet_end = 0x7f773c004b7e "" end_of_stmt = 0x0 net = 0x3bca538 _db_func_ = 0xb814e8 "do_command" _db_file_ = 0xb81380 "sql_parse.cc" dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_level_ = 2 _db_framep_ = 0x7f7790564d50 #20 0x000000000066386f in do_command (thd=0x3bca3d0) at sql_parse.cc:908 return_value = false packet = 0x3ba8970 "\003UPDATE IGNORE `table100_innodb_compressed` t1, `table500_innodb_dynamic_int` t2 SET t1.`col_int_unsigned` = 0 WHERE t1.`col_char_latin1_default_null` <= NULL" command = COM_QUERY _db_func_ = 0xc78934 "?func" _db_file_ = 0xc7893a "?file" _db_level_ = 1 _db_framep_ = 0x6615de dbug_violation_helper = {_entered = true} __PRETTY_FUNCTION__ = "bool do_command(THD*)" packet_length = 159 net = 0x3bca538 #21 0x000000000066196f in handle_one_connection (arg=0x3bca3d0) at sql_connect.cc:2099 net = 0x3bca538 create_user = true thd = 0x3bca3d0 #22 0x000000391b007851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #23 0x000000391a8e811d in clone () from /lib64/libc.so.6 No symbol table info available.