Shulou(Shulou.com)06/01 Report--

[summary of problems] at 10:26, the application timeout error is as follows:

[2020-04-22 10 DubboServerHandler-192.168.xx.xx:20881-thread-199] [ERROR] [DruidPooledStatement:357] [DubboServerHandler-192.168.xx.xx:20881-thread-199]-- [TID: 668796908.406.15875214226879429] CommunicationsException, druid version 1.1.10, jdbcUrl: jdbc:mysql://rm-rds-instanceid.mysql.rds.aliyuncs.com:3306/xxxxxx?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowMultiQueries=true, testWhileIdle true, idle millis 928197, minIdle 1, poolingCount 4, timeBetweenEvictionRunsMillis 60000, lastValidIdleMillis 928197, driver com.mysql.jdbc.Driver ExceptionSorter com.alibaba.druid.pool.vendor.MySqlExceptionSorter [2020-04-22 10 DruidDataSource:1602] [DubboServerHandler-192.168.xx.xxx:20881-thread-199]-- [TID: 668796908.406.15875214226879429] discard connectioncom.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

First of all, check the network monitoring, ignore here, and do not see the network jitter, check the mysql server, there is no obvious abnormal performance before and after the timeout, then what should I do?

First of all, network monitoring belongs to coarse-grained, low-grained jitter network monitoring can not detect, and can not see the cause of the timeout, so let's grab tcpdump for analysis

It is recommended to grab the bag and have a look at it.

Linux fixed size cycle grab package:

1. Open a ssh connection to ECS and log in as root.

Run the following command in this window (the following command saves the package capture results in 20 50 MB files for recycling)

Tcpdump-I any-s 0-w / var/tmp/rds.cap-C 50-W 20 port RDS instance port or 53

2. Recurrence of the problem.

3. Use ctrl + c to terminate the tcpdump command of the above window.

Download / var/tmp/rds.cap* and provide it to us (if the grab file is too large, it is recommended that you place it in a subdirectory of the Web server so that we can download it).

Note: network packet capture may produce large files. It is recommended to choose a reasonable save directory according to the use of ECS disk space.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.