rev2004 / nemadiy

Automatically exported from code.google.com/p/nemadiy
0 stars 0 forks source link

Meandre Database fkup #126

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
-Can't express it better. Look at the 

JobInformationBackendAdapter class.

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last 
packet successfully received from the server was 70,315,212 milliseconds ago.  
The last packet sent successfully to the server was 70,315,213 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.GeneratedConstructorAccessor17.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
        at org.meandre.core.services.coordinator.tools.DatabaseTools.executeUpdateQueryWithParams(DatabaseTools.java:57)
        ... 3 more
Caused by: java.net.SocketException: Broken pipe
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3298)
        ... 11 more
   [org.meandre.jobs.storage.backend.JobInformationBackendAdapter.updateJobStatusInServer] <Thread-2:32>
2010.06.19 12:22:57.025::WARNING:  Could not print to the job information 
storage! 
org.meandre.jobs.storage.backend.JobInformationBackendAdapterException: 
org.meandre.core.services.coordinator.tools.DatabaseBackendAdapterException: 
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet 
successfully received from the server was 70,315,213 milliseconds ago.  The 
last packet sent successfully to the server was 70,315,214 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 org.meandre.jobs.storage.backend.JobInformationBackendAdapter.executeUpdateQueryWithParams(JobInformationBackendAdapter.java:220)
        at org.meandre.jobs.storage.backend.JobInformationBackendAdapter.print(JobInformationBackendAdapter.java:428)
        at org.meandre.jobs.storage.helpers.PersistentPrintStream$AsynchronousUpdateThread.run(PersistentPrintStream.java:85)
        at java.lang.Thread.run(Thread.java:619)
Caused by: 
org.meandre.core.services.coordinator.tools.DatabaseBackendAdapterException: 
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet 
successfully received from the server was 70,315,213 milliseconds ago.  The 
last packet sent successfully to the server was 70,315,214 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 org.meandre.core.services.coordinator.tools.DatabaseTools.executeUpdateQueryWithParams(DatabaseTools.java:61)
        at org.meandre.jobs.storage.backend.JobInformationBackendAdapter.executeUpdateQueryWithParams(JobInformationBackendAdapter.java:218)
        ... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last 
packet successfully received from the server was 70,315,213 milliseconds ago.  
The last packet sent successfully to the server was 70,315,214 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.GeneratedConstructorAccessor17.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
        at org.meandre.core.services.coordinator.tools.DatabaseTools.executeUpdateQueryWithParams(DatabaseTools.java:57)
        ... 4 more

Original issue reported on code.google.com by kumarami...@gmail.com on 19 Jun 2010 at 5:34