Subject | Broken Database after system crash on W2K |
---|---|
Author | jpcarlino |
Post date | 2005-01-11T14:21:27Z |
Hi:
I'm using Firbird 1.5.1.4481 for Win32 on a W2K machine, and I've
observed that always an electric shutdown happens, the database get
broken. If I replace the .fdb file for a backup copy then, the
database has no problem to open it.
This is the exception I get after the shutdown:
org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error for
file CreateFile (open) "g2"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "g2"
Error while trying to open file
null
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:112)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.delsatgroup.g2.kernel.db.DbConnection.<init>(DbConnection.java:83)
at com.delsatgroup.g2.kernel.Server.initializeDatabase(Server.java:240)
at com.delsatgroup.g2.kernel.Server.initialize(Server.java:84)
at com.delsatgroup.g2.kernel.Server.main(Server.java:471)
at
org.firebirdsql.gds.GDSException: I/O error for file CreateFile (open)
"g2"
Error while trying to open 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_attach_database(GDS_Impl.java:303)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:265)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:562)
at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:90)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:388)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:60)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:109)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.delsatgroup.g2.kernel.db.DbConnection.<init>(DbConnection.java:83)
at com.delsatgroup.g2.kernel.Server.initializeDatabase(Server.java:240)
at com.delsatgroup.g2.kernel.Server.initialize(Server.java:84)
at com.delsatgroup.g2.kernel.Server.main(Server.java:471)
The curious thing is that this issue does not occurr when I use
Firebird on Linux (Gentoo). Can I fix this problem adjusting some
settings? It's a NTFS issue?
Thanks in advance
Juan Pablo
I'm using Firbird 1.5.1.4481 for Win32 on a W2K machine, and I've
observed that always an electric shutdown happens, the database get
broken. If I replace the .fdb file for a backup copy then, the
database has no problem to open it.
This is the exception I get after the shutdown:
org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error for
file CreateFile (open) "g2"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "g2"
Error while trying to open file
null
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:112)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.delsatgroup.g2.kernel.db.DbConnection.<init>(DbConnection.java:83)
at com.delsatgroup.g2.kernel.Server.initializeDatabase(Server.java:240)
at com.delsatgroup.g2.kernel.Server.initialize(Server.java:84)
at com.delsatgroup.g2.kernel.Server.main(Server.java:471)
at
org.firebirdsql.gds.GDSException: I/O error for file CreateFile (open)
"g2"
Error while trying to open 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_attach_database(GDS_Impl.java:303)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:265)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:562)
at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:90)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:388)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:60)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:109)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.delsatgroup.g2.kernel.db.DbConnection.<init>(DbConnection.java:83)
at com.delsatgroup.g2.kernel.Server.initializeDatabase(Server.java:240)
at com.delsatgroup.g2.kernel.Server.initialize(Server.java:84)
at com.delsatgroup.g2.kernel.Server.main(Server.java:471)
The curious thing is that this issue does not occurr when I use
Firebird on Linux (Gentoo). Can I fix this problem adjusting some
settings? It's a NTFS issue?
Thanks in advance
Juan Pablo