Skip to content

Instantly share code, notes, and snippets.

@peppy
Created January 25, 2013 03:21
Show Gist options
  • Save peppy/4631468 to your computer and use it in GitHub Desktop.
Save peppy/4631468 to your computer and use it in GitHub Desktop.
Percona Server 5.5.28-29.1-log crash
Jan 24 14:06:05 db mysqld: 20:06:05 UTC - mysqld got signal 11 ;
Jan 24 14:06:05 db mysqld: This could be because you hit a bug. It is also possible that this binary
Jan 24 14:06:05 db mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Jan 24 14:06:05 db mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Jan 24 14:06:05 db mysqld: We will try our best to scrape up some info that will hopefully help
Jan 24 14:06:05 db mysqld: diagnose the problem, but since we have already crashed,
Jan 24 14:06:05 db mysqld: something is definitely wrong and this may fail.
Jan 24 14:06:05 db mysqld: Please help us make Percona Server better by reporting any
Jan 24 14:06:05 db mysqld: bugs at http://bugs.percona.com/
Jan 24 14:06:05 db mysqld:
Jan 24 14:06:05 db mysqld: key_buffer_size=1073741824
Jan 24 14:06:05 db mysqld: read_buffer_size=33554432
Jan 24 14:06:05 db mysqld: max_used_connections=605
Jan 24 14:06:05 db mysqld: max_threads=8000
Jan 24 14:06:05 db mysqld: thread_count=159
Jan 24 14:06:05 db mysqld: connection_count=158
Jan 24 14:06:05 db mysqld: It is possible that mysqld could use up to
Jan 24 14:06:05 db mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 525434638 K bytes of memory
Jan 24 14:06:05 db mysqld: Hope that's ok; if not, decrease some variables in the equation.
Jan 24 14:06:05 db mysqld:
Jan 24 14:06:05 db mysqld: Thread pointer: 0x7fa840064230
Jan 24 14:06:05 db mysqld: Attempting backtrace. You can use the following information to find out
Jan 24 14:06:05 db mysqld: where mysqld died. If you see no messages after this, something went
Jan 24 14:06:05 db mysqld: terribly wrong...
Jan 24 14:06:05 db mysqld: stack_bottom = 7fa89dc1ee88 thread_stack 0x30000
Jan 24 14:06:05 db mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7c6d05]
Jan 24 14:06:05 db mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x696c44]
Jan 24 14:06:05 db mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7fa90cb24030]
Jan 24 14:06:05 db mysqld: /usr/sbin/mysqld[0x967170]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(ft_boolean_read_next+0xd9)[0x967759]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_ZN9ha_myisam7ft_readEPh+0xe4)[0x9296d4]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_ZN9FT_SELECT8get_nextEv+0x1d)[0x5d6e8d]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z8filesortP3THDP5TABLEP13st_sort_fieldjP10SQL_SELECTybPy+0x12c3)[0x695893]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld[0x5ca6dd]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0xb5b)[0x5d47db]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12c)[0x5d602c]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cd)[0x5d6aed]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld[0x593b52]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1236)[0x597676]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x333)[0x59afa3]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x15cd)[0x59c61d]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xdf)[0x638f5f]
Jan 24 14:06:06 db mysqld: /usr/sbin/mysqld(handle_one_connection+0x51)[0x639091]
Jan 24 14:06:06 db mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x6b50)[0x7fa90cb1bb50]
Jan 24 14:06:06 db mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fa90bd9f70d]
Jan 24 14:06:06 db mysqld:
Jan 24 14:06:06 db mysqld: Trying to get some variables.
Jan 24 14:06:06 db mysqld: Some pointers may be invalid and cause the dump to abort.
Jan 24 14:06:06 db mysqld: Query (7fa854355010): is an invalid pointer
Jan 24 14:06:06 db mysqld: Connection ID (thread ID): 225399813
Jan 24 14:06:06 db mysqld: Status: NOT_KILLED
Jan 24 14:06:06 db mysqld:
Jan 24 14:06:06 db mysqld: You may download the Percona Server operations manual by visiting
Jan 24 14:06:06 db mysqld: http://www.percona.com/software/percona-server/. You may find information
Jan 24 14:06:06 db mysqld: in the manual which will help you identify the cause of the crash.
Jan 24 14:06:06 db mysqld_safe: Number of processes running now: 0
Jan 24 14:06:06 db mysqld_safe: mysqld restarted
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment