[Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: afb707fb-fa33-11ed-95d5-005056810b5a.
Informational message only.
[Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
[Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)
[ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
See also: [MY-013236][MY-011011][MY-010020]
In our case a UNIX admin had created separate mount points under /var/lib/mysql (/var/lib/mysql/log and /var/lib/mysql/backup). To work around the issue, I created a directory /var/lib/mysql/data, then edited /etc/my.cnf to change datadir from /var/lib/mysql to /var/lib/mysql/data.
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-20) starting as process 406143
Informational message only.
[ERROR] [MY-010119] [Server] Aborting
See accompanying error messages.
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-20) Percona Server (GPL), Release 20, Revision fd4b5a776a6.
Informational message only.
[System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.28-20' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 20, Revision fd4b5a776a6.
Informational message only.
[ERROR] [MY-011011] [Server] Failed to find valid data directory.
See accompanying error messages.
[Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
[Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
[Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
[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 later on this page.
[System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
Informational message only.
[ERROR] [MY-012144] [InnoDB] posix_fallocate(): Failed to preallocate data for file myidbfile, desired size x bytes. Operating system error number 28. Check that the disk is not full or a disk quota exceeded. Make sure the file system supports this function. Some operating system error numbers are described at http://dev.mysql.com/doc/refman/8.0/en/operating-system-error-codes.html
See OS Error Code 28 later on this page.
[Warning] [MY-012145] [InnoDB] Error while writing x zeroes to y
See accompanying error messages.
[Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
See accompanying error messages.
[ERROR] [MY-012639] [InnoDB] Write to file myidbfile failed at offset x, y bytes should have been written, only z were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
[ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
[System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28-20) initializing of server in progress as process 406117
Informational message only.
[System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.28-20).
Informational message only.
[ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
See: [MY-010457]
[System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
Informational message only.
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
Informational message only.
[System] [MY-013577] [InnoDB] InnoDB initialization has ended.
Informational message only.
[Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: /usr/lib64/mysql/private/.
TODO - what does this mean?
[Note] Aborted connection 3680 to db: 'mydb' user: 'myuser' host: 'myhost' (Got timeout reading communication packets)
TODO
[Note] Got timeout reading communication packets
perror 28
To show error code description
Check SELinux status (sestatus) and disable/reconfigure if necessary.
Check /mysql/log for unnecessary files and remove them if safe to do so.
Check /mysql/backup for redundant backup files.
Consider purging the binary logs.
Optimize or force rebuild tables which have had large deletes.