At 07:36 AM 17/11/2011, Carlos H. Cantu wrote:

>I was talking with Vlad Khorsun about this.
>
>He said a related problem was fixed 1.5 years ago in Firebird. At last
>in recent FB versions, generators page are flushed when *any*
>transaction is commited/rolledback.

Actually, it was fixed in v.1.5.1: from release notes --
"Generator bugs (2) fixed by Oleg Loa, Vlad Horsun, Dmitry Yemanov
(1.5.1) Generator pages were not flushed properly, causing generator value changes to be lost after a server failure, even in Forced Writes mode"

>So, Ed, please try with FB 2.5.1 and see if the problem still exists.
>Also, remember to have Forced Writes ON. If you can reproduce it with
>FB 2.5.1, please open a issue in the Firebird tracker, and attach your
>code example to it.

He's using Fb 1.5, which is not going to get any more fixes - it came to the end of the road in October 2009.

But maybe he needs to check whether the sites that have the problem are using Fb 1.5.0....

Helen