Hi,

I'm trying to figure out what is causing database corruption with
firebird. Currently within our test environment, we are experiencing
corruption with a firebird database which I would expect to not be
occurring on a regular basis, which requires the app that to be
shutdown and a restore to occur prior to restarting firebird.

*snipped*.cpp [174]: An IBPP::Exception occurred inserting new batch:
*** IBPP::SQLException ***
Context: Statement::Fetch
Message: isc_dsql_fetch failed.

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544335
Engine Message :
database file appears corrupt ()
wrong page type
page 169452 is of wrong type (expected 7, found 5)
(Error message: Database error.) (0x8000000d)

Looking through Helen Borrie's "The Firebird Book: A Reference for
Database Developers" nothing stands out as to what is causing this
error. Could using isql to run a stored procedure 4000 times and
committing cause issues when a remote process is running other stored
procedures?

Any tips would be appreciated.

Regards
--jm

--
Jacques Marneweck
http://www.powertrip.co.za/
http://www.powertrip.co.za/blog/
http://www.ataris.co.za/