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

[Andy C. <an...@ca...>]

Pavel Cisar wrote:
> Hi,
> 
> I forwarded the initial report to firebird-devel.
> 
> Andy Colson wrote:
> 
>> Progress... (well, a little)
>>
>> I was able to extract the sql that is run duing the batch and generate 
>> a sql script.
>>
>> If I run the script with sqlWin it corrupts the db, however, when I 
>> run the script with isql it works fine.
>>
>> When I get home I'm going to make sure I dont have any stray 
>> gds*.dll's or fbclient.dll's laying around, and run it a few times on 
>> my laptop just to make sure its reproducable.
>>
>> then I can post it and see if anyone else gets the problem.
> 
> 
> Great, please send it to firebird-devel because all db corruption issues 
> as top priority ones should be handled there.
> 
> best regards
> Pavel Cisar

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)).

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.

-Andy