Failing assertion: discard.n_recs == 1 in file row0import.cc line 3453 | abort (sig=6) in row_import_update_discarded_flag

[Roel Van de Paar]

(gdb) bt
#0 0x00007f0da452d771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000675e4a in handle_fatal_signal (sig=6) at /bzr/5.6_opt/sql/signal_handler.cc:254
#2 <signal handler called>
#3 0x00007f0da2ae0989 in raise () from /lib64/libc.so.6
#4 0x00007f0da2ae2098 in abort () from /lib64/libc.so.6
#5 0x0000000000a0ce74 in row_import_update_discarded_flag (trx=trx@entry=0x7f0ce84c6468, table_id=<optimized out>, discarded=discarded@entry=true, dict_locked=dict_locked@entry=true) at /bzr/5.6_opt/storage/innobase/row/row0import.cc:3453
#6 0x0000000000a2533a in row_discard_tablespace (table=0x7f0ce8469368, trx=0x7f0ce84c6468) at /bzr/5.6_opt/storage/innobase/row/row0mysql.cc:2957
#7 row_discard_tablespace_for_mysql (name=<optimized out>, trx=0x7f0ce84c6468) at /bzr/5.6_opt/storage/innobase/row/row0mysql.cc:3083
#8 0x000000000098aaf7 in ha_innobase::discard_or_import_tablespace (this=0x7f0ce847c010, discard=<optimized out>) at /bzr/5.6_opt/storage/innobase/handler/ha_innodb.cc:10603
#9 0x00000000007445a2 in mysql_discard_or_import_tablespace (thd=thd@entry=0x7f0cfb3d4000, table_list=table_list@entry=0x7f0ce841d108, discard=<optimized out>) at /bzr/5.6_opt/sql/sql_table.cc:5494
#10 0x00000000008241f3 in Sql_cmd_discard_import_tablespace::execute (this=0x7f0ce841d670, thd=0x7f0cfb3d4000) at /bzr/5.6_opt/sql/sql_alter.cc:369
#11 0x00000000006f5a94 in mysql_execute_command (thd=thd@entry=0x7f0cfb3d4000) at /bzr/5.6_opt/sql/sql_parse.cc:5384
#12 0x00000000006faa58 in mysql_parse (thd=thd@entry=0x7f0cfb3d4000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f0da4b1e580) at /bzr/5.6_opt/sql/sql_parse.cc:6746
#13 0x00000000006fc1e7 in dispatch_command (command=<optimized out>, thd=0x7f0cfb3d4000, packet=0x7f0ce7719001 "ALTER TABLE t1 DISCARD TABLESPACE", packet_length=<optimized out>) at /bzr/5.6_opt/sql/sql_parse.cc:1434
#14 0x00000000006fe009 in do_command (thd=<optimized out>) at /bzr/5.6_opt/sql/sql_parse.cc:1051
#15 0x00000000006ca332 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f0cfb3d4000) at /bzr/5.6_opt/sql/sql_connect.cc:1532
#16 0x00000000006ca420 in handle_one_connection (arg=arg@entry=0x7f0cfb3d4000) at /bzr/5.6_opt/sql/sql_connect.cc:1443
#17 0x000000000091eff3 in pfs_spawn_thread (arg=0x7f0d847e6420) at /bzr/5.6_opt/storage/perfschema/pfs.cc:1860
#18 0x00007f0da4528df3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f0da2ba13dd in clone () from /lib64/libc.so.6

[Roel Van de Paar (roel11)]

============= Testcase:

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(i INT,KEY(i)) ENGINE=InnoDB;
SET innodb_fake_changes=1;
ALTER TABLE t1 DISCARD TABLESPACE;

- Reproducible on optimized (Percona-Server-5.6.19-rel67.0-648.Linux.x86_64).
- Not reproducible on upstream.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2086