[rt-users] Ticket missing from database

Mike Friedman mikef at ack.Berkeley.EDU
Thu Dec 1 11:58:50 EST 2005

Hash: SHA1

On Thu, 1 Dec 2005 at 10:20 (+0300), Ruslan Zakirov wrote:

> DB transactions! You couldn't assume that ID sequences is without gaps 
> even if you don't delete anything.


Aha!  I guess this was my misunderstanding (or oversight).  I had been 
assuming that when you use the Load method on an ID number, it always 
meant a ticket number.  But clearly that's not right, since all kinds of 
objects in RT have ID numbers.

So, now I really would like to know (as I asked in a more recent posting) 
if there's a way, using the API, to determine the highest *ticket ID* that 
has been assigned thus far.  My script (which displays all deleted tickets 
in a range of ticket numbers) can ignore the IDs that don't load as 
tickets, but I'd like to know when to stop searching when the specified 
range is all existing tickets:  I would stop when I reached the first ID 
greater than or equal to the last ticket ID assigned.

I'm trying to reduce my log traffic by minimizing the number of ticket 
Load failures that get logged when I run this script.  So I don't want to 
just keep going up to some arbitrarily large number.

Thanks again.


Mike Friedman                   System and Network Security
mikef at ack.Berkeley.EDU          2484 Shattuck Avenue
1-510-642-1410                  University of California at Berkeley
http://ack.Berkeley.EDU/~mikef  http://security.berkeley.edu

Version: PGP 6.5.8


More information about the rt-users mailing list