The Ultimate Guide to High Availability with MariaDB

Changelog for MariaDB Enterprise Server 10.5.26-20

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-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-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
  • (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-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-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-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-33523) Spurious deadlock error when wsrep_on=OFF
  • (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-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-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

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
Back to Top