Subject Re: RES: [firebird-support] Copy of the current db not updating generators
Author Ann Harrison
On Thu, May 31, 2012 at 8:29 AM, Hannes Streicher <hstreicher@...> wrote:

> Hello Tupy... nambá,
>
> what is the setting of forced writes
> because generators are outside of transaction control and thf shud be
> updated
> immediately
>

Generators are not written to disk every time they're changed. When a
transaction commits, all the pages it changed (data, index, generator, page
information, etc.) are written before the transaction inventory page that
marks it as committed. So there are gaps when the generator pages on disk
get behind the copy in memory.


Good luck,

Ann

Don't copy a running database.


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