Probably because I’m embarassed ;-). I’ve been really stumped as to what
happend and now I’ve finally determined that ALL these tickets (120) with
missing GROUP/PRINCIPALS Table records were created within 3 seconds and ALL
in the same Queue over a year ago. That lead me to conclude that I had a
User that went ahead and created a temporary scrip to mass create some
tickets and failed to insert a GROUPS & PRINCIPALS record for each ticket in
that code (BAD TOAD!!). I’ll be stopping by his office for a few words (of
This can be corrected, so no big deal at the moment, since all these tickets
belong to the same person.
By the way, I got rt-validator to run. Thanks. I’m going to set up a monthly
cron job to run it so I can monitor stuff like this.
Thanks for your help.
LBNLOn Tue, Jun 21, 2011 at 1:34 PM, Kevin Falcone email@example.com:
On Tue, Jun 21, 2011 at 12:46:00PM -0700, Kenneth Crocker wrote:
I also noticed, while perusing the DB, that there are a lot of gaps in
ticket numbers and the
create dates are in the evening when no one is around in the building,
usually around midnight
(TICKETS sorted in ID sequence).
What is rt-validator?
rt-validator ships with RT. Just run find /opt/rt3 -name rt-validator
and read the documentation.
You’ve not given any information that would allow me to comment on
ticket id gaps.
2011 Training: http://bestpractical.com/services/training.html