Subject | Re: RES: [firebird-support] Copy of the current db not updating generators |
---|---|
Author | Ann Harrison |
Post date | 2012-05-31T12:59:36Z |
On Thu, May 31, 2012 at 8:29 AM, Hannes Streicher <hstreicher@...> wrote:
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]
> Hello Tupy... nambá,Generators are not written to disk every time they're changed. When a
>
> what is the setting of forced writes
> because generators are outside of transaction control and thf shud be
> updated
> immediately
>
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]