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:
RevisionActionfile
1.13modifypkgsrc/databases/mariadb106-client/Makefile
1.17modifypkgsrc/databases/mariadb106-client/Makefile.common
1.7modifypkgsrc/databases/mariadb106-client/PLIST
1.15modifypkgsrc/databases/mariadb106-client/distinfo
1.26modifypkgsrc/databases/mariadb106-server/Makefile