卧槽,mysql启动不了了,,排查好久还是不行

hldbkkew

docker跑的mysql,,fqd帮忙看下

2023-07-12T02:22:13.451832649Z 2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:22:13.649282410Z 2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:22:13.657589728Z 2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:22:13.830518212Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:22:14.001969205Z 2023-07-12T02:22:13.999226Z 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-12T02:22:14.001988572Z 2023-07-12T02:22:13.999241Z 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-12T02:22:14.002005635Z 2023-07-12T02:22:13.999245Z 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-12T02:22:14.002008460Z 2023-07-12T02:22:13.999260Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:22:14.002010684Z 2023-07-12T02:22:13.999272Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-12T02:22:14.002012568Z 2023-07-12T02:22:14.000144Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: location is accessible to all OS users. Consider choosing a different directory.
2023-07-12T02:22:14.002014481Z 2023-07-12T02:22:14.000178Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:22:14.778839922Z 2023-07-12T02:22:14.778660Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-12T02:38:55.642015975Z 2023-07-12 02:38:55+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:38:55.843810885Z 2023-07-12 02:38:55+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:38:55.851698545Z 2023-07-12 02:38:55+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:38:56.028181486Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:38:56.207121749Z 2023-07-12T02:38:56.204049Z 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-12T02:38:56.207150254Z 2023-07-12T02:38:56.204066Z 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-12T02:38:56.207154301Z 2023-07-12T02:38:56.204071Z 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-12T02:38:56.207157147Z 2023-07-12T02:38:56.204085Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:38:56.207159521Z 2023-07-12T02:38:56.204098Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-12T02:38:56.207162336Z 2023-07-12T02:38:56.205236Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: location is accessible to all OS users. Consider choosing a different directory.
2023-07-12T02:38:56.207164551Z 2023-07-12T02:38:56.205297Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:38:56.394137661Z 2023-07-12T02:38:56.393982Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-12T02:41:25.077172346Z 2023-07-12 02:41:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:41:26.317304877Z 2023-07-12 02:41:26+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:41:26.325838935Z 2023-07-12 02:41:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:41:26.501392859Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:41:26.673532544Z 2023-07-12T02:41:26.670624Z 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-12T02:41:26.673692493Z 2023-07-12T02:41:26.670654Z 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-12T02:41:26.673727931Z 2023-07-12T02:41:26.670659Z 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-12T02:41:26.673731818Z 2023-07-12T02:41:26.670675Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:41:26.673740335Z 2023-07-12T02:41:26.670689Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-12T02:41:26.673743351Z 2023-07-12T02:41:26.670726Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-07-12T02:41:26.673745895Z 2023-07-12T02:41:26.670810Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:41:26.897202989Z 2023-07-12T02:41:26.897006Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-12T02:47:29.006489337Z 2023-07-12 02:47:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:47:29.226627031Z 2023-07-12 02:47:29+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:47:29.237383828Z 2023-07-12 02:47:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:47:29.409320378Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:47:29.580966846Z 2023-07-12T02:47:29.577361Z 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-12T02:47:29.581010659Z 2023-07-12T02:47:29.577380Z 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-12T02:47:29.581014398Z 2023-07-12T02:47:29.577385Z 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-12T02:47:29.581016912Z 2023-07-12T02:47:29.577400Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:47:29.581019116Z 2023-07-12T02:47:29.577435Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-07-12T02:47:29.581034756Z 2023-07-12T02:47:29.577517Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:47:30.560387390Z 2023-07-12T02:47:30.560168Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

a669091781

这不是启动了吗/？

llmllm

[InnoDB] InnoDB initialization has started.
之后就没动了

活跃概况

没看到ERROR ，楼下大佬来

chaoji

直接找DBA

☆飘☆

ps -ef | grep mysql

发出来

苯鸟

ChatGPT的回答

1. 这些日志是MySQL服务器在Docker容器中运行时生成的输出。让我们逐条解释每个日志条目的含义：1. `2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.`   这是MySQL服务器启动时的提示消息，表示MySQL容器的入口脚本已开始运行。2. `2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'`   表示MySQL服务器正在切换到专用用户'mysql'。3. `'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'`   这是一个符号链接操作，将`/var/lib/mysql/mysql.sock`链接到`/var/run/mysqld/mysqld.sock`。它用于与MySQL服务器建立套接字连接。4. `[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.`   这是一个警告消息，指出`--skip-host-cache`语法已过时，并将在未来的版本中被移除。建议使用`SET GLOBAL host_cache_size=0`来替代。5. `[Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.`   这是一个警告消息，指出`thread_stack`选项的无符号值65536已被调整为131072。6. `[Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.`   这是一个警告消息，指出`max_allowed_packet`选项的无符号值107374182400已被调整为1073741824。7. `[Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: location is accessible to all OS users. Consider choosing a different directory.`   这是一个警告消息，指出`--secure-file-priv`的配置存在安全风险，建议选择一个不容易被所有操作系统用户访问的不同目录。8. `[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1`   表示MySQL服务器已经作为进程1开始启动。9. `[System] [MY-013576] [InnoDB] InnoDB initialization has started.`   表示InnoDB存储引擎正在初始化。这些日志提供了MySQL服务器在Docker容器中启动和配置过程中的一些关键信息、警告和提示。

复制代码