Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL), 11.7
-
None
Description
./mtr binlog.binlog_bug36391 --repeat=2
|
binlog.binlog_bug36391 'mix' [ pass ] 38
|
binlog.binlog_bug36391 'mix' [ 2 fail ]
|
Test ended at 2022-12-29 23:30:39
|
|
CURRENT_TEST: binlog.binlog_bug36391
|
ERROR 1051 (42S02) at line 38: Unknown table 'test.t1'
|
mysqltest: At line 26: exec of '/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/bin/mariadb-binlog --defaults-file=/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/my.cnf --local-load=/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/tmp /home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/mysqld.1/data/master-bin.000002 | /home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/bin/mariadb --defaults-file=/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 11
|
Output from before failure:
|
DROP TABLE t1;
|
|
|
|
The result from queries just before the failure was:
|
CREATE TABLE t1(id INT);
|
SHOW TABLES;
|
Tables_in_test
|
t1
|
FLUSH LOGS;
|
DROP TABLE t1;
|
On 11.0 0529784d3 it fails with an extra Error message. Unsure if this is related to MDEV-29803:
binlog.binlog_bug36391 'mix' [ 2 fail ]
|
Test ended at 2022-12-29 23:38:51
|
|
CURRENT_TEST: binlog.binlog_bug36391
|
ERROR: Found out of order GTID. Got 0-1-1 after 0-1-2
|
ERROR 1051 (42S02) at line 38: Unknown table 'test.t1'
|
mysqltest: At line 26: exec of '/home/angelique/dev/build-11.0-0529784d3/build1/bin/mariadb-binlog --defaults-file=/home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/my.cnf --local-load=/home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/tmp /home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/mysqld.1/data/master-bin.000002 | /home/angelique/dev/build-11.0-0529784d3/build1/bin/mariadb --defaults-file=/home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 11
|
Output from before failure:
|
DROP TABLE t1;
|
binlog.binlog_base64_flag also has the same problem (not sure if it's related, but just putting here for now):
./mtr binlog.binlog_base64_flag --repeat=2
|
binlog.binlog_base64_flag 'mix' [ pass ] 64
|
binlog.binlog_base64_flag 'mix' [ 2 fail ]
|
Test ended at 2022-12-30 02:33:11
|
|
CURRENT_TEST: binlog.binlog_base64_flag
|
mysqltest: At line 43: query 'BINLOG '
|
SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
|
SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
|
'' succeeded - should have failed with errno 1609...
|
|
The result from queries just before the failure was:
|
call mtr.add_suppression("BINLOG_BASE64_EVENT: According to the master's version");
|
call mtr.add_suppression("BINLOG_BASE64_EVENT: Column 1 of table 'test.char128_utf8' cannot be converted");
|
DROP TABLE IF EXISTS t1;
|
==== Test BUG#32407 ====
|
select * from t1;
|
a
|
1
|
1
|
==== Test BINLOG statement w/o FD event ====
|
BINLOG '
|
SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
|
SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
|
';
|
Attachments
Issue Links
- relates to
-
MDEV-29803 Unexpected ERROR: Found out of order GTID after replaying binlog read from remote
- Open