[rt-users] Internal Loop in RT 3.0.6

[Michael D. Richards]

I'm getting some sort of internal mail loop that I'm not sure how to 
stop. This is not coming from sendmail, but about every 15 minutes a 
ticket is being recreated. Along with this new ticket I'm getting a 
series of db errors in my log, a sample of which follows. These errors 
are only occuring on this message.

I'd appreciate any advice on how to stop this. It's creating a mess and 
I'm sure the requestor doesn't appreciate all the auto replys. :)

Thanks,
Michael~
-----------------------------------------------
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'INSERT INTO Attachments (Subject, ContentType, 
Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, 
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'SELECT  * FROM Tickets WHERE id = ?' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [err]: RT::Transaction=HASH(0x1f89a30) 
couldn't load ticket 15760
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'SELECT ACL.id from ACL, Groups, Principals, 
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName 
= 'SeeQueue') 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::Queue' AND ACL.ObjectId = '')) 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' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'SELECT ACL.id from ACL, Groups, Principals, 
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName 
= 'SeeQueue') 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::Queue' AND ACL.ObjectId = '')) AND  ( 
((Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 0)  )  AND 
Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND 
Principals.PrincipalType = 'Group')  LIMIT 1' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 145.
[Tue Dec 16 21:02:57 2003] [warning]: DBIx::SearchBuilder error:MySQL 
server has gone away
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st fetchrow_hashref 
failed: fetch() without execute() at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 163.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'SELECT  * FROM Tickets WHERE id = ?' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'SELECT ACL.id from ACL, Groups, Principals, 
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName 
= 'SeeQueue') 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::Queue' 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' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [warning]: DBD::mysql::st execute failed: 
MySQL server has gone away at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 410.
[Tue Dec 16 21:02:57 2003] [warning]: RT::Handle=HASH(0xd37a74) couldn't 
execute the query 'SELECT ACL.id from ACL, Groups, Principals, 
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName 
= 'SeeQueue') 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::Queue' AND ACL.ObjectId = '1')) AND  ( 
((Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1)  )  AND 
Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND 
Principals.PrincipalType = 'Group')  LIMIT 1' at 
/cm/tools/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm 
line 417.
[Tue Dec 16 21:02:57 2003] [info]: Ticket 15760 created in queue '' by 
<requestors addr removed> 
(/cmweb/tools/rt-3-0-6/lib/RT/Ticket_Overlay.pm:635)