Comment 16 for bug 1212955

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

With wsrep_debug it crashed as:
.........

130827 17:26:43 [Note] WSREP: BF Aborted, thd: 25 is_AC: 0, retry: 0 - 1 SQL: UPDATE IGNORE `table100_innodb_int_autoinc` AS X SET `col_char_12` = 'v' WHERE X . `col_char_12_key` < 195 ORDER BY `col_char_12`,`col
 _char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5
 InnoDB: DEBUG: update_statistics for test/table1000_innodb_key_pk_parts_2_int#P#p0.
 InnoDB: DEBUG: update_statistics for test/table1000_innodb_key_pk_parts_2_int#P#p1.
 130827 17:26:43 [ERROR] WSREP: galera/src/fsm.hpp:shift_to():77: FSM: no such a transition EXECUTING -> COMMITTED
 11:56:43 UTC - mysqld got signal 6 ;
 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.
 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.
 Please help us make Percona Server better by reporting any
 bugs at http://bugs.percona.com/

 key_buffer_size=8388608
 read_buffer_size=131072
 max_used_connections=20
 max_threads=153
 thread_count=19
 connection_count=19
 It is possible that mysqld could use up to
 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 343058 K bytes of memory
 Hope that's ok; if not, decrease some variables in the equation.

 Thread pointer: 0x2b9d730
 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 = 7ff73c0e1e68 thread_stack 0x40000
 /pxc/bin/mysqld(my_print_stacktrace+0x2c)[0x811e1a]
 /pxc/bin/mysqld(handle_fatal_signal+0x30f)[0x6d1c6b]
 /usr/lib/libpthread.so.0(+0xf870)[0x7ff74ea46870]
 /usr/lib/libc.so.6(gsignal+0x39)[0x7ff74d1f33d9]
 /usr/lib/libc.so.6(abort+0x148)[0x7ff74d1f47d8]
 /pxc/lib/libgalera_smm.so(_ZN6galera3FSMINS_9TrxHandle5StateENS1_10TransitionENS_10EmptyGuardENS_11EmptyActionEE8shift_toES2_+0x17c)[0x7ff74c54475c]
 /pxc/lib/libgalera_smm.so(_ZN6galera13ReplicatorSMM11post_commitEPNS_9TrxHandleE+0xcd)[0x7ff74c53af1d]
 /pxc/lib/libgalera_smm.so(galera_post_commit+0x46)[0x7ff74c54e2f6]
 /pxc/bin/mysqld(_Z25wsrep_cleanup_transactionP3THD+0x6a)[0x67dc5a]
 /pxc/bin/mysqld[0x6d3bbc]
 /pxc/bin/mysqld(_Z15ha_commit_transP3THDb+0x6a4)[0x6d59f4]
 /pxc/bin/mysqld(_Z21trans_commit_implicitP3THD+0x99)[0x6671cd]
 /pxc/bin/mysqld(_Z21mysql_execute_commandP3THD+0x4f9)[0x59e741]
 /pxc/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20a)[0x5a6e41]
 /pxc/bin/mysqld[0x5a7ab3]
 /pxc/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xa62)[0x5a8a89]
 /pxc/bin/mysqld(_Z10do_commandP3THD+0x6c0)[0x5aa994]
 /pxc/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x143)[0x65834a]
 /pxc/bin/mysqld(handle_one_connection+0x49)[0x65857e]
 /usr/lib/libpthread.so.0(+0x80a2)[0x7ff74ea3f0a2]
 /usr/lib/libc.so.6(clone+0x6d)[0x7ff74d2a2a2d]

 Trying to get some variables.
 Some pointers may be invalid and cause the dump to abort.
 Query (7ff6d0004c10): DROP TABLE IF EXISTS b
 Connection ID (thread ID): 24
 Status: KILL_QUERY

 You may download the Percona Server operations manual by visiting
 http://www.percona.com/software/percona-server/. You may find information
 in the manual which will help you identify the cause of the crash.
 Writing a core file

===========================================================

Complete log attached above.