[rt-users] MySQL server has gone away
Goddard Lee
lee.goddard at easa.eu.int
Thu Jan 26 08:28:09 EST 2006
I've upgraded to 3.4.5 and still get the same problem.
Could you someone please point me in the right direction for a fix?
:( Unless I can get this bug-free very soon, RT will stay in Softare
Development here, and not the whole of the Agency.
Lee Goddard
Contract Internet Application Analysis/Development
European Aviation Safety Agency www.easa.eu.int
> -----Original Message-----
> From: Goddard Lee
> Sent: 23 January 2006 09:48
> To: Goddard Lee; 'rt-users'
> Subject: RE: [rt-users] MySQL server has gone away
>
>
> 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::Sessi
> on::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::Sessi
> on::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::ApacheHandle
> r=HASH(0xb24cd6c)') called at
> /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.
> pm line 168
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Reques
> t::ApacheHandler=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::Apach
> eHandler=HASH(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]#
>
More information about the rt-users
mailing list