Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.35
-
None
-
centos 5/6, x86_64
Description
Hello,
we had an issue with mariadb 5.5.35 and couldn't reproduce the problem.
OS - Centos 6.
140211 12:43:57 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see http://kb.askmonty.org/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 5.5.35-MariaDB-log
|
key_buffer_size=268435456
|
read_buffer_size=131072
|
max_used_connections=727
|
max_threads=742
|
thread_count=585
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 24684221 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0x7fbd83a4d7e0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7fa027b6ed58 thread_stack 0x48000
|
(my_addr_resolve failure: fork)
|
/usr/libexec/mysqld(my_print_stacktrace+0x2e) [0x7fbcd586cc5e]
|
/usr/libexec/mysqld(handle_fatal_signal+0x4ac) [0x7fbcd54b551c]
|
/lib64/libpthread.so.0(+0x3578c0f500) [0x7fbcd4be1500]
|
/usr/libexec/mysqld(+0x7660e0) [0x7fbcd57770e0]
|
/usr/libexec/mysqld(+0x76684c) [0x7fbcd577784c]
|
/usr/libexec/mysqld(+0x7533be) [0x7fbcd57643be]
|
/usr/libexec/mysqld(+0x74f5d7) [0x7fbcd57605d7]
|
/usr/libexec/mysqld(+0x751ecf) [0x7fbcd5762ecf]
|
/usr/libexec/mysqld(+0x744c99) [0x7fbcd5755c99]
|
/usr/libexec/mysqld(+0x6f94f7) [0x7fbcd570a4f7]
|
/usr/libexec/mysqld(+0x6c9984) [0x7fbcd56da984]
|
/usr/libexec/mysqld(handler::read_range_next()+0x7a) [0x7fbcd54b6dba]
|
/usr/libexec/mysqld(handler::multi_range_read_next(void**)+0xb2) [0x7fbcd5460182]
|
/usr/libexec/mysqld(Mrr_simple_index_reader::get_next(void**)+0x20) [0x7fbcd5460240]
|
/usr/libexec/mysqld(DsMrr_impl::dsmrr_next(void**)+0x2f) [0x7fbcd54604ff]
|
/usr/libexec/mysqld(QUICK_RANGE_SELECT::get_next()+0x52) [0x7fbcd558a7b2]
|
/usr/libexec/mysqld(QUICK_ROR_INTERSECT_SELECT::get_next()+0x23e) [0x7fbcd558bffe]
|
/usr/libexec/mysqld(+0x597b68) [0x7fbcd55a8b68]
|
/usr/libexec/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x1ee) [0x7fbcd53aa75e]
|
/usr/libexec/mysqld(+0x39ca05) [0x7fbcd53ada05]
|
/usr/libexec/mysqld(JOIN::exec()+0x739) [0x7fbcd53c7639]
|
/usr/libexec/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x128) [0x7fbcd53c96b8]
|
/usr/libexec/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x2b3) [0x7fbcd53ca2d3]
|
/usr/libexec/mysqld(+0x36535f) [0x7fbcd537635f]
|
/usr/libexec/mysqld(mysql_execute_command(THD*)+0x30b5) [0x7fbcd537d435]
|
/usr/libexec/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x142) [0x7fbcd53805e2]
|
/usr/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x175b) [0x7fbcd5381ddb]
|
/usr/libexec/mysqld(do_handle_one_connection(THD*)+0xff) [0x7fbcd543599f]
|
/usr/libexec/mysqld(handle_one_connection+0x51) [0x7fbcd5435ae1]
|
/usr/libexec/mysqld(+0x829ed8) [0x7fbcd583aed8]
|
/lib64/libpthread.so.0(+0x3578c07851) [0x7fbcd4bd9851]
|
/lib64/libc.so.6(clone+0x6d) [0x7fbcd34f994d]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fa174dab928): is an invalid pointer
|
Connection ID (thread ID): 49263308
|
Status: NOT_KILLED
|
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off
|
|
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
140211 12:43:58 mysqld_safe Number of processes running now: 0
|
140211 12:43:58 mysqld_safe mysqld restarted
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
Sorry for the delay... Wasn't able to do right away, and forgot about this for a bit.
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fb2287fd700 (LWP 2715)]
0x00007fb396d37925 in raise () from /lib64/libc.so.6
(gdb) thread apply all bt
Thread 27 (Thread 0x7fb394bff700 (LWP 2698)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 26 (Thread 0x7fb23bbfe700 (LWP 2699)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 25 (Thread 0x7fb23b1fd700 (LWP 2700)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 24 (Thread 0x7fb23a7fc700 (LWP 2701)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 23 (Thread 0x7fb239dfb700 (LWP 2702)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
--Type <return> to continue, or q <return> to quit--
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 22 (Thread 0x7fb2393fa700 (LWP 2703)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 21 (Thread 0x7fb2389f9700 (LWP 2704)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 20 (Thread 0x7fb237ff8700 (LWP 2705)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 19 (Thread 0x7fb2375f7700 (LWP 2706)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 18 (Thread 0x7fb236bf6700 (LWP 2707)):
--Type <return> to continue, or q <return> to quit--
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 17 (Thread 0x7fb2361f5700 (LWP 2708)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 16 (Thread 0x7fb2357f4700 (LWP 2709)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 15 (Thread 0x7fb234df3700 (LWP 2710)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 14 (Thread 0x7fb2343f2700 (LWP 2711)):
#0 0x000000000094bf74 in __io_getevents_0_4 ()
#1 0x0000000000922a74 in os_aio_linux_handle ()
#2 0x00000000008d5793 in fil_aio_wait ()
#3 0x0000000000844e68 in io_handler_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
--Type <return> to continue, or q <return> to quit--
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 13 (Thread 0x7fb2291fe700 (LWP 2714)):
#0 0x00007fb3984d298e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x000000000092482b in os_event_wait_time_low ()
#2 0x0000000000841890 in srv_lock_timeout_thread ()
#3 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#4 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 12 (Thread 0x7fb2287fd700 (LWP 2715)):
#0 0x00007fb396d37925 in raise () from /lib64/libc.so.6
#1 0x00007fb396d39105 in abort () from /lib64/libc.so.6
#2 0x00000000008420e3 in srv_error_monitor_thread ()
#3 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#4 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 11 (Thread 0x7fb227dfc700 (LWP 2716)):
#0 0x00007fb3984d298e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x000000000092482b in os_event_wait_time_low ()
#2 0x00000000008415a3 in srv_monitor_thread ()
#3 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#4 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 10 (Thread 0x7fb2273fb700 (LWP 2717)):
#0 0x00007fb3984d298e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x000000000092482b in os_event_wait_time_low ()
#2 0x0000000000842163 in srv_LRU_dump_restore_thread ()
#3 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#4 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 9 (Thread 0x7fb2269fa700 (LWP 2718)):
#0 0x00007fb3984d25bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000924721 in os_event_wait_low ()
#2 0x000000000089b850 in buf_flush_wait_batch_end ()
#3 0x000000000084360c in srv_master_thread ()
#4 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#5 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
--Type <return> to continue, or q <return> to quit--
Thread 8 (Thread 0x7fb225ff9700 (LWP 2719)):
#0 0x00007fb3984d25bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000924721 in os_event_wait_low ()
#2 0x0000000000844aae in srv_purge_thread ()
#3 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#4 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 7 (Thread 0x7fb21d7ff700 (LWP 2720)):
#0 0x00007fb3984d298e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x000000000099f5c7 in my_service_thread_sleep ()
#2 0x0000000000997de2 in ma_checkpoint_background ()
#3 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#4 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 6 (Thread 0x7fb21cdfe700 (LWP 2721)):
#0 0x00007fb3984d64b5 in sigwait () from /lib64/libpthread.so.0
#1 0x000000000051f76f in signal_hand ()
#2 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#3 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 5 (Thread 0x7fb21bfff700 (LWP 3123)):
#0 0x00007fb3984d575d in read () from /lib64/libpthread.so.0
#1 0x0000000000a9f558 in vio_read ()
#2 0x0000000000527b81 in my_real_read(st_net*, unsigned long*) ()
#3 0x0000000000528a49 in my_net_read ()
#4 0x00000000005a4012 in do_command(THD*) ()
#5 0x00000000006533cb in do_handle_one_connection(THD*) ()
#6 0x000000000065344c in handle_one_connection ()
#7 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#8 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 4 (Thread 0x7fb21bfb6700 (LWP 3125)):
#0 0x0000000000a7273c in my_pthread_fastmutex_lock ()
#1 0x000000000092469d in os_event_reset ()
#2 0x00000000008487ac in sync_array_reserve_cell ()
#3 0x000000000084a07e in mutex_spin_wait ()
--Type <return> to continue, or q <return> to quit--
#4 0x00000000008a37a3 in buf_LRU_free_from_common_LRU_list ()
#5 0x00000000008a532f in buf_LRU_get_free_block ()
#6 0x0000000000894133 in buf_page_create ()
#7 0x00000000008dabc8 in fsp_page_create ()
#8 0x00000000008de6b8 in fseg_alloc_free_page_low ()
#9 0x00000000008e155b in fseg_alloc_free_page_general ()
#10 0x000000000086e000 in btr_page_split_and_insert ()
#11 0x00000000008793d6 in btr_cur_pessimistic_insert ()
#12 0x000000000093d655 in row_ins_index_entry_low ()
#13 0x0000000000940f30 in row_ins_step ()
#14 0x0000000000825f00 in row_insert_for_mysql ()
#15 0x000000000080e830 in ha_innobase::write_row(unsigned char*) ()
#16 0x00000000006d4e88 in handler::ha_write_row(unsigned char*) ()
#17 0x0000000000a4444f in ha_partition::write_row(unsigned char*) ()
#18 0x00000000006d4e88 in handler::ha_write_row(unsigned char*) ()
#19 0x00000000005856a2 in write_record(THD*, TABLE*, st_copy_info*) ()
#20 0x0000000000585f83 in select_insert::send_data(List<Item>&) ()
#21 0x00000000005bc7b6 in end_send(JOIN*, st_join_table*, bool) ()
#22 0x00000000005bcb22 in evaluate_join_record(JOIN*, st_join_table*, int) ()
#23 0x00000000005bcdf9 in sub_select(JOIN*, st_join_table*, bool) ()
#24 0x00000000005d3acd in do_select(JOIN*, List<Item>, TABLE, Procedure*) ()
#25 0x00000000005e8ccc in JOIN::exec() ()
#26 0x00000000005e4095 in mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) ()
#27 0x00000000005eac83 in handle_select(THD*, LEX*, select_result*, unsigned long) ()
#28 0x00000000005a0e76 in mysql_execute_command(THD*) ()
#29 0x00000000005a1ab4 in mysql_parse ()
#30 0x00000000005a3f2e in dispatch_command(enum_server_command, THD*, char*, unsigned int) ()
#31 0x00000000006533cb in do_handle_one_connection(THD*) ()
#32 0x000000000065344c in handle_one_connection ()
#33 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#34 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 3 (Thread 0x7fb21bf6d700 (LWP 3126)):
#0 0x00007fb3984d25bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000924721 in os_event_wait_low ()
#2 0x0000000000848bae in sync_array_wait_event ()
--Type <return> to continue, or q <return> to quit--
#3 0x0000000000849900 in rw_lock_s_lock_spin ()
#4 0x000000000089aefe in buf_flush_try_neighbors ()
#5 0x000000000089b64b in buf_flush_flush_list_batch ()
#6 0x000000000089be5d in buf_flush_list ()
#7 0x000000000090d9de in log_check_margins ()
#8 0x000000000093d317 in row_ins_index_entry_low ()
#9 0x0000000000940e68 in row_ins_step ()
#10 0x0000000000825f00 in row_insert_for_mysql ()
#11 0x000000000080e830 in ha_innobase::write_row(unsigned char*) ()
#12 0x00000000006d4e88 in handler::ha_write_row(unsigned char*) ()
#13 0x0000000000a4444f in ha_partition::write_row(unsigned char*) ()
#14 0x00000000006d4e88 in handler::ha_write_row(unsigned char*) ()
#15 0x00000000005856a2 in write_record(THD*, TABLE*, st_copy_info*) ()
#16 0x0000000000585f83 in select_insert::send_data(List<Item>&) ()
#17 0x00000000005bc7b6 in end_send(JOIN*, st_join_table*, bool) ()
#18 0x00000000005bcb22 in evaluate_join_record(JOIN*, st_join_table*, int) ()
#19 0x00000000005bcdf9 in sub_select(JOIN*, st_join_table*, bool) ()
#20 0x00000000005d3acd in do_select(JOIN*, List<Item>, TABLE, Procedure*) ()
#21 0x00000000005e8ccc in JOIN::exec() ()
#22 0x00000000005e4095 in mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) ()
#23 0x00000000005eac83 in handle_select(THD*, LEX*, select_result*, unsigned long) ()
#24 0x00000000005a0e76 in mysql_execute_command(THD*) ()
#25 0x00000000005a1ab4 in mysql_parse ()
#26 0x00000000005a3f2e in dispatch_command(enum_server_command, THD*, char*, unsigned int) ()
#27 0x00000000006533cb in do_handle_one_connection(THD*) ()
#28 0x000000000065344c in handle_one_connection ()
#29 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#30 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 2 (Thread 0x7fb21bf24700 (LWP 3127)):
#0 0x00007fb3984d25bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000924721 in os_event_wait_low ()
#2 0x000000000089b850 in buf_flush_wait_batch_end ()
#3 0x000000000090de63 in log_check_margins ()
#4 0x000000000093d317 in row_ins_index_entry_low ()
#5 0x0000000000940e68 in row_ins_step ()
--Type <return> to continue, or q <return> to quit--
#6 0x0000000000825f00 in row_insert_for_mysql ()
#7 0x000000000080e830 in ha_innobase::write_row(unsigned char*) ()
#8 0x00000000006d4e88 in handler::ha_write_row(unsigned char*) ()
#9 0x0000000000a4444f in ha_partition::write_row(unsigned char*) ()
#10 0x00000000006d4e88 in handler::ha_write_row(unsigned char*) ()
#11 0x00000000005856a2 in write_record(THD*, TABLE*, st_copy_info*) ()
#12 0x0000000000585f83 in select_insert::send_data(List<Item>&) ()
#13 0x00000000005bc7b6 in end_send(JOIN*, st_join_table*, bool) ()
#14 0x00000000005bcb22 in evaluate_join_record(JOIN*, st_join_table*, int) ()
#15 0x00000000005bcdf9 in sub_select(JOIN*, st_join_table*, bool) ()
#16 0x00000000005d3acd in do_select(JOIN*, List<Item>, TABLE, Procedure*) ()
#17 0x00000000005e8ccc in JOIN::exec() ()
#18 0x00000000005e4095 in mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) ()
#19 0x00000000005eac83 in handle_select(THD*, LEX*, select_result*, unsigned long) ()
#20 0x00000000005a0e76 in mysql_execute_command(THD*) ()
#21 0x00000000005a1ab4 in mysql_parse ()
#22 0x00000000005a3f2e in dispatch_command(enum_server_command, THD*, char*, unsigned int) ()
#23 0x00000000006533cb in do_handle_one_connection(THD*) ()
#24 0x000000000065344c in handle_one_connection ()
#25 0x00007fb3984ce9d1 in start_thread () from /lib64/libpthread.so.0
#26 0x00007fb396dedb6d in clone () from /lib64/libc.so.6
Thread 1 (Thread 0x7fb3988f1840 (LWP 2696)):
#0 0x00007fb396de4343 in poll () from /lib64/libc.so.6
#1 0x0000000000523073 in handle_connections_sockets() ()
#2 0x0000000000526db2 in mysqld_main(int, char**) ()
#3 0x00007fb396d23d1d in __libc_start_main () from /lib64/libc.so.6
#4 0x000000000051d149 in _start ()
(gdb)
This does not look similar to original problem, it looks like more a long semaphore wait problem.
I don't know, it seems to crash differently each time, but if we are getting random corruption is that unexpected? It is on slower storage right now than when I was testing originally. Tight on SSD storage right now so don't know if I'll be able to move it to fast storage again (but we did just order some new servers, not sure how many weeks that might take).
Even if it's just a semaphore wait problem in this case, shouldn't it do a deadlock detection or something and abort some threads and not crash mysql? or is gdb intercepting that?
There is no deadlock detection on semaphore waits, only timeout and then it stops
Hi,
About the stack, it does not look correct.
#2 0x000000000089829c in buf_flush_buffered_writes.part.7 ()#3 0x000000000089add6 in buf_flush_try_neighbors ()There is no function called buf_flush_buffered_writes.part.7 and buf_flush_buffered_writes is not called from buf_flush_try_neighbors. Could you try again and please send me output from following command from gdb/ddd:
thread apply all bt