Aurora MySQL database engine updates 2023-03-01 (version 3.03.0) (Deprecated)

CVE-2022-32221

CVE-2022-21451

CVE-2022-21444

Fixed an issue where larger DB instance classes may experience issues during restart due to the buffer pool initialization taking longer than expected.

Fixed an issue where the DB instance may restart during the database recovery process when binary logging is enabled.

Fixed an issue that can cause connection failures on reader instances while executing Data Control Language (DCL) statements, for example GRANT and REVOKE, or while establishing new connections on the writer instance.

Fixed an issue where parallel query was incorrectly used for Data Manipulation Language (DML) operations, such as the DELETE and UPDATE statements, which aren't currently supported, that led to a DB instance restart. For more information on operations supported in parallel query, see Aurora MySQL parallel query limitations.

Fixed an issue which, in rare cases, can cause Aurora replicas to restart during the simultaneous execution of large update operations or Data Definition Language (DDL) workloads on the writer instance and read operations on the same set of tables on the Aurora replica.

Fixed an issue with the Aurora Serverless v2 reader instance scale down operation that can cause that reader instance to restart, and in some rare cases, cause data inconsistency.

Fixed an issue which can cause the DB instance to restart due to incorrectly accessing an invalid memory location when a connection to the DB instance is closed.

Fixed an issue which, in rare conditions, can cause the DB instance to restart while processing a query with a GROUP BY clause that truncates a decimal column to zero decimal places.

Fixed an issue that can cause a DB instance restart due to incorrectly accessing a record when executing a range query using spatial index.

Fixed an issue that can cause a DB instance restart on Aurora MySQL replica instances when internal temporary tables exceed the default or customer-configured memory or mmap values.

Fixed an issue where the Advanced Audit log rotation may cause memory management issues.

Fast insert isn't enabled in this Aurora MySQL version, due to an issue that can cause inconsistencies when running queries such as INSERT INTO, SELECT, and FROM. For more information on the fast insert optimization, see Amazon Aurora MySQL performance enhancements.

Improved the read query latency of global database write forwarding sessions using the GLOBAL read consistency setting.

Fixed an issue where the wait_timeout parameter value wasn't being honored after a client session executed the reset_connection or change_user commands.

Fixed an issue where applications may experience increased latency while connecting to a DB instance when the instance is experiencing a sudden increase in incoming connections. Two new CloudWatch metrics, AuroraSlowHandshakeCount and AuroraSlowConnectionHandleCount, were introduced to help troubleshoot connection establishment delays for Aurora MySQL DB instances. More information on these metrics can be found in the Aurora CloudWatch metrics definitions documentation, Amazon CloudWatch metrics for Amazon Aurora.

The temptable_use_mmap parameter has been deprecated, and support for it is expected to be removed in a future MySQL release. For more information, see Storage engine for internal (implicit) temporary tables.

Fixed an issue which can cause higher than expected execution times for the SHOW BINARY LOGS statement. This could lead to a drop in the commit throughput of the database.

To perform a minor version upgrade for an Aurora global database from Aurora MySQL version 3.01 or 3.02 to Aurora MySQL version 3.03 or higher, refer to Upgrading Aurora MySQL by modifying the engine version.

Fixed an issue that can cause major version upgrades from Aurora MySQL version 2 to Aurora MySQL version 3 to fail when there are a large number of tables (over 750K) in the cluster.

Fixed an issue that can cause major version upgrades from Aurora MySQL version 2 to Aurora MySQL version 3 to fail because migrating the mysql.innodb_table_stats and mysql.innodb_index_stats tables took longer than expected. This issue mainly affected DB clusters with millions of tables.

Fixed an issue that can cause failures while upgrading from Aurora MySQL version 2 to Aurora MySQL version 3 due to schema inconsistency errors. These errors are reported by the upgrade pre-checker for the mysql.general_log_template and mysql.slow_log_template tables. For more information about upgrade troubleshooting, see Troubleshooting upgrade issues with Aurora MySQL version 3.

Fixed an issue that can cause upgrade failures from Aurora MySQL version 2 to Aurora MySQL version 3 due to the schemaInconsistencyCheck error. This error is caused by schema inconsistencies within the mysql.table_migration_index_info table, as reported by the upgrade-prechecks.log. For more information about troubleshooting upgrades to Aurora MySQL version 3, see Troubleshooting upgrade issues with Aurora MySQL version 3.

Fixed an issue where sorts of some column types, including JSON and TEXT, sometimes exhausted the sort buffer if its size wasn't at least 15 times that of the largest row in the sort. Now the sort buffer need only be 15 times as large as the largest sort key. (Bug #103325, Bug #105532, Bug #32738705, Bug #33501541)

Fixed an issue where InnoDB did't always handle some legal names for table partitions correctly. (Bug #32208630)

Fixed an issue which, in certain conditions, may return incorrect results due to an inaccurate calculation of the nullability property when executing a query with an OR condition. (Bug #34060289)

Fixed an issue which, in certain conditions, may return incorrect results when the following two conditions are met:

(Bug #34060289)

Fixed an issue where incorrect AUTO_INCREMENT values were generated when the maximum integer column value was exceeded. The error was due to the maximum column value not being considered. The previous valid AUTO_INCREMENT value should have been returned in this case, causing a duplicate key error. (Bug #87926, Bug #26906787)

Fixed an issue where it wasn't possible to revoke the DROP privilege on the Performance Schema. (Bug #33578113)

Fixed an issue where a stored procedure containing an IF statement using EXISTS, which acted on one or more tables that were deleted and recreated between executions, didn't execute correctly for the subsequent invocations following the first one. (Bug #32855634).

Fixed an issue where a query that references a view in a subquery and an outer query block can cause an unexpected restart. (Bug#32324234)