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

[Ruslan Zakirov]

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 at 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 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
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at 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.