Path to this page:
Subject: CVS commit: pkgsrc/databases
From: Nia Alarie
Date: 2023-07-01 15:56:17
Message id: 20230701135617.9F249FA89@cvs.NetBSD.org
Log Message:
mariadb106: update to 10.6.14
MariaDB 10.6.14 Release Notes
Notable Items
InnoDB
* Server crashes in st_join_table::choose_best_splitting (MDEV-31403)
* Crash with condition pushable into derived and containing outer
reference (MDEV-31240)
* InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)
* InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)
* Innodb_buffer_pool_read_requests 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"
Optimizer
* Crash with condition pushable into derived and containing outer
reference (MDEV-31403 MDEV-31240)
* Crash with EXPLAIN EXTENDED for multi-table update of system table
(MDEV-31224)
MariaDB 10.6.13 Release Notes
Notable Items
InnoDB
* Crash on ROLLBACK in a ROW_FORMAT=COMPRESSED 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 (MDEV-30551)
* InnoDB undo log truncation fails to wait for purge of history
(MDEV-30671
* MariaDB crash due to DB_FAIL reported for a corrupted page
(MDEV-30397)
* Deadlock between INSERT and InnoDB non-persistent statistics update
(MDEV-30638)
* InnoDB hang on B-tree split or merge (MDEV-29835)
* Performance regression in locking reads from secondary indexes
(MDEV-30357)
* Improve adaptive flushing (MDEV-26055)
* Make page flushing even faster (MDEV-26827)
* Purge misses a chance to free not-yet-reused undo pages (MDEV-29593)
* InnoDB temporary tablespace: reclaiming of free space does not work
(MDEV-26782)
* Fix miscount of doublewrites by Innodb_data_written (MDEV-31124)
Backup
* mariadb-backup doesn't utilise innodb-undo-log-directory (if specified
as a relative path) during copy-back operation (MDEV-28187)
* mariabackup 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)
Replication
* 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
(MDEV-30780)
* Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a
necessary mutex always intialized (MDEV-30620)
* Fixed the slave applier to report a correct error when gtid_slave_pos
insert fails for some (engine) reasons (MDEV-31038)
* Made parallel slave reports in performance schema consistent with that
of show-slave-status (MDEV-26071)
Optimizer
* Split Materialized 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, hash_join_cardinality, 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)
* ANALYZE FORMAT=JSON now prints more information about Block Nested
Loop joins: block-nl-join element now has r_loops, r_effective_rows
and r_other_time_ms fields (MDEV-30806, MDEV-30972).
* 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 (MDEV-30605)
* EXPLAIN could erroneously report that Rowid Filter optimization is
used for partitioned tables. Partitioned tables do not support it.
(MDEV-30596)
* 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 (MDEV-31067).
Security
* Fixes for the following security vulnerabilities:
* CVE-2022-47015
Files: