[debian-mysql] Bug#1025784: Acknowledgement (mariadb-server-core-10.6: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111))
Tim McConnell
tmcconnell168 at gmail.com
Sun Dec 25 21:03:36 GMT 2022
Further attachments and files.
On Fri, 2022-12-09 at 01:36 +0000, Debian Bug Tracking System wrote:
> Thank you for filing a new Bug report with Debian.
>
> You can follow progress on this Bug here: 1025784:
> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1025784.
>
> This is an automatically generated reply to let you know your message
> has been received.
>
> Your message is being forwarded to the package maintainers and other
> interested parties for their attention; they will reply in due
> course.
>
> Your message has been sent to the package maintainer(s):
> Debian MySQL Maintainers <pkg-mysql-maint at lists.alioth.debian.org>
>
> If you wish to submit further information on this problem, please
> send it to 1025784 at bugs.debian.org.
>
> Please do not send mail to owner at bugs.debian.org unless you wish
> to report a problem with the Bug-tracking system.
>
-------------- next part --------------
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] Aborting
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_table_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: 2022-12-08 14:44:21 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_index_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 08 14:44:21 DebianTim mariadbd[1596347]: Warning: Memory not freed: 280
Dec 08 14:44:21 DebianTim systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Dec 08 14:44:21 DebianTim systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Dec 08 14:44:21 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 159712 and the job result is failed.
-------------- next part --------------
Dec 21 13:15:08 DebianTim systemd[1]: Starting MariaDB 10.6.11 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has begun execution.
░░
░░ The job identifier is 139.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] /usr/sbin/mariadbd (server 10.6.11-MariaDB-1) starting as process 1252 ...
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:21 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:21 0 [Note] InnoDB: Number of pools: 1
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:21 0 [Note] InnoDB: Using liburing
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:22 0 [Note] InnoDB: Completed initialization of buffer pool
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: 128 rollback segments are active.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/gtid_slave_pos.ibd' OS error: 81
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/gtid_slave_pos. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_index_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_table_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/transaction_registry.ibd' OS error: 81
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/transaction_registry. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: 10.6.11 started; log sequence number 43088; transaction id 15
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] InnoDB: Buffer pool(s) load completed at 221221 13:15:25
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_table_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_index_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Dec 21 13:15:25 DebianTim mariadbd[1252]: 2022-12-21 13:15:25 0 [ERROR] Aborting
Dec 21 13:15:26 DebianTim mariadbd[1252]: Warning: Memory not freed: 280
Dec 21 13:15:26 DebianTim systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Dec 21 13:15:26 DebianTim systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Dec 21 13:15:26 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 139 and the job result is failed.
Dec 24 15:37:23 DebianTim systemd[1]: Starting MariaDB 10.6.11 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has begun execution.
░░
░░ The job identifier is 62167.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] /usr/sbin/mariadbd (server 10.6.11-MariaDB-1) starting as process 2344532 ...
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Number of pools: 1
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Using liburing
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Completed initialization of buffer pool
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: 128 rollback segments are active.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/gtid_slave_pos.ibd' OS error: 81
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/gtid_slave_pos. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_index_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_table_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/transaction_registry.ibd' OS error: 81
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/transaction_registry. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: 10.6.11 started; log sequence number 43100; transaction id 15
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] InnoDB: Buffer pool(s) load completed at 221224 15:37:24
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_index_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_table_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Dec 24 15:37:24 DebianTim mariadbd[2344532]: 2022-12-24 15:37:24 0 [ERROR] Aborting
Dec 24 15:37:25 DebianTim mariadbd[2344532]: Warning: Memory not freed: 280
Dec 24 15:37:25 DebianTim systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Dec 24 15:37:25 DebianTim systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Dec 24 15:37:25 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 62167 and the job result is failed.
-------------- next part --------------
× mariadb.service - MariaDB 10.6.11 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Sun 2022-12-25 14:36:51 CST; 3min 15s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1680296 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 1680297 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1680299 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 1680328 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 1680328 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 147ms
Dec 25 14:36:50 DebianTim mariadbd[1680328]: 2022-12-25 14:36:50 0 [Note] InnoDB: Buffer pool(s) load completed at 221225 14:36:50
Dec 25 14:36:50 DebianTim mariadbd[1680328]: 2022-12-25 14:36:50 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Dec 25 14:36:50 DebianTim mariadbd[1680328]: 2022-12-25 14:36:50 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Dec 25 14:36:50 DebianTim mariadbd[1680328]: 2022-12-25 14:36:50 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 25 14:36:50 DebianTim mariadbd[1680328]: 2022-12-25 14:36:50 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Dec 25 14:36:50 DebianTim mariadbd[1680328]: 2022-12-25 14:36:50 0 [ERROR] Aborting
Dec 25 14:36:51 DebianTim mariadbd[1680328]: Warning: Memory not freed: 280
Dec 25 14:36:51 DebianTim systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 25 14:36:51 DebianTim systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 25 14:36:51 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 database server.
-------------- next part --------------
× mariadb.service - MariaDB 10.6.11 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Sat 2022-12-24 16:34:59 CST; 1min 51s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2350820 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 2350822 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2350824 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 2350862 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 2350862 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 220ms
Dec 24 16:34:58 DebianTim mariadbd[2350862]: 2022-12-24 16:34:58 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
Dec 24 16:34:58 DebianTim mariadbd[2350862]: 2022-12-24 16:34:58 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
Dec 24 16:34:58 DebianTim mariadbd[2350862]: 2022-12-24 16:34:58 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory.
Dec 24 16:34:58 DebianTim mariadbd[2350862]: 2022-12-24 16:34:58 0 [ERROR] InnoDB: Could not find a valid tablespace file for mysql/innodb_index_stats. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
Dec 24 16:34:58 DebianTim mariadbd[2350862]: 2022-12-24 16:34:58 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Dec 24 16:34:58 DebianTim mariadbd[2350862]: 2022-12-24 16:34:58 0 [ERROR] Aborting
Dec 24 16:34:59 DebianTim mariadbd[2350862]: Warning: Memory not freed: 280
Dec 24 16:34:59 DebianTim systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 24 16:34:59 DebianTim systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 24 16:34:59 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 database server.
More information about the pkg-mysql-maint
mailing list