MariaDB Initialization Not Working

Abubakar · 18 October 2022 18:51

I’m trying to set up MariaDB on my Manjaro KDE laptop, but the initialization doesn’t seem to be working. I typed:

mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

And got:

Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2022-10-18 19:36:51 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2022-10-18 19:36:51 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2022-10-18 19:36:51 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-18 19:36:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-18 19:36:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-18 19:36:51 0 [ERROR] Aborting

Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/bin/mariadb-install-db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/bin/mariadbd --skip-grant-tables --general-log &

and use the command line tool /usr/bin/mariadb
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at https://mariadb.org/jira

I’ve tried running the first and second recommendations from the error log generated:

[user ~] /usr/bin/mariadb-install-db --defaults-file=~/.my.cnf
Could not open required defaults file: ~/.my.cnf
Fatal error in defaults handling. Program aborted
Installing MariaDB/MySQL system tables in './data' ...
Could not open required defaults file: ~/.my.cnf
Fatal error in defaults handling. Program aborted

Installation of system tables failed!  Examine the logs in
./data for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/bin/mariadb-install-db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/bin/mariadbd --skip-grant-tables --general-log &

and use the command line tool /usr/bin/mariadb
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in ./data that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at https://mariadb.org/jira

[user ~]#  /usr/bin/mariadbd --skip-grant-tables --general-log &
[1] 10707
[user ~]# 2022-10-18 19:44:48 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB-log) starting as process 10707 ...
/usr/bin/mariadbd: Please consult the Knowledge Base to find out how to run mysqld as root!
2022-10-18 19:44:48 0 [ERROR] Aborting
> /usr/bin/mysql -u root mysql                       /usr/bin/mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
[1]+  Exit 1                  /usr/bin/mariadbd --skip-grant-tables --general-log
[user ~]#

This is all while running the terminal as root. I’ve tried accessing the location /var/lib/mysql , but when I read the log files I get gibberish.

Thank you

freggel.doe · 18 October 2022 19:15

You’re following the arch wiki?

Did you inspect those logs?

Abubakar · 18 October 2022 19:35

I’ve tried again and it worked. But I’m not sure which logs to open.

[user /]# cd var
[user var]# cd lib
[user lib]# cd mysql/
aria_log.00000001   binlog.000002       binlog.index        client-key.pem      ibdata1             mysql.ibd           server-cert.pem
aria_log_control    binlog.000003       ca-key.pem          #ib_16384_0.dblwr   #innodb_redo/       performance_schema/ server-key.pem
auto.cnf            binlog.000004       ca.pem              #ib_16384_1.dblwr   #innodb_temp/       private_key.pem     undo_001
binlog.000001       binlog.000005       client-cert.pem     ib_buffer_pool      mysql/              public_key.pem      undo_002
[user lib]# cd mysql/
[user mysql]# ls
 aria_log.00000001   binlog.000002   binlog.index      client-key.pem       ibdata1         mysql.ibd            server-cert.pem
 aria_log_control    binlog.000003   ca-key.pem       '#ib_16384_0.dblwr'  '#innodb_redo'   performance_schema   server-key.pem
 auto.cnf            binlog.000004   ca.pem           '#ib_16384_1.dblwr'  '#innodb_temp'   private_key.pem      undo_001
 binlog.000001       binlog.000005   client-cert.pem   ib_buffer_pool       mysql           public_key.pem       undo_002
[user mysql]# cat aria_log
aria_log.00000001  aria_log_control   
[user mysql]# cat aria_log.00000001 
��
  MARIALOGj�
            �''�������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������

freggel.doe · 18 October 2022 20:06

That’s no log file in the sense of error log to check. I can’t spot anything that looks like that in your ls listing.
Maybe they meant to check the journal, mariadb generates some entries there:

$ journalctl -u mariadb

Nice.

Abubakar · 18 October 2022 20:16

The output to the code you gave is below:

[user mysql]# journalctl -u mariadb 
Oct 15 16:03:37 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Using Linux native AIO 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [Note] InnoDB: Starting shutdown... 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 15 16:03:38 user mariadbd[5854]: 2022-10-15 16:03:38 0 [ERROR] Aborting 
Oct 15 16:03:38 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 15 16:03:38 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 15 16:03:38 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
Oct 15 16:06:50 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Using Linux native AIO 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [Note] InnoDB: Starting shutdown... 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 15 16:06:50 user mariadbd[6517]: 2022-10-15 16:06:50 0 [ERROR] Aborting 
Oct 15 16:06:50 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 15 16:06:50 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 15 16:06:50 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
Oct 15 16:19:54 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Using Linux native AIO 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [Note] InnoDB: Starting shutdown... 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 15 16:19:55 user mariadbd[9076]: 2022-10-15 16:19:55 0 [ERROR] Aborting 
Oct 15 16:19:55 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 15 16:19:55 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 15 16:19:55 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
-- Boot ea31bb894eae400e82cdcdeff5e69911 -- 
Oct 15 20:26:15 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 15 20:26:27 user mariadbd[1184]: 2022-10-15 20:26:27 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 15 20:26:28 user mariadbd[1184]: 2022-10-15 20:26:28 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 15 20:26:28 user mariadbd[1184]: 2022-10-15 20:26:28 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 15 20:26:28 user mariadbd[1184]: 2022-10-15 20:26:28 0 [Warning] WSREP: Guessing address for incoming client connecti> 
Oct 15 20:26:28 user mariadbd[1184]: 2022-10-15 20:26:28 0 [Note] WSREP: Node addr: 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Using Linux native AIO 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [Note] InnoDB: Starting shutdown... 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 15 20:26:30 user mariadbd[1184]: 2022-10-15 20:26:30 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 15 20:26:31 user mariadbd[1184]: 2022-10-15 20:26:31 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 15 20:26:31 user mariadbd[1184]: 2022-10-15 20:26:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 15 20:26:31 user mariadbd[1184]: 2022-10-15 20:26:31 0 [ERROR] Aborting 
Oct 15 20:26:31 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 15 20:26:31 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 15 20:26:31 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
-- Boot 4cf7dde9e87745fdb0924850feadd957 -- 
Oct 15 20:39:07 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 15 20:39:15 user mariadbd[1172]: 2022-10-15 20:39:15 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 15 20:39:16 user mariadbd[1172]: 2022-10-15 20:39:16 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 15 20:39:16 user mariadbd[1172]: 2022-10-15 20:39:16 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 15 20:39:16 user mariadbd[1172]: 2022-10-15 20:39:16 0 [Warning] WSREP: Guessing address for incoming client connecti> 
Oct 15 20:39:16 user mariadbd[1172]: 2022-10-15 20:39:16 0 [Note] WSREP: Node addr: 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Using Linux native AIO 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [Note] InnoDB: Starting shutdown... 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 15 20:39:18 user mariadbd[1172]: 2022-10-15 20:39:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 15 20:39:19 user mariadbd[1172]: 2022-10-15 20:39:19 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 15 20:39:19 user mariadbd[1172]: 2022-10-15 20:39:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 15 20:39:19 user mariadbd[1172]: 2022-10-15 20:39:19 0 [ERROR] Aborting 
Oct 15 20:39:19 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 15 20:39:19 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 15 20:39:19 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
-- Boot 56321d178d76438eaf0335ccc2127041 -- 
Oct 16 10:42:43 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 16 10:42:49 user mariadbd[1191]: 2022-10-16 10:42:49 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 16 10:42:49 user mariadbd[1191]: 2022-10-16 10:42:49 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 16 10:42:49 user mariadbd[1191]: 2022-10-16 10:42:49 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 16 10:42:49 user mariadbd[1191]: 2022-10-16 10:42:49 0 [Warning] WSREP: Guessing address for incoming client connecti> 
Oct 16 10:42:49 user mariadbd[1191]: 2022-10-16 10:42:49 0 [Note] WSREP: Node addr: 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Using Linux native AIO 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 16 10:42:50 user mariadbd[1191]: 2022-10-16 10:42:50 0 [Note] InnoDB: Starting shutdown... 
Oct 16 10:42:51 user mariadbd[1191]: 2022-10-16 10:42:51 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 16 10:42:51 user mariadbd[1191]: 2022-10-16 10:42:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 16 10:42:51 user mariadbd[1191]: 2022-10-16 10:42:51 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 16 10:42:51 user mariadbd[1191]: 2022-10-16 10:42:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 16 10:42:51 user mariadbd[1191]: 2022-10-16 10:42:51 0 [ERROR] Aborting 
Oct 16 10:42:51 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 16 10:42:51 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 16 10:42:51 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
-- Boot 1fcd020f0b4e4ab5aaa2f13f35648401 -- 
Oct 17 22:53:39 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 17 22:53:46 user mariadbd[1066]: 2022-10-17 22:53:46 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 17 22:53:47 user mariadbd[1066]: 2022-10-17 22:53:47 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 17 22:53:47 user mariadbd[1066]: 2022-10-17 22:53:47 0 [Warning] WSREP: Failed to guess base node address. Set it exp> 
Oct 17 22:53:47 user mariadbd[1066]: 2022-10-17 22:53:47 0 [Warning] WSREP: Guessing address for incoming client connecti> 
Oct 17 22:53:47 user mariadbd[1066]: 2022-10-17 22:53:47 0 [Note] WSREP: Node addr: 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Using Linux native AIO 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [Note] InnoDB: Starting shutdown... 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 17 22:53:48 user mariadbd[1066]: 2022-10-17 22:53:48 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 17 22:53:49 user mariadbd[1066]: 2022-10-17 22:53:49 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 17 22:53:49 user mariadbd[1066]: 2022-10-17 22:53:49 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 17 22:53:49 user mariadbd[1066]: 2022-10-17 22:53:49 0 [ERROR] Aborting 
Oct 17 22:53:49 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 17 22:53:49 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 17 22:53:49 user systemd[1]: Failed to start MariaDB 10.9.3 database server.
-- Boot d1ad470f533747e69a4eb3f99bb299dd -- 
Oct 18 19:36:08 user systemd[1]: Starting MariaDB 10.9.3 database server... 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] /usr/bin/mariadbd (server 10.9.3-MariaDB) starting as p> 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Number of transaction pools: 1 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Using Linux native AIO 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000M> 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Completed initialization of buffer pool 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] InnoDB: Plugin initialization aborted with error Data > 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [Note] InnoDB: Starting shutdown... 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] Plugin 'InnoDB' init function returned error. 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE faile> 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugi> 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
Oct 18 19:36:09 user mariadbd[9996]: 2022-10-18 19:36:09 0 [ERROR] Aborting 
Oct 18 19:36:09 user systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Oct 18 19:36:09 user systemd[1]: mariadb.service: Failed with result 'exit-code'. 
Oct 18 19:36:09 user systemd[1]: Failed to start MariaDB 10.9.3 database server. 
lines 140-173/173 (END)

freggel.doe · 18 October 2022 20:24

That looks like it didn’t work: mariadb server did not start.
There are also no entries regarding the mariadb-install-db - only entries regarding mariadb service.

Best to start over:

stop mariadb server (shouldn’t be running as it failed to start)

# systemctl stop mariadb.service

remove /var/lib/mysql directory

# rm -fr /var/lib/mysql

and begin anew.

Abubakar · 18 October 2022 20:26

Should I reinstall it completely?

freggel.doe · 18 October 2022 20:30

Package re-installation is not the first thing I’d think of but you can try it: what’s to loose?

Abubakar · 18 October 2022 21:07

It worked. Thanks a tonne!!

system · 21 October 2022 11:08

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.