innodb_fake_changes cause unknown error code 1000
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Krunal Bauskar | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
Medium
|
Krunal Bauskar |
Bug Description
Version: '5.6.22-71.0' MySQL Community Server (GPL)
InnoDB: unknown error code 1000
InnoDB: Assertion failure in thread X in file row0mysql.cc line 688
Program received signal SIGABRT, Aborted.
in raise () from /usr/lib64/
(gdb) bt
#0 in raise () from /usr/lib64/
#1 in abort () from /usr/lib64/
#2 in row_mysql_
#3 in row_insert_
#4 in ha_innobase:
#5 in handler:
#6 in write_record at sql_insert.cc:1947
#7 in mysql_insert at sql_insert.cc:1085
#8 in mysql_execute_
#9 in mysql_parse at sql_parse.cc:6918
#10 in dispatch_command at sql_parse.cc:1434
#11 in do_command at sql_parse.cc:1051
#12 in do_handle_
#13 in handle_
#14 in start_thread () from /usr/lib64/
#15 in clone () from /usr/lib64/
How To Repeat:
------------------
drop table if exists `t1`;
create table `t1`(`a` int,`c` blob,`d` blob,`e` blob,`f` blob,primary key (`a`)) engine=innodb;
insert into `t1` values (1,'a', repeat(
insert into `t1` values (2,'a', repeat(
insert into `t1` values (3,repeat('a',953), repeat(
insert into `t1` values (4,repeat('a',661), repeat(
insert into `t1` values (5,repeat(
set session innodb_fake_changes = 1 ;
insert into `t1` values (6,repeat(
tags: | added: fake-changes xtradb |
With different inserts you'd also see this:
ERROR 1180 (HY000): Got error 131 during COMMIT