Abnormal number of groups

RT Users
1

Hello,

Check this out:

mysql> SELECT COUNT(id) FROM Groups;
| count(id) |
| 4674 |

I don’t think this is normal behavior since, as the administrator, I have
not created this many groups (at least not intentionally). I may have an
idea as to where they come from, look at this:

mysql> SELECT COUNT(id) FROM Groups WHERE Domain = “RT::Ticket-Role”;
| COUNT(id) |
| 4496 |

We currently have about 1,100 tickets in the database. Every time a ticket
is created, a scrip runs using a template that contains the following code:

— CUT HERE
my $GroupName = ''Computer Support;

instantiate a group object

my $addGroupObj = RT::Group->new($RT::SystemUser);
$addGroupObj->LoadUserDefinedGroup($GroupName);
return undef unless $addGroupObj;
my $addGroupMembersObj = $addGroupObj->UserMembersObj;

my $res = ‘’;

walk through members of group to do stuff

while ( my $userObj = $addGroupMembersObj->Next) {
— CUT HERE

It seems that my $addGroupObj = RT::Group->new($RT::SystemUser) creates a
real group in the database. Can someone confirm?

I figuredit could be the case so after I’m done with that $addGroupObj, I
tried to clean things up by using

$addGroupObj->Delete();

Here is the error I got in the logs:

[Sun Jan 1 22:50:54 2012] [crit]: Deleting groups violates referential
integrity until we go through and fix this
(/usr/local/rt4/sbin/…/lib/RT/Group.pm:627)

I do not believe it’s healthy. I need to know if it’s really my template
that is causing the issue and if so, how can I gather the email addresses
for each member of an existing group without creating a new one.

I use RT 4.0.4. Thank you for your help.

Haïm Dimermanas

2

Hello,

Check this out:

mysql> SELECT COUNT(id) FROM Groups;
±----------+
| count(id) |
±----------+
| 4674 |
±----------+

I don’t think this is normal behavior since, as the administrator, I
have not created this many groups (at least not intentionally). I may
have an idea as to where they come from, look at this:

The Groups table also contains many internal groups RT uses for access
control. Don’t worry about it.

We currently have about 1,100 tickets in the database. Every time a
ticket is created, a scrip runs using a template that contains the
following code:

Your scrip isn’t causing this. Don’t delete groups, however.

It seems that my $addGroupObj = RT::Group->new($RT::SystemUser) creates
a real group in the database. Can someone confirm?

No, this just creates an RT::Group object.

Thomas