Release Notes for MariaDB Enterprise Server 10.2.38-12

This twelfth release of MariaDB Enterprise Server 10.2 is a maintenance release. This release includes a variety of fixes.

MariaDB Enterprise Server 10.2.38-12 was released on 2021-06-14.

Fixed Security Vulnerabilities

Notable Changes

• New function ST_DISTANCE_SPHERE() calculates the spherical distance between two geometries (point or multipoint) on a sphere. (MDEV-13467)

• Galera updated to 25.3.3

Issues Fixed

Can result in data loss

• ALTER TABLE fails to rename a column in InnoDB table and causes server to crash. InnoDB table is not accessible after restart. (MDEV-24763)

• Table corruption ER_NO_SUCH_TABLE_IN_ENGINE or ER_CRASHED_ON_USAGE after ALTER on InnoDB table with foreign key. (MDEV-24532)

• MariaDB Enterprise Backup deletes the current source file after a No space left on device error, before exiting. Only the incomplete target file is still available. (MDEV-25221)

Can result in a hang or crash

• Possible hang when KILL CONNECTION or KILL QUERY is used with MariaDB Enterprise Cluster and a multi-master setup. (MDEV-18874)

• Possible memory corruption with MariaDB Enterprise Cluster when inserting values bigger than 4096 bytes into variable-length fields (BLOB, TEXT, VARCHAR, and related types). (MDEV-24978)

• innodb_flush_method=O_DIRECT fails on compressed tables. (MDEV-25121)

• Server crashes in check_grant upon invoking function with userstat enabled. (MDEV-25242)

• MariaDB Client crashes when --default-character-set is set and --character-sets-dir is undefined. (MDEV-24879)

• Possible Server crash when dropping a table. Only seen when using a table space per table and if the tablespace size is increased at the time of the drop. (MDEV-20648)

• Possible server hang with InnoDB and indexed virtual columns after an error with UPDATE, INSERT, REPLACE on virtual columns. (MDEV-24786)

• MariaDB Enterprise Cluster conflict resolution issues. (MDEV-24923)

• Index count mismatch due to aborted FULLTEXT INDEX (MDEV-25200)

• MariaDB Enterprise Cluster node crashes when inserting a row into a table that contains a virtual column and does not have a primary key. (MDEV-25047)

• Server crashes when InnoDB fails to add a new index on a new virtual column and a concurrent connection executes a query that accesses the freed virtual column. (MDEV-24971)

• EXISTS subquery with correlation in ON expression crashes. (MDEV-25407)

• Server crashes in row_undo_mod_clust_low upon rollback of read-only transaction. (MDEV-25457)

• Server crashes on the second execution of a stored procedure when the stored procedure uses an invalid multi-table UPDATE statement to update a view. (MDEV-24823)

• InnoDB startup hangs when a recovered transaction exists for the mysql.innodb_index_stats or mysql.innodb_table_stats system tables and a DDL transaction needs to be rolled back. (MDEV-25503)

• Server crashes when InnoDB tries to fetch data from table containing a FULLTEXT INDEX and the table's tablespace was discarded. (MDEV-25536)

• Server crashes on SHOW TABLES when a WHERE condition references a derived table. (MDEV-21603)

• Potential hang in InnoDB purge when virtual indexed columns exist. (MENT-1203)

• After DROP INDEX or CREATE INDEX, change buffer entries for secondary indexes are lost on InnoDB restart. (MENT-1217)

Can result in unexpected behavior

• SUM column from a derived table returns invalid values. (MDEV-23291)

• CAST('0e1111111111' AS DECIMAL(38,0)) returns an incorrect result. (MDEV-24790)

• Incorrect behavior of SET STATEMENT when it is executed as a prepared statement. (MDEV-24860)

• Query returns a ER_BAD_FIELD_ERROR error when a subquery contains a JOIN with an ON clause that references an outer column. (MDEV-25002)

• Query returns a ER_BAD_FIELD_ERROR error when a Common Table Expression (CTE) contains a UNION (MDEV-24597)

• Query returns wrong result when the MIN() or MAX() aggregate functions are used and the aggregated column is indexed. (MDEV-25112)

• Wrong result (extra rows and wrong values) with incremental block nested loop hash. (MDEV-21104)

• Query returns wrong results when a JOIN is evaluated using the Block Nested Loop Hash (BLNH) optimization with a compound index. (MDEV-24767)

• Server fails to start using mysqld_multi with mysqld_safe options. (MDEV-21039)

• Duplicate key may be generated during MariaDB Enterprise Cluster configuration change. (MDEV-24853)

• State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Backup fails when the --log-bin option was set on the command-line with no value at server startup. (MDEV-24903)

• Race condition between persistent statistics and RENAME TABLE or TRUNCATE (MDEV-25051)

• Race condition between ANALYZE TABLE and STATS_AUTO_RECALC (MDEV-10682)

• Incorrect message about field length is written to the error log when CHECK TABLE is executed on an InnoDB table. (MDEV-24748)

• No error is returned when the optimizer removes a redundant part of a subquery that contains an unknown table alias. For example, if the optimizer removes a redundant GROUP BY clause from an IN() subquery, unknown table aliases in the redundant part are ignored. (MDEV-23449)

• Selectivity shown with EXPLAIN in field "filter" is incorrect for BIT columns. (MDEV-22583)

• Histogram statistics are used even with optimizer_use_condition_selectivity=3 (MDEV-19474)

• EXPLAIN shows nonsensical value for key_len with type=index (MDEV-11172)

• SSL connection fails when server and client certs are signed by same CA. (MDEV-23740)

• Wrong function name in error messages upon ST_GeomFromGeoJSON call. (MDEV-25272)

• MariaDB Enterprise Backup fails --prepare on large backup. (MDEV-24197)

• State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Server fails when the password for the backup user is set via the MYSQL_PWD environment variable. (MDEV-25321)

• State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Backup fails when the --innodb option was set on the command-line at server startup. (MDEV-25328)

• An extra warning is returned when the EXPLAIN EXTENDED statement is executed in a prepared statement. (MDEV-25108)

• Complex query in stored procedure returns wrong results. (MDEV-25182)

• ALTER TABLE wrongly checks for field's default value if AFTER is used. (MDEV-25403)

• Incorrect name resolution for subqueries in ON expressions. (MDEV-25362)

• When FLUSH LOGS is executed, a race condition between InnoDB group commit and binary log rotation causes the old binary log file to become obsolete before the InnoDB group commit has been written to it. (MDEV-24526)

• MariaDB Enterprise Backup logs an error instead of a warning when it reads an invalid log block checksum during a --backup. (MDEV-25456)

• Rows are wrongly omitted when an InnoDB index is read using Multiversion Concurrency Control (MVCC). (MDEV-25459)

• SELECT aborts after failed REPLACE into table with virtual column. (MDEV-24583)

• InnoDB fails to fetch index type when index mismatch happens. (MDEV-22928)

• MariaDB Enterprise Cluster silently enables InnoDB Monitor output and never disables it when a wsrep slave thread tries to perform a brute-force (BF) kill, but fails due to a long lock wait. (MDEV-25319)

• RENAME TABLE causes
  "Ignoring data file ... with space ID xxxx, since the redo log references ... with space ID xxxx." for MariaDB Enterprise Backup. (MDEV-25568)

• The Replication Heartbeat binary log event (Heartbeat_log_event) uses 4 bytes to store the log position within the current binary log file, so the log position overflows when the binary log file size exceeds 4 GB. (MDEV-16146)

• InnoDB spatial indexes miss large geometry fields. (MENT-1205)

• Table alias from previous statement interferes with later commands. (MENT-1200)

• MariaDB Enterprise Cluster fails to replicate SET PASSWORD statement when strict_password_validation is enabled. (MDEV-25258)

Related to install and upgrade

• Missing libsepol dependency on SLES 12 and SLES 15. (MENT-1163)

• caching_sha2_password.so isn't included in Debian packages. (MDEV-24728)

• Minor version upgrade does not perform server restart. (MDEV-25240)

Interface Changes

• mariabackup --innodb-force-recovery command-line option added

• mariadb_repo_setup --skip-check-installed command-line option added

• ST_DISTANCE_SPHERE function added

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.2.38-12 is provided for:

• CentOS 7

• CentOS 8

• Debian 9

• Red Hat Enterprise Linux 7

• Red Hat Enterprise Linux 8

• SUSE Linux Enterprise Server 12

• SUSE Linux Enterprise Server 15

• Ubuntu 18.04

• Microsoft Windows

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "MariaDB Corporation Engineering Policies".