Release Notes for MariaDB Enterprise Server 10.6.5-2

InnoDB tables with ROW_FORMAT=COMPRESSED could be corrupted. (MENT-1367)

MariaDB Enterprise Cluster, powered by Galera, can crash on INSERT if the table does not have a primary key and if the data for a field exceeds 4096 bytes. (MDEV-24978)

When an InnoDB tablespace (.ibd) file is imported using ALTER TABLE .. IMPORT TABLESPACE without a corresponding .cfg file, InnoDB causes a server crash. (MDEV-26131, MDEV-20931)

When OPTIMIZE TABLE (or mariadb-check -o) is executed against an InnoDB table with a FULLTEXT index, InnoDB can cause a server crash. (MDEV-25702, MENT-1198)

Resolving aggregate functions that are used in a view can cause in a crash. (MDEV-24454)

Executing CREATE OR REPLACE TABLE AS SELECT under LOCK TABLE can cause in a crash. (MDEV-23391)

If two InnoDB tables have a foreign key and an operation cascades from the parent table to the child table, an index on a virtual generated column in the child table can become corrupt. (MDEV-26866)

MariaDB Enterprise Cluster, powered by Galera, crashes with errors like: [ERROR] WSREP: Trx 236236 tries to abort slave trx 236238 (MDEV-25835)

Server crashes when a table uses a sequence as a column default (DEFAULT NEXT_VALUE(my_seq)) and the table is used concurrently by both a prepared statement and a normal statement. (MDEV-22785)

InnoDB causes server crash when a table is converted from utf8mb3 to utf8mb4 (MDEV-25951)

When enabling MariaDB Enterprise Audit, server crash can occur. (MENT-1307)

MariaDB Enterprise Audit occasionally hangs when rotating logs. (MENT-1339)

On 64-bit Microsoft Windows when MyISAM accesses key buffer and key_buffer_size is greater than 4 GB, the server crashes. (MDEV-26533)

Using SET GLOBAL innodb_purge_threads to increase innodb_purge_threads, may cause a hang. (MENT-1331)

Enterprise Spider causes server crash when an ALTER TABLE operation requires access to a Data Node. (MDEV-26539)

InnoDB persistent statistics causes server to hang. (MDEV-15020)

On an InnoDB table, when a DDL statement rebuilds the parent table in a foreign key relationship, a concurrent INSERT into the child table sometimes causes a crash. (MDEV-26554)

On an InnoDB table, when the server crashes or is killed while a DROP TABLE or table-rebuilding ALTER TABLE operation is being executed, InnoDB causes a server crash during crash recovery, which occurs after the server has restarted. (MENT-1368)

InnoDB sometimes causes server crash during ALTER TABLE .. IMPORT TABLESPACE when the imported tablespace contains columns that have been instantly reordered or dropped. The MariaDB error log contains the following error message: (MDEV-18543)

Schema mismatch (Index field name newcol doesn't match tablespace metadata field name name for field position...

MariaDB Enterprise Cluster causes server crash when wsrep_on=OFF is set and transactions are in progress. (MENT-1236)

skip_networking does not prevent replication. (MDEV-24969)

MariaDB Enterprise Cluster joiner node incorrectly uses localhost for TLS certificate verification and fails to join cluster when wsrep_sst_method=mariabackup and encrypt=3 are configured. (MDEV-26360)

mariadb --binary-mode is not able to replay some mysqlbinlog outputs if \\0 is in the data. (MDEV-25444)

Memory leak with row-based replication can lead to high memory usage on replica servers. (MDEV-26712)

SHOW CREATE VIEW and mariadb-dump generate invalid SQL for some complex views. (MDEV-26299)

When statement-based or mixed replication is used and a DML statement encounters an error in a transaction that creates or drops a temporary table, non-committed writes to transactional tables can be incorrectly replicated to replica servers. (MDEV-26833)

MariaDB Enterprise Cluster joiner node fails to join cluster when wsrep_sst_method=mariabackup and Backward Compatible SST TLS Mode is configured. (MDEV-26211)

Spider does not work correctly for UDF and stored functions if used in a query's WHERE conditions. (MDEV-26545)

If an INVISIBLE column has a computed default value, an INSERT statement that doesn't specify a value for the column causes the default value to be ignored. (MDEV-25891)

Password validation plugins (including simple_password_check) cause a user's existing password hash to be removed from the server's in-memory privilege cache when the user tries to change their password to an invalid password. (MDEV-26650)

With MariaDB Enterprise Cluster, a TRUNCATE on a table with a Foreign Key Constraint is not replicated to other nodes. (MDEV-26053)

InnoDB's adaptive purging can decrease throughput by starving user threads after dict_sys.mutex removal. (MDEV-26356)

CONNECTION_ID column is NULL in information_schema.THREAD_POOL_QUEUES (MDEV-26440)

The server in some cases shows decreasing performance with notes InnoDB: Cannot close file... in the error log. This issue occurs only when open-files-limit is reached and a log-checkpoint is triggered. (MDEV-25215)

XA PREPARE sometimes leads to lock wait timeouts on replica servers. (MDEV-26682)

Replica server does not invalidate query cache after replicating table updates. (MENT-1360)

MariaDB Enterprise Cluster, powered by Galera, shows inconsistent values for wsrep_apply_window and wsrep_commit_window when comparing performance_schema.galera_group_members and information_schema.GLOBAL_STATUS (MENT-1333)

MariaDB Enterprise Cluster incorrectly streams XA transactions when wsrep_trx_fragment_unit=statements is set, which causes errors when the fragment is applied. (MENT-1344)

With MariaDB Enterprise Cluster, a replica server replicating from a MariaDB Enterprise Cluster node incorrectly uses the primary server's server_id and wsrep_gtid_domain_id values to generate GTIDs for local transactions. (MDEV-26250)

MariaDB Enterprise Backup does not write the current GTID to xtrabackup_binlog_info when a MariaDB Enterprise Cluster node is backed up and wsrep_gtid_mode=ON is set. (MDEV-26237)

When a new MariaDB Enterprise Cluster node is bootstrapped with wsrep_gtid_mode=ON set, the node's configured server_id and wsrep_gtid_domain_id values are overridden by the values present in the node's binary logs. (MDEV-26223)

With MariaDB Enterprise Cluster, changes to wsrep_gtid_domain_id in my.cnf are ignored on node restart. (MDEV-25115)

On CentOS 7, auth_pam_tool has incorrect permissions. (MDEV-26380)

Running mariadb-upgrade with no 'root'@'localhost' user may fail with the message The user specified as a definer ('root'@'localhost') does not exist FATAL ERROR: Upgrade failed. (MDEV-26925)