Mariadb/MySQL数据库不断失败

x8goxv8g  于 2023-10-20  发布在  Mysql
关注(0)|答案(1)|浏览(202)

希望你能帮忙。我的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
dz6r00yl

dz6r00yl1#

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'

这意味着另一个mariadb示例已经在同一个datadir上运行。
正在使用的service/init脚本无法充分保护数据。Systemd服务做得很好。

[ERROR] InnoDB: Cannot open datafile for read-only: './meta01_hemp/wp_commentmeta.ibd' OS error: 71
[ERROR] InnoDB: Operating system error number 2 in a file operation.
[ERROR] InnoDB: The error means the system cannot find the path specified.

这意味着它期望一个innodb文件存在,但它不存在。在同一个datadir上运行的两个进程可能损坏了某些东西。
首先查找现有的mysqld进程并彻底关闭它们。
InnoDB增加了更强大的保护功能,可以防止在MDEV-31568(10.5.22+)中运行多个版本。

相关问题