Changelog for MariaDB Enterprise Server 10.6.19-15

MariaDB Enterprise Server 10.6.19-15 is a maintenance release of MariaDB Enterprise Server 10.6. For the categorized highlights and other details of this release, see the release notes.

MariaDB Enterprise Server 10.6.19-15 was released on 2024-09-09.

Changes

• (MENT-1304) No Method to Shrink ibdata1

• (MENT-2031) Backport MDEV-30879 - Add conversion to based 62 for CONV function

• (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()

• (MENT-2092) Backport Improvements/Bug fixes from MariaDB Backup of 10.11

• (MDEV-33650) Q2 2024 release merge

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

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

• (MDEV-34223) Innodb - add status variable for number of bulk inserts

Issues Fixed

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

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

• (MDEV-34357) InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211

• (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-34167) We fail to terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing

• (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-29027) ASAN errors in spider_db_free_result after partition DDL

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

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

• (MDEV-34475) Disable new connections in case of fatal signal

• (MDEV-34473) Enhanced network logging information shown as error instead of warning

• (MDEV-34458) wait_for_read in buf_page_get_low hurts performance

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

• (MDEV-33465) an option to enable semi-sync recovery

• (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)'

• (MDEV-31658) Deadlock found when trying to get lock during applying

• (MENT-2126) Cherry-Pick MDEV-34759 buf_page_get_low() is unnecessarily acquiring exclusive latch on secondary index pages

• (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-1967) Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log FIRST, end_log_pos xxx, Internal MariaDB error code: 1213

• (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

• (MENT-2121) Backport MDEV-34200 from 10.11 to 10.6-enterprise

• (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-30623) JSON_TABLE in subquery not correctly marked as correlated

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

• (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-34190) ANALYZE: r_engine_stats shows unrealistically low pages_read_count

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

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

• (MDEV-34625) MariaDB server crashes in 10.11.8 due to using uninitialized member variables

• (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-34505) galera.mariadb_tzinfo_to_sql fails deterministically on Ubuntu 24.04

• (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-34664) InnoDB's doubling of rec_per_key estimates causes poor query plans

• (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-34066) Output of SHOW ENGINE INNODB STATUS uses the nanoseconds suffix for microseconds

• (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-28800) SIGABRT due to running out of memory for InnoDB locks

• (MDEV-34265) Possible hang during IO burst with innodb_flush_sync enabled

• (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-33064) ALTER INPLACE running TOI doesn't abort a DML operation in InnoDB

• (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-34283) A misplaced btr_cur_need_opposite_intention() check may fail to prevent hangs

• (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-34014) mysql_upgrade failed

• (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-34428) main.winservice_basic fails with [Warning] Could not remove temporary table: '<path>', error: 2

• (MDEV-34108) Inappropriate semi-consistent read in RC if innodb_snapshot_isolation=ON

• (MDEV-33935) Innodb_deadlocks status variable counts wrong

• (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-34125) ANALYZE FORMAT=JSON: r_engine_stats.pages_read_time_ms has wrong scale

• (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-9159) assert() in semisync.master.cc

• (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-34307) Recovery or mariadb-backup --prepare debug failure [FATAL] InnoDB: Page ... still fixed or dirty

• (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-34355) rpl.rpl_semi_sync_no_missed_ack_after_add_slave "server_3 should have sent..."

• (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-34360) Columnstore should not be build on 32 bit systems

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

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

• (MDEV-33602) rpl.rpl_gtid_stop_start At line 187: sync_with_master failed: 'select master_pos_wait('master-bin.000005', 1186, 300, '')' returned NULL indicating slave SQL thread

• (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-32176) Contention in ha_innobase::info_low (dict_table::lock_mutex_lock)

• (MDEV-34296) extern thread_local is a CPU waste

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

• (MDEV-34178) Performance regression with IO-bound insert benchmark

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

• (MDEV-34311) ALTER USER should reset password errors counters

• (MDEV-33971) 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-34670) IMPORT TABLESPACE unnecessarily traverses tablespaces list

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