Louis,
I hope you get lots of ideas about the CAUSE from here...here are two possiblities to start with:

Is your gdb file over 2 Gb? if so, is it getting near 4 Gb? If the database file overruns the 2 Gb limit (for FAT32, some say it is 4 Gb), it will begin to write over the top of itself from the beginning.

Is somebody connecting to the database with a missing backslash following the drive designator? e.g. SERVERNAME:c:databases\mydb.gdb. If you have one or more users connected with the correct string and one or more connected with the bad string, your database will be corrupted.

Other than that - over to the rest! (Pity Ann H. is on vacation right now).

Regards,
Helen

At 12:00 PM 07-08-01 +0200, you wrote:

>We have encountered a serious problem with our development database. We
>have a team working on the adatabase, making metadata changes like adding
>columns, changing SPs etc. We have encountered some really 'wierd;
>behaviour. Columns not having NOT NULL constraints refusing null
>values, the DB crashing when trying to create new SPs, etc.
>
>We tried a validation on the server, but it gave a lot of errors. The
>server runs IB5.6 & NT4 & SP6. A backup & restore also fails. An extract of
>the (very large) log file is included. The extract show the two errors we
>get. There are MANY instances of these 2 errors.
>
>The restore bombs out on a 'deadlock' error. No other users are logged into
>the DB.
>
>On another machine (W2K), the restore runs, but fail because of column with
>NOT NULL constraints having null values etc.
>
>Is there anybody that can give some advice?
>
>Thanks in advance
>
>L.J. van Alphen
>lja@...
>
>
>
>LOG
>-------
>Some examples (many of these):
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Page 7624 is an orphan
>
>MAIA (Server) Tue Aug 07 09:24:01 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Page 8168 is an orphan
>
>MAIA (Server) Tue Aug 07 09:24:01 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Page 8173 is an orphan
>
>Some other examples (many of these):
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 5864 has bad transaction 128892 in table FWF_ERROR_LOG (265)
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 5917 has bad transaction 128893 in table FWF_ERROR_LOG (265)
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 0 has bad transaction 67396 in table FW_SYS_SETTINGS (266)
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 1 has bad transaction 67396 in table FW_SYS_SETTINGS (266)
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 2 has bad transaction 86880 in table FW_SYS_SETTINGS (266)
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 3 has bad transaction 88662 in table FW_SYS_SETTINGS (266)
>
>
>MAIA (Server) Tue Aug 07 09:23:59 2001
> Database: C:\PROJECTS\ENHANCED STS\TECH\ESTS MAIN SERVER\DATABASE\STS.GDB
> Record 4 has bad transaction 88853 in table FW_SYS_SETTINGS (266)
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________