Contenu | Rechercher | Menus

Annonce

Si vous avez des soucis pour rester connecté, déconnectez-vous puis reconnectez-vous depuis ce lien en cochant la case
Me connecter automatiquement lors de mes prochaines visites.

À propos de l'équipe du forum.

#1 Le 12/11/2017, à 15:57

gotcha5832

serveur mysql impossible à démarrer.

J'ai un petit serveur de dev chez ovh avec un ubuntu16,php7,mariadb

Lors de son premier redemarrage je n'arrivais plus à me reconnecter
Ayant eu ce souci je savais que j'avais un souci qu'il faudrait que je regarde un jour repoussant le prochain redemarrage.

au redemarrage le l'ovhgate je n'ai plus aucune base.
Je decide pour pas perdre de temps de directemt les importer depuis un mysqldump du serveur de prod.

Je fais de sauvegarde et me dis que je vais redemarrer et voir.

en redemarrant mon serveur il m'est impossible d'accéder d'ouvrir un session sous phpmyadmin

#2002 - No such file or directory<br />Le serveur ne répond pas (ou l'interface de connexion vers le serveur MySQL local n'est pas correctement configurée).
La connexion au controluser tel que défini dans votre configuration a échoué.

J'essaye de redemmarer mysql

$ 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.

Voici le retour des deux commandes

moi@vps007:/var/lib/mysql$ systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: failed (Result: exit-code) since Sun 2017-11-12 14:21:22 CET; 1min 29s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 2054 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: [61B blob data]
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: 
Nov 12 14:21:22 vps007 mysql[2054]:    ...fail!
Nov 12 14:21:22 vps007 systemd[1]: mysql.service: Control process exited, code=exited status=1
Nov 12 14:21:22 vps007 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Nov 12 14:21:22 vps007 systemd[1]: mysql.service: Unit entered failed state.
Nov 12 14:21:22 vps007 systemd[1]: mysql.service: Failed with result 'exit-code'.

moi@vps007:/var/lib/mysql$ journalctl -xe
-- 
-- Unit mysql.service has begun starting up.
Nov 12 14:20:52 vps007 mysql[2054]:  * Starting MariaDB database server mysqld
Nov 12 14:20:52 vps007 mysqld_safe[2223]: Starting mysqld daemon with databases from /var/lib/mysql
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] /usr/sbin/mysqld (mysqld 10.0.31-MariaDB-0ubuntu0.16.04.2) starting as process 2227 ...
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13 "Permission denied")
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Plugin 'Aria' init function returned error.
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Nov 12 14:20:52 vps007 mysqld[2228]: 
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: The InnoDB memory heap is disabled
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Compressed tables use zlib 1.2.8
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Using Linux native AIO
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Using CPU crc32 instructions
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] InnoDB: Completed initialization of buffer pool
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] InnoDB: The system tablespace must be writable!
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Plugin 'InnoDB' init function returned error.
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] Plugin 'FEEDBACK' is disabled.
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Unknown/unsupported storage engine: InnoDB
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [ERROR] Aborting
Nov 12 14:20:52 vps007 mysqld[2228]: 
Nov 12 14:20:52 vps007 mysqld[2228]: 171112 14:20:52 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 12 14:20:52 vps007 mysqld[2228]: 
Nov 12 14:20:52 vps007 mysqld_safe[2241]: mysqld from pid file /var/run/mysqld/mysqld.pid ended
cd Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: [61B blob data]
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 12 14:21:22 vps007 /etc/init.d/mysql[2521]: 
Nov 12 14:21:22 vps007 mysql[2054]:    ...fail!
Nov 12 14:21:22 vps007 systemd[1]: mysql.service: Control process exited, code=exited status=1
Nov 12 14:21:22 vps007 sudo[2022]: pam_unix(sudo:session): session closed for user root
Nov 12 14:21:22 vps007 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysql.service has failed.
-- 
-- The result is failed.
Nov 12 14:21:22 vps007 systemd[1]: mysql.service: Unit entered failed state.
Nov 12 14:21:22 vps007 systemd[1]: mysql.service: Failed with result 'exit-code'.
Nov 12 14:21:51 vps007 kernel: [UFW BLOCK] IN=ens3 OUT= […]

j'ai aussi essayé un mysql_upgrade

moi@vps007:/var/lib/mysql$ mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed

du coup je suis bloqué
auriez vous une idée?

Hors ligne

#2 Le 13/11/2017, à 02:45

gotcha5832

Re : serveur mysql impossible à démarrer.

j'ai trouvé /var/lib/mysql etait own et grp by root
une fois passé en chown/chgrp mysql c'est bon

Mais pourquoi le dossier était il passé en root?? mystere

Et désormais phpmyadmin est extrement lent.

Dernière modification par gotcha5832 (Le 13/11/2017, à 03:33)

Hors ligne