​​Download Release Notes Changelog Overview of 11.5

Alternate download from mariadb.org

Release date: 16 Feb 2024

Note that the Debian packages have compatibility problems with PHP and NodeJS. We suggest that these users hold off upgrading, wait until the next 11.x release, MariaDB 11.4.2, or implement one of the following workarounds:

• Edit /etc/mysql/mariadb.conf.d/50-server.cnf and change character-set-collations = utf8mb4=uca1400_ai_ci to character-set-collations = utf8mb4=general_ci or

• run this as root: sed -i -e '/character-set-collations/d' /etc/mysql/mariadb.conf.d/50-server.cnf

Note that upgrading from earlier versions will leave all users, including root and other users with ALL PRIVILEGES ON *.*, and ALL PRIVILEGES ON db.*, without the privilege. While the users with read privileges on mysql.proc will be have the effective privileges of SHOW CREATE ROUTINE, they are unable to GRANT them. To gain the privileges back on a global user, e.g. root@localhost:

1. Start server with as a configuration option

2. Run

3. Execute

4. Execute

To re-gain a database level privileges, using a user with SHOW CREATE ROUTINE on *.* execute [GRANT ALL ON db.* TO user] optionally WITH GRANT OPTION](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements-and-structure/sql-statements/account-management-sql-commands/grant).

is a previous stable rolling release of MariaDB. It is an evolution of with several entirely new features. It is a rolling release — one is expected to upgrade to 11.4.2, there will be no 11.3.3 — see .

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• Unique hash key on column prefix is computed incorrectly ()

• Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old ()

• Assertion ``0'failed in

Backup

• mariadb-backup has wrong or missing plugin-dir default? ()

• mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) ()

• Missing required privilege CONNECTION ADMIN ()

JSON

• Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE ()

• JSON_VALID fail to validate integer zero in scientific notation ()

• ASAN errors in Item_func_json_contains_path::val_int

Spider

• Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider ()

• SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES ()

• ASAN

Optimizer

• Crash caused by multi-table UPDATE over derived with hanging CTE ()

• Crash on query using CTE with the same name as a base table ()

• Crash with query using constant subquery as left part of IN subquery ()

• Incorrect result interceptor passed to mysql_explain_union()

Data Definition, Data Manipulation

• ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note ()

• Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY ()

Character Sets, Data Types

• InnoDB: CHAR+nopad does not work well ()

• CAST(AS UNSIGNED) fails with --view-protocol ()

• JSON_ARRAYAGG charset issue ()

Plugins

• The can optionally (when is enabled) include the thread ID and database / table in its log (). NULL is displayed if there is no database ()

• Backport SQL service, introduced by ()

• "plugin already loaded" should be a Warning, not an Error ()

Galera

• Node has been dropped from the cluster on Startup / Shutdown with async replica ()

• Inconsistency in Galera caused by ALTER being aborted before entering TOI mode ()

• Assertion ``total_length + thd->wsrep_sr().log_position() == saved_pos'failed in intwsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)` ()

Replication

• Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe ()

• binlog corruption (/tmp no space left on device at the same moment) ()

• multi source replication filters breaking GTID semantic ()

• SHOW SLAVE STATUS

General

• As per the , this will be the last release of for Fedora 37 and Ubuntu 23.04 "Lunar"

• is now dynamic, and contains new options, and old options have been deprecated ()

• It is now possible to create on tables that contain ()

• New

Security

• Fixes for the following :

  • CVE-`-```

Changelog

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

Contributors

For a full list of contributors to , see the .

MariaDB 11.3 is an old rolling release and is no longer maintained. Please use a more recent release.

MariaDB 11.3 is a previous rolling release. It is the first release in the new release model. From 11.3, we stop doing GA bug fix releases within each minor version. See Adjusting the MariaDB Server release model (mariadb.org).

Upgrading

• See and .

New Features & Improvements

Connection Redirection

• Added a using the system variable ()

• At the moment client-side support is missing

InnoDB

• Shrink without restart by setting the system variable. ()

Replication

• Add keywords "SQL_BEFORE_GTIDS" and "SQL_AFTER_GTIDS" for (). SQL_BEFORE_GTIDS stops the replica when it sees gtids of the option's argument list, without executing them.

Data Types

• It is now possible to create on tables that contain ()

• data types can now be cast into types ()

• This means INET4 values can be compared with INET6 values and can be inserted into INET6 columns; the server can automatically convert INET4 value into INET6 as needed.

Functions

• Values generated by the Key Derivation Function are resistant against password hashing generators, so are good for strongly hashed passwords ().

Date and Time

• function can now print the current time zone abbreviation and current time zone offset from UTC with %Z and %z format specifiers. ()

Optimizer

• Queries like can now use an index on varchar_col if its collation is case insensitive. An option, , has been added to enable this optimization. ()

Privileges

• Add a new database-level , SHOW CREATE ROUTINE that allows one to see the routine definition even if the user isn't the routine owner ()

Processlist

• Added a SENT_ROWS column to the table, as well as extended the display size for the columns in processlist to ensure that most results will fit in display ()

OLD_MODE

• Setting a non-default value will now always issue a deprecation warning ()

mariadb-backup

• mode has been deprecated ()

Spider

• The storage engine now supports table options instead of having to encode them in COMMENT/CONNECTION strings. When any table option is specified, Spider will ignore COMMENT/CONNECTION strings at the same table/partition/subpartition. A new variable is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable, , is introduced to suppress warnings when Spider ignores COMMENT/CONNECTION strings. ()

Removed

The following deprecated features and system variables have been removed ():

• sr_YU (deprecated since )

• "engine_condition_pushdown" in (deprecated since )

• , , , (deprecated since )

• (deprecated since )

Variables

• For a list of all new variables, see .

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

List of All Releases

Download | Release Notes | Changelog | Overview of 11.3

Release date: 20 September 2023

Do not use alpha releases in production!

MariaDB 11.3 is a current development series of MariaDB. It is an evolution of MariaDB 11.2 with several entirely new features.

MariaDB 11.3.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.3.

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

For an overview of MariaDB 11.3 see theWhat is MariaDB 11.3? page.

Thanks, and enjoy MariaDB!

Connection Redirection

• Added a using the system variable ()

• At the moment client-side support is missing

InnoDB

• Shrink without restart by setting the system variable. ()

Replication

• Add keywords "SQL_BEFORE_GTIDS" and "SQL_AFTER_GTIDS" for (). SQL_BEFORE_GTIDS stops the replica when it sees gtids of the option's argument list, without executing them.

SSL/TLS

• Note that this feature did not make it into , but is in .

• is now enabled in the server by default. No configuration necessary, if no server certificate was provided a self-signed certificate will be automatically generated by the server. See on mariadb.org ().

• Clients now can validate self-signed server certificates if the or authentication is used and account password is not empty ().

Data Types

• data types can now be cast into types ()

• This means, INET4 values can be compared with INET6 values and can be inserted into INET6 columns, the server can automatically convert INET4 value into INET6 as needed.

Functions

• Values generated by the Key Derivation Function are resistant against password hashing generators, so are good for strongly hashed passwords ().

Date and Time

• function can now print the current time zone abbreviation and current time zone offset from UTC with %Z and %z format specifiers. ()

Optimizer

• Queries like can now use an index on varchar_col if its collation is case insensitive. An option, , has been added to enable this optimization. ()

Privileges

• Add a new database-level , SHOW CREATE ROUTINE that allows to see the routine definition even if the user isn't the routine owner ()

Processlist

• Added a SENT_ROWS column to the table, as well as extended the display size for the columns in processlist to ensure that most results will fit in display ()

Application-Time Periods

• Note that this feature did not make it into , but is in .

• Add views for in information_schema (), in particular

• New view

• New view

OLD_MODE

• Setting a non-default value will now always issue a deprecation warning ()

mariadb-backup

• mode has been deprecated ()

Spider

• The storage engine now supports table options instead of having to encode them in COMMENT/CONNECTION strings. When any table option is specified, Spider will ignore COMMENT/CONNECTION strings at the same table/partition/subpartition. A new variable is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable, , is introduced to suppress warnings when Spider ignores COMMENT/CONNECTION strings. ()

Removed

The following deprecated features and system variables have been removed ():

• (deprecated since )

• sr_YU (deprecated since )

• "engine_condition_pushdown" in (deprecated since )

• , , , (deprecated since )

Download 11.3.1 | Release Notes | Changelog | Overview of 11.3

Release date: 21 Nov 2023

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

MariaDB 11.3 is a current development series of MariaDB. It is an evolution of MariaDB 11.2 with several entirely new features.

MariaDB 11.3.1 is a Release Candidate (RC) release.

For an overview of MariaDB 11.3 see theWhat is MariaDB 11.3? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• followed by may corrupt data ()

• ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. ()

• Server aborts during alter operation when table doesn't have foreign index ()

• row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently ()

Optimizer

• New setting, cset_narrowing, to enable the ()

• Crash when HAVING in a correlated subquery references columns in the outer query ()

• Server crashes at TABLE::add_tmp_key ()

• Server crashes inside filesort at my_decimal::to_binary (

Replication

• rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables ()

• Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication ()

• strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT ()

• Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE ()

• Assertion ``state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying'` failed. ()

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

• wsrep_sst_mariadb-backup not working on FreeBSD ()

• Galera library 26.4.16 fails with every server version (

Data Definition

• MariaDB crash on calling function ()

• ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations ()

• vcol circular references lead to stack overflow ()

• OPTIMIZE TABLE crash ()

Scripts and Clients

• (mysqlbinlog) option ()

• (mysqladmin) wrong error with ()

• shows warning on missing directory $pamtooldir/auth_pam_tool_dir ()

• main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()

mariadb-backup

• mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 ()

• mbstream breaks page compression on XFS ()

Character Sets, Data Types, Collations

• Prefix keys for CHAR work differently for MyISAM vs InnoDB ()

• Inconsistent results of DISTINCT with NOPAD ()

• Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT ()

• Compressed varchar values lost on joins when sorting on columns from joined table(s) ()

Spider

• Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims ()

• Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows ()

• ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler ()

• ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str

General

• Added database level privilege ()

• option breaks importing sql dumps ()

• Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 ()

• getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO ()

Security

• Fixes for the following :

  • CVE-`-```

Changelog

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

Contributors

For a full list of contributors to , see the .

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