I have a solution running at a shop that uses Citrix for its clients. Users are saying that after a period of idle time, they come back to see an error message that says something like ‘record not found’ and must restart the Servoy client, which I take to mean that they have become disconnected from the server. I found this post:
http://forum.servoy.com/viewtopic.php?t=3478
It recommends that the two-way socket option be disabled. When I disable the two-way option, clients are no longer able to connect to the server at all. The client application launches, but stalls at the ‘Start Repository’ stage. At this time, the users are not able to give me any more specific information about the error. Any ideas?
Thanks in advance,
Steve In LA
Bumped. Does anyone have any ideas about this?
This is probably due to NAT routers throwing away a connection which the server uses to communicate to the client. Some times it can be really bad (NAT router drops connections after 1 minute of idle time). We have developed a fix for this problem in the current test build, and it should be fixed in the next release (which should be released next week).
Sebastiaan
Forgive my ignorance - but will this also reduce number of Client disconnects - seems to affect OSX user more than Win XP users and Server log getting littered with:
Error flushing message buffer to client 387296b0-fc2a-11d9-a472-a9acda78f5c2, Exception creating connection to: 192.168.1.102; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
Graham Greensall
Worxinfo Ltd
I am also seeing this error in the server log:
Error flushing message buffer to client 40b1dcb8-ffb2-11d9-9b76-e15bb829a1f7, Exception creating connection to: 192.33.4.17; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
In addition, I see this one quite a bit:
Error flushing message buffer to client 11543f1a-ffa9-11d9-9b76-e15bb829a1f7, Connection refused to host: 192.33.4.15; nested exception is: java.net.ConnectException: Connection refused: connect
When this one occurs, I see it 5 times for the same IP address over the span of 2 minutes. Is this what is being addressed in the next release?
Steve In LA
Yes, that’s the error that’s being addressed. It means that a nat router threw out a connection from the client to the server which the server uses to talk back to the client. Unfortunately the client is not aware that the connection was thrown out (the NAT routers don’t send a RST packet to the client) and the server then tries to make a new connection to the client but fails. This will all be fixed in the newest release.
Have updated Server to latest 2.1 release but Clients still getting disconnection problems - usually Clients using OSX Tiger - see last two days log below. Several issues:
-
user is not aware if they are disconnected and work is ‘lost’ - ie they spend some time writing a lengthy email - with interruptions - and when click [Save] get the disconnected message and sometimes cannot reconnect
-
on OSX sometime impossible to close Servoy after disconnect - ‘Quit’ does not appear as an option and the only way seem to be Force Quit
-
Force Quit leaves the Client open on the Server [see item 2 below] - the two instances of ‘Vigor13’ are my Powerbook - the first time it was idle from 17:53 and had to be force-quit at about 18:25 but still shows as a Client even after restarting at 18:28
Two way sockets are enabled and using default 1099/8080 ports.
Graham Greensall
Worxinfo Ltd
Servoy Developer
Version R2 2.2.1-build 333
Java version 1.5.0_02-b09 (Windows XP)
005-10-25 00:34 : Error flushing message buffer to client 2a220dd6-44cd-11da-ba86-8032a202433f, Exception creating connection to: 69.228.218.67; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-25 13:53 : Error flushing message buffer to client 758f9375-454e-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.101; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-25 17:54 : Error flushing message buffer to client 17df00d7-4558-11da-ba86-8032a202433f, Exception creating connection to: 192.168.0.7; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-25 17:55 : Error flushing message buffer to client 17df00d7-4558-11da-ba86-8032a202433f, Connection refused to host: 192.168.0.7; nested exception is: java.net.ConnectException: Connection timed out: connect
2005-10-25 17:57 : Error flushing message buffer to client 17df00d7-4558-11da-ba86-8032a202433f, Connection refused to host: 192.168.0.7; nested exception is: java.net.ConnectException: Connection timed out: connect
2005-10-25 18:02 : Error flushing message buffer to client 0ae8ca58-4571-11da-ba86-8032a202433f, Exception creating connection to: 69.228.218.67; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-25 18:02 : Error flushing message buffer to client 0ae8ca58-4571-11da-ba86-8032a202433f, Connection refused to host: 69.228.218.67; nested exception is: java.net.ConnectException: Connection timed out: connect
2005-10-25 19:02 : Error flushing message buffer to client 17df00d7-4558-11da-ba86-8032a202433f, Exception creating connection to: 192.168.0.7; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-25 19:05 : Error flushing message buffer to client 758f9375-454e-11da-ba86-8032a202433f, Connection refused to host: 192.168.1.101; nested exception is: java.net.ConnectException: Connection timed out: connect
2005-10-25 22:36 : Error flushing message buffer to client 053457f9-4599-11da-ba86-8032a202433f, Exception creating connection to: 192.168.0.7; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 02:46 : Error flushing message buffer to client d81cd5db-45bb-11da-ba86-8032a202433f, Exception creating connection to: 192.168.0.7; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 11:30 : Error flushing message buffer to client a3e608f0-460a-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.13; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 15:26 : Error flushing message buffer to client a3e608f0-460a-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.13; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 15:33 : Error flushing message buffer to client b57b8f51-462c-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.13; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 17:47 : Error flushing message buffer to client abdf9442-462d-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.13; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 17:53 : Error flushing message buffer to client 309a70d5-4640-11da-ba86-8032a202433f, error during JRMP connection establishment; nested exception is: java.net.SocketTimeoutException: Read timed out
2005-10-26 17:54 : Error flushing message buffer to client 309a70d5-4640-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.13; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2005-10-26 18:28 : Error flushing message buffer to client 4827a896-4644-11da-ba86-8032a202433f, Exception creating connection to: 192.168.1.13; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
Client: GRGDell[192.168.1.19]
User logged in: Wed Oct 26 17:31:49 BST 2005
Solution opened: Wed Oct 26 17:31:49 BST 2005
User idle since: Wed Oct 26 18:06:09 BST 2005Client: Vigor13[192.168.1.13]
User logged in: Wed Oct 26 17:47:26 BST 2005
Solution opened: Wed Oct 26 17:47:26 BST 2005
User idle since: Wed Oct 26 17:53:18 BST 2005Client: ibook.local[192.168.0.7]
User logged in: Wed Oct 26 16:52:38 BST 2005
Solution opened: Wed Oct 26 16:52:38 BST 2005
User idle since: Wed Oct 26 18:23:52 BST 2005Client: baby[69.228.218.67]
User logged in: Wed Oct 26 00:25:23 BST 2005
Solution opened: Wed Oct 26 00:25:23 BST 2005
User idle since: Wed Oct 26 18:29:11 BST 2005Client: Vigor13[192.168.1.13]
User logged in: Wed Oct 26 18:28:43 BST 2005
Solution opened: Wed Oct 26 18:28:43 BST 2005
User idle since: Wed Oct 26 18:28:46 BST 2005
Hi, your Servoy server should automatically adjust itself zo that after a while the disconnects stop. The idea is that it pings clients to keep open the server connection on nat routers, but by default does not do this too often (unnecessary network traffic). However, it adjusts itself if it notices that clients are disconnecting.
You can force it to start low by changing a setting in the admin page: Network Settings → ApplicationServer.pingDelay. Set this as high as possible but as low as is necessary. Chances are you’ll need to make it 50 seconds or a minute, if the client NAT routers are really bad.
Many thanks Sebastiaan for quick reply - have updated Server & will feedback results.
Is it possible to programatically check to see if Connection still live - ie could we get Servoy Client to ‘ping’ the Server & warn User if Connection had been lost?
Would also appreciate some feedback on problem of closing Servoy Client on OSX after disconnection.
Thanks
Graham Greensall
Worxinfo Ltd
Changed ApplicationServer.pingDelay to 50 seconds and Clients have noticed a real improvement. However, they are still suffering lost connections and great frustration if a detailed email or note is composed then just ‘disappears’ when they try to Save.
Would it be possible to get the Client to ‘ping’ the Server to check if Connection still alive. This could be built into method for creating new record so that User warned if connection had been dropped.
Regards
Graham Greensall
Worxinfo Ltd
Hi Graham,
I’ve had same problems with an other customer.
pingdelay is set to 30 sec. which solved all problems.
BTW: What’s the brand of that NAT router?
Thanks for quick response Maarten
Will change settings to 30 secs & let you know how we get on.
Router is Draytek Vigor 2600 GI
Regards
Graham Greensall
Worxinfo Ltd
I’m still experiencing a lot of these errors, I tried to decrease pingDelay, now it is set at 10 secs but I’m still having problems, mainly two kind of errors: SocketPool empty timeout and No route to host. Two way socket is enabled cause I need to give some users acces to the solution from outside the lan trough the Firewall.
All the affected clients are on the same LAN as the server, there aren’t nat routers or firewalls, just unmanagedd switches between them. The funny thing is that there aren’t any problems when connecting from the net trough the firewall but only on LAN connections, the not so funny thing is that my customer is getting angry… clients disconnect and loose the data they were editing, sometimes records remain locked, zombie clients can’t be killed from admin pages and keep eating licenses and the only cure is to restart the server to free the licenses and release the frozen locks and licenses.
Servoy server is 2.2.3 on java 1.4.2_10-b03 on Suse Linux 2.6.8-24-smp, clients are Windows 2000 w/ Java 1.4.2 and a bunch of Linux and MacOS clients on Java 1.5.
I really need help.
This is an example from the last log:
2006-02-01 20:11 : Loading servoy.properties from /usr/local/servoy_2.2/servoy.properties
2006-02-01 20:11 : Loading - Done
2006-02-01 20:11 : Using RMI registry on port 1099
2006-02-02 08:46 : No 1.5 found for pack200
2006-02-02 08:46 : Loading servoy.properties from /usr/local/servoy_2.2/servoy.properties
2006-02-02 08:46 : Loading - Done
2006-02-02 11:01 : Error flushing message buffer to client 3f80588e-93cf-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.149; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2006-02-02 11:02 : Error flushing message buffer to client 3f80588e-93cf-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.149; nested exception is: java.net.NoRouteToHostException: No route to host
2006-02-02 11:03 : Error flushing message buffer to client 3f80588e-93cf-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.149; nested exception is: java.net.NoRouteToHostException: No route to host
2006-02-02 15:16 : No 1.5 found for pack200
2006-02-02 18:00 : Error flushing message buffer to client 63e74c65-9409-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.126; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2006-02-02 18:04 : Error flushing message buffer to client 63e74c65-9409-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.126; nested exception is: java.net.NoRouteToHostException: No route to host
And this is the stack trace:
2006-02-02 08:46 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
at com.servoy.j2db.server.servlets.MessagesServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:748)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
at com.servoy.j2db.server.servlets.MessagesServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:748)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 08:46 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Repository.do(Unknown Source)
at com.servoy.j2db.persistence.Repository.byte(Unknown Source)
at com.servoy.j2db.persistence.m.do(Unknown Source)
at com.servoy.j2db.persistence.m.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getSolutionDefinitions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Repository.do(Unknown Source)
at com.servoy.j2db.persistence.Repository.byte(Unknown Source)
at com.servoy.j2db.persistence.m.do(Unknown Source)
at com.servoy.j2db.persistence.m.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getSolutionDefinitions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 08:46 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Repository.do(Unknown Source)
at com.servoy.j2db.persistence.Repository.byte(Unknown Source)
at com.servoy.j2db.persistence.m.do(Unknown Source)
at com.servoy.j2db.persistence.m.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getSolutionDefinitions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Repository.do(Unknown Source)
at com.servoy.j2db.persistence.Repository.byte(Unknown Source)
at com.servoy.j2db.persistence.m.do(Unknown Source)
at com.servoy.j2db.persistence.m.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getSolutionDefinitions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 08:53 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 09:19 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.access$2(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine$c.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.access$2(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine$c.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 09:35 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 11:01 : Error flushing message buffer to client 3f80588e-93cf-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.149; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2006-02-02 11:01 : java.rmi.ConnectIOException: Exception creating connection to: 10.0.0.149; nested exception is:
java.io.InterruptedIOException: SocketPool empty timeout
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:580)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:185)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:171)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:101)
at com.servoy.j2db.UserClient_Stub.notifyDataChange(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.try(Unknown Source)
at com.servoy.j2db.dataprocessing.j$e.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.io.InterruptedIOException: SocketPool empty timeout
at com.servoy.j2db.util.a.b.a(Unknown Source)
at com.servoy.j2db.util.a.d.createSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:562)
... 8 more
2006-02-02 11:02 : Error flushing message buffer to client 3f80588e-93cf-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.149; nested exception is: java.net.NoRouteToHostException: No route to host
2006-02-02 11:02 : java.rmi.ConnectIOException: Exception creating connection to: 10.0.0.149; nested exception is:
java.net.NoRouteToHostException: No route to host
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:580)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:185)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:171)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:101)
at com.servoy.j2db.UserClient_Stub.notifyDataChange(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.try(Unknown Source)
at com.servoy.j2db.dataprocessing.j$e.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:452)
at java.net.Socket.connect(Socket.java:402)
at java.net.Socket.(Socket.java:309)
at java.net.Socket.(Socket.java:124)
at com.servoy.j2db.util.a.d.createSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:562)
... 8 more
2006-02-02 11:03 : Error flushing message buffer to client 3f80588e-93cf-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.149; nested exception is: java.net.NoRouteToHostException: No route to host
2006-02-02 11:03 : java.rmi.ConnectIOException: Exception creating connection to: 10.0.0.149; nested exception is:
java.net.NoRouteToHostException: No route to host
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:580)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:185)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:171)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:101)
at com.servoy.j2db.UserClient_Stub.notifyDataChange(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.try(Unknown Source)
at com.servoy.j2db.dataprocessing.j$e.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:452)
at java.net.Socket.connect(Socket.java:402)
at java.net.Socket.(Socket.java:309)
at java.net.Socket.(Socket.java:124)
at com.servoy.j2db.util.a.d.createSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:562)
... 8 more
2006-02-02 11:05 : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162)
at com.servoy.j2db.persistence.datasource.a.a(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.validateObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 15:16 : No 1.5 found for pack200
2006-02-02 17:21 : com.servoy.j2db.persistence.RepositoryException: Record is locked
at com.servoy.j2db.dataprocessing.SQLEngine.performUpdates(Unknown Source)
at sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2006-02-02 18:00 : Error flushing message buffer to client 63e74c65-9409-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.126; nested exception is: java.io.InterruptedIOException: SocketPool empty timeout
2006-02-02 18:00 : java.rmi.ConnectIOException: Exception creating connection to: 10.0.0.126; nested exception is:
java.io.InterruptedIOException: SocketPool empty timeout
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:580)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:185)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:171)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:101)
at com.servoy.j2db.UserClient_Stub.removeLocks(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.try(Unknown Source)
at com.servoy.j2db.dataprocessing.j$e.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.io.InterruptedIOException: SocketPool empty timeout
at com.servoy.j2db.util.a.b.a(Unknown Source)
at com.servoy.j2db.util.a.d.createSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:562)
... 8 more
2006-02-02 18:04 : Error flushing message buffer to client 63e74c65-9409-11da-94b8-982afd1df99b, Exception creating connection to: 10.0.0.126; nested exception is: java.net.NoRouteToHostException: No route to host
2006-02-02 18:04 : java.rmi.ConnectIOException: Exception creating connection to: 10.0.0.126; nested exception is:
java.net.NoRouteToHostException: No route to host
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:580)
at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:185)
at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:171)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:101)
at com.servoy.j2db.UserClient_Stub.removeLocks(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.try(Unknown Source)
at com.servoy.j2db.dataprocessing.j$e.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:452)
at java.net.Socket.connect(Socket.java:402)
at java.net.Socket.(Socket.java:309)
at java.net.Socket.(Socket.java:124)
at com.servoy.j2db.util.a.d.createSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:562)
... 8 more
Hi Nicola
One of my OSX clients has continued to have disconnect problems - although they are using a remotely hosted system - not LAN as in your case.
Reducing the pingDelay to 30secs improved but didn’t cure problem. However have created a Cron job that gets the ServerTime every minute - and customer reports that he hasn’t been disconnected since - even though I still see some disconnected errors in the log.
Added this line to User log-in method
plugins.scheduler.addCronJob(‘ServerTime’, ‘0 0/1 * * * ?’, globals.jc_getServerTime)
to run this global method
var vServerTime = application.getServerTimeStamp()
application.setStatusText(vServerTime)
HTH
Graham Greensall
Worxinfo Ltd
Hi Nicola,
The logging seems to indicate there’s a connection problem between your db server and servoy app server.
Could be that your db server kills the connection to servoy server after a certain idle time. (like a connection that’s open all night without any traffic)
To overcome this you can do 2 things:
- adjust time out setting in your db server
OR - Goto the servoy admin page > Database servers
Under settings set Query validation type to “query validation”
This means that Servoy will always first check the connection to the db by firing a simple query “SELECT 1”. IF no IO errors occur, Servoy will go ahead with this connection, in case of failure, Servoy will remove this connection from the pool and check for the next connection in the pool, etc. etc. If all connections failed, Servoy build up a new connection to the db.
By default Query validation type is set to “exception validation”
which means that Servoy will remove the invalid connection right away
without prechecking it like with query validation.
maarten:
- adjust time out setting in your db server
The DB server is a MySQL 4.1 server running on the same host as servoy server, here’s the connections settings:
connect_timeout: 5
interactive timeout: 1000000
wait_timeout: 28800
These are default values and look Ok to me, I use these values in other MySQL servers as well and I don’t experience any problems at all.
maarten:
2) Goto the servoy admin page > Database servers
Under settings set Query validation type to “query validation”
This means that Servoy will always first check the connection to the db by firing a simple query “SELECT 1”. IF no IO errors occur, Servoy will go ahead with this connection, in case of failure, Servoy will remove this connection from the pool and check for the next connection in the pool, etc. etc. If all connections failed, Servoy build up a new connection to the db.By default Query validation type is set to “exception validation”
which means that Servoy will remove the invalid connection right away
without prechecking it like with query validation.
I’ve always used “Query Validation: select1;” with MySQL DB servers but the problem persists and it is not related to a long overnight idle time, look at the logs I sent, it happened even in the afternoon around 18:00.
A month ago I noticed some tcp errors in the stats of the second network adapter (it was configured and online but NEVER used to connect to the server, all connections went trough the first adapter) so i turned offline eth1 and set java.rmi.server.hostname to “127.0.0.1”, things improved a bit but the problem is still there. Any comments on this? A second network adapter is a good thing for high availability and shouldn’t be turned off.
I suppose your reply is related to the “socket empty” errors and what about the “no route to host” errors?
grahamg:
Hi NicolaOne of my OSX clients has continued to have disconnect problems - although they are using a remotely hosted system - not LAN as in your case.
Reducing the pingDelay to 30secs improved but didn’t cure problem. However have created a Cron job that gets the ServerTime every minute - and customer reports that he hasn’t been disconnected since - even though I still see some disconnected errors in the log.
Added this line to User log-in method
plugins.scheduler.addCronJob(‘ServerTime’, ‘0 0/1 * * * ?’, globals.jc_getServerTime)
to run this global method
var vServerTime = application.getServerTimeStamp()
application.setStatusText(vServerTime)HTH
Graham Greensall
Worxinfo Ltd
Thanks Graham, I could give it a try but I’m wondering what happens if the scheduled job goes in execution while the client is executing another method… is the job delayed until the running methd is over or is the job executed in another thread?
This should be taken into account because it could lead to other problems as well.
I believe the Quartz Scheduler runs in it’s own thread - but can’t find anything to substantiate this. However, even if it does delay another action it should only be for a very short time as the query and data sent back are very ‘lean’.
Have just tested by starting a Servoy process that usually take 4-5 secs about 2 secs before the time was due to be updated and the Quartz job waited until the original process had completed then returned a time 12:31:03. So I guess it does not run in seperate thread - but also does not interupt.
For info I had originally set this to trigger at one minute intervals just to test the principle - but clients travel a lot and like the idea of up-to-date UK time being displayed so have left it.
Graham Greensall
Worxinfo Ltd
Hi,
I see two different errors in your log.
- The server is having problems reaching the mysql database.
- The server is having problems reaching the internal hosts on the LAN.
The first error already suggests a network problem unrelated to Servoy, especially if you already have query validation and a very high timeout, and say it is not a timeout problem.
Furthermore, if there is no NAT/Firewall running on the internal LAN I find it very strange that the server cannot connect to the clients on your local LAN… Can you ping those clients from your server? A no route to host error is pretty strange for a LAN.
sebster:
Hi,I see two different errors in your log.
- The server is having problems reaching the mysql database.
The Servoy Server and MySQL server are running on the same machine.
sebster:
2) The server is having problems reaching the internal hosts on the LAN.The first error already suggests a network problem unrelated to Servoy, especially if you already have query validation and a very high timeout, and say it is not a timeout problem.
Both processes are running on the same machine so I can’t imagine where the network problem should be, everything happens on loopback interface. Query validation is used in EVERY Servoy db connection. The problem happens randomly and I can’t really figure out where the cause.
sebster:
Furthermore, if there is no NAT/Firewall running on the internal LAN I find it very strange that the server cannot connect to the clients on your local LAN… Can you ping those clients from your server? A no route to host error is pretty strange for a LAN.
Sure! I can ping any host! The clients stay connected all day long as my Servoy Solution is critical for everybody’s work, the problem happens randomly and on ANY host: Windows, Macintosh or Linux. I can’t see a relation between the activity of the user in my servoy solution and the problem itself, it just happens.
A ‘No route to host’ on a LAN where everything is connected to a bunch of unmanaged switches is not strange, it’s impossible! There’s no routing in this situation, the switch simply knows the MAC addresses of the two hosts and connects them, no routing tables at all.
Now I have a team of electricians checking the wires but if they don’t find anything (and I’m worrying the won’t) I’m going to be really embarassed with my customer.
I’m really clueless. Any help is appreciated.