Subject Re: [firebird-support] Structure change
Author Helen Borrie
At 08:04 PM 8/03/2008, you wrote:
>Hello,
>I have this problem. With a script i change the db structure of 12 DB's.
>It works korrect with 4 db's. And then this:
>
>Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements.
>internal gds software consistency check (cannot find record fragment
>(248)).

Your database has some corruption.


>And this was the deathblow for the DB 5. Oh, i'm so happy, that i have
>a backup :-).
>This was the second fall in two days.
>
>Server version: WI-V6.3.4.4910 Firebird 1.5
> SQLDialect: 1. ODS: 10.1.

>Forced writes: Off.

A very bad idea on Windows. Don't leave it this way. It is probably the cause of the corruption.

>The scripttool is ibexpert.

You will need to get a copy of the database and repair it before you can proceed. For steps to do this, please see Appendix IV of The Firebird Book (if you have it) or this web page:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr

./heLen