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-ma...@lists.alioth.debian.org>
>
> If you wish to submit further information on this problem, please
> send it to 1025...@bugs.debian.org.
>
> Please do not send mail to ow...@bugs.debian.org unless you wish
> to report a problem with the Bug-tracking system.
>
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.
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.
× 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.
× 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.
