Subject | Re: [Firebird-Java] severe problems |
---|---|
Author | Carsten Schäfer |
Post date | 2004-11-12T13:12:48Z |
At the second costumer site i've installed Firebird 1.5.2RC1 and Jaybird 1.5.4.
But now the error happens every day.
It's not reproducable, because everytime it happens in another db-operation, but after that the connection is not usable anymore and the connection pool returns this invalid connection everytime.
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.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.Auftrag.speichern(Auftrag.java:1707)
at com.TTC_Informatik.PAULA.server.App_Server.speichereAuftrag(App_Server.java:8749)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichernSync(App_Server.java:7287)
at com.TTC_Informatik.PAULA.server.App_Server.erzeugeSync(App_Server.java:9441)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichern(App_Server.java:7229)
at sun.reflect.GeneratedMethodAccessor208.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.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.Auftrag.speichern(Auftrag.java:1707)
at com.TTC_Informatik.PAULA.server.App_Server.speichereAuftrag(App_Server.java:8749)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichernSync(App_Server.java:7287)
at com.TTC_Informatik.PAULA.server.App_Server.erzeugeSync(App_Server.java:9441)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichern(App_Server.java:7229)
at sun.reflect.GeneratedMethodAccessor208.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)
...
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544327. invalid request handle
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.general.Arbeitsplan.getArbeitsplaeneUndErgebnisse(Arbeitsplan.java:1247)
at com.TTC_Informatik.PAULA.server.App_Server.getArbeitsplaeneUndErgebnisse(App_Server.java:8077)
at sun.reflect.GeneratedMethodAccessor179.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.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.general.Arbeitsplan.getArbeitsplaeneUndErgebnisse(Arbeitsplan.java:1247)
at com.TTC_Informatik.PAULA.server.App_Server.getArbeitsplaeneUndErgebnisse(App_Server.java:8077)
at sun.reflect.GeneratedMethodAccessor179.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)
Carsten
[Non-text portions of this message have been removed]
But now the error happens every day.
It's not reproducable, because everytime it happens in another db-operation, but after that the connection is not usable anymore and the connection pool returns this invalid connection everytime.
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.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.Auftrag.speichern(Auftrag.java:1707)
at com.TTC_Informatik.PAULA.server.App_Server.speichereAuftrag(App_Server.java:8749)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichernSync(App_Server.java:7287)
at com.TTC_Informatik.PAULA.server.App_Server.erzeugeSync(App_Server.java:9441)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichern(App_Server.java:7229)
at sun.reflect.GeneratedMethodAccessor208.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.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.Auftrag.speichern(Auftrag.java:1707)
at com.TTC_Informatik.PAULA.server.App_Server.speichereAuftrag(App_Server.java:8749)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichernSync(App_Server.java:7287)
at com.TTC_Informatik.PAULA.server.App_Server.erzeugeSync(App_Server.java:9441)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichern(App_Server.java:7229)
at sun.reflect.GeneratedMethodAccessor208.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)
...
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544327. invalid request handle
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.general.Arbeitsplan.getArbeitsplaeneUndErgebnisse(Arbeitsplan.java:1247)
at com.TTC_Informatik.PAULA.server.App_Server.getArbeitsplaeneUndErgebnisse(App_Server.java:8077)
at sun.reflect.GeneratedMethodAccessor179.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.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.general.Arbeitsplan.getArbeitsplaeneUndErgebnisse(Arbeitsplan.java:1247)
at com.TTC_Informatik.PAULA.server.App_Server.getArbeitsplaeneUndErgebnisse(App_Server.java:8077)
at sun.reflect.GeneratedMethodAccessor179.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)
Carsten
[Non-text portions of this message have been removed]