<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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* 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;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1217161863;
mso-list-type:hybrid;
mso-list-template-ids:599397098 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Eric,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thank you for writing. To answer your
questions:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>MySQL
and RT reside on the same server; I am using localhost as the host name.<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>MySQL
has been operational since 21 December.<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
am trying to find out about the network blip.<o:p></o:p></span></font></li>
</ol>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>We have had several hundred tickets
created since 21 December, until this happened.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Take care!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Nick<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b><span style='font-weight:
bold'>On Behalf Of </span></b>Schultz, Eric<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, January 10, 2006
3:13 PM<br>
<b><span style='font-weight:bold'>To:</span></b> rt-users@lists.bestpractical.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [rt-users] Ticket
e-mailed, but doesn't make it to database</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>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?</span></font><o:p></o:p></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com]<b><span
style='font-weight:bold'>On Behalf Of </span></b>Nick Metrowsky<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, January 10, 2006
2:08 PM<br>
<b><span style='font-weight:bold'>To:</span></b>
rt-users@lists.bestpractical.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [rt-users] Ticket
e-mailed, but doesn't make it to database</span></font><o:p></o:p></p>
<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><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><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><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><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><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><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><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><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><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><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><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><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><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><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><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><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>
</blockquote>
</div>
</body>
</html>