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

[Carl Makin]

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!

Nick

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com]
Sent: Wednesday, January 11, 2006 8:49 AM
To: Nick Metrowsky
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Ticket e-mailed, but doesn't make it to database




On Tue, Jan 10, 2006 at 03:07:52PM -0700, Nick Metrowsky wrote:
> 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)  

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
> 

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

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