RT 3.2.1 problem - ticket create fails

RT Developers
1

Hi,

I’ve recently installed RT 3.2.1 on SuSE 9.1 . I have the following
problem. From time to time, when I try to create a ticket, RT fails with
this message:

error: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.3/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/lib/perl5/site_perl/5.8.3/Apache/Session/Lock/MySQL.pm:70
/usr/lib/perl5/site_perl/5.8.3/Apache/Session/Lock/MySQL.pm:81
/usr/lib/perl5/site_perl/5.8.3/Apache/Session/Lock/MySQL.pm:87
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm:1078

the mysql server it’s up and running, and a show processlist looks like
this:

mysql> show processlist; | Id | User | Host | db | Command | Time | State | Info | | 35 | rt_dbuser | localhost | rt3 | Sleep | 192 | | NULL | | 36 | rt_dbuser | localhost | rt3 | Sleep | 193 | | NULL | | 37 | rt_dbuser | localhost | rt3 | Sleep | 577 | | NULL | | 38 | rt_dbuser | localhost | rt3 | Sleep | 164 | | NULL | | 40 | rt_dbuser | localhost | rt3 | Sleep | 217 | | NULL | | 41 | rt_dbuser | localhost | rt3 | Sleep | 216 | | NULL | | 42 | root | localhost | NULL | Query | 0 | NULL | show processlist |

Any ideeas ?

signature.asc (189 Bytes)