![[BACK]](/icons/back.gif){kind=icon}
Up to [cvs.NetBSD.org] / pkgsrc / databases / mariadb105-client
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
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)
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
mariadb105: Update to 10.5.25 Fixes various reliability problems and CVE-2024-21096. Mess around with the patches, since apparently some quite invasive build system changes are being committed to these old LTS branches.
mariadb105: Update to 10.5.24
MariaDB 10.5.24 Changelog
* Includes all fixes from MariaDB 10.4.33
* MDEV-32837 long unique does not work like unique key when using
replace
* MDEV-29954 Unique hash key on column prefix is computed
incorrectly
* cleanup: MY_STRNNCOLLSP_NCHARS_EMULATE_TRIMMED_TRAILING_SPACES
* cleanup: unused and undefined methods
* MDEV-11628 mysql.slow_log reports incorrect start time
* cleanup: main.log_tables test
* disable perfschema in mtr bootstrap
* MDEV-28651 quote(NULL) returns incorrect result in view ('NU'
instead of 'NULL')
* MDEV-33290: Disable ColumnStore based on boost version
* sql_test.cc compile fix
* MDEV-33165 Incorrect result interceptor passed to
mysql_explain_union()
* MDEV-33283: Binlog Checksum is Zeroed by Zlib if Part of Event
Data is Empty
* MDEV-32968 InnoDB fails to restore tablespace first page from
doublewrite buffer when page is empty
* Replace incorrect message `mariadb-safe` with correct
`mariadbd-safe`
* MDEV-27666 User variable not parsed as geometry variable in
geometry function
* MDEV-32968 InnoDB fails to restore tablespace first page from
doublewrite buffer when page is empty
* MDEV-32111: Debian Sid/Trixie will not have libncurses 5 anymore
* MDEV-29298 INSERT ... SELECT Does not produce an optimizer trace
* Fix test failures on s390x in test following
main.column_compression_rpl
* MDEV-32235: mysql_json cannot be used on newly created table
* Revert "MDEV-32235: mysql_json cannot be used on newly created
table"
* MDEV-32235: mysql_json cannot be used on newly created table
* MDEV-32790: Output result in show create table for mysql_json
type should be longtext
* MDEV-30170 ha_spider::delete_table() should report table not
exist
* MDEV-29002 Spider: remove SPIDER_CONN::loop_check_meraged_last
* MDEV-33092 Undefined reference to concurrency on Solaris
* MDEV-32984 Update federated table and column privileges
* MDEV-33098: Fix some instrumentation for innodb.doublewrite_debug
* MDEV-33156 Crash on innodb_buf_flush_list_now=ON and
innodb_force_recovery=6
* MDEV-33098 The test innodb.doublewrite_debug occasionally fails
to start up InnoDB
* MDEV-32549 Cluster inconsistent after SAVEPOINT is rolled back
* MDEV-31905 GTID inconsistency
* MDEV-33046 fixup. Do not try to schedule timer without
dict_stats_start()
* MDEV-33046 - delete unnecessary synchronization with
dict_stats_mutex
* MDEV-24481 : galera_3nodes.galera_vote_rejoin_mysqldump MTR
failed: mysql_shutdown failed
* Fix main.type_timestamp: Change 10.10 in "End of 10.10 tests" to
10.5
* MDEV-33062 innodb_undo_log_truncate=ON prevents fast shutdown
* MDEV-33052 MSAN use-of-uninitialized-value in
buf_read_ahead_linear()
* MDEV-33009 Server hangs for a long time with
innodb_undo_log_truncate=ON
* MDEV-33006 Missing required privilege CONNECTION ADMIN
* MDEV-32839 LONG UNIQUE gives error when used with REPLACE
* cleanup: remove innodb-specific code around
update_auto_increment()
* cleanup: remove partition-specific code around
update_auto_increment()
* [fixup] galera: Fix an accidental logical inversion in a recent
merge
* MDEV-29816 rpl.rpl_parallel_29322 occasionally fails in BB
* MDEV-16264 fixup: Remove a useless test
* MDEV-17226 Column Data in Truncated on UNION to the length of the
first value if using REPLACE
* Cleanup: Removing the unused method
Type_handler::get_handler_by_cmp_type
* MDEV-32971 Assertion !recv_sys.is_corrupt_fs() failed on recovery
* MDEV-31939 Adaptive flush recommendation ignores dirty ratio and
checkpoint age
* MDEV-32242 innodb.doublewrite test case always gets skipped
* [fixup] post-merge spider fixup
* Followup for fix for MDEV-20169: enable main.partition_innodb
* MDEV-32725 innodb.import_update_stats accesses uninitialized
ib_table->stat_n_rows
* fix for the test (real fixes will be in 10.4)
* MDEV-32212 DELETE with ORDER BY and semijoin optimization causing
crash
* MDEV-32269 InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be
crash safe
* MDEV-28682 gcol.gcol_purge contaminates further execution of
innodb.gap_locks
* Remove deprication from mariadbd --debug
* MDEV-32879 Server crash in my_decimal::operator= or unexpected
ER_DUP_ENTRY upon comparison with INET6 and similar types
* MDEV-31611: mariadb-setpermission - Can't use string as an ARRAY
ref while strict refs in use
* MDEV-32861 InnoDB hangs when running out of I/O slots
* MDEV-32820 Race condition between trx_purge_free_segment() and
trx_undo_create()
* MDEV-22243 type_test.type_test_double fails with 'NUMERIC_SCALE
NULL'
* Revert "MDEV-22243 type_test.type_test_double fails with
'NUMERIC_SCALE NULL'"
* MDEV-24784 JSON_ARRAYAGG charset issue
* MDEV-26055: Correct the formula for adaptive flushing
* MDEV-26055: Improve adaptive flushing
* MDEV-32757 innodb_undo_log_truncate=ON is not crash safe
* MDEV-32689: Remove Ubuntu Bionic from 10.5
* MDEV-32798 innodb_fast_shutdown=0 hang after incomplete startup
* bump the VERSION
* galera: cleanup of the lists of disabled tests
* MDEV-31413: post-fix for 10.5+ (galera_restart_replica test
failures)
* MDEV-32737 innodb.log_file_name fails on Assertion `after_apply
|| !(blocks).end in recv_sys_t::clear
* Fix random test failures in testcase perfschema.mdl_func
* MDEV-32672: Don't hold LOCK_thd_data over commit_ordered
* MDEV-32462: mysql_upgrade -s still checks for non system tables
* MDEV-32462: mysql_upgrade -s still checks for non system tables
* MDEV-26875: Wrong user in SET DEFAULT ROLE error
* galera: post-fix after migrating changes from 10.4
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/
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
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.
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)
mariadb105-client: SunOS doesn't support hwaddr.
mariadb105: update to 10.5.17
Notable Items
InnoDB
* InnoDB corruption due to lack of file locking (MDEV-28495)
* FULLTEXT search with apostrophe, and mandatory words (MDEV-20797)
* ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table (MDEV-28779)
* ALTER TABLE wrong-result fix (MDEV-26294)
* Crash recovery fixes (MDEV-28668, MDEV-28731)
Replication
* explicit_defaults_for_timestamp is stored in binlog, so that CREATE
TABLE on slave would always have the same effect as on master.
(MDEV-29078)
* ER_SLAVE_INCIDENT error is specified now on slave to be seen with
SHOW-SLAVE-STATUS (MDEV-21087)
* INCIDENT_EVENT is no longer binlogged when a being logged transaction
can be safely rolledback (MDEV-21443)
* sequences related row-format events are made to correspond to
binlog_row_image (MDEV-28487)
* Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948)
Galera
* Possible to write/update with read_only=ON and not a SUPER privilege
(MDEV-28546)
* Node crashes with Transport endpoint is not connected mysqld got
signal 6 (MDEV-25068)
* Galera4 not able to report proper wsrep_incoming_addresses
(MDEV-20627)
* Galera should replicate nextval()-related changes in sequences with
INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)
Optimizer
* Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)
* Queries that use DISTINCT and an always-constant function like
COLLATION(aggegate_func(...)) could cause a server crash. Note
that COLLATION() is a special function - its value is constant
even if its argument is not costant.
* Crash when using ANY predicand with redundant subquery in GROUP BY
clause (MDEV-29139)
* A query with a subuquery in this form could cause a crash:
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
* MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)
* Certain queries in form "INSERT ... SELECT
with_aggregate_or_window_func" could cause a crash.
* restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly
(MDEV-28749)
* Subquery semi-join optimization could miss LooseScan or
FirstMatch strategies for certain queries.
* Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246)
* For multi-table UPDATE or DELETE queries, the optimizer failed to
apply Partition Pruning optimization for the table that is
updated or deleted from.
* Range optimizer regression for key IN (const, ....) (MDEV-25020)
* The issue can be observed on MariaDB 10.5.9 and later versions
which have the fix for MDEV-9750. That fix introduceds
optimizer_max_sel_arg_weight.
* If one sets optimizer_max_sel_arg_weight to a very high value or
zero (which means "unlimited") and runs queries that produce
heavy-weight graphs, they can observe a performance slowdown,
e.g.:
table.keyXpartY [NOT] IN ( ... )
* Wrong result with table elimination combined with not_null_range_scan
(MDEV-28858)
* If one runs with optimizer_switch='not_null_range_scan=on' (which
is not enabled by default), a query that does a join and has
const tables could produce a wrong result.
CONNECT
* CONNECT Engine now supports INSERT IGNORE with Mysql Table type
(MDEV-27766)
mariadb Client
* New mariadb client option, -enable-cleartext-plugin. Option does not
do anything, and is for MySQL-compatibility purposes only.
General
* explicit_defaults_for_timestamp now also has a session scope, not only
global (MDEV-29225)
* MariaDB can be built with OpenSSL 3.0
* HELP was updated to include the latest content
* Crash in JSON_EXTRACT (MDEV-29188)
* ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (MDEV-28727)
* Server crash upon CREATE VIEW with unknown column in ON condition
(MDEV-29088)
* As per the MariaDB Deprecation Policy, this will be the last release
of MariaDB 10.5 for Debian 10 "Buster" for ppc64el
Security
* Fixes for the following security vulnerabilities:
* CVE-2022-32082
* CVE-2022-32089
* CVE-2022-32081
* CVE-2018-25032
* CVE-2022-32091
* CVE-2022-32084
Pullup ticket #6641 - requested by nia
databases/mariadb105-client: security update
databases/mariadb105-server: security update
Revisions pulled up:
- databases/mariadb105-client/Makefile.common 1.16
- databases/mariadb105-client/distinfo 1.13
- databases/mariadb105-client/patches/patch-CMakeLists.txt 1.2
- databases/mariadb105-server/Makefile 1.25
- databases/mariadb105-server/PLIST 1.10
-------------------------------------------------------------------
Module Name: pkgsrc
Committed By: nia
Date: Sat May 21 10:38:26 UTC 2022
Modified Files:
pkgsrc/databases/mariadb105-client: Makefile.common distinfo
pkgsrc/databases/mariadb105-client/patches: patch-CMakeLists.txt
pkgsrc/databases/mariadb105-server: Makefile PLIST
Log Message:
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
To generate a diff of this commit:
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/mariadb105-client/Makefile.common
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/mariadb105-client/distinfo
cvs rdiff -u -r1.1 -r1.2 \
pkgsrc/databases/mariadb105-client/patches/patch-CMakeLists.txt
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/mariadb105-server/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/mariadb105-server/PLIST
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
mariadb105-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 #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
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/
mariadb105*: Update to 10.5.13 Release notes: https://mariadb.com/kb/en/mariadb-10513-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
mariadb105-client: install missing scripts, PR pkg/56317 Matches later MariaDB versions.
mariadb105: Add SunOS patch from OmniOS. Remove tokudb patches. TokuDB is not built (it's removed in newer MariaDB) so having patches for it is quite redundant.
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)
Pullup ticket #6477 - requested by nia databases/mariadb105-client: NetBSD/aarch64 build fix Revisions pulled up: - databases/mariadb105-client/distinfo 1.2 - databases/mariadb105-client/patches/patch-mysys_crc32_crc32__arm64.c 1.1 --- Module Name: pkgsrc Committed By: nia Date: Sat Jul 3 09:23:45 UTC 2021 Modified Files: pkgsrc/databases/mariadb105-client: distinfo Added Files: pkgsrc/databases/mariadb105-client/patches: patch-mysys_crc32_crc32__arm64.c Log Message: mariadb105-client: Fix building on NetBSD/aarch64
mariadb105-client: Fix building on NetBSD/aarch64
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.