Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-skip.html
First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. You can use mysqlbinlog to ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
If any of the transactions that should be sent by the source have been purged from the source's binary log, or added to the set of GTIDs in the gtid_purged system variable by another method, the source sends the error ... GTIDs replace the ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs (Result consisted of more than one row). INTO statements that occur as ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 8.3 server on the same data directory, and fix the cause of any errors. Warning Applying SQL extracted from a previous MySQL release to a new MySQL release may result in errors due ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_webauthn'; +-------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... Note WebAuthn authentication is an ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-restrictions.html
The parser recognizes these window constructs which nevertheless are not supported: The GROUPS frame units specifier is parsed, but produces an error. The EXCLUDE clause for frame specification is parsed, but produces an error. The SQL standard ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
Errors were returned similar to the following: Assertion failure: row0pread.h:306:active >= n_threads (Bug #38325137) Under certain circumstances, a virtual index rollback could fail on 32-bit builds of MySQL Server. Errors were returned similar to ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-osb.html
sbt_error_msg: Error message, when an error occurs while retrieving information for the tape backup. sbt_error_code: Error code, when an error occurs while retrieving information for the tape backup. Tape drives are affordable, high-capacity ...