J'ai depuis quelques temps, un problème avec MariaDB qui ne veut plus démarrer.
En effet quand je veux lancer mon service :
Code : Tout sélectionner
systemctl start mariadb.service
Code : Tout sélectionner
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Code : Tout sélectionner
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since jeu. 2016-11-17 20:37:47 CET; 1min 32s ago
Process: 5174 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 5076 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 5073 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 5174 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Plugin 'InnoDB' init function returned error.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] Plugin 'FEEDBACK' is disabled.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Unknown/unsupported storage engine: InnoDB
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Aborting
nov. 17 20:37:47 archounette systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
nov. 17 20:37:47 archounette systemd[1]: Failed to start MariaDB database server.
nov. 17 20:37:47 archounette systemd[1]: mariadb.service: Unit entered failed state.
nov. 17 20:37:47 archounette systemd[1]: mariadb.service: Failed with result 'exit-code'.
Code : Tout sélectionner
nov. 17 20:37:35 archounette su[5065]: pam_unix(su:session): session opened for user root by (uid=1000)
nov. 17 20:37:45 archounette systemd[1]: Starting MariaDB database server...
-- Subject: L'unité (unit) mariadb.service a commencé à démarrer
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mariadb.service a commencé à démarrer.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 5174 ...
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/var/lib/mysql/aria_log_control'
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Plugin 'Aria' init function returned error.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Using mutexes to ref count buffer pool pages
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: The InnoDB memory heap is disabled
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Compressed tables use zlib 1.2.8
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Using Linux native AIO
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Using SSE crc32 instructions
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Initializing buffer pool, size = 128.0M
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] InnoDB: Completed initialization of buffer pool
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Plugin 'InnoDB' init function returned error.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [Note] Plugin 'FEEDBACK' is disabled.
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Unknown/unsupported storage engine: InnoDB
nov. 17 20:37:47 archounette mysqld[5174]: 2016-11-17 20:37:47 140704702848512 [ERROR] Aborting
nov. 17 20:37:47 archounette systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
nov. 17 20:37:47 archounette systemd[1]: Failed to start MariaDB database server.
-- Subject: L'unité (unit) mariadb.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mariadb.service a échoué, avec le résultat failed.
nov. 17 20:37:47 archounette systemd[1]: mariadb.service: Unit entered failed state.
nov. 17 20:37:47 archounette systemd[1]: mariadb.service: Failed with result 'exit-code'.
Quelqu'un aurait une réponse ?
Merci d'avance pour votre aide et une bonne soirée a vous !
Engelbarte.