Subject RE: [firebird-support] Repeated database corruption
Author Alan McDonald
>
> 2) If not, what else should I check.

trying to access the database while it is being copied will also cause these
bug check errors on connection. Under these circumstances no permanent
damage is done, in my experience but it's still not a good habit.

>
> 3) After the gbak mend, the log file shows entries like these examples:
>
> Relation has 3 orphan backversions (0 in use) in table MEMBER
> (128)
> Record 10152 is wrong length in table WEB_USER (439)
> Page 81771 is an orphan
>
> Many of the last. Does this mean that I lost data? Can anyone
> explain
> what these mean?

not necessarily with regard to first and last error. Backversions can be
discarded and the orphan page may have been created but not written to with
data or related to what sort of page it was to be used for. The middle error
may mean data loss. When you finally get it done (fixed), and if the data in
this table is relatively stable over time, you can do a table data compare
against the most recent backup of the db to restore some sense to it.
Alan


>
> Thanks in advance,
>
> Scott
>
>
>
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>