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

Tue Jan 10 17:07:52 EST 2006

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(0xb4f917
c)', '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(0xa9c25b
0)', '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(0xa9c25b
0)', '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/2dbc77d5/attachment.htm>