On 7.8.2012 17:10, Tomasz Tyrakowski wrote: > > On 2012-08-07 16:06, Sofija Blazevski wrote: > > Problem is that generator values are changed (from nowhere) to some > > earlier version say about 15 days ago, on the other side all of the data > > is current. > > >From my own (sad ;-) ) experience I'd advise to blame Firebird last, > and first look through the code and make sure there are no statements > executing gen_id(generator, increment) with a _negative_ increment. > I'm not blaming firebird at all, but I would like to know what else could lead to such situation, some system misconfiguration, or I have no idea, like I said I never though it could happen like this. We never use negative increment, and this is only client installation with such issue.
> > > Do you have any idea what could have caused an issue like this? > > Could this be due to some windows issue? Same server had security.fdb > > corrupted about a month ago. > > The values of generators are stored per database, so corrupted security > DB shouldn't do any harm to them. > Perhaps it could ring a bell to someone what could be wrong with operating the system, I'm not suggesting its related to the problem :) > > > regards > Tomasz > > -- > __--==============================--__ > __--== Tomasz Tyrakowski ==--__ > __--== SOL-SYSTEM ==--__ > __--== http://www.sol-system.pl ==--__ > __--==============================--__ > > [Non-text portions of this message have been removed]