Home > database >  Abnormal crawlers to access the database
Abnormal crawlers to access the database

Time:02-06

A crawler low-frequency crawl, need frequent reading and writing database, the database is god zhuo, I haven't done the configuration, wait_timeout is 8 hours, continuous access to two or three hours would be easy to error
 com.mysql.jdbc.exceptions.jdbc4.Com municationsException: Communications link failure 

The last packet successfully received from The server was 64 milliseconds line. The last packet sent successfully to The server was 64 milliseconds line.
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance0 (Native Method)
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance (NativeConstructorAccessorImpl. Java: 62)
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (DelegatingConstructorAccessorImpl. Java: 45)
The at Java. Lang. Reflect. Constructor. NewInstance (423) Constructor. Java:
At com. Mysql. JDBC. Util. HandleNewInstance (Util. Java: 425)
At com. Mysql. JDBC. SQLError. CreateCommunicationsException (SQLError. Java: 990)
At com. Mysql. JDBC. MysqlIO. ReuseAndReadPacket (MysqlIO. Java: 3562)
At com. Mysql. JDBC. MysqlIO. ReuseAndReadPacket (MysqlIO. Java: 3462)
At com. Mysql. JDBC. MysqlIO. CheckErrorPacket (MysqlIO. Java: 3905)
At com. Mysql. JDBC. MysqlIO. SendCommand (MysqlIO. Java: 2530)
At com. Mysql. JDBC. MysqlIO. SqlQueryDirect (MysqlIO. Java: 2683)
At com. Mysql. JDBC. ConnectionImpl. ExecSQL (ConnectionImpl. Java: 2495)
At com. Mysql. JDBC. PreparedStatement. ExecuteInternal (PreparedStatement. Java: 1903)
At com. Mysql. JDBC. PreparedStatement. ExecuteQuery (PreparedStatement. Java: 2011)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_executeQuery (FilterChainImpl. Java: 3188)
At com. Alibaba. Druid. Wall. WallFilter. PreparedStatement_executeQuery (WallFilter. Java: 640)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_executeQuery (FilterChainImpl. Java: 3185)
At com. Alibaba. Druid. Proxy. JDBC. PreparedStatementProxyImpl. ExecuteQuery (PreparedStatementProxyImpl. Java: 181)
At com. Alibaba. Druid. Pool. DruidPooledPreparedStatement. ExecuteQuery (DruidPooledPreparedStatement. Java: 228)
At the main. Java. WeiXinInfoSpider. QueryIsExistence (WeiXinInfoSpider. Java: 427)
At the main. Java. WeiXinInfoSpider. ValiList (WeiXinInfoSpider. Java: 201)
At the main. Java. WeiXinInfoSpider. GetInfo (WeiXinInfoSpider. Java: 193)
At the main. Java. WeiXinInfoSpider. Main (WeiXinInfoSpider. Java: 46)
Under Caused by: java.net.SocketException: Connection reset
The at java.net.SocketInputStream.read SocketInputStream. Java: (209)
The at java.net.SocketInputStream.read SocketInputStream. Java: (141)
At sun. Security. SSL. InputRecord. ReadFully (InputRecord. Java: 465)
At sun. Security. SSL. InputRecord. Read (503) InputRecord. Java:
At sun. Security. SSL. SSLSocketImpl. ReadRecord (SSLSocketImpl. Java: 973)
At sun. Security. SSL. SSLSocketImpl. ReadDataRecord (SSLSocketImpl. Java: 930)
At sun. Security. SSL. AppInputStream. Read (105) AppInputStream. Java:
At com. Mysql. JDBC. MysqlIO. ReadFully (MysqlIO. Java: 3011)
At com. Mysql. JDBC. MysqlIO. ReuseAndReadPacket (MysqlIO. Java: 3472)
. 16 more


Com.mysql.jdbc.exceptions.jdbc4.Com municationsException: Communications link failure

The last packet successfully received from The server was 5321 milliseconds line. The last packet sent successfully to The server was 142 milliseconds line.
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance0 (Native Method)
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance (NativeConstructorAccessorImpl. Java: 62)
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (DelegatingConstructorAccessorImpl. Java: 45)
The at Java. Lang. Reflect. Constructor. NewInstance (423) Constructor. Java:
At com. Mysql. JDBC. Util. HandleNewInstance (Util. Java: 425)
At com. Mysql. JDBC. SQLError. CreateCommunicationsException (SQLError. Java: 990)
At com. Mysql. JDBC. MysqlIO. ReuseAndReadPacket (MysqlIO. Java: 3562)
At com. Mysql. JDBC. MysqlIO. ReuseAndReadPacket (MysqlIO. Java: 3462)
At com. Mysql. JDBC. MysqlIO. CheckErrorPacket (MysqlIO. Java: 3905)
At com. Mysql. JDBC. MysqlIO. SendCommand (MysqlIO. Java: 2530)
At com. Mysql. JDBC. MysqlIO. SqlQueryDirect (MysqlIO. Java: 2683)
At com. Mysql. JDBC. ConnectionImpl. ExecSQL (ConnectionImpl. Java: 2495)
At com. Mysql. JDBC. PreparedStatement. ExecuteInternal (PreparedStatement. Java: 1903)
At com. Mysql. JDBC. PreparedStatement. ExecuteQuery (PreparedStatement. Java: 2011)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_executeQuery (FilterChainImpl. Java: 3188)
At com. Alibaba. Druid. Wall. WallFilter. PreparedStatement_executeQuery (WallFilter. Java: 640)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_executeQuery (FilterChainImpl. Java: 3185)
At com. Alibaba. Druid. Proxy. JDBC. PreparedStatementProxyImpl. ExecuteQuery (PreparedStatementProxyImpl. Java: 181)
At com. Alibaba. Druid. Pool. DruidPooledPreparedStatement. ExecuteQuery (DruidPooledPreparedStatement. Java: 228)
At the main. Java. WeiXinInfoSpider. QueryIsExistence (WeiXinInfoSpider. Java: 427)
At the main. Java. WeiXinInfoSpider. ValiList (WeiXinInfoSpider. Java: 201)
nullnullnullnullnullnull
  • Related