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

查看 44|回复 3
作者:AYrm   
docker跑的mysql,,mjj帮忙看下
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.

好久, option, thread_stack

helloloc   
这不是启动了吗/?
AYrm
OP
  

helloloc 发表于 2023-7-12 10:55
这不是启动了吗/?

[InnoDB] InnoDB initialization has started.
之后就没动了
whl32   
没看到ERROR ,楼下大佬来
您需要登录后才可以回帖 登录 | 立即注册

返回顶部