DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t(a CHAR (1)) ENGINE=InnoDB;
set global innodb_undo_logs=-1;
set global innodb_trx_rseg_n_slots_debug=1;
drop table if exists t,tp,t1_will_crash;
SET GLOBAL innodb_corrupt_table_action='salvage';
INSERT INTO t VALUES(1);
INSERT INTO t VALUES(1);
Laurynas, could you please confirm whether it is similar bug or not
** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t(a CHAR (1)) ENGINE=InnoDB;
set global innodb_undo_logs=-1;
set global innodb_trx_rseg_n_slots_debug=1;
drop table if exists t,tp,t1_will_crash;
INSERT INTO t VALUES(1);
INSERT INTO t VALUES(1);
** GDB info
#0 0x00007f7a33b63771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7e66 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-70.0/mysys/stacktrace.c:422
#2 0x000000000072fcd3 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-70.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f7a327675c9 in raise () from /lib64/libc.so.6
#5 0x00007f7a32768cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000d375b4 in fseg_inode_get (header=0x7f79c1fec054 "", space=6, zip_size=0, mtr=0x7f798dff65f0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/fsp/fsp0fsp.cc:1899
#7 0x0000000000d38205 in fseg_n_reserved_pages (header=0x7f79c1fec054 "", used=0x7f798dff6590, mtr=0x7f798dff65f0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/fsp/fsp0fsp.cc:2228
#8 0x0000000000c84393 in btr_get_size (index=0x7f7976c6bff8, flag=2, mtr=0x7f798dff65f0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/btr/btr0btr.cc:1245
#9 0x0000000000d1511f in dict_stats_analyze_index (index=0x7f7976c6bff8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/dict/dict0stats.cc:1910
#10 0x0000000000d15bb6 in dict_stats_update_persistent (table=0x7f7976c82378) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/dict/dict0stats.cc:2209
#11 0x0000000000d1776d in dict_stats_update (table=0x7f7976c82378, stats_upd_option=DICT_STATS_RECALC_PERSISTENT) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/dict/dict0stats.cc:3127
#12 0x0000000000d1b9cb in dict_stats_process_entry_from_recalc_pool () at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/dict/dict0stats_bg.cc:313
#13 0x0000000000d1baaf in dict_stats_thread (arg=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/dict/dict0stats_bg.cc:355
#14 0x00007f7a33b5edf3 in start_thread () from /lib64/libpthread.so.0
#15 0x00007f7a3282801d in clone () from /lib64/libc.so.6
**** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test; undo_logs= -1; trx_rseg_ n_slots_ debug=1; corrupt_ table_action= 'salvage' ;
CREATE TABLE t(a CHAR (1)) ENGINE=InnoDB;
set global innodb_
set global innodb_
drop table if exists t,tp,t1_will_crash;
SET GLOBAL innodb_
INSERT INTO t VALUES(1);
INSERT INTO t VALUES(1);
When we remove innodb_ corrupt_ table_action from above testcase getting slightly different assertion, which is similar to MS bug #74343 (http:// bugs.mysql. com/bug. php?id= 74343).
Laurynas, could you please confirm whether it is similar bug or not
** Testcase undo_logs= -1; trx_rseg_ n_slots_ debug=1;
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t(a CHAR (1)) ENGINE=InnoDB;
set global innodb_
set global innodb_
drop table if exists t,tp,t1_will_crash;
INSERT INTO t VALUES(1);
INSERT INTO t VALUES(1);
** GDB info
#0 0x00007f7a33b63771 in pthread_kill () from /lib64/ libpthread. so.0 percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/mysys/ stacktrace. c:422 percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/sql/ signal_ handler. cc:236 0x7f79c1fec054 "", space=6, zip_size=0, mtr=0x7f798dff65f0) at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ fsp/fsp0fsp. cc:1899 reserved_ pages (header= 0x7f79c1fec054 "", used=0x7f798dff 6590, mtr=0x7f798dff65f0) at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ fsp/fsp0fsp. cc:2228 0x7f7976c6bff8, flag=2, mtr=0x7f798dff65f0) at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ btr/btr0btr. cc:1245 analyze_ index (index= 0x7f7976c6bff8) at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ dict/dict0stats .cc:1910 update_ persistent (table= 0x7f7976c82378) at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ dict/dict0stats .cc:2209 0x7f7976c82378, stats_upd_ option= DICT_STATS_ RECALC_ PERSISTENT) at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ dict/dict0stats .cc:3127 process_ entry_from_ recalc_ pool () at /mnt/workspace/ percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ dict/dict0stats _bg.cc: 313 percona- server- 5.6-binaries- debug-yassl/ label_exp/ centos6- 64/percona- server- 5.6.21- 70.0/storage/ innobase/ dict/dict0stats _bg.cc: 355 libpthread. so.0
#1 0x0000000000ab7e66 in my_write_core (sig=6) at /mnt/workspace/
#2 0x000000000072fcd3 in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f7a327675c9 in raise () from /lib64/libc.so.6
#5 0x00007f7a32768cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000d375b4 in fseg_inode_get (header=
#7 0x0000000000d38205 in fseg_n_
#8 0x0000000000c84393 in btr_get_size (index=
#9 0x0000000000d1511f in dict_stats_
#10 0x0000000000d15bb6 in dict_stats_
#11 0x0000000000d1776d in dict_stats_update (table=
#12 0x0000000000d1b9cb in dict_stats_
#13 0x0000000000d1baaf in dict_stats_thread (arg=0x0) at /mnt/workspace/
#14 0x00007f7a33b5edf3 in start_thread () from /lib64/
#15 0x00007f7a3282801d in clone () from /lib64/libc.so.6