[rt-users] RT 3.6.5 - DBD::mysql::st error when trying to create a ticket

[Will Dennis]

Hi all,
 
I'm having a problem with my new RT installation - when I try to enter a
ticket thru the web interface, or by email, I get a DBD::mysql::st error
as follows:
 
The RT web interface reports:
 
System error
error:  DBD::mysql::st execute failed: MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
 
context:  ...   
67:  if ($self->{lock}) { 
68:  local $self->{dbh}->{RaiseError} = 1; 
69:   
70:  my $sth = $self->{dbh}->prepare_cached(q{SELECT RELEASE_LOCK(?)},
{}, 1); 
71:  $sth->execute($self->{lockid}); 
72:  $sth->finish(); 
73:   
74:  $self->{lock} = 0; 
75:  }  
...   
 
code stack:
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:83
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:89
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1254
 
 
Syslog reports (this from a mail submission):
 
Aug 12 15:09:46 test-rt RT: DBD::mysql::st execute failed: MySQL server
has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
 
My environment is as follows:
 
RT: 3.6.5
OS: CentOS release 5.2 (Final)
DB: MySQL 5.0.45
 
(and from Admin/Tools/Configuration.html)
Loaded perl modules
 
Perl v5.8.8 under linux
  [...]
  DBD::mysql v3.0007;  
  DBI v1.52;  
  DBIx::SearchBuilder v1.53;  
  DBIx::SearchBuilder::Union v0;  
  DBIx::SearchBuilder::Unique v0.01;
  [...]
  RT v3.6.5;  
  RT::Interface::Email v2;
 
The rest of the web interface seems to work fine; I can create queues,
change perm's, etc. I just cannot seem to create a ticket.
 
Any help gratefully appreciated...
 
Thanks,
Will
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080812/65fdd2fd/attachment.htm>