| 1 |
# MDEV-24302 RESET MASTER hangs as Innodb does not report on binlog checkpoint |
| 2 |
# Testing binlog checkpoint notification works under stringent condition |
| 3 |
# set by innodb_force_recovery = 2. |
| 4 |
|
| 5 |
--source include/have_innodb.inc |
| 6 |
--source include/have_binlog_format_mixed.inc |
| 7 |
|
| 8 |
# Binlog checkpoint notification consumers such as RESET MASTER |
| 9 |
# receive one when lsn_0 at the time of the request is finally gets flushed |
| 10 |
# flush_lsn >= lsn_0 |
| 11 |
# The bug situation was that when lsn_0 reflects a write of an internal innodb trx |
| 12 |
# and RESET MASTER was not followed by any more user transaction |
| 13 |
# it would hang. |
| 14 |
|
| 15 |
CREATE TABLE t1(a int) ENGINE=InnoDB; |
| 16 |
INSERT INTO t1 SET a=1; |
| 17 |
RESET MASTER; |
| 18 |
|
| 19 |
# final cleanup |
| 20 |
DROP TABLE t1; |
| 21 |
--echo End of the tests. |