[MDEV-31900] galera.mariadb_tzinfo_to_sql fails on FreeBSD with wrong result - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 11.1.1, 10.6
Fix Version/s: 10.6.20, 10.11.10, 11.2.6, 11.4.4, 11.6.2
Component/s: Galera, Platform FreeBSD, Tests
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

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.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

logs.tar.gz
2023-08-11 08:43
9.53 MB
Timofey Turenko
logs (2).tar.gz
2023-08-08 08:57
9.95 MB
Timofey Turenko
mtr.log
2023-08-11 08:43
45 kB
Timofey Turenko
mtr (2).log
2023-08-08 08:57
89 kB
Timofey Turenko
mtr-vardir.tar.gz
2022-05-29 20:44
1.40 MB
Elena Stepanova
syslog.tar.gz
2023-08-11 08:43
19 kB
Timofey Turenko
syslog (2).tar.gz
2023-08-08 08:57
25 kB
Timofey Turenko
test-MTR-galera.log
2022-05-29 20:44
97 kB
Elena Stepanova

Issue Links

is part of

MDEV-33073 always green buildbot

Stalled

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2022-05-29 20:46

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

Elena Stepanova added a comment - 2022-05-29 20:46 The test will be skipped in Jenkins FreeBSD builds of 10.6.

Timofey Turenko added a comment - 2023-06-13 10:49

more logs can be found as attachments to MENT-1717

Timofey Turenko added a comment - 2023-06-13 10:49 more logs can be found as attachments to MENT-1717

Timofey Turenko added a comment - 2023-08-08 08:57

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

logs from 23.07.0 added

Timofey Turenko added a comment - 2023-08-08 08:57 syslog (2).tar.gz mtr (2).log logs (2).tar.gz logs from 23.07.0 added

Timofey Turenko added a comment - 2023-08-11 08:43

logs from CS 11.1.1 added

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

Timofey Turenko added a comment - 2023-08-11 08:43 logs from CS 11.1.1 added mtr.log syslog.tar.gz logs.tar.gz

Daniel Black added a comment - 2025-04-30 06:51

https://buildbot.mariadb.org/#/builders/619/builds/12840/steps/10/logs/stdio 10.6.22-c62671543976eb397576f1b57fb6817029bc21ee

galera.mariadb_tzinfo_to_sql w8 [ pass ] 4289

CURRENT_TEST: galera.mariadb_tzinfo_to_sql
$ /data/buildbot/workers/prod/amd64-freebsd-14/build/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/8/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --log-bin --core-file --loose-debug-sync-timeout=300
2025-04-30 4:29:26 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2025-04-30 4:29:26 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2025-04-30 4:29:26 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:19274' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
2025-04-30 4:29:26 0 [Note] Starting MariaDB 10.6.22-MariaDB-log source revision c62671543976eb397576f1b57fb6817029bc21ee server_uid FglNILs65UixXfWamH92YwU9iDI= as process 11715
2025-04-30 4:29:26 0 [Note] WSREP: Loading provider /usr/local/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2025-04-30 4:29:26 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/lib/libgalera_smm.so'
2025-04-30 4:29:26 0 [Note] WSREP: wsrep_load(): Galera 26.4.22(r0dee28ef8b) by Codership Oy <info@codership.com> loaded successfully.
2025-04-30 4:29:26 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1'
2025-04-30 4:29:26 0 [Note] WSREP: Resolved symbol 'wsrep_certify_v1'
2025-04-30 4:29:26 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2025-04-30 4:29:26 0 [Warning] WSREP: Could not open state file for reading: '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/8/mysqld.1/data//grastate.dat'
2025-04-30 4:29:26 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2025-04-30 4:29:26 0 [Note] WSREP: Preallocating 10487064/10487064 bytes in '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/8/mysqld.1/data//galera.cache'...
2025-04-30 4:29:26 0 [Note] WSREP: GCache DEBUG: opened preamble:

Cross reference showing a few errors of it failing to complete on other builders and warning output differences but no errors of the described form.

Daniel Black added a comment - 2025-04-30 06:51 https://buildbot.mariadb.org/#/builders/619/builds/12840/steps/10/logs/stdio 10.6.22-c62671543976eb397576f1b57fb6817029bc21ee galera.mariadb_tzinfo_to_sql w8 [ pass ] 4289 CURRENT_TEST: galera.mariadb_tzinfo_to_sql $ /data/buildbot/workers/prod/amd64-freebsd-14/build/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/8/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --log-bin --core-file --loose-debug-sync-timeout=300 2025-04-30 4:29:26 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2025-04-30 4:29:26 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2025-04-30 4:29:26 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:19274' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members. 2025-04-30 4:29:26 0 [Note] Starting MariaDB 10.6.22-MariaDB-log source revision c62671543976eb397576f1b57fb6817029bc21ee server_uid FglNILs65UixXfWamH92YwU9iDI= as process 11715 2025-04-30 4:29:26 0 [Note] WSREP: Loading provider /usr/local/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 2025-04-30 4:29:26 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/lib/libgalera_smm.so' 2025-04-30 4:29:26 0 [Note] WSREP: wsrep_load(): Galera 26.4.22(r0dee28ef8b) by Codership Oy <info@codership.com> loaded successfully. 2025-04-30 4:29:26 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1' 2025-04-30 4:29:26 0 [Note] WSREP: Resolved symbol 'wsrep_certify_v1' 2025-04-30 4:29:26 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2025-04-30 4:29:26 0 [Warning] WSREP: Could not open state file for reading: '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/8/mysqld.1/data//grastate.dat' 2025-04-30 4:29:26 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2025-04-30 4:29:26 0 [Note] WSREP: Preallocating 10487064/10487064 bytes in '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/8/mysqld.1/data//galera.cache'... 2025-04-30 4:29:26 0 [Note] WSREP: GCache DEBUG: opened preamble: Cross reference showing a few errors of it failing to complete on other builders and warning output differences but no errors of the described form.

Daniel Black added a comment - 2025-04-30 07:00

last observed in cr - bb-10.6-mdev34720-v3 f41af86dd (2024-08-22)

took 10.6.20 as the version after this as estimated fix release.

Daniel Black added a comment - 2025-04-30 07:00 last observed in cr - bb-10.6-mdev34720-v3 f41af86dd (2024-08-22) took 10.6.20 as the version after this as estimated fix release.

MariaDB Server

galera.mariadb_tzinfo_to_sql fails on FreeBSD with wrong result

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration