Gongratulations Vlad



You make it work.



Back to the basics. How can we avoid this kind of situation.

Places are 24/7 and we don't know when those places have breaks to make
backup/restore.



So how can we reset transaction counters without use backup/restore.



-br-

Petri





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Vlad Khorsun
Sent: 1. syyskuuta 2009 10:30
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Memory problem, isc_attach_database
failed

> Ok here is gstat information
>
>
>
> Database "C:\IBDatabases\pdv.fdb"
>
> Database header page information:

...

> Next transaction 2147483646

Looks like http://tracker.firebirdsql.org/browse/CORE-2348

Setup and run FB 2.1.3 RC2.
Make database read-only
Make backup of database using gbak version 2.0.x .
Stop FB 2.1.3
Run your FB 2.0.x
Restore database
Make database read-write

Regards,
Vlad





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