Pullup ticket #6640 - requested by nia
databases/mariadb106-client: security update
databases/mariadb106-server: security update

Revisions pulled up:
- databases/mariadb106-client/Makefile.common                  1.8
- databases/mariadb106-client/distinfo                          1.9
- databases/mariadb106-client/patches/patch-CMakeLists.txt      1.3
- databases/mariadb106-client/patches/patch-storage_innobase_include_transactional__lock__guard.h 1.3
- databases/mariadb106-server/Makefile                          1.15
- databases/mariadb106-server/PLIST                            1.7

-------------------------------------------------------------------
  Module Name: pkgsrc
  Committed By: nia
  Date: Sat May 21 09:36:03 UTC 2022

  Modified Files:
  pkgsrc/databases/mariadb106-client: Makefile.common distinfo
  pkgsrc/databases/mariadb106-client/patches: patch-CMakeLists.txt
      patch-storage_innobase_include_transactional__lock__guard.h
  pkgsrc/databases/mariadb106-server: Makefile PLIST

  Log Message:
  mariadb106: update to 10.6.8

                            MariaDB 10.6.8 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, MDEV-27767,
          MDEV-28313, MDEV-28137, MDEV-28465, MDEV-26789)
        * Backup regression fixes (MDEV-27919)
        * 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 persistent statistics were sometimes lost
          (MDEV-27805)

    Replication

        * Semisync-slave server recovery is refined to correctly rollback
          prepared transaction (MDEV-28461)
        * Circular semisync setup endless event circulation is handled
          (MDEV-27760)
        * Semisync-slave server recovery is extended to work on new server_id
          server (MDEV-27342)
        * 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

        * Query performance degradation in newer MariaDB versions when using
          many tables (MDEV-28073)
        * 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
        * Packages for Ubuntu 22.04 LTS "Jammy" and Fedora 36 are not yet
          available pending the resolution of MDEV-28133: Backport OpenSSL-3.0
          compatibility to 10.6 branch

    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

  To generate a diff of this commit:
  cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/mariadb106-client/Makefile.common
  cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/mariadb106-client/distinfo
  cvs rdiff -u -r1.2 -r1.3 \
      pkgsrc/databases/mariadb106-client/patches/patch-CMakeLists.txt \
      pkgsrc/databases/mariadb106-client/patches/patch-storage_innobase_include_transactional__lock__guard.h
  cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/mariadb106-server/Makefile
  cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/mariadb106-server/PLIST

(spz)