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

[Jesse Vincent]

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

--