Service Mysql ne veut pas demarrer - Yunohost 4.2.6.1

derf81 · July 2, 2021, 8:55am

Bonjour,

Suite a un plantage de mon serveur sous une ancienne version de Yunohost, je viens d’installer la dernière version sur un nouveau serveur.

Je suis sur Freebox Delta en VM avec Debian 10.10 avec YunoHost 4.2.6.1 (stable)
Linux 4.19.0-17-arm64 #1 SMP Debian 4.19.194-2 (2021-06-21) aarch64 GNU/Linux
mysql Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (aarch64) using readline 5.2

Suite a ma nouvelle installation, j’ai seulement le service MYSQL qui ne veut pas ce demarrer.

Voici l’erreur que j’ai : https://paste.yunohost.org/ceyexeqabo

LOGFILE: journalctl
-- Logs begin at Fri 2021-07-02 02:17:24 UTC, end at Fri 2021-07-02 08:07:34 UTC. --
-- No entries --

LOGFILE: /var/log/mysql/error.log
b"2021-06-24  7:43:58 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable"
b"2021-06-24  7:43:58 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable"
b"2021-06-24  7:43:58 0 [ERROR] Plugin 'InnoDB' init function returned error."
b"2021-06-24  7:43:58 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed."
b'2021-06-24  7:43:58 0 [ERROR] Unknown/unsupported storage engine: InnoDB'
b'2021-06-24  7:43:58 0 [ERROR] Aborting'
b''
b'2021-06-24  7:44:01 0 [Note] InnoDB: Using Linux native AIO'
b"2021-06-24  7:44:01 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!"
b'2021-06-24  7:44:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Uses event mutexes'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Number of pools: 1'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Using generic crc32 instructions'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Completed initialization of buffer pool'
b'2021-06-24  7:44:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().'
b"2021-06-24  7:44:01 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ..."
b"2021-06-24  7:44:01 0 [Note] InnoDB: File './ibdata1' size is now 12 MB."
b'2021-06-24  7:44:01 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0'
b'2021-06-24  7:44:01 0 [Note] InnoDB: New log files created, LSN=44897'
b'2021-06-24  7:44:01 0 [Note] InnoDB: Doublewrite buffer not found: creating new'
b'2021-06-24  7:44:02 0 [Note] InnoDB: Doublewrite buffer created'
b'2021-06-24  7:44:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.'
b'2021-06-24  7:44:02 0 [Note] InnoDB: Creating foreign key constraint system tables.'
b'2021-06-24  7:44:02 0 [Note] InnoDB: Creating tablespace and datafile system tables.'
b'2021-06-24  7:44:02 0 [Note] InnoDB: Creating sys_virtual system tables.'
b'2021-06-24  7:44:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables'
b"2021-06-24  7:44:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ..."
b"2021-06-24  7:44:02 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB."
b'2021-06-24  7:44:02 0 [Note] InnoDB: Waiting for purge to start'
b'2021-06-24  7:44:02 0 [Note] InnoDB: 10.3.29 started; log sequence number 0; transaction id 7'
b"2021-06-24  7:44:02 0 [Note] Plugin 'FEEDBACK' is disabled."
b'2021-06-24  7:44:02 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded'
b"2021-06-24  7:44:03 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist"
b"2021-06-24  7:44:03 0 [Note] Server socket created on IP: '127.0.0.1'."
b"2021-06-24  7:44:03 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist"
b'2021-06-25  8:44:45 0 [Note] InnoDB: Using Linux native AIO'
b'2021-06-25  8:44:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins'
b'2021-06-25  8:44:45 0 [Note] InnoDB: Uses event mutexes'
b'2021-06-25  8:44:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11'
b'2021-06-25  8:44:45 0 [Note] InnoDB: Number of pools: 1'
b'2021-06-25  8:44:45 0 [Note] InnoDB: Using generic crc32 instructions'
b'2021-06-25  8:44:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M'
b'2021-06-25  8:44:46 0 [Note] InnoDB: Completed initialization of buffer pool'
b'2021-06-25  8:44:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().'
b'2021-06-25  8:44:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=48579'
b'2021-06-25  8:44:47 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.'
b'2021-06-25  8:44:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.'
b'2021-06-25  8:44:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"'
b'2021-06-25  8:44:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables'
b"2021-06-25  8:44:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ..."
b"2021-06-25  8:44:48 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB."
b'2021-06-25  8:44:48 0 [Note] InnoDB: Waiting for purge to start'
b'2021-06-25  8:44:48 0 [Note] InnoDB: 10.3.29 started; log sequence number 1601327; transaction id 8'
b'2021-06-25  8:44:48 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool'
b"2021-06-25  8:44:48 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory"
b"2021-06-25  8:44:48 0 [Note] Plugin 'FEEDBACK' is disabled."
b'2021-06-25  8:44:48 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded'
b'2021-06-25  8:44:48 0 [Note] Recovering after a crash using tc.log'
b'2021-06-25  8:44:48 0 [Note] Starting crash recovery...'
b'2021-06-25  8:44:48 0 [Note] Crash recovery finished.'
b"2021-06-25  8:44:49 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist"
b"2021-06-25  8:44:49 0 [Note] Server socket created on IP: '127.0.0.1'."
b"2021-06-25  8:44:49 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist"
b'2021-06-30 19:03:38 0 [Note] InnoDB: Using Linux native AIO'
b"2021-06-30 19:03:38 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable"
b"2021-06-30 19:03:38 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable"
b"2021-06-30 19:03:38 0 [ERROR] Plugin 'InnoDB' init function returned error."
b"2021-06-30 19:03:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed."
b"2021-06-30 19:03:38 0 [Note] Plugin 'FEEDBACK' is disabled."
b'2021-06-30 19:03:38 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded'
b'2021-06-30 19:03:38 0 [ERROR] mysqld: File \'/www/server/data/mysql-slow.log\' not found (Errcode: 13 "Permission denied")'
b'2021-06-30 19:03:38 0 [ERROR] Could not use /www/server/data/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.'
b'2021-06-30 19:03:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB'
b'2021-06-30 19:03:38 0 [ERROR] Aborting'

Merci à vous pour votre aide

derf81 · July 5, 2021, 8:43am

Reinstallation de yunohost idem

gannonwoto · July 5, 2021, 12:35pm

Salut,

 InnoDB: The innodb_system data file 'ibdata1' must be writable"

Ca sent le problème de droits. Execute la commande suivante

root@monsrv:~# ls -las /var/lib/ | grep mysql
4 drwxr-xr-x 10 mysql     mysql     4096 Jun 29 16:42 mysql

Si tu n’as pas mysql mysql, la commande suivante pourra aider.

chown -R mysql:mysql /var/lib/mysql

Stop et redémarre ensuite le service mariadb

 systemctl stop mariadb.service
 systemctl start mariadb.service

Reinstallation, en partant d’une VM vierge ? Tu l’installes avec l’iso Yunohost ou tu pars d’une VM Debian déjà existante ?

derf81 · July 5, 2021, 12:54pm

Bonjour gannonwoto,
Merci pour ton retour.

ls -las /var/lib/ | grep mysql
4 drwxr-xr-x 2 mysql mysql 4096 Jul 5 09:27 mysql

Et le start ne fonctionne pas apres avoir fait stop

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.

derf81 · July 5, 2021, 12:56pm

Oui un VM vierge seulement avec Debian 10, version pré-installé sur l’installation de la VM sur ma freebox delta.

gannonwoto · July 5, 2021, 11:28pm

Les “Versions préinstallées” … bref, je viens de faire des petites recherches et il semble pas y avoir de problèmes spécifique avec cela. Je sais pas si quelqu’un qui a une Delta peut nous confirmer que cela fonctionne correctement actuellement.

Tu as bien installé Yunohost, sur cette Debian puis avec un curl https://install.yunohost.org | bash ?
Tu as a ce message quand ? Pendant l’installation ? Ou après avoir installé des applications ?

system · August 4, 2021, 11:28pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.