[2019/07/19 04:00:00.742] [ INFO] [Timer-0] DBConnector getConnection New database connection is created, OK [2019/07/19 04:00:00.745] [ INFO] [Timer-0] JobTimerTask connectDB DB connection established successfully. [2019/07/19 04:00:00.761] [ INFO] [Timer-0] JobTimerTask run Moving of Past MMSMT has been performed successfully. [2019/07/19 11:52:27.254] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran {"Db Index":"0","Sender Key":"66f4fa3e315e3c62e7bafd6f4368a4650291bc00","Template Code":"FT4001 ","Response Method":"push","timeout":"86400"} [2019/07/19 11:52:27.262] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran MMT QUE: 237/0/01093979575//2019-07-19 11:52:26.0/66f4fa3e315e3c62e7bafd6f4368a4650291bc00/FT4001 /push [2019/07/19 11:52:28.603] [ INFO] [Thread-1] MTSender sendMmsPacket MMT SEND: 237/1000/kgwrs2 [2019/07/19 11:52:29.276] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran {"Db Index":"0","Sender Key":"66f4fa3e315e3c62e7bafd6f4368a4650291bc00","Template Code":"FT4001 ","Response Method":"push","timeout":"86400"} [2019/07/19 11:52:29.277] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran MMT QUE: 238/0/01093979575//2019-07-19 11:52:28.0/66f4fa3e315e3c62e7bafd6f4368a4650291bc00/FT4001 /push [2019/07/19 11:52:30.534] [ INFO] [Thread-1] MTRPTReceiver SaveToReportQue MMT RSLT: 237/0/1000/01093979575/10000/1563504749000/kgwrs2/0 [2019/07/19 11:52:30.605] [ INFO] [Thread-1] MTSender sendMmsPacket MMT SEND: 238/1000/kgwrs2 [2019/07/19 11:52:31.288] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran {"Db Index":"0","Sender Key":"66f4fa3e315e3c62e7bafd6f4368a4650291bc00","Template Code":"FT4001 ","Response Method":"push","timeout":"86400"} [2019/07/19 11:52:31.291] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran MMT QUE: 239/0/01093979575//2019-07-19 11:52:30.0/66f4fa3e315e3c62e7bafd6f4368a4650291bc00/FT4001 /push [2019/07/19 11:52:32.060] [ERROR] [Thread-0] MTDistributor fromQueToDB DBException occurred when insert to database from queue. ib.frame.exception.DBException: The last packet successfully received from the server was 74,311,292 milliseconds ago. The last packet sent successfully to the server was 74,311,292 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.||The last packet successfully received from the server was 74,311,292 milliseconds ago. The last packet sent successfully to the server was 74,311,292 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. at biz.ata.db.mysql.MySQLRPTDBHandler.failbackInsert(MySQLRPTDBHandler.java:488) at biz.ata.worker.MTDistributor.fromQueToDB(MTDistributor.java:348) at biz.ata.worker.MTDistributor.run(MTDistributor.java:283) com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 74,311,292 milliseconds ago. The last packet sent successfully to the server was 74,311,292 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. at sun.reflect.GeneratedConstructorAccessor25.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3746) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2509) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497) at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4782) at biz.ata.db.mysql.MySQLRPTDBHandler.failbackInsert(MySQLRPTDBHandler.java:466) at biz.ata.worker.MTDistributor.fromQueToDB(MTDistributor.java:348) at biz.ata.worker.MTDistributor.run(MTDistributor.java:283) Caused by: java.net.SocketException: Broken pipe (Write failed) at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) at java.net.SocketOutputStream.write(SocketOutputStream.java:155) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3728) ... 7 more ----------------------------- [2019/07/19 11:52:32.539] [ INFO] [Thread-1] MTRPTReceiver SaveToReportQue MMT RSLT: 238/0/1000/01093979575/10000/1563504751000/kgwrs2/0 [2019/07/19 11:52:32.608] [ INFO] [Thread-1] MTSender sendMmsPacket MMT SEND: 239/1000/kgwrs2 [2019/07/19 11:52:34.068] [ INFO] [Thread-0] DBConnector getConnection New database connection is created, OK [2019/07/19 11:52:34.074] [ INFO] [Thread-0] MySQLRPTDBHandler updateMtResult MMT RPT: 237/0/01093979575/1 [2019/07/19 11:52:34.076] [ INFO] [Thread-0] MySQLRPTDBHandler updateMtResult MMT RPT: 238/0/01093979575/1 [2019/07/19 11:52:34.548] [ INFO] [Thread-1] MTRPTReceiver SaveToReportQue MMT RSLT: 239/0/1000/01093979575/10000/1563504753000/kgwrs2/0 [2019/07/19 11:52:36.079] [ INFO] [Thread-0] MySQLRPTDBHandler updateMtResult MMT RPT: 239/0/01093979575/1 [2019/07/19 17:15:14.049] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran {"Db Index":"0","Sender Key":"66f4fa3e315e3c62e7bafd6f4368a4650291bc00","Template Code":"FT1001 ","Response Method":"push","timeout":"86400"} [2019/07/19 17:15:14.052] [ INFO] [Thread-0] MySQLMMTDBHandler selectMmtTran MMT QUE: 240/0/01030681446//2019-07-19 17:15:12.0/66f4fa3e315e3c62e7bafd6f4368a4650291bc00/FT1001 /push [2019/07/19 17:15:15.892] [ INFO] [Thread-1] MTSender sendMmsPacket MMT SEND: 240/1000/kgwrs2 [2019/07/19 17:15:17.916] [ INFO] [Thread-1] MTRPTReceiver SaveToReportQue MMT RSLT: 240/0/1000/01030681446/10000/1563524116000/kgwrs2/0 [2019/07/19 17:15:18.234] [ INFO] [Thread-0] MySQLRPTDBHandler updateMtResult MMT RPT: 240/0/01030681446/1