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 inha_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_mariadb-backup 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 invoid 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

Last updated 1 month ago

Was this helpful?