MariaDB can't start because it can't read your files, the logs state it very clearly: 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. Likely, you created the DB files and folders with the wrong permissions. Please run : chown -R mysql:mysql /var/lib/mysql to fix the issue and restart MariaDB again. Hope this helps, -GL Le ven. 30 déc. 2022 à 23:03, Tim McConnell <tmcconnell168@gmail.com> a écrit :
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.
-- Tim McConnell <tmcconnell168@gmail.com>
On Fri, 2022-12-30 at 21:54 +0100, Guillaume Lefranc wrote:
Please post the content of your error logs (journalctl -u mariadb.service)
Le ven. 30 déc. 2022, 21:50, Tim McConnell <tmcconnell168@gmail.com> a écrit :
Hi Guillame, Well, that almost worked, mysql_install_db ran and completed. Now it won't let me login as root. If I try 'mysql -u root -p'and hit enter when prompted for a password I get this Enter password: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 104 and I have to use 'sudo systemctl start mariadb.socket' instead of 'sudo systemctl start mariadb.service' but it has to be restarted if authentication fails. so the rest of the KB you sent does no good since I still can't access the DB, or even view what was created by the installer command.
_______________________________________________ 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