[rt-users] MySQL server has gone away

[Goddard Lee]

I installed RT 3.4.4 and happily imported an RT 3.0.something database.

Creating a new ticket produces the following error - re-submitting the
page immediately does create the ticket and send the e-mail.
Re-submitting the page after a delay causes the same error to be output.


When the error message appears, the ticket UIDs increase, but no ticket
can be found.

mysqld  Ver 4.1.9-standard for pc-linux-gnu on i686 (Official
MySQL RPM) Perl 5.8.7 Mod_perl 2 Apache 2.0.54
Perl -V at aend.

Error message:

System error

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

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

Trace begun at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute
failed: MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
70.^J') called at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
70
Apache::Session::Lock::MySQL::release_read_lock('Apache::Session::Lock::
MySQL=HASH(0xb1d69c8)') called at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
81
Apache::Session::Lock::MySQL::release_all_locks('Apache::Session::Lock::
MySQL=HASH(0xb1d69c8)') called at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
87
Apache::Session::Lock::MySQL::DESTROY('Apache::Session::Lock::MySQL=HASH
(0xb1d69c8)') called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1254
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 1254
HTML::Mason::Request::comp(undef, undef, undef, 'Status', 'new',
'new-DependsOn', '', 'Queue', 'Software-Dev', 'AdminCc', '',
'Requestors', 'lee.goddard at easa.eu.int', 'InitialPriority', 0, 'Starts',
'', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject',
'', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '',
'TimeLeft', '', 'DependsOn-new', '', 'Owner', 10, 'new-MemberOf', '',
'MemberOf-new', '', 'Content', 'tEST,', 'Due', '') called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 459
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 459
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 411
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb
24cd6c)') called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheH
andler=HASH(0xb24cd6c)') called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm line
826
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=H
ASH(0x98a4dc0)', 'Apache2::RequestRec=SCALAR(0xb1fe0c4)') called at
/opt/rt3/bin/webmux.pl line 132
eval {...} at /opt/rt3/bin/webmux.pl line 132
RT::Mason::handler('Apache2::RequestRec=SCALAR(0xb1fe0c4)') called at -e
line 0
eval {...} at -e line 0


__OUTPUT_OF_PERL_-V__ 

[root at crtd EASA-CRT]# perl -V
Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
  Platform:
    osname=linux, osvers=2.4.21-32.0.1.el, archname=i686-linux
    uname='linux dave11 2.4.21-32.0.1.el #1 tue may 17 18:01:37 edt 2005
i686 i686 i386 gnulinux '
    config_args=''
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=undef usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include
-I/usr/include/gdbm',
    optimize='-O2',
    cppflags='-fno-strict-aliasing -pipe -I/usr/local/include
-I/usr/include/gdbm'
    ccversion='', gccversion='2.96 20000731 (Red Hat Linux 7.3
2.96-122)', gccosandvers='linux7'
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
    perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
    libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version='2.3.2'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
-Wl,-rpath,/usr/local/lib/perl5/5.8.7/CORE'
    cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options:
  Built under linux
  Compiled at Sep 16 2005 11:04:03
  %ENV:
    PERL5LIB="/usr/local/lib/perl5/site_perl/5.8.7/"
  @INC:
    /usr/local/lib/perl5/site_perl/5.8.7/
    /usr/local/lib/perl5/5.8.7
    /usr/local/lib/perl5/5.8.7
    /usr/local/lib/perl5/site_perl/5.8.7
    /usr/local/lib/perl5/site_perl
    .
[root at crtd EASA-CRT]#