Installation mariadb failed | |
|
|
Mitglied Posts: 56 Registered: 2007-11-13 | Hello,
I install mariadb ok but when I do a systemctl start mariadb it failed ....
I have this :
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sat 2017-04-01 08:25:39 UTC; 4s ago
Process: 2665 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 2613 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl
Process: 2612 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2611 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2665 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
avril 01 08:25:38 paul-pc systemd[1]: Starting MariaDB database server...
avril 01 08:25:39 paul-pc mysqld[2665]: 2017-04-01 8:25:39 140192060864448 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 2
avril 01 08:25:39 paul-pc mysqld[2665]: 2017-04-01 8:25:39 140192060864448 [Warning] Can't create test file /home/mysql/paul-pc.lower-test
avril 01 08:25:39 paul-pc mysqld[2665]: [94B blob data]
avril 01 08:25:39 paul-pc mysqld[2665]: 2017-04-01 8:25:39 140192060864448 [ERROR] Aborting
avril 01 08:25:39 paul-pc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
avril 01 08:25:39 paul-pc systemd[1]: Failed to start MariaDB database server.
avril 01 08:25:39 paul-pc systemd[1]: mariadb.service: Unit entered failed state.
avril 01 08:25:39 paul-pc systemd[1]: mariadb.service: Failed with result 'exit-code'.
And if I create the /home/mysql/paul-pc.lower-test :
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
Active: failed (Result: protocol) since Sat 2017-04-01 08:28:39 UTC; 3s ago
Process: 2751 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 2699 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl
Process: 2698 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2697 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2751 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
avril 01 08:28:39 paul-pc mysqld[2751]: 2017-04-01 8:28:39 140203864324032 [ERROR] Plugin 'InnoDB' init function returned error.
avril 01 08:28:39 paul-pc mysqld[2751]: 2017-04-01 8:28:39 140203864324032 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
avril 01 08:28:39 paul-pc mysqld[2751]: 2017-04-01 8:28:39 140203864324032 [Note] Plugin 'FEEDBACK' is disabled.
avril 01 08:28:39 paul-pc mysqld[2751]: 2017-04-01 8:28:39 140203864324032 [ERROR] Could not open mysql.plugin table. Some plugins may be not loa
avril 01 08:28:39 paul-pc mysqld[2751]: 2017-04-01 8:28:39 140203864324032 [ERROR] Unknown/unsupported storage engine: InnoDB
avril 01 08:28:39 paul-pc mysqld[2751]: 2017-04-01 8:28:39 140203864324032 [ERROR] Aborting
avril 01 08:28:39 paul-pc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
avril 01 08:28:39 paul-pc systemd[1]: Failed to start MariaDB database server.
avril 01 08:28:39 paul-pc systemd[1]: mariadb.service: Unit entered failed state.
avril 01 08:28:39 paul-pc systemd[1]: mariadb.service: Failed with result 'protocol'.
Thanks for help |
|
|
|
|
|
Re: Installation mariadb failed | |
|
|
Administrator Posts: 426 Registered: 2004-09-09 | Hi,
you have to run
as root to setup /home/mysql before starting MariaDB for the first time. |
|
|
|
|
|