Arch Linux

James80

Member

Registered: 2021-01-11

Posts: 10

mariadb problem

Hi,

I've installed mariadb but I've problems to start it.

 sudo systemctl enable mariadb
[james@jimmy-ms7b79 ~]$ systemctl status mariadb.service
× mariadb.service - MariaDB 10.9.4 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
     Active: failed (Result: exit-code) since Mon 2023-01-23 14:30:50 EST; 37s ago
   Duration: 7min 41.114s
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: xxxxx (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 123ms

Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [Note] InnoDB: log sequence number xxxx; transaction id 4
Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [ERROR] Failed to initialize plugins.
Jan 23 14:30:50 jimmy-ms7b79 mariadbd[1367595]: 2023-01-23 14:30:50 0 [ERROR] Aborting
Jan 23 14:30:50 jimmy-ms7b79 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 23 14:30:50 jimmy-ms7b79 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 23 14:30:50 jimmy-ms7b79 systemd[1]: Failed to start MariaDB 10.9.4 database server.

Adriik

Member

From: Argentina

Registered: 2022-03-10

Posts: 128

Re: mariadb problem

From MariaDB wiki:

Install mariadb, and run the following command before starting the mariadb.service:

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

Did you do that? Because searching for could not open mysql.plugin table... I found this. The problem of the page is for MySql, but I think you can adapt it to mariadb, just delete all under /var/lib/mysql and run the above command before enabling/starting the service.

Last edited by Adriik (2023-01-23 19:57:19)

---

Solo soy un loco más. Please use [code] [/code] tags.
Command cheatsheet ♠ Command not found?
If I write something wrong in English, please correct me.