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

[Nick Metrowsky]

Hi Eric & Todd,

I believe both of you are right. According to mysqladmin, the
wait_timeout variable is set to 28800 (I assume this is seconds) or 480
minutes. The MySQL server has gone away message is almost immediate. By
the way, my connect timeout is set to 5, should I increase that to lets
say 60?

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:34 PM
To: Todd Chapman; Nick Metrowsky
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: Todd Chapman [mailto:todd at chaka.net] 
> Sent: Friday, March 03, 2006 2:26 PM
> To: Nick Metrowsky
> Cc: Schultz, Eric; Chaim Rieger; rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] MySQL Server has Gone a way; No 
> ticket created but e-mail is sent
> 
> On Fri, Mar 03, 2006 at 03:22:53PM -0700, Nick Metrowsky wrote:
> > 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
> > 
> 
> I doubt it. With no attachments the data should be easily
> less thatn 1 meg.
> 
> I would lower that variable back to the previous setting
> and see what happens wehn you send a larger attachment.
> 
> -Todd
> 

If it's happening for something so small, then Todd is right, that won't
be the problem.  There are various settings to mess with on your MySQL
server, but I wonder if it isn't just a network problem between the
database machine and the machine RT is hosted on?  Maybe have mtr
running for awhile and see if any packets are getting dropped.  Are you
able to put the two on the same machine?

This may also shed some light:
http://dev.mysql.com/doc/refman/4.1/en/gone-away.html

Eric