Subject servere problems
Author Carsten Schäfer
At 2 customer sites i have some problems.They are using Firebird 1.5.0/1.5.1 with Jaybird 1.5.3/4.
At first custumer i got this error 2 times (in a row):
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file %.0s"ReadFile"
null
Error while trying to read from file
null
at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:198)
at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:110)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:223)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.ResultSetHandler.invoke(ResultSetHandler.java:70)
at $Proxy2.next(Unknown Source)
at com.TTC_Informatik.PAULA.kunden.haendle.Anpassung.getLaufendeNummer(Anpassung.java:430)
at com.TTC_Informatik.PAULA.kunden.haendle.Anpassung.parseChargennr2(Anpassung.java:395)
at com.TTC_Informatik.PAULA.general.WBH_Charge.speichern(WBH_Charge.java:804)
at com.TTC_Informatik.PAULA.server.App_Server.updateCharge(App_Server.java:11232)
at sun.reflect.GeneratedMethodAccessor75.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: I/O error for file %.0s"ReadFile"
null
Error while trying to read from file
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1761)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1714)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_fetch(GDS_Impl.java:1078)
at org.firebirdsql.jca.FBManagedConnection.fetch(FBManagedConnection.java:819)
at org.firebirdsql.jdbc.AbstractConnection.fetch(AbstractConnection.java:961)
at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:192)
at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:110)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:223)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.ResultSetHandler.invoke(ResultSetHandler.java:70)
at $Proxy2.next(Unknown Source)
at com.TTC_Informatik.PAULA.kunden.haendle.Anpassung.getLaufendeNummer(Anpassung.java:430)
at com.TTC_Informatik.PAULA.kunden.haendle.Anpassung.parseChargennr2(Anpassung.java:395)
at com.TTC_Informatik.PAULA.general.WBH_Charge.speichern(WBH_Charge.java:804)
at com.TTC_Informatik.PAULA.server.App_Server.updateCharge(App_Server.java:11232)
at sun.reflect.GeneratedMethodAccessor75.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

direct after that:
java.lang.NullPointerException
at org.firebirdsql.jgds.GDS_Impl.isc_start_transaction(GDS_Impl.java:542)
at org.firebirdsql.jca.FBManagedConnectionFactory.getCurrentIscTrHandle(FBManagedConnectionFactory.java:485)
at org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1116)
at org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:673)
at org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:111)
at org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:94)
at org.firebirdsql.jdbc.AbstractConnection.ensureInTransaction(AbstractConnection.java:830)
at org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:155)
at org.firebirdsql.pool.PingablePooledConnection.ping(PingablePooledConnection.java:134)
at org.firebirdsql.pool.AbstractConnectionPool.getPooledConnection(AbstractConnectionPool.java:225)
at org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSource.java:348)
at org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSource.java:367)
at org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource.java:203)
at com.TTC_Informatik.PAULA.server.App_Server.getConnection(App_Server.java:10172)
at com.TTC_Informatik.PAULA.server.App_Server.getWriteConnection(App_Server.java:8304)
at com.TTC_Informatik.PAULA.server.App_Server.updateCharge(App_Server.java:11228)
at sun.reflect.GeneratedMethodAccessor75.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Then no more error in log file but i have a duplicate primary key in the table that was affected by this update.
I don't know if there is a correlation. But duplicate primary key is one of the worst things that can happen and this is the only error in the log file.

At second cutomer i got a similar error (2 time in a row):
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file ReadFile "E:\IB_DATENBANK\DBAMS_THT_L.GDB"
Error while trying to read from file
null
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:503)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPreparedStatement.java:109)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.Tools.DBAuftragSuche.makeSQLAnfrage(DBAuftragSuche.java:499)
at com.TTC_Informatik.PAULA.Tools.DBAuftragSuche.makeKundenAnfrage(DBAuftragSuche.java:982)
at com.TTC_Informatik.PAULA.Tools.DBAuftragSuche.getPassendeAuftraege(DBAuftragSuche.java:216)
at com.TTC_Informatik.PAULA.server.App_Server.getPassendeAuftraege(App_Server.java:3611)
at sun.reflect.GeneratedMethodAccessor162.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: I/O error for file ReadFile "E:\IB_DATENBANK\DBAMS_THT_L.GDB"
Error while trying to read from file
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1816)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1769)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2(GDS_Impl.java:917)
at org.firebirdsql.jca.FBManagedConnection.executeStatement(FBManagedConnection.java:793)
at org.firebirdsql.jdbc.AbstractConnection.executeStatement(AbstractConnection.java:946)
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:499)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPreparedStatement.java:109)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.Tools.DBAuftragSuche.makeSQLAnfrage(DBAuftragSuche.java:499)
at com.TTC_Informatik.PAULA.Tools.DBAuftragSuche.makeKundenAnfrage(DBAuftragSuche.java:982)
at com.TTC_Informatik.PAULA.Tools.DBAuftragSuche.getPassendeAuftraege(DBAuftragSuche.java:216)
at com.TTC_Informatik.PAULA.server.App_Server.getPassendeAuftraege(App_Server.java:3611)
at sun.reflect.GeneratedMethodAccessor162.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

After that i get the following for every operation:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544327. invalid request handle
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:503)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:144)
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeUpdate(Unknown Source)
at com.TTC_Informatik.PAULA.general.WBH_Charge.ersetzen(WBH_Charge.java:655)
at com.TTC_Informatik.PAULA.server.App_Server.updateCharge(App_Server.java:10713)
at sun.reflect.GeneratedMethodAccessor38.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: invalid request handle
at org.firebirdsql.jdbc.AbstractConnection.executeStatement(AbstractConnection.java:945)
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:499)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:144)
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeUpdate(Unknown Source)
at com.TTC_Informatik.PAULA.general.WBH_Charge.ersetzen(WBH_Charge.java:655)
at com.TTC_Informatik.PAULA.server.App_Server.updateCharge(App_Server.java:10713)
at sun.reflect.GeneratedMethodAccessor38.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.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

So no one can work any longer and i have to restart all services.
I've to look at this database to see if it's corrupted, too.
Any explanation ?

mfg
Carsten

[Non-text portions of this message have been removed]