[rt-users] Internal Loop in RT 3.0.6

[Jesse Vincent]

On Wed, Dec 17, 2003 at 11:33:07AM -0700, Michael D. Richards wrote:
> 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. :)

That sure looks like you've got a mail message that's knocking over RT's
database, causing it to return an error..after having sent out the
relevant mail. And because your MTA sees an error, it's retrying RT 15
minutes later.    
So. Capture that message for debugging, clear it out of your mail queue,
make sure you're running the latest mysql (database queries shouldn't
make your database go away) and then upgrade to rt 3.0.7, which handles
mail failure more elegantly.


> 
> 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)
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.