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,

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.

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.

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?

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 (44š56.013’N 93š24.736’W)
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

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?

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

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

>

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.

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

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

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.


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