Building and testing MySQL 8.0.42 / 8.4.5 / 9.3.0 on macOS

Previously: 8.0.41 / 8.4.4 / 9.2.0

MySQL 8.0.42 / 8.4.5 / 9.3.0 are out, and as usual, I have built and tested the new releases on macOS, due to its popularity as the server OS, of course.

Build

The 8.0 series don't build with the current XCode clang because of bug 118026 (Build failed with apple clang 17). That's inconvenient, but Homebrew-packaged LLVM clang versions 14 to 18 build it fine.

Another pre-existing build bug 117299 (ddl0bulk.h:236:15: error: parameter 'prebuilt' not found in the function declaration [-Werror,-Wdocumentation]) previously only affected 8.0, but now hits 8.4. Of course, the workarounds are simple enough.

I have also reported bug 118161 (Having Homebrew-installed googletest breaks build). I suspect this is not a 8.0.42 regression, thus will not be counting towards the running bug totals.

So, for build, we have one bug with no change, and one slightly worsened. Meh, but not too bad either.

Test

Here the things are not looking as good.

Bad news first. New bugs and existing bugs with substantial regressions. The number is substantial:

• https://bugs.mysql.com/bug.php?id=116369 (rpl.rpl_semi_sync_alias crashes under AddressSanitizer) - was 8.0-only, now 9.3.0 crashes too at a different point.
• https://bugs.mysql.com/bug.php?id=118169 (Test innodb.partition_upgrade_8019_mac_lctn_2_debug failing)
• https://bugs.mysql.com/bug.php?id=118170 (Test innodb.partition_upgrade_8019_win_lctn_2_debug failing instead of skipping on macos)
• https://bugs.mysql.com/bug.php?id=118171 (Test main.mysqldump-tablespace-escape failing)
• https://bugs.mysql.com/bug.php?id=118175 (UBSan error at x/protocol/stream/decompression_input_stream.h)
• https://bugs.mysql.com/bug.php?id=118184 (UBSan errors on router tests)
• https://bugs.mysql.com/bug.php?id=118185 (Non-specific ASan error on TestLoaderGood/LoaderReadTest.load_wrong_version/0)
• https://bugs.mysql.com/bug.php?id=118193 (Test innodb.partition_upgrade_5727_mac_lctn_2 failing with a result difference)
• https://bugs.mysql.com/bug.php?id=118211 (Spec/ShareConnectionReconnectTest.change_user/ssl_modes_REQUIRED__PREFERRED_socket test fails)
• https://bugs.mysql.com/bug.php?id=118212 (Some router tests crash under AddressSanitizer)
• https://bugs.mysql.com/bug.php?id=118213 (Test perfschema.idx_compare_mutex_instances fails under debug + sanitizers)
• https://bugs.mysql.com/bug.php?id=118214 (LifecycleTest.Simple_AllFunctions crashes under AddressSanitizer)

Bugs with no news:

• https://bugs.mysql.com/bug.php?id=103338 (Starting mysqld on same data files sometimes errors out due to doublewrite buf)
• 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=113260 (Client error in error log: MY-004031 - The client was disconnected …)
• https://bugs.mysql.com/bug.php?id=113665 (perfschema.relaylog fails with a result difference)
• https://bugs.mysql.com/bug.php?id=113709 (StrXfrmTest.ChineseUTF8MB4 failing with an AddressSanitizer error)
• https://bugs.mysql.com/bug.php?id=113722 (Test main.index_merge_innodb failing with a result difference) - was closed for 9.2.0, still happens on 8.4.5.
• https://bugs.mysql.com/bug.php?id=115480 (Test innodb.log_first_rec_group failing)
• 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=116375 (UBSan error on Rpl_commit_order_queue_test.Simulate_mts) - no change in the current release but already closed for the next ones, looking forward to confirming.
• https://bugs.mysql.com/bug.php?id=116378 (routertest_integration_routing_splitting crashing under AddressSanitizer)
• https://bugs.mysql.com/bug.php?id=116394 (Test binlog_gtid.binlog_gtid_binlog_recovery_errors crashes with an assert)
• 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)

Closed bugs or bugs that have improved in some ways:

• https://bugs.mysql.com/bug.php?id=114892 (Test XComControlTest.SuspectMemberFailedRemovalDueToMajorityLoss fails) - this one is intermittent with low enough frequency that I cannot tell whether it was fixed.
• https://bugs.mysql.com/bug.php?id=116385 (Test main.mysql_upgrade_grant timing out on debug build)

Did not test:

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

One-off issues that I wasn't able to repeat properly for bug reporting.

• rpl_gtid.rpl_gtids_table_disable_binlog_on_slave on 8.0.42
• rpl_gtid.rpl_gtid_create_select on 8.0.42
• test_services.test_table_access on 8.0.42
• main.system_variable_source on 8.0.42
• innodb.trigger_function_lock_compare on 8.0.42
• gcs_xcom_control_interface-t on 8.0.42 and 9.3.0
• router.authentication_mysql_accounts on 9.3.0
• routertest_integration_routing_sharing on 9.3.0
• routertest_integration_routing_sharing_constrained_pools on 9.3.0
• rpl_nogtid.rpl_semi_sync_uninstall_plugin on 9.3.0
• perfschema.idx_compare_events_waits_history on 9.3.0
• sys_vars.log_slow_admin_statements_func on 9.3.0
• main.subquery_mat_all on 9.3.0

Conclusion

Without the one-off issues I have 13 (!) new, 15 unchanged, 2 fixed, and 1 untested bug. The positive trend of the previous set of releases is no more, and the set of open issues almost doubles in size. I hope that the next quarterly release will look better.