[rt-users] Ticket e-mailed, but doesn't make it to database

Schultz, Eric ESchultz at corp.untd.com
Tue Jan 10 17:12:49 EST 2006 

Is the MySQL server on the same machine as your RT instance?  Perhaps it was a network blip?  Do the MySQL logs show the daemon being restarted?

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Nick Metrowsky
Sent: Tuesday, January 10, 2006 2:08 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Ticket e-mailed, but doesn't make it to database



Hi Everyone,

 

We have been using rt-3.4.4, MySQL V4.1.15, Apache V 2.0.55 and mod_perl V2. For the past few weeks, everything has been running fine. Today, within 40 minutes of each other, two tickets never made it into the database, but an e-mail was sent that the ticket was created. After looking through several logs, the /var/log/messages file gave the following clue:

 

Jan 10 15:20:06 helpdesk RT: <rt-3.4.4-18623-1136906406-1126.15749-2-0 at digitalglobe.com> #15749/84441 - Scrip 2  (/opt/rt3/lib/RT/Action/SendEmail.pm:237)  

Jan 10 15:20:06 helpdesk RT: <rt-3.4.4-18623-1136906406-1126.15749-2-0 at digitalglobe.com> sent To: Kdenney at digitalglobe.com Cc:  Bcc:  (/opt/rt3/lib/RT/Action/SendEmail.pm:297)  

Jan 10 15:20:06 helpdesk RT: <rt-3.4.4-18623-1136906406-1338.15749-3-0 at digitalglobe.com> #15749/84441 - Scrip 3  (/opt/rt3/lib/RT/Action/SendEmail.pm:237)  

Jan 10 15:20:06 helpdesk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287)  

Jan 10 15:20:06 helpdesk RT: RT::Handle=HASH(0xa9c25b0) couldn't execute the query 'INSERT INTO Transactions (OldReference, Field, Type, OldValue, NewReference, NewValue, Creator, ObjectId, ReferenceType, Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 506       DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa9c25b0)', 'INSERT INTO Transactions (OldReference, Field, Type, OldValue...', 'undef', 'undef', 'EmailRecord', 'undef', 'undef', 'undef', 1, ...) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 366       DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xa9c25b0)', 'Transactions', 'OldReference', 'undef', 'Field', 'undef', 'Type', 'EmailRecord', 'OldValue', ...) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle/mysql.pm line 39       DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0xa9c25b0)', 'Transactions', 'OldReference', 'undef', 'Field', 'undef', 'Type'

Jan 10 15:20:06 helpdesk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287)  

Jan 10 15:20:06 helpdesk RT: RT::Handle=HASH(0xa9c25b0) couldn't execute the query 'SELECT  * FROM Transactions WHERE id = ?' at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 506       DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa9c25b0)', 'SELECT  * FROM Transactions WHERE id = ?', 0) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line 1218       DBIx::SearchBuilder::Record::_LoadFromSQL('RT::Transaction=HASH(0xb4f917c)', 'SELECT  * FROM Transactions WHERE id = ?', 0) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line 1133       DBIx::SearchBuilder::Record::LoadByCols('RT::Transaction=HASH(0xb4f917c)', 'id', 0) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record/Cachable.pm line 137       DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::Transaction=HASH(0xb4f917c)', 'id', 0) called at /opt/rt3/lib/RT/Record.pm line 392       RT::Record::LoadByCols('RT::Transaction=HASH(0xb4f917c)', 'id', 0) called at /usr/local/lib/perl5/site_

Jan 10 15:20:06 helpdesk RT: RT::Attachment->Create couldn't, as you didn't specify a transaction  (/opt/rt3/lib/RT/Attachment_Overlay.pm:147)  

Jan 10 15:20:06 helpdesk RT: <rt-3.4.4-18623-1136906406-1338.15749-3-0 at digitalglobe.com> sent To: Kdenney at digitalglobe.com Cc: cs, dgreen at digitalglobe.com, dnussbaumer at digitalglobe.com, jtregenza at digitalglobe.com Bcc: dtrue at digitalglobe.com, gcopeland at digitalglobe.com (/opt/rt3/lib/RT/Action/SendEmail.pm:297)  

Jan 10 15:20:06 helpdesk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287)  

Jan 10 15:20:06 helpdesk RT: RT::Handle=HASH(0xa9c25b0) couldn't execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 506       DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa9c25b0)', 'UPDATE Tickets SET LastUpdated=? WHERE id=? ', '2006-01-10 15:20:06', 15749) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 413       DBIx::SearchBuilder::Handle::UpdateRecordValue('RT::Handle=HASH(0xa9c25b0)', 'Table', 'Tickets', 'IsSQLFunction', 'undef', 'Column', 'LastUpdated', 'PrimaryKeys', 'HASH(0xb42062c)', ...) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line 841       DBIx::SearchBuilder::Record::__Set('RT::Ticket=HASH(0xb3ee760)', 'Value', '2006-01-10 15:20:06', 'Field', 'LastUpdated') called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record/Cachable.pm line 158       DBIx::SearchBuilder::Record::Cachable::__Set('RT::Ticket=HASH(0xb3ee760)', 'Field', 'LastUpdated', 'Value', '2

Jan 10 15:20:06 helpdesk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287)  

Jan 10 15:20:06 helpdesk RT: RT::Handle=HASH(0xa9c25b0) couldn't execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 506       DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa9c25b0)', 'UPDATE Tickets SET LastUpdated=? WHERE id=? ', '2006-01-10 15:20:06', 15749) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 413       DBIx::SearchBuilder::Handle::UpdateRecordValue('RT::Handle=HASH(0xa9c25b0)', 'Table', 'Tickets', 'IsSQLFunction', 'undef', 'Column', 'LastUpdated', 'PrimaryKeys', 'HASH(0xb422afc)', ...) called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line 841       DBIx::SearchBuilder::Record::__Set('RT::Ticket=HASH(0xb3ee760)', 'Value', '2006-01-10 15:20:06', 'Field', 'LastUpdated') called at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record/Cachable.pm line 158       DBIx::SearchBuilder::Record::Cachable::__Set('RT::Ticket=HASH(0xb3ee760)', 'Field', 'LastUpdated', 'Value', '2

Jan 10 15:20:06 helpdesk RT: Ticket 15749 created in queue 'Y_G_GeoOps_SPG' by guest (/opt/rt3/lib/RT/Ticket_Overlay.pm:730)  

Jan 10 15:20:06 helpdesk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. (/opt/rt3/lib/RT.pm:287)  

 

Anyone have an idea what would cause these errors? Thank you for your time.

 

Take care!

 

Nick

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060110/4a686fd9/attachment.htm>

More information about the rt-users mailing list