<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi Everyone,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Jan 10 15:20:06 helpdesk RT:
<rt-3.4.4-18623-1136906406-1126.15749-2-0@digitalglobe.com> #15749/84441
- Scrip 2 (/opt/rt3/lib/RT/Action/SendEmail.pm:237) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Jan 10 15:20:06 helpdesk RT:
<rt-3.4.4-18623-1136906406-1126.15749-2-0@digitalglobe.com> sent To:
Kdenney@digitalglobe.com Cc: Bcc:
(/opt/rt3/lib/RT/Action/SendEmail.pm:297) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Jan 10 15:20:06 helpdesk RT:
<rt-3.4.4-18623-1136906406-1338.15749-3-0@digitalglobe.com> #15749/84441
- Scrip 3 (/opt/rt3/lib/RT/Action/SendEmail.pm:237) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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'<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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_<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Jan 10 15:20:06 helpdesk RT:
<rt-3.4.4-18623-1136906406-1338.15749-3-0@digitalglobe.com> sent To:
Kdenney@digitalglobe.com Cc: cs, dgreen@digitalglobe.com,
dnussbaumer@digitalglobe.com, jtregenza@digitalglobe.com Bcc:
dtrue@digitalglobe.com, gcopeland@digitalglobe.com
(/opt/rt3/lib/RT/Action/SendEmail.pm:297) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Anyone have an idea what would cause these errors? Thank you
for your time.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Take care!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Nick<o:p></o:p></span></font></p>
</div>
</body>
</html>