[Rt-devel] RT 3.2.1 problem - ticket create fails

SUBREDU Manuel diablo at iasi.roedu.net
Sat Aug 21 07:53:23 EDT 2004


 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:

<quote>
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
</quote>

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

<quote>
 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 |
+----+-----------+-----------+------+---------+------+-------+------------------+
</quote>

 Any ideeas ?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20040821/dadcf6cd/attachment.pgp


More information about the Rt-devel mailing list