MariaDB 10.5.24 Changelog

Download 10.5.24 Release Notes Changelog Overview of 10.5

Release date: 7 Feb 2024

For the highlights of this release, see the release notes.

The revision number links will take you to the revision's page on GitHub. On GitHub you can view more details of the revision and view diffs of the code modified in that revision.

• Includes all fixes from MariaDB 10.4.33
• Merge Revision #01f6abd1d4 2024-01-31 17:32:53 +0100 - Merge branch '10.4' into 10.5
• Revision #97fcafb9ec 2024-01-10 15:35:25 +0400
  • MDEV-32837 long unique does not work like unique key when using replace
• Revision #a7ee3bc58b 2024-01-22 18:02:11 +0100
  • MDEV-29954 Unique hash key on column prefix is computed incorrectly
• Revision #14d00fdb15 2024-01-22 18:17:05 +0100
  • cleanup: MY_STRNNCOLLSP_NCHARS_EMULATE_TRIMMED_TRAILING_SPACES
• Revision #8bb464899f 2024-01-22 18:01:37 +0100
  • cleanup: unused and undefined methods
• Revision #dcb814c44e 2024-01-21 23:28:54 +0100
  • MDEV-11628 mysql.slow_log reports incorrect start time
• Revision #db9fad1562 2024-01-21 23:20:07 +0100
  • cleanup: main.log_tables test
• Revision #2bc940f7c9 2024-01-20 11:01:46 +0100
  • disable perfschema in mtr bootstrap
• Revision #81d01855fe 2024-01-23 13:22:58 +0400
  • MDEV-28651 quote(NULL) returns incorrect result in view ('NU' instead of 'NULL')
• Revision #5ce6a352b6 2024-01-22 14:23:44 +1100
  • MDEV-33290: Disable ColumnStore based on boost version
• Revision #13e49b783f 2024-01-19 18:40:53 +0700
  • sql_test.cc compile fix
• Revision #117388225c 2024-01-12 09:32:34 +1200
  • MDEV-33165 Incorrect result interceptor passed to mysql_explain_union()
• Revision #207c85783b 2024-01-19 10:31:45 -0700
  • MDEV-33283: Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty
• Revision #7573fe8b07 2024-01-19 15:00:13 +0530
  • MDEV-32968 InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty
• Revision #c95ba183d2 2023-12-21 20:08:32 +0000
  • Replace incorrect message `mariadb-safe` with correct `mariadbd-safe`
• Revision #fa3171df08 2023-12-27 18:57:49 +0400
  • MDEV-27666 User variable not parsed as geometry variable in geometry function
• Revision #caad34df54 2024-01-15 14:08:27 +0530
  • MDEV-32968 InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty
• Revision #ee30491e50 2023-11-15 11:09:26 +0200
  • MDEV-32111: Debian Sid/Trixie will not have libncurses 5 anymore
• Revision #48e4962c44 2023-07-06 11:55:40 +0700
  • MDEV-29298 INSERT ... SELECT Does not produce an optimizer trace
• Revision #5b0a4159ef 2024-01-05 13:44:49 +0100
  • Fix test failures on s390x in test following main.column_compression_rpl
• Revision #8a763c014e 2024-01-12 15:39:38 +0100
  • MDEV-32235: mysql_json cannot be used on newly created table
• Revision #8b5c1d5afa 2024-01-12 15:20:25 +0100
  • Revert "MDEV-32235: mysql_json cannot be used on newly created table"
• Revision #22f3ebe4bf 2024-01-11 15:15:46 +0100
  • MDEV-32235: mysql_json cannot be used on newly created table
• Revision #9a5f85dcbe 2023-11-13 15:40:13 +0100
  • MDEV-32790: Output result in show create table for mysql_json type should be longtext
• Revision #9e9e0b99ad 2023-12-19 12:18:13 +1100
  • MDEV-30170 ha_spider::delete_table() should report table not exist
• Revision #7801c6d22d 2023-12-15 17:37:28 +1100
  • MDEV-29002 Spider: remove SPIDER_CONN::loop_check_meraged_last
• Revision #761d5c8987 2024-01-10 00:56:19 +0100
  • MDEV-33092 Undefined reference to concurrency on Solaris
• Revision #c4ebf87f86 2023-12-13 21:02:44 +0100
  • MDEV-32984 Update federated table and column privileges
• Merge Revision #c9902a20b3 2024-01-10 18:01:46 +1100 - Merge branch '10.4' into 10.5
• Revision #0b612619ef 2024-01-08 14:36:54 +0200
  • MDEV-33098: Fix some instrumentation for innodb.doublewrite_debug
• Revision #cc5c0eda4c 2024-01-03 12:08:21 +0200
  • MDEV-33156 Crash on innodb_buf_flush_list_now=ON and innodb_force_recovery=6
• Merge Revision #3a3a4f044f 2024-01-03 12:07:51 +0200 - Merge 10.4 into 10.5
• Revision #77b8bedf34 2024-01-03 15:08:22 +0530
  • MDEV-33098 The test innodb.doublewrite_debug occasionally fails to start up InnoDB
• Revision #362c0950e8 2023-10-23 11:49:47 +0200
  • MDEV-32549 Cluster inconsistent after SAVEPOINT is rolled back
• Revision #c89f769f24 2023-11-21 15:43:11 +0200
  • MDEV-31905 GTID inconsistency
• Revision #569381df83 2023-12-21 19:20:18 +0100
  • MDEV-33046 fixup. Do not try to schedule timer without dict_stats_start()
• Revision #7cc332b724 2023-12-21 01:55:25 +0100
  • MDEV-33046 - delete unnecessary synchronization with dict_stats_mutex
• Merge Revision #a3dd7ea09f 2023-12-21 11:30:32 +0200 - Merge 10.4 into 10.5
• Revision #cfaab614ea 2023-12-19 10:03:54 +0200
  • MDEV-24481 : galera_3nodes.galera_vote_rejoin_mysqldump MTR failed: mysql_shutdown failed
• Revision #2b8c59fffa 2023-12-20 14:51:00 +0300
  • Fix main.type_timestamp: Change 10.10 in "End of 10.10 tests" to 10.5
• Merge Revision #12995559f9 2023-12-19 18:30:58 +0200 - Merge 10.4 into 10.5
• Revision #476ff0927a 2023-12-19 14:45:39 +0200
  • MDEV-33062 innodb_undo_log_truncate=ON prevents fast shutdown
• Revision #4c2e971841 2023-12-18 10:37:11 +0200
  • MDEV-33052 MSAN use-of-uninitialized-value in buf_read_ahead_linear()
• Merge Revision #4ae105a37d 2023-12-18 08:59:07 +0200 - Merge 10.4 into 10.5
• Revision #f98d2ef5b4 2023-12-15 15:38:31 +0200
  • MDEV-33009 Server hangs for a long time with innodb_undo_log_truncate=ON
• Revision #2c60d43d7d 2023-12-13 16:24:34 +1100
  • MDEV-33006 Missing required privilege CONNECTION ADMIN
• Revision #e472b682e0 2023-11-29 18:56:59 +0100
  • MDEV-32839 LONG UNIQUE gives error when used with REPLACE
• Revision #81609d8625 2023-11-29 17:19:40 +0100
  • cleanup: remove innodb-specific code around update_auto_increment()
• Revision #c5904702cd 2023-11-29 17:19:14 +0100
  • cleanup: remove partition-specific code around update_auto_increment()
• Revision #b94ae3870b 2023-12-12 11:27:20 +1100
  • [fixup] galera: Fix an accidental logical inversion in a recent merge
• Revision #da9ffca908 2023-11-24 07:38:16 +0100
  • MDEV-29816 rpl.rpl_parallel_29322 occasionally fails in BB
• Revision #1e80601b82 2023-12-11 10:37:12 +0200
  • MDEV-16264 fixup: Remove a useless test
• Revision #03ee23bcbb 2023-12-11 10:42:37 +0400
  • MDEV-17226 Column Data in Truncated on UNION to the length of the first value if using REPLACE
• Revision #2d775fd01a 2023-11-30 05:32:09 +0400
  • Cleanup: Removing the unused method Type_handler::get_handler_by_cmp_type
• Revision #a356a940d2 2023-12-08 10:55:13 +0200
  • MDEV-32971 Assertion !recv_sys.is_corrupt_fs() failed on recovery
• Revision #c8346c0bac 2023-12-08 09:31:34 +0200
  • MDEV-31939 Adaptive flush recommendation ignores dirty ratio and checkpoint age
• Merge Revision #d7c6d306fb 2023-12-08 18:02:23 +1100 - Merge branch '10.4' into 10.5
• Revision #d5a6ea36f3 2023-12-07 18:44:28 +0530
  • MDEV-32242 innodb.doublewrite test case always gets skipped
• Merge Revision #c33ca17c17 2023-12-07 17:52:44 +1100 - Merge branch '10.4' into 10.5
• Merge Revision #13dd787530 2023-12-07 16:38:00 +1100 - Merge branch '10.4' into 10.5
• Revision #ddd5449c57 2023-12-05 14:33:16 +1100
  • [fixup] post-merge spider fixup
• Revision #b97f4c340e 2023-12-04 20:34:45 +0300
  • Followup for fix for MDEV-20169: enable main.partition_innodb
• Revision #2700d20b7c 2023-12-04 10:30:39 +0100
  • MDEV-32725 innodb.import_update_stats accesses uninitialized ib_table->stat_n_rows
• Revision #af2e91d9f2 2023-11-30 09:59:23 +0100
  • fix for the test (real fixes will be in 10.4)
• Merge Revision #98a39b0c91 2023-12-01 13:43:58 +0100 - Merge branch '10.4' into 10.5
• Revision #c6a9fd7904 2023-11-30 11:47:44 +1200
  • MDEV-32212 DELETE with ORDER BY and semijoin optimization causing crash
• Revision #89a5a8d234 2023-11-30 09:43:36 +0200
  • MDEV-32269 InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe
• Revision #968061fd9c 2023-11-27 21:03:21 +0300
  • MDEV-28682 gcol.gcol_purge contaminates further execution of innodb.gap_locks
• Revision #387b92df97 2023-11-28 15:31:02 +0200
  • Remove deprication from mariadbd --debug
• Revision #f436b4a523 2023-11-27 09:56:21 +0400
  • MDEV-32879 Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types
• Revision #dd62a285b8 2023-11-20 16:22:07 +0100
  • MDEV-31611: mariadb-setpermission - Can't use string as an ARRAY ref while strict refs in use
• Revision #78c9a12c8f 2023-11-22 16:54:41 +0200
  • MDEV-32861 InnoDB hangs when running out of I/O slots
• Revision #de31ca6a21 2023-11-21 08:53:02 +0200
  • MDEV-32820 Race condition between trx_purge_free_segment() and trx_undo_create()
• Revision #9b7a1c0e92 2023-11-13 23:38:47 +0100
  • MDEV-22243 type_test.type_test_double fails with 'NUMERIC_SCALE NULL'
• Revision #8aa2076426 2023-11-13 18:41:22 +0100
  • Revert "MDEV-22243 type_test.type_test_double fails with 'NUMERIC_SCALE NULL'"
• Revision #8bbf6697cf 2023-11-02 14:57:37 +0100
  • MDEV-24784 JSON_ARRAYAGG charset issue
• Revision #9a545eb67c 2023-11-16 17:45:37 +0200
  • MDEV-26055: Correct the formula for adaptive flushing
• Revision #a3d0d5fc33 2023-11-16 17:45:18 +0200
  • MDEV-26055: Improve adaptive flushing
• Revision #8b509a5d64 2023-09-25 12:56:30 +1100
  • Merge 10.4 into 10.5
• Revision #a0f02f7438 2023-11-15 12:23:35 +0200
  • MDEV-32757 innodb_undo_log_truncate=ON is not crash safe
• Revision #15bb8acf8f 2023-11-15 10:49:39 +0200
  • MDEV-32689: Remove Ubuntu Bionic from 10.5
• Revision #c638051d80 2023-11-14 14:35:51 +0200
  • MDEV-32798 innodb_fast_shutdown=0 hang after incomplete startup
• Merge Revision #9f83a8822f 2023-11-14 08:41:23 +0100 - Merge branch '10.5' into mariadb-10.5.23
• Revision #8b84fb1383 2023-11-13 13:21:35 -0500
  • bump the VERSION
• Revision #9da247b2e7 2023-11-11 15:37:29 +0100
  • galera: cleanup of the lists of disabled tests
• Revision #c3fdfbdbd8 2023-11-10 13:54:25 +0100
  • MDEV-31413: post-fix for 10.5+ (galera_restart_replica test failures)
• Revision #e0c65784aa 2023-11-09 11:06:17 +0200
  • MDEV-32737 innodb.log_file_name fails on Assertion `after_apply || !(blocks).end in recv_sys_t::clear
• Revision #c68620df48 2023-11-04 20:40:31 +0100
  • Fix random test failures in testcase perfschema.mdl_func
• Revision #3c1f324a55 2023-11-03 14:43:45 +0100
  • MDEV-32672: Don't hold LOCK_thd_data over commit_ordered
• Revision #b06ac9a8cd 2023-10-19 09:21:18 +0200
  • MDEV-32462: mysql_upgrade -s still checks for non system tables
• Revision #4eb8aeee8e 2023-10-17 15:41:52 +0200
  • MDEV-32462: mysql_upgrade -s still checks for non system tables
• Revision #ee77375377 2022-12-07 14:14:24 +0100
  • MDEV-26875: Wrong user in SET DEFAULT ROLE error
• Revision #9d8f659f80 2023-11-10 12:40:21 +0100
  • galera: post-fix after migrating changes from 10.4