Subject | Re: [firebird-support] Re: Internal gds software consistency check (cannot find tip page (165)) |
---|---|
Author | Vlad Khorsun |
Post date | 2008-08-26T06:24:36Z |
> Vlad -No, look at CORE-342, problem is not in sweep but more general.
>
> Are you talking about CORE-595?
For read-only databases Firebird incerements in-memory counter for
Next transaction when transaction starts. When this counter going to the
next (not-exists) TIP page we have a bugcheck 165.
To work around it recommend to reconnect to read-only database
after few thousand transactions. To be more precise - evaluate how many
transactions per TIP page your database support, let it be number T,
look at Next transaction in gstat -h output, let it be number N and :
X = T - (N mod T) - this is how many transactions you may start before
the bugcheck. So, you need to reconnect when new transaction number
is X -1 (or when N mod T == T - 1).
Regards,
Vlad
PS You may obtain number of transaction at client side using isc_transaction_info