--- - branch: MAIN date: Sat Jul 1 13:56:17 UTC 2023 files: - new: '1.13' old: '1.12' path: pkgsrc/databases/mariadb106-client/Makefile pathrev: pkgsrc/databases/mariadb106-client/Makefile@1.13 type: modified - new: '1.17' old: '1.16' path: pkgsrc/databases/mariadb106-client/Makefile.common pathrev: pkgsrc/databases/mariadb106-client/Makefile.common@1.17 type: modified - new: '1.7' old: '1.6' path: pkgsrc/databases/mariadb106-client/PLIST pathrev: pkgsrc/databases/mariadb106-client/PLIST@1.7 type: modified - new: '1.15' old: '1.14' path: pkgsrc/databases/mariadb106-client/distinfo pathrev: pkgsrc/databases/mariadb106-client/distinfo@1.15 type: modified - new: '1.26' old: '1.25' path: pkgsrc/databases/mariadb106-server/Makefile pathrev: pkgsrc/databases/mariadb106-server/Makefile@1.26 type: modified id: 20230701T135617Z.9d4f70d1d3c810b0c9a96af994c6ab396f660931 log: | 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 module: pkgsrc subject: 'CVS commit: pkgsrc/databases' unixtime: '1688219777' user: nia