Changelog for MariaDB Enterprise Server 10.5.26-20

Overview

MariaDB Enterprise Server 10.5.26-20 is a maintenance release of MariaDB Enterprise Server 10.5. For the categorized highlights and other details of this release, see the release notes.

MariaDB Enterprise Server 10.5.26-20 was released on 2024-09-09.

Changes

  • (MENT-1897) Backport MDEV-26182 - Functions JSON_OBJECT_FILTER_KEYS, JSON_OBJECT_TO_ARRAY, JSON_ARRAY_INTERSECT

  • (MENT-1896) Backport MDEV-30145 - Function JSON_KEY_VALUE()

  • (MDEV-34548) Q3 2024 release merge

  • (MDEV-33650) Q2 2024 release merge

  • (MDEV-34581) mariadb-dump man page incorrectly refers to flashback option

  • (MDEV-34353) Revert changes for indefinite wait during signal handler under --bootstrap

  • (MDEV-34359) Spider: add tests for connection param overriding

  • (MDEV-34168) Extend perror utility to print link to knowledge page

  • (MDEV-34491) Setting log_slow_admin="" at startup should be converted to log_slow_admin=ALL

  • (MDEV-34406) Enhance mariadb_upgrade to print failing query in case of error

  • (MDEV-34494) Add server_uid global variable and add it to error log at startup

Issues Fixed

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

  • (MDEV-32155) MariaDB Server crashes with ill-formed partitions

  • (MDEV-34226) On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations

  • (MDEV-34187) 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-32376) SHOW CREATE DATABASE statement crashes the server when db name contains some Unicode characters, ASAN stack-buffer-overflow

  • (MDEV-34227) On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc

  • (MDEV-31475) UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT

  • (MDEV-32487) SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]'

  • (MDEV-34222) Alter operation on redundant table aborts the server

  • (MDEV-30651) Crash after killing query while it is processed by test_quick_select

  • (MDEV-19520) Extend condition normalization to include 'NOT a'

  • (MDEV-34543) Shutdown hangs while freeing the asynchronous i/o slots

  • (MDEV-25607) Auto-generated DELETE from HEAP table can break replication

  • (MDEV-33921) 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-29363) Constant subquery causing a crash in pushdown optimization

  • (MDEV-34541) 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-29962) SIGSEGV in ha_spider::lock_tables on BEGIN after table lock

  • (MDEV-32492) SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT, and SELECT

  • (MDEV-34421) SIGSEGV in parse_engine_part_options on INSERT, SELECT, or ALTER

  • (MDEV-27902) Spider: Crashes, asserts, hangs, memory corruptions, and ASAN heap-use-after-free's

  • (MDEV-33010) Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table

  • (MDEV-23857) replication master password length

  • (MDEV-24610) Assertion 'auto_increment_value' failed in ha_partition::info on INSERT into MEMORY table

  • (MDEV-28105) Spider: @@insert_id 128 to TINYINT: Assertion '!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.

  • (MDEV-22935) Erroneous Aria Index / Optimizer behavior

  • (MDEV-34417) Wrong result set with utf8mb4_danish_ci and BNLH join

  • (MDEV-34434) Hide password passed on command-line from xtrabackup_info

  • (MDEV-33265) unknown variable 'defaults-group-suffix= with mariadb-secure-installation

  • (MDEV-34506) 2nd execution name resolution problem with pushdown into unions

  • (MENT-2122) Backport MDEV-33465 to 10.5 ES

  • (MDEV-34170) table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0

  • (MDEV-32158) wsrep_sst_mariabackup use /tmp dir during SST rather then user defined tmpdir

  • (MDEV-12008) Change error code for Galera unkillable threads

  • (MDEV-24411) Trigger doesn't work correctly with bulk insert

  • (MDEV-32633) galera_gtid_2_cluster: Assertion 'thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'

  • (MENT-2127) Cherry-pick fix for MDEV-34683

  • (MENT-2125) Cherry-Pick MDEV-34043 Drastically slower query performance between CentOS (2sec) and Rocky (48sec)

  • (MDEV-34474) InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound

  • (MDEV-34632) 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*)

  • (MENT-2120) MSAN reports use-of-uninitialized-value on binlog_encryption.encrypted_master

  • (MENT-2131) Backport JSON_SCHEMA_VALID() bugs that were left.

  • (MDEV-34568) rpl.rpl_mdev12179 windows fix "File already exists"

  • (MDEV-34203) Sandbox mode - is not compatible with --binary-mode

  • (MDEV-34269) 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning

  • (MDEV-34129) mariadb-install-db appears to hang on macOS

  • (MDEV-34266) safe_strcpy() includes an unnecessary conditional branch

  • (MDEV-34580) Assertion '(key_part->key_part_flag & 4) == 0' failed key_hashnr

  • (MDEV-32782) galera_sst_mysqldump_with_key test failed

  • (MDEV-31566) Fix buffer overrun in dynstr_append_json_quote

  • (MDEV-33952) galera.galera_create_table_as_select fails sporadically

  • (MENT-2073) Backport MDEV-33609 to MariaDB Enterprise

  • (MDEV-34099) AddressSanitizer running out of memory regardless of stack_thread size

  • (MDEV-32456) incorrect result of GIS function in view protocol

  • (MDEV-34546) No error log entries after startup in XAMPP

  • (MDEV-30408) Spider test using semijoin=off returns wrong result (zero rows)

  • (MDEV-32424) Pushdown: server crashes at JOIN::save_explain_data()

  • (MDEV-32304) Pushdown: server crashes at Item_field::used_tables()

  • (MDEV-32293) Pushdown: server crashes at check_simple_equality()

  • (MDEV-31151) Inaccurate stack size calculation caused stack overflow in pinbox allocator

  • (MDEV-34519) innodb_log_checkpoint_now crashes when innodb_read_only is enabled

  • (MDEV-34181) Instant table aborts after discard tablespace

  • (MDEV-29010) Table cannot be loaded after instant ALTER, errors, or assertion failure

  • (MDEV-34305) Redundant truncation errors/warnings with optimizer_trace enabled

  • (MDEV-15393) gtid_slave_pos duplicate key errors after mysqldump restore

  • (MDEV-21538) galera_desync_overlapped MTR failed: Result content mismatch

  • (MENT-1522) galera_nbo_local_mdl fails on FreeBSD with timeout

  • (MDEV-34634) Types mismatch when cloning items causes debug assertion

  • (MDEV-34449) spider/bugfix.mdev_28683 failing the valgrind build

  • (MDEV-34318) mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server

  • (MDEV-28345) ASAN: use-after-poison or unknown-crash in my_strtod_int from charset_info_st::strntod or test_if_number

  • (MDEV-34604) mytop - fix specifying filters in .mytop

  • (MDEV-21166) Creating and running a mroonga function causes various crashes, UBSAN member call on null pointer, UBSAN access within null pointer

  • (MDEV-32892) IO Thread Reports False Error When Stopped During Connecting to Primary

  • (MDEV-30027) [Draft] rpl.rpl_semi_sync_shutdown_await_ack fails when --mysqld=--debug is set

  • (MDEV-19052) Range-type window frame supports only numeric datatype

  • (MDEV-32608) Expression with constant subquery causes a crash in pushdown from HAVING

  • (MDEV-32738) Inconsistency in Galera cluster while running add drop column

  • (MDEV-34477) galera.galera_gcache_recover_manytrx sporadic test failures

  • (MDEV-34510) UBSAN: crc32 x86 - integer overflow

  • (MDEV-34490) get_copy() and build_clone() may return an instance of a ancestor class instead of a copy/clone

  • (MDEV-34041) Additional information for materialized subqueries must be displayed in EXPLAIN/ANALYZE FORMAT=JSON

  • (MDEV-34539) Invalid "use" and "Schema" in slow query log file with multi-line schema

  • (MDEV-34530) dead code in the thr_rwlock.c

  • (MDEV-34384) restorecon call in RPM POSTIN script has hard-coded datadir path

  • (MDEV-34542) Assertion 'lock_trx_has_sys_table_locks(trx) == __null' failed in void row_mysql_unfreeze_data_dictionary(trx_t*)

  • (MDEV-34372) Starting MariaDB failed with illegal instruction in WolfSSL

  • (MENT-1504) Spider and Spider/ODBC: Fix some minor English grammar typo's

  • (MDEV-34143) Server crashes when executing JSON_EXTRACT after setting non-default collation_connection

  • (MDEV-34166) Server could hang with BP < 80M under stress

  • (MDEV-27186) Assertion '!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())' failed in Diagnostics_area::set_eof_status when using spider partitioning, and Assertion '! is_set()' failed in Diagnostics_area::set_eof_status

  • (MDEV-30931) UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in get_interval_value on SELECT

  • (MDEV-34397) "delete si" rather than "my_free(si)" in THD::register_slave()

  • (MDEV-33119) User is case insensitive in INFORMATION_SCHEMA.VIEWS

  • (MDEV-33120) System log table names are case insensitive with lower-cast-table-names=0

  • (MDEV-33110) HANDLER commands are case insensitive with lower-case-table-names=0

  • (MDEV-33108) TABLE_STATISTICS and INDEX_STATISTICS are case insensitive with lower-case-table-names=0

  • (MDEV-33109) DROP DATABASE MYSQL -- does not drop SP with lower-case-table-names=0

  • (MDEV-33088) Cannot create triggers in the database MYSQL

  • (MDEV-33086) SHOW OPEN TABLES IN DB1 -- is case insensitive with lower-case-table-names=0

  • (MDEV-33084) LASTVAL(t1) and LASTVAL(T1) do not work well with lower-case-table-names=0

  • (MDEV-33085) Tables T1 and t1 do not work well with ENGINE=CSV and lower-case-table-names=0

  • (MDEV-29307) Wrong result when joining two derived tables over the same view

  • (MDEV-34057) Inconsistent FTS state in concurrent scenarios

  • (MDEV-34381) During innodb_undo_truncate=ON recovery, InnoDB may fail to shrink undo* files

  • (MDEV-34404) Spider: UBSAN: runtime error: null pointer passed as argument 2, which is declared to never be null in spider_create_string on SELECT

  • (MDEV-33103) LOCK TABLE t1 AS t2 -- alias is not case sensitive with lower-case-table-names=0

  • (MDEV-32583) UUID() should be treated as stochastic for the purposes of forcing query materialization

  • (MDEV-20548) Unexpected error on CREATE..SELECT HEX(num)

  • (MDEV-34053) privilege REPLICA MONITOR issue

  • (MDEV-33523) Spurious deadlock error when wsrep_on=OFF

  • (MDEV-20053) galera_recovery: Wrong @sbindir@

  • (MDEV-7111) Unable to detect network timeout in 10.x when using SSL (regression from 5.5)

  • (MDEV-34313) WITHOUT_SERVER cannot compile mariadb-binlog

  • (MDEV-28162) clang compiler emits atomic library calls on x86/32bit

  • (MDEV-34437) SIGSEGV in vio_get_normalized_ip when using extra-port

  • (MDEV-34502) InnoDB Debug build under valgrind errors on assertions

  • (MDEV-33746) macOS virtual override markings missing

  • (MDEV-34205) ASAN stack-buffer-overflow in strxnmov | frm_file_exists

  • (MDEV-33490) Syntax errors in Spider error messages

  • (MDEV-34361) wait for slave timeout when running mtr --reorder spider.connection_override spider.slave_trx_isolation

  • (MDEV-34204) Assertion '!*detailed_error' failed in void trx_t::assert_freed() const

  • (MDEV-33161) Function pointer signature mismatch in LF_HASH

  • (MDEV-34321) UBSAN runtime error: call to function crc32c_3way through pointer to incorrect function type

  • (MDEV-34389) Don't write FILE_CHECKPOINT during early recovery when InnoDB log file in insufficient

  • (MDEV-34435) Increase code coverage for debug_dbug test case during startup

  • (MDEV-33574) mysqlbinlog -R not working

  • (MDEV-34237) On Startup: UBSAN: runtime error: call to function MDL_lock::lf_hash_initializer lf_hash_insert through pointer to incorrect function type 'void (*)(st_lf_hash *, void *, const void *)'

  • (MDEV-34365) UBSAN runtime error: call to function io_callback(tpool::aiocb*)

  • (MDEV-33078) SysInfo.pm reports incorrect CPU count on macOS

  • (MDEV-33919) Remonve an-trap from man pages

  • (MDEV-34175) mtr_t::log_close() warning should change the shutdown condition

  • (MDEV-34221) Errors about checksum mismatch on crash recovery are confusing

  • (MDEV-34169) Don't allow innodb_open_files to be lesser than number of non-user tablespace.

  • (MDEV-34236) Mroonga build will hang during MariaDB build when using GCC 12

  • (MDEV-34295) CAST(char_col AS DOUBLE) prints redundant spaces in a warning

  • (MDEV-27966) Assertion 'fixed()' failed and Assertion 'fixed ==  1' failed, both in Item_func_concat::val_str on SELECT after INSERT with collation utf32_bin on utf8_bin table

  • (MDEV-34297) get_rnd_value() of ib_counter_t is unnecessarily complex

  • (MDEV-34443) ha_innobase::info_low() does not distinguish HA_STATUS_VARIABLE_EXTRA

  • (MDEV-34670) IMPORT TABLESPACE unnecessarily traverses tablespaces list

  • (MDEV-33875) ORDER BY DESC causes ROWID Filter optimization performance degradation