[MDEV-29866] binlog.binlog_table_map_optional_metadata_binary 'row' fail Created: 2022-10-24  Updated: 2022-11-09  Resolved: 2022-11-09

Status: Closed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.5.17
Fix Version/s: 10.11.2, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3

Type: Bug Priority: Major
Reporter: Andrei Elkin Assignee: Angelique Sklavounos (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-28970 Some tests that show binlog events wi... Closed

 Description   

The test fails when run by the same worker with a preceding test

binlog.binlog_row_drop_tbl 'row'         [ pass ]    225
 
binlog.binlog_table_map_optional_metadata_binary 'row' [ fail ]
 
        Test ended at 2022-10-24 18:37:00
 
 
 
CURRENT_TEST: binlog.binlog_table_map_optional_metadata_binary
 
--- /home/andrei/MDB.WTs/CS/10.5/C/mysql-test/suite/binlog/r/binlog_table_map_optional_metadata_binary.result	2022-10-24 12:39:02.188069856 +0300
 
+++ /home/andrei/MDB.WTs/CS/10.5/C/mysql-test/suite/binlog/r/binlog_table_map_optional_metadata_binary.reject	2022-10-24 18:37:00.022562401 +0300
 
@@ -7,6 +7,7 @@
 
 c_set_2 SET("set2_v1_å", "set2_v2_ä", "set2_v3_ö") CHARACTER SET binary);
 
 SET GLOBAL binlog_row_metadata = MINIMAL;
 
 INSERT INTO t1 VALUES("set1_v1_å", "set2_v2_ä");
 
+# Columns(INT)
 
 # Columns(SET,
 
 #         SET)
 
 RESET MASTER;
 
 
 
mysqltest: Result length mismatch

Crossref finds one case of the 'mismatch' in-output failure

[Revision hash: cf9e4c8b16d038997d7284731478dc14ceb78c11]
 
 
 
binlog.binlog_table_map_optional_metadata_binary 'row' w21 [ fail ]
 
        Test ended at 2021-05-25 11:58:18
 
 
 
CURRENT_TEST: binlog.binlog_table_map_optional_metadata_binary
 
--- /buildbot/amd64-ubuntu-1804-clang10-asan/build/mysql-test/suite/binlog/r/binlog_table_map_optional_metadata_binary.result	2021-05-25 11:07:48.000000000 +0000
 
+++ /buildbot/amd64-ubuntu-1804-clang10-asan/build/mysql-test/suite/binlog/r/binlog_table_map_optional_metadata_binary.reject	2021-05-25 11:58:18.380041277 +0000
 
@@ -7,6 +7,7 @@
 
 c_set_2 SET("set2_v1_å", "set2_v2_ä", "set2_v3_ö") CHARACTER SET binary);
 
 SET GLOBAL binlog_row_metadata = MINIMAL;
 
 INSERT INTO t1 VALUES("set1_v1_å", "set2_v2_ä");
 
+# Columns(INT)
 
 # Columns(SET,
 
 #         SET)
 
 RESET MASTER;
 
 
 
mysqltest: Result length mismatch

I presume the preceding test (or tests) improper cleanup to blame on.

 Comments   
Comment by Angelique Sklavounos (Inactive) [ 2022-11-02 ]

Will resolve this as part of MDEV-28970.

Comment by Angelique Sklavounos (Inactive) [ 2022-11-07 ]

While similar in nature, reopening because this deals with a different macro (print_optional_metadata.inc).

Comment by Angelique Sklavounos (Inactive) [ 2022-11-09 ]

I presume the preceding test (or tests) improper cleanup to blame on.

The test binlog.binlog_table_map_optional_metadata does not fail in the same way, and this test has a RESET MASTER at the beginning, so I added this to the other tests.

Comment by Andrei Elkin [ 2022-11-09 ]

Thanks! You could also close it as a duplicate of the reported by you (which I missed to find at the reporting time).

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