Search Results
https://dev.mysql.com/doc/refman/9.7/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-remote.html
An error is returned if the explicit specification cannot be satisfied. An error is reported if a table or tablespace already exists. An error is reported if duplicate undo tablespace file names are encountered during a cloning operation. Otherwise, ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
If binary logging is enabled and binlog_format is set to STATEMENT, the statement is logged and executed but a warning message is written to the error log, because replicas might diverge. For nontransactional tables, an error occurs, but if this ...
https://dev.mysql.com/doc/refman/9.7/en/dbug-package.html
In MySQL, common debug macro keywords to enable are enter, exit, error, warning, info, and loop. The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for ...
https://dev.mysql.com/doc/refman/9.7/en/handler-scope.html
A specific handler is for a MySQL error code, SQLSTATE value, or condition name. For example, there might be a specific MySQL error code handler in an outer block, and a general SQLWARNING handler in an inner block. Or there might be handlers for a ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-troubleshooting-datadict.html
Cannot Open Datafile With innodb_file_per_table enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd file) is missing: [ERROR] InnoDB: Operating system error number 2 in a file operation.
https://dev.mysql.com/doc/refman/9.7/en/myisam-start.html
If either of these conditions is true, the following happens: The server checks the table for errors. If the server finds an error, it tries to do a fast table repair (with sorting and without re-creating the data file). If the repair fails because ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-move-data.html
--abort-on-error Command-Line Format --abort-on-error Dump core on permanent error (debug option). --core-file Command-Line Format --core-file Write core file on error; used in debugging. --staging-tries=x[,y[,z]] Command-Line Format ...Usage The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-issues.html
Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error message. Note The NDB storage engine uses ...