Error connections on the Server

Classic Servoy
1

We have many errors of this type on the server but not exactly understand the cause.

Errors are generated only by the client while the developer does not occur.

Time: 2007-10-25 08:20 - Thread: TaskExecuter[6] - Level: ERROR - Category: com.servoy.j2db.util.Debug - Message: Throwable 

java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.Connection.execSQL(Connection.java:2251) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619) at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source) at $Proxy0.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) 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$300(Unknown Source) at com.servoy.j2db.dataprocessing.SQLEngine$b.run(Unknown Source) at com.servoy.j2db.util.al.run(Unknown Source) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** 
     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1713) 
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929) 
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) 
     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) 
     at com.mysql.jdbc.Connection.execSQL(Connection.java:2251) 
     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772) 
     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619) 
     at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source) 
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
     at java.lang.reflect.Method.invoke(Unknown Source) 
     at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source) 
     at $Proxy0.executeUpdate(Unknown Source) 
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) 
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) 
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) 
     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$300(Unknown Source) 
     at com.servoy.j2db.dataprocessing.SQLEngine$b.run(Unknown Source) 
     at com.servoy.j2db.util.al.run(Unknown Source) 
     at java.lang.Thread.run(Unknown Source)

We tried to update the driver Mysql but errors continue.
Someone idea of the possible cause?

Thanks.

2

hi

Not sure about using MySQL in version 4+

All my installations are 5.0+ not sure if version 4+ is even supported!

This may be your issue.

3

Referring to Rodneys post.

I would try to update MySQL first.

I can imagine that this is a (too old) MySQL version with a (current) Driver issue…

4

Thanks for the answers.

I can imagine that this is a (too old) MySQL version with a (current) Driver issue…

It is possible that this is the reason but errors occur even with the driver for version 4.

Also I do not understand why the developer does not cause problems both with the new driver with the old.

PS. The errors were initiated to the Servoy version 2.2.7.

5

Do you use the same drivers for both developer and server?

6

Do you use the same drivers for both developer and server?

Yes! Exactly the same.

7

So, you have the errors with 2.2.7 and not with 3.x.x?

8

So, you have the errors with 2.2.7 and not with 3.x.x?

No. otherwise. The errors are exactly the same!

9

hmm, this is something strange. Is it a problem to upgrade MySQL or test with a higher version?

10

Hi

Again i don’t think you should be using MySQL 4x with servoy. i don’t think this is supported no matter what drivers you are using.

Upgrade to 5x and use the 5.04+ drivers as a starting point.

11

Again i don’t think you should be using MySQL 4x with servoy. i don’t think this is supported no matter what drivers you are using.

It is not supported?

The manual does not say anything that’s not compatible. Are you sure?

In any case as soon as possible we will test the 5.

12

Are you using also Query validation with mySQL?

(look into the admin-pages, there you can fill in a query validation)
for mySQL we use always: SELECT 1

13

I’ve been seeing this error on 2 client installations which run on Windows 2003, Servoy 3.5.1, with MySql 5.0.37 backend.

I haven’t done a lot of troubleshooting yet, but I personally see the error most often when importing a new version of a solution into the repository (which is in MySql).

Often if I try again, it works. Or if I restart the server and try again, it always works. I’ve been guessing it’s a problem with idle connections that are reused – but I could be totally wrong about that.

greg.