[rt-users] The dreaded "MySQL server has gone away"

[Nick Metrowsky]

Hi Everyone,

 

While I am generally please with Request Tracker V3, and I know it is
free software and does more than commercial products selling for
thousands of dollars, it does have it glitches. We are running RT-3.4.4,
MySQL V4.1.5, Apache 2.0.55, mod_per2, perl 5.8.7,
DBIx-SearchBuilder-1.35.

 

We get hundreds of tickets per day, without any issues. So far, since we
upgraded to 3.4.4 from 2.x, we have had about 25 incidents out of 2500+
tickets submitted (since 21 December, 2005) with the following result:

 

error: 

DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
70.

context: 

... 

 

66: 

if ($self->{lock}) {

67: 

local $self->{dbh}->{RaiseError} = 1;

68: 

 

69: 

my $sth = $self->{dbh}->prepare_cached(q{SELECT RELEASE_LOCK(?)}, {},
1);

70: 

$sth->execute($self->{lockid});

71: 

 

72: 

$self->{lock} = 0;

73: 

} 

74: 

}

... 

 

code stack: 

/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:70
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:81
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:87
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm:1258

 

The worse part it sends out e-mail to everyone and the ticket never is
created in the database.

 

As far as the system goes, the MySQL server and the various software
components are not being restarted or manipulated in any way. It looking
at /var/log/messages, it looks like Request Tracker cannot access the
MySQL server. Yet, the MySQL logs indicate there are no errors related
to the software. Matter of, the only thing in the logs was when the
server was started.

 

Any information about this issue would be most helpful.

 

Take care!

 

Nick

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060209/ddf9afa9/attachment.htm>