Release Notes for MariaDB Enterprise Server 10.5.5-3

This third release of MariaDB Enterprise Server 10.5 is a maintenance release, including a variety of fixes.

MariaDB Enterprise Server 10.5.5-3 was released on 2020-09-08.

Note

With MariaDB Enterprise Server 10.5 "mysql" command names are replaced with "mariadb" command names. Symbolic links are in place to maintain backward compatibility with the old names and prevent disruption. (MDEV-21303)

Notable Changes

  • Deprecated InnoDB configuration parameters: (MDEV-23379)

    • innodb_thread_concurrency

    • innodb_commit_concurrency

    • innodb_replication_delay

    • innodb_concurrency_tickets

    • innodb_thread_sleep_delay

    • innodb_adaptive_max_sleep_delay

  • UPDATE privilege for system user mariadb.sys removed for system table mysql.global_priv (MDEV-23237)

  • Spider storage engine now allows parameters driver and filedsn for the ODBC wrapper. System tables spider_link_mon_servers, spider_tables, spider_xa_member, and spider_xa_failed_log updated. (MENT-812)

  • Setting SHUTDOWN_WAIT_FOR_SLAVES now only requires SHUTDOWN privilege, not the generic SUPER privilege. (MENT-731)

Changes in Storage Engines

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 table corruption can occur after DROP INDEX. (MDEV-22988)

  • ALTER TABLE to extend a CHAR column was incorrectly allowed to be instant. (MDEV-22771)

  • Possible data inconsistency when executing ADD PRIMARY KEY with concurrent DML transactions. (MDEV-23244)

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, and FLUSH TABLES WITH READ LOCK (MDEV-23089)

  • Crashes when running a SQL query containing a specific subquery pattern. (MDEV-23221)

  • 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 in mysql.plugin refer to non-existent libraries. (MDEV-19918)

  • Server crashes upon SHOW CREATE PROCEDURE for stored procedures after upgrade from MariaDB Server 10.3. (MENT-819)

  • Crash with CREATE TEMPORARY TABLE .. ENGINE=SPIDER using wrapper odbc (MENT-807)

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 when UPDATE privilege exists at database level but SELECT 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 instant ALTER TABLE. An instant ADD/DROP/reorder column could create a dummy table object with the wrong ROW_FORMAT when innodb_default_row_format was changed between CREATE TABLE and ALTER TABLE. (MDEV-23295)

  • Slow InnoDB shutdown on large instance when using Windows OS. (MDEV-22778)

  • Fixes to performance regressions introduced in MariaDB 10.5.4. (MDEV-23369) (MDEV-23410)

  • Point in time recovery of binary log fails with syntax error when sql_mode=ORACLE. (MDEV-23108)

  • Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE .. SELECT when sql_mode=ORACLE. (MDEV-19632)

  • 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)

  • S3 Storage Engine fails to load if Xpand plugin is loaded. (MENT-879)

  • Performance regression when using MariaDB Enterprise Audit. (MENT-870)

  • Change in InnoDB I/O thread count is not reflected in system variables. (MENT-866)

  • Regression in Audit Plugin Performance. (MENT-700)

Install and Upgrade

  • UNINSTALL PLUGIN and UNINSTALL SONAME can't run if the library file doesn't exist. (MDEV-21258)

Interface Changes

  • innodb_adaptive_max_sleep_delay system variable default value changed from 150000 to 0 (now deprecated)

  • innodb_concurrency_tickets system variable default value changed from 5000 to 0 (now deprecated)

  • innodb_thread_sleep_delay system variable default value changed from 10000 to 0 (now deprecated)

  • mysqld --xpand-master-skip-dml-binlog command-line option added

  • mysqld --xpand-replicate-alter-as-create-select command-line option added

  • mysqld --xpand-slave-ignore-ddl command-line option added

  • spider_link_mon_servers system table schema changed

  • spider_tables system table schema changed

  • spider_xa_failed_log system table schema changed

  • spider_xa_member system table schema changed

  • xpand_connect_timeout system variable default value changed from -1 to 10

  • xpand_master_skip_dml_binlog system variable added

  • xpand_password system variable removed

  • xpand_replicate_alter_as_create_select system variable added

  • xpand_slave_ignore_ddl system variable added

  • xpand_upsert_handler system variable default value changed from ON to OFF

  • xpand_username system variable removed

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.5.5-3 is provided for:

  • CentOS 8

  • CentOS 7

  • Debian 10

  • Debian 9

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

  • Ubuntu 20.04

  • Ubuntu 18.04

  • Ubuntu 16.04

  • Microsoft Windows

Note

MariaDB Enterprise Server 10.5 removes support for Red Hat Enterprise Linux (RHEL) 6 and CentOS 6.

Upgrade Instructions