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