MariaDB 10.4.9 Changelog

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

After an upgrade MariaDB Server can crash if InnoDB tables exist with a FULLTEXT INDEX and a FOREIGN KEY constraint attached to them. We got reports that the crash already will be encountered on startup, but a crash is also possible at a later stage. See MDEV-20987 for more details.Do not download or use this release.

DownloadRelease NotesChangelogOverview of 10.4

Alternate download from mariadb.org

Release date: 5 Nov 2019

For the highlights of this release, see therelease notes.

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

• Includes all fixes from MariaDB 10.3.19

• Revision #0339cbe2f6 2019-11-03 20:41:47 +0200

  • List of unstable tests for 10.4.9 release

• Revision #903f5fea30 2019-11-02 18:54:01 +0100

  • Revert "wolfssl 4.2.0" (it is not ready jet)

• Revision #dacd1794e4 2019-11-02 12:11:39 +0100

  • wolfssl 4.2.0

• Revision #6818f40adf 2019-11-02 08:40:43 +0100

  • Postmerge fix of rocksdb test results

• Merge Revision #f566889a79 2019-11-01 20:01:44 +0100 - Merge branch '10.3' into 10.4

• Merge Revision #ec40980ddd 2019-11-01 15:23:18 +0200 - Merge 10.3 into 10.4

• Revision #6801f80afa 2019-11-01 14:28:33 +0200

  • MDEV-19457 sys_vars.wsrep_provider_basic failed

• Revision #366f4f299e 2019-10-30 17:41:39 +0200

  • Fix that BACKUP STAGE BLOCK_COMMIT flushes binary log

• Revision #fcd65b0376 2019-10-31 19:44:29 +0300

  • MDEV-17171: RocksDB Tables do not have "Creation Date"

• Revision #eafc9d8516 2019-10-30 10:18:09 +0300

  • MDEV-17171: RocksDB Tables do not have "Creation Date"

• Revision #ad8266a5c2 2019-10-09 03:13:13 -0500

  • MDEV-20732 MDB now correctly estimates a length of the FORMAT() result for doubles in scientific notation with a big integer part.

• Revision #6535827885 2019-10-30 15:24:00 +0100

  • MDEV-19516 mysql_secure_installation doesn't set password_last_changed while setting password for root

• Revision #f4ba775914 2019-10-30 09:45:22 +0100

  • MDEV-17099 Preliminary changes for Galera XA support (#1404)

• Revision #576c96a938 2019-10-29 19:10:52 +0200

  • MDEV-20917: Fix dict_table_t::instant_column()

• Revision #d4e1fa39f0 2019-10-29 11:58:11 +0200

  • Use C++11 "range for" in crash recovery code

• Revision #dadc53ff0b 2019-10-26 10:43:10 +0200

  • MDEV-19882 pam v2: auth_pam_tool truncates passwords that are not null-terminated

• Revision #d67ea8151f 2019-10-28 14:54:28 +0200

  • Rename LOG_HEADER_FORMAT_ to log_t::FORMAT_

• Revision #8f46e3833c 2019-10-28 16:16:21 +0200

  • Revert MDEV-17099 Preliminary changes for Galera XA support (#1401)

• Revision #9afbb1069a 2019-10-25 12:32:11 +0300

  • Add wait_condition to stabilize.

• Revision #2b5f4b3ed6 2019-10-24 13:05:33 +0200

  • MDEV-17099 Preliminary changes for Galera XA support (#1401)

• Revision #82f22d2f25 2019-10-18 08:26:54 +0300

  • MDEV-18590 galera.versioning_trx_id: Test failure: mysqltest: Result content mismatch

• Revision #1036886b70 2019-10-16 14:02:16 +0300

  • Stabilize tests.

• Revision #9c735784ae 2019-10-20 15:48:20 +0300

  • Ensure that full_crc32_import doesn't fail

• Revision #c2e0a0b175 2019-10-20 14:42:59 +0300

  • Server crashes with BACKUP STAGE and FLUSH TABLE table_name

• Revision #5b6b16636d 2019-10-17 23:20:34 +0200

  • MDEV-20730: Syntax error on SELECT INTO @variable with CTE

• Revision #421d52e896 2019-10-16 07:51:36 +0300

  • MDEV-6860 Parallel async replication hangs (#1400)

• Merge Revision #899c843f11 2019-10-12 22:03:31 +0300 - Merge 10.3 into 10.4

• Merge Revision #0a473de08d 2019-10-12 15:47:20 +0300 - Null-merge 10.3 into 10.4

• Revision #dba743b653 2019-10-12 06:57:02 +0300

  • Fix -Wunused-variable

• Merge Revision #55c75b6bb3 2019-10-12 06:50:12 +0300 - Merge 10.3 into 10.4

• Revision #36824d2bef 2019-10-07 12:34:08 +0200

  • MDEV-20728: /usr/sbin/mysqld: unknown variable 'defaults-group-suffix=mysqld1

• Revision #b05be3ef8c 2019-10-11 08:24:30 +0300

  • Add encryption.innodb-redo-badkey,strict_full_crc32

• Merge Revision #09afd3da1a 2019-10-10 21:30:40 +0300 - Merge 10.3 into 10.4

• Revision #0f7732d1d1 2019-10-10 15:19:44 +0300

  • MDEV-19335 adjustment for innodb_checksum_algorithm=full_crc32

• Merge Revision #c11e5cdd12 2019-10-10 11:19:25 +0300 - Merge 10.3 into 10.4

• Revision #62dce14d15 2019-10-09 11:42:50 +0300

  • MDEV-20782 : Galera test failure on galera_sr.galera_sr_mysqldump_sst

• Revision #44a11a7c08 2019-10-09 11:41:14 +0300

  • MDEV-20780 : Galera test failure on galera_sr.galera_sr_ddl_master

• Revision #57b666b2e5 2019-10-08 15:04:39 +0300

  • Fix test case wsrep.mdev_6832 we need to wait until wsrep_ready is ON before test can end.

• Revision #6bc75a4253 2019-10-08 13:05:35 +0300

  • MDEV-15528 preparation: Remove a constant parameter

• Revision #c339487030 2019-10-07 08:47:42 +0300

  • Try to fix galera_parallel_simple test case.

• Revision #37570e845b 2019-10-04 20:16:39 +0300

  • MDEV-20740: Odd computations in calculate_cond_selectivity_for_table

• Revision #a5c34bc200 2019-10-04 10:11:47 +0200

  • if the test uses example plugin, it has to check whether plugin exists

• Revision #b710d01dc7 2019-09-25 16:57:05 +0200

  • mark PAMv2 plugin stable

• Revision #fe4f766e81 2019-10-04 14:44:16 +0300

  • Add wait_condition to wait that node returns to ready state before accessing it.

• Revision #5709a7777b 2019-10-04 10:27:55 +0300

  • MDEV-19956: Do not dereference an uninitialized pointer

• Revision #eb0a10b072 2019-10-03 07:03:15 +0300

  • Add missing have_debug to galera.MDEV-20225 test case.

• Revision #97d82c3429 2019-10-01 12:40:29 +0300

  • galera_sp_bf_abort requires debug Galera library.

• Revision #c42c4233cb 2019-10-01 10:41:33 +0300

  • MDEV-20225 BF aborting SP execution (#1394)

• Merge Revision #dc588e3d3f 2019-10-01 10:45:52 +0400 - Merge remote-tracking branch 'origin/10.3' into 10.4

• Revision #f1dcbc2d9a 2019-09-28 12:34:57 +0400

  • MDEV-20639 ASAN SEGV in get_prefix upon modifying base column type with existing indexed virtual column

• Merge Revision #9b5cdeeb0f 2019-09-27 16:26:53 +0300 - Merge 10.3 into 10.4

• Revision #ea2b19dee6 2019-09-27 16:01:55 +0300

  • MDEV-20117: Fix another scenario

• Revision #1f4ee3fa5a 2019-09-26 19:45:10 +0300

  • MDEV-20117 Assertion 0 failed in row_sel_get_clust_rec_for_mysql

• Merge Revision #bb5afc7ceb 2019-09-26 16:56:02 +0300 - Merge 10.3 into 10.4

• Revision #e3c39c0be8 2019-09-26 10:25:34 +0300

  • MDEV-13564 follow-up: Remove dead code

• Merge Revision #d3350c160a 2019-09-25 10:14:33 +0300 - Merge 10.3 into 10.4

• Revision #a39c4b5f9f 2019-09-16 18:56:29 +0300

  • Update mysqld_multi.sh

• Revision #b44171428a 2019-09-20 09:03:38 -0700

  • MDEV-19956 Queries with subqueries containing UNION are not parsed

• Revision #e3da362c03 2019-09-22 21:04:00 +0300

  • MDEV-19189 ASAN memcpy-param-overlap in fill_alter_inplace_info upon adding indexes

• Merge Revision #5a92ccbaea 2019-09-23 17:35:29 +0300 - Merge 10.3 into 10.4

• Revision #c997af7d1f 2019-09-23 10:33:10 +0300

  • Remove reference to dict_sys->mutex

• Revision #631c5ab45f 2019-06-12 12:33:34 +0000

  • Removing obsolete register keyword

• Revision #d99216356d 2019-04-09 22:28:10 +0200

  • cmake: support new libedit interface

• Revision #2f88bd2da2 2019-09-20 10:36:20 +0400

  • MDEV-20634 Report disallowed subquery errors as such (instead of parse error)

• Revision #b9dea911bf 2019-07-27 15:56:58 -0300

  • Extend mysql_instal_db to search plugins also from lib/*/mariadb19/plugin

• Revision #97cd583df7 2019-07-26 18:36:42 -0300

  • Deb: Sync non-functional changes from official Debian 10.4 packaging

• Revision #ffd36093f1 2019-07-24 20:49:12 -0300

  • Deb: Run 'wrap-and-sort -a' so comparison across releases is easier

• Revision #bf617c3654 2019-09-18 09:51:13 +0400

  • MDEV-20423 Assertion 0' failed or btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with TIME_ROUND_FRACTIONAL

• Revision #efefafd02f 2019-09-17 04:58:20 -0300

  • fix for thread getting stuck after BF ABORT (#1362)

• Revision #c793f07841 2019-09-16 14:57:39 +0300

  • Re-record galera_shutdown_nonprim for 10.4.

• Revision #da76ae2162 2019-09-16 14:57:18 +0300

  • Disable galera_var_notify_cmd as it causes hang.

• Revision #509d103810 2019-09-13 09:18:11 +0300

  • MDEV-20561 Galera node shutdown fails in non-Primary (#1386)

• Revision #c946b5f38a 2019-09-13 14:23:13 +0300

  • Re-record galera.galera_pc_ignore_sb test result for 10.4.

• Revision #e73dbec1c8 2019-09-13 11:10:54 +0300

  • Disable wsrep.variables until fixed.

• Revision #1f1f172002 2019-09-13 11:03:26 +0300

  • Re-record galera.galera_events2 test case.

• Revision #8711f5505a 2019-09-13 09:22:10 +0300

  • Fix galera.galera_sst_mysqldump_with_key test case for 10.4

• Revision #7ced6fa141 2019-09-13 20:03:43 +0400

  • MDEV-20228 mysql_upgrade fails on every version upgrade: "ERROR 1267 (HY000) at line 7: Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'"

• Revision #c924e39fab 2019-09-13 11:04:23 +0400

  • MDEV-18153 Assertion 0' or Assertion btr_validate_index(index, 0)' failed in row_upd_sec_index_entry or error code 126: Index is corrupted upon UPDATE with TIME_ROUND_FRACTIONAL

• Revision #368e64aaed 2019-09-13 10:42:10 +0300

  • MDEV-19826: Avoid unused variable in cmake -DPLUGIN_PERFSCHEMA=NO

• Revision #d0b74bbacc 2019-09-12 19:07:56 +0300

  • MDEV-20440: Optimizer trace: print more details about semi-join optimization

• Merge Revision #60c04be659 2019-09-12 12:16:40 +0300 - Merge 10.3 into 10.4

• Revision #ebddd8699c 2019-09-12 11:42:48 +0300

  • MDEV-20565 Assertion failure on CHANGE COLUMN...SYSTEM VERSIONING

• Revision #9bacc9d0c1 2019-09-11 13:13:37 +0300

  • MDEV-20505: Server crash on startup beacuse of bad wsrep configuration

• Revision #5c5452a5a0 2019-09-11 09:15:28 -0400

  • bump the VERSION

• Revision #71c57bcf8f 2019-09-10 14:01:31 +0530

  • Moved the function trace_plan_prefix to the optimizer trace file

• Revision #7b988e5ceb 2019-09-04 19:51:27 +0530

  • MDEV-20444: More information regarding access of a table to be printed inside the optimizer_trace

• Merge Revision #e980cf91cd 2019-09-10 16:09:14 +0300 - Merge mariadb-10.4.8 to 10.4

• Revision #e2f570bff8 2019-09-10 17:41:26 +0530

  • MDEV-20320 Tablespace flags mismatch for full_crc32 format

• Revision #13f740904a 2019-09-10 12:43:48 +0300

  • MDEV-12112/MDEV-12026: Enable the test for full_crc32

• Revision #fe4a4bb0a4 2019-09-08 23:40:08 +0300

  • List of unstable tests for 10.4.8 release

• Revision #c1a2778e68 2019-09-07 10:34:46 +0300

  • MDEV-17171: RocksDB Tables do not have "Creation Date"

• Revision #2d93efc001 2019-09-06 22:11:29 +0300

  • MDEV-17171: RocksDB Tables do not have "Creation Date"

_{This page is licensed: CC BY-SA / Gnu FDL}