[MDEV-30319] [Draft] binlog.binlog_bug36391 fails the second time with --repeat 2 Created: 2022-12-29  Updated: 2022-12-30

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Angelique Sklavounos (Inactive) Assignee: Angelique Sklavounos (Inactive)
Resolution: Unresolved Votes: 0
Labels: 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==
';


Generated at Thu Feb 08 10:15:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.