Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. TEST-JDBC 2019-09-16 21:42:06 transaction TPS:4 TEST-JDBC 2019-09-16 21:42:09 transaction TPS:5 TEST-JDBC execute Query fail at 2019-09-16 21:42:15 com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet successfully received from the server was 3,010 milliseconds ago. The last packet sent successfully to the server was 3,010 milliseconds ago. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:805) at com.mysql.cj.jdbc.ha.MultiHostMySQLConnection.commit(MultiHostMySQLConnection.java:164) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.mysql.cj.jdbc.ha.LoadBalancedConnectionProxy.invokeMore(LoadBalancedConnectionProxy.java:565) at com.mysql.cj.jdbc.ha.MultiHostConnectionProxy.invoke(MultiHostConnectionProxy.java:481) at com.sun.proxy.$Proxy0.commit(Unknown Source) at com.companyname.bank.App.executeSimpleTransaction(App.java:150) at com.companyname.bank.App.main(App.java:122) Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure The last packet successfully received from the server was 3,010 milliseconds ago. The last packet sent successfully to the server was 3,010 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:541) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:711) at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:650) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:949) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:895) at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1111) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:793) ... 9 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107) at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150) at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:535) ... 15 more TEST-JDBC 2019-09-16 21:42:15 transaction TPS:2 TEST-JDBC 2019-09-16 21:42:18 transaction TPS:5 TEST-JDBC execute Query fail at 2019-09-16 21:42:25 com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet successfully received from the server was 3,004 milliseconds ago. The last packet sent successfully to the server was 3,205 milliseconds ago. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:805) at com.mysql.cj.jdbc.ha.MultiHostMySQLConnection.commit(MultiHostMySQLConnection.java:164) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.mysql.cj.jdbc.ha.LoadBalancedConnectionProxy.invokeMore(LoadBalancedConnectionProxy.java:565) at com.mysql.cj.jdbc.ha.MultiHostConnectionProxy.invoke(MultiHostConnectionProxy.java:481) at com.sun.proxy.$Proxy0.commit(Unknown Source) at com.companyname.bank.App.executeSimpleTransaction(App.java:150) at com.companyname.bank.App.main(App.java:122) Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure The last packet successfully received from the server was 3,004 milliseconds ago. The last packet sent successfully to the server was 3,205 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:541) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:711) at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:650) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:949) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:895) at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1111) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:793) ... 9 more Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107) at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150) at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180) at java.io.FilterInputStream.read(FilterInputStream.java:133) at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:535) ... 15 more TEST-JDBC 2019-09-16 21:42:25 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:28 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:32 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:36 transaction TPS:1 TEST-JDBC 2019-09-16 21:42:39 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:43 transaction TPS:1 TEST-JDBC 2019-09-16 21:42:46 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:50 transaction TPS:1 TEST-JDBC 2019-09-16 21:42:53 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:56 transaction TPS:0 TEST-JDBC 2019-09-16 21:42:59 transaction TPS:0 TEST-JDBC 2019-09-16 21:43:03 transaction TPS:0 TEST-JDBC 2019-09-16 21:43:06 transaction TPS:0 TEST-JDBC 2019-09-16 21:43:09 transaction TPS:0 TEST-JDBC 2019-09-16 21:43:13 transaction TPS:0 TEST-JDBC 2019-09-16 21:43:16 transaction TPS:0 TEST-JDBC 2019-09-16 21:43:19 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:22 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:25 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:28 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:31 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:34 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:37 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:40 transaction TPS:5 TEST-JDBC 2019-09-16 21:43:43 transaction TPS:5