Ticket e-mailed, but doesn't make it to database

Nick_Metrowsky · January 10, 2006, 10:07pm

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@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@digitalglobe.com sent To:
Kdenney@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@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@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)

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

Schultz_Eric · January 10, 2006, 10:12pm

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@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Nick Metrowsky
Sent: Tuesday, January 10, 2006 2:08 PM
To: rt-users@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@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@digitalglobe.com sent To: Kdenney@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@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(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

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@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)

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(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

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(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

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

Nick_Metrowsky · January 10, 2006, 10:19pm

Hi Eric,

Thank you for writing. To answer your questions:

MySQL and RT reside on the same server; I am using localhost as
the host name.
MySQL has been operational since 21 December.
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!

NickFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Schultz,
Eric
Sent: Tuesday, January 10, 2006 3:13 PM
To: rt-users@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?

Jesse_Vincent · January 11, 2006, 3:49pm

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@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@digitalglobe.com sent To:
Kdenney@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@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)

At a guess, your max_packet for mysql is too small. What’s in mysql’s
error logs?

Jesse

Nick_Metrowsky · January 11, 2006, 3:54pm

Hi Jesse,

Thank you for writing. There are no errors in the MySQL log file. Also,
the max_allowed_packet variable is set to 25165824, max_buffer_length is
1047551. I am starting to think that there was some sort of network
blip, though I could not get any confirmation of one.

Take care!

NickFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, January 11, 2006 8:49 AM
To: Nick Metrowsky
Cc: rt-users@lists.bestpractical.com
Subject: Re: [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@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@digitalglobe.com sent To:
Kdenney@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@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)

At a guess, your max_packet for mysql is too small. What’s in mysql’s
error logs?

Jesse

Anyone have an idea what would cause these errors? Thank you for your
time.

Take care!

Nick

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

Carl_Makin · January 12, 2006, 10:59pm

Hi Jesse,

Thank you for writing. There are no errors in the MySQL log file. Also,
the max_allowed_packet variable is set to 25165824, max_buffer_length is
1047551. I am starting to think that there was some sort of network
blip, though I could not get any confirmation of one.

Take care!

NickFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, January 11, 2006 8:49 AM
To: Nick Metrowsky
Cc: rt-users@lists.bestpractical.com
Subject: Re: [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@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@digitalglobe.com sent To:
Kdenney@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@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)

At a guess, your max_packet for mysql is too small. What’s in mysql’s
error logs?

Jesse

Anyone have an idea what would cause these errors? Thank you for your
time.

Take care!

Nick

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html