RT Hangs when removing users from group

Yoav_Daniely · April 11, 2005, 8:14am

Greetings,

I have an RT installation version 3.4.1 that has been upgraded from rt
3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless
I restart apache.
I enabled logging on mysql and I get the following line when removing the
user (in an endless loop)

6 Query SELECT * FROM CachedGroupMembers WHERE MemberId = ‘1’ AND
GroupId = ‘36’ AND Disabled = ‘0’

When I run this query by hang I get an empty set.

other logs are empty.
Any Ideas?

Regards,

        Yoav Daniely.

Yoav_Daniely · April 11, 2005, 10:08am

Ian,

1.mysql 4.0.18
2. DBIx::SearchBuilder ver 1.22

Regards,

    YoavFrom: Norton, Ian [mailto:i.norton@lancaster.ac.uk]

Sent: Monday, April 11, 2005 1:01 PM
To: Yoav Daniely; rt-users@lists.fsck.com
Subject: RE: [rt-users] RT Hangs when removing users from group

Yoav,

What database are you using and which version of SearchBuilder?

Regards, Ian.

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Yoav Daniely
Sent: 11 April 2005 09:14
To: rt-users@lists.fsck.com
Subject: [rt-users] RT Hangs when removing users from group

Greetings,

I have an RT installation version 3.4.1 that has been upgraded from rt
3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless
I restart apache.
I enabled logging on mysql and I get the following line when removing the
user (in an endless loop)

6 Query SELECT * FROM CachedGroupMembers WHERE MemberId = ‘1’ AND
GroupId = ‘36’ AND Disabled = ‘0’

When I run this query by hang I get an empty set.

other logs are empty.
Any Ideas?

Regards,

        Yoav Daniely.

Ian_Norton · April 11, 2005, 10:00am

Yoav,

What database are you using and which version of SearchBuilder?

Regards, Ian.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Yoav
Daniely
Sent: 11 April 2005 09:14
To: rt-users@lists.fsck.com
Subject: [rt-users] RT Hangs when removing users from group

Greetings,

I have an RT installation version 3.4.1 that has been upgraded from rt
3.0.10.
I followed the upgrade path as documents and everything seemed fine
until I had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt
unless I restart apache.
I enabled logging on mysql and I get the following line when removing
the user (in an endless loop)

6 Query SELECT * FROM CachedGroupMembers WHERE MemberId = ‘1’
AND GroupId = ‘36’ AND Disabled = ‘0’

When I run this query by hang I get an empty set.

other logs are empty.
Any Ideas?

Regards,

        Yoav Daniely.

Jesse_Vincent · April 11, 2005, 12:52pm

Greetings,

I have an RT installation version 3.4.1 that has been upgraded from rt
3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless
I restart apache.
I enabled logging on mysql and I get the following line when removing the
user (in an endless loop)

Is it 100% reproducible?

Tim_Wilson · April 11, 2005, 1:34pm

I have an RT installation version 3.4.1 that has been upgraded from rt 3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless I
restart apache.
I enabled logging on mysql and I get the following line when removing the user
(in an endless loop)

I’m seeing this too with RT 3.2.3 and Postgres 7.4

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA (4456.013’N 9324.736’W)
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

Jesse_Vincent · April 11, 2005, 1:53pm

I have an RT installation version 3.4.1 that has been upgraded from rt 3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless I
restart apache.
I enabled logging on mysql and I get the following line when removing the user
(in an endless loop)

I’m seeing this too with RT 3.2.3 and Postgres 7.4

Same database query?

Tim_Wilson · April 11, 2005, 3:06pm

I’m seeing this too with RT 3.2.3 and Postgres 7.4

Same database query?

I haven’t tried it myself, but my colleague reports that he had to restart
apache after trying to remove someone from a group. It was definitely
reproducible. I don’t have any more detailed information than that at the
moment unfortunately.

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA (4456.013’N 9324.736’W)
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

Yoav_Daniely · April 11, 2005, 10:09pm

It happens everytime I try to do that.

Any ideas? can the "cachedgroupmembers" table be recreated from the groupmembers table?

ן¿½ן¿½ן¿½ן¿½ן¿½ן¿½ן¿½ן¿½ן¿½ Yoav

> On 4/11/05 8:53 AM, "Jesse Vincent" wrote:

>

>>> I’m seeing this too with RT 3.2.3 and Postgres 7.4

>>

>> Same database query?

>

> I
haven’t tried it myself, but my colleague reports that he had to restart

> apache after trying to remove someone from a group. It was
definitely

> reproducible. I don’t have any more detailed
information than that at the

> moment unfortunately.

>

> -Tim

>

> –

> Timothy Wilson

> Technology Integration Specialist

> Hopkins ISD #270,
Hopkins, MN, USA (44ן¿½56.013’N 93ן¿½24.736’W)

> ph: 952.988.4103
fax: 952.988.4311 AIM: tis270

>

>
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

>

> RT Administrator and Developer training is coming to
your town soon!

> (Boston, San Francisco, Austin, Sydney) Contact
training@bestpractical.com

> for details.

>

>
Be sure to check out the RT Wiki at http://wiki.bestpractical.com

>

Scott_Muller · April 12, 2005, 3:18am

I have an RT installation version 3.4.1 that has been upgraded from rt 3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless I
restart apache.
I enabled logging on mysql and I get the following line when removing the user
(in an endless loop)

I am also seeing this happen.

FreeBSD 5.3
rt 3.2.2
perl 5.8.6_2
p5-DBIx-SearchBuilder-1.22
mysql 4.1.9
apache-1.3.33_1
fastcgi

ANY attempt to delete a user from a group leads to the following SQL
query being repeated until apache is restarted

SELECT * FROM CachedGroupMembers WHERE Disabled = ‘0’ AND GroupId =
‘29’ AND MemberId = ‘1’

This install has been upgraded over time from 3.?. This happens if the
user being removed existed before the upgrade or if it is a new user.

Scott Muller.

Yoav_Daniely · April 13, 2005, 6:33am

Greetings,
Any ideas how to fix/workaround this issue?

Regards,

	YoavFrom: rt-users-bounces@lists.bestpractical.com

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Tim Wilson
Sent: Monday, April 11, 2005 6:07 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Hangs when removing users from group

I’m seeing this too with RT 3.2.3 and Postgres 7.4

Same database query?

I haven’t tried it myself, but my colleague reports that he had to restart
apache after trying to remove someone from a group. It was definitely
reproducible. I don’t have any more detailed information than that at the
moment unfortunately.

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA (44š56.013’N 93š24.736’W)
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Yoav_Daniely · April 13, 2005, 6:53am

I just found out that recreated groups does not have this problem (so I am
recreating all groups/permissions)

FYIFrom: rt-users-bounces@lists.bestpractical.com

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Yoav Daniely
Sent: Wednesday, April 13, 2005 9:33 AM
To: ‘Tim Wilson’; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Hangs when removing users from group

Greetings,
Any ideas how to fix/workaround this issue?

Regards,

	Yoav

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Tim Wilson
Sent: Monday, April 11, 2005 6:07 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Hangs when removing users from group

I’m seeing this too with RT 3.2.3 and Postgres 7.4

Same database query?

I haven’t tried it myself, but my colleague reports that he had to restart
apache after trying to remove someone from a group. It was definitely
reproducible. I don’t have any more detailed information than that at the
moment unfortunately.

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA (44š56.013’N 93š24.736’W)
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Neil_Troy · April 21, 2005, 5:59pm

I have noticed that at our site we have the same problem; being unable
to remove users from groups. We are upgrading from 3.0.4pre1 to
3.4.2rc1. We have seen this error when we tried 3.4.1 too.

Old Installation Info:

Linux version 2.4.20-8, Red Hat Linux release 9 (Shrike)
Mysql: Ver 4.0.12 for pc-linux on i686
Apache v2.0.47
DBIx::SearchBuilder v0.92
RT-Version: 3.0.4pre1

New Installation Info:

Linux version 2.6.3, Debian Sarge
Mysql: Ver 4.0.22_Debian-6-log for pc-linux on i386 (Source distribution)
Apache v1.3.33
DBIx::SearchBuilder v1.26
Rt-Version: 3.4.2rc1

Here is a brief overview of how I upgraded from RT 3.0.4On the new host, install RT 3.4.2rc1 following the instructions from the wiki: download source, make fixdeps, etc… Then I drop the rt3 database on the new host. I create a backup of the rt3 database from our old host using the following command: mysqldump -u root -p --opt -B rt3 > rt3.sql I then import this on the new host, and run the database upgrade scripts in rt/etc/upgrade for 3.1.0 through 3.3.11. Copy over RT_SiteConfig.pm, add our needed .htaccess files and start apache. RT works great, except that we can no longer remove users from groups. I can create new groups, and it works fine. Here are some log entries from our new host: /var/log/syslog Apr 21 12:25:32 data RT: Deep recursion on subroutine “RT::ACE::_Value” at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Record.pm line 425. (/usr/local/rt3/lib/RT.pm:277) /var/log/mysql/mysql.log The query on the last line is repeated over and over until apache is stopped. 58 Query SELECT * FROM Users WHERE id = ‘1’ 58 Query SELECT * FROM Principals WHERE PrincipalType = ‘User’ AND ObjectId = ‘1’ 58 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = ‘SuperUser’ OR ACL.RightName = ‘ShowACL’) AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = ‘1’ AND ( ACL.ObjectType = ‘RT::System’ OR (ACL.ObjectType = ‘RT::System’ AND ACL.ObjectId = ‘1’)) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR Groups.Domain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain = ‘Personal’)) ) LIMIT 1 58 Query SELECT * FROM CachedGroupMembers WHERE Disabled = ‘0’ AND GroupId = ‘24’ AND MemberId = ‘1’ 58 Query SELECT * FROM CachedGroupMembers WHERE Disabled = ‘0’ AND GroupId = ‘24’ AND MemberId = ‘1’ I also noticed while looking at the tables that in the groups table the new groups had a 0 in the ‘Instance’ column, where as all the old groups didn’t. This may not be relevant. ±------±------------±----------------------------------------±------------±-----±---------+ | id | Name | Description |Domain | Type |Instance | ±------±------------±----------------------------------------±------------±-----±---------+ | 24 | ECE-ITS_old | ECE IT Support | UserDefined | | | | 22360 | ECE-ITS | NULL | UserDefined | | 0 | | 22361 | Public | NULL |UserDefined | | 0 | ±------±------------±----------------------------------------±------------±-----±---------+ Yoav Daniely wrote:

Greetings,

I have an RT installation version 3.4.1 that has been upgraded from rt
3.0.10.
I followed the upgrade path as documents and everything seemed fine until I
had to remove a user from a group.
When I remove the users httpd hangs on 80% CPU and I cannot access rt unless
I restart apache.
I enabled logging on mysql and I get the following line when removing the
user (in an endless loop)

6 Query SELECT * FROM CachedGroupMembers WHERE MemberId = ‘1’ AND
GroupId = ‘36’ AND Disabled = ‘0’

When I run this query by hang I get an empty set.

other logs are empty.
Any Ideas?

Regards,
       Yoav Daniely.
The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com