Problem with oldest snapshot

76 views
Skip to first unread message

Marcel Zawadzki

unread,
Feb 21, 2025, 5:48:26 AM2/21/25
to firebird-support

Hi,

In FB 5.0.2 we have a problem with oldest snapshot.

Gstat output:

Oldest transaction          288666

               Oldest active                    288667

               Oldest snapshot              249644

               Next transaction              293640

All of our connections are using read commited record version isolation. Of course we are using gbak and nbackup periodically.

There is no transaction with id 249644

There are several transactions (all read commited record version and read only=1) that in MON$transactions in field MON$OLDEST_TRANSACTION have the value of 249644. After disconnecting them the OST is rolling forward.

At this time no backup work is done.

Is this a bug?
How to handle it?
Normally on our db`s OST=OAT.

Best regards,
Marcel

Reply all
Reply to author
Forward
0 new messages