Subject | Re: [firebird-support] Missing pointer page |
---|---|
Author | Aage Johansen |
Post date | 2005-09-27T22:02:06Z |
Alexey Kovyazin wrote:
the size of the database is 1.5GB.
Running "gfix -v -full ..." (on a copy of the database) completed without
any indication of problems.
The original database looked fine (after the server restart). I'll check
the log from the nightly backup.
[The table was dropped because we for some reason could not delete those
two records (some constraint violation on one of the fields, except we
couldn't see any constraints! Well, maybe we should try harder
...). Routines for doing metadata changes on a database have now been
reviewed (again)...]
--
Aage J.
> Hello!The table that was dropped had just 2 records. We're using Fb/1.5.2, and
>
> Do you have a large table in database - with 600-700 000 000 records (or
> with size = 36.6Gb)?
> It may be one of the reasons of this error.
>
> Also, if you drop table when multiple user are connected (especially on
> Classic) this may be result of interception between actual on-disc data
> and cached metadata.
>
the size of the database is 1.5GB.
Running "gfix -v -full ..." (on a copy of the database) completed without
any indication of problems.
The original database looked fine (after the server restart). I'll check
the log from the nightly backup.
[The table was dropped because we for some reason could not delete those
two records (some constraint violation on one of the fields, except we
couldn't see any constraints! Well, maybe we should try harder
...). Routines for doing metadata changes on a database have now been
reviewed (again)...]
--
Aage J.