|Subject||Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version|
On 10.8.2012 18:20, Ann Harrison wrote:
>Thank you for this information.
> On Fri, Aug 10, 2012 at 5:32 AM, Sofija Blazevski <
> <mailto:sofija.blazevski%40grappologroup.com>> 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
>[Non-text portions of this message have been removed]
> Good luck
> [Non-text portions of this message have been removed]