#26 Le 19/05/2023, à 15:40
- iznobe
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
@bruno , y a du se glisser un truc pas clair dans le copier coller de ta citation :
sudo apt autoremove --purge ~n^mysql-server ~n^mariadb-serverj ' aurais plus vu :
sudo apt autoremove --purge mysql-server mariadb-server@ CQFD93 , exact , je corrige ...
Dernière modification par iznobe (Le 19/05/2023, à 15:42)
retour COMPLET et utilisable de commande
MSI Z490A-pro , i7 10700 , 32 GB RAM .
En ligne
#27 Le 19/05/2023, à 15:44
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
root@vps93604:/# apt policy php
php:
Installed: (none)
Candidate: 2:8.2+93+ubuntu22.04.1+deb.sury.org+2
Version table:
2:8.2+93+ubuntu22.04.1+deb.sury.org+2 500
500 https://ppa.launchpadcontent.net/ondrej/php/ubuntu jammy/main amd64 Packages
2:8.1+92ubuntu1 500
500 http://archive.ubuntu.com/ubuntu jammy/main amd64 Packages Hors ligne
#28 Le 19/05/2023, à 15:45
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Un problème à la fois ! Pour l'instant on essaie de dépanner le serveur Mysql et la commande la doc est correcte (merci de vérifier avant de répondre)
Le ppa ondrej doit effectivement être viré avec les commandes données! au #19
Pour Moodle cela fonctionnera très bien avec Ubuntu 22.04 et ses paquets officiels (php 8)
Dernière modification par bruno (Le 19/05/2023, à 15:47)
#29 Le 19/05/2023, à 15:56
- iznobe
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
vu le retour de apt policy php , tu es donc sous ubuntu 22.04 , puisque par défaut , la version de PHP des dépôts officiels proposée est la 8.1 :
2:8.1+92ubuntu1 500
500 http://archive.ubuntu.com/ubuntu jammy/main amd64 Packages donc virer le ppa ondrrej , ne peut faire que du bien 
mais je laisse la main , étant plutôt inexpérimenté sur les serveurs .
Dernière modification par iznobe (Le 19/05/2023, à 15:58)
retour COMPLET et utilisable de commande
MSI Z490A-pro , i7 10700 , 32 GB RAM .
En ligne
#30 Le 19/05/2023, à 15:59
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
vu le retour de apt policy php , tu es donc sous ubuntu 22.04
Merci pour le rappel, mais nous le savons depuis le tout premier message :
Je dois installer Moodle sur le serveur Ubuntu 22.04 hébergé chez LWS.
#31 Le 19/05/2023, à 16:30
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
J'ai réinstallé php 8.1 sans ppa ondrej.
J'ai réinstallé proprement mysql.
Je peux enfin voir les logs des erreurs :
root@vps93604:/# cat /var/log/mysql/error.log
2023-05-19T15:20:00.648042Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) initializin
g of server in progress as process 98415
2023-05-19T15:20:00.655791Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-19T15:20:00.661774Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before g
iving up.
2023-05-19T15:20:00.661798Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
2023-05-19T15:20:01.161978Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
2023-05-19T15:20:01.662726Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
2023-05-19T15:20:02.162971Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
2023-05-19T15:20:02.663196Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
2023-05-19T15:20:03.163435Z 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
2023-05-19T15:20:03.163491Z 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
2023-05-19T15:20:03.163503Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error.
You may need to delete the ibdata1 file before trying to start up again.
2023-05-19T15:20:03.163652Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T15:20:03.163669Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You
can remove all files that the server added to it.
2023-05-19T15:20:03.163678Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T15:20:03.164375Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
2023-05-19T15:20:03.714667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) starting as
process 98422
2023-05-19T15:20:03.738605Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-05-19T15:20:03.738704Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T15:20:03.738721Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T15:20:03.739779Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).Hors ligne
#32 Le 19/05/2023, à 16:47
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Vu cette erreur :
The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it. Ok il manquait sans doute cette étape :
sudo mkdir -p /var/lib/mysql
sudo chown mysql:mysql /var/lib/mysqlpuis relancer le service mysql :
sudo systemctl restart mysqlet vérifier son état :
systemctl status mysqlDernière modification par bruno (Le 19/05/2023, à 16:48)
#33 Le 19/05/2023, à 16:56
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Même chose 
Je l'avais déjà vidé, supprimé, créé ce répertoire avant hier
root@vps93604:/# sudo mkdir -p /var/lib/mysql
root@vps93604:/# sudo chown mysql:mysql /var/lib/mysql
root@vps93604:/# sudo systemctl restart mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
root@vps93604:/# systemctl status mysql
x mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Drop-In: /run/systemd/system/service.d
`-zzz-lxc-service.conf
Active: failed (Result: exit-code) since Fri 2023-05-19 17:51:34 CEST; 13s ago
Process: 98835 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
CPU: 11ms
May 19 17:51:34 vps93604 mysql-systemd-start[98835]: MySQL system database not found in /var/lib/mysql. Please run mysql>
May 19 17:51:34 vps93604 systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
May 19 17:51:34 vps93604 systemd[1]: mysql.service: Failed with result 'exit-code'.
May 19 17:51:34 vps93604 systemd[1]: Failed to start MySQL Community Server.
May 19 17:51:34 vps93604 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
May 19 17:51:34 vps93604 systemd[1]: Stopped MySQL Community Server.
May 19 17:51:34 vps93604 systemd[1]: mysql.service: Start request repeated too quickly.
May 19 17:51:34 vps93604 systemd[1]: mysql.service: Failed with result 'exit-code'.
May 19 17:51:34 vps93604 systemd[1]: Failed to start MySQL Community Server.
lines 1-17/17 (END)
Hors ligne
#34 Le 19/05/2023, à 17:01
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Et que disent les logs maintenant ?
L'erreur est explicite mais la ligne est coupée :
MySQL system database not found in /var/lib/mysql. Please run mysql>Dernière modification par bruno (Le 19/05/2023, à 17:08)
#35 Le 19/05/2023, à 17:04
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Même chose
root@vps93604:/# cat /var/log/mysql/error.log
2023-05-19T15:20:00.648042Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) initializin
g of server in progress as process 98415
2023-05-19T15:20:00.655791Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-19T15:20:00.661774Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before g
iving up.
2023-05-19T15:20:00.661798Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
2023-05-19T15:20:01.161978Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
2023-05-19T15:20:01.662726Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
2023-05-19T15:20:02.162971Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
2023-05-19T15:20:02.663196Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
2023-05-19T15:20:03.163435Z 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
2023-05-19T15:20:03.163491Z 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
2023-05-19T15:20:03.163503Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error.
You may need to delete the ibdata1 file before trying to start up again.
2023-05-19T15:20:03.163652Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T15:20:03.163669Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You
can remove all files that the server added to it.
2023-05-19T15:20:03.163678Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T15:20:03.164375Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
2023-05-19T15:20:03.714667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) starting as
process 98422
2023-05-19T15:20:03.738605Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-05-19T15:20:03.738704Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T15:20:03.738721Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T15:20:03.739779Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
root@vps93604:/# Hors ligne
#36 Le 19/05/2023, à 17:06
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
L'erreur est explicite mais la ligne est coupée :
MySQL system database not found in /var/lib/mysql. Please run mysql>Je suppose que cela demande d’exécuter :
mysqld --initialize#37 Le 19/05/2023, à 17:12
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
root@vps93604:/# cat /var/log/mysql/error.log
2023-05-19T15:20:00.648042Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) initializin
g of server in progress as process 98415
2023-05-19T15:20:00.655791Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-19T15:20:00.661774Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before g
iving up.
2023-05-19T15:20:00.661798Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
2023-05-19T15:20:01.161978Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
2023-05-19T15:20:01.662726Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
2023-05-19T15:20:02.162971Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
2023-05-19T15:20:02.663196Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
2023-05-19T15:20:03.163435Z 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
2023-05-19T15:20:03.163491Z 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
2023-05-19T15:20:03.163503Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error.
You may need to delete the ibdata1 file before trying to start up again.
2023-05-19T15:20:03.163652Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T15:20:03.163669Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You
can remove all files that the server added to it.
2023-05-19T15:20:03.163678Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T15:20:03.164375Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
2023-05-19T15:20:03.714667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) starting as
process 98422
2023-05-19T15:20:03.738605Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-05-19T15:20:03.738704Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T15:20:03.738721Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T15:20:03.739779Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
2023-05-19T16:08:25.308685Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) initializin
g of server in progress as process 99422
2023-05-19T16:08:25.311336Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it.
Aborting.
2023-05-19T16:08:25.311392Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You
can remove all files that the server added to it.
2023-05-19T16:08:25.311469Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T16:08:25.311676Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
2023-05-19T16:09:59.910916Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) initializin
g of server in progress as process 99516
2023-05-19T16:09:59.913324Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it.
Aborting.
2023-05-19T16:09:59.913357Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You
can remove all files that the server added to it.
2023-05-19T16:09:59.913408Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T16:09:59.913563Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu). Hors ligne
#38 Le 19/05/2023, à 17:14
- iznobe
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
et cette erreur :
2023-05-19T15:20:03.163503Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error.
You may need to delete the ibdata1 file before trying to start up again. retour COMPLET et utilisable de commande
MSI Z490A-pro , i7 10700 , 32 GB RAM .
En ligne
#39 Le 19/05/2023, à 17:15
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
C'est pas cohérent du tout ces retours… On dirait que le répertoire /var/lib/mysql n'est pas récréé entre chaque tentative.
Refait strictement ces commandes :
sudo apt autoremove --purge ~n^mysql-server ~n^mariadb-serversudo rm -rf /var/lib/mysql
sudo rm -rf /etc/mysql
sudo mkdir -p /etc/mysql/conf.d
sudo apt cleansudo apt install mysql-serverNormalement cela devrait fonctionner.
Dernière modification par bruno (Le 19/05/2023, à 17:23)
#40 Le 19/05/2023, à 17:34
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Fait pour la nième fois.
Déjà des erreurs pendants l'installation :
root@vps93604:/# sudo apt install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
libaio1 libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7 libfcgi-bin
libfcgi-perl libfcgi0ldbl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl
libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmecab2 libnuma1 libprotobuf-lite23 libtimedate-perl
liburi-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common
mysql-server-8.0 mysql-server-core-8.0
Suggested packages:
libdata-dump-perl libipc-sharedcache-perl libbusiness-isbn-perl libwww-perl mailx tinyca
The following NEW packages will be installed:
libaio1 libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7 libfcgi-bin
libfcgi-perl libfcgi0ldbl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl
libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmecab2 libnuma1 libprotobuf-lite23 libtimedate-perl
liburi-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common
mysql-server mysql-server-8.0 mysql-server-core-8.0
0 upgraded, 30 newly installed, 0 to remove and 0 not upgraded.
Need to get 29.6 MB of archives.
After this operation, 243 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://archive.ubuntu.com/ubuntu jammy/main amd64 mysql-common all 5.8+1.0.8 [7212 B]
Get:2 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 mysql-client-core-8.0 amd64 8.0.33-0ubuntu0.22.04.2 [2802
kB]
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service -> /lib/systemd/system/mysql.service.
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
invoke-rc.d: initscript mysql, action "start" failed.
* mysql.service - MySQL Community Server
Loaded: loaded (;;file://vps93604/lib/systemd/system/mysql.service/lib/systemd/system/mysql.service;;; enabled; vend
or preset: enabled)
Drop-In: /run/systemd/system/service.d
`-;;file://vps93604/run/systemd/system/service.d/zzz-lxc-service.confzzz-lxc-service.conf;;
Active: activating (auto-restart) (Result: exit-code) since Fri 2023-05-19 18:19:24 CEST; 6ms ago
Process: 100351 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
CPU: 9ms
May 19 18:19:24 vps93604 systemd[1]: mysql.service: Failed with result 'exit-code'.
May 19 18:19:24 vps93604 systemd[1]: Failed to start MySQL Community Server.
dpkg: error processing package mysql-server-8.0 (--configure):
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Setting up libcgi-pm-perl (4.54-1) ...
Setting up libhtml-template-perl (2.97-1.1) ...
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-8.0; however:
Package mysql-server-8.0 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Setting up libcgi-fast-perl (1:2.15-1) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
Errors were encountered while processing:
mysql-server-8.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)Erreurs logs :
root@vps93604:/# cat /var/log/mysql/error.log
2023-05-19T16:19:21.189909Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) initializin
g of server in progress as process 100250
2023-05-19T16:19:21.199634Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-19T16:19:21.204977Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before g
iving up.
2023-05-19T16:19:21.204999Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
2023-05-19T16:19:21.705211Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
2023-05-19T16:19:22.205496Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
2023-05-19T16:19:22.705751Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
2023-05-19T16:19:23.205998Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
2023-05-19T16:19:23.706252Z 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
2023-05-19T16:19:23.706305Z 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
2023-05-19T16:19:23.706318Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error.
You may need to delete the ibdata1 file before trying to start up again.
2023-05-19T16:19:23.706442Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T16:19:23.706482Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You
can remove all files that the server added to it.
2023-05-19T16:19:23.706491Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T16:19:23.707217Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu).
2023-05-19T16:19:24.248158Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) starting as
process 100257
2023-05-19T16:19:24.270122Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-05-19T16:19:24.270239Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-19T16:19:24.270255Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-19T16:19:24.271260Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.2
2.04.2) (Ubuntu). Le tuto de Moodle demande de déplacer les dossiers tuto instal moodle
J'ai pensé que ceci peut être la cause, mais j'ai supprime tout le Moodle depuis.
Je continue à penser que c'est le serveur distant LWS met les restrictions.
Hors ligne
#41 Le 19/05/2023, à 19:12
- iznobe
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
je vois pas comment les problemes de dependances seraient liés a des restrictions du serveur , y a plutot fort a parie que c' est a cause du ppa ondrej .
retour COMPLET et utilisable de commande
MSI Z490A-pro , i7 10700 , 32 GB RAM .
En ligne
#42 Le 19/05/2023, à 19:19
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
je vois pas comment les problemes de dependances seraient liés a des restrictions du serveur , y a plutot fort a parie que c' est a cause du ppa ondrej .
ppa ondrej a été bien eliminé, supprimé, purgé
php 8.1 réinstallé sans ppa ondrej
Hors ligne
#43 Le 19/05/2023, à 19:20
- xubu1957
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Montre aussi d'éventuels paquets cassés :
dpkg -l | grep -v ^iiet
apt list ?obsolete... histoire de vérifier la présence éventuelle de paquets "orphelins".
Conseils pour les nouveaux demandeurs et pas qu'eux
Important : Pensez à passer vos sujets en [Réso|u] lorsque ceux-ci le sont, au début du titre en cliquant sur Modifier sous le premier message, et un bref récapitulatif de la solution à la fin de celui-ci. Merci. Membre de Linux-Azur
En ligne
#44 Le 19/05/2023, à 19:23
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
root@vps93604:/# dpkg -l | grep -v ^ii
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-=================================-=======================================-============-==============================
==================================================
ic mariadb-client-10.6 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database client binari
es
ic mariadb-common 1:10.6.12-0ubuntu0.22.04.1 all MariaDB common configuration f
iles
iU mysql-server 8.0.33-0ubuntu0.22.04.2 all MySQL database server (metapac
kage depending on the latest version)
iF mysql-server-8.0 8.0.33-0ubuntu0.22.04.2 amd64 MySQL database server binaries
and system database setup root@vps93604:/# apt list ?obsolete
Listing... Done Hors ligne
#45 Le 19/05/2023, à 19:28
- xubu1957
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Je laisse la main aux spécialistes.
Conseils pour les nouveaux demandeurs et pas qu'eux
Important : Pensez à passer vos sujets en [Réso|u] lorsque ceux-ci le sont, au début du titre en cliquant sur Modifier sous le premier message, et un bref récapitulatif de la solution à la fin de celui-ci. Merci. Membre de Linux-Azur
En ligne
#46 Le 19/05/2023, à 19:37
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Je pense je vais réinstaller Ubuntu sur le serveur
Et installer tout proprement à nouveau
https://i.ibb.co/RCsy5cC/reinstal.png
(modération :taille de l'image !)
Hors ligne
#47 Le 19/05/2023, à 19:40
- bruno
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Arrête de suivre ce tuto qui n'est pas adapté et te fait probablement faire n'importe quoi.
Si tu refais un installation propre du serveur VPS, il faudra d'abord installer la pile lamp e suivant la doc donnée en lien. Et lorsque tous les services fonctionnent, utiliser la doc officielle de Moodle.
Dernière modification par bruno (Le 19/05/2023, à 19:44)
#48 Le 19/05/2023, à 19:56
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Nan, il veut pas...:)
Je rigole maintenant...
Logs erreurs les mêmes.
---
Je vais réinstaller le serveur, mais demain, j'en ai assez pour aujourd'hui.
Je ne sais pas s'il y aura qqun ici demain, un bon we à tout le monde en tous les cas.
Hors ligne
#49 Le 21/05/2023, à 15:07
- olamoi
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Bonjour,
J'ai réinstallé le serveur.
Puis j'ai suivi l installation de lamp comme dans le tuto :
sudo apt install apache2 php libapache2-mod-php mysql-server php-mysql
sudo apt install php-curl php-gd php-intl php-json php-mbstring php-xml php-zipPhp ok, apache ok.
Mysql - toujours la même erreur et les mêmes logs erreur...
J'ai réinstallé a nouveau le serveur et installé que mysql server.
Pareil...
J'ai ouvert un ticket chez le support LWS.
Hors ligne
#50 Le 22/05/2023, à 08:14
- manoaratefy
Re : RESOLU. Start request repeated too quickly. Failed start MySQL Server.
Bonjour,
Vu que c'est du LXC, tu ne peux pas modifier les paramètres du kernel, or ton log indique que le moteur InnoDB tente de faire ça :
2023-05-19T15:20:00.661798Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.Je te recommande de mettre ceci dans ton fichier de configuration MySQL pour palier à ce problème (j'ignore si c'est /etc/mysql/my.cnf ou un autre chemin) :
innodb_use_native_aio = 0C'est valable pour tous les fournisseurs VPS qui utilisent LXC, et tous les conteneurs Docker non privilégiés.
Hors ligne