Building and testing MySQL 8.0.41 / 8.4.4 / 9.2.0 on macOS

Previously: 8.0.40 / 8.4.3 / 9.1.0

Oracle released MySQL 8.0.41 / 8.4.4 / 9.2.0, and it's time for me to build and test it under macOS, of all things!

But first, a detour to the last set of releases Valgrind results, because its run took a few weeks on 9.1.0, and that's without --big-test. A big part of tests timed out, or failed randomly. There appear no errors that are diagnosed during server operation, and the shutdown logs are way too verbose for me to try to find any memory leaks. Perhaps 9.2.0 will fare better, and I will reduce --parallel further. Will it take two months to run? We will see!

Build

Mostly good news here, again. -DWITH_ZLIB=bundled is no longer required, that's probably due to newer XCode toolchain finally updating its zlib.

A new build bug:

• https://bugs.mysql.com/bug.php?id=117299 (ddl0bulk.h:236:15: error: parameter 'prebuilt' not found in the function declaration [-Werror,-Wdocumentation]) - the workaround is trivial.

A fixed build bug:

• https://bugs.mysql.com/bug.php?id=113113 (Build failure with Homebrew LLVM 14-19 on macOS) no longer happens with 8.4.4 and 9.2.0, but 8.0.41 is still affected.

MySQL 8.0.41 does not build with LLVM 19. It could probably be fixed by backporting a fix for MySQL 8.4.4 which is documented as "Implemented the standards-compliant my_char_traits<unsigned char> for use as a drop-in replacement for std::char_traits<unsigned char>, which was deprecated in Clang 18 and removed in Clang 19. (Bug #37273525)"

Test

New bugs:

• https://bugs.mysql.com/bug.php?id=117297 (Test rpl.rpl_json failing)
• https://bugs.mysql.com/bug.php?id=117314 (Test innodb.tablespace_encrypt_9 failing)

No changes:

• https://bugs.mysql.com/bug.php?id=113260 (Client error in error log: MY-004031 - The client was disconnected …)
• https://bugs.mysql.com/bug.php?id=116373 (auth_sec.acl_tables_row_locking failing with result diff)
• https://bugs.mysql.com/bug.php?id=115480 (Test innodb.log_first_rec_group failing)
• https://bugs.mysql.com/bug.php?id=113189 (ColumnStatisticsTest.StoreAndRestoreAttributesEquiHeight unit test fails)
• https://bugs.mysql.com/bug.php?id=113190 (Several tests in routertest_integration_routing_sharing_constrained_pools fail)
• https://bugs.mysql.com/bug.php?id=113709 (StrXfrmTest.ChineseUTF8MB4 failing with an AddressSanitizer error)
• https://bugs.mysql.com/bug.php?id=116375 (UBSan error on Rpl_commit_order_queue_test.Simulate_mts)
• https://bugs.mysql.com/bug.php?id=113665 (perfschema.relaylog fails with a result difference)
• https://bugs.mysql.com/bug.php?id=116385 (Test main.mysql_upgrade_grant timing out on debug build)
• https://bugs.mysql.com/bug.php?id=116378 (routertest_integration_routing_splitting crashing under AddressSanitizer)
• https://bugs.mysql.com/bug.php?id=113722 (Test main.index_merge_innodb failing with a result difference)
• https://bugs.mysql.com/bug.php?id=114892 (Test XComControlTest.SuspectMemberFailedRemovalDueToMajorityLoss fails) - this one I haven't seen in a while, but it's back
• https://bugs.mysql.com/bug.php?id=116394 (Test binlog_gtid.binlog_gtid_binlog_recovery_errors crashes with an assert)

Fixed bugs:

• https://bugs.mysql.com/bug.php?id=115495 ("Unable to read page" crash on innodb.dblwr_encrypt_recover)
• https://bugs.mysql.com/bug.php?id=116390 (Test main.opt_hint_resource_group_hypergraph failing testcase check)
• https://bugs.mysql.com/bug.php?id=116391 (Test main.opt_hints_join_order_hypergraph failing with a result diff)
• https://bugs.mysql.com/bug.php?id=115498 (Test main.opt_hints_hypergraph always failing)

Did not test:

• https://bugs.mysql.com/bug.php?id=116372 (ODR violation reported by AddressSanitizer for plugin variables)

One-off issues:

• main.join_cache_nojb failed once with query execution plan difference on 8.0.41 debug build.
• rpl_gtid.rpl_gtids_table_disable_binlog_on_slave failed intermittently on 8.0.41 Debug with sanitizers, 8.4.4 Debug, & 8.4.4 Debug with sanitizers builds. The same happened in the previous set of releases too.
• binlog_gtid.binlog_gtid_bgc_ticket_manager failed once on 8.4.4 Debug build.
• routertest_integration_routing_sharing_constrained_pools failed once in a way that is not bug #113190 above.
• rpl_gtid.rpl_heartbeat_log_pos_4gb timed out once on 8.4.4 Debug with sanitizers.
• binlog_gtid.binlog_check_gtid_persistor_compatibility failed once on 9.2.0 Debug with sanitizers.
• innodb.trigger_function_lock_compare timed out once on 9.2.0 Debug with sanitizers.

Conclusion

Without the one-off issues I have 2 new, 13 unchanged, 4 fixed, 1 untested bug. Much less churn than the last time, and finally the trend is positive.