Ubuntu-fr

Guillaume09

[Résolu]Mysql.service failed...

Bonjour,

J'ai tenté de déplacer mes Bd mysql comme expliqué sur la  page mysql du site, mais ça n'a pas marché, j'ai donc tenté de revenir en arrière mais le service mysql ne démarre plus.....

Au démarrage :

~/$ sudo service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

Dans systemctl :

~/$ systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since mar. 2017-04-04 21:20:41 CEST; 27s ago
  Process: 32483 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 32479 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 32483 (code=exited, status=1/FAILURE);         : 32484 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           └─control
             ├─32484 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─32574 sleep 1

avril 04 21:20:41 Sys-Xa systemd[1]: Starting MySQL Community Server...
avril 04 21:20:44 Sys-Xa systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Et dans journalctl:

 ~/$ journalctl -xe
avril 04 21:29:13 Sys-Xa kernel: audit: type=1400 audit(1491334153.902:976): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/1793/status" pid=1793 comm="mysqld" requested_mask="r"
avril 04 21:29:16 Sys-Xa systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
avril 04 21:29:45 Sys-Xa systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
avril 04 21:29:45 Sys-Xa systemd[1]: mysql.service: Unit entered failed state.
avril 04 21:29:45 Sys-Xa systemd[1]: mysql.service: Failed with result 'exit-code'.
avril 04 21:29:45 Sys-Xa systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
avril 04 21:29:45 Sys-Xa systemd[1]: Stopped MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a terminé son arrêt
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

Là je suis perdu et je ne sais plus quoi faire, merci pour votre aide.

Dernière modification par Guillaume09 (Le 06/04/2017, à 15:54)

---

Xubuntu 16.04.1 LTS

Vobul

Re : [Résolu]Mysql.service failed...

Regarde /var/log/mysql.err (ou .log je ne sais plus).

---

Vobul
Utilisez le retour utilisable de commandes !!!
J'aime la langue française, mais je parle franglais, deal with it.
RTFM

Guillaume09

Re : [Résolu]Mysql.service failed...

Voila ce que j'ai:

2017-04-05T18:33:50.150664Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-04-05T18:33:50.150740Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-04-05T18:33:50.327851Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-04-05T18:33:50.330084Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17-0ubuntu0.16.04.1) starting as process 20134 ...
2017-04-05T18:33:50.336606Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-04-05T18:33:50.336728Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-04-05T18:33:50.336738Z 0 [Note] InnoDB: Uses event mutexes
2017-04-05T18:33:50.336747Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-04-05T18:33:50.336757Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-04-05T18:33:50.336765Z 0 [Note] InnoDB: Using Linux native AIO
2017-04-05T18:33:50.337137Z 0 [Note] InnoDB: Number of pools: 1
2017-04-05T18:33:50.337291Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-04-05T18:33:50.339297Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-04-05T18:33:50.354256Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-04-05T18:33:50.357403Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-04-05T18:33:50.372878Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-04-05T18:33:50.426851Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-04-05T18:33:50.427032Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-04-05T18:33:50.675349Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-04-05T18:33:50.676416Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-04-05T18:33:50.676431Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-04-05T18:33:50.677332Z 0 [Note] InnoDB: Waiting for purge to start
2017-04-05T18:33:50.728268Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 1231552
2017-04-05T18:33:50.728797Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-04-05T18:33:50.729089Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170405 20:33:50
2017-04-05T18:33:50.729491Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2017-04-05T18:33:50.729813Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-04-05T18:33:50.730960Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-04-05T18:33:50.731147Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-04-05T18:33:50.731178Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-04-05T18:33:50.731209Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-04-05T18:33:50.731294Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-04-05T18:33:50.731666Z 0 [Warning] Failed to open optimizer cost constant tables

2017-04-05T18:33:50.732019Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2017-04-05T18:33:50.732164Z 0 [ERROR] Aborting

---

Xubuntu 16.04.1 LTS

Vobul

Re : [Résolu]Mysql.service failed...

Bah après tu le lis et tu google les messages d'erreur…

http://google.fr/?q=mysql+Fatal+error%3 … %27t+exist

Dernière modification par Vobul (Le 05/04/2017, à 21:31)

---

Vobul
Utilisez le retour utilisable de commandes !!!
J'aime la langue française, mais je parle franglais, deal with it.
RTFM

bruno

Re : [Résolu]Mysql.service failed...

Salut,

Bon tu as déplacé les fichiers de bases de données et tu n'as pas su rétablir la situation. Résultat le serveur MySQL ne trouve plus certaines tables essentielles à son fonctionnement (tables de la bas mysql).
Soit tu arrives à remettre les choses en place en revenant à la version d'origine des fichiers de configuration et à l'emplacement par défaut des fichiers des bases de données (/var/lib/myslq), soit tu purge ton installation (paquets mysql-server*), tu réinstalle et tu restaures tes bases à partir des sauvegardes.

Remarques :
- beaucoup de docs sur ubuntu-fr.org sont obsolètes, il ne faut les suivre avec précaution et discernement ;
- coller les messages d'erreur dans un moteur de recherche est un bon réflexe, mais il existe des moteurs qui respectent la vie privée des utilisateurs et donnent de très bon résultats : duckduckgo, startpage, etc.

Guillaume09

Re : [Résolu]Mysql.service failed...

Merci pour les réponses.
La solution a été de réinstaller les paquets, (entièrement d'accord pour la remarque sur les moteurs de recherche).

---

Xubuntu 16.04.1 LTS