本帖最后由 堡塔运维小林 于 2023-5-14 12:12 编辑
为了能快速了解并处理您的问题，请提供以下基础信息：
7.9.10
centos 7
mysql8.0无法启动
[root@wj2zd /]# cat /www/server/data/*.err|grep -i -C 10 error
2023-05-07T12:03:39.091060Z 0 [Warning] [MY-000081] [Server] option 'max_allowe d_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-05-07T12:03:39.091147Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'N O_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-05-07T12:03:39.091259Z 0 [System] [MY-010116] [Server] /www/server/mysql/b in/mysqld (mysqld 8.0.24) starting as process 18486
2023-05-07T12:03:39.104295Z 1 [System] [MY-013576] [InnoDB] InnoDB initializati on has started.
2023-05-07T12:03:39.433041Z 1 [System] [MY-013577] [InnoDB] InnoDB initializati on has ended.
2023-05-07T12:03:39.544751Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-05-07T12:03:39.725750Z 0 [Warning] [MY-010068] [Server] CA certificate ca. pem is self signed.
2023-05-07T12:03:39.725961Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this cha nnel.
2023-05-07T12:03:39.753642Z 0 [System] [MY-010931] [Server] /www/server/mysql/b in/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-05-07T14:13:30.052527Z 0 [System] [MY-013172] [Server] Received SHUTDOWN f rom user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-05-07T14:13:31.184972Z 0 [System] [MY-010910] [Server] /www/server/mysql/b in/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.
2023-05-07T14:13:32.949072Z 0 [Warning] [MY-000081] [Server] option 'max_allowe d_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-05-07T14:13:32.949160Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'N O_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-05-07T14:13:32.949283Z 0 [System] [MY-010116] [Server] /www/server/mysql/b in/mysqld (mysqld 8.0.24) starting as process 15579
2023-05-07T14:13:32.972362Z 1 [System] [MY-013576] [InnoDB] InnoDB initializati on has started.
2023-05-07T14:13:33.219755Z 1 [System] [MY-013577] [InnoDB] InnoDB initializati on has ended.
2023-05-07T14:13:33.340840Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-05-07T14:13:33.477004Z 0 [Warning] [MY-010068] [Server] CA certificate ca. pem is self signed.
2023-05-07T14:13:33.477298Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this cha nnel.
2023-05-07T14:13:33.511131Z 0 [System] [MY-010931] [Server] /www/server/mysql/b in/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-05-07T17:04:07.438131Z 0 [System] [MY-013172] [Server] Received SHUTDOWN f rom user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-05-07T17:04:08.464051Z 0 [System] [MY-010910] [Server] /www/server/mysql/b in/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.
2023-05-07T17:04:33.824684Z 0 [Warning] [MY-000081] [Server] option 'max_allowe d_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-05-07T17:04:33.824790Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'N O_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-05-07T17:04:33.824934Z 0 [System] [MY-010116] [Server] /www/server/mysql/b in/mysqld (mysqld 8.0.24) starting as process 2270
2023-05-07T17:04:33.879993Z 1 [System] [MY-013576] [InnoDB] InnoDB initializati on has started.
2023-05-07T17:04:34.461635Z 1 [System] [MY-013577] [InnoDB] InnoDB initializati on has ended.
2023-05-07T17:04:34.756561Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-05-07T17:04:35.025682Z 0 [Warning] [MY-010068] [Server] CA certificate ca. pem is self signed.
2023-05-07T17:04:35.025957Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this cha nnel.
2023-05-07T17:04:35.065120Z 0 [System] [MY-010931] [Server] /www/server/mysql/b in/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-05-08T06:43:51.751266Z 0 [System] [MY-013172] [Server] Received SHUTDOWN f rom user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-05-08T06:43:53.221602Z 0 [System] [MY-010910] [Server] /www/server/mysql/b in/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.
2023-05-08T06:43:54.568818Z 0 [Warning] [MY-000081] [Server] option 'max_allowe d_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-05-08T06:43:54.568912Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'N O_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-05-08T06:43:54.569029Z 0 [System] [MY-010116] [Server] /www/server/mysql/b in/mysqld (mysqld 8.0.24) starting as process 11066
2023-05-08T06:43:54.602621Z 1 [System] [MY-013576] [InnoDB] InnoDB initializati on has started.
2023-05-08T06:43:55.068605Z 1 [System] [MY-013577] [InnoDB] InnoDB initializati on has ended.
2023-05-08T06:43:55.224419Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock
2023-05-08T06:43:55.329772Z 0 [Warning] [MY-010068] [Server] CA certificate ca. pem is self signed.
2023-05-08T06:43:55.329987Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this cha nnel.
2023-05-08T06:43:55.347833Z 0 [System] [MY-010931] [Server] /www/server/mysql/b in/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 0 Source distribution.
2023-05-08T06:44:02.726795Z 0 [Warning] [MY-000081] [Server] option 'max_allowe d_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-05-08T06:44:02.726886Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'N O_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-05-08T06:44:02.726997Z 0 [System] [MY-010116] [Server] /www/server/mysql/b in/mysqld (mysqld 8.0.24) starting as process 11952
2023-05-08T06:44:02.749492Z 1 [System] [MY-013576] [InnoDB] InnoDB initializati on has started.
2023-05-08T06:44:03.902028Z 1 [System] [MY-013577] [InnoDB] InnoDB initializati on has ended.
2023-05-08T06:44:04.049829Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-05-08T06:44:04.111676Z 0 [System] [MY-010229] [Server] Starting XA crash r ecovery...
2023-05-08T06:44:04.120704Z 0 [System] [MY-010232] [Server] XA crash recovery f inished.
2023-05-08T06:44:04.271948Z 0 [Warning] [MY-010068] [Server] CA certificate ca. pem is self signed.
2023-05-08T06:44:04.272320Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this cha nnel.
2023-05-08T06:44:04.300671Z 0 [System] [MY-010931] [Server] /www/server/mysql/b in/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-05-13T13:11:36.856217Z 0 [System] [MY-013172] [Server] Received SHUTDOWN f rom user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-05-13T13:11:37.118543Z 0 [ERROR] [MY-011945] [InnoDB] Cannot open '/www/se rver/data/ib_buffer_pool.incomplete' for writing: No such file or directory
2023-05-13T13:11:37.375773Z 0 [System] [MY-010910] [Server] /www/server/mysql/b in/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.
2023-05-13T14:06:40.910141Z 0 [Warning] [MY-000081] [Server] option 'max_allowe d_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-05-13T14:06:40.910239Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'N O_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-05-13T14:06:40.910386Z 0 [System] [MY-010116] [Server] /www/server/mysql/b in/mysqld (mysqld 8.0.24) starting as process 3289
2023-05-13T14:06:41.023019Z 1 [System] [MY-013576] [InnoDB] InnoDB initializati on has started.
2023-05-13T14:06:42.081457Z 1 [System] [MY-013577] [InnoDB] InnoDB initializati on has ended.
2023-05-13T14:06:42.452362Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-05-13T14:06:42.647260Z 0 [Warning] [MY-010068] [Server] CA certificate ca. pem is self signed.
2023-05-13T14:06:42.647496Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this cha nnel.
2023-05-13T14:06:42.693249Z 0 [System] [MY-010931] [Server] /www/server/mysql/b in/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
|
|
运维要高效，装宝塔
