[MDEV-31900] galera.mariadb_tzinfo_to_sql fails on FreeBSD with wrong result Created: 2022-05-29  Updated: 2023-08-11

Status: Open
Project: MariaDB Server
Component/s: Galera, Platform FreeBSD, Tests
Affects Version/s: 11.1.1, 10.6
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None
Environment:

debian buster aarch64 debian buster amd64 rhel 7 amd64 rhel 8 aarch64 rhel 8 amd64 rocky 9 aarch64 rocky 9 amd64 sles 12 amd64 sles 15 amd64 ubuntu focal amd64 ubuntu jammy aarch64


Attachments: File logs (2).tar.gz     File logs.tar.gz     File mtr (2).log     File mtr-vardir.tar.gz     File mtr.log     File syslog (2).tar.gz     File syslog.tar.gz     File test-MTR-galera.log    

 Description   

https://es-jenkins.mariadb.net/job/Test-Package//42995/artifact/test-MTR-galera.log/*view*

10.6-enterprise 053503c

galera.mariadb_tzinfo_to_sql 'innodb'    w3 [ fail ]
        Test ended at 2022-05-28 23:52:19
 
CURRENT_TEST: galera.mariadb_tzinfo_to_sql
--- /tmp/workspace/Test-Package/mysql-test/suite/galera/r/mariadb_tzinfo_to_sql.result	2022-05-28 23:32:08.000000000 +0000
+++ /tmp/workspace/Test-Package/mysql-test/suite/galera/r/mariadb_tzinfo_to_sql.reject	2022-05-28 23:52:18.919881000 +0000
@@ -138,19 +138,21 @@
 connection node_1;
 Warnings:
 Warning	1478	Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1'
+Warnings:
+Warning	1478	Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1'
 'binlog advanced as expected'
 SELECT @wsrep_is_on,  @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
 @wsrep_is_on	@wsrep_cannot_replicate_tz	@save_wsrep_on	@save_sql_log_bin	@@WSREP_ON	@@SQL_LOG_BIN
-1	0	1	1	1	1
+1	1	1	1	1	1
 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
 FROM information_schema.global_status g
 JOIN baseline b USING (VARIABLE_NAME)
 ORDER BY g.VARIABLE_NAME;
 VARIABLE_NAME	diff
-COM_ALTER_TABLE	2
-COM_BEGIN	0
+COM_ALTER_TABLE	8
+COM_BEGIN	1
 COM_INSERT	6
-COM_LOCK_TABLES	1
+COM_LOCK_TABLES	0
 COM_TRUNCATE	4
 SELECT COUNT(*) FROM time_zone;
 COUNT(*)
@@ -176,13 +178,13 @@
 2
 SELECT COUNT(*) FROM time_zone_name;
 COUNT(*)
-0
+2
 SELECT COUNT(*) FROM time_zone_transition;
 COUNT(*)
 0
 SELECT COUNT(*) FROM time_zone_transition_type;
 COUNT(*)
-0
+2
 SELECT COUNT(*) FROM time_zone_leap_second;
 COUNT(*)
 0
 
mysqltest: Result length mismatch

The test doesn't fail on CS when it's built from ports, but it is an essentially different build, so it's not a fair comparison.



 Comments   
Comment by Elena Stepanova [ 2022-05-29 ]

The test will be skipped in Jenkins FreeBSD builds of 10.6.

Comment by Timofey Turenko [ 2023-06-13 ]

more logs can be found as attachments to MENT-1717

Comment by Timofey Turenko [ 2023-08-08 ]

syslog (2).tar.gz mtr (2).log logs (2).tar.gz

logs from 23.07.0 added

Comment by Timofey Turenko [ 2023-08-11 ]

logs from CS 11.1.1 added

mtr.log syslog.tar.gz logs.tar.gz

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