On Mon, Sep 17, 2012 at 10:17 PM, Bob Murdoch <mailgroups@...>wrote:

>
> That has been a problem for a very long time. Right now, a full
> backup/restore cycle is taking more than 24 hours, and at best we only
> have a 12 hour window at best on a Sunday. Hence the May 2009
> creation date of the current DB.
>
>

Sorry to jump into this late, but I had a thought (rare, but it happens).
It appears
that through some glitch, an old transaction is listed as active on the
header page
but is not actually present. Firebird is running in Classic mode, with one
process
per connection. The oldest active from the header page is not visible
through the
monitoring tables. Shutting down the database does not cure the problem -
that's
odd, which is why I'm suggesting that there's a glitch.

What you might try is installing SuperServer configuration of the same
version of
Firebird using the instructions for installing multiple versions of
Firebird. Shut down
the Classic and start the SuperServer. If there's actually a client out
there using
the database, SuperServer won't be able to get the access it needs to the
database
file and that will suggest where to look for the missing active
transaction. If it does
start, it should reset the oldest active.

Good luck,

Ann


[Non-text portions of this message have been removed]