"MySQL server has gone away" when saving tickets


#1

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@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


#2

This happens when mysql server closes connection. One situation is a
seg fault in the server. You should look into mysql logs.On Mon, May 19, 2008 at 4:16 PM, Ricky Jelm rve-jelm@myamail.com wrote:

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@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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.