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

[Ruslan Zakirov]

I saw such problem with mod_perl-2.0.x, then I rebuilt perl, libperl,
mod_perl, DBI and DBD::mysql from sources and problem's gone away, I
don't know exactly reason of the error.

2ALL: max_allowed_packet don't drop connections, but generate error
message, error "mysql has gone away" means that your server was
killed/seg faulted or something like that.

On 3/4/06, Nick Metrowsky <nmetrowsky at digitalglobe.com> 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
>
> ------------------------------------------------------------------------
> ---------
> 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;
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.htm
>


--
Best regards, Ruslan.