<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=721531122-10012006><FONT face=Arial color=#0000ff size=2>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?</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]<B>On Behalf Of </B>Nick
Metrowsky<BR><B>Sent:</B> Tuesday, January 10, 2006 2:08 PM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> [rt-users] Ticket
e-mailed, but doesn't make it to database<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi
Everyone,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Take
care!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Nick<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>