MariaDB 11.8.6 Release Notes

MariaDB 11.8.6 is a Stable (GA) release of MariaDB Community Server 11.8, released on

Download Release Notes Changelog Overview of 11.8

^{Alternate download from mariadb.org}

Release date: ?

MariaDB 11.8.6 is a Stable (GA) release. It is an evolution of MariaDB 11.7 with several entirely new features.

MariaDB 11.8 is a long-term release.

For an overview of MariaDB 11.8 see the MariaDB 11.8 Changes and Improvements page.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• innodb_undo_log_truncate=ON leads to out-of-bounds write (MDEV-37042)

• Bogus [ERROR] InnoDB: Compressed page checksum mismatch could be reported for ROW_FORMAT=COMPRESSED tables. (MDEV-37306)

• When innodb_buffer_pool_size is not large enough to buffer all log records during crash recovery, InnoDB may fail to recover a page from the doublewrite buffer. (MDEV-37558)

• InnoDB could crash during a workload that is frequently rebuilding or dropping tables by executing statements such as TRUNCATE TABLE, OPTIMIZE TABLE, or DROP TABLE. (MDEV-37755)

• If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover. (MDEV-38026)

• MariaBackup fails during rollback of inplace FTS alter table (MDEV-38041)

• In multi-threaded write-heavy workloads, buf_pool.flush_list_mutex could become a point of contention. (MDEV-38069)

• Secondary indexes could be corrupted for InnoDB tables that contain indexed virtual columns. (MDEV-38140)

• Server hang during concurrent set innodb_encryption_threads (MDEV-38271)

• Under some circumstances, some read operations could unnecessarily wait for an InnoDB log write. (MDEV-38589)

Aria

• Fixed crash in Aria when doing a sub transaction like reading an entry from the proc table. (MDEV-23132)

RocksDB

• Server shutdown prevented by RocksDB setting rocksdb_pause_background_work (MDEV-38110)

Spider

• Spider could crash when loop detection variables were artificially manipulated. (MDEV-38368)

Authentication and Privilege System

• Only users with the TRIGGER privilege could see rows in the INFORMATION_SCHEMA.TRIGGERS table. The standard defines that only the columns ACTION_CONDITION, ACTION_STATEMENT and DEFINER columns are shown as NULL unless the user is the owner of the schema or has TRIGGER privilege, the other columns only require any edit privilege (MDEV-37474)

• INSERT ... RETURNING exposes columns for which the user lacks SELECT privilege (MDEV-37950)

• CHECK TABLE command can be executed by users with the table-level CREATE but not with global CREATE (MDEV-37971)

• REFERENCES permission on particular schema is sometimes ignored (MDEV-38209)

• SHA2 auth plugin crash on large packets (MDEV-38365)

Backup

• InnoDB: Failing assertion: tail.trx_no <= last_trx_no (MDEV-36845)

• On Unix-like systems, mariadb-dump --dir can fail due to access permission issue, when server and mariadb-dump run as different OS users. This can happen even if the OS users are in the same group, or mariadb-dump is executed as "root" OS user. (MDEV-38226)

Character Sets

• ASCII strings will be sent to client connections slightly faster. (MDEV-21816)

• On IA-32 and AMD64 depending on the build options, the server could crash due to an unaligned access when sending data to a client connection. (MDEV-37148)

Compiling

• Parsec client plugin is now compiled and packaged on Windows (MDEV-38360)

Data Definition - Alter Table

• OPTIMIZE table not replicating (MDEV-26618)

• Atomic DDL: Assertion !param->got_error failed upon unsuccessful multi-RENAME TABLE (MDEV-27027)

• Cannot remove default value of NOT NULL column (MDEV-37275)

Data Definition - Create Table

• Error message "No savepoint with that name upon ROLLBACK TO SAVEPOINT" shown on ROLLBACK TO SAVEPOINT (MDEV-36787)

• If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover. (MDEV-37994)

• (Column) CHECK constraints can cause CREATE TABLE (SELECT) queries to fail (MDEV-37998)

Data Manipulation - Delete

• ER_GET_ERRNO or server crash upon EXPLAIN DELETE with fulltext search subquery (MDEV-31255)

• Allow execution of multi-update/multi-delete queries within the storage engines. (MDEV-37484)

• Server crashes in setup_returning_fields upon 2nd execution of multi-table-styled DELETE from a view (MDEV-38620)

Data Manipulation - Insert

• Empty value inserted if BEFORE trigger and ENUM NOT NULL field (MDEV-37481)

• Server crashes after INSERT.. ON duplicate KEY UPDATE i = DEFAULT; (MDEV-38096)

Data Manipulation - Subquery

• An unresolvable outer reference can cause a server to crash. (MDEV-31632)

Data types

• Unexpected type changing after changing AVG to MAX (MDEV-37888)

• Unexpected Data too long error on subselect as a multiplication argument (MDEV-38626)

Events

• Event scheduler spams the error log (MDEV-38124)

Full-text Search

• Server crash upon moving InnoDB table with fulltext index between databases (MDEV-31892)

• Memory leak in innodb.import_hidden_fts_debug (MDEV-38391)

Galera

• Galera updated to 26.4.25

  • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated

• wsrep_store_key_val_for_row() may invoke memcpy() on nullptr (MDEV-30732)

• Wrong variable name in the configuration leads Galera to think SST/IST failed, at next restart will request a full SST (MDEV-31517)

• Sequence Fails with Galera Version 26.4.16 and later (MariaDB Server 10.6.17) in the Presence of Enabled Streaming Replication (MDEV-34124)

• Applier thread performing IST is left with REPEATABLE_READ isolation level (MDEV-37229)

• Galera cluster crashes when granting permission to non existing user after setting max_error_count and wsrep_ignore_apply_errors to zero (MDEV-37991)

• Galera nodes should operate when transaction-read-only=ON (MDEV-38073)

• Restore of dumped databases fails since ver 11.8.4 with ERROR 1100 if constraints are in place (MDEV-38216)

• Long blob prefix keys could cause a crash in galera. (MDEV-38374)

• Galera test failure on MDEV-38073 (MDEV-38383)

GIS

• ST_OVERLAPS returns true despite dim(originalInput1) ≠ dim(originalInput2) (MDEV-35765)

• Malformed spatial data could've caused a crash inside InnoDB (MDEV-38372)

JSON

• Unexpected success and result set upon erroneous JSON_VALUE call (MDEV-25148)

• JSON_SCHEMA_VALID() crashes with a long enum (MDEV-38356)

Optimizer

• EXPLAIN FOR CONNECTION (subquery) causes crash (MDEV-36353)

• Server crashes in Item_field::used_tables upon queries from a view (MDEV-36686)

• Assertion in create_ref_for_key() fails with disabled derived_merge (MDEV-37266)

• Incorrect results for INTERSECT ALL in ORACLE mode (MDEV-37325)

• Intermittent Replication Failure on a multi-table DELETE (MDEV-38003)

• Poor cost calculations for index access cause bad query plans for big VARCHARs in 11.x (MDEV-38164)

• Selectivity sampling for LIKE %foo% not done when the table has no sargable conditions (MDEV-38240)

• Wrong result with index_merge_sort_intersection and rowid_filter=on (MDEV-38327)

• Clustered PK not used for Loose Index Scan optimization (MDEV-38426)

• Potentially incorrect result with having reference to group by item. (MDEV-38473)

• We are trying to push aggregate into WHERE (MDEV-38487)

• Crash with low @@optimizer_max_sel_arg_weight and optimizer_trace=on. (MDEV-37510)

Optimizer - CTE

• Segfault when preparing unreferenced select in recursive CTE (MDEV-32299)

Optimizer - Window functions

• ref_ptrs exhaust on multiple ORDER by func from winfunc (MDEV-32317)

OTHER

• Prohibited semijoin with rownum, correctly process in HAVING rownum. (MDEV-37157)

Packaging

• ed25519 client authentication plugin would fail to load for anything but mariadb client utility. This has been fixed now. (MDEV-37527)

• Package mariadb-common conflicts with mysql-common (MDEV-38133)

• Incorrect BuildRequires entry in RHEL10 srpm (MDEV-38237)

• mariadb.socket as a systemd unit was corrected to include WantedBy=sockets.target that enables it to start correctly on boot. (MDEV-38313)

• Debian packages are missing many server include headers, such as handler.h (MDEV-38532)

Parser

• Lots of joins can crash the server (MDEV-38168)

• Fix MASTER_SSL_VERIFY_SERVER_CERT not usable as an unquoted identifier, unlike other CHANGE MASTER keys (MDEV-38194)

Partitioning

• ALTER puts row into different partition for system_time interval partitioning (MDEV-29114)

• INTERVAL partitioning by system time does not work close to the end of timestamp range (MDEV-33289)

• On partitioned tables algorithm is not supported throw "no such file or directory" error (MDEV-35562)

Performance Schema

• sys.ps_setup_save does not restore SQL_LOG_BIN after error, causes replication discrepancy (MDEV-37979)

Plugin - Hashicorp Key Management

• Hashicorp plugin lets keys timeout and doesn't use cached keys on vault errors (MDEV-38203)

Plugin - userstat

• Userstat Plugin CPU_TIME much higher than BUSY_TIME (MDEV-38028)

Protocol

• Auth Switch with Long Password Corrupts Database Name (MDEV-38431)

Replication

• An issue is fixed which could result in server hangs when a replica internally scans its mysql.gtid_slave_pos table contents. (MDEV-20586)

• Race of rolling back and committing transaction to binlog (MDEV-37541)

• For large transactions (i.e. those whose data exceeds the binlog_cache_size limit and spills into tmp files), provides a general performance improvement and fixes a bug that would lead to binlog corruption where the large transaction would have its GTID written into the binary log, without any additional transaction data, if the server's --tmp-dir was full. (MDEV-37662)

• Presence of Spider disables "external" XA commit (MDEV-37972)

• MDEV-37686 fixes are reverted which should restore parallel slave functionality back to normal (MDEV-38212)

• An issue is fixed where GRANT EXECUTE ON PROCEDURE would fail on the master, but would still be replicated and executed successfully on the slave. (MDEV-38506)

Scripts & Clients

• There was a short gap when mariadb-secure-installation temporary files were potentially openable/readable by an unprivileged user. These files may contain database root password. (MDEV-28823)

• mariadb-dump --dir doesn't convert db names (MDEV-38498)

• Missing Null terminator in the definition of mysqldump's --system typelib (MDEV-38642)

Sequences

• Server crashes after select from view (MDEV-28650)

Server

• SIGSEGV in store_server_fields on CREATE SERVER (MDEV-36230)

• Inconsistent results for make_set of cast (MDEV-38233)

• Inconsistent results for NULLIF function (MDEV-38283)

Stored routines

• SHOW FUNCTION CODE package_func crashes on the second execution (MDEV-38451)

Temporal Types

• Inconsistent behaviors when casting into time (MDEV-38006)

Views

• Crash when reading a corrupted view frm file (MDEV-38001)

Virtual Columns

• rr_from_cache does not update generated columns (MDEV-34984)

Changelog

For a complete list of changes made in MariaDB 11.8.6, with links to detailed information on each push, see the changelog.

---

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

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