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

Tue Jan 10 17:19:15 EST 2006

Hi Eric,

Thank you for writing. To answer your questions:

1.	MySQL and RT reside on the same server; I am using localhost as
the host name.
2.	MySQL has been operational since 21 December.
3.	I am trying to find out about the network blip.

We have had several hundred tickets created since 21 December, until
this happened.

Take care!

Nick

________________________________

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Schultz,
Eric
Sent: Tuesday, January 10, 2006 3:13 PM
To: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Ticket e-mailed, but doesn't make it to database

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(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/b863ae0f/attachment.htm>