MariaDB Enterprise Server 10.4.31-21 is a maintenance release of . This release includes a variety of fixes.
MariaDB Enterprise Server 10.4.31-21 was released on 2023-09-11.
has been backported. (MENT-1853)
The JSON_OVERLAPS() function can be used to compare two JSON documents to determine if they have any key-value pairs or array elements in common.
has been backported. (MENT-1796)
The JSON_SCHEMA_VALID() function can be used to validate a JSON document against a JSON schema, as documented by the .
This function can also be used in a CHECK constraint to verify that JSON documents are only stored in the database if they include required items and that the values are within a given range and length.
The package for the cracklib_password_check plugin includes an SELinux policy, allowing the plugin to work with SELinux. ()
With Optimizer Trace, a sel_arg_alloc_limit_hit record is written when MAX_SEL_ARGS is reached. ()
MAX_SEL_ARGS
ANALYZE FORMAT=JSON output includes InnoDB statistics. ()
For example:
Slow query log output includes InnoDB engine information. ()
InnoDB engine information output is enabled with --log-slow-verbosity=innodb
Sample output:
Engine_time is the time in milliseconds spent inside engine calls.
Page_* variables are supported for the InnoDB storage engine.
For the Spider storage engine, the default values and behavior of some system variables have changed: ()
With parallel replication, in some rare cases, when the sequence of FLUSH TABLE WITH READ LOCKS, UNLOCK TABLES, and STOP REPLICA is executed, data can be lost on the replica. ()
With the Aria storage engine, when Aria encryption is enabled and used, but an encryption plugin is not loaded, the server can crash. ()
With Galera Cluster, when wsrep_sst_donor and wsrep_cluster_address are set to NULL rather than an empty string, the server can crash. ()
When optimizer_switch='optimize_join_buffer_size=off' is set, the server can crash. (
For a System Versioned table with non-versioned columns, if the initial INSERT includes a versioned column, an "on duplicate key update" for the non-versioned column generates a history record. ()
With the Spider storage engine, setting a system variable overrides the value set as a table parameter. ()
The "pam_user_map" module does not correctly handle usernames or group names containing the "@" character. ()
With partitioning, possible slow down of queries. ()
system variable maximum value changed from 18446744073709551615 to 1152921504606846975 ()
system variable minimum value changed from 4096 to 16376 ()
error code added (MENT-1796)
system variable default value changed from -1 to 0 ()
system variable default value changed from -1 to 2 ()
system variable default value changed from -1
In alignment with the , MariaDB Enterprise Server 10.4.31-21 is provided for:
CentOS 7 (x86_64)
Debian 10 (x86_64, ARM64)
Microsoft Windows (x86_64) (MariaDB Enterprise Cluster excluded)
Red Hat Enterprise Linux 7 (x86_64)
Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see
WHEREFor example:
These variables used a value of -1 (the default) to indicate that Spider would use the default table value, and this value was not user visible.
Spider table parameters could set values, but these values would be overridden with the system variable value if the system variable was set to a value other than -1.
Starting with this release:
The default value for these system variables has been updated to reflect the actual default table value, rather than -1.
Where a value is set by a table parameter, this value overrides the system default and the value set by the Spider system variable.
If a table parameter is not set, the Spider system variable's value is used. This behavior is unchanged.
See "Interface Changes" for a full list of updated default values.
When executing a SELECT query using an index for GROUP BY and filesort, the server can crash. (MDEV-30143)
With MariaDB Connector/C, when the mysql_list_fields() function is called against a view, the server can crash. (MDEV-30159)
With the Aria storage engine, changing aria_sort_buffer_size settings to huge numbers and executing INSERT/UPDATE can result in a crash. (MDEV-28054)
With parallel replication, when a replica thread gets killed, the replica node can crash. (MDEV-31448)
With the InnoDB storage engine, when slave_parallel_mode is optimistic, and slave_parallel_threads is greater than 0, an ALTER SEQUENCE can fail with an out-of-order binlog error if the SEQUENCE uses InnoDB. (MDEV-31503)
Prior to this release, the following error can be raised:
Last_Error: Error 'An attempt was made to binlog GTID 0-1-100, which would create an out-of-order sequence number with existing GTID 0-1-100 and gtid stric mode is enabled' on query. Default database: 'test'. Query: 'alter sequence s1 restart with 1' will be shown.``
With replication, when gtid_seq_no is set to DEFAULT in a session, the server can crash. (MDEV-31723)
With the InnoDB storage engine, when a BINARY(0) or VARBINARY(0) column in an InnoDB table is indexed, the server can crash. (MDEV-19216)
Setting session_track_system_variables globally to an invalid value can cause the server to crash. (MDEV-25237)
Replication from an older MariaDB Server version to a newer MariaDB Server version can break, and the server may crash. (MENT-1935)
A mismatch in hash values was caused by the use of different hash functions, causing rows in tables having explicit or implicit unique hash indexes to be treated as different rows between different versions of MariaDB Server, even though the data in the rows was the same.
Stored routines with ROW variables set by subselects can produce incorrect results. (MDEV-31250)
Integer multiplication, DIV, MOD, or ROUND/TRUNCATE could return unexpected results when an argument is evaluated as -9223372036854775808 (MDEV-30932)
With Galera Cluster, creating a TEMPORARY SEQUENCE can cause inconsistency. (MDEV-31335)
With Galera Cluster, the state of the cluster can only be retrieved from the primary component. (MDEV-21479)
information_schema.PARAMETERS can include outdated data when a stored routine is changed in one session while the stored routine is being used in a second session. (MDEV-31064)
Queries that use multiple RANK window functions can produce the wrong result. (MDEV-20010)
Queries that use the < "less than" operator to compare a string with a prefixed BLOB key produce the wrong result. (MDEV-31800)
Recursive CTE execution is interrupted without errors or warnings when max_recursive_iterations is reached. (MDEV-31214)
Starting with this release, a warning occurs when max_recursive_iterations is reached: Warning 1931 Query execution was interrupted. The query exceeded max_recursive_iterations = 1000. The query result may be incomplete.
On Microsoft Windows, when lower_case_table_names=2, SHOW TABLES does not work properly. (MDEV-30765)
When the system is busy, STOP REPLICA can take a long time. (MDEV-13915)
With parallel replication, Seconds_Behind_Master can show a wrong value. (MDEV-30619)
With replication for System Versioned tables, having a parent table and a child table WITH SYSTEM VERSIONING, where the child table has a Foreign Key CASCADE, generates orphan rows on the replica. (MDEV-31313)
mariadb-dump --force can stop with the error Couldn't execute 'SHOW CREATE FUNCTION object': even though --force should cause the error to be ignored. (MDEV-31092)
With the ColumnStore storage engine and Federated storage engine, ANALYZE can return the incorrect value 0 for r_rows (MDEV-29284)
ALTER TABLE .. MODIFY COLUMN can break foreign key constraints and lead to unrestorable dumps. (MDEV-31086)
With the InnoDB storage engine, three concurrent DELETE by a UNIQUE key can cause an unexpected deadlock. (MDEV-10962)
With the InnoDB storage engine, innochecksum fails with a Floating point exception error. (MDEV-31641)
With the HashiCorp key management plugin, possible memory leaks. (MENT-1874)
Using functions MAX() or MIN() with functions ROUND(time), CEILING(time), or FLOOR(time) as an argument can return wrong results. (MDEV-23838)
For transaction precise System Versioned tables, UPDATE can return an unexpected error: ERROR 1761 (23000): Foreign key constraint for table 'xxx', record 'yyy' would lead to a duplicate entry in table 'xxx', key 'PRIMARY' (MDEV-25644)
Assertion const_item_cache == true failed in Item_func::fix_fields when a flow control statement (such as IF()) was used in a generated column. (MDEV-31319)
Creating a table with a foreign key (with a cascade action) defined on a base column of a virtual column is not rejected. (MDEV-18114, MDEV-31322)
Starting with this release, it is no longer possible to create STORED generated columns and CHECK constraints when values of the affected columns can be changed by foreign key constraint actions, such as SET NULL or ON UPDATE CASCADE.
Starting with this release, this results in an error like: ERROR 1901 (HY000): Function or expression 'f_id' cannot be used in the GENERATED ALWAYS AS clause of 'v_id'
Starting with this release, for existing tables with STORED generated columns, SET NULL and ON UPDATE CASCADE are ignored.
error code added (MENT-1796)
error code removed (MDEV-31214)
error code added (MDEV-31214)
ER_QUERY_TIMEOUT error code removed
ER_UNUSED_1 error code added
function added (MENT-1853)
function added (MENT-1796)
system variable maximum value changed from 18446744073709551615 to 1152921504606846975 (MDEV-28054)
0 system variable default value changed from -1 to 100 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 16000 (MDEV-31524)
system variable default value changed from -1 to 16000 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 16000 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 6 (MDEV-31524)
system variable default value changed from -1 to 2 (MDEV-31524)
system variable default value changed from -1 to 51 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 2 (MDEV-31524)
system variable default value changed from -1 to 2 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 9223372036854775807 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 1024 (MDEV-31524)
system variable default value changed from -1 to 9223372036854775807 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 32767 (MDEV-31524)
system variable default value changed from -1 to 100 (MDEV-31524)
system variable default value changed from -1 to 600 (MDEV-31524)
system variable default value changed from -1 to 600 (MDEV-31524)
system variable default value changed from -1 to 3 (MDEV-31524)
system variable default value changed from -1 to 10485760(MDEV-31524)
system variable default value changed from -1 to 1024 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 2 (MDEV-31524)
system variable default value changed from -1 to 9223372036854775807 (MDEV-31524)
system variable default value changed from 1 to 0 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 9223372036854775807 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 2 (MDEV-31524)
system variable default value changed from -1 to 10 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 10 (MDEV-31524)
system variable default value changed from -1 to 100 (MDEV-31524)
system variable default value changed from -1 to 3000 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 0 (MDEV-31524)
system variable default value changed from -1 to 1 (MDEV-31524)
Rocky Linux 8 (x86_64, ARM64 Red Hat Enterprise Linux 8 packages)
SUSE Linux Enterprise Server 12 (x86_64)
SUSE Linux Enterprise Server 15 (x86_64, ARM64)
Ubuntu 20.04 (x86_64, ARM64)
SELECT JSON_OVERLAPS('{"A": 1, "B": {"C":2}}', '{"A": 2, "B": {"C":2}}') AS is_overlap;+---------------------+
| is_overlap |
+---------------------+
| 1 |
+---------------------+SELECT
JSON_DETAILED(JSON_EXTRACT(trace, '$**.setup_range_conditions'))
FROM information_schema.OPTIMIZER_TRACE;[
[
{
"sel_arg_alloc_limit_hit":
{
"alloced_sel_args": 16001
}
}
]
]table": {
"table_name": "t1",
...
"r_engine_stats": {
"pages_accessed": integer,
"pages_updated" : integer,
"pages_read_count" : integer,
"pages_read_time_ms" : double_val,
"old_rows_read" : integer,
},# Pages_accessed: 184 Pages_read: 95 Pages_updated: 0 Undo_rows_read: 1\\
# Pages_read_time: 17.0204 Engine_time: 248.1297
This page is: Copyright © 2025 MariaDB. All rights reserved.