Age | Commit message (Collapse) | Author | Files | Lines |
|
MariaDB 10.5.18 Release Notes
Notable Items
Backup
* mariabackup --compress hangs (MDEV-29043)
* Assertion on info.page_size failed in xb_delta_open_matching_space
(MDEV-18589)
InnoDB
* InnoDB unnecessarily extends data files (MDEV-13013)
* Adaptive hash index MDEV-27700, MDEV-29384
* MVCC and locking MDEV-29666, MDEV-27927
* Virtual columns MDEV-29299, MDEV-29753
* InnoDB crash recovery fixes (MDEV-29438, MDEV-29475)
* InnoDB crash recovery fixes (MDEV-29559)
* MVCC and locking (MDEV-28709)
* Race condition between KILL and transaction commit (MDEV-29368)
Galera
* Galera updated to 26.4.13
* Galera server crashes after 10.3 > 10.4 upgrade (MDEV-29375)
* wsrep_incoming_addresses status variable prints 0 as port number if
the port is not mentioned in wsrep_node_incoming_address system
variable (MDEV-28868)
JSON
* JSON_VALUE() does not parse NULL properties properly (MDEV-27151)
Replication
* minor correction in unsafe warning message (MDEV-28827)
* False replication error-stop of REVOKE PRIVILEGES from a non-existing
user on primary (MDEV-28530) in combination with a filtering replica
is corrected
* SET DEFAULT ROLE replication is mended on a replica that filters
system tables (MDEV-28294)
* XA COMMIT is not binlogged when the XA transaction has not updated any
transaction engine (MDEV-25616)
* Concurrent CREATE TRIGGER statements made to binlog without any mixup
(MDEV-25606)
|
|
|
|
|
|
Notable Items
InnoDB
* InnoDB corruption due to lack of file locking (MDEV-28495)
* FULLTEXT search with apostrophe, and mandatory words (MDEV-20797)
* ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table (MDEV-28779)
* ALTER TABLE wrong-result fix (MDEV-26294)
* Crash recovery fixes (MDEV-28668, MDEV-28731)
Replication
* explicit_defaults_for_timestamp is stored in binlog, so that CREATE
TABLE on slave would always have the same effect as on master.
(MDEV-29078)
* ER_SLAVE_INCIDENT error is specified now on slave to be seen with
SHOW-SLAVE-STATUS (MDEV-21087)
* INCIDENT_EVENT is no longer binlogged when a being logged transaction
can be safely rolledback (MDEV-21443)
* sequences related row-format events are made to correspond to
binlog_row_image (MDEV-28487)
* Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948)
Galera
* Possible to write/update with read_only=ON and not a SUPER privilege
(MDEV-28546)
* Node crashes with Transport endpoint is not connected mysqld got
signal 6 (MDEV-25068)
* Galera4 not able to report proper wsrep_incoming_addresses
(MDEV-20627)
* Galera should replicate nextval()-related changes in sequences with
INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)
Optimizer
* Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)
* 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 (MDEV-29139)
* A query with a subuquery in this form could cause a crash:
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
* MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)
* 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
(MDEV-28749)
* Subquery semi-join optimization could miss LooseScan or
FirstMatch strategies for certain queries.
* 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.:
table.keyXpartY [NOT] IN ( ... )
* Wrong result with table elimination combined with not_null_range_scan
(MDEV-28858)
* 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.
CONNECT
* CONNECT Engine now supports INSERT IGNORE with Mysql Table type
(MDEV-27766)
mariadb Client
* New mariadb client option, -enable-cleartext-plugin. Option does not
do anything, and is for MySQL-compatibility purposes only.
General
* explicit_defaults_for_timestamp now also has a session scope, not only
global (MDEV-29225)
* MariaDB can be built with OpenSSL 3.0
* HELP was updated to include the latest content
* Crash in JSON_EXTRACT (MDEV-29188)
* ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (MDEV-28727)
* Server crash upon CREATE VIEW with unknown column in ON condition
(MDEV-29088)
* As per the MariaDB Deprecation Policy, this will be the last release
of MariaDB 10.5 for Debian 10 "Buster" for ppc64el
Security
* Fixes for the following security vulnerabilities:
* CVE-2022-32082
* CVE-2022-32089
* CVE-2022-32081
* CVE-2018-25032
* CVE-2022-32091
* CVE-2022-32084
|
|
|
|
MariaDB 10.5.16 Release Notes
Notable Items
InnoDB
* innodb_disallow_writes removed (MDEV-25975)
* InnoDB gap locking fixes (MDEV-20605, MDEV-28422)
* InnoDB performance improvements (MDEV-27557, MDEV-28185)
Replication
* 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)
* autocommit=0 slave hang is eliminated (DBAAS-7828)
* 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)
* Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE using two or more
unique key values at a time with MIXED format binlogging is corrected
(MDEV-28310)
* Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE stops issuing
unnessary "Unsafe statement" with MIXED binlog format (MDEV-21810)
* Incomplete replication event groups are detected to error out by the
slave IO thread (MDEV-27697)
* mysqlbinlog --stop-never --raw now flushes the result file to disk
after each processed event so the file can be listed with the actual
bytes (MDEV-14608)
Backup
* Incorrect binlogs after Galera SST using rsync and mariabackup
(MDEV-27524)
* mariabackup does not detect multi-source replication slave
(MDEV-21037)
* Useless warning "InnoDB: Allocated tablespace ID <id> for <tablename>,
old maximum was 0" during backup stage (MDEV-27343)
* mariabackup prepare fails for incrementals if a new schema is created
after full backup is taken (MDEV-28446)
Optimizer
* A SEGV in Item_field::used_tables/update_depend_map_for_order...
(MDEV-26402)
* ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries
(MDEV-27699)
* Subquery in an UPDATE query uses full scan instead of range
(MDEV-22377)
* 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)
General
* Server error messages are now available in Chinese (MDEV-28227)
* For RHEL/CentOS 7, non x86_64 architectures are no longer supported
upstream and so our support will also be dropped with this release
Security
* Fixes for the following security vulnerabilities:
* CVE-2022-27376
* CVE-2022-27377
* CVE-2022-27378
* CVE-2022-27379
* CVE-2022-27380
* CVE-2022-27381
* CVE-2022-27382
* CVE-2022-27383
* CVE-2022-27384
* CVE-2022-27386
* CVE-2022-27387
* CVE-2022-27444
* CVE-2022-27445
* CVE-2022-27446
* CVE-2022-27447
* CVE-2022-27448
* CVE-2022-27449
* CVE-2022-27451
* CVE-2022-27452
* CVE-2022-27455
* CVE-2022-27456
* CVE-2022-27457
* CVE-2022-27458
|
|
The file client/mysql.cc uses the readline library, but it has preprocessor
conditionals specially for __APPLE__. Pkgsrc expects a common readline,
however, and so the build fails. Removing the special case handles __APPLE__
the same as other platforms.
|
|
MariaDB 10.5.15 Release Notes
Notable Items
InnoDB
* Set innodb_change_buffering=none by default (MDEV-27734)
Security
* Fixes for the following security vulnerabilities:
* CVE-2021-46665
* CVE-2021-46664
* CVE-2021-46661
* CVE-2021-46668
* CVE-2021-46663
MariaDB 10.5.14 Release Notes
Notable Items
InnoDB
* --skip-symbolic-links does not disallow .isl file creation
(MDEV-26870)
* Indexed CHAR columns are broken with NO_PAD collations (MDEV-25440)
* insert-intention lock conflicts with waiting ORDINARY lock
(MDEV-27025)
* Crash recovery improvements (MDEV-26784, MDEV-27022, MDEV-27183,
MDEV-27610)
Galera
* Galera updated to 26.4.11
* Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory
(MDEV-27181)
* Alter Sequence do not replicate to another nodes with in Galera
Cluster (MDEV-19353)
* Galera crash - Assertion. Possible parallel writeset problem
(MDEV-26803)
* CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel
(MDEV-27276)
* Galera cluster node consider old server_id value even after
modification of server_id [wsrep_gtid_mode=ON] (MDEV-26223)
Replication
* Seconds behind master corrected from artificial spikes at relay-log
rotation (MDEV-16091)
* Statement rollback in binlog when transaction creates or drop
temporary table is set right (MDEV-26833)
* CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to
stabilize its parallel execution on slave (MDEV-27365)
Security
* Fixes for the following security vulnerabilities:
* CVE-2022-24052
* CVE-2022-24051
* CVE-2022-24050
* CVE-2022-24048
* CVE-2021-46659
|
|
|
|
Release notes:
https://mariadb.com/kb/en/mariadb-10513-release-notes/
|
|
All checksums have been double-checked against existing RMD160 and
SHA512 hashes
The following distfiles could not be fetched (some may be only fetched
conditionally):
./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
|
|
its buildlink3.mk now includes openssl's buildlink3.mk
|
|
|
|
|
|
|
|
Matches later MariaDB versions.
|
|
TokuDB is not built (it's removed in newer MariaDB) so having patches
for it is quite redundant.
|
|
Notable Items
InnoDB
* InnoDB no longer acquires advisory file locks by default (MDEV-24393)
* Encryption: Automatically disable key rotation checks for
file_key_management plugin (MDEV-14180)
* Some fixes from MySQL 5.7.35 (MDEV-26205)
* Fixed scrubbing on AIX (MDEV-26110)
* Improved page flushing performance (MDEV-25954, MDEV-25948,
MDEV-25801, MDEV-25113, MDEV-26004)
Optimizer
* A query that uses ORDER BY .. LIMIT clause and "Range checked for each
record optimization" could produce incorrect results under some
circumstances (MDEV-25858)
* Queries that have more than 32 equality conditions comparing columns
of different tables ("tableX.colX=tableY.colY) could cause a stack
overrun in the query optimizer (MDEV-17783, MDEV-23937)
* "Condition pushdown into derived table" optimization cannot be applied
if the expression being pushed refers to a derived table column which
is computed from expression that has a stored function call, @session
variable reference, or other similar construct. The fix for MDEV-25969
makes it so that only the problematic part of the condition is not
pushed. The rest of the condition is now pushed. (MDEV-25969)
* A query with window function on the left side of the subquery could
cause a crash. (MDEV-25630)
* Fixed the issue fixed in MySQL Bug #76803: DML or locking SELECT
statements that use outer joins could produce this warning in the
error log: [ERROR] InnoDB: Unlock row could not find a 3 mode lock on
the record. (MDEV-26106)
Security
* Fixes for the following security vulnerabilities:
* CVE-2021-2372
* CVE-2021-2389
|
|
|
|
|
|
|
|
This version of MariaDB is being released now to fix the following two regressions:
Table alias from previous statement interferes later commands (MDEV-25672)
Join using derived with aggregation returns incorrect results (MDEV-25714)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
MariaDB Server is one of the most popular open source relational databases.
It's made by the original developers of MySQL.
MariaDB turns data into structured information in a wide array of applications,
ranging from banking to websites. It is an enhanced, drop-in replacement
for MySQL. MariaDB is used because it is fast, scalable and robust, with a
rich ecosystem of storage engines, plugins and many other tools make it very
versatile for a wide variety of use cases.
MariaDB is developed as open source software and as a relational database
it provides an SQL interface for accessing data. The latest versions of
MariaDB also include GIS and JSON features.
|