![[BACK]](/icons/back.gif){kind=icon}
Up to [cvs.NetBSD.org] / pkgsrc / databases / mariadb106-client
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
mariadb106-*: Update to 10.6.19
MariaDB 10.6.19 Release Notes
Notable Items
Storage Engines
InnoDB
* We fail to terminate transaction early with ER_LOCK_TABLE_FULL when
lock memory is growing (MDEV-34167)
* 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)
* wait_for_read in buf_page_get_low hurts performance (MDEV-34458)
* InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc
line 4211 (MDEV-34357)
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)
* ASAN errors in spider_db_free_result after partition DDL (MDEV-29027)
* 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)
* Using NAME_CONST() (or executing query from the stored procedure and
referring to a local variable) changes the plan and may make execution
slower (MDEV-33971)
* 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)
* an option to enable semisync recovery (MDEV-33465)
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)
* Deadlock found when trying to get lock during applying (MDEV-31658)
* 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.6 for Debian 10 "Buster", RHEL/CentOS 7, and Fedora 38
* 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)
* We fail to terminate transaction early with ER_LOCK_TABLE_FULL when
lock memory is growing (MDEV-34167)
* Disable new connections in case of fatal signal (MDEV-34475)
* 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.6 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
mariadb106: Update to 10.6.18 Fixes various fatal errors and CVE-2024-21096. XXX mariadb.org mentions 10.6.19 but there appears to be no such release as of yet.
mariadb106: Update to 10.6.17
MariaDB 10.6.17 Changelog
* Includes all fixes from MariaDB 10.5.24
* pcre.cmake: always check the library with check_library_exists()
* fix columnstore compilation on fc39
* Disable perfschema.misc_session_status for 32 bit
* Updated some 32 bit result files in sys_vars
* Fixed some wrong printf() usage after changing m_table_id to
ulonglong
* fix failing test on buildbot for MDEV-27087
* MDEV-33317 [Warning] InnoDB: Could not free any blocks in the
buffer pool!
* MDEV-31616 Problems with a stored function EMPTY() on upgrade to
10.6.
* reorder the log columns for MDEV-27087
* Fixed some mtr tests that failed on windows
* Fixed compiler error/warning in backup_copy.cc
* Fixed main.strict test to work with icc compiler
* Disable main.gis from embedded
* MDEV-33279 Disable transparent huge pages after page buffers has
been allocatedDisable transparent huge pages (THP)
* Trivial fixes:
* Temporary table name used by multip-update has 'null' as part of
the name
* MDEV-33118 optimizer_adjust_secondary_key_costs variable
* Ensure keyread_tmp variable is assigned.
* Fixed possible mutex-wrong-order with KILL USER
* MDEV-32551: "Read semi-sync reply magic number error" warnings on
master
* MDEV-32906: The SQL error plugin prints (null) as database if the
mariadb client is not using any database to execute the SQL.
* MDEV-27087: Add thread ID and database / table, where the error
occured to SQL error plugin
* new CC 3.3
* MDEV-33053 fixup: Correct a condition before a message
* MDEV-33031 test fixup for HAVE_PERFSCHEMA=NO
* MDEV-32983 cosmetic improvement on path separator near
ib_buffer_pool
* MDEV-33091 pcre2 headers aren't found on Solaris
* Revert "MDEV-32899 InnoDB is holding shared dict_sys.latch while
waiting for FOREIGN KEY child table lock on DDL"
* MDEV-33275 buf_flush_LRU():
mysql_mutex_assert_owner(&buf_pool.mutex) failed
* MDEV-33053 InnoDB LRU flushing does not run before running out of
buffer pool
* new CC 3.3
* innodb: IO Error message missing space
* MDEV-33095 innodb_flush_method=O_DIRECT creates excessive errors
on Solaris
* MDEV-33213 fixup: GCC 5 -Wconversion
* MDEV-30940: Try to fix the test
* MDEV-33213 History list is not shrunk unless there is a pause in
the workload
* MDEV-32559 failing spider signal_ddl_recovery_done callback
should result in spider deinit
* MDEV-33112 innodb_undo_log_truncate=ON is blocking page write
* MDEV-32050 fixup: Remove srv_purge_rseg_truncate_frequency
* MDEV-33137: Assertion end_lsn == page_lsn failed in
recv_recover_page
* MDEV-33150 double-locking of LOCK_thd_kill in
performance_schema.session_status
* cleanup: change a function, that always return 0, to void
* MDEV-33031 Assertion failure upon reading from performance schema
with binlog enabled
* cleanup: spider status variables
* MDEV-33031 Assertion failure upon reading from performance schema
with binlog enabled
* MDEV-11777 REGEXP_REPLACE converts utf8mb4 supplementary
characters to '?'
* Fix galera.galera_kill_ddl test errors in debug mode.
* [fixup] Spider: correct init queries after merge
* MDEV-33000: Fix test result file on some test cases
* MDEV-33046 - reschedule dict_stats_func() if there work left to
do.
* Cleanup - reuse background THD in dict_stats_func()
* Fix an intermittent test failure
* Add an end-of-test marker
* MDEV-33098: Disable the test
* MDEV-33009 Server hangs for a long time with
innodb_undo_log_truncate=ON
* MDEV-33046 race condition in InnoDB dict_stats_schedule()
* Spider cannot run DDL (e.g. create tables) before ddl recovery
* Adjust the MDEV-26052 test case for MDEV-29092
* MDEV-18322 Assertion "wrong page type" on instant ALTER TABLE
* MDEV-32939 If tables are frequently created, renamed, dropped, a
backup cannot be restored
* MDEV-32751 fixup: cmake -DPLUGIN_PERFSCHEMA=NO
* perfschema: use LOCK_thd_kill to "keep THD during
materialization"
* MDEV-32751 sys schema view session_ssl_status is empty
* MDEV-32617 deprecate secure_auth=0
* main.long_host failures
* MDEV-32884 backward compatibility fixes
* MDEV-31296: Crash in Item_func::fix_fields when prepared
statement with subqueries and window function is executed with
sql_mode = ONLY_FULL_GROUP_BY
* MDEV-32958 Unusable key notes do not get reported for some
operations
* MDEV-32884 Improve S3 options comaptibility
* MDEV-32957 Unusable key notes report wrong predicates for > and
>=
* MDEV-32068 Some calls to buf_read_ahead_linear() seem to be
useless
* MDEV-32899 instrumentation fixup
* Fix occasional failure of encryption.corrupted_during_recovery
* Fix occasional failure of innodb.innodb-alter-tempfile
* MDEV-32903 MDEV-32532 Assertion failure in
ddl_log_increment_phase_no_lock upon ..
* MDEV-32884 Make s3_debug dynamic
* mysqladmin -vv processlist now shows more information
* MDEV-32371 Deadlock between buf_page_get_zip() and
buf_pool_t::corrupted_evict()
* MDEV-31817 SIGSEGV after btr_page_get_father_block() returns
nullptr on corrupted data
* MDEV-32899 instrumentation
* MDEV-32899 InnoDB is holding shared dict_sys.latch while waiting
for FOREIGN KEY child table lock on DDL
* MDEV-32879 Server crash in my_decimal::operator= or unexpected
ER_DUP_ENTRY upon comparison with INET6 and similar types
* MDEV-32873 Test innodb.innodb-index-online occasionally fails
* MDEV-32050 fixup: Stabilize tests
* MDEV-32050 fixup: innodb.instant_alter_crash (take 2)
* MDEV-32027 Opening all .ibd files on InnoDB startup can be slow
* MDEV-31861 Empty INSERT crashes with innodb_force_recovery=6 or
innodb_read_only=ON
* MDEV-32050 fixup: innodb.instant_alter_crash
* MDEV-32757: rollback crash on corruption
* MDEV-32689: Remove Ubuntu Bionic
* bump the VERSION
* MDEV-32788: Debug build failure with SUX_LOCK_GENERIC
mariadb106: Update to 10.6.16 Fixes various data corruption issues and crashes, adds a new Charset Narrowing Optimization. Release notes: https://mariadb.com/kb/en/mariadb-10-6-16-release-notes/
Pullup ticket #6775 - requested by nia
databases/mariadb106-client: security fix
databases/mariadb106-server: security fix
Revisions pulled up:
- databases/mariadb106-client/Makefile 1.13
- databases/mariadb106-client/Makefile.common 1.17
- databases/mariadb106-client/PLIST 1.7
- databases/mariadb106-client/distinfo 1.15
- databases/mariadb106-server/Makefile 1.26
---
Module Name: pkgsrc
Committed By: nia
Date: Sat Jul 1 13:56:17 UTC 2023
Modified Files:
pkgsrc/databases/mariadb106-client: Makefile Makefile.common PLIST
distinfo
pkgsrc/databases/mariadb106-server: Makefile
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
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
mariadb106: update to 10.6.12
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)
* mariadb-backup --backup --incremental --throttle=... hangs
(MDEV-29896)
* Crash after recovery, with InnoDB: Tried to read (MDEV-30132)
* Trying to write ... bytes at ... outside the bounds (MDEV-30069)
* TRUNCATE breaks FOREIGN KEY locking (MDEV-29504, MDEV-29849)
* INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo
tablespaces (MDEV-30119)
* Fixed hangs and error handling in B-tree operations (MDEV-29603,
MDEV-30400)
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)
mariadb106-client: fix build on NetBSD with binutils 2.39
mariadb106: Update to 10.6.11
MariaDB 10.6.11 Release Notes
Notable Items
Backup
* Assertion on info.page_size failed in xb_delta_open_matching_space
(MDEV-18589)
InnoDB
* Adaptive hash index MDEV-27700, MDEV-29384
* MVCC and locking (MDEV-29666, MDEV-27927, MDEV-28709, MDEV-29635)
* Virtual columns (MDEV-29299, MDEV-29753)
* InnoDB crash recovery fixes (MDEV-29559)
* Race condition between KILL and transaction commit (MDEV-29368)
* Implement CHECK TABLE…EXTENDED for InnoDB (MDEV-24402)
* InnoDB persistent statistics fail to update after bulk insert
(MDEV-28327)
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)
Replication
* 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)
mariadb106-client: SunOS doesn't support hwaddr.
mariadb106: Update to 10.6.10
Notable Items
* Fix Assertion mysql_mutex_assert_owner(&log_sys.flush_order_mutex)
failed in mtr_t::commit() (MDEV-29383)
* Fix Frequent "Data structure corruption" in InnoDB after OOM
(MDEV-29374)
* Fix Recovery or backup of instant ALTER TABLE is incorrect
(MDEV-29438)
* Fix InnoDB Temporary Tablespace (ibtmp1) is continuously growing
(MDEV-28240)
* Fix full text index corruption if shutdown before changes are fully
flushed (MDEV-29342)
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
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
mariadb106: Build fix for Solaris / SmartOS by re-order includes On Solaris / SmartOS it's required to provide the correct order of including pam_appl.h before pam_modules.h.
mariadb106-client: no need to special case __APPLE__ for pkgsrc builds The file client/mysql.cc uses the readline library, but it has preprocessor conditionals specially for __APPLE__. Pkgsrc expects a common readline, however, and so the build fails. Removing the special case handles __APPLE__ the same as other platforms.
Pullup ticket #6585 - requested by nia
databases/mariadb106-client, databases/mariadb106-server: security fix
Revisions pulled up:
- databases/mariadb106-client/Makefile 1.6
- databases/mariadb106-client/Makefile.common 1.7
- databases/mariadb106-client/PLIST 1.3
- databases/mariadb106-client/distinfo 1.6
- databases/mariadb106-client/patches/patch-storage_innobase_include_transactional__lock__guard.h 1.2
- databases/mariadb106-server/Makefile 1.12
---
Module Name: pkgsrc
Committed By: nia
Date: Sat Feb 19 09:13:21 UTC 2022
Modified Files:
pkgsrc/databases/mariadb106-client: Makefile Makefile.common PLIST
distinfo
pkgsrc/databases/mariadb106-client/patches:
patch-storage_innobase_include_transactional__lock__guard.h
pkgsrc/databases/mariadb106-server: Makefile
Log Message:
mariadb106: update to 10.6.7
MariaDB 10.6.7 Release Notes
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.6.6 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)
* mariabackup skips valid .ibd file (MDEV-26326)
* Allow seamless upgrade despite ROW_FORMAT=COMPRESSED (MDEV-27736)
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
mariadb106: update to 10.6.7
MariaDB 10.6.7 Release Notes
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.6.6 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)
* mariabackup skips valid .ibd file (MDEV-26326)
* Allow seamless upgrade despite ROW_FORMAT=COMPRESSED (MDEV-27736)
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
Pullup ticket #6550 - requested by nia databases/mariadb106: security fix Revisions pulled up: - databases/mariadb106-client/Makefile 1.4 - databases/mariadb106-client/Makefile.common 1.6 - databases/mariadb106-client/PLIST 1.2 - databases/mariadb106-client/distinfo 1.5 - databases/mariadb106-client/patches/patch-CMakeLists.txt 1.2 - databases/mariadb106-client/patches/patch-plugin_auth__pam_CMakeLists.txt deleted - databases/mariadb106-client/patches/patch-plugin_auth__socket_auth__socket.c deleted - databases/mariadb106-client/patches/patch-scripts_CMakeLists.txt 1.2 - databases/mariadb106-client/patches/patch-storage_innobase_include_transactional__lock__guard.h 1.1 - databases/mariadb106-server/Makefile 1.7 - databases/mariadb106-server/PLIST 1.5 --- Module Name: pkgsrc Committed By: nia Date: Sat Nov 27 23:40:28 UTC 2021 Modified Files: pkgsrc/databases/mariadb106-client: Makefile Makefile.common PLIST distinfo pkgsrc/databases/mariadb106-client/patches: patch-CMakeLists.txt patch-scripts_CMakeLists.txt pkgsrc/databases/mariadb106-server: Makefile PLIST Added Files: pkgsrc/databases/mariadb106-client/patches: patch-storage_innobase_include_transactional__lock__guard.h Removed Files: pkgsrc/databases/mariadb106-client/patches: patch-plugin_auth__pam_CMakeLists.txt patch-plugin_auth__socket_auth__socket.c Log Message: mariadb106*: Update to 10.6.5 Release notes: https://mariadb.com/kb/en/mariadb-1065-release-notes/
mariadb106*: Update to 10.6.5 Release notes: https://mariadb.com/kb/en/mariadb-1065-release-notes/
databases: Replace RMD160 checksums with BLAKE2s checksums All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
databases: Remove SHA1 distfile hashes
mariadb106: update to 10.6.4
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)
* buf_pool.flush_list corrupted by buffer pool resizing or
ROW_FORMAT=COMPRESSED (MDEV-26200)
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
databases: Add MariaDB 10.6. What's new in 10.6: https://mariadb.com/kb/en/changes-improvements-in-mariadb-106/