error in mysql
[root@server ~]# systemctl status mysqld
Warning: The unit file, source configuration file or drop-ins of mariadb.service changed on disk. Run 'systemctl daemon-reload' to reload units.
● mariadb.service - MariaDB 10.5.27 database server
Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Sat 2025-01-11 16:28:39 +03; 2min 54s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 494849 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 494839 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environm>
Process: 494837 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 494849 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [Note] InnoDB: Starting shutdown...
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [Note] Plugin 'FEEDBACK' is disabled.
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". So>
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 11 16:28:39 server.fliershare.com mariadbd[494849]: 2025-01-11 16:28:39 0 [ERROR] Aborting
Jan 11 16:28:39 server.fliershare.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 11 16:28:39 server.fliershare.com systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 11 16:28:39 server.fliershare.com systemd[1]: Failed to start MariaDB 10.5.27 database server.
[root@server ~]#
-
Hey there! When a service fails like this, it's best to check the log to see if there are more details. By default, the MySQL log is created at /var/log/mysqld.log - can you check that file to see if there is anything helpful there?
0
Please sign in to leave a comment.
Comments
1 comment