MariaDB 11.7.2 Release Notes

New parameter --skip-freed-pages for . Use this parameter to not get freed undo logs reported as existing undo log pages. ()

Cloning of table statistics while saving the InnoDB table stats is now avoided ()

InnoDB deadlock output query length increased to improve visibility of deadlocked statements. ()

now works with INDEX DESC ()

Fix occasional failure of recovery of a multi-batch operation with InnoDB on startup ()

Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer ()

Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump ()

no longer ignores binary log events written with system timestamp 4294967295 and possibly all following events, avoiding potential data loss during recovery from binlogs ()

Table flags, preserved from the old storage engine after changing the storage engine of a table, can no longer break replication ()

Fix issue where / ALL REPLICAS errors without returning an error if the command could be executed due to wrong privileges. ()

Fix possibly wrong result using a degenerated subquery (SELECT ) with window function ()

Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory ()

Fix cluster node hang during shutdown if threadpool is used ()

MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB ()

Fix possible crash in wsrep_check_sequence ()

Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction ()

Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays ()

Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. ()

Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. ()

Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ ()

Fix possible crash in wsrep_sst_mariadb-backup script when upgrading node in cluster from 10.11.9 to 10.11.10. ()

wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours ()

Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED ()

Fix possible crash during index traversal using tree_search_next. ()

FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown ()

START TRANSACTION, when triggering an implicit commit as a COMMIT or ROLLBACK has not been executed before, now resets optional characteristics added to the last START TRANSACTION command ()

sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers ()

The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error ()

Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages ()

Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix ()

During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan ()

Fix debian-start script failure when using non-standard socket path ()

Fix possible hang or crash where zero offset applied to null pointer ()

Fixed issue where ST_PointFromWKB ignored SRID parameter and returned 0 ()

Fix possible hang during CREATE TABLE…SELECT error handling, especially with innodb_snapshot_isolation enabled ()

Fix incorrect locking order of LOCK_log/LOCK_commit_ordered and LOCK_global_system_variables ()

Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy ()

Fix possible memory leak on SHUTDOWN ()

Fix possible memory leak while shutting down server after installing the auth_gssapi plugin ()

Fix possible server crash when using INSERT DELAYED on tables with virtual columns. ()

Fix possible Spider crash or hang when the first byte of a connection key is changed ()

A BEFORE INSERT Trigger previously returned with error ""Field 'xxx' doesn't have a default value", if a NULL value is added for a column defined NOT NULL without explicit value and no DEFAULT specified ()

Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. ()

Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy ()

Comparison of UUID v1 and V6 could return incorrect results ()

INSERT SELECT on NOT NULL columns with BEFORE UPDATE trigger can fail with error 1048 (23000) ()

It was not possible to use a package body variable as a fetch target, instead error "Undeclared variable" was returned. ()

Validation of SSL certificate fails for mariadb-backup. For a MariaDB Cluster (Galera) SST operations can be affected ()