Comment 0 for bug 1208921

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Assertion failure in thread 140433424082688 in file ha_innodb.cc line 6207 | prebuilt->trx->conc_state == 1

Repeatable with RQG with galera grammar:

Hope that's ok; if not, decrease some variables in the equation. [2/740]
                                                                                                                                                                                                              [1/740]
Thread pointer: 0x28cc5a0 [0/740]
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 = 7fb9345b5e68 thread_stack 0x40000
/chip/bin/mysqld(my_print_stacktrace+0x2c)[0x8007ca]
/chip/bin/mysqld(handle_fatal_signal+0x2f9)[0x6c256d]
/usr/lib/libpthread.so.0(+0xf0e0)[0x7fb946c310e0]
/usr/lib/libc.so.6(gsignal+0x39)[0x7fb9453e01c9]
/usr/lib/libc.so.6(abort+0x148)[0x7fb9453e15c8]
/chip/bin/mysqld[0x815a1b]
/chip/bin/mysqld(_ZN12ha_partition10unlock_rowEv+0x4a)[0xa1774e]
/chip/bin/mysqld(_Z8filesortP3THDP5TABLEP13st_sort_fieldjP10SQL_SELECTybPy+0x1af6)[0x6c1483]
/chip/bin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyy+0x808)[0x7b76ab]
/chip/bin/mysqld(_Z21mysql_execute_commandP3THD+0x34a8)[0x59ff10]
/chip/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x142)[0x5a52e8]
/chip/bin/mysqld[0x5a5dfb]
/chip/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x994)[0x5a6d02]
/chip/bin/mysqld(_Z10do_commandP3THD+0x679)[0x5a8bd3]
/chip/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x13a)[0x64fbfd]
/chip/bin/mysqld(handle_one_connection+0x49)[0x64fded]
/usr/lib/libpthread.so.0(+0x7dd2)[0x7fb946c29dd2]
/usr/lib/libc.so.6(clone+0x6d)[0x7fb945490cdd]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fb900004c10): DELETE IGNORE FROM `table10000_innodb_key_pk_parts_2_int` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table1_innodb_int` WHERE `pk` = 0 ) ORDER BY `col_char_12`,`col_char_12_k
ey`,`col_int`,`col_int_key`,`pk` LIMIT 3
Connection ID (thread ID): 10
Status: NOT_KILLED

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.
Writing a core file
# 2013-08-06T22:18:32 [41182] datadir is /chip/mysql-test/var/node0/data/
# 2013-08-06T22:18:32 [41182] binary is /chip/../chip/bin/mysqld
# 2013-08-06T22:18:32 [41182] bindir is /chip/../chip/bin
# 2013-08-06T22:18:32 [41182] WARNING: Core file not found!
"/media/Tintin/Work/code/randgen/mariadb-patches" is not a core dump: Is a directory
backtrace.gdb:19: Error in sourced command file:
No stack.
# 2013-08-06T22:18:33 [41182] Whether to confirm potentially dangerous operations is on.
"/media/Tintin/Work/code/randgen/mariadb-patches" is not a core dump: Is a directory
# 2013-08-06T22:18:33 [41182] Whether to confirm potentially dangerous operations is on.
# 2013-08-06T22:18:33 [41182] Test completed with failure status STATUS_SERVER_CRASHED (101)
# 2013-08-06T22:18:33 [41182] GenTest exited with exit status STATUS_SERVER_CRASHED (101)
# 2013-08-06T22:18:33 [41182] Stopping server on port 19300
# 2013-08-06T22:18:33 [41182] Stale connection. Reconnecting
# 2013-08-06T22:18:33 [41182] Reconnect failed due to 2003:Can't connect to MySQL server on '127.0.0.1' (111)
# 2013-08-06T22:18:33 [41182] Server would not shut down properly. Terminate it
# 2013-08-06T22:18:33 [41182] Terminated process 41533
# 2013-08-06T22:18:33 [41182] Stopping server on port 19301
# 2013-08-06T22:18:33 [41182] Stale connection. Reconnecting
# 2013-08-06T22:18:33 [41182] [41182] runall-new.pl will exit with exit status STATUS_SERVER_CRASHED (101)
==============================================================================================

Cmdline:

perl runall-new.pl --basedir=/chip --galera=ms --grammar=$PWD/conf/galera/galera_stress.yy --gendata=$PWD/conf/galera/galera_stress.zz --threads=10 --queries=1000000 --mysqld=--wsrep-provider=/pxc/lib/libgalera_smm.so

The galera grammar from:
bzr+ssh://bazaar.launchpad.net/~elenst/randgen/mariadb-patches/