Re: [Firebird-test] Firebird 2.0, corrupting a db

[Pavel C. <pc...@ib...>]

Andy Colson wrote:

> Shoot...  Things got a little more complicated.  I setup fb2 on my 
> laptop at home, created a new db, and ran my script, and it worked fine. 
>  No problems at all.
> 
> Then I tried the batch function in our application, and at least that 
> still crashed the db.
> 
> (Interesting side note, after the app crashes the db then I can create a 
> new database and just run the script and it will crash.  but If I 
> restart the fb service I can no longer crash with the script alone, I 
> have to run the batch function at least once.)
> 
> (another interesting node: on my pc at work it always crashed at the 
> same spot (giveing me the same table name.  At home it crashed later in 
> the process (a new spot, and always that spot)).

If the new spot gives you the same error then this is definitely somehow 
connected to tables (header page is assigned to hold table data in 
Pointer Page). It would be good to know if header page was overwritten 
by table data or not (in this case only the Pointer Page was mangled. My 
personal guess is that the page number was not set at all, so it's still 
zero and zero means header page). Can you try to run gstat -h on 
corrupted database? If it fails or show weird results, then header was 
overwritten.

I guess that in your narrow-down attempt you should concentrate on 
table/data operations.

> So, I guess we have a couple options.  I can try to pull out the code 
> and make a little test app, or I can setup the application on one of the 
> developers machines.
> 
> I assume they'd prefer a little test app, so I'll start working on that.
> 
> As soon as I get something I'll post to firebird-devel list.

Thanks a lot.

best regards
--Pavel