[rt-users] "MySQL server has gone away" when saving tickets

[Ricky Jelm]

Hello everybody,

I've just set up TR on a Fedora 9 machine (with yum install).  
Everything seems to work fine except for one important part: when  
saving a tickets, I get the following error -- this happens always.

System error

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

raw error


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


Trace begun at  
/usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute  
failed: MySQL server has gone away at  
/usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line  
70.^J') called at  
/usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line 70
Apache::Session::Lock::MySQL::release_read_lock('Apache::Session::Lock::MySQL=HASH(0xbb0fff74)') called at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line  
81
Apache::Session::Lock::MySQL::release_all_locks('Apache::Session::Lock::MySQL=HASH(0xbb0fff74)') called at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line  
87
Apache::Session::Lock::MySQL::DESTROY('Apache::Session::Lock::MySQL=HASH(0xbb0fff74)') called at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Request.pm line  
1282
eval {...} at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Request.pm  
line 1282
HTML::Mason::Request::comp(undef, undef, undef, 'TimeEstimated', '',  
'Status', 'new', 'new-DependsOn', '', 'Queue', 'Alcib', 'AdminCc', '',  
'Requestors', 'Nicolas.Kuebler at lxapch1.ch', 'InitialPriority', 0,  
'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new',  
'TimeEstimated-TimeUnits', 'minutes', 'Cc', '', 'Subject', 'test',  
'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '',  
'TimeLeft-TimeUnits', 'minutes', 'TimeLeft', '', 'DependsOn-new', '',  
'Owner', 10, 'new-MemberOf', '', 'MemberOf-new', '', 'Content',  
'test', 'Due', '', 'TimeWorked-TimeUnits', 'minutes') called at  
/usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Request.pm line 467
eval {...} at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Request.pm line 467
eval {...} at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xbb0d53d4)') called at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/ApacheHandler.pm line  
168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xbb0d53d4)') called at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/ApacheHandler.pm line  
825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xb924063c)', 'Apache2::RequestRec=SCALAR(0xbaffcabc)') called at /usr/sbin/webmux.pl line  
125
eval {...} at /usr/sbin/webmux.pl line 125
RT::Mason::handler('Apache2::RequestRec=SCALAR(0xbaffcabc)') called at  
-e line 0
eval {...} at -e line 0



Does anyone know what causes this problem? How can I debug it and what  
information does the stack give me?

Thanks,

Ricky