Connect IO Exception

The forum to discuss the Headless version of Servoy. Web, Java and Servlet development questions can all be posted here.

Connect IO Exception

Postby gzola » Fri Mar 21, 2008 12:29 pm

Code: Select all
java.rmi.ConnectIOException: Exception creating connection to: 10.14.1.1; nested exception is: java.io.InterruptedIOException: The socket pool for a client 10.14.1.1:3003 did not recieve a callback socket from the client within 60001ms, pool still empty


We often errors on Servoy server for connections via Headless Client from a office connected with our VPN WAN.

I tried to change the lower values timeout Server in this way:
Code: Select all
Rmi.connection.timeout: 10
ApplicationServer.pingDelay: 20

Without seeing improvements.

What can we do to avoid these errors?
Giovanni Zola
Servizio Innovazione Informatica
Comune di Nuoro

Version: 5.2.4 - build 1006
Java version 1.6.x (Windows 2000/2003 - XP - Vista - Windows 7)
Mysql 5.0
User avatar
gzola
 
Posts: 91
Joined: Mon Nov 29, 2004 2:24 pm
Location: Nuoro, Sardegna, Italy

Postby IT2Be » Fri Mar 21, 2008 12:49 pm

What happens when you raise them even more to, let's say, 60 seconds?
Just for the sake of the experiment I would play a little more with these setting to identify the issue...
Marcel J.G. Trapman (IT2BE)
SAN partner - Freelance Java and Servoy
Servoy Components - IT2BE Plug-ins and Beans for Servoy
ServoyForge - Open Source Components for Servoy
User avatar
IT2Be
Servoy Expert
 
Posts: 4766
Joined: Tue Oct 14, 2003 7:09 pm
Location: Germany

Postby gzola » Fri Mar 21, 2008 1:14 pm

Now offices are empty. Try and then refer you what is happened.

Thanks.
Giovanni Zola
Servizio Innovazione Informatica
Comune di Nuoro

Version: 5.2.4 - build 1006
Java version 1.6.x (Windows 2000/2003 - XP - Vista - Windows 7)
Mysql 5.0
User avatar
gzola
 
Posts: 91
Joined: Mon Nov 29, 2004 2:24 pm
Location: Nuoro, Sardegna, Italy

Postby ngervasi » Fri Mar 21, 2008 4:24 pm

Giovanni, are you sure that this is an headless client? An headless client runs on the server so all RMI communication is done on localhost and only the resulting html is sent trough the VPN to the web browser, I would double check that log entry, I don't think it's related to the HC.
Nicola Gervasi
sintpro.com
SAN Partner
ngervasi
 
Posts: 1485
Joined: Tue Dec 21, 2004 12:47 pm
Location: Arezzo, Italy

Postby gzola » Sat Mar 22, 2008 11:46 am

Ciao Nicola.

Giovanni, are you sure that this is an headless client?


Are absolutely sure. The error message is taken from the page "server logs" of Servoy Server.

We have some offices connected to the VPN with ping times from 12ms to 50ms and we continually messages like this. Among the offices there are two routers on the network MPLS (Telecom Italia). Servoy Server is located at headquarters.

Code: Select all
2008-03-22 07:39
RMI TCP Connection(2)-10.11.2.8
ERROR com.servoy.j2db.util.Debug destroyObject: java.sql.SQLException: Eccezione IO: Connection reset by peer: socket write error

...

org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Eccezione IO: Connection reset by peer: socket write error
     at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:191)
     at com.servoy.j2db.persistence.datasource.m.borrowObject(Unknown Source)
     at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:128)
     at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:188)
     at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:188)
     at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
     at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
     at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
     at sun.rmi.transport.Transport$1.run(Unknown Source)
     at java.security.AccessController.doPrivileged(Native Method)
     at sun.rmi.transport.Transport.serviceCall(Unknown Source)
     at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
     at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
     at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: Eccezione IO: Connection reset by peer: socket write error
     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
     at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:389)
     at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
     at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
     at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92)
     at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
     at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
     at com.servoy.j2db.persistence.datasource.l.prepareStatement(Unknown Source)
     at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:185)
     ... 20 more


I do not understand on what have caused.
It may be too slow connection? (HDSL lines 1Mbps)

PS: Sorry for my bad English... :oops:
Giovanni Zola
Servizio Innovazione Informatica
Comune di Nuoro

Version: 5.2.4 - build 1006
Java version 1.6.x (Windows 2000/2003 - XP - Vista - Windows 7)
Mysql 5.0
User avatar
gzola
 
Posts: 91
Joined: Mon Nov 29, 2004 2:24 pm
Location: Nuoro, Sardegna, Italy

Postby ROCLASI » Sat Mar 22, 2008 12:54 pm

Hi Giovanni,

That last piece of trace-log looks more of a JDBC connection issue between Servoy Server and your Oracle database server.
Is the database server also located at headquarters or is it further away ?
Or maybe Oracle has a limit on the amount of connections you may use and you have set the max connections to high in Servoy?
Just thinking out loud here.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Postby gzola » Sat Mar 22, 2008 1:20 pm

That last piece of trace-log looks more of a JDBC connection issue between Servoy Server and your Oracle database server.


It is true, but the server is always on the headquarters so I do not understand the problem.

Or maybe Oracle has a limit on the amount of connections you may use and you have set the max connections to high in Servoy?


I do not think this is the problem. The error posted is verified with a single user connected to Servoy and Oracle servers.
Giovanni Zola
Servizio Innovazione Informatica
Comune di Nuoro

Version: 5.2.4 - build 1006
Java version 1.6.x (Windows 2000/2003 - XP - Vista - Windows 7)
Mysql 5.0
User avatar
gzola
 
Posts: 91
Joined: Mon Nov 29, 2004 2:24 pm
Location: Nuoro, Sardegna, Italy

Postby ROCLASI » Sat Mar 22, 2008 1:36 pm

But even 1 single user can make Servoy Server use as much database connections as it needs.
Do you see anything in the Oracle logs ?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium


Return to Servoy Headless Client

Who is online

Users browsing this forum: No registered users and 6 guests