Fedora-Fr - Communauté francophone Fedora - Linux

Communauté francophone des utilisateurs de la distribution Linux Fedora.

  

Dernière news : Assemblée Générale Ordinaire de Borsalinux-fr de 2023

#1 01/11/2018 16:41:11

Da-maax
Rédacteur Wiki
Rédacteur Wiki
Lieu : France (Hautes-Alpes)
Inscription : 03/08/2018
Messages : 27

[Résolu] Probléme mysql au lancement

Bonjour à tous,

Je viens de terminer la mise à jour, par la même occasion, j'ai voulus installé PHP, Apache, Mysql et phpMyAdmin afin de continué un projet de site web.
Tout c'est bien déroulé, jusqu'au lancement de Mysql où j'ai une erreur :

[da-max@localhost ~]$ sudo systemctl start mysqld.service
[sudo] Mot de passe de da-max : 
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.

J'ai donc suivis les instructions et voici le retour de :

status mysqld.serivce
 
[da-max@localhost ~]$ sudo systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor pre>
   Active: failed (Result: exit-code) since Thu 2018-11-01 15:27:06 CET; 34s ago
  Process: 4900 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=>
  Process: 4898 ExecStart=/usr/libexec/mysqld --basedir=/usr (code=exited, stat>
  Process: 4862 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (>
  Process: 4838 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, stat>
 Main PID: 4898 (code=exited, status=1/FAILURE)
   Status: "SERVER_BOOTING"
    Error: 2 (No such file or directory)

nov. 01 15:27:06 localhost systemd[1]: Starting MySQL 8.0 database server...
nov. 01 15:27:06 localhost systemd[1]: mysqld.service: Main process exited, cod>
nov. 01 15:27:06 localhost systemd[1]: mysqld.service: Failed with result 'exit>
nov. 01 15:27:06 localhost systemd[1]: Failed to start MySQL 8.0 database serve>
lines 1-15/15 (END)...skipping...
● mysqld.service - MySQL 8.0 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2018-11-01 15:27:06 CET; 34s ago
  Process: 4900 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
  Process: 4898 ExecStart=/usr/libexec/mysqld --basedir=/usr (code=exited, status=1/FAILURE)
  Process: 4862 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)
  Process: 4838 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
 Main PID: 4898 (code=exited, status=1/FAILURE)
   Status: "SERVER_BOOTING"
    Error: 2 (No such file or directory)

nov. 01 15:27:06 localhost systemd[1]: Starting MySQL 8.0 database server...
nov. 01 15:27:06 localhost systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
nov. 01 15:27:06 localhost systemd[1]: mysqld.service: Failed with result 'exit-code'.
nov. 01 15:27:06 localhost systemd[1]: Failed to start MySQL 8.0 database server.

- Et de :

journalctl -xe
[da-max@localhost ~]$ journalctl -xe
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unité (unit) mysqld.service a commencé à démarrer.
nov. 01 15:27:06 localhost systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
nov. 01 15:27:06 localhost systemd[1]: mysqld.service: Failed with result 'exit-code'.
nov. 01 15:27:06 localhost systemd[1]: Failed to start MySQL 8.0 database server.
-- Subject: L'unité (unit) mysqld.service a échoué
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unité (unit) mysqld.service a échoué, avec le résultat RESULT.
nov. 01 15:27:06 localhost audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=mysqld comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? te>
nov. 01 15:27:06 localhost sudo[4807]: pam_unix(sudo:session): session closed for user root
nov. 01 15:27:06 localhost audit[4807]: USER_END pid=4807 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_close grantors=pam_keyinit,pam_limits,pam_keyinit,p>
nov. 01 15:27:06 localhost audit[4807]: CRED_DISP pid=4807 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_localuser,pam_unix acct="root" exe="/>
nov. 01 15:27:28 localhost sudo[5562]:   da-max : problem with defaults entries ; TTY=pts/0 ; PWD=/home/da-max ; USER=root ;
nov. 01 15:27:28 localhost audit[5562]: USER_ACCT pid=5562 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:accounting grantors=pam_unix,pam_localuser acct="da-max>
nov. 01 15:27:28 localhost audit[5562]: USER_CMD pid=5562 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/da-max" cmd=737461747573206D7973716C642E736572697663>
nov. 01 15:27:31 localhost audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=fprintd comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? te>
nov. 01 15:27:32 localhost sudo[5592]:   da-max : problem with defaults entries ; TTY=pts/0 ; PWD=/home/da-max ; USER=root ;
nov. 01 15:27:32 localhost audit[5592]: USER_ACCT pid=5592 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:accounting grantors=pam_unix,pam_localuser acct="da-max>
nov. 01 15:27:32 localhost audit[5592]: USER_CMD pid=5592 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/da-max" cmd=737461747573206D7973716C642E736572766963>
nov. 01 15:27:40 localhost sudo[6856]:   da-max : problem with defaults entries ; TTY=pts/0 ; PWD=/home/da-max ; USER=root ;
nov. 01 15:27:40 localhost audit[6856]: USER_ACCT pid=6856 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:accounting grantors=pam_unix,pam_localuser acct="da-max>
nov. 01 15:27:40 localhost sudo[6856]:   da-max : TTY=pts/0 ; PWD=/home/da-max ; USER=root ; COMMAND=/usr/bin/systemctl status mysqld.service
nov. 01 15:27:40 localhost audit[6856]: USER_CMD pid=6856 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/da-max" cmd=73797374656D63746C20737461747573206D7973>
nov. 01 15:27:40 localhost audit[6856]: CRED_REFR pid=6856 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_env,pam_fprintd acct="root" exe="/usr>
nov. 01 15:27:40 localhost sudo[6856]: pam_systemd(sudo:session): Cannot create session: Already running in a session or user slice
nov. 01 15:27:40 localhost sudo[6856]: pam_unix(sudo:session): session opened for user root by (uid=0)
nov. 01 15:27:40 localhost audit[6856]: USER_START pid=6856 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_open grantors=pam_keyinit,pam_limits,pam_keyinit,>
nov. 01 15:28:45 localhost org.keepassxc.KeePassXC.desktop[2190]: QObject::startTimer: Timers cannot have negative intervals
nov. 01 15:29:10 localhost gnome-shell[2190]: NOTE: Not using GLX TFP!
nov. 01 15:34:41 localhost dbus-daemon[927]: [system] Activating via systemd: service name='org.freedesktop.hostname1' unit='dbus-org.freedesktop.hostname1.service' requested by ':1.429' (uid=1000 pid=2778 comm>
nov. 01 15:34:41 localhost systemd[1]: Starting Hostname Service...
-- Subject: L'unité (unit) systemd-hostnamed.service a commencé à démarrer
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unité (unit) systemd-hostnamed.service a commencé à démarrer.
nov. 01 15:34:41 localhost dbus-daemon[927]: [system] Successfully activated service 'org.freedesktop.hostname1'
nov. 01 15:34:41 localhost systemd[1]: Started Hostname Service.
-- Subject: L'unité (unit) systemd-hostnamed.service a terminé son démarrage
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unité (unit) systemd-hostnamed.service a terminé son démarrage, avec le résultat RESULT.
nov. 01 15:34:41 localhost audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=systemd-hostnamed comm="systemd" exe="/usr/lib/systemd/systemd" hostname=>
nov. 01 15:34:42 localhost kernel: nf_conntrack: default automatic helper assignment has been turned off for security reasons and CT-based  firewall rule not found. Use the iptables CT target to attach helpers >
nov. 01 15:35:19 localhost audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=systemd-hostnamed comm="systemd" exe="/usr/lib/systemd/systemd" hostname=?>
nov. 01 15:35:22 localhost sudo[6856]: pam_unix(sudo:session): session closed for user root
nov. 01 15:35:22 localhost audit[6856]: USER_END pid=6856 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_close grantors=pam_keyinit,pam_limits,pam_keyinit,p>
nov. 01 15:35:22 localhost audit[6856]: CRED_DISP pid=6856 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_env,pam_fprintd acct="root" exe="/usr>

J'ai essayé de dé-installer puis de ré-installer (ou même d'installer MariaDB), mais rien n'y fait.
Merci d'avance.


Config : I5-7300HQ - GTX 1050 4G - 8G DDR4

Hors ligne

#2 01/11/2018 18:20:55

Nicosss
Rédacteur Wiki
Rédacteur Wiki
Lieu : Isère
Inscription : 05/03/2007
Messages : 7 608
Site Web

Re : [Résolu] Probléme mysql au lancement

Ton hostname est localhost hors il faut définir un hostname différent.

Je te propose de lire https://doc.fedora-fr.org/wiki/Installa … n_de_MySQL ou selon ton choix https://doc.fedora-fr.org/wiki/Installa … de_MariaDB.


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

Hors ligne

#3 01/11/2018 23:22:13

Da-maax
Rédacteur Wiki
Rédacteur Wiki
Lieu : France (Hautes-Alpes)
Inscription : 03/08/2018
Messages : 27

Re : [Résolu] Probléme mysql au lancement

Tous d'abord merci pour ta réponse.

Effectivement, j'ai sauté cette étape big_smile , cependant, même après avoir nommé ma machine, je n'arrive toujours pas à démarrer mysql neutral

Dernière modification par Da-maax (01/11/2018 23:30:07)


Config : I5-7300HQ - GTX 1050 4G - 8G DDR4

Hors ligne

#4 02/11/2018 00:33:53

Nicosss
Rédacteur Wiki
Rédacteur Wiki
Lieu : Isère
Inscription : 05/03/2007
Messages : 7 608
Site Web

Re : [Résolu] Probléme mysql au lancement

Les erreurs sont toujours les mêmes ?


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

Hors ligne

#5 02/11/2018 00:53:40

Da-maax
Rédacteur Wiki
Rédacteur Wiki
Lieu : France (Hautes-Alpes)
Inscription : 03/08/2018
Messages : 27

Re : [Résolu] Probléme mysql au lancement

Oui, (il y a juste localhost qui a été remplacé par le nom de ma machine) :

[da-max@Da-max ~]$ sudo systemctl start mysqld.service
[sudo] Mot de passe de da-max : 
Désolé, essayez de nouveau.
[sudo] Mot de passe de da-max : 
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
[da-max@Da-max ~]$ sudo systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor pre>
   Active: failed (Result: exit-code) since Thu 2018-11-01 23:51:38 CET; 7s ago
  Process: 26479 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status>
  Process: 26477 ExecStart=/usr/libexec/mysqld --basedir=/usr (code=exited, sta>
  Process: 26441 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service >
  Process: 26417 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, sta>
 Main PID: 26477 (code=exited, status=1/FAILURE)
   Status: "SERVER_BOOTING"
    Error: 2 (No such file or directory)

nov. 01 23:51:38 Da-max systemd[1]: Starting MySQL 8.0 database server...
nov. 01 23:51:38 Da-max systemd[1]: mysqld.service: Main process exited, code=e>
nov. 01 23:51:38 Da-max systemd[1]: mysqld.service: Failed with result 'exit-co>
nov. 01 23:51:38 Da-max systemd[1]: Failed to start MySQL 8.0 database server.

Config : I5-7300HQ - GTX 1050 4G - 8G DDR4

Hors ligne

#6 02/11/2018 08:00:51

Heldwin
version 329521
Inscription : 07/10/2008
Messages : 4 334

Re : [Résolu] Probléme mysql au lancement

Bonjour,

juste une question, pourquoi mysql et pas mariadb ?
mariadb est fourni par fedora (fork de mysql), et est à la version 10

# systemctl status mariadb
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /usr/lib/systemd/system/mariadb.service.d
           └─tokudb.conf
   Active: active (running) since Fri 2018-11-02 06:58:30 CET; 4s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 4844 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
  Process: 4672 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
  Process: 4648 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
 Main PID: 4794 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 49 (limit: 4915)
   Memory: 177.5M
   CGroup: /system.slice/mariadb.service
           └─4794 /usr/libexec/mysqld --basedir=/usr

nov 02 06:58:30 localhost.localdomain mysql-prepare-db-dir[4672]: Please report any problems at http://mariadb.org/jira
nov 02 06:58:30 localhost.localdomain mysql-prepare-db-dir[4672]: The latest information about MariaDB is available at http://mariadb.org/.
nov 02 06:58:30 localhost.localdomain mysql-prepare-db-dir[4672]: You can find additional information about the MySQL part at:
nov 02 06:58:30 localhost.localdomain mysql-prepare-db-dir[4672]: http://dev.mysql.com
nov 02 06:58:30 localhost.localdomain mysql-prepare-db-dir[4672]: Consider joining MariaDB's strong and vibrant community:
nov 02 06:58:30 localhost.localdomain mysql-prepare-db-dir[4672]: https://mariadb.org/get-involved/
nov 02 06:58:30 localhost.localdomain mysqld[4794]: 2018-11-02  6:58:30 0 [Note] /usr/libexec/mysqld (mysqld 10.3.10-MariaDB) starting as process 4794 ...
nov 02 06:58:30 localhost.localdomain mysqld[4794]: 2018-11-02  6:58:30 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
nov 02 06:58:30 localhost.localdomain mysqld[4794]: 2018-11-02  6:58:30 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
nov 02 06:58:30 localhost.localdomain systemd[1]: Started MariaDB 10.3 database server.

EDIT: je viens de voir l'indication sur la tentative avec mariadb, mais il faudrait se concentrer plus sur mariadb que mysql
(et surtout sur comment a été installé mysql)

Dernière modification par Heldwin (02/11/2018 08:04:32)


"The only way to achieve the impossible is to believe it’s possible"

Hors ligne

#7 02/11/2018 09:22:46

Da-maax
Rédacteur Wiki
Rédacteur Wiki
Lieu : France (Hautes-Alpes)
Inscription : 03/08/2018
Messages : 27

Re : [Résolu] Probléme mysql au lancement

Bonjour,
J'ai essayé d'installer Mariadb, mais j'ai la même erreur :

[da-max@Da-max ~]$ sudo systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
[da-max@Da-max ~]$ systemctl status mariadb.service
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor pr>
  Drop-In: /usr/lib/systemd/system/mariadb.service.d
           └─tokudb.conf
   Active: failed (Result: exit-code) since Fri 2018-11-02 07:59:31 CET; 20min >
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 8037 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSR>
  Process: 7999 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service >
  Process: 7962 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, stat>
 Main PID: 8037 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

nov. 02 07:59:27 Da-max systemd[1]: Starting MariaDB 10.3 database server...
nov. 02 07:59:28 Da-max mysql-prepare-db-dir[7999]: Database MariaDB is probabl>
nov. 02 07:59:28 Da-max mysql-prepare-db-dir[7999]: If this is not the case, ma>
nov. 02 07:59:28 Da-max mysqld[8037]: 2018-11-02  7:59:28 0 [Note] /usr/libexec>
nov. 02 07:59:28 Da-max mysqld[8037]: 2018-11-02  7:59:28 0 [Warning] Could not>
nov. 02 07:59:28 Da-max mysqld[8037]: 2018-11-02  7:59:28 0 [Warning] Changed l>
nov. 02 07:59:31 Da-max systemd[1]: mariadb.service: Main process exited, code=>
nov. 02 07:59:31 Da-max systemd[1]: mariadb.service: Failed with result 'exit-c>
nov. 02 07:59:31 Da-max systemd[1]: Failed to start MariaDB 10.3 database serve>

Pour moi, cela revient au même, j'ai juste connu mysql en premier donc je n'ai pas cherché autre chose, cependant, ça ne me dérange pas du tout de changer.

Merci d'avance


Config : I5-7300HQ - GTX 1050 4G - 8G DDR4

Hors ligne

#8 02/11/2018 10:11:12

Nicosss
Rédacteur Wiki
Rédacteur Wiki
Lieu : Isère
Inscription : 05/03/2007
Messages : 7 608
Site Web

Re : [Résolu] Probléme mysql au lancement

Les messages sont tronqués.

Quel est le contenu de /var/log/mariadb/mariadb.log ?


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

Hors ligne

#9 02/11/2018 10:16:51

Da-maax
Rédacteur Wiki
Rédacteur Wiki
Lieu : France (Hautes-Alpes)
Inscription : 03/08/2018
Messages : 27

Re : [Résolu] Probléme mysql au lancement

Voici le contenu de /var/log/mariadb/mariadb.log

2018-11-01 12:55:16 0 [Note] RocksDB: Got ENOENT when listing column families
2018-11-01 12:55:16 0 [Note] RocksDB:   assuming that we're creating a new database
2018-11-01 12:55:16 0 [Note] RocksDB: Column Families at start:
2018-11-01 12:55:16 0 [Note]   cf=default
2018-11-01 12:55:16 0 [Note]     write_buffer_size=67108864
2018-11-01 12:55:16 0 [Note]     target_file_size_base=67108864
2018-11-01 12:55:16 0 [Note] RocksDB: creating a column family __system__
2018-11-01 12:55:16 0 [Note]     write_buffer_size=67108864
2018-11-01 12:55:16 0 [Note]     target_file_size_base=67108864
2018-11-01 12:55:17 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-01 12:55:17 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-01 12:55:17 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-01 12:55:17 0 [Note] InnoDB: Using Linux native AIO
2018-11-01 12:55:17 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01 12:55:17 0 [Note] InnoDB: Uses event mutexes
2018-11-01 12:55:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-01 12:55:17 0 [Note] InnoDB: Number of pools: 1
2018-11-01 12:55:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-01 12:55:17 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-01 12:55:17 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01 12:55:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-01 12:55:17 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-01 12:55:17 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-01 12:55:18 0 [Note] InnoDB: Starting shutdown...
2018-11-01 12:55:18 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-01 12:55:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-01 12:55:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-01 12:55:18 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/da-max@' not found in keytab
2018-11-01 12:55:18 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-01 12:55:18 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-01 12:55:18 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-01 12:55:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-01 12:55:18 0 [ERROR] Aborting

2018-11-01 12:56:56 0 [Note] RocksDB: 2 column families found
2018-11-01 12:56:56 0 [Note] RocksDB: Column Families at start:
2018-11-01 12:56:56 0 [Note]   cf=default
2018-11-01 12:56:56 0 [Note]     write_buffer_size=67108864
2018-11-01 12:56:56 0 [Note]     target_file_size_base=67108864
2018-11-01 12:56:56 0 [Note]   cf=__system__
2018-11-01 12:56:56 0 [Note]     write_buffer_size=67108864
2018-11-01 12:56:56 0 [Note]     target_file_size_base=67108864
2018-11-01 12:56:56 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-01 12:56:56 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-01 12:56:56 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-01 12:56:56 0 [Note] InnoDB: Using Linux native AIO
2018-11-01 12:56:56 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01 12:56:56 0 [Note] InnoDB: Uses event mutexes
2018-11-01 12:56:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-01 12:56:56 0 [Note] InnoDB: Number of pools: 1
2018-11-01 12:56:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-01 12:56:56 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-01 12:56:56 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01 12:56:56 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-01 12:56:56 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-01 12:56:56 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-01 12:56:57 0 [Note] InnoDB: Starting shutdown...
2018-11-01 12:56:57 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-01 12:56:57 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-01 12:56:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-01 12:56:57 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/da-max@' not found in keytab
2018-11-01 12:56:57 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-01 12:56:57 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-01 12:56:57 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-01 12:56:57 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-01 12:56:57 0 [ERROR] Aborting

2018-11-01 12:57:42 0 [Note] RocksDB: 2 column families found
2018-11-01 12:57:42 0 [Note] RocksDB: Column Families at start:
2018-11-01 12:57:42 0 [Note]   cf=default
2018-11-01 12:57:42 0 [Note]     write_buffer_size=67108864
2018-11-01 12:57:42 0 [Note]     target_file_size_base=67108864
2018-11-01 12:57:42 0 [Note]   cf=__system__
2018-11-01 12:57:42 0 [Note]     write_buffer_size=67108864
2018-11-01 12:57:42 0 [Note]     target_file_size_base=67108864
2018-11-01 12:57:42 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-01 12:57:42 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-01 12:57:42 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-01 12:57:42 0 [Note] InnoDB: Using Linux native AIO
2018-11-01 12:57:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01 12:57:42 0 [Note] InnoDB: Uses event mutexes
2018-11-01 12:57:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-01 12:57:42 0 [Note] InnoDB: Number of pools: 1
2018-11-01 12:57:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-01 12:57:42 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-01 12:57:42 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01 12:57:42 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-01 12:57:42 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-01 12:57:42 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-01 12:57:43 0 [Note] InnoDB: Starting shutdown...
2018-11-01 12:57:43 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-01 12:57:43 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-01 12:57:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-01 12:57:43 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/localhost@' not found in keytab
2018-11-01 12:57:43 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-01 12:57:43 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-01 12:57:43 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-01 12:57:43 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-01 12:57:43 0 [ERROR] Aborting

2018-11-01 14:23:57 0 [Note] RocksDB: 2 column families found
2018-11-01 14:23:57 0 [Note] RocksDB: Column Families at start:
2018-11-01 14:23:57 0 [Note]   cf=default
2018-11-01 14:23:57 0 [Note]     write_buffer_size=67108864
2018-11-01 14:23:57 0 [Note]     target_file_size_base=67108864
2018-11-01 14:23:57 0 [Note]   cf=__system__
2018-11-01 14:23:57 0 [Note]     write_buffer_size=67108864
2018-11-01 14:23:57 0 [Note]     target_file_size_base=67108864
2018-11-01 14:23:57 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-01 14:23:57 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-01 14:23:57 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-01 14:23:57 0 [Note] InnoDB: Using Linux native AIO
2018-11-01 14:23:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01 14:23:57 0 [Note] InnoDB: Uses event mutexes
2018-11-01 14:23:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-01 14:23:57 0 [Note] InnoDB: Number of pools: 1
2018-11-01 14:23:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-01 14:23:57 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-01 14:23:57 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01 14:23:57 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-01 14:23:57 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-01 14:23:57 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-01 14:23:58 0 [Note] InnoDB: Starting shutdown...
2018-11-01 14:23:58 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-01 14:23:58 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-01 14:23:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-01 14:23:58 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/localhost@' not found in keytab
2018-11-01 14:23:58 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-01 14:23:58 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-01 14:23:58 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-01 14:23:58 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-01 14:23:58 0 [ERROR] Aborting

2018-11-01 14:34:57 0 [Note] RocksDB: 2 column families found
2018-11-01 14:34:57 0 [Note] RocksDB: Column Families at start:
2018-11-01 14:34:57 0 [Note]   cf=default
2018-11-01 14:34:57 0 [Note]     write_buffer_size=67108864
2018-11-01 14:34:57 0 [Note]     target_file_size_base=67108864
2018-11-01 14:34:57 0 [Note]   cf=__system__
2018-11-01 14:34:57 0 [Note]     write_buffer_size=67108864
2018-11-01 14:34:57 0 [Note]     target_file_size_base=67108864
2018-11-01 14:34:59 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-01 14:35:00 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-01 14:35:00 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-01 14:35:00 0 [Note] InnoDB: Using Linux native AIO
2018-11-01 14:35:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01 14:35:00 0 [Note] InnoDB: Uses event mutexes
2018-11-01 14:35:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-01 14:35:00 0 [Note] InnoDB: Number of pools: 1
2018-11-01 14:35:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-01 14:35:00 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-01 14:35:00 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01 14:35:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-01 14:35:00 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-01 14:35:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-01 14:35:00 0 [Note] InnoDB: Starting shutdown...
2018-11-01 14:35:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-01 14:35:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-01 14:35:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-01 14:35:00 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/localhost@' not found in keytab
2018-11-01 14:35:00 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-01 14:35:00 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-01 14:35:00 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-01 14:35:00 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-01 14:35:00 0 [ERROR] Aborting

2018-11-01 14:35:16 0 [ERROR] mysqld: Can't open shared library '/usr/auth_gssapi.so' (errno: 22, cannot open shared object file: No such file or directory)
2018-11-01 14:35:16 0 [ERROR] Couldn't load plugins from 'auth_gssapi.so'.
2018-11-01 14:35:16 0 [ERROR] mysqld: Can't open shared library '/usr/ha_rocksdb.so' (errno: 22, cannot open shared object file: No such file or directory)
2018-11-01 14:35:16 0 [ERROR] Couldn't load plugins from 'ha_rocksdb.so'.
2018-11-01 14:35:16 0 [ERROR] mysqld: Can't open shared library '/usr/ha_tokudb.so' (errno: 22, cannot open shared object file: No such file or directory)
2018-11-01 14:35:16 0 [ERROR] Couldn't load plugins from 'ha_tokudb.so'.
2018-11-01 14:36:22 0 [Note] RocksDB: 2 column families found
2018-11-01 14:36:22 0 [Note] RocksDB: Column Families at start:
2018-11-01 14:36:22 0 [Note]   cf=default
2018-11-01 14:36:22 0 [Note]     write_buffer_size=67108864
2018-11-01 14:36:22 0 [Note]     target_file_size_base=67108864
2018-11-01 14:36:22 0 [Note]   cf=__system__
2018-11-01 14:36:22 0 [Note]     write_buffer_size=67108864
2018-11-01 14:36:22 0 [Note]     target_file_size_base=67108864
2018-11-01 14:36:23 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-01 14:36:23 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-01 14:36:23 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-01 14:36:23 0 [Note] InnoDB: Using Linux native AIO
2018-11-01 14:36:23 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01 14:36:23 0 [Note] InnoDB: Uses event mutexes
2018-11-01 14:36:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-01 14:36:23 0 [Note] InnoDB: Number of pools: 1
2018-11-01 14:36:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-01 14:36:23 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-01 14:36:23 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01 14:36:23 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-01 14:36:23 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-01 14:36:23 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-01 14:36:23 0 [Note] InnoDB: Starting shutdown...
2018-11-01 14:36:23 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-01 14:36:23 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-01 14:36:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-01 14:36:23 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/localhost@' not found in keytab
2018-11-01 14:36:23 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-01 14:36:23 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-01 14:36:23 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-01 14:36:23 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-01 14:36:23 0 [ERROR] Aborting

2018-11-02  7:59:29 0 [Note] RocksDB: 2 column families found
2018-11-02  7:59:29 0 [Note] RocksDB: Column Families at start:
2018-11-02  7:59:29 0 [Note]   cf=default
2018-11-02  7:59:29 0 [Note]     write_buffer_size=67108864
2018-11-02  7:59:29 0 [Note]     target_file_size_base=67108864
2018-11-02  7:59:29 0 [Note]   cf=__system__
2018-11-02  7:59:29 0 [Note]     write_buffer_size=67108864
2018-11-02  7:59:29 0 [Note]     target_file_size_base=67108864
2018-11-02  7:59:29 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
2018-11-02  7:59:30 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
2018-11-02  7:59:30 0 [Note] MyRocks storage engine plugin has been successfully initialized.
2018-11-02  7:59:30 0 [Note] InnoDB: Using Linux native AIO
2018-11-02  7:59:30 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-02  7:59:30 0 [Note] InnoDB: Uses event mutexes
2018-11-02  7:59:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-02  7:59:30 0 [Note] InnoDB: Number of pools: 1
2018-11-02  7:59:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-11-02  7:59:30 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-02  7:59:30 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-02  7:59:30 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-02  7:59:30 0 [ERROR] InnoDB: Invalid flags 0x4000 in ./ibdata1
2018-11-02  7:59:30 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-11-02  7:59:30 0 [Note] InnoDB: Starting shutdown...
2018-11-02  7:59:30 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-11-02  7:59:30 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-11-02  7:59:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-02  7:59:31 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/da-max@' not found in keytab
2018-11-02  7:59:31 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2018-11-02  7:59:31 0 [ERROR] Plugin 'gssapi' init function returned error.
2018-11-02  7:59:31 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-11-02  7:59:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-11-02  7:59:31 0 [ERROR] Aborting

Config : I5-7300HQ - GTX 1050 4G - 8G DDR4

Hors ligne

#10 02/11/2018 12:43:27

Nicosss
Rédacteur Wiki
Rédacteur Wiki
Lieu : Isère
Inscription : 05/03/2007
Messages : 7 608
Site Web

Re : [Résolu] Probléme mysql au lancement

Que retourne

# ll /var/lib/mysql/

Sinon désinstalle MySQL ainsi que MariaDB, efface le répertoire /var/lib/mysql/ puis installe à nouveau MariaDB.


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

Hors ligne

#11 02/11/2018 21:41:03

Da-maax
Rédacteur Wiki
Rédacteur Wiki
Lieu : France (Hautes-Alpes)
Inscription : 03/08/2018
Messages : 27

Re : [Résolu] Probléme mysql au lancement

Bonsoir,

Merci beaucoup, j'ai donc désinstallé Mysql et MariaDB puis effacé /var/lib/mysql, enfin ré-installé MariaDB, et tous fonctionne parfaitement.

Merci encore du temps que tu as passé pour m'aider et bonne soirée.


Config : I5-7300HQ - GTX 1050 4G - 8G DDR4

Hors ligne

Pied de page des forums