[rt-users] Oracle sequences in Tickets table being skipped

[Nathan, Ahalya]

This hasn't caused a problem so far, because we are not missing any
tickets. When many tickets were created and some go out of sequence,
users got a little confused as to why the creation of tickets was not
happening in sequence. I was wondering if there is any impact if I have
the NOCACHE option for the Ticket Sequences in RT. I couldn't understand
why this is happening now because we had RT3.4.1(before we changed to RT
3.4.4) with the same Oracle database and then the tickets were always
created in sequence. 

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District 
(402) 504-7180 phone
(402) 504-5180 fax



-----Original Message-----
From: Stephen Turner [mailto:sturner at MIT.EDU] 
Sent: Monday, January 09, 2006 12:07 PM
To: Nathan, Ahalya; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Oracle sequences in Tickets table being skipped

At Monday 1/9/2006 12:52 PM, Nathan, Ahalya wrote:

>Hi all,
>
>We are using RT 3.4.4, fastcgi and Oracle in our production
environment. 
>The problem that we are facing right now is that ticket creation is 
>created in skipped sequences. I checked up the TICKETS.SEQUENCE script
and 
>found that there is a cache option=20 being provided. I did check up on

>the internet and found this website: 
>http://www.arikaplan.com/oracle/ari82599.html , which says that :
>
>Applications which use Oracle sequences which have the CACHE option 
>enabled will often 'skip' values.
>
>Did anyone have this problem of skipping oracle sequences? If yes, how
did 
>you solve it? It would be really helpful if some one could give me tips

>how to go about this.

The article you point to seems to do a pretty good job explaining why
this 
happens and how to minimize the effect. What was it you needed to know
that 
the article didn't cover? Also, I'm wondering why this is a problem?

Steve