Re: Sequence Numbers Jumping
From: Flash Gordon <spam_at_flash-gordon.me.uk>
Date: Wed, 05 Mar 2008 20:55:24 +0000
Message-ID: <uud3a5xouf.ln2@news.flash-gordon.me.uk>
>
> Adding to that these are the reasons why you can get gaps:
>
> - caching enabled and sessions close without using all values cached so far
>
> - rollbacks on TX that inserted sequence values
>
> - deletions
>
> Did I miss one?
Date: Wed, 05 Mar 2008 20:55:24 +0000
Message-ID: <uud3a5xouf.ln2@news.flash-gordon.me.uk>
Robert Klemme wrote:
> On 05.03.2008 16:13, Ken Denny wrote:
>> On Mar 5, 6:36 am, Flash Gordon <s..._at_flash-gordon.me.uk> wrote:
<snip question about cause of gaps in sequences>
>> What do you mean by jumping? You mean there are gaps?
Yes.
>> There will >> always be gaps when using a sequence. I don't know how you managed to >> not have gaps using 9.
Well, we were not getting anywhere near as many, or so the application people tell me.
>> If gaps are not acceptable then you can't use >> sequences.
>
> Adding to that these are the reasons why you can get gaps:
>
> - caching enabled and sessions close without using all values cached so far
>
> - rollbacks on TX that inserted sequence values
>
> - deletions
>
> Did I miss one?
You missed application bugs :-)
Thank you everyone. It looks like it was the caching causing some of the problems and a bug in application causing most of the rest. I will also pass on your comments to the application people.
-- Flash GordonReceived on Wed Mar 05 2008 - 14:55:24 CST