Release Notes for MariaDB Enterprise Server 10.4.14-8
This eighth release of MariaDB Enterprise Server 10.4 is a maintenance release, including a variety of fixes.
MariaDB Enterprise Server 10.4.14-8 was released on 2020-09-08.
Notable Changes
Limit
innodb_encryption_threads
to255
. (MDEV-22258)Minimum value of
max_sort_length
raised to8
(previously4
) so fixed size data types likeDOUBLE
andBIGINT
are not truncated for lower values ofmax_sort_length
. (MDEV-22715)UPDATE
privilege for system usermariadb.sys
removed for system tablemysql.global_priv
(MDEV-23237)Backport from MariaDB Server 10.5.4 of improvements to
DROP TABLE
for InnoDB. (MENT-636)
Changes in Storage Engines
This release includes ColumnStore 1.4.4.
Bugs Fixed
Can result in data loss
InnoDB doublewrite recovery can corrupt data pages. (MDEV-11799)
InnoDB table can disappear when trying to change primary key after disabling Foreign Key checks and violating a Foreign Key constraint. (MENT-804)
InnoDB corruption in delete buffering. (MDEV-22497)
Rollback of
INSERT
fails when column reorder occurs. (MDEV-22637)Possible data inconsistency when executing
ADD PRIMARY KEY
with concurrent DML transactions. (MDEV-23244)InnoDB table corruption after`` DROP INDEX``. (MDEV-22988)
ALTER TABLE
to extend aCHAR
column was incorrectly allowed to be instant. (MDEV-22771)
Can result in hang or crash
InnoDB deadlock in
FLUSH TABLES .. FOR EXPORT
(MDEV-22890)InnoDB data file extension is not crash-safe. (MDEV-23190)
innodb_log_optimize_ddl=OFF
is not crash safe. (MDEV-21347)Deadlock involving parallel workers,
STOP SLAVE
, andFLUSH TABLES WITH READ LOCK
(MDEV-23089)Crashes when running a SQL query containing a specific subquery pattern. (MDEV-23221)
Dropping the adaptive hash index may cause DDL to lock up InnoDB. (MDEV-22456)
RESET MASTER TO
could result in a crash when the value exceeds the max allowed2147483647
. (MDEV-22451)Crash on
WITH RECURSIVE
large query (MDEV-22748)Crash with Prepared Statement with a
?
parameter inside a re-used CTE. (MDEV-22779)Possible crash after changing the
query_cache
size. (MDEV-5924)Crash in
CREATE TABLE AS SELECT
when the precision of returning type= 0
. (MDEV-22502)ENUM
orSET
in aCREATE TABLE
statement which has a0x00
byte in one of the values could crash the server. (MDEV-22111)Possible crash of a MariaDB Enterprise Cluster node when
KILL
is executed (MDEV-23147)Possible crash when executing
FLUSH PRIVILEGES
. (MDEV-23009)Server can hang when started with
--plugin-load-add=server_audit
and records inmysql.plugin
refer to non-existent libraries. (MDEV-19918)InnoDB recovery can block server startup. (MENT-915)
Server hangs on start up when loading MariaDB Enterprise Audit if old
SERVER_AUDIT
plugin is installed (MENT-273)
Can result in unexpected behavior
Service shutdown fails if OS datetime has been updated backwards. (MDEV-17481)
ALTER TABLE .. ANALYZE PARTITION
can run for hours for huge tables if engine-independent persistent statistics are enabled, due to reading and locking of all rows in the InnoDB table instead of for the partition. (MDEV-21472)UPDATE
can fail with privilege error whenUPDATE
privilege exists at database level butSELECT
privilege exists at table level. (MDEV-23010)Latency and throughput regression identified in write-heavy benchmarks for latest releases in MariaDB Server 10.2, 10.3, and 10.4. (MENT-909)
ROW_FORMAT
mismatch in instantALTER TABLE
. An instantADD
orDROP
column or reorder could create a dummy table object with the wrongROW_FORMAT
wheninnodb_default_row_format
was changed betweenCREATE TABLE
andALTER TABLE
. (MDEV-23295)Slow InnoDB shutdown on large instances when using Windows OS. (MDEV-22778)
When giving a parallel optimistic slave a replication stop position with
START SLAVE UNTIL .. file .. pos
stops at an earlier position earlier than defined if the transaction that spans over the given stop position has to roll back due to conflicts. (MDEV-15152)Point in time recovery of binary log fails with syntax error when
sql_mode=ORACLE
. (MDEV-23108)Replication aborts with
ER_SLAVE_CONVERSION_FAILED
uponCREATE .. SELECT
whensql_mode=ORACLE
. (MDEV-19632)mariabackup --prepare
does not stop on errors while applying InnoDB redo log. (MDEV-22354)Rounding functions return wrong datatype. (MDEV-23366) (MDEV-23367) (MDEV-23368) (MDEV-23350) (MDEV-23351) (MDEV-23337) (MDEV-23323)
PAM v2 plugin produces zombie processes. (MDEV-21385)
Performance regression when using MariaDB Enterprise Audit. (MENT-870)
Regression in Audit Plugin Performance. (MENT-700)
Install and Upgrade
UNINSTALL PLUGIN
andUNINSTALL SONAME
can't run if the library file doesn't exist. (MDEV-21258)
Interface Changes
mariabackup
--help
command-line option addedmariabackup
--mysqld-args
command-line option addedmax_sort_length
system variable minimum value changed from4
to8
Platforms
In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.4.14-8 is provided for:
Red Hat Enterprise Linux 8
Red Hat Enterprise Linux 7
Red Hat Enterprise Linux 6
CentOS 8
CentOS 7
CentOS 6
Debian 10
Debian 9
Debian 8
SUSE Linux Enterprise Server 15
SUSE Linux Enterprise Server 12
Ubuntu 20.04
Ubuntu 18.04
Ubuntu 16.04
Microsoft Windows
Note
CentOS 6, Debian 8, and Red Hat Enterprise Linux 6 are no longer supported as per the MariaDB Engineering Policy. Older releases are available from the MariaDB Downloads page. Instructions for installation are included as a README
file within the download.