Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
MariaDB 10.9 was a short-term maintenance stable series of MariaDB maintained until August 2023
The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now
Download 10.9.7 | Release Notes | Changelog | Overview of 10.9
Release date: 7 Jun 2023
MariaDB 10.9 is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.7 is a Stable (GA) release.
For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.
Thanks, and enjoy MariaDB!
Server crashes in st_join_table::choose_best_splitting ()
Crash with condition pushable into derived and containing outer reference ()
InnoDB does not free UNDO after the fix of ()
InnoDB hang fixes (, , )
Crash with condition pushable into derived and containing outer reference ( )
Crash with for multi-table update of system table ()
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
is not updated correctly (MDEV-31309)
InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)
Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"
function (MDEV-27677)
Implement range notation for JSONPath (MDEV-27911)
Support JSONPath negative index (MDEV-22224)
is now dynamic (MDEV-27812)
InnoDB performance improvements (MDEV-27557, MDEV-28185, MDEV-27767, MDEV-28313, MDEV-28137, MDEV-28465, MDEV-26789)
removed (MDEV-25975)
for implementing using keys stored in the Hashicorp Vault KMS (MDEV-19281)
Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for (MDEV-20119)
Semisync-slave server recovery is extended to work on new server_id server (MDEV-27342)
now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)
JSON file interface to wsrep node state / SST progress logging (MDEV-26971)
Extend to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
Add EXPLAIN FOR CONNECTION syntax support to (MDEV-10000)
For a list of all new variables, see .
Merge to sql variable (MDEV-24920)
The following variables have been deprecated:
(replaced by )
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
:
:
:
:
14 Aug 2023
Stable (GA)
7 Jun 2023
Stable (GA)
The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now
Download 10.9.4 | Release Notes | Changelog | Overview of 10.9
Release date: 7 Nov 2022
MariaDB 10.9 is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.4 is a Stable (GA) release.
For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.
Thanks, and enjoy MariaDB!
The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
Assertion on info.page_size failed in xb_delta_open_matching_space ()
locks database for minutes ()
Adaptive hash index ,
MVCC and locking (, , , )
Virtual columns (, )
InnoDB crash recovery fixes ()
updated to 26.4.13
Galera server crashes after 10.3 > 10.4 upgrade ()
status variable prints 0 as port number if the port is not mentioned in system variable ()
XA COMMIT is not binlogged when the has not updated any transaction engine ()
Concurrent statements made to binlog without any mixup ()
Beginning with the next release (Q1 2023), our Yum, DNF, and Zypper repositories for Red Hat, Fedora, and SUSE will be migrated to being signed with a new . The key we are migrating to is the same one we already use for our Debian and Ubuntu Repositories.
The short Key ID is: 0xC74CD1D8
The long Key ID is: 0xF1656F24C74CD1D8
The following changes have been made to the docker.io/library/mariadb container image.
The number of gpg packages has been removed, leaving enough to apt-get update, but dirmngr that would fetch keys has been removed. (inspired by )
The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes ).
Adds OCI labels to image (fixes and )
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now
Download 10.9.3 | Release Notes | Changelog | Overview of 10.9
Release date: 19 Sep 2022
MariaDB 10.9 is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.3 is a Stable (GA) release.
For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.
Thanks, and enjoy MariaDB!
Assertion mysql_mutex_assert_owner(&log_sys.flush_order_mutex) failed in mtr_t::commit() ()
Frequent "Data structure corruption" in InnoDB after OOM ()
Recovery or backup of instant ALTER TABLE is incorrect ()
InnoDB Temporary Tablespace (ibtmp1) is continuously growing ()
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Race condition between KILL and transaction commit (MDEV-29368)
Implement for InnoDB (MDEV-24402)
fail to update after bulk insert (MDEV-28327)
InnoDB bulk insert bug fixes (MDEV-29570, MDEV-29761)
The full fingerprint of the key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
The key can be imported now in preparation for this change using the following command:
MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf
Full text index corruption if shutdown before changes are fully flushed (MDEV-29342)
does not parse NULL properties properly (MDEV-27151)
InnoDB hangs on multiple concurrent requests of a cold ROW_FORMAT=COMPRESSED page (MDEV-27983)
10 May 2023
Stable (GA)
6 Feb 2023
Stable (GA)
7 Nov 2022
Stable (GA)
19 Sep 2022
Stable (GA)
22 Aug 2022
Stable (GA)
20 May 2022
RC
23 Mar 2022
Alpha
The most recent release of is: Stable (GA)
| | |
Release date: 23 March 2022
Do not use alpha releases in production!
is a current development series of MariaDB. It is an evolution of with several entirely new features.
is not a single release, but is instead a number of preview releases based on feature branches. Each should be considered . Read more about feature preview releases .
Thanks, and enjoy MariaDB!
Remember, these features are in separate preview packages. The subsection header text corresponds to the preview package name.
| | |
Release date: 14 Aug 2023
is a previous short-term stable series of MariaDB, August 2023. It is an evolution of with several entirely new features.
is a release.
is the last release of the release series.
For an overview of see the page.
Thanks, and enjoy MariaDB!
sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEYfunction (MDEV-27677)
Implement range notation for JSONPath (MDEV-27911)
Support JSONPath negative index (MDEV-22224)
Extend to support [SHOW ANALYZE ] (MDEV-27021)
Add EXPLAIN FOR CONNECTION syntax support to (MDEV-10000)
Asynchronous write (MDEV-26603) (not included in MariaDB 10.9.1)
Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for (MDEV-20119)
now shows TEMPORARY for local temporary tables (MDEV-12459) (not included in MariaDB 10.9.1)
Merge to sql variable (MDEV-24920)
for implementing using keys stored in the Hashicorp Vault KMS ()
JSON file interface to wsrep node state / SST progress logging ()
Allow to change without server restart ()
As per the MariaDB Maintenance Policy, this will be the final release of MariaDB 10.9
MariaDB now detects and converts previously incompatible MySQL partition schemes (MDEV-29253)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.9 for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"
doesn't ignore error as it should (MDEV-31092)
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode (MDEV-26186)
SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION ()
Unexpected result when combining , subselect and ()
variables do not get assigned from subselects ()
Crash after setting global session_track_system_variables to an invalid value ()
ODKU of non-versioning column inserts history row ()
UPDATE not working properly on transaction precise system versioned table ()
Assertion ``const_item_cache == true'failed inItem_func::fix_fields` ()
ANALYZE doesn't work with pushed derived tables ()
get_partition_set is never executed in ha_partition::multi_range_key_create_key due to bitwise & with 0 constant ()
Client can crash the server with a mysql_list_fields("view") call ()
I_S.parameters not immediatly changed updated after procedure change ()
bzero wipes more bytes than necessary in set_global_from_ddl_log_entry ()
Assertion ``0'failed inType_handler_row::field_typeuponTO_CHAR` with wrong argument ()
mysql_upgrade fails due to old_mode="", with "Cannot load from mysql.proc. The table is probably corrupted" ()
version >= 6 are now stored without byte-swapping, UUIDs with version >=8 and variant=0 are now considered invalid, old tables are supported, old (always byte swapped) and new (swapped for version < 6) UUIDs can be compared and converted transparently (MDEV-29959)
UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT (MDEV-28384)
Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` ()
Assertion ``(length % 4) == 0'failed inmy_lengthsp_utf32onSELECT` ()
UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()
Assorted assertion failures in json_find_path with certain collations ()
Crashing on I/O error is unhelpful (MDEV-27593)
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery (MDEV-31354)
InnoDB tables are being flagged as corrupted on an I/O bound server (MDEV-31767)
Duplicate entry allowed into a ()
Server Status is reported in seconds ()
innochecksum dies with Floating point exception ()
Add InnoDB engine information to the ()
Deadlock with 3 concurrent by ()
innodb protection against dual processes accessing data insufficient ()
ER_DUP_KEY in mysql.innodb_table_stats upon RENAME on sequence ()
Assertion ``!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")'failed inbtr_node_ptr_max_size` ()
InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value ()
btr_estimate_n_rows_in_range() accesses unfixed, unlatched page ()
MODIFY COLUMN can break FK constraints, and lead to unrestorable dumps ()
Recovery or backup failure after ()
Assertion 'n & PENDING' failed in fil_space_t::set_needs_flush() ()
fil_node_open_file() releases fil_system.mutex allowing other thread to open its file node ()
ASAN errors in dict_v_col_t::detach upon adding key to virtual column ()
Purge trying to access freed secondary index page ()
Freed data pages are not always being scrubbed ()
InnoDB recovery hangs after reporting corruption ()
!cursor->index->is_committed() in row0ins.cc after update to 10.4.13 from 10.3.21 ()
fails to wait for purge of enough transaction history ()
SET GLOBAL does not free space when no undo logs exist ()
(linear read-ahead) does not work ()
InnoDB recovery and mariadb-backup --prepare fail to report detailed progress ()
fil_ibd_create() may hijack the file handle of an old file ()
recovery results in a corrupted undo log ()
Server freeze due to and ()
Change buffer entries are left behind when freeing a page, causing secondary index corruption when the page is later reused ()
Foreign Key Constraint actions don't affect Virtual Column ()
Various crashes upon INSERT/UPDATE after changing Aria settings (MDEV-28054)
Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded (MDEV-26258)
SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT (MDEV-29447)
that double as table params overriding mechanism is buggy (MDEV-31524)
InnoDB engine statistics for each table (MDEV-31577)
Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` (MDEV-31348)
Problem with open ranges on prefix blobs keys (MDEV-31800)
Equal on two create wrong result ()
Recursive CTE execution is interrupted without errors or warnings ()
Assertion ``s->table->opt_range_condition_rows <= s->found_records'failed inapply_selectivity_for_table` ()
Inconsistency between MRR and SQL layer costs can cause poor query plan ()
MAX_SEL_ARG memory exhaustion is not visible in the optimizer trace ()
not working properly with lower_case_table_names=2 ()
Segfault on select query using index for group-by and filesort ()
Server crash in store_length, assertion failure in Type_handler_string_result::sort_length ()
Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers (MDEV-30619)
ends up in optimistic parallel slave binlog out-of-order (MDEV-31503)
takes very long time on a busy system (MDEV-13915)
On slave fail to return an error in read-only mode (MDEV-30978)
Calling a function from a different database in a slave side trigger crashes ()
rpl.rpl_manual_change_index_file occasionally fails in BB with Result length mismatch ()
Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup (MDEV-31737)
Node has been dropped from the cluster on Startup / Shutdown with async replica (MDEV-31413)
KILL QUERY maintains nodes data consistency but breaks GTID sequence (MDEV-31075)
Assertion failure !lock.was_chosen_as_deadlock_victim in trx0trx.h:1065 ()
MariaDB stuck on starting commit state (waiting on commit order critical section) ()
Assertion state() == s_aborting || state() == s_must_replay failed in int wsrep::transaction::after_rollback() ()
Assertion !wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted failed ()
Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL ()
Create temporary sequence can cause inconsistency ()
Galera 4 unable to query cluster state if not primary component ()
Fixes for the following :
CVE--``#
For a complete list of changes made in MariaDB 10.9.8, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.9.8, see the MariaDB Foundation release announcement.
Download | Release Notes | Changelog | Overview of 10.9
Release date: 6 Feb 2023
MariaDB 10.9 is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.5 is a Stable (GA) release.
For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.
Thanks, and enjoy MariaDB!
As mentioned in the , our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, Fedora, openSUSE, and SUSE are changing with this release to being signed with a new GPG key with SHA2 digest algorithms instead of SHA1. See and the page for more details.
corruption with ()
recovery and backup fixes (, , )
Upgrade after a crash is not supported ()
Remove load throttling ()
updated to 26.4.14
Fixes for cluster wide write conflict resolving ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
is now shown now more precisely at the slave applier start, including in the delayed mode ()
mysqlbinlog --verbose is made to show the type of compressed columns ()
added as an alias for ()
Infinite sequence of recursive calls when processing embedded CTE ()
Crash with a query containing nested WINDOW clauses ()
Major performance regression with 10.6.11 ()
Json Range only affects first row of the result set ()
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
The most recent release of is: Stable (GA)
| | |
Release date: 10 May 2023
is the current short-term maintenance stable series of MariaDB, August 2023. It is an evolution of with several entirely new features.
is a release.
For an overview of see the page.
Thanks, and enjoy MariaDB!
InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009)
innodb_fast_shutdown=0 fails to report change buffer merge progress (MDEV-29984)
mariadb-backup --backup --incremental --throttle=... hangs (MDEV-29896)
Crash after recovery, with InnoDB: Tried to read (MDEV-30132)
Trying to write ... bytes at ... outside the bounds (MDEV-30069)
TRUNCATE breaks FOREIGN KEY locking (MDEV-29504, MDEV-29849)
INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces (MDEV-30119)
Fixed hangs and error handling in B-tree operations (MDEV-29603, MDEV-30400)
InnoDB bulk insert fixes (MDEV-30047, MDEV-30321)
BACKUP STAGE BLOCK_COMMIT and a committing user XA (MDEV-30423)As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.9 for Fedora 35.
In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.
Crash on in a table (MDEV-30882)
UNIQUE USING HASH accepts duplicate entries for tricky collations (MDEV-30034)
rec_get_offsets() is not optimal (MDEV-30567)
Performance regression in fil_space_t::try_to_close() introduced in MDEV-23855 (MDEV-30775)
InnoDB recovery hangs when buffer pool ran out of memory ()
InnoDB undo log truncation fails to wait for purge of history (
MariaDB crash due to DB_FAIL reported for a corrupted page ()
Deadlock between INSERT and InnoDB non-persistent statistics update ()
InnoDB hang on B-tree split or merge ()
Performance regression in locking reads from secondary indexes ()
Improve adaptive flushing ()
Make page flushing even faster ()
Purge misses a chance to free not-yet-reused undo pages ()
InnoDB temporary tablespace: reclaiming of free space does not work ()
Deadlock between CHECK TABLE and bulk insert ()
Fix miscount of doublewrites by ()
mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation (MDEV-28187)
mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing (MDEV-29050)
mariadb-backup does not copy Aria logs if aria_log_dir_path is used (MDEV-30968)
Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare (MDEV-30860)
Fixed a deadlock on parallel slave involving full image Write event on the sequence engine (MDEV-29621)
Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine (MDEV-31077)
Corrected non-versioned master to versioned slave replication on no-unique attribute table (MDEV-30430)
Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file (MDEV-28798)
Refined optimistic parallel slave to error-exit without any hang ()
Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always intialized ()
Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons ()
Made parallel slave reports in performance schema consistent with that of show-slave-status ()
optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too (MDEV-26301).
New optimizer_switch option, , is added. It is off by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)
Queries using SELECT DISTINCT some_expression(aggregate_function()) could produce wrong query result. (MDEV-20057)
now prints more information about : block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (, ).
A GROUP BY query with MIN(primary_key) in select list and primary_key<>const in the WHERE could produce wrong result when executed with "Using index for group-by" strategy ()
EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. ()
A bug in selectivity computations for SINGLE/DOUBLE_PREC_HB histograms could cause wrong estimates to be produced. This could cause the optimizer to pick sub-optimal query plans ().
Add replication setup to containers contributed by Md Sahil (MDEV-29762)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.9 for Fedora 36.
In this release repositories for Fedora 38 and Ubuntu 23.04 Lunar have been added.
Fixes for the following :
For a complete list of changes made in MariaDB 10.9.6, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.9.6, see the MariaDB Foundation release announcement.
The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now
Download 10.9.1 | Release Notes | Changelog | Overview of 10.9
Release date: 20 May 2022
Do not use non-stable (non-GA) releases in production!
MariaDB 10.9 is a current development series of MariaDB. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.1 is a Release Candidate (RC) release.
For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.
Thanks, and enjoy MariaDB!
removed ()
InnoDB gap locking fixes (, )
InnoDB performance improvements (, , , , , , )
Backup regression fixes (
New --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids are implemented ()
Semisync-slave server recovery is refined to correctly rollback prepared transaction ()
Circular semisync setup endless event circulation is handled ()
Semisync-slave server recovery is extended to work on new server_id server ()
Incorrect binlogs after Galera SST using rsync and ()
does not detect multi-source replication slave ()
Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage ()
prepare fails for incrementals if a new schema is created after full backup is taken ()
Query performance degradation in newer MariaDB versions when using many tables ()
A SEGV in Item_field::used_tables/update_depend_map_for_order... ()
ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries ()
Subquery in an UPDATE query uses full scan instead of range ()
and have been deprecated ()
Auto-create history partitions for ()
--order-by-size option ()
Server are ()
For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Do not use non-stable (non-GA) releases in production!
InnoDB portability: FreeBSD futexes (MDEV-26476), POWER and s390x transactional memory (MDEV-27956)
ALTER TABLE: Fixed bogus duplicate key errors (MDEV-15250)
DDL and crash recovery fixes (MDEV-27274, MDEV-27234, MDEV-27817)
Requests to recalculate were sometimes lost (MDEV-27805)
Deprecate the parameter (MDEV-27735)
Allow SET GLOBAL (MDEV-27812)
Server initialization time gtid_slave_pos purge related reason of crashing in binlog background thread is removed (MDEV-26473)
Shutdown of the semisync master can't produce inconsistent state anymore (MDEV-11853)
Binlogs disappear after rsync IST (MDEV-28583)
master crash is eliminated in compressed semisync replication protocol with packet counting amendment (MDEV-25580)
OPTIMIZE on a sequence does not cause counterfactual ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617)
Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member (MDEV-28550)
using two or more unique key values at a time with is corrected (MDEV-28310)
stops issuing unnecessary "Unsafe statement" with (MDEV-21810)
Incomplete replication event groups are detected to error out by the slave IO thread (MDEV-27697)
now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)
Assertion `item1->type() == Item::FIELD_ITEM ... (MDEV-19398)
Server crashes in Expression_cache_tracker::fetch_current_stats (MDEV-28268)
MariaDB server crash at Item_subselect::init_expr_cache_tracker (MDEV-26164, MDEV-26047)
Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)
SIGSEGV in st_join_table::cleanup (MDEV-24560)
Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)
Packages for Ubuntu 22.04 LTS "Jammy" and Fedora 36 are now available in this release
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Debian 9 "Stretch", Ubuntu 21.10 "Impish", and Fedora 34
The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now
Download 10.9.2 | Release Notes | Changelog | Overview of 10.9
Release date: 22 Aug 2022
MariaDB 10.9 is a current stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.2 is a Stable (GA) release.
For an overview of MariaDB 10.9 see theWhat is MariaDB 10.9? page.
Thanks, and enjoy MariaDB!
InnoDB corruption due to lack of file locking ()
with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
ALTER TABLE wrong-result fix ()
is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
sequences related row-format events are made to correspond to binlog_row_image ()
updated to 26.4.12
Possible to write/update with read_only=ON and not a SUPER privilege ()
Node crashes with Transport endpoint is not connected mysqld got signal 6 ()
Galera4 not able to report proper wsrep_incoming_addresses ()
Server crash in JOIN_CACHE::free or in copy_fields ()
Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()
MariaDB Server SEGV on INSERT .. SELECT ()
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly ()
Wrong result with table elimination combined with not_null_range_scan ()
If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path ()
The version number now matches the server version (and the system variable removed) ()
and have been deprecated (, )
Spider's high-availability feature has been deprecated ()
: extract document fragment into JSON column ()
now supports with ()
now also has a session scope, not only global ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Crash recovery fixes (MDEV-28668, MDEV-28731)
DDL crash recovery fixes (MDEV-28752, MDEV-28802, MDEV-28864, MDEV-28870, MDEV-28923, MDEV-28977)
Avoid crashes on corrupted data (MDEV-13542, MDEV-18519, MDEV-21098, MDEV-22388, MDEV-28457, MDEV-28950)
Bulk load bug fixes (MDEV-28242, MDEV-28679)
Performance fixes (MDEV-28708, MDEV-28766)
Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948)
Fix out-of-order gtid error in the circular semisync setup (MDEV-28609)
Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)
Add support for OpenSSL 3.0 in Galera (MDEV-25949)
Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246)
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
Range optimizer regression for key IN (const, ....) (MDEV-25020)
The issue can be observed on MariaDB 10.5.9 and later versions which have the fix for MDEV-9750. That fix introduceds optimizer_max_sel_arg_weight.
If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:
Server crash upon CREATE VIEW with unknown column in ON condition (MDEV-29088)
password_reuse_check plugin mixes username and password (MDEV-28838)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.9 for Debian 10 "Buster" for ppc64el
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...table.keyXpartY [NOT] IN ( ... )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
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