Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
11.8
-
None
-
Not for Release Notes
Description
galera.MDEV-40727 fails on the 11.8 branch: its result file records DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci in four SHOW CREATE TABLE outputs, while 11.8 returns DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci.
Build Run Info
| Branch | Builder name | Date | Commit | Variant |
|---|---|---|---|---|
| 11.8 | s390x-ubuntu-2204 | 2026-11-02T03:02:34Z | 62b26c2f7cb85d0814851af05b3de7a0f9dbbd40 | none |
Failure text
Latest run on 11.8 (worker number, timestamps and paths differ between runs; the amd64-last-N-failed, aarch64-debian-13 and ppc64le-ubuntu-2204 runs of the same commit show the same four changed lines):
galera.MDEV-40727 w1 [ fail ]
|
Test ended at 2026-11-02 02:04:12
|
|
|
CURRENT_TEST: galera.MDEV-40727
|
--- /home/buildbot/s390x-ubuntu-2204/build/mysql-test/suite/galera/r/MDEV-40727.result 2026-11-01 20:37:37.000000000 +0000
|
+++ /home/buildbot/s390x-ubuntu-2204/build/mysql-test/suite/galera/r/MDEV-40727.reject 2026-11-02 02:04:12.274941298 +0000
|
@@ -45,14 +45,14 @@
|
`f1` int(11) NOT NULL,
|
`f2` varchar(100) DEFAULT NULL,
|
PRIMARY KEY (`f1`)
|
-) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
+) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
|
SHOW CREATE TABLE t_innodb;
|
Table Create Table
|
t_innodb CREATE TABLE `t_innodb` (
|
`f1` int(11) NOT NULL,
|
`f2` varchar(100) DEFAULT NULL,
|
PRIMARY KEY (`f1`)
|
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_innodb_data/'
|
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_innodb_data/'
|
SELECT * FROM t_aria;
|
f1 f2
|
1 aria_row_1
|
@@ -68,14 +68,14 @@
|
`f1` int(11) NOT NULL,
|
`f2` varchar(100) DEFAULT NULL,
|
PRIMARY KEY (`f1`)
|
-) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_aria_data/' INDEX DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_aria_index/'
|
+) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_aria_data/' INDEX DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_aria_index/'
|
SHOW CREATE TABLE t_innodb;
|
Table Create Table
|
t_innodb CREATE TABLE `t_innodb` (
|
`f1` int(11) NOT NULL,
|
`f2` varchar(100) DEFAULT NULL,
|
PRIMARY KEY (`f1`)
|
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_innodb_data/'
|
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci DATA DIRECTORY='MYSQLTEST_VARDIR/tmp/MDEV-40727_innodb_data/'
|
SELECT * FROM t_aria;
|
f1 f2
|
1 aria_row_1
|
|
|
Result length mismatch
|
|
|
- saving '/home/buildbot/s390x-ubuntu-2204/build/mysql-test/var/1/log/galera.MDEV-40727/' to '/home/buildbot/s390x-ubuntu-2204/build/mysql-test/var/log/galera.MDEV-40727/'
|
|
|
Retrying test galera.MDEV-40727, attempt(2/3)...
|
Analysis
The SHOW CREATE TABLE and SELECT checks on both nodes after the SST were added by commit b097f46c86f2 (follow-up of MDEV-40727, https://github.com/MariaDB/server/pull/5986, merged into 10.11 on 2026-10-27); the four SHOW CREATE TABLE outputs in r/MDEV-40727.result (lines 48, 55, 71 and 78) are recorded with latin1 / latin1_swedish_ci. The 11.8 result file is byte-identical to the 10.11 and 11.4 one; it came into 11.8 with the merge of 11.4 into 11.8 (commit 62b26c2f7cb8, 2026-11-01), the first 11.8 commit on which the test fails. On 12.3, 13.1 and main the same four lines are recorded as utf8mb4 / utf8mb4_uca1400_ai_ci (they came into 12.3 with the merge of 11.8 into 12.3, commit 3d87634cc6b1), so 11.8 is the only release branch with the mismatch. The diff holds only these four lines; the Synced filesystem checks and the row data match. Six builders report the failure on this commit (s390x-ubuntu-2204, ppc64le-ubuntu-2204, aarch64-debian-13, amd64-last-N-failed, amd64-debian-12-deb-autobake-migration and amd64-rhel-9-rpm-autobake-migration; the two autobake-migration builders store only the tail of the output, which shows the same utf8mb4 lines). The same diff on four CPU architectures points at the result file, not at a builder. The 11.8 result file needs the same four-line change as on 12.3.
Created via the mtr-failure-create-bug skill.
Attachments
Issue Links
- is part of
-
MDEV-30172 Galera test case cleanup
-
- Stalled
-
- relates to
-
-
- Closed
-
- includes
-
AI-53 Loading...