InnoDB: Failing assertion: (mode & ~16384) == BTR_MODIFY_LEAF in file row0ins.cc line 368 | abort (sig=6) in row_ins_clust_index_entry_by_modify | Now in file row0ins.cc line 365

Bug #1224272 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Medium
Unassigned
5.1
New
Medium
Unassigned
5.5
New
Medium
Unassigned
5.6
Triaged
Medium
Unassigned

Bug Description

Thread 26 (LWP 25375):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006f0d0d in handle_fatal_signal (sig=6) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000ab1034 in row_ins_clust_index_entry_by_modify (flags=0, mode=<optimized out>, cursor=0x1a0f1960, offsets=0x1a0f19f8, offsets_heap=0x1a0f19e8, heap=0x212ba230, big_rec=0x1a0f19f0, entry=0x2089e668, thr=0x19ff0bc0, mtr=0x1a0f1490) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:368
#6 0x0000000000ab1422 in row_ins_clust_index_entry_low (flags=0, mode=37, index=0x19e1b778, n_uniq=<optimized out>, entry=0x2089e668, n_ext=0, thr=0x19ff0bc0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:2435
#7 0x0000000000ab45e5 in row_ins_clust_index_entry (index=0x19e1b778, entry=0x2089e668, thr=0x19ff0bc0, n_ext=0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:2915
#8 0x0000000000ab4774 in row_ins_index_entry_step (node=0x19ff03a8, thr=0x19ff0bc0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:3086
#9 0x0000000000ab484b in row_ins (node=0x19ff03a8, thr=0x19ff0bc0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:3226
#10 0x0000000000ab4acb in row_ins_step (thr=0x19ff0bc0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:3351
#11 0x0000000000aca984 in row_insert_for_mysql (mysql_rec=<optimized out>, prebuilt=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0mysql.cc:1313
#12 0x0000000000a10278 in ha_innobase::write_row (this=0x20f200d0, record=0x2123a1c0 "-\001\302", <incomplete sequence \370>) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/ha_innodb.cc:6940
#13 0x0000000000642ef8 in handler::ha_write_row (this=0x20f200d0, buf=0x2123a1c0 "-\001\302", <incomplete sequence \370>) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/handler.cc:7448
#14 0x000000000076146c in write_record (thd=0x1a9bfc40, table=0x209abe90, info=0x1a0f2440, update=0x0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_insert.cc:1935
#15 0x00000000008d9834 in read_sep_field (thd=0x1a9bfc40, info=..., table_list=0x1a7467c8, fields_vars=..., set_fields=..., set_values=..., read_info=..., enclosed=..., skip_lines=0, ignore_check_option_errors=false) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_load.cc:1116
#16 0x00000000008dac58 in mysql_load (thd=<optimized out>, ex=0x1a7466c0, table_list=0x1a7467c8, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=DUP_ERROR, ignore=false, read_file_from_client=false) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_load.cc:506
#17 0x000000000077d434 in mysql_execute_command (thd=0x1a9bfc40) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:3909
#18 0x0000000000780188 in mysql_parse (thd=0x1a9bfc40, rawbuf=0x1a9bfc48 "@\344B\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:6479
#19 0x0000000000780ccd in dispatch_command (command=<optimized out>, thd=0x1a9bfc40, packet=0x1a0f3ae0 "@\374\233\032", packet_length=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#20 0x0000000000781a05 in do_command (thd=0x1a9bfc40) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#21 0x000000000074b1bf in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1615
#22 0x000000000074b280 in handle_one_connection (arg=0x19d960d0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1526
#23 0x00000000009ead1a in pfs_spawn_thread (arg=0x1a6cb7e0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#24 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#25 0x0000003636ee890d in clone () from /lib64/libc.so.6

2013-09-12 06:30:42 1a0f4700 InnoDB: Assertion failure in thread 437208832 in file row0ins.cc line 368
InnoDB: Failing assertion: (mode & ~16384) == BTR_MODIFY_LEAF
[...]
Query (1a746560): LOAD DATA INFILE '/ssd//335296/tmp/gentest26042.tmp' INTO TABLE `view_table1_innodb_dynamic`
Connection ID (thread ID): 10
Status: NOT_KILLED

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

(gdb) up
#10 0x0000000000ab4acb in row_ins_step (thr=0x19ff0bc0) at /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc:3351
3351 in /bzr/5.6-QA_val/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0ins.cc
(gdb) p trx->fake_changes
$1 = 1

Revision history for this message
Roel Van de Paar (roel11) wrote :

[roel@qaserver 335296]$ cat /ssd/randgen/.bzr/branch/last-revision
904 <email address hidden>

Revision history for this message
Roel Van de Paar (roel11) wrote :
tags: added: fake-changes
tags: added: 56qual
Revision history for this message
Roel Van de Paar (roel11) wrote :

--56qual since fake changes (alpha)

tags: removed: 56qual
Revision history for this message
Roel Van de Paar (roel11) wrote :

Line number has changed

2014-10-04 20:38:01 7ff9f1377700 InnoDB: Assertion failure in thread 140711470528256 in file row0ins.cc line 365
InnoDB: Failing assertion: (mode & ~16384) == BTR_MODIFY_LEAF

summary: InnoDB: Failing assertion: (mode & ~16384) == BTR_MODIFY_LEAF in file
row0ins.cc line 368 | abort (sig=6) in
- row_ins_clust_index_entry_by_modify
+ row_ins_clust_index_entry_by_modify | Now in file row0ins.cc line 365
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

**** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(pk INT KEY,b INT,c INT)ENGINE=InnoDB;
INSERT INTO t1 VALUES(1,1,0);
ALTER TABLE t1 ADD c2 CHAR(5)FIRST;
XA START'';
delete FROM t1;
SET innodb_fake_changes=1;
INSERT INTO t1 VALUES(1,1,1,0);

tags: removed: qablock
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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