Subject Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version
Author Ann Harrison
On Fri, Aug 10, 2012 at 5:32 AM, Sofija Blazevski <
sofija.blazevski@...> wrote:

> This affected entire database (all generators actively in use), mostly
> generators are used for Integer columns, some are used for varchar
> columns in case like document number that has string prefix, the prefix
> can vary within a table.
> I'm not sure how could type of column produce a problem like this?
Values for generators are stored densely on a page - depending on the page
size, somewhere between a lot and a whole lot fit on a page (4 bytes per
generator, 4-16K bytes per page, less page overhead). Generator pages are
written out when a transaction that changed them commits, so they should be
written often. It's vaguely possible there's something going on with your

Good luck

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