希望你能帮忙。我的Mariadb/MySQL数据库一直失败,日志中有此消息:
===============
Service Error
(XID fseu38) The “mysql” service failed to start.
Startup Log
Starting MariaDB.230914 21:53:41 mysqld_safe Logging to '/var/lib/mysql/gla.glassheadz.com.err'.
230914 21:53:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
.........../etc/init.d/mysql: line 264: kill: (31815) - No such process
ERROR!
=================
第64行是这段代码的一部分:
wait_for_ready () {
i=0
while test $i -ne $service_startup_timeout ; do
if $bindir/mysqladmin ping >/dev/null 2>&1; then
log_success_msg
return 0
elif kill -0 $! ; then
: # mysqld_safe is still running
else
# mysqld_safe is no longer running, abort the wait loop
break
fi
echo $echo_n ".$echo_c"
i=`expr $i + 1`
sleep 1
done
如果你尝试加载一个网站,如goodinthehead.com,你会看到Error establishing database connection
问题解决后,重新启动,但错误再次发生后,一两天,所以它可能会或可能不会工作,当你尝试它。
我还没有熟练到可以试着破译错误...
摘自https://glassheadz.com/error.html
2023-09-01 2:04:42 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2023-09-01 2:05:13 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2023-09-01 2:05:13 0 [ERROR] Plugin 'Aria' init function returned error.
2023-09-01 2:05:13 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-09-01 2:05:13 0 [Note] InnoDB: Using Linux native AIO
2023-09-01 2:05:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-09-01 2:05:13 0 [Note] InnoDB: Uses event mutexes
2023-09-01 2:05:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-09-01 2:05:13 0 [Note] InnoDB: Number of pools: 1
2023-09-01 2:05:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-09-01 2:05:13 0 [Note] InnoDB: Initializing buffer pool, total size = 110M, instances = 1, chunk size = 110M
2023-09-01 2:05:13 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-01 2:05:13 0 [Note] InnoDB: page_cleaner coordinator priority: -20
2023-09-01 2:05:13 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2023-09-01 2:05:13 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2023-09-01 2:05:13 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2023-09-01 2:05:13 0 [ERROR] InnoDB: Cannot open datafile for read-only: './meta01_hemp/wp_commentmeta.ibd' OS error: 71
2023-09-01 2:05:13 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2023-09-01 2:05:13 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2023-09-01 2:05:13 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2023-09-01 2:05:13 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``meta01_hemp`.`wp_commentmeta``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2023-09-01 2:05:13 0 [Warning] InnoDB: Ignoring tablespace for `meta01_hemp`.`wp_commentmeta` because it could not be opened.
....
2023-09-01 2:05:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-09-01 2:05:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-09-01 2:05:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-09-01 2:05:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-09-01 2:05:13 0 [Note] InnoDB: Waiting for purge to start
2023-09-01 2:05:13 0 [Note] InnoDB: 10.3.27 started; log sequence number 3938880214; transaction id 64368475
2023-09-01 2:05:13 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-09-01 2:05:13 0 [Note] InnoDB: Buffer pool(s) load completed at 230901 2:05:13
2023-09-01 2:05:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-09-01 2:05:13 0 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2023-09-01 2:05:13 0 [ERROR] Aborting
1条答案
按热度按时间dz6r00yl1#
这意味着另一个mariadb示例已经在同一个datadir上运行。
正在使用的service/init脚本无法充分保护数据。Systemd服务做得很好。
这意味着它期望一个innodb文件存在,但它不存在。在同一个datadir上运行的两个进程可能损坏了某些东西。
首先查找现有的
mysqld
进程并彻底关闭它们。InnoDB增加了更强大的保护功能,可以防止在MDEV-31568(10.5.22+)中运行多个版本。