[QUESTION] MySQL8.0安装后容器重复启动，无法正常使用

[SMGoro]

请描述您的问题

1Panel v1.3.6版本安装MySQL8.0正常，但一段时间后MySQL8的容器就进入循环重启状态

报错：

服务内部错误: OCI runtime exec failed: exec failed: cannot exec in a stopped container: unknown

服务内部错误: cannot exec in a stopped state: unknown

服务内部错误: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

容器日志（循环重复以下内容）：

2023-07-11T10:12:13.204885Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-11T10:12:13.206612Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-07-11T10:12:13.206639Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33) starting as process 1
2023-07-11T10:12:13.207961Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-07-11T10:12:13.231835Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-11T10:12:13.300569Z 1 [ERROR] [MY-012962] [InnoDB] The redo log file ./#innodb_redo/#ib_redo11 size 827392 is not a multiple of innodb_page_size
2023-07-11T10:12:13.300608Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-07-11T10:12:13.755570Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-07-11T10:12:13.755766Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-07-11T10:12:13.755800Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-07-11T10:12:13.757668Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33)  MySQL Community Server - GPL.
2023-07-11 10:13:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
2023-07-11 10:13:14+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-11 10:13:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

使用其他机子，重装等都会有这个问题，复现率几乎100%

将mysql的data文件全部删除后暂时会恢复正常，但是过一段时间又会这样

[wanghe-fit2cloud]

感谢反馈。 麻烦提供一下你的服务器配置，我们先在本地环境复现一下。

我们在测试环境中安装的 Halo 就是使用的 MySQL 8.0 版本，稳定运行并没有复现上述问题。

服务器是 CentOS 7.9，x86_64 架构

[SMGoro]

服务器配置： PVE 7.4-15 使用Ubuntu20.04 LXC x86_64架构 进行运行

root@IMCSQL:~# neofetch
            .-/+oossssoo+/-.               root@IMCSQL 
        `:+ssssssssssssssssss+:`           ----------- 
      -+ssssssssssssssssssyyssss+-         OS: Ubuntu 20.04.6 LTS x86_64 
    .ossssssssssssssssssdMMMNysssso.       Host: SA5112M5 00001 
   /ssssssssssshdmmNNmmyNMMMMhssssss/      Kernel: 5.13.19-6-pve 
  +ssssssssshmydMMMMMMMNddddyssssssss+     Uptime: 5 days, 18 hours, 44 mins 
 /sssssssshNMMMyhhyyyyhmNMMMNhssssssss/    Packages: 481 (dpkg) 
.ssssssssdMMMNhsssssssssshNMMMdssssssss.   Shell: bash 5.0.17 
+sssshhhyNMMNyssssssssssssyNMMMysssssss+   Resolution: 1024x768 
ossyNMMMNyMMhsssssssssssssshmmmhssssssso   Terminal: /dev/tty1 
ossyNMMMNyMMhsssssssssssssshmmmhssssssso   CPU: Intel Xeon Platinum 8222L (2) @ 3.500GHz 
+sssshhhyNMMNyssssssssssssyNMMMysssssss+   GPU: 03:00.0 ASPEED Technology, Inc. ASPEED Graphics Family 
.ssssssssdMMMNhsssssssssshNMMMdssssssss.   Memory: 355MiB / 4096MiB 
 /sssssssshNMMMyhhyyyyhdNMMMNhssssssss/
  +sssssssssdmydMMMMMMMMddddyssssssss+                             
   /ssssssssssshdmNNNNmyNMMMMhssssss/                              
    .ossssssssssssssssssdMMMNysssso.
      -+sssssssssssssssssyyyssss+-
        `:+ssssssssssssssssss+:`
            .-/+oossssoo+/-.

分配资源：4c4g 40G硬盘 MySQL配置：

[mysqld]
skip-host-cache
skip-name-resolve
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
secure-file-priv=/var/lib/mysql-files
user=mysql


character_set_server=utf8
lower_case_table_names=1
group_concat_max_len=1024000
log_bin_trust_function_creators=1

pid-file=/var/run/mysqld/mysqld.pid
key_buffer_size=128M
tmp_table_size=64M
innodb_buffer_pool_size=256M
innodb_log_buffer_size=1024K
sort_buffer_size=768K
read_buffer_size=768K
read_rnd_buffer_size=512K
join_buffer_size=1024K
thread_stack=256K
binlog_cache_size=64K
thread_cache_size=64
table_open_cache=128
max_connections=100
[client]
socket=/var/run/mysqld/mysqld.sock

!includedir /etc/mysql/conf.d/

报错截图

[wanghe-fit2cloud]

可能跟你自行添加的 my.cnf 配置有关系，你可以先根据这些后期添加的配置项再辅助错误日志来分析定位一下问题。

[SMGoro]

初始配置也不可以，就是因为初始配置不行所以才更改的mysql配置。

尝试过删除sock文件，无效；更改调整配置文件，无效；重装mysql，无效；

目前唯一已知有效操作是删除data内所有文件，但是对日常使用影响很大。

[yzx1208]

1.9.2 centos7.9 报错 ls: cannot access '/docker-entrypoint-initdb.d/': Operation not permitted mysql8 | 2024-01-09 18:54:10+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started. mysql8 | 2024-01-09 18:54:10+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' mysql8 | 2024-01-09 18:54:10+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.