All pages
Powered by GitBook
1 of 8

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Release Notes - MariaDB 11.8 Series

Release notes for MariaDB Community Server 11.8 series

MariaDB 11.8.5 Release Notes

MariaDB 11.8.5 is a Stable (GA) release of MariaDB Community Server 11.8, released on 2025-11-14

Download Release Notes Changelog Overview of 11.8

Alternate download from mariadb.org

Release date: 14 Nov 2025

MariaDB 11.8.5 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 page.

Thanks, and enjoy MariaDB!

Notable Items

  • : This issue caused a partial data deletion when using the DELETE statement on MyISAM or Aria tables under specific conditions. InnoDB tables are not affected by this issue. Specifically, when a DELETE statement included a WHERE clause with a non-unique indexed column compared for equality with a literal (col=const) and the execution plan showed a "range" operation on that index, the query could fail to delete all matching rows. Users of MariaDB Community Server 11.8.4 are strongly advised to upgrade immediately to 11.8.5.

Changelog

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


MariaDB 11.8.1 Release Notes

MariaDB 11.8.1 is a Release Candidate (RC) release of MariaDB Community Server 11.8, released on 2025-02-13

Release date: 13 Feb 2025

is a current long-term development series of MariaDB. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

  • Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182)

Optimizer

  • Fix possibly wrong result using a degenerated subquery (SELECT ) with window function (MDEV-35869)

  • Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition (MDEV-35910)

  • Support ORDER BY and LIMIT for multi-table DELETE, index hints for single-table DELETE. (MDEV-30469)

  • Optimizer can now use indexed virtual columns in WHERE/ON clauses for improved query performance. (MDEV-35616)

  • Make SUBSTR(col, 1, n) = const_str sargable ()

PL/SQL

  • It is now possible to define default values (or expressions) for parameters to stored procedures, stored functions and UDFs (MDEV-10862)

  • New DECLARE TYPE type_name IS RECORD (..) with scalar members in stored routines (MDEV-34317)

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

  • Fix trigger created with "" which is adding rows to another table using "FOR EACH ROW insert into table2(id, name) values (NEW.id, NEW.name);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table (MDEV-34958)

  • A Trigger definition can now include column names for specifying the columns for which a trigger should be called (MDEV-34551)

  • Triggers can now use SIGNAL SQLSTATE '02TRG' to skip row operations (insert, update, delete) in BEFORE triggers, affecting data modification. ()

  • Fix possible hang or crash where zero offset applied to null pointer (MDEV-35864)

  • Comparison of UUID v1 and V6 could return incorrect results (MDEV-35468)

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

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

  • OS character sets "utf8" and "utf-8" now map to MariaDB character set "utf8mb4" for full UTF-8 support. (MDEV-22217)

  • 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. (MDEV-24935)

Scripts & Clients

  • When using with --innodb-optimize-keys, secondary index creation is delayed until after data load, potentially improving load speed. (MDEV-34740)

Changelog

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

Contributors

For a full list of contributors to MariaDB 11.8.1, see the MariaDB Foundation release announcement.

Download
Release Notes
Changelog
Overview of 11.8
MariaDB 11.8
MariaDB 11.7
MariaDB 11.8.1
Release Candidate (RC)
MariaDB 11.8
What is MariaDB 11.8?
MariaDB 11.8 Changes and Improvements
MDEV-38068
changelog
MDEV-34911
MDEV-34724

MariaDB 11.8.0 Release Notes

MariaDB 11.8.0 is a preview release of MariaDB Community Server 11.8, released on 2024-12-18

Download Release Notes Changelog Overview of 11.8

Release date: 18 Dec 2024

MariaDB 11.8 is a long-term development series of MariaDB. It is an evolution of MariaDB 11.7 with several entirely new features.

MariaDB 11.8.0 is a single preview release. Features are to be considered previews, and none are guaranteed to make it into MariaDB 11.8.

The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.8-preview.

For an overview of MariaDB 11.8, see the What is MariaDB 11.8? page.

Thanks, and enjoy MariaDB!

Notable Items

Vectors

  • New function for calculating either a Euclidean or Cosine distance between two vectors, depending on the underlying index type ()

  • aarch64 SIMD instructions now supported ()

Optimizer

  • Expanded ()

    • Implement ()

    • Implement ()

    • Optimizer hints did not make it into the final release.

InnoDB

  • Fix scalability with multiple threads ()

Importing

  • The --no-autocommit option is now set by default to allow faster data loading by InnoDB, writing only one undo log for the whole operation ()

  • has a new option --innodb-optimize-keys to delay creation of secondary indexes until after data load, resulting in faster loads. By default. ()

GIS

New GIS functions. These functions improve compatibility with MySQL 8.

  • ()

  • ()

  • ()

  • ()

Functions

  • New function. Given a byte count, returns a string consisting of a value and the units in a human-readable format ()

Referential Integrity

  • now also checks for referential integrity ()

Information Schema

  • When querying the , that have the same name as a native function no longer generate a warning ()

Optimizer can now take advantage of queries of the format (MDEV-34911)

  • Add basic optimizer support for - see (MDEV-35616)

  • (MDEV-34159)

  • (MDEV-34160)

  • (MDEV-34277)

  • (MDEV-34276)

  • (MDEV-34278)

  • MDEV-35450
    MDEV-34699
    MDEV-35504
    MDEV-34888
    MDEV-34860
    MariaDB 11.8
    MDEV-35049
    MDEV-32250
    MDEV-34740
    MDEV-34137
    MDEV-34138
    MDEV-34141
    MDEV-34158
    MDEV-31736
    MDEV-34309
    MDEV-35437

    Be notified of new MariaDB Server releases automatically by 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 page.

    The most recent release of MariaDB 11.8 is:

    Stable (GA)

    Be notified of new MariaDB Server releases automatically by 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 page.

    Be notified of new MariaDB Server releases automatically by 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 page.

    The most recent release of MariaDB 11.8 is:

    Stable (GA)

    subscribing
    subscribing
    MariaDB 11.8.5
    Download Now
    Alternate download from mariadb.org
    subscribing
    MariaDB 11.8.5
    Download Now
    Alternate download from mariadb.org

    MariaDB 11.8.3 Release Notes

    MariaDB 11.8.3 is a Stable (GA) release of MariaDB Community Server 11.8, released on 2025-08-06

    The most recent release of MariaDB 11.8 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 11.8

    Alternate download from mariadb.org

    Release date: 6 Aug 2025

    MariaDB 11.8.3 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 page.

    Thanks, and enjoy MariaDB!

    Notable Items

    Storage Engines

    InnoDB

    • After SET GLOBAL innodb_buffer_pool_size was aborted while attempting to shrink the buffer pool, executing SET GLOBAL innodb_adaptive_hash_index=ON could lead to corruption of the adaptive hash index. ()

    • Fatal InnoDB error: Unknown error Temp file write failure ()

    • When innodb_buffer_pool_size is being shrunk while there are no data pages cached, InnoDB could hang or crash. ()

    • After a successful shrinking of innodb_buffer_pool_size, there will be no message about it in the server error log.

    Aria

    • Assertion when adding FK to MyISAM/Aria table with a vector index ()

    Data Definition - Alter Table

    • Adding (with ALTER TABLE) a UNIQUE constraint that is USING HASH to a table with foreign keys could've caused the table to become corrupted. ()

    • DROP DEFAULT makes SHOW CREATE non-idempotent ()

    Partitioning

    • Server crashes in do_mark_index_columns instead of ER_DUP_ENTRY on partitioned table ()

    • A replica would crash while replicating UPDATE and DELETE DML statements that target a table which previously had a partition that was converted to a separate table via ALTER TABLE .. CONVERT PARTITION .. TO TABLE. For example, if the command looked like ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE t_new; the replica would crash when trying to update/deleterows in table t1 after running the command. ()

    Data Definition - Create Table

    • CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed ()

    Server

    • Segfault on INTERSECT ALL with UNION in Oracle mode ()

    • In certain cases privileges on sequences were too restrictive, for example, SELECT on a table might've erroneously required INSERT privilege on a sequences ()

    mariabackup

    • This commit fixes a bug where Aria tables are used in (master->slave1->slave2) and a backup is taken on slave2. In this case it is possible that the replication position in the backup, stored in mysql.gtid_slave_pos, will be wrong. This will lead to replication errors if one is trying to use the backup as a new slave. ()

    • Maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running. ()

    Optimizer

    • MariaDB server crash when a query includes a derived table containing unnamed column. ()

    • Crash in add_keyuses_for_splitting() when joining with a derived table ()

    • Split Materialized code: last_refills is never set in 11.0+ ()

    • Don't generate index_merge plans, if a column is present in both Secondary Key and Primary Key indexes and either of the indexes include it with DESC order (as the scan itself is not a ROR scan). ()

    JSON

    • Starting from 10.11.12, Incorrect handling of UTF-8 characters (and other character sets requiring more than a single byte representation) in the minimum/maximum positions of a table during the execution of ANALYZE TABLE tbl PERSISTENT FOR ALL resulted in an endless loop consuming more memory and prevented the server from terminating. ()

    Galera

    • updated to 26.4.23

    • galera_3nodes.inconsistency_shutdown test occasionally hangs ()

    • Galera-26.4.23 corrects an incompatibility with OpenZFS >= 2.3.0 enabling the use of galera on this filesystem.

    Replication

    • semi sync makes the master unresponsive when a replica is stopped ()

    • parallel slave ALTER-SEQUNCE attempted to binlog out-of-order ()

    • mysqldump --dump-slave always starts stopped slave ()

    • Optimize Rows_log_event Reporting of Process Info ()

    Stored routines

    • Crash when calling stored function in FOR loop argument ()

    Authentication and Privilege System

    • ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression ()

    Locking

    • Deadlock does not rollback transaction fully ()

    Data Manipulation - Insert

    • UNIQUE constraint that was USING HASH and UNIQUE constrant WITHOUT OVERLAPS could be violated under heavy load in READ COMMITTED transaction isolation mode. ()

    Character Sets

    • Changing the server character set in my.cnf could cause debian-start script to fail with "Illegal mix of collations" ().

    Plugin - AWS key management

    • aws_key_management compilation was previously broken, is now fixed. plugin can be compiled again. As before, -DNOT_FOR_DISTRIBUTION=ON is necessary to build it. ()

    Packaging

    • mariadb systemd mult-instance service was changed to not attempt changes to the permissions on its pam helper server. This prevented unconstructive behaviour and errors in the systemd journal when starting the mariadb@.service. ()

    Sequences

    • Remove the error codes added to 10.11 by the MDEV-36032 patch ()

    XA

    • DML committed within XA transaction block after deadlock error and implicit rollback ()

    General

    • Add option to not collect statistics for long char/varchars ()

    • Packages for RHEL8 no longer depend on liburing. The RHEL8 kernel had insufficient kernel support so linking was an unneeded dependency. libaio was sufficient ()

    • SLES 15 SP6 and SLES 15 SP7 are new packages in this release. Because of incompatibilities of packages between SLES service pack versions there are now separate packages for 15sp6 and 15sp7. An upgradeable repo file should include "sles/$releasever/$basearch" rather than the "sles15-amd64" or "sles/15/x86_64" path that may exist currently. (, )

    Changelog

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


    • After a failed shrinking of innodb_buffer_pool_size, the adaptive hash index will not be re-enabled if innodb_adaptive_hash_index was ON when SET GLOBAL innodb_buffer_pool_size=... started to execute. (MDEV-36868)

  • AUTO_INCREMENT leads to non-serializable on results (MDEV-36330)

  • Vector index was corrupted if one statement was rolled back (e.g. insert violating a unique constraint) in the middle of a larger transaction. (MDEV-37068)

  • The new parameter innodb_linux_aio controls which Linux implementation to use for innodb_use_native_aio=ON. (MDEV-36234)

    • innodb_linux_aio=auto is equivalent to innodb_linux_aio=io_uring when it is available, and falling back to innodb_linux_aio=aio when not.

    • Previously, only one implementation (libaio or io_uring) was available. Currently, if io_uring is disabled in the environment, we will fall back to the older libaio interface.

  • Incorrect handling of null values on join conditions. (MDEV-37057)

    Seconds_Behind_Master Spike at Log Rotation on Parallel Replication (MDEV-36840)

    Fedora 42 is a new release version and x86_64 and aarch64 packages are available (MDBF-1060)
  • Red Hat Enterprise Linux 10 packages are available for x86_64, aarch64, ppc64le, and s390x hardware platforms (MDBF-995)

  • Centos Stream 9 previously missed building a MariaDB-provider-lzo package and this has been corrected (MDBF-1038)

  • This is the last release of the interim Ubuntu 24.10 which ended its standard support in July 2025 (MDBF-1090)

  • Ubuntu 25.04 (Plucky Puffin) packages are available for amd64 and arm64 (MDBF-849)

  • Debian 13 (Trixie) packages are available for amd64, arm64, ppc64le and i386 (MDBF-848)

  • MariaDB 11.8 Changes and Improvements
    MDEV-36863
    MDEV-36017
    MDEV-37263
    MDEV-37022
    MDEV-36852
    MDEV-29001
    MDEV-36817
    MDEV-36906
    MDEV-29155
    MDEV-25158
    MDEV-36870
    MDEV-36143
    MDEV-36860
    MDEV-24588
    MDEV-30711
    MDEV-36323
    MDEV-36410
    MDEV-36765
    MDEV-36968
    MDEV-36934
    MDEV-35570
    MDEV-7611
    MDEV-36839
    MDEV-26115
    MDEV-36280
    MDEV-36959
    MDEV-37199
    MDEV-36815
    MDEV-30831
    MDEV-36738
    MDEV-36856
    MDEV-37141
    MDEV-36536
    MDBF-1042
    MDBF-1067
    MDEV-36945
    changelog
    MariaDB 11.8.5
    Download Now
    Alternate download from mariadb.org
    Galera

    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 page.

    MariaDB 11.8 Changes & Improvements

    An overview of changes, improvements, and what's new in MariaDB Community Server 11.8

    is a long-term release, maintained until June 2028.

    This list includes all features since the previous long-term release, (those introduced in the , and rolling releases, and in MariaDB 11.8).

    Upgrading

    • Note that if you are using system versioned tables, all rows and indexes has to be updated in these to use the extended timestamp range ('

    2106-02-07 06:28:15 UTC
    '). Upgrading to 11.8 can take a
    long time
    if you have many rows in your system versioned tables!
  • If you are not using system versioned tables and you are upgrading from 10.0 and up, the upgrade should just take a few seconds.

  • See Also: and .

  • Downgrading

    • If you have system versioned tables, downgrading is not trivial. In other cases see .

    New Features

    Vectors

    • Functions and

    • Functions , , for calculating either a Euclidean or Cosine distance between two vectors. The last one automatically uses Euclidean or Cosine, depending on the underlying index type (MDEV-35450)

    • Vector indexes can use x86_64 (AVX2 and AVX512), aarch64 neon (MDEV-34699) and Powerpc64 AltiVec () SIMD instructions

    Character Sets

    • The default has been changed from latin1 to utf8mb4 (MDEV-19123, MariaDB 11.6)

    • Change to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)(MDEV-25829, MariaDB 11.5)

    Optimizer

    • Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies (MDEV-25008)

    • The is now on by default (MDEV-34380)

    • Optimizer can now take advantage of queries of the format (MDEV-34911)

    • Add basic optimizer support for - see (MDEV-35616)

    • is now supported for partitioned tables (, )

    • ANALYZE for statement should show selectivity of pushed index condition (, )

    System-Versioned Tables

    • Allow a to be converted from implicit to explicit row_start/row_end columns (MDEV-27293)

    Temporary files and tables

    • (MDEV-9101, MariaDB 11.5)

      • There are two system variables used for controlling this feature (MariaDB 11.5):

        • : Limits the temporary space allowance per user

        • : Limits the temporary space allowance for all users.

    Data Types

    • The range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188, MariaDB 11.5). Note that if you are using system versioned tables, all rows have to be updated in these to use the new end range. This can take a long time if you have many rows in your system versioned tables!

    Authentication

    • (MDEV-32618, MariaDB 11.6)

    • Extend to support authentication_string (MDEV-33479, MariaDB 11.6)

    InnoDB

    • Fix scalability with multiple threads (MDEV-35049)

    Backup and Restore

    • Parallel dump of multiple databases via with the --dir option (MDEV-33625, MariaDB 11.5)

    • Parallel import of multiple databases via with the --dir option (MDEV-33627, MariaDB 11.6)

      • Added the related --database, --ignore-database, --table and --ignore-table options.

      • Refactor threading

    • The --no-autocommit option is now set by default to allow faster data loading by InnoDB, writing only one undo log for the whole operation ()

    • has a new option, --innodb-optimize-keys to delay creation of secondary indexes until after data load, resulting in faster loads. On by default. ()

    Replication

    • When is enabled, committing a large transaction no longer freezes all other transactions until completed (MDEV-32014, MariaDB 11.7)

    • has been deprecated (MDEV-33756, MariaDB 11.7)

    • Async rollback prepared transactions during binlog crash recovery (MDEV-33853, MariaDB 11.7)

    • New variable, , for aborting long-running queries on a replica (, )

    • deprecated (, )

    • New definition for Seconds_Behind_Master (, )

      • Added three variables to

      • New

    Galera

    • Automatic SST user account management (MDEV-31809, MariaDB 11.6)

    UUID

    • New function for generating version 4 UUIDs (MDEV-11339, MariaDB 11.7)

    • New function for generating version 7 UUIDs (MDEV-32637, MariaDB 11.7)

    Other Functions

    • New function. Given a byte count, returns a string consisting of a value and the units in a human-readable format (MDEV-31736)

    Protocol

    • Permit bulk implementation to return ALL individual results (MDEV-30366, MariaDB 11.5)

    • Send initial values of system variables in first OK packet (MDEV-31609, MariaDB 11.5)

    Observability

    • New in the Information Schema for storing information about users, , and the limits set by (MDEV-23729, MDEV-32218, MariaDB 11.5)

    • Add more columns to Information Schema , and tables (MDEV-33151, MariaDB 11.5)

    • Add QUERIES column to Information Schema table (MDEV-33152, MariaDB 11.5)

    • Add (, )

    • Provide InnoDB async IO statistics (, )

    • Extend to be compatible with Percona server (, )

    • Additional features for Sequences (MDEV-28152, MariaDB 11.5)

      • permits creating as any type (including ), extending the range

      • Parser accepts larger and smaller values for and

    • on no longer attempts to collect statistics ()

    System-Versioned Tables

    • Allow a to be converted from implicit to explicit row_start/row_end columns (MDEV-27293, MariaDB 11.7)

    Stored Routines

    • ROW data type for stored function return values (MDEV-12252, MariaDB 11.7)

    • Stored routines parameters can have default values (MDEV-10862)

    • Update triggers can optionally have a list of columns an update of which executes the trigger. Updating other columns does not execute the trigger (MDEV-34551)

    Derived Tables

    • Add optional correlation column list for (MDEV-31466, MariaDB 11.7)

    [SHOW] CREATE SERVER

    • Implement (MDEV-15696, MariaDB 11.7)

    • Allow arbitrary options in (MDEV-34716, MariaDB 11.7)

    Slow Query Log

    • New variable, , for specifying that all queries longer than this time are logged to the , regardless of and (MDEV-33144, MariaDB 11.7)

    Information Schema

    • When querying the , that have the same name as a native function no longer generate a warning (MDEV-35437)

    Spider

    • The Spider variables and have been deprecated (MDEV-28009, MariaDB 11.7)

    • Deprecate (MDEV-31789, MariaDB 11.5)

    General

    • , which used to be an alias for now shows the value of when the session was created (MDEV-30908, MariaDB 11.7)

    • CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) (MDEV-15751, MariaDB 11.7)

    • A warning has been added when is exceeded. (MDEV-27277, MariaDB 11.7)

    • Single-table now support table aliases (, )

    • Set thread names for MariaDB Server threads (, )

    • (, )

    Variables

    • Deprecate and ignore the system variable (MDEV-33655, MariaDB 11.5)

    • For a list of all new variables, see

    Removed Features

    The following deprecated features have been removed:

    • <data type> <character set clause> ... COMPRESSED... (MariaDB 11.5)

      • the correct syntax is <data type> COMPRESSED... <character set clause> ...

    • (MariaDB 11.5)

    • (and the related variable). ()

    List of All MariaDB 11.8 Releases

    Date
    Release
    Status
    Release Notes
    Changelog

    14 Nov 2025

    MariaDB 11.8.5

    Stable (GA)

    6 Nov 2025

    MariaDB 11.8.4

    Stable (GA)

    MariaDB 11.8
    MariaDB 11.4
    MariaDB 11.5
    MariaDB 11.6
    MariaDB 11.7

    The most recent release of MariaDB 11.8 is:

    MariaDB 11.8.5 Stable (GA) Download Now

    Alternate download from mariadb.org

    MariaDB 11.8.4 Release Notes

    MariaDB 11.8.4 is a Stable (GA) release of MariaDB Community Server 11.8, released on 2025-11-06

    An issue has been discovered which causes partial data deletion when using the DELETE statement on MyISAM or Aria tables under specific conditions. InnoDB tables are not affected by this issue.

    Specifically, when a DELETE statement included a WHERE clause with a non-unique indexed column compared for equality with a literal (col=const) and the execution plan showed a "range" operation on that index, the query could fail to delete all matching rows. Users of MariaDB Community Server 11.8.4 are strongly advised to upgrade immediately to 11.8.5.

    Release date: 6 Nov 2025

    MariaDB 11.8.4 is a release. It is an evolution of with several entirely new features.

    is a .

    For an overview of MariaDB 11.8 see the page.

    Thanks, and enjoy MariaDB!

    Notable Items

    Storage Engines

    InnoDB

    • The InnoDB purge subsystem will no longer reset transaction identifiers in freshly inserted records, because it did severely hurt performance in some workloads. ()

    • InnoDB could crash after a DROP TABLE, TRUNCATE TABLE, OPTIMIZE TABLE or a table-rebuilding ALTER TABLE if innodb_adaptive_hash_index entries existed in the table. ()

    • InnoDB could crash if the definition of the InnoDB persistent statistics tables were incorrect. ()

    • Workloads that are bound by innodb_log_file_size would write out unnecessarily many data pages in an attempt to advance the log checkpoint. (

    Aria

    • Recovery of Aria transactional tables did not work in big-endian machines like s390x and Sparc.()

    • Failure to detect corruption during backups of Aria table ()

    Connect

    • BsonGet_String and JsonGet_String with a NULL argument resulted in an empty string warning. This now has an "Argument is NULL" warning. ()

    Federated

    • FederatedX error 10000 on multi-table UPDATE/DELETE ()

    MyISAM

    • myisamchk -V crashes ()

    RocksDB

    • Corrected python3 compatibility of myrocks_hotbackup thanks to contributor i18n.site ()

    Spider

    • Server may crash in spider bg mode if multiple queries are sent by spider bg threads consecutively ()

    • Spider: XA COMMIT ONE PHASE fails with "This xid does not exist" ()

    Full-text Search

    • InnoDB could potentially crash if there is any lock conflict on an internal FTS_%_CONFIG table of a FULLTEXT INDEX while one of the INFORMATION_SCHEMA views INNODB_TRX, INNODB_LOCKS, or INNODB_LOCK_WAITS are being accessed. ()

    • The minimum value of the parameter innodb_ft_min_token_size was increased to 1, similar to the parameter ft_min_word_len. ()

    Optimizer

    • Prevent MariaDB server crash when a query includes a derived table containing unnamed column. ()

    • Crash when considering Split-Materialized plan ()

    • Wrong result when split optimization is used for grouping with order by and limit ()

    • Correlated derived table query merges can cause crashes, especially with prepared statements. ()

    Sequences

    • Fixed crashing bug when inserting into a tables with several nextval(sequence) default values. ()

    Galera

    • Setting wsrep_slave_threads causes thread hang when wsrep is not enabled ()

    • MariaDB Cluster server crash during insert when replication filters are used ()

    • Inconsistency detected - create sequence ()

    • InnoDB partition table disallow local GTIDs in galera ()

    Plugins

    • Change several Plugin Maturity Levels ()

    Plugin - Audit

    • Wrong query_ids are logged by the server_audit plugin for inserts by triggers when multi-insert statements are used ()

    • Fix server_audit rwlock Performance Schema instrumentation ()

    Plugin - Hashicorp Key Management

    • Hashicorp Plugin: enable key version caching by default ()

    Plugin - userstat

    • The number of concurrent connections reported by userstats, when enabled, is updated. ()

    JSON

    • Corrected the creation of views on JSON_TABLEs to require no special privileges. ()

    • JSON_ARRAY_INTERSECT function crashes the server when called with empty json arrays ()

    • View containing JSON_TABLE does not return JSON ()

    • Wrong result json_table ()

    Parser

    • very long query cannot be killed quickly ()

    Server

    • LIMIT ROWS EXAMINED prematurely triggers during optimization ()

    • Exchange partition with virtual columns fails ()

    • ALTER TABLE allows adding unique hash key with duplicate values ()

    • LOCATE(X,Y,NULL) is not NULL ()

    Locking

    • DDL in procedure propagates no locking to tables locked by DML ()

    Partitioning

    • Errors or assertion failure upon REPAIR on partitioned Aria table with misplaced rows ()

    Platform RedHat

    • On Fedora, RHEL, and derivatives, depend on the mysql-selinux-1.0.14 package that provides the correct selinux rules for the /usr/sbin/mariadbd that is installed. ()

    Platform Windows

    • On Windows, when MSI package is installed, with ADDLOCAL parameter passed to msiexec.exe, and Visual C++ Redistributable package is not installed on the target machine, installation may fail during "create database" step. ()

    Stored routines

    • Crash when calling stored function in FOR loop argument ()

    • Fix crash by correctly updating SP instruction state after instruction re-parsing , preventing dangling reference. ()

    GIS

    • Several bugs in SPATIAL INDEX page splitting logic could crash InnoDB if the PRIMARY KEY or the SPATIAL data is variable-length. ()

    • Wrong results for self-touching shapes. ()

    Optimizer - CTE

    • Server crash on cleanup of non-fully-constructed-due-to-an-error CTE ()

    Packaging

    • A tmpfiles file will now create /run/mysqld path on Debian/Ubuntu packaged distributions. ()

    • server cannot load client plugins on Debian ()

    • Previous systemd warnings in recent systemd versions about uninitialised environment variables have been corrected. ()

    • The PrivateDevices=false directive in the systemd service has been removed as it was an old kernel incompatibility that this directived worked around. With this, the MariaDB is restricted further. Those using InnoDB on raw devices will need to add an override for this. See https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd#useful-systemd-options (

    Backup

    • Parallel slave worker crashes During Backup at retrying ()

    Scripts & Clients

    • mariadb-dump -T did not encode table names like the server did for frm files, so some tables can be created in the server, but not dumped with mariadb-dump -T, for example, a table con on Windows. ()

    • Using mytop with DBD-MariaDB and host=localhost specified resulted in an unexpected error because the driver did not expect a port 3306. Contribution thanks to Jean Weisbuch. ()

    Authentication and Privilege System

    • Backport “Implement a caching_sha2_password plugin” ()

    Versioned Tables

    • REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY) ()

    Prepared Statements

    • Parameterized PS converts error to warning, causes replication problems ()

    Admin statements

    • Assertion failure in online_alter_log_row or server hang upon replicating REPAIR on mysql.gtid_slave_pos ()

    Data Definition - Create Table

    • Innodb did not handle case-sensitivity on Windows correctly prior to this fix in its data dictionary, converting all names to lowercase. This resulted in inconsistency, if data directory was in case-sensitive NTFS directory, as well as in situations when data directory was copied from Windows to Unix systems. This is fixed in this patch. ()

    mariabackup

    • Fixed bug in maria-backup where maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running. ()

    Replication

    • Fix --master-retry-count=0 not infinite as described ()

    • Ensure that Annotate_rows is always written direct after GTID information, before any table_map events. Before this patch the event could be written in a random position in the binary log. This change make the place of the Annotate_rows event predictable. When mixing transactional and not transactional tables in the same transaction, the Annotate rows event was not always written in the case of a rollback. This is now fixed. ()

    • ALTER TABLE ... ENGINE=MRG_MyISAM is now properly logged as an DDL. This ensure that the changed MERGE table cannot be used by a slave thread until after the ALTER command has been executed. ()

    Configuration

    • Galera galera_new_cluster scipt and its systemd interactions was rewritten to avoid selinux errors. This will require the mysql-selinux-1.0.14+ version that is a dependency of the server in RPM+selinux distributions. ()

    Changelog

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


    Do not use non-stable (non-GA) releases in production!

    Do not use non-stable (non-GA) releases in production!

    )
  • ALTER TABLE could fail to update InnoDB persistent statistics. (MDEV-35163)

  • Some lock elision code that was detrimental to performance was removed. (MDEV-36190)

  • MariaDB upgrade fails when using innodb_encrypt_tables=ON and innodb_checksum_algorithm=crc32, which is not the default. innodb_checksum_algorithm=crc32 is used only if explicitly specified or if the table has been created which MariaDB 10.4 or a prior version (MDEV-36556)

  • innochecksum misinterprets doublewrite buffer pages (MDEV-37138)

  • The performance of ANALYZE FORMAT=JSON as well as the counter innodb_buffer_pool_read_requests was improved. (MDEV-37152)

  • Crash recovery after bulk load data reports corruption (MDEV-37192)

  • When a page needs to be read into the InnoDB buffer pool, concurrent access to the page will avoid some hash table lookup and busy waiting. (MDEV-37244)

  • InnoDB could crash during the crash recovery of a corrupted database. (MDEV-37412)

  • There was a very small chance of InnoDB crashing or misbehaving after an attempt to reduce innodb_buffer_pool_size. (MDEV-37447)

  • The performance of innodb_adaptive_hash_index=ON was improved further. We introduce the parameter innodb_adaptive_hash_index_cells that can be configured with SET GLOBAL. The specified value will be effectively multiplied by innodb_adaptive_hash_index_parts, because each partition will contain its own hash table. (MDEV-37482)

  • The forced use of THD accessor functions hurts InnoDB performance (MDEV-37619)

  • CHECK TABLE…EXTENDED could flag bogus corruption on a column prefix index. (MDEV-37659)

  • During workload after crash recovery, an incorrect (too large) innodb_buffer_pool_pages_dirty could be reported. (MDEV-37677)

  • In rare cases, shutdown might hang (MDEV-37728)

  • Lock checks for secondary indexes were unnecessarily accessing some history and could access freed BLOB pages that correspond to column prefixes. (MDEV-37753)

  • Crash if subquery is a UNION of SELECT rand() and uncorrelated SELECT (MDEV-32403)

  • UPDATE/DELETE of single table queries would now show r_table_time_ms, and r_other_time_ms during ANALYZE FORMAT=JSON (MDEV-33309)

  • Explain format=json with a DML statement containing a derived table and some manner of execution abortion, a timeout or kill will lead to an assertion or crash. (MDEV-36034)

  • Query does not recognize advantage of using primary key index (MDEV-36761)

  • Item_func_nextval::val_int() crash on INSERT...SELECT with subqueries (MDEV-37345)

  • IS TRUE incorrectly converts outer join to inner (MDEV-37653)

  • TPROC-H, no stats: Query4 much slower in 11.4 than in 10.11 (MDEV-37723)

  • Wrong result with Loose Scan on QUICK_GROUP_MIN_MAX_SELECT WITH TIES (MDEV-37901)

  • disable_index_merge_plans causes SELECT data loss when more than 100 ORs (MDEV-37913)

  • The galera_new_cluster script was installed into the scriptdir in the 2025 Q3 releases. It previously was in the bin dir. The difference is only noticeable on bintar releases. (MDEV-37497)

  • Galera replication does not preserve the character set and collation associated with views, etc. (MDEV-37857)

  • MDL conflict between CREATE TRIGGER and INSERT (MDEV-37965)

  • Under selinux, the galera SST port checking resulted in excessive AVC notices. This has been simplified under selinux. (MDEV-37899)

  • json_array_intersect previously crashed when there was an unused table reference in the SQL query. (MDEV-36809)

  • Correct return value of JSON_VALUE which in the previous release, incorrectly converted a valid empty string return value to a NULL. This has been reverted to correct behaviour. (MDEV-37428)

  • mysqli silently trims each json_arrayagg result to modulo 64KB (MDEV-37835)

  • Introduce @@new_mode variable (MDEV-37784)

    )
    Download
    Release Notes
    Changelog
    Overview of 11.8
    Alternate download from mariadb.org
    Stable (GA)
    MariaDB 11.7
    MariaDB 11.8
    long-term release
    MariaDB 11.8 Changes and Improvements
    MDEV-16168
    MDEV-26599
    MDEV-31740
    MDEV-34914
    MDEV-37520
    MDEV-37633
    MDEV-29874
    MDEV-37505
    MDEV-36010
    MDEV-36325
    MDEV-37829
    MDEV-36545
    MDEV-37423
    MDEV-24588
    MDEV-29638
    MDEV-31887
    MDEV-32294
    MDEV-37172
    MDEV-30418
    MDEV-36134
    MDEV-37366
    MDEV-37373
    MDEV-37858
    MDEV-37434
    MDEV-37555
    MDEV-30849
    MDEV-23283
    MDEV-27898
    MDEV-33149
    MDEV-34081
    MDEV-36319
    MDEV-37938
    MDEV-22241
    MDEV-34033
    MDEV-37296
    MDEV-37740
    MDEV-16686
    MDEV-33190
    MDEV-24941
    MDEV-36938
    MDEV-26115
    MDEV-37489
    MDEV-27675
    MDEV-31499
    MDEV-32308
    MDEV-15502
    MDEV-34744
    MDEV-35904
    MDEV-37453
    MDEV-37483
    MDEV-37852
    MDEV-9804
    MDEV-37600
    MDEV-15990
    MDEV-34046
    MDEV-34134
    MDEV-34953
    MDEV-36860
    MDEV-36002
    MDEV-37356
    MDEV-37903
    MDEV-37726
    changelog

    The most recent release of MariaDB 11.8 is:

    MariaDB 11.8.5 Stable (GA) Download Now

    Alternate download from mariadb.org

    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 page.

    MDEV-35155
    MDEV-36721

    6 Aug 2025

    MariaDB 11.8.3

    Stable (GA)

    Release Notes

    Changelog

    4 Jun 2025

    MariaDB 11.8.2

    Stable (GA)

    Release Notes

    Changelog

    13 Feb 2024

    MariaDB 11.8.1

    RC

    Release Notes

    Changelog

    18 Dec 2024

    MariaDB 11.8.0

    Alpha

    Release Notes

    MDEV-36184
    MDEV-12404
    MariaDB 11.5
    MDEV-18478
    MariaDB 11.5
    MDEV-32250
    MDEV-34740
    MDEV-34857
    MariaDB 11.7
    MDEV-33756
    MariaDB 11.7
    MDEV-33856
    MariaDB 11.6
    MDEV-33145
    MariaDB 11.5
    MDEV-32841
    MariaDB 11.5
    MDEV-33501
    MariaDB 11.5
    MDEV-33938
    MDEV-33988
    MariaDB 11.6
    MDEV-32537
    MariaDB 11.6
    MDEV-33449
    MariaDB 11.5
    MariaDB 11.5
    Release Notes
    Changelog
    Release Notes
    Changelog

    MariaDB 11.8.2 Release Notes

    MariaDB 11.8.2 is a Stable (GA) release of MariaDB Community Server 11.8, released on 2025-06-04

    The most recent release of MariaDB 11.8 is:

    Stable (GA)

    Download Release Notes Changelog Overview of 11.8

    Alternate download from mariadb.org

    Release date: 4 Jun 2025

    MariaDB 11.8.2 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 page.

    Thanks, and enjoy MariaDB!

    Notable Items

    Storage Engines

    InnoDB

    • Race condition between log_t::resize_start() and log_t::resize_abort() ()

    • Race conditions between ALTER TABLE or OPTIMIZE TABLE and the purge of transaction history were fixed. ()

    • Server crashes when resizing default innodb buffer pool after setting innodb-buffer-pool-chunk-size to 1M ()

    • ASAN errors in dict_sys_t::load_table / get_foreign_key_info after failing to load a table ()

    RocksDB

    • Assertion `!level_and_file.second->being_compacted' failed in LevelCompactionBuilder::SetupInitialFiles ()

    • Assertion `ikey_.type == kTypeValue' failed in rocksdb::CompactionIterator::NextFromInput ()

    Spider

    • intended to fix spider wrapper so that it is case insensitive, among other things. However that fix was incomplete, as the udf spider_direct_sql may still require case sensitivity. fixes this. ()

    • The untested ha_spider::index_first_internal constructs broken queries ()

    • Unexpected error 1264 'Out of Range Value for Column' when inserting into ... select ... from a spider table ()

    • Tests calling the udf spider_copy_tables fail with --view-protocol (

    Connect

    • Connect crashes server because of duplicate 'free()' in GetUser ()

    Versioned Tables

    • Assertion InnoDB searching row in wrong partition for multiple system versioned DELETE with same timestamp and same multistatement transaction ()

    Optimizer

    • A server crash is possible when a statement is executed that satisfies all of these requirements: ()

      • It is a data-modifying statement (UPDATE/DELETE/etc)

      • It uses a condition that produces a warning during optimization (typically, a type mismatch)

      • The client is using a bulk operation

    Stored routines

    • Stored routine with a cursor crashes on the second execution if a DDL statement happened ()

    Data Definition - Alter Table

    • ALTER TABLE…SEQUENCE does not work correctly with InnoDB ()

    • The server could crash when an UPDATE is about to commit concurrently with a CREATE INDEX that includes VIRTUAL columns ()

    • ALTER TABLE…DROP COLUMN after a failed ALTER TABLE…DROP COLUMN could lead to a server crash ()

    Backup

    • mariadb-backup --backup crash during innodb_undo_log_truncate=ON, innodb_encrypt_log=ON ()

    • MariaDB Backup returns with an error like "Error on file ./test/t1#P#p513.MYD open during `test`.`t1` table copy for partitioned MyISAM tables when running out of file handles ()

    • make mariadb-backup to force an innodb checkpoint ()

    GIS

    • Server aborts while deleting the record in spatial index ()

    Upgrades

    • Upgrades fail on Windows ()

    Server

    • MariDB 11.7.2 - /usr/sbin/mariadbd got signal 11 ()

    • Protocol_text allocates memory without error checking, potentially leading to server crashes. ()

    • Server crash in find_field_in_tables, Assertion `name' failed in find_field_in_table_ref ()

    • Server crash when inserting from derived table containing insert target table ()

    OTHER

    • Field pointer may be uninitialized in fill_record ()

    • Extend SBOM with 'license' and 'copyright' ()

    • Wrong results from tables with a single record and an aggregate ()

    Replication

    • A primary server could crash when a semi-sync connection is stopped, if the primary previously disabled semi-sync replication while the connection was already up (and `rpl_semi_sync_master_wait_no_slave=0`). ()

    • Semi-sync Replica Can't Kill Dump Thread When Using SSL ()

    • CREATE-or-REPLACE-SELECT with ROW binlog format may not log DROP TABLE events, potentially causing replication issues. ()

    • Mysqlbinlog --stop-position does not warn if EOF not reached with --read-from-remote-server (

    Character Sets

    • Assertion `src != ((void *)0)' failed in my_casedn_8bit ()

    • The collation utf8mb4_0900_bin is defined as an alias for utf8mb4_bin while it should be an alias of utf8mb4_nopad_bin, causing wrong comparison results. ()

    Authentication and Privilege System

    • MariaDB crashes when trying to access information_schema.users when started with --skip-grant-tables ()

    • User without any privileges to a sequence can read from it and modify it via column default ()

    • User has unauthorized access to a sequence through a view with security invoker ()

    Galera

    • updated to 26.4.22

    • With wsrep_ignore_apply_errors = 0, the node crashes due to assertion thd->is_error() failed in Sql_cmd_dml::prepare(), shown in the logs ()

    • In some cases, if there are MDL locks (for example, when LOCK TABLE is executed), a node could get stuck in the system thread due to incorrect handling of metadata locks (MDL) in server code when a transaction was BF aborted. ()

    • Regression after the fix for - sometimes the server crashes with an assertion in wsrep::transaction::before_rollback(), for example when using OPTIMIZE TABLE on an ARIA table with wsrep_osu_method=RSU. (

    Partitioning

    • corruption when query cache cannot allocate block ()

    Data Manipulation - Update

    • Stack looping and SIGSEGV in Item_args::walk_args on UPDATE ()

    Vector search

    • Crash on disconnect when dropped Aria table with vector key under lock ()

    • Support for powerpc64 SIMD instructions in the distance calculation function of the mhnsw algorithm is added. ()

    Virtual Columns

    • Server crashes when reading information_schema.COLUMNS after creating a table with virtual columns using the GIS data type ()

    Plugin - Audit

    • Long server_audit_file_path causes buffer overflow ()

    Sequences

    • Check when doing ALTER TABLE table_name sequence=1 that table can be a sequence ()

    Data types

    • Comparison ROW(stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. ()

    Configuration

    • Bad value for the variable "Buffer pool size" ()

    • Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX ()

    • my_getopt compares option names case sensitively ()

    Parser

    • In sql_mode=ORACLE, package body variables are not allowed as FETCH targets ()

    Locking

    • Segfault on concurrent ALTER and SELECT for partitioned table ()

    Packaging

    • Error while installing MariaDB on Windows Server 2022 due to antivirus interference. ()

    • Systemd: Restart on OOM ()

    • RHEL 8 (and compatible) + Ubuntu 20.04 cannot start systemd servce (EXIT_CAPABILTIES/218) ()

    • remove all RPM MariaDB-compat packages (with old shared libraries) ()

    Scripts & Clients

    • mariadb-dump used wrong quoting character ()

    JSON

    • JSON_UNQUOTE doesn't work with emojis ()

    Prepared Statements

    • mysql_stmt_errno() returns 0 after an error in mysql_stmt_execute() ()

    Binary Protocol

    • When a CREATE TABLE .. SELECT errors while inserting data, a user would expect that all changes are rolled back and the table would not exist after executing the query; however, the error was accidentally ignored in the code, and the table would still exist. ()

    Changelog

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

    Contributors

    For a full list of contributors to , see the .

    Incorrect undo logging for indexes on virtual columns whose index ID does not fit in 32 bits (MDEV-36613)

  • Memory leak after failed CREATE TABLE…SELECT; crash on CREATE TABLE…SELECT that reads from multiple tables (MDEV-36504)

  • Doublewrite recovery of innodb_checksum_algorithm=full_crc32 page_compressed pages does not work (MDEV-36180)

  • decreasing innodb_buffer_pool_size at runtime does not release memory (MDEV-32339)

  • innodb_snapshot_isolation=1 gives error for not committed row changes (MDEV-36639)

  • InnoDB system tables cannot be optimized or defragmented (MDEV-35689)

  • LSN allocation is a bottleneck (MDEV-21923)

  • reorganise innodb buffer pool (and remove buffer pool chunks) (MDEV-29445)

  • FLUSH TABLES will no longer cause InnoDB persistent statistics to be reloaded. RENAME TABLE will. This change of logic improves the performance in general, and avoids a case where statistics for relatively rarely modified tables are never updated. (MDEV-35000)

  • The Linux memory pressure interface, which could previously not be disabled and could cause performance anomalies, was rewritten and is disabled by default. (MDEV-34863)

  • Stall and crash when page cleaner fails to generate free pages during Async flush (MDEV-36226)

  • Performance regression in INSERT…SELECT due to unnecessarily making InnoDB log durable. (MDEV-35813)

  • )

    A query using a subquery in form: (MDEV-32084)

    could cause a crash in the optimizer. The essential part is that ON expression has only two kinds of references:

    1. to inner side of the outer join and

    2. to outside the subquery.

  • When executing SELECT MIN using loose index scan, if at least one of the WHERE condition is "f IS NULL", a memory violation may happen resulting in unexpected behaviour (MDEV-36220)

  • find_order_in_list mismatch when order item needs fixing() (MDEV-36607)

  • Wrong cardinality estimation for the derived table leads to slow plan with LATERAL DERIVED (MDEV-30877)

  • If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query (MDEV-36592)

  • Cost estimates for materialized derived tables are poor (MDEV-35958)

  • Large N-way OR causes a lot of index_merge variants to be created and discarded (MDEV-34620)

  • Wrong result in loose index scan (MDEV-36118)

  • group by handler missing constant fields when selecting from a view (MDEV-36307)

  • mysqldump does not preserve case of table names in generated sql (MDEV-14432)

  • TO_CHAR FM format not recognized in SQL_MODE=Oracle (MDEV-36216)

  • Incorrect result for BETWEEN over unique blob prefix (MDEV-36235)

  • MariaDB effectively running as root CAP_DAC_OVERRIDE (MDEV-36229)

  • Build fails with cmake 4.0 (MDEV-36506)

  • Incorrect query result for comparisons of binary_column NOT LIKE binary_column (MDEV-36211)

  • )
  • For transactions committing in one-phase using rollback-capable engines, if binlogging fails during commit, the overall transaction would still commit, when it should roll-back. (MDEV-35506)

  • )
  • SST failure occurs when gtid_strict_mode is enabled under high load, such as OLTP load is active on the primary node. A typical symptom of this error is the presence of the diagnostic "[ERROR] mariadbd: Error writing file 'binlog'", in the debug version it is also possible to crash on assertion in the wsrep::transaction::before_rollback() function with the message "Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed". (MDEV-34891)

  • In Galera, creating sequence with a small cache leads to signal 6 error: [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED. (MDEV-33850)

  • Under high load wsrep internal thread may terminate due to memory pressure conditions, but this is not a crash, however in debug version user may encounter assertion in wsrep_to_isolation_begin() function with following message: "int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, const Alter_info*, const key_array*, const HA_CREATE_INFO*): Assertion `(0)' failed." (MDEV-36116)

  • Assertion `commit_trx' failed in innobase_commit() (ha_innodb.cc). An INSERT with sql_log_bin=0 is still replicated in Galera (per MDEV-7205), despite binary logging being disabled. This results in a partial binlog bypass, requiring a two-phase commit (2PC). During 2PC, the INSERT is first prepared (entering the PREPARED state in InnoDB), and on commit, the new assertion from MDEV-24035 fails, causing a crash with "Assertion 'commit_trx' failed" in logs. (MDEV-35658)

  • A Galera node might hang if foreign key (FK) and unique key (UK) checks are disabled on multiple appliers executing INSERTs into the same table, because InnoDB might treat these operations as bulk inserts, leading one applier to acquire a table-level lock. If another applier with a lower sequence number then waits for this lock, a deadlock can occur within Galera. Specifically, the lock holder waits for the earlier applier to commit, while the earlier applier is blocked by the lock. (MDEV-36360)

  • When a sequence is used and inserts run in parallel on multiple Galera nodes, a transaction may be aborted after passing certification. If it then attempts to roll back, the binlog statement cache—which includes reserved sequence values—may be written prematurely. This causes a crash with the diagnostic "WSREP: FSM: no such a transition REPLICATING -> COMMITTED" in the logs, as the transaction is supposed to replay and only write to the binlog during the final commit. (MDEV-33589)

  • A Galera node may hang due to improper mutex handling: a thread held lock_sys.wait_mutex while triggering a streaming replication rollback, which also tried to acquire THD::LOCK_thd_kill, leading to incorrect mutex usage. In debug versions, this leads to diagnostics like "safe_mutex: Found wrong usage of mutex 'wait_mutex' and 'LOCK_thd_data'", but in both debug and release versions, there is some probability that the node may hang. (MDEV-36509)

  • After a corrupted table on one node triggers the cluster to vote to evict a node that failed a transaction, the current master can't commit any more and hangs. To avoid this crash in the future, the user should also update the galera library to version 26.4.21+. (MDEV-34998)

  • MariaDB service manager reports “WSREP state transfer ongoing...” via the system log although the transfer is complete. The script defined in `wsrep_notify_cmd` is not called after the state transfer, preventing the service manager from updating its status. (MDEV-35969)

  • Selecting mysql.wsrep_streaming_log incorrectly not allowed when detached (MDEV-36527)

  • Build fails with cmake 4.0.0 due to wsrep (MDEV-36422)

  • What is MariaDB 11.8?
    MDEV-36082
    MDEV-36122
    MDEV-34677
    MDEV-33167
    MDEV-16523
    MDEV-15164
    MDEV-32157
    MDEV-35807
    MDEV-35807
    MDEV-36324
    MDEV-35874
    MDEV-36248
    MDEV-36115
    MDEV-36080
    MDEV-36079
    MDEV-36038
    MDEV-36281
    MDEV-36236
    MDEV-36152
    MDEV-36437
    MDEV-30000
    MDEV-35420
    MDEV-36128
    MDEV-36087
    MDEV-35640
    MDEV-25012
    MDEV-32086
    MDEV-36181
    MDEV-36398
    MDEV-35238
    MDEV-36359
    MDEV-36663
    MDEV-35499
    MDEV-36565
    MDEV-36361
    MDEV-36351
    MDEV-36413
    MDEV-36380
    MDEV-35946
    MDEV-35941
    MDEV-31413
    MDEV-34075
    MDEV-31647
    MDEV-36256
    MDEV-36184
    MDEV-36104
    MDEV-36245
    MDEV-36032
    MDEV-36322
    MDEV-21203
    MDEV-21375
    MDEV-27126
    MDEV-36047
    MDEV-31122
    MDEV-35983
    MDEV-36009
    MDEV-36591
    MDEV-35512
    MDEV-36268
    MDEV-35614
    MDEV-35953
    MDEV-35207
    changelog
    MariaDB 11.8.2
    MariaDB Foundation release announcement
    MariaDB 11.8.5
    Download Now
    Alternate download from mariadb.org
    Galera

    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 page.

    MDEV-36335
    MDEV-35694
    MDEV-32631
    WHERE col IN (SELECT ... LEFT JOIN tbl ON tbl.column=reference_outside_subquery)
    wsrep_load_data_splitting
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    InnoDB
    Triggers
    CREATE TRIGGER table1_after_insert AFTER INSERT
    Data types
    Character Sets
    Stored routines
    mariadb-import
    VEC_DISTANCE
    Optimizer hints
    subquery optimizer hints
    MAX_EXECUTION_TIME hint
    innodb-adaptive-hash-index
    mariadb-dump
    mariadb-import
    ST_Validate
    MBRCoveredBy
    ST_Simplify
    ST_GeoHash
    FORMAT_BYTES
    CHECK TABLE ... EXTENDED
    information Schema
    stored functions
    SUBSTR(col, 1, n) = const_str
    virtual columns
    Virtual Column Support in the Optimizer
    ST_LatFromGeoHash
    ST_LongFromGeoHash
    ST_PointFromGeoHash
    ST_IsValid
    ST_Collect
    analyze_max_length
    Upgrading Between Major MariaDB Versions
    Upgrading from MariaDB 11.4 to MariaDB 11.8
    downgrading between major versions
    Vector datatype and vector indexing
    VEC_FromText
    VEC_ToText
    VEC_DISTANCE_COSINE
    VEC_DISTANCE_EUCLIDEAN
    VEC_DISTANCE
    character set
    default Unicode collation
    Charset Narrowing Optimization
    SUBSTR(col, 1, n) = const_str
    virtual columns
    Virtual Column Support in the Optimizer
    system-versioned table
    Limit size of created disk temporary files and tables
    max_tmp_session_space_usage
    TIMESTAMP
    New PARSEC authentication plugin
    Unix socket authentication
    innodb-adaptive-hash-index
    mariadb-dump
    mariadb-import
    binlogging
    binlog_optimize_thread_scheduling
    slave_abort_blocking_timeout
    UUID_v4
    UUID_v7
    FORMAT_BYTES
    USERS table
    password expiry
    max_password_errors
    TABLE_STATISTICS
    CLIENT_STATISTICS
    USER STATISTICS
    INDEX_STATISTICS
    Sequences
    CREATE SEQUENCE ... AS
    INT
    BIGINT UNSIGNED
    Information Schema Sequences table
    MINVALUE
    MAXVALUE
    system-versioned table
    derived tables
    SHOW CREATE SERVER
    CREATE SERVER
    log_slow_always_query_time
    slow query log
    log_slow_min_examined_row_limit
    log_slow_rate_limit
    information Schema
    stored functions
    spider_table_crd_thread_count
    spider_table_sts_thread_count
    spider_casual_read
    SESSION_USER()
    USER()
    CURRENT_USER()
    max_sort_length
    alter_algorithm
    System Variables Added in MariaDB 11.8
    Index condition pushdown
    max_tmp_total_space_usage
    mariadb-import
    mariadb-dump
    mariadb-import
    binlog_optimize_thread_scheduling
    SHOW ALL REPLICAS STATUS
    Information Schema SLAVE_STATUS Table
    FLUSH GLOBAL STATUS
    Query Response Time plugin
    ANALYZE TABLE
    sequences
    DELETEs
    REPAIR TABLE ... FORCE
    integer latches in OQGraph
    oqgraph_allow_create_integer_latch

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

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

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

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

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

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

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