Internal Loop in RT 3.0.6

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. :slight_smile:

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

(/cmweb/tools/rt-3-0-6/lib/RT/Ticket_Overlay.pm:635)

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. :slight_smile:

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

(/cmweb/tools/rt-3-0-6/lib/RT/Ticket_Overlay.pm:635)


rt-users mailing list
rt-users@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.