Hi Daniel, I did that and it does work fine now. I'm not sure why it was installed as root. I would have thought apt-get would have assigned that "properly". It's fixed now and is running now. -- Tim McConnell <tmcconnell168@gmail.com> On Sat, 2022-12-31 at 10:40 +1100, Daniel Black wrote:
Looks like mysql_install_db was run as root.
Change the ownership to the mysql user and the service should start ok.
chown -R mysql: /var/lib/mysql
On Sat, Dec 31, 2022 at 9:05 AM Tim McConnell <tmcconnell168@gmail.com> wrote:
Hi Guilaume, From journalctl : 2022-12-30 14:23:01 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:23:01 0 [ERROR] /usr/sbin/mariadbd: unknown option '- - print-defaults' 2022-12-30 14:23:01 0 [ERROR] Aborting 2022-12-30 14:30:11 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:30:11 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:34:42 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:34:42 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:34:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:34:42 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:34:42 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:34:42 0 [Note] InnoDB: Using liburing 2022-12-30 14:34:42 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:34:42 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:34:42 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 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. 2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 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. 2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 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. 2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 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. 2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:34:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:34:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:34:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:34:42 0 [Note] InnoDB: 10.6.11 started; log sequence number 43100; transaction id 15 2022-12-30 14:34:42 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:34:42 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:34:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:34:42 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: Permission denied 2022-12-30 14:34:42 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:34:42 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:34:42 0 [Note] Server socket created on IP: '127.0.0.1'. 2022-12-30 14:34:42 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:34:42 0 [ERROR] Aborting 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 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. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:34:42 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. Warning: Memory not freed: 280 2022-12-30 14:35:15 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:35:15 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:35:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:35:15 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:35:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:35:15 0 [Note] InnoDB: Using liburing 2022-12-30 14:35:15 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:35:15 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:35:15 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 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. 2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 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. 2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 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. 2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 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. 2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:35:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:35:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:35:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:35:15 0 [Note] InnoDB: 10.6.11 started; log sequence number 43112; transaction id 15 2022-12-30 14:35:15 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:35:15 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:35:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:35:15 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:35:15 2022-12-30 14:35:15 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 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. 2022-12-30 14:35:15 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:15 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. 2022-12-30 14:35:15 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:35:15 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:35:15 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:35:15 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:35:15 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:35:16 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:35:16 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:35:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:35:16 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:35:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:35:16 0 [Note] InnoDB: Using liburing 2022-12-30 14:35:16 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:35:16 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:35:16 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:35:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:35:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:35:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:35:16 0 [Note] InnoDB: 10.6.11 started; log sequence number 43124; transaction id 15 2022-12-30 14:35:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:35:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:35:16 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:35:16 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:35:16 2022-12-30 14:35:16 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:35:16 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:35:16 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:35:16 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:35:16 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:35:16 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:35:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:35:16 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:35:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:35:16 0 [Note] InnoDB: Using liburing 2022-12-30 14:35:16 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:35:16 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:35:16 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:35:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:35:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:35:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:35:16 0 [Note] InnoDB: 10.6.11 started; log sequence number 43136; transaction id 15 2022-12-30 14:35:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:35:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:35:16 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:35:16 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:35:16 2022-12-30 14:35:16 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:35:16 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:16 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. 2022-12-30 14:35:16 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:35:16 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:35:17 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:35:17 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:35:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:35:17 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:35:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:35:17 0 [Note] InnoDB: Using liburing 2022-12-30 14:35:17 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:35:17 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:35:17 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:35:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:35:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:35:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:35:17 0 [Note] InnoDB: 10.6.11 started; log sequence number 43148; transaction id 15 2022-12-30 14:35:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:35:17 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:35:17 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:35:17 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:35:17 2022-12-30 14:35:17 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:35:17 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:35:17 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:35:17 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:35:17 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:35:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:35:17 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:35:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:35:17 0 [Note] InnoDB: Using liburing 2022-12-30 14:35:17 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:35:17 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:35:17 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:35:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:35:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:35:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:35:17 0 [Note] InnoDB: 10.6.11 started; log sequence number 43160; transaction id 15 2022-12-30 14:35:17 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:35:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:35:17 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:35:17 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:35:17 2022-12-30 14:35:17 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:35:17 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:35:17 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. 2022-12-30 14:35:17 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:35:17 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:48:21 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:48:21 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:48:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:48:21 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:48:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:48:21 0 [Note] InnoDB: Using liburing 2022-12-30 14:48:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:48:21 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:48:21 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:48:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:48:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:48:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:48:21 0 [Note] InnoDB: 10.6.11 started; log sequence number 43172; transaction id 15 2022-12-30 14:48:21 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:48:21 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:48:21 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:48:21 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:48:21 2022-12-30 14:48:21 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:48:21 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:48:21 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:48:21 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:48:21 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:48:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:48:21 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:48:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:48:21 0 [Note] InnoDB: Using liburing 2022-12-30 14:48:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:48:21 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:48:21 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 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. 2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:48:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:48:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:48:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:48:21 0 [Note] InnoDB: 10.6.11 started; log sequence number 43184; transaction id 15 2022-12-30 14:48:21 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:48:21 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:48:21 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:48:21 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:48:21 2022-12-30 14:48:21 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48: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. 2022-12-30 14:48:21 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:48:21 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:48:21 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:48:22 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:48:22 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:48:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:48:22 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:48:22 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:48:22 0 [Note] InnoDB: Using liburing 2022-12-30 14:48:22 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:48:22 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:48:22 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:48:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:48:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:48:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:48:22 0 [Note] InnoDB: 10.6.11 started; log sequence number 43196; transaction id 15 2022-12-30 14:48:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:48:22 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:48:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:48:22 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:48:22 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:48:22 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:48:22 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:48:22 0 [ERROR] Aborting 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. Warning: Memory not freed: 280 2022-12-30 14:48:22 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:48:22 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:48:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:48:22 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:48:22 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:48:22 0 [Note] InnoDB: Using liburing 2022-12-30 14:48:22 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:48:22 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:48:22 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:48:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:48:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:48:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:48:22 0 [Note] InnoDB: 10.6.11 started; log sequence number 43208; transaction id 15 2022-12-30 14:48:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:48:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:48:22 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:48:22 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:48:22 2022-12-30 14:48:22 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:48:22 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:22 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. 2022-12-30 14:48:22 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:48:22 0 [ERROR] Aborting Warning: Memory not freed: 280 2022-12-30 14:48:23 0 [Warning] Plugin 'OQGRAPH' is of maturity level gamma while the server is stable 2022-12-30 14:48:23 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2022-12-30 14:48:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2022-12-30 14:48:23 0 [Note] InnoDB: Number of pools: 1 2022-12-30 14:48:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-12-30 14:48:23 0 [Note] InnoDB: Using liburing 2022-12-30 14:48:23 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-12-30 14:48:23 0 [Note] InnoDB: Completed initialization of buffer pool 2022-12-30 14:48:23 0 [Note] InnoDB: 128 rollback segments are active. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/gtid_slave_pos.ibd' OS error: 81 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 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. 2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for mysql/gtid_slave_pos because it could not be opened. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 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. 2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_index_stats because it could not be opened. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 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. 2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for mysql/innodb_table_stats because it could not be opened. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/transaction_registry.ibd' OS error: 81 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 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. 2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for mysql/transaction_registry because it could not be opened. 2022-12-30 14:48:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-12-30 14:48:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-12-30 14:48:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-12-30 14:48:23 0 [Note] InnoDB: 10.6.11 started; log sequence number 43220; transaction id 15 2022-12-30 14:48:23 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-12-30 14:48:23 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-12-30 14:48:23 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-12-30 14:48:23 0 [Note] InnoDB: Buffer pool(s) load completed at 221230 14:48:23 2022-12-30 14:48:23 0 [Warning] You need to use --log-bin to make - - expire-logs-days or --binlog-expire-logs-seconds work. 2022-12-30 14:48:23 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_table_stats.ibd' OS error: 81 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 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. 2022-12-30 14:48:23 0 [Note] Using systemd activated socket host :: port 3306 2022-12-30 14:48:23 0 [Note] Using systemd activated unix socket /run/mysqld/mysqld.sock 2022-12-30 14:48:23 0 [Note] Using systemd activated unix socket @mariadb 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read- only: './mysql/innodb_index_stats.ibd' OS error: 81 2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not have the access rights to the directory. 2022-12-30 14:48:23 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. 2022-12-30 14:48:23 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 2022-12-30 14:48:23 0 [ERROR] Aborting Warning: Memory not freed: 280 I tried to follow the link in the errors but it appears that you have to have a running DB to do those steps.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp