Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
Description
--source include/have_innodb.inc
|
--source include/have_binlog_format_mixed.inc
|
CREATE TABLE t1 (i INT) ENGINE=InnoDB; |
INSERT IGNORE INTO t1 VALUES (1); |
--let $shutdown_timeout= 0
|
--let $restart_parameters= --innodb-force-recovery=3
|
--source include/restart_mysqld.inc
|
--let $shutdown_timeout= 30
|
--let $restart_parameters= --innodb-force-recovery=0 --innodb-read-only=1 --tc-heuristic-recover=ROLLBACK
|
--source include/restart_mysqld.inc |
10.0 60c9485a8e5ebf410d9fa60caa7937f3fe3ca9b8 |
170803 17:26:09 [Note] Heuristic crash recovery mode
|
2017-08-03 17:26:09 7f3ac8727080 InnoDB: Starting recovery for XA transactions...
|
2017-08-03 17:26:09 7f3ac8727080 InnoDB: Transaction 1283 in prepared state after recovery
|
2017-08-03 17:26:09 7f3ac8727080 InnoDB: Transaction contains changes to 1 rows
|
2017-08-03 17:26:09 7f3ac8727080 InnoDB: 1 transactions in prepared state after recovery
|
170803 17:26:09 [Note] Found 1 prepared transaction(s) in InnoDB
|
170803 17:26:09 [Note] rollback xid 'MySQLXid\1\0\0\0\0\0\0\0\26\0\0\0\0\0\0\0'
|
2017-08-03 17:26:09 7f3ac8727080 InnoDB: Assertion failure in thread 139890447773824 in file mtr0mtr.cc line 322
|
InnoDB: Failing assertion: !srv_read_only_mode
|
#5 0x00007f3ac63a43fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x00007f3abebbcf9f in mtr_commit (mtr=0x7ffd79958de0) at /data/src/10.0/storage/innobase/mtr/mtr0mtr.cc:322
|
#7 0x00007f3abec67ec1 in btr_pcur_commit_specify_mtr (pcur=0x7f3ac587f6e8, mtr=0x7ffd79958de0) at /data/src/10.0/storage/innobase/include/btr0pcur.ic:386
|
#8 0x00007f3abec68735 in row_undo_ins_remove_clust_rec (node=0x7f3ac587f678) at /data/src/10.0/storage/innobase/row/row0uins.cc:170
|
#9 0x00007f3abec68f72 in row_undo_ins (node=0x7f3ac587f678) at /data/src/10.0/storage/innobase/row/row0uins.cc:461
|
#10 0x00007f3abec70af3 in row_undo (node=0x7f3ac587f678, thr=0x7f3ac583cc40) at /data/src/10.0/storage/innobase/row/row0undo.cc:304
|
#11 0x00007f3abec70c21 in row_undo_step (thr=0x7f3ac583cc40) at /data/src/10.0/storage/innobase/row/row0undo.cc:351
|
#12 0x00007f3abebf861f in que_thr_step (thr=0x7f3ac583cc40) at /data/src/10.0/storage/innobase/que/que0que.cc:1077
|
#13 0x00007f3abebf883f in que_run_threads_low (thr=0x7f3ac583cc40) at /data/src/10.0/storage/innobase/que/que0que.cc:1141
|
#14 0x00007f3abebf89cb in que_run_threads (thr=0x7f3ac583cc40) at /data/src/10.0/storage/innobase/que/que0que.cc:1182
|
#15 0x00007f3abecac7d0 in trx_rollback_to_savepoint_low (trx=0x7f3ac587cc78, savept=0x0) at /data/src/10.0/storage/innobase/trx/trx0roll.cc:113
|
#16 0x00007f3abecacb34 in trx_rollback_for_mysql_low (trx=0x7f3ac587cc78) at /data/src/10.0/storage/innobase/trx/trx0roll.cc:176
|
#17 0x00007f3abecaceac in trx_rollback_for_mysql (trx=0x7f3ac587cc78) at /data/src/10.0/storage/innobase/trx/trx0roll.cc:211
|
#18 0x00007f3abeb4141f in innobase_rollback_trx (trx=0x7f3ac587cc78) at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:4056
|
#19 0x00007f3abeb54045 in innobase_rollback_by_xid (hton=0x7f3ac0d17270, xid=0x7f3abb000070) at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:14479
|
#20 0x000000000083b2b2 in xarecover_handlerton (unused=0x0, plugin=0x7ffd79959888, arg=0x7ffd799598f0) at /data/src/10.0/sql/handler.cc:1855
|
#21 0x0000000000662379 in plugin_foreach_with_mask (thd=0x0, func=0x83afcf <xarecover_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=4294967287, arg=0x7ffd799598f0) at /data/src/10.0/sql/sql_plugin.cc:2336
|
#22 0x000000000083b522 in ha_recover (commit_list=0x0) at /data/src/10.0/sql/handler.cc:1898
|
#23 0x0000000000917fb1 in TC_LOG::using_heuristic_recover (this=0x17acd00 <mysql_bin_log>) at /data/src/10.0/sql/log.cc:8938
|
#24 0x000000000091808d in MYSQL_BIN_LOG::open (this=0x17acd00 <mysql_bin_log>, opt_name=0x7f3ac1bbf838 "master-bin") at /data/src/10.0/sql/log.cc:8961
|
#25 0x00000000005925e9 in init_server_components () at /data/src/10.0/sql/mysqld.cc:4905
|
#26 0x0000000000593167 in mysqld_main (argc=138, argv=0x7f3ac5878ac0) at /data/src/10.0/sql/mysqld.cc:5371
|
#27 0x0000000000589c76 in main (argc=23, argv=0x7ffd79959d78) at /data/src/10.0/sql/main.cc:25
|
Attachments
Issue Links
- relates to
-
MDEV-13438 Assertion `(&(&LOCK_log)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&LOCK_log)->m_mutex)->thread)' failed in MYSQL_BIN_LOG::open or Assertion `info.dry_run || total_ha_2pc>(ulong)opt_bin_log' failed in ha_recover
- Closed
-
MDEV-13606 XA PREPARE transactions should survive innodb_force_recovery=1 or 2
- Closed
-
MDEV-13269 Upgrade tests for InnoDB undo log
- Closed