[已解决] Got an error reading communication packets？

904 2 2022-8-29 09:14

本帖最后由 chly1103 于 2022-8-29 09:14 编辑

环境如下：

OS：CentOS Linux release 7.7.1908
MySQL：8.0.30
Router：8.0.30
MRG：单主模式（1主2从）
CPU：8c
MEM：32G

my.cnf 参数
----------------

lock_wait_timeout = 3600
open_files_limit = 65535
max_connections = 512
max_connect_errors = 1000000
interactive_timeout = 600
wait_timeout = 600

查看日志存在大量如下错误信息
---------------

2022-08-24T16:25:32.092270+08:00 112148 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T16:25:32.092405+08:00 112148 [Note] [MY-010914] [Server] Aborted connection 112148 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T16:28:17.468306+08:00 116720 [Note] [MY-010914] [Server] Aborted connection 116720 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:38:16.396284+08:00 118611 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T16:38:16.396466+08:00 118611 [Note] [MY-010914] [Server] Aborted connection 118611 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T16:38:17.707621+08:00 118625 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T16:38:17.707807+08:00 118625 [Note] [MY-010914] [Server] Aborted connection 118625 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T16:38:17.724679+08:00 118626 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T16:38:17.724835+08:00 118626 [Note] [MY-010914] [Server] Aborted connection 118626 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T16:38:23.797757+08:00 118613 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T16:38:23.797909+08:00 118613 [Note] [MY-010914] [Server] Aborted connection 118613 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T16:38:29.950790+08:00 118624 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T16:38:29.950924+08:00 118624 [Note] [MY-010914] [Server] Aborted connection 118624 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T16:44:45.882788+08:00 126030 [Note] [MY-010914] [Server] Aborted connection 126030 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:50:34.882647+08:00 126974 [Note] [MY-010914] [Server] Aborted connection 126974 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:50:46.283304+08:00 126071 [Note] [MY-010914] [Server] Aborted connection 126071 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:50:46.471899+08:00 126987 [Note] [MY-010914] [Server] Aborted connection 126987 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:50:46.473751+08:00 126988 [Note] [MY-010914] [Server] Aborted connection 126988 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:50:46.475367+08:00 126990 [Note] [MY-010914] [Server] Aborted connection 126990 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:51:31.011786+08:00 126973 [Note] [MY-010914] [Server] Aborted connection 126973 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:52:26.541232+08:00 130503 [Note] [MY-010914] [Server] Aborted connection 130503 to db: 'unconnected' user: 'rpl_user' host: '10.1.20.111' (Got an error reading communication packets).
2022-08-24T16:53:34.741395+08:00 130418 [Note] [MY-010914] [Server] Aborted connection 130418 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:53:34.747815+08:00 129939 [Note] [MY-010914] [Server] Aborted connection 129939 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:53:34.768894+08:00 130038 [Note] [MY-010914] [Server] Aborted connection 130038 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:53:39.763776+08:00 131341 [Note] [MY-010914] [Server] Aborted connection 131341 to db: 'unconnected' user: 'dev_imes_rwh' host: '10.1.20.111' (Got an error reading communication packets).
2022-08-24T16:55:11.148706+08:00 131465 [Note] [MY-010914] [Server] Aborted connection 131465 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:55:11.158267+08:00 131467 [Note] [MY-010914] [Server] Aborted connection 131467 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:55:11.169376+08:00 131468 [Note] [MY-010914] [Server] Aborted connection 131468 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T16:55:11.178043+08:00 131466 [Note] [MY-010914] [Server] Aborted connection 131466 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T17:00:20.417164+08:00 132287 [Note] [MY-010914] [Server] Aborted connection 132287 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T17:00:20.512995+08:00 132286 [Note] [MY-010914] [Server] Aborted connection 132286 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T17:00:20.514773+08:00 132285 [Note] [MY-010914] [Server] Aborted connection 132285 to db: 'test' user: 'dev' host: '10.1.20.112' (Got an error reading communication packets).
2022-08-24T17:00:53.809623+08:00 130036 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.
2022-08-24T17:00:53.809757+08:00 130036 [Note] [MY-010914] [Server] Aborted connection 130036 to db: 'test' user: 'dev' host: '10.1.20.112' (The client was disconnected by the server because of inactivity.).
2022-08-24T17:01:00.541884+08:00 130158 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.

全部回复(2)

只看楼主

yejr 2022-8-29 14:09:41

1.note级别的日志，关注即可，一般没什么要事。
2.连接超时自动被观看了，日志里已明示：'wait_timeout' period of 600 seconds was exceeded for `dev`@`%`. The idle time since last command was too long.