[mariadb] Erreurs au lancement de mariadb

[stephan08]

Bonjour,

Code : Tout sélectionner

pacman -Qs mariadb

me donne bien:

Code : Tout sélectionner

local/libmariadbclient 10.1.26-1
    MariaDB client libraries
local/mariadb 10.1.26-1
    Fast SQL database server, drop-in replacement for MySQL
local/mariadb-clients 10.1.26-1
    MariaDB client tools

Du coup, mariadb est bien installé.

Code : Tout sélectionner

systemctl enable mariadb

me donne:

Code : Tout sélectionner

Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.

Du coup, cela veut dire qu'à chaque démarrage, il se lancera.

Puis, j'ai quand même fait pour le lancer:

Code : Tout sélectionner

systemctl start mariadb

et j'obtiens:

Code : Tout sélectionner

Job for mariadb.service failed because the service did not take the steps required by its unit configuration.
See "systemctl  status mariadb.service" and "journalctl  -xe" for details.

Ensuite,

Code : Tout sélectionner

systemctl status mariadb

Code : Tout sélectionner

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: inactive (dead)

Du coup, j'ai regardé les logs d'erreurs via:

Code : Tout sélectionner

journalctl -xe

Code : Tout sélectionner

sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Compressed tables use zlib 1.2.11
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Using Linux native AIO
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Using SSE crc32 instructions
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Initializing buffer pool, size = 128.0M
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Completed initialization of buffer pool
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new datab
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
sept. 10 20:24:05 DeepakPc mysqld[4749]: 2017-09-10 20:24:05 140084036857792 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
sept. 10 20:24:06 DeepakPc mysqld[4749]: 2017-09-10 20:24:06 140084036857792 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Warning] InnoDB: New log files created, LSN=45883
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Doublewrite buffer not found: creating new
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Doublewrite buffer created
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: 128 rollback segment(s) are active.
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Warning] InnoDB: Creating foreign key constraint system tables.
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Foreign key constraint system tables created
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Creating tablespace and datafile system tables.
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Tablespace and datafile system tables created.
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB: Waiting for purge to start
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log 
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140083405997824 [Note] InnoDB: Dumping buffer pool(s) not yet started
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [Note] Plugin 'FEEDBACK' is disabled.
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036857792 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
sept. 10 20:24:07 DeepakPc mysqld[4749]: 2017-09-10 20:24:07 140084036713216 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos:
sept. 10 20:24:08 DeepakPc mysqld[4749]: 2017-09-10 20:24:08 140084036857792 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
sept. 10 20:24:08 DeepakPc mysqld[4749]: 2017-09-10 20:24:08 140084036857792 [Note] Server socket created on IP: '::'.
sept. 10 20:24:08 DeepakPc mysqld[4749]: 2017-09-10 20:24:08 140084036857792 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doe
sept. 10 20:24:08 DeepakPc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
sept. 10 20:24:08 DeepakPc systemd[1]: Failed to start MariaDB database server.
-- Subject: L'unité (unit) mariadb.service a échoué
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unité (unit) mariadb.service a échoué, avec le résultat failed.
sept. 10 20:24:08 DeepakPc systemd[1]: mariadb.service: Unit entered failed state.
sept. 10 20:24:08 DeepakPc systemd[1]: mariadb.service: Failed with result 'protocol'.

Je ne comprends pas où est l'erreur. Pouvez vous m'aider à lancer mariadb.

Je vous remercie par avance pour votre aide

[benjarobin]

Bonjour,
Essaye ce qui est décrit dans le Wiki : https://wiki.archlinux.org/index.php/MySQL#Installation