[rt-users] Rebuild Groups Table

[Kenneth Crocker]

Kevin,

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
wisdom).

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.

Kenn
LBNL

On Tue, Jun 21, 2011 at 1:34 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

> 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?
>
> Kenn
>
> 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.
>
> -kevin
>
>
> --------
> 2011 Training: http://bestpractical.com/services/training.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110623/9c46bb55/attachment.htm>