Percona Server moved to https://jira.percona.com/projects/PS

InnoDB: Failing assertion: rec_get_trx_id(btr_pcur_get_rec(pcur), index) == node->new_trx_id in file row0umod.cc line 338 | abort (sig=6) in row_undo_mod_clust

Bug #1381916 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Low
Unassigned
5.1
New
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
Triaged
Low
Unassigned

Bug Description

************** GDB info

+bt
#0 0x00007f8db995e771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab75b6 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-6
9.0/mysys/stacktrace.c:422
#2 0x000000000072fa2f in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.
6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f8db85625c9 in raise () from /lib64/libc.so.6
#5 0x00007f8db8563cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000d73608 in row_undo_mod_clust (node=0x7f8d4029ad58, thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label
_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0umod.cc:337
#7 0x0000000000d752b0 in row_undo_mod (node=0x7f8d4029ad58, thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/c
entos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0umod.cc:1152
#8 0x0000000000c0f2b6 in row_undo (node=0x7f8d4029ad58, thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/cento
s6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0undo.cc:308
#9 0x0000000000c0f3b4 in row_undo_step (thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-se
rver-5.6.21-69.0/storage/innobase/row/row0undo.cc:350
#10 0x0000000000b955c2 in que_thr_step (thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/que/que0que.cc:1113
#11 0x0000000000b95803 in que_run_threads_low (thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/que/que0que.cc:1177
#12 0x0000000000b959d2 in que_run_threads (thr=0x7f8d40289cd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/que/que0que.cc:1218
#13 0x0000000000c52b6f in trx_rollback_to_savepoint_low (trx=0x7f8d34002368, savept=0x7f8d34053a00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:109
#14 0x0000000000c52eb8 in trx_rollback_to_savepoint (trx=0x7f8d34002368, savept=0x7f8d34053a00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:151
#15 0x0000000000c539af in trx_rollback_to_savepoint_for_mysql_low (trx=0x7f8d34002368, savep=0x7f8d340539f8, mysql_binlog_cache_pos=0x7f8d82647818) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:364
#16 0x0000000000c53b11 in trx_rollback_to_savepoint_for_mysql (trx=0x7f8d34002368, savepoint_name=0x7f8d826477d0 "1DPNHY6A5C", mysql_binlog_cache_pos=0x7f8d82647818) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/trx/trx0roll.cc:422
#17 0x0000000000ad1944 in innobase_rollback_to_savepoint (hton=0x30606a0, thd=0x303e0a0, savepoint=0x7f8d40006ee0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:4325
#18 0x000000000064089c in ha_rollback_to_savepoint (thd=0x303e0a0, sv=0x7f8d40006eb0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:2119
#19 0x00000000008b7f06 in trans_rollback_to_savepoint (thd=0x303e0a0, name=...) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/transaction.cc:659
#20 0x00000000007e82a7 in mysql_execute_command (thd=0x303e0a0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:4798
#21 0x00000000007ed1c3 in mysql_parse (thd=0x303e0a0, rawbuf=0x7f8d40004e90 "rollback to savepoint `a``; create database couldbebadthingshere; savepoint ``dummy`", length=84, parser_state=0x7f8d82648d50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#22 0x00000000007df62c in dispatch_command (command=COM_QUERY, thd=0x303e0a0, packet=0x3843a11 "rollback to savepoint `a``; create database couldbebadthingshere; savepoint ``dummy`;", packet_length=85) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#23 0x00000000007de558 in do_command (thd=0x303e0a0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#24 0x00000000008c2c60 in threadpool_process_request (thd=0x303e0a0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#25 0x00000000008c55a2 in handle_event (connection=0x37dc0c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#26 0x00000000008c57d2 in worker_main (param=0x1898200 <all_groups+2048>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#27 0x0000000000dc5bdc in pfs_spawn_thread (arg=0x37c58c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#28 0x00007f8db9959df3 in start_thread () from /lib64/libpthread.so.0
#29 0x00007f8db862301d in clone () from /lib64/libc.so.6

Server version :
Percona-Server-5.6.21-rel69.0-676.Linux.x86_64-debug

I could not create a testcase. Attached core, datadir, gdb etc

See original description
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
description: updated
Revision history for this message
Roel Van de Paar (roel11) wrote :

============== Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 INT);
set autocommit=0;
INSERT INTO t1 VALUES(0xA6E8);
CREATE TABLE t1(i1 int key,f1 int)ENGINE=InnoDB PARTITION BY HASH(i1) PARTITIONS 2;
DELETE FROM t1;
SET innodb_fake_changes=1;
LOCK TABLE bug38231_1 WRITE;

============== PS 5.6.21-rel69.0-687, Optimized
mysql> LOCK TABLE bug38231_1 WRITE;
ERROR 1180 (HY000): Got error 131 during COMMIT

============== PS 5.6.21-rel69.0-687, debug
mysql> LOCK TABLE bug38231_1 WRITE;
ERROR 2013 (HY000): Lost connection to MySQL server during query

============== MS 5.6.20, debug
mysql> LOCK TABLE bug38231_1 WRITE;
ERROR 1146 (42S02): Table 'test.bug38231_1' doesn't exist

tags: added: fake-changes qa
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.