Embedded Files
ERROR 3 (HY000) at line x: Error writing file '...'
ERROR 3 (HY000) at line x: Error writing file '...'
ERROR 3 (HY000) at line 1: Error writing file '/tmp/myfile.txt' (Errcode: 28 - No space left on device)
See OS Error Code 28
ERROR 1086 (HY000): File '...' already exists.
ERROR 1086 (HY000): File '...' already exists.
This error will be raised when you attempt to SELECT ... INTO OUTFILE where the target file already exists.
Database to Text
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
This error will be raised when you attempt to SELECT ... INTO OUTFILE where the target file is outside the location specified by the secure_file_priv parameter.
Check the correct location with...
SELECT @@secure_file_priv;
ERROR 1418 (HY000): This function has none of DETERMINISTI...
ERROR 1418 (HY000): This function has none of DETERMINISTI...
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
The real fix here is to make sure your function explicitly specifies that it is DETERMINISTIC, NO SQL or READS SQL DATA.
log_bin_trust_function_creators has been deprecated in MySQL 8.0 as it is exclusively used for statement-based binary logging which is also deprecated. In future, row-based binary logging will be the only binary logging format used or supported.
Having digested the guidance above, if you still want to set the log_bin_trust_function_creators variable to work around some incorrectly defined DDL (e.g. perhaps it was 3rd party vendor supplied)...
SET GLOBAL log_bin_trust_function_creators=true;
https://dba.stackexchange.com/questions/108316/use-of-log-bin-trust-function-creators-in-mysqlhttps://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html#sysvar_log_bin_trust_function_creatorshttps://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.htmlhttps://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.htmlhttps://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded
ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded
ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded
The mysql_native_password authentication plugin is deprecated and subject to removal in a future version of MySQL.
Possible workarounds...
Start MySQL with --mysql-native-password=ON
[ERROR] Slave I/O for channel '': error connecting to master...
[ERROR] Slave I/O for channel '': error connecting to master...
[ERROR] Slave I/O for channel '': error connecting to master '...' - retry-time: 60 retries 88888, Error_code: 2003
See Client Error Code 2003
[MY-000011]: Can't unlock file (OS errno %d - %s)
[MY-000011]: Can't unlock file (OS errno %d - %s)
[MY-000035] [Server] Disk is full writing '...'
[MY-000035] [Server] Disk is full writing '...'
[ERROR] [MY-000035] [Server] Disk is full writing './binlog.000023' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.
See OS Error Code 28
[ERROR] [MY-000035] [Server] Disk is full writing './relay-bin.000005' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.
See OS Error Code 28
[MY-000067] [Server] unknown variable ...
[MY-000067] [Server] unknown variable ...
[ERROR] [MY-000067] [Server] unknown variable 'binlog_transaction_dependency_tracking=WRITESET'
Percona Server 8.4 has removed support for this option.
[ERROR] [MY-000067] [Server] unknown variable 'symbolic-link=0'.
Caused by a typo. In this case, the real variable is called symbolic-links (which is deprecated so, ideally, don't set it anyway).
[ERROR] [MY-000067] [Server] unknown variable 'innodb_flush_neighbours=0'.
Caused by a typo. In this case the real variable is called innodb_flush_neighbors
[MY-010020] [Server] Data Dictionary initialization failed.
[MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
See accompanying error messages.
[MY-011263] [Server] Could not use /.../mysql-slow.log for logging
[MY-011263] [Server] Could not use /.../mysql-slow.log for logging
[ERROR] [MY-011263] [Server] Could not use /var/log/mysql/mysql-slow.log for logging (error 28 - No space left on device). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
See OS Error Code 28
[ERROR] [MY-011263] [Server] Could not use /var/log/mysqld-slow.log for logging (error 13 - Permission denied). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
sudo touch /var/log/mysqld-slow.log
sudo chown mysql:mysql /var/log/mysqld-slow.log
sudo chmod 640 /var/log/mysqld-slow.log
sudo chcon -t mysqld_log_t /var/log/mysqld-slow.log
[MY-013236] [Server] The designated data directory /var/lib/mysql/data/ is unusable
[MY-013236] [Server] The designated data directory /var/lib/mysql/data/ is unusable
[ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/data/ is unusable. You can remove all files that the server added to it.
This may be a knock-on effect from other errors. Fix all other errors. Restart MySQL and only worry about this if it still happens after that.
sudo chown mysql:mysql /var/lib/mysql/data
sudo chmod 640 /var/lib/mysql/data
sudo restorecon -R /var/lib/mysql
Page updated
Google Sites
Report abuse