Safe to delete "CachedGroupMembers"?

I have an RT instance that started out as RT2, was upgraded to RT3
soon after its release, and is now running 3.0.10.

A system crash several months ago caused some problems for the
database; we had to manually fix a few tables to get RT running again.
It’s now working mostly fine, except for a few niggling problems. In
particular, there’s one user who has been disabled, and who is not
listed in any groups or as a watcher of any queues (when I view them
with the web interface), who still gets AdminCCs on mail sent to one
of the queues.

My working theory is that there’s a problem with the CachedGroupMembers
table. My question is, is it safe to clear the values in this table?
Will RT re-create them?

Tom Holub (tom_holub@LS.Berkeley.EDU, 510-642-9069)
College of Letters & Science
249 Campbell Hall

My working theory is that there’s a problem with the CachedGroupMembers
table. My question is, is it safe to clear the values in this table?
Will RT re-create them?

No. This table should only be modified by RT itself when adding users to
or removing them from groups. And it only does this within a database
transaction, so it shouldn’t be able to get out of sync, unless you were
running without InnoDB tables or manually editing things.

Tom Holub wrote:

I have an RT instance that started out as RT2, was upgraded to RT3
soon after its release, and is now running 3.0.10.

A system crash several months ago caused some problems for the
database; we had to manually fix a few tables to get RT running again.
It’s now working mostly fine, except for a few niggling problems. In
particular, there’s one user who has been disabled, and who is not
listed in any groups or as a watcher of any queues (when I view them
with the web interface), who still gets AdminCCs on mail sent to one
of the queues.

You can use script that I wrote to fix tables when user doesn’t belong
to ‘everyone’ system group and when he is not in ‘priveleged’ or
‘unprivileged’.
http://lists.bestpractical.com/pipermail/rt-devel/2004-April/005710.html

My working theory is that there’s a problem with the CachedGroupMembers
table. My question is, is it safe to clear the values in this table?
Will RT re-create them?

RT wouldn’t recreate them. This records are created when user takes
membership in group.