CVS log for pkgsrc/databases/mariadb105-server/Makefile

Up to [cvs.NetBSD.org] / pkgsrc / databases / mariadb105-server

Request diff between arbitrary revisions

Keyword substitution: kv
Default branch: MAIN

mariadb: RC script fixes. From RVP on netbsd-users@.

*: recursive bump for default Kerberos implementation switch

*: recursive bump for icu 77 and libxml2 2.14

mariadb: Update packages to latest minor version of LTS releases.

While here, delint (mainly fixing whitespace issues in options.mk).

Builds on: FreeBSD NetBSD OmniOS macOS

revbump after updating boost

mariadb105: Update to 10.5.27

                         MariaDB 10.5.27 Release Notes

Notable Items

  Storage Engines

    InnoDB

     * Fix MariaDB crash with SIGILL because the OS does not support AVX512
       (MDEV-34565)
     * Fix innodb.innodb-lock-inherit-read_commited failure with timeout
       (MDEV-33106)

    Spider

     * Fix server crash when calling spider UDF after aria_encrypt_tables is
       enabled (MDEV-34682)
     * SELECT MIN on Spider table no longer returns more rows than expected
       (MDEV-26345)
     * Fix Spider group by handler wrong result on order by aggregate
       (MDEV-29546)

  Optimizer

     * Fix crash caused by query containing constant having clause
       (MDEV-23983)

  Data Definition - Alter Table

     * Modification of the column now correctly checks foreign key constraint
       (MDEV-34392)
     * Fix incorrect NULL value handling for instantly dropped BLOB columns
       (MDEV-35122)

  Galera

     * Galera updated to 26.4.20
     * Fix server crash when setting wsrep_cluster_address after adding
       invalid value to wsrep_allowlist table (MDEV-31173)
     * Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera
       (MDEV-34647)
     * Fix galera_ssl_reload failure with warning message (MDEV-32778)
     * When InnoDB gets an assertion failure, WSREP layer is now handled
       gracefully (MDEV-32363)

  Backup

     * Recovery now correctly notes some log corruption (MDEV-34802)
     * Can now selectively restore sequences using innodb tables from backup
       (MDEV-32350)

  General

     * mariadbd no longer hangs on startup when --init-file target does not
       exist (MDEV-34814)
     * LOAD DATA INFILE with geometry data no longer fails (MDEV-34883)
     * Fix heap-use-after-free in group_concat with compressed or GIS columns
       (MDEV-16699)
     * Trigger now works correctly with bulk update (MDEV-34718)
     * Fix assertion failure in find_producing_item upon a query from a view
       (MDEV-35276)
     * Add new setting, --quick-max-column-width to the mariadb client for
       use in --quick mode (MDEV-34704)

*: recursive bump for icu 76 shlib major version bump

*: revbump for icu downgrade

*: recursive bump for icu 76.1 shlib bump

*: Recursive revbump from Boost 1.86.0

*: replace CMAKE_ARGS with CMAKE_CONFIGURE_ARGS

mariadb105-*: Update to 10.5.26

                         MariaDB 10.5.26 Release Notes

Notable Items

  Storage Engines

    InnoDB

     * Alter operation on redundant table aborts the server (MDEV-34222)
     * MariaDB crashes with SIGILL because the OS does not support AVX512
       (MDEV-34565)
     * InnoDB: Failing assertion: stat_n_leaf_pages > 0 in
       ha_innobase::estimate_rows_upper_bound (MDEV-34474)

    Aria

     * Index for (specific) Aria table is created as corrupted (MDEV-34522)

    Spider

     * UBSAN: runtime error: applying non-zero offset in spider_free_mem and
       SIGSEGV in spider_free_mem on SELECT (MDEV-31475)
     * SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index
       4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)
     * SIGSEGV in spider_db_conn::fin_loop_check, and ASAN:
       heap-use-after-free in spider_db_mbase::fin_loop_check on SHOW TABLE
       STATUS (MDEV-34541)
     * SIGSEGV in ha_spider::lock_tables on BEGIN after table lock
       (MDEV-29962)
     * SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and
       SELECT (MDEV-32492)
     * Spider: Crashes, asserts, hangs, memory corruptions and ASAN
       heap-use-after-free's (MDEV-27902)
     * Spider: @@insert_id 128 to TINYINT: Assertion `!is_set() || (m_status
       == DA_OK_BULK && is_bulk_op())' failed. (MDEV-28105)
     * Server crashes when calling spider UDF after aria_encrypt_tables is
       enabled (MDEV-34682)

  Partitioning

     * MariaDB Server crashes with ill-formed partitions (MDEV-32155)
     * SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER
       (MDEV-34421)
     * Assertion `auto_increment_value' failed in ha_partition::info on
       INSERT into MEMORY table (MDEV-24610)

  Character Sets

     * On startup: UBSAN: applying zero offset to null pointer in
       my_copy_fix_mb from strings/ctype-mb.c and other locations
       (MDEV-34226)
     * On startup: UBSAN: runtime error: applying zero offset to null pointer
       in skip_trailing_space and
       my_hash_sort_utf8mb3_general1400_nopad_as_ci (MDEV-34187)
     * SHOW CREATE DATABASE statement crashes the server when db name
       contains some unicode characters, ASAN stack-buffer-overflow
       (MDEV-32376)
     * Wrong result set with utf8mb4_danish_ci and BNLH join (MDEV-34417)

  Optimizer

     * On startup: UBSAN: runtime error: applying non-zero offset in
       JOIN::make_aggr_tables_info in sql/sql_select.cc (MDEV-34227)
     * Crash after killing query while it is processed by test_quick_select
       (MDEV-30651)
     * Extend condition normalization to include 'NOT a' (MDEV-19520)
     * Constant subquery causing a crash in pushdown optimization
       (MDEV-29363)
     * Crash when pushing condition with CHARSET()/COERCIBILITY() into
       derived table (MDEV-33010)
     * 2nd execution name resolution problem with pushdown into unions
       (MDEV-34506)
     * Assertion `(key_part->key_part_flag & 4) == 0' failed key_hashnr
       (MDEV-34580)
     * Crash caused by query containing constant having clause (MDEV-23983)
     * ORDER BY DESC causes ROWID Filter optimization performance degradation
       (MDEV-33875)

  Replication

     * Auto-generated DELETE from HEAP table can break replication
       (MDEV-25607)
     * Replication fails when XA transactions are used where the slave has
       replicate_do_db set and the client has touched a different database
       when running DML such as inserts. (MDEV-33921)
     * replication master password length (MDEV-23857)

  Backup

     * Hide password passed on commandline from xtrabackup_info (MDEV-34434)

  Galera

     * Galera updated to 26.4.19
     * galera_gtid_2_cluster: Assertion `thd->wsrep_next_trx_id() !=
       (0x7fffffffffffffffLL * 2ULL + 1)' (MDEV-32633)
     * table gtid_slave_pos entries never been deleted with wsrep_gtid_mode =
       0 (MDEV-34170)
     * Change error code for Galera unkillable threads (MDEV-12008)
     * 10.11.8 cluster becomes inconsistent when using composite primary key
       and partitioning (MDEV-34269)
     * wsrep_sst_mariabackup use /tmp dir during SST rather then user defined
       tmpdir (MDEV-32158)

  General

     * As per the MariaDB Deprecation Policy, this will be the last release
       of MariaDB 10.5 for Debian 10 "Buster", and RHEL/CentOS 7
     * IMPORT TABLESPACE unnecessarily traverses tablespaces list
       (MDEV-34670)
     * unknown variable defaults-group-suffix= with
       mariadb-secure-installation (MDEV-33265)
     * mariadb-install-db appears to hang on macOS (MDEV-34129)
     * Control over memory allocated for SP/PS (MDEV-14959)
     * Trigger doesn't work correctly with bulk insert (MDEV-24411)
     * Assertion `table->field[0]->ptr >= table->record[0] &&
       table->field[0]->ptr <= table->record[0] + table->s->reclength' failed
       in void handler::assert_icp_limitations(uchar*) (MDEV-34632)
     * Sandbox mode \- is not compatible with --binary-mode (MDEV-34203)

Apply fix for hang and data loss on mariadb 10.5 shutdown

Apply https://github.com/MariaDB/server/pull/3253 to fix a hang on
at least NetBSD resulting in unrecoverable database corruption when
attempting to shutdown the mariadb server

revbump after icu and protobuf updates

*: recursive bump for gnutls p11-kit option

(existing installations need the bl3.mk included, but it's now only
optionally included)

mariadb105: Update to 10.5.23

Fixes various crashes and data corruption issues.

Release notes:
https://mariadb.com/kb/en/mariadb-10-5-23-release-notes/

revbump for boost-libs

*: recursive bump for icu 74.1

*: bump for openssl 3

*: recursive bump for Python 3.11 as new default

Pullup ticket #6774 - requested by nia
databases-mariadb105-client: security fix
databases-mariadb105-server: security fix

Revisions pulled up:
- databases/mariadb105-client/Makefile                          1.16
- databases/mariadb105-client/Makefile.common                   1.21
- databases/mariadb105-client/PLIST                             1.7
- databases/mariadb105-client/distinfo                          1.19
- databases/mariadb105-client/patches/patch-include_mysql_service__encryption.h deleted
- databases/mariadb105-server/Makefile                          1.36

---
   Module Name:	pkgsrc
   Committed By:	nia
   Date:		Sat Jul  1 16:02:04 UTC 2023

   Modified Files:
   	pkgsrc/databases/mariadb105-client: Makefile Makefile.common PLIST
   	    distinfo
   	pkgsrc/databases/mariadb105-server: Makefile
   Removed Files:
   	pkgsrc/databases/mariadb105-client/patches:
   	    patch-include_mysql_service__encryption.h

   Log Message:
   mariadb105: update to 10.5.21

                            MariaDB 10.5.21 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)
        * 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.5.20 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
        * 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)

     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).
        * Queries using SELECT DISTINCT some_expression(aggregate_function())
          could produce wrong query result. (MDEV-20057)
        * 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

mariadb105: update to 10.5.21

                         MariaDB 10.5.21 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)
     * 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.5.20 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
     * 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)

  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).
     * Queries using SELECT DISTINCT some_expression(aggregate_function())
       could produce wrong query result. (MDEV-20057)
     * 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

revbump for boost

revbump after textproc/icu update

mariadb105: Update to 10.5.19

Notable Items

  InnoDB

     * Full-text index corruption with system versioning (MDEV-25004)
     * innodb_undo_log_truncate=ON recovery and backup fixes (MDEV-29999,
       MDEV-30179, MDEV-30438)
     * Upgrade after a crash is not supported (MDEV-24412)
     * Remove InnoDB buffer pool load throttling (MDEV-25417)
     * InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009)
     * innodb_fast_shutdown=0 fails to report change buffer merge progress
       (MDEV-29984)

  Galera

     * Fixes for cluster wide write conflict resolving (MDEV-29684)

  Replication

     * Parallel slave applying in binlog order is corrected for admin class
       of commands including ANALYZE (MDEV-30323)
     * Seconds_Behind_Master is showed now more precisely at the slave
       applier start, including in the delayed mode (MDEV-29639)
     * mysqlbinlog --verbose is made to show the type of compressed columns
       (MDEV-25277)
     * Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT
       and a committing user XA (MDEV-30423)

  JSON

     * JSON_PRETTY added as an alias for JSON_DETAILED (MDEV-19160)

  General

     * Infinite sequence of recursive calls when processing embedded CTE
       (MDEV-30248)
     * Crash with a query containing nested WINDOW clauses (MDEV-30052)
     * Major performance regression with 10.6.11 (MDEV-29988)

mariadb105: Various SunOS fixes.

*: Recursive revbump from Boost 1.81.0

mariadb105: update to 10.5.18

                         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)

massive revision bump after textproc/icu update

*: bump PKGREVISION for libunistring shlib major bump

Reset PKGREVISION.

*: recursive bump for perl 5.36

mariadb105: Update to 10.5.16

                         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

revbump for textproc/icu update

Pullup ticket #6584 - requested by nia
databases/mariadb105-client, databases/mariadb105-server: security fix

Revisions pulled up:
- databases/mariadb105-client/Makefile                          1.10
- databases/mariadb105-client/Makefile.common                   1.15
- databases/mariadb105-client/PLIST                             1.4
- databases/mariadb105-client/distinfo                          1.11
- databases/mariadb105-server/Makefile                          1.23

---
   Module Name:	pkgsrc
   Committed By:	nia
   Date:		Sat Feb 19 09:57:51 UTC 2022

   Modified Files:
   	pkgsrc/databases/mariadb105-client: Makefile Makefile.common PLIST
   	    distinfo
   	pkgsrc/databases/mariadb105-server: Makefile

   Log Message:
   mariadb105: update to 10.5.15

                            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

mariadb105: update to 10.5.15

                         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

Allow overriding mariadb_datadir in rc.conf

Bump PKGREVISION

*: Recursive revbump from boost 1.78.0

Pullup ticket #6549 - requested by nia
databases/mariadb105: security fix

Revisions pulled up:
- databases/mariadb105-client/Makefile                          1.8
- databases/mariadb105-client/Makefile.common                   1.14
- databases/mariadb105-client/PLIST                             1.3
- databases/mariadb105-client/distinfo                          1.10
- databases/mariadb105-client/patches/patch-plugin_auth__pam_CMakeLists.txt deleted
- databases/mariadb105-client/patches/patch-scripts_CMakeLists.txt 1.3
- databases/mariadb105-server/Makefile                          1.18
- databases/mariadb105-server/PLIST                             1.8

---
   Module Name:	pkgsrc
   Committed By:	nia
   Date:		Sat Nov 27 22:52:15 UTC 2021

   Modified Files:
   	pkgsrc/databases/mariadb105-client: Makefile Makefile.common PLIST
   	    distinfo
   	pkgsrc/databases/mariadb105-client/patches:
   	    patch-scripts_CMakeLists.txt
   	pkgsrc/databases/mariadb105-server: Makefile PLIST
   Removed Files:
   	pkgsrc/databases/mariadb105-client/patches:
   	    patch-plugin_auth__pam_CMakeLists.txt

   Log Message:
   mariadb105*: Update to 10.5.13

   Release notes:
   https://mariadb.com/kb/en/mariadb-10513-release-notes/

revbump for icu and libffi

Add -DCONNECT_WITH_MONGO=NO to mariadb10{4,5,6}-server

Avoids build failure if monogb 4.x is installed.

Someone can always add a mongodb option to options.mk if they want, but
this is just to ensure reliable builds

mariadb105*: Update to 10.5.13

Release notes:
https://mariadb.com/kb/en/mariadb-10513-release-notes/

*: recursive bump for heimdal 7.7.0

its buildlink3.mk now includes openssl's buildlink3.mk

revbump for boost-libs

mariadb[105,106]-server: Use default auth method (socket) in rc script

mariadb*: auth_pam also not built on SunOS

mariadb*: add PLIST VARS for mariabackup, not built on SunOS

mariadb105: update to 10.5.12

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

mariadb105: Add support for auth_socket on NetBSD.

mariadb105*: Update to 10.5.11

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)

databases/mariadb105-server: fix startup script

Fix startup problem of mariadb.

* Remove creating ${VARBASE}/run/mariadb with OWN_DIRS_PERMS since
  ${VARBASE}/run will be cleared on system start up.
* Create ${VARBASE}/run/mariadb in startup script with sutable owner.

Bump PKGREVISION.

mariadb*: Disable embedded server by default.

It is off by default upstream and doesn't seem to work well with
any non-GNU linker.

mariadb*: Disable embedded-server on SunOS

mariadb105: Don't install full test suite. Suggested by jperkin.

mariadb105-server: add more PKG_OPTIONS.

The defaults are basically based on what FreeBSD/OpenBSD are doing.

MariaDB includes several third-party storage engines (e.g. RocksDB)
which are developed out-of-tree and don't generally have the same
(e.g. portability) guarantees. Keep these disabled by default for now.

bump PKGREVISION.

mariadb*: Simplify variable assignment and dedup.

*: recursive bump for perl 5.34

mariadb*: update COMMENTs

mariadb105[-client,-server]: import mariadb 10.5

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.