Bonjour,
il s'agit d'une config cluster avec trois nœuds, ci-joint log d'erreur si vous pouvez m'aider à l’interpréter.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 mariadb.service - MariaDB 10.1.41 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Mon 2019-11-18 23:09:46 CET; 56s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 1195 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 918 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment Process: 814 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 746 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 1195 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" nov. 18 23:09:08 imsbd1 systemd[1]: Starting MariaDB 10.1.41 database server... nov. 18 23:09:12 imsbd1 sh[918]: WSREP: Recovered position 799e5e93-c114-11e9-a611-dac237d8b112:9080 nov. 18 23:09:12 imsbd1 mysqld[1195]: 2019-11-18 23:09:12 140573700537472 [Note] /usr/sbin/mysqld (mysqld 10.1.41-MariaDB-0ubuntu0.18.04.1) starting as process 1 nov. 18 23:09:46 imsbd1 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE nov. 18 23:09:46 imsbd1 systemd[1]: mariadb.service: Failed with result 'exit-code'. nov. 18 23:09:46 imsbd1 systemd[1]: Failed to start MariaDB 10.1.41 database server.
Après la suppression des fichiers suivants, il reste une erreur innodb
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3 # mv /var/lib/mysql/aria_log_control /var/lib/mysql/backup-aria_log # mv /var/lib/mysql/ibdata1 /var/lib/mysql/backupibdata1
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6 nov. 19 09:27:32 imsdb3 sh[1490]: 2019-11-19 9:27:32 140551901514880 [Note] InnoDB: Restoring page 0 of tablespace 0 nov. 19 09:27:32 imsdb3 sh[1490]: 2019-11-19 9:27:32 140551901514880 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0 nov. 19 09:27:32 imsdb3 sh[1490]: 2019-11-19 9:27:32 140551901514880 [ERROR] InnoDB: space header page consists of zero bytes in data file ./ibdata1 nov. 19 09:27:32 imsdb3 sh[1490]: 2019-11-19 9:27:32 140551901514880 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system nov. 19 09:27:32 imsdb3 sh[1490]: 2019-11-19 9:27:32 140551901514880 [ERROR] Plugin 'InnoDB' init function returned error.
Partager