Subject RE: [firebird-support] Broken Database after system crash on W2K
Author Myles Wakeham
Sounds like someone needs to purchase a UPS.

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org


> -----Original Message-----
> From: jpcarlino [mailto:jpcarlino@...]
> Sent: Tuesday, January 11, 2005 7:21 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Broken Database after system crash on W2K
>
>
>
>
> 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(FBManagedCon
> nectionFactory.java:562)
> at
> org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:90
> )
> at
> org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBM
> anagedConnectionFactory.java:388)
> at
> org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBSta
> ndAloneConnectionManager.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
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>