Subject | Re: About CURRENT_TRANSACTION number |
---|---|
Author | Adam |
Post date | 2006-11-25T23:37:34Z |
> If the last number is invalid, then it will have to be changed.Hello Ann,
> However, it would be very easy to fix even 1.0 and 1.5 to
> recognize that the next transaction id is going to cause
> problems, and set the database to be read only. I think that
> would prevent catastrophes...
That would be a very prudent change IMO. It would prevent the
fireworks (except the fact the database is no longer available to
'use' until it is backup-restored).
Obviously gfix would need to be modified to refuse to make such a
database writable with an informative error message (something like
'out of transaction IDs, you must backup then restore'), and a message
would also need to appear in Firebird.conf because it would not be the
first thing that came to mind when I could not start a new
non-read-only transaction. But to me this is preferable than having to
ask some third party to rescue my database by fudging the header pages.
Adam