Fedora-Fr - Communauté francophone Fedora - Linux

Communauté francophone des utilisateurs de la distribution Linux Fedora.

  

Dernière news : Représenter Fedora au Capitole du Libre 2019

#1 05/07/2019 14:58:54

philo71
Membre
Inscription : 31/05/2018
Messages : 41

[Résolu] Failed to start MariaDB 10.3 database server.

bonjour,
Je vient de supprimer MySQL 8.0.16 sur mon serveur.
j'ai installé mariaDB 10.3.

j'ai une erreur suite a la commande en mode root

# systemctl start mariadb.service

Erreur :

systemctl status mariadb.service
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2019-07-05 14:39:36 CEST; 4min 32s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 5474 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
  Process: 5496 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
  Process: 5532 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
 Main PID: 5532 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

juil. 05 14:39:35 dct-heliot systemd[1]: Starting MariaDB 10.3 database server...
juil. 05 14:39:35 dct-heliot mysql-prepare-db-dir[5496]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
juil. 05 14:39:35 dct-heliot mysql-prepare-db-dir[5496]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql>
juil. 05 14:39:35 dct-heliot mysqld[5532]: 2019-07-05 14:39:35 0 [Note] /usr/libexec/mysqld (mysqld 10.3.12-MariaDB) starting as process 553>
juil. 05 14:39:36 dct-heliot systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
juil. 05 14:39:36 dct-heliot systemd[1]: mariadb.service: Failed with result 'exit-code'.
juil. 05 14:39:36 dct-heliot systemd[1]: Failed to start MariaDB 10.3 database server.

Je pense qu'il y a des objets (tables...) de MySQL résidant sur mon système.
Ce matin j'ai installé mariaDB sur un autre ordinateur, mariaDB marche très bien.

Comment faire pour contourner ce problème ?

Hors ligne

#2 05/07/2019 15:04:42

winmandrake
Membre
Inscription : 08/07/2008
Messages : 1 144

Re : [Résolu] Failed to start MariaDB 10.3 database server.

supprimer tout dossier utlisé par mysql ?


Mon pc : AMD R5-2400G sur Asus Prime B450M-A, 16 Go ram, Nvidia 1050Ti (4Go), SSD Samsung 850 EVO (250 Go) + black caviar de 1To.

Hors ligne

#3 05/07/2019 15:34:04

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Tout est indiqué dans le message d'erreur. Tu as les fichiers de MySQL qui n'ont pas été effacés avant d'utiliser MariaDB. Il te faut vider /var/lib/mysql/.


F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#4 05/07/2019 15:51:36

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

avec minhight commander j'ai supprimé /var/lib/mysql/

j'ai toujours le mème message d'erreur avec la commande >>

systemctl status mariadb.service

après avoir redémarer mon serveur, mon repertoire /var/lib/mysql est toujours visible par mariaDB.

Est ce qu'il existe un fichier qui a indexé /var/lib/mysql sur le serveur mariaDB ?

Dernière modification par philo71 (05/07/2019 16:03:14)

Hors ligne

#5 05/07/2019 16:06:41

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Que retourne

# ls -al /var/lib/mysql/
# tail -n 100 /var/log/mariadb/mariadb.log

Edit : Ajout commande

Dernière modification par Nicosss (05/07/2019 16:10:57)


F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#6 05/07/2019 17:10:41

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

[root@dct-heliot lib]# ls -al /var/lib/mysql/
ls: impossible d'accéder à '/var/lib/mysql/': Aucun fichier ou dossier de ce type
[root@dct-heliot lib]#
[root@dct-heliot lib]# tail -n 100 /var/log/mariadb/mariadb.log
2019-07-05 13:56:45 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 13:56:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 13:56:45 0 [Note] InnoDB: Uses event mutexes
2019-07-05 13:56:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 13:56:45 0 [Note] InnoDB: Number of pools: 1
2019-07-05 13:56:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 13:56:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 13:56:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 13:56:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 13:56:45 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 13:56:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 13:56:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 13:56:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 13:56:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 13:56:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 13:56:46 0 [ERROR] Aborting

2019-07-05 14:28:46 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:28:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:28:46 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:28:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:28:46 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:28:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:28:46 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:28:46 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:28:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:28:46 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:28:46 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:28:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:28:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:28:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:28:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:28:46 0 [ERROR] Aborting

2019-07-05 14:30:19 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:30:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:30:19 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:30:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:30:19 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:30:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:30:19 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:30:19 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:30:19 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:30:19 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:30:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:30:19 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:30:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:30:19 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:30:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:30:19 0 [ERROR] Aborting

2019-07-05 14:39:35 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:39:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:39:35 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:39:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:39:35 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:39:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:39:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:39:35 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:39:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:39:35 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:39:35 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:39:36 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:39:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:39:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:39:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:39:36 0 [ERROR] Aborting

2019-07-05 14:44:04 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:44:04 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:44:04 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:44:04 0 [ERROR] Aborting

[root@dct-heliot lib]# 

Hors ligne

#7 05/07/2019 18:21:21

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Tu as supprimé le répertoire et non son contenu.

As-tu désinstallé mysql ? Si oui installe à nouveau mariadb-server.


F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#8 05/07/2019 18:22:44

madko
Contributeur Fedora et Linuxé depuis 1994
Modérateur
Lieu : Noisy the Great (9³)
Inscription : 22/12/2006
Messages : 7 373
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

C'est peut être un peu violent d'avoir supprimé /var/lib/mysql. Recrée le, met lui les bons propriétaires pour que le démon puisse écrire dedans et ça devrait rouler. Au pire reinstalle le paquet qui fournit le rep /var/lib/mysql si tu as un doute sur les droits/propriétaire etc (cf la doc du site sur dnf)

Hors ligne

#9 08/07/2019 01:52:21

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

j"ai recréé le repertoire "mysql" mais toujours le même message d'erreur !

Hors ligne

#10 08/07/2019 06:11:05

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

philo71 a écrit :

j"ai recréé le repertoire "mysql" mais toujours le même message d'erreur !

On doit deviner quoi ? Un retour de commande serait plus parlant pour avoir tous les détails.

Si tu installes à nouveau MariaDB, il se chargera de tout créer correctement.

Edit : changera is not chargera

Dernière modification par Nicosss (08/07/2019 15:04:24)


F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#11 08/07/2019 14:10:36

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

bonjour,
j'ai désinstallé mariaDB et installé de nouveau, mariaDB marche.
Cependant j'ai un problème d'authentification suite à la commande mysql_secure_installation.

[phipo@dct-heliot mysql]$ mysql_secure_installation
shell-init : erreur de détermination du répertoire actuel : getcwd : ne peut accéder aux répertoires parents : Aucun fichier ou dossier de ce type
touch: impossible de faire un touch '.my.cnf.10441': Aucun fichier ou dossier de ce type
touch: impossible de faire un touch '.mysql.10441': Aucun fichier ou dossier de ce type
chmod: impossible d'accéder à '.my.cnf.10441': Aucun fichier ou dossier de ce type
chmod: impossible d'accéder à '.mysql.10441': Aucun fichier ou dossier de ce type

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
/usr/bin/mysql_secure_installation: ligne 248: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 249: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 250: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 252: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 217: .mysql.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 219: .mysql.10441: Aucun fichier ou dossier de ce type
Enter current password for root (enter for none): 
/usr/bin/mysql_secure_installation: ligne 248: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 249: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 250: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 252: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 217: .mysql.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 219: .mysql.10441: Aucun fichier ou dossier de ce type
Enter current password for root (enter for none): 

Dernière modification par philo71 (08/07/2019 14:30:52)

Hors ligne

#12 08/07/2019 15:16:45

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Tu as dû mettre un peu de bazar on dirait.

Mariadb tourne ?

# systemctl status mariadb.service

Que retourne

# updatedb
# locate my.cnf
# tail -n 100 /var/log/mariadb/mariadb.log

F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#13 08/07/2019 15:21:34

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

[root@dct-heliot mysql]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Mon 2019-07-08 14:05:08 CEST; 1h 12min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 10125 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 30 (limit: 4686)
   Memory: 76.9M
   CGroup: /system.slice/mariadb.service
           └─10125 /usr/libexec/mysqld --basedir=/usr

juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: See the MariaDB Knowledgebase at http://mariadb.com/kb or the
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: MySQL manual for more instructions.
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: Please report any problems at http://mariadb.org/jira
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: The latest information about MariaDB is available at http://mariadb.org/.
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: You can find additional information about the MySQL part at:
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: http://dev.mysql.com
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: Consider joining MariaDB's strong and vibrant community:
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: https://mariadb.org/get-involved/
juil. 08 14:05:07 dct-heliot mysqld[10125]: 2019-07-08 14:05:07 0 [Note] /usr/libexec/mysqld (mysqld 10.3.12-MariaDB) starting as process 10>
juil. 08 14:05:08 dct-heliot systemd[1]: Started MariaDB 10.3 database server.
lines 1-22
[root@dct-heliot mysql]# updatedb
[root@dct-heliot mysql]# locate my.cnf
/etc/my.cnf
/etc/my.cnf.d
/etc/my.cnf.rpmsave
/etc/my.cnf.d/auth_gssapi.cnf
/etc/my.cnf.d/client.cnf
/etc/my.cnf.d/cracklib_password_check.cnf
/etc/my.cnf.d/enable_encryption.preset
/etc/my.cnf.d/mariadb-server.cnf
/etc/my.cnf.d/mysql-clients.cnf



[root@dct-heliot mysql]# tail -n 100 /var/log/mariadb/mariadb.log
2019-07-05 13:56:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 13:56:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 13:56:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 13:56:45 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 13:56:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 13:56:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 13:56:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 13:56:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 13:56:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 13:56:46 0 [ERROR] Aborting

2019-07-05 14:28:46 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:28:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:28:46 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:28:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:28:46 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:28:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:28:46 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:28:46 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:28:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:28:46 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:28:46 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:28:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:28:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:28:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:28:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:28:46 0 [ERROR] Aborting

2019-07-05 14:30:19 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:30:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:30:19 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:30:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:30:19 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:30:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:30:19 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:30:19 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:30:19 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:30:19 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:30:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:30:19 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:30:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:30:19 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:30:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:30:19 0 [ERROR] Aborting

2019-07-05 14:39:35 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:39:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:39:35 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:39:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:39:35 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:39:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:39:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:39:35 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:39:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:39:35 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:39:35 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:39:36 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:39:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:39:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:39:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:39:36 0 [ERROR] Aborting

2019-07-05 14:44:04 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:44:04 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:44:04 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:44:04 0 [ERROR] Aborting

2019-07-08 14:05:07 0 [Note] InnoDB: Using Linux native AIO
2019-07-08 14:05:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-08 14:05:07 0 [Note] InnoDB: Uses event mutexes
2019-07-08 14:05:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-08 14:05:07 0 [Note] InnoDB: Number of pools: 1
2019-07-08 14:05:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-08 14:05:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-08 14:05:07 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-08 14:05:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-08 14:05:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-08 14:05:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-08 14:05:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-08 14:05:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-07-08 14:05:07 0 [Note] InnoDB: Waiting for purge to start
2019-07-08 14:05:07 0 [Note] InnoDB: 10.3.12 started; log sequence number 1630815; transaction id 21
2019-07-08 14:05:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-07-08 14:05:07 0 [Note] InnoDB: Buffer pool(s) load completed at 190708 14:05:07
2019-07-08 14:05:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-08 14:05:07 0 [Note] Server socket created on IP: '::'.
2019-07-08 14:05:08 0 [Note] Reading of all Master_info entries succeded
2019-07-08 14:05:08 0 [Note] Added new Master_info '' to hash table
2019-07-08 14:05:08 0 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.3.12-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
[root@dct-heliot mysql]# 

Hors ligne

#14 08/07/2019 15:44:09

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Tu as un retour de la commande

$ mysql --user root --execute "select version()"

Que retourne

# ls -al /var/lib/mysql/

F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#15 08/07/2019 16:09:47

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

[phipo@dct-heliot mysql]$ mysql --user root --execute "select version()"
+-----------------+
| version()       |
+-----------------+
| 10.3.12-MariaDB |
+-----------------+
[phipo@dct-heliot mysql]$ 
[phipo@dct-heliot mysql]$ ls -al /var/lib/mysql/
total 122948
drwxr-xr-x.  4 mysql mysql     4096  8 juil. 14:05 .
drwxr-xr-x. 61 root  root      4096  8 juil. 14:02 ..
-rw-rw----.  1 mysql mysql    16384  8 juil. 14:05 aria_log.00000001
-rw-rw----.  1 mysql mysql       52  8 juil. 14:05 aria_log_control
-rw-rw----.  1 mysql mysql      972  8 juil. 14:05 ib_buffer_pool
-rw-rw----.  1 mysql mysql 12582912  8 juil. 14:05 ibdata1
-rw-rw----.  1 mysql mysql 50331648  8 juil. 14:05 ib_logfile0
-rw-rw----.  1 mysql mysql 50331648  8 juil. 14:05 ib_logfile1
-rw-rw----.  1 mysql mysql 12582912  8 juil. 14:05 ibtmp1
-rw-rw----.  1 mysql mysql        0  8 juil. 14:05 multi-master.info
drwx------.  2 mysql mysql     4096  8 juil. 14:05 mysql
srwxrwxrwx.  1 mysql mysql        0  8 juil. 14:05 mysql.sock
-rw-rw----.  1 mysql mysql       16  8 juil. 14:05 mysql_upgrade_info
drwx------.  2 mysql mysql     4096  8 juil. 14:05 performance_schema
-rw-rw----.  1 mysql mysql    24576  8 juil. 14:05 tc.log
[phipo@dct-heliot mysql]$ 

Hors ligne

#16 08/07/2019 16:34:50

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Essaye la manipulation suivante

$ cd ~
$ mysql_secure_installation

Sinon il faudrait repartir de zéro en désinstallant mariadb, en supprimant le répertoire /var/lib/mysql/ ainsi que le répertoire /etc/my.cnf.d/ et les 2 fichiers /etc/my.cnf et /etc/my.cnf.rpmsave.
Ensuite tu appliques la procédure https://doc.fedora-fr.org/wiki/Installa … de_MariaDB.


F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

#17 08/07/2019 18:03:47

philo71
Membre
Inscription : 31/05/2018
Messages : 41

Re : [Résolu] Failed to start MariaDB 10.3 database server.

merci,
les deux commandes :

$ cd ~
$ mysql_secure_installation

ont fonctionnées.

Juste un dernier détail: Quel est le dernier GUI pour mariaDB ? (mysql=mysqlworkbench)

Hors ligne

#18 08/07/2019 18:24:44

Nicosss
Membre
Lieu : Isère
Inscription : 05/03/2007
Messages : 5 025
Site Web

Re : [Résolu] Failed to start MariaDB 10.3 database server.

Bon tant mieux.

Tu peux utiliser phpMyAdmin comme indiqué dans la documentation. Sinon tu peux consulter https://mariadb.com/kb/en/library/guiwo … iadb-aria/.


F30_64 Gnome-Shell - GA-990FXA-UD3 - Phenom II X6 1100T - NH-D14 - Ati HD 5750 Fanless - 16Go RAM /&/ F30_64 Gnome-Shell - Toshiba Satellite C660D-19X - 8Go RAM
F30_64 - ASRock 960GC-GS FX - AMD FX(tm)-8300 - 16Go RAM

Hors ligne

Pied de page des forums