服务器断电后MariaDB服务器启动问题

fsi0uk1n  于 2022-11-08  发布在  其他
关注(0)|答案(1)|浏览(387)

工作站因明显断电而停机后,我的工作MariaDB服务器无法启动。任何连接MySQL的尝试都将失败,并显示:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2),下面是我在错误日志中找到的相关输出:

2022-08-10 23:53:05 0 [ERROR] Couldn't load plugins from 'auth_gssapi.so'.
2022-08-10 23:53:05 0 [ERROR] mysqld: Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb19/plugin/ha_connect.so' (errno: 22, cannot open shared object file: No such file or directory)
2022-08-10 23:53:05 0 [ERROR] Couldn't load plugins from 'ha_connect.so'.
2022-08-10 23:53:05 0 [ERROR] mysqld: Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb19/plugin/cracklib_password_check.so' (errno: 22, cannot open shared object file: No such file or directory)
2022-08-10 23:53:05 0 [ERROR] Couldn't load plugins from 'cracklib_password_check.so'.
2022-08-10 23:53:05 0 [ERROR] mysqld: Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb19/plugin/ha_oqgraph.so' (errno: 22, cannot open shared object file: No such file or directory)
2022-08-10 23:53:05 0 [ERROR] Couldn't load plugins from 'ha_oqgraph.so'.
2022-08-10 23:53:05 0 [ERROR] mysqld: Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb19/plugin/ha_rocksdb.so' (errno: 22, cannot open shared object file: No such file or directory)
2022-08-10 23:53:05 0 [ERROR] Couldn't load plugins from 'ha_rocksdb.so'.
2022-08-10 23:53:05 0 [ERROR] mysqld: Can't open shared library '/usr/lib/x86_64-linux-gnu/mariadb19/plugin/ha_tokudb.so' (errno: 22, cannot open shared object file: No such file or directory)
2022-08-10 23:53:05 0 [ERROR] Couldn't load plugins from 'ha_tokudb.so'.
2022-08-10 23:53:05 0 [Note] InnoDB: Using Linux native AIO
2022-08-10 23:53:05 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-08-10 23:53:05 0 [Note] InnoDB: Uses event mutexes
2022-08-10 23:53:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-10 23:53:05 0 [Note] InnoDB: Number of pools: 1
2022-08-10 23:53:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-10 23:53:05 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-08-10 23:53:05 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-10 23:53:05 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-08-10 23:53:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-10 23:53:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-10 23:53:05 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-10 23:53:05 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-08-10 23:53:05 0 [Note] InnoDB: Waiting for purge to start
2022-08-10 23:53:05 0 [Note] InnoDB: 10.3.34 started; log sequence number 2938465608; transaction id 4388264
2022-08-10 23:53:05 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-08-10 23:53:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-10 23:53:05 0 [Note] Recovering after a crash using tc.log
2022-08-10 23:53:05 0 [ERROR] Recovery failed! You must enable all engines that were enabled at the moment of the crash
2022-08-10 23:53:05 0 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start mysqld with --tc-heuristic-recover={commit|rollback}
2022-08-10 23:53:05 0 [ERROR] Can't init tc log
2022-08-10 23:53:05 0 [ERROR] Aborting

我已经尝试了sudo mysqld_safe --skip-grant-tables和设置innodb_force_recovery=1;两者都产生类似的错误日志。
这里可能有什么问题?我的数据库丢失了吗?

pvabu6sv

pvabu6sv1#

MariaDB软件包已经升级,但是相关的插件没有安装,这使得守护进程无法启动,正如问题注解中所提到的。强烈建议您按照注解中所述,准备一个备用电源解决方案,我还在特定的时间间隔启动了一个自动DB备份脚本。

相关问题