[rt-users] MySQL Server has Gone a way; No ticket created but e-mail is sent

[Nick Metrowsky]

Hi Eric,

Thank you for writing. This seems to be logical that this variable needs
to be increased. I just did so. However, I have seen this error occur
when a simple text message was created via the web interface, e. g.
"This is a test".

Now, it could be possible that a large packet could be being sent when
the web is involved.

Take care!

Nick

------------------------------------------------------------------------
---------
Nick Metrowsky
Consulting System Administrator
303-684-4785 Office
303-684-4100 Fax
nmetrowsky at digitalglobe.com
DigitalGlobe (r), An Imaging and Information Company
http://www.digitalglobe.com
------------------------------------------------------------------------
---------

-----Original Message-----
From: Schultz, Eric [mailto:ESchultz at corp.untd.com] 
Sent: Friday, March 03, 2006 3:15 PM
To: Nick Metrowsky; Chaim Rieger
Cc: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] MySQL Server has Gone a way;No ticket created
but e-mail is sent


> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
> Of Nick Metrowsky
> Sent: Friday, March 03, 2006 1:42 PM
> To: Chaim Rieger
> Cc: rt-users at lists.bestpractical.com
> Subject: RE: [rt-users] MySQL Server has Gone a way;No ticket 
> created but e-mail is sent
> 
> Hi Chaim,
> 
> Thank you for writing. Please find below the output of my 
> MySQL variables from mysqladmin.
> 
> Thank you for your help in advance.
> 
> Take care!
> 
> Nick
> 
> +---------------------------------+---------------------------
> | max_allowed_packet              | 1047552                   
>

This is the variable of interest.  Unfortunately, MySQL doesn't tell you
why it dropped the connection, it just does it.  In some testing, I
found that if you are trying to do too large of an extended insert, or a
single insert is too large, your insert will fail.  This is normally
caused by large attachments, such as those over 20MB.  In your case,
anything over 1MB will fail, because that's what max_allowed_packet is
set at.  I'd bet that the 1% of the time this happens is when someone
attaches a large file.  Increase this variable and modify mysql so that
this is something that is set whenever the daemon starts up.  To set
this in the current running daemon:

mysql> set global max_allowed_packet=1677216;