MySQL server has gone away

anon7363646 · July 4, 2005, 4:34am

Hi,

I managed to install RT3 on Apache2 and mod_perl2.
But When I try to create a ticket I get this error message.

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.

I can’t find st anywhere on the server.

Do you have any suggestion?

Shin
Shin Imai shin.imai@etimestech.jp

seph1 · July 6, 2005, 4:19pm

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.

so, is your mysql server actually there and answering queries, or did
it go away like the error says?

seph

Goddard_Lee · January 20, 2006, 11:39am

Is it usual to have to reconfigure things so that creating a ticket does not produce the ‘mysql server has gone away’ message? MySQL can be connected to using the ‘mysql’ command program, and RT 344 only seems to have problems creating tickets, nowhere else (relevant)

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.3

Lee Goddard
Internet Application Analysis/Development
European Aviation Safety Agency
Administrative Directorate

E: Lee.Goddard@EASA.EU.int
T: +49 221 89990 3221
F: +49 221 89990 3721
W: www.easa.eu.int
:: Ottoplat 1, D-50679 Köln, Germany

Goddard_Lee · January 20, 2006, 11:42am

Correctin:

Goddard_Lee · January 23, 2006, 8:48am

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::MySQL::release_read_lock(‘Apache::Session::
MySQL=HASH(0xb1d69c8)’) called at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
81
Apache::Session::MySQL::release_all_locks(‘Apache::Session::
MySQL=HASH(0xb1d69c8)’) called at
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line
87
Apache::Session::MySQL::DESTROY(‘Apache::Session::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@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@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@crtd EASA-CRT]#

Goddard_Lee · January 26, 2006, 1:28pm

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

Glenn_E_Sieb · January 26, 2006, 1:59pm

Goddard Lee said the following on 1/26/2006 8:28 AM:

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

Lee? Can we see your RT_SiteConfig.pm? (remember to obfuscate any
passwords…)

Best,
–Glenn

“They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety.”
~Benjamin Franklin, Historical Review of Pennsylvania, 1759

Goddard_Lee · January 26, 2006, 2:27pm

Lee? Can we see your RT_SiteConfig.pm? (remember to obfuscate any
passwords…)

Thanks: it follows… I have seen and ignored a few DBIx::SearchBuilder
posts here since joining recently, and since I see that module in
rt.log, I will look in the archives, too…

package RT;

=head1 NAME

RT::Config

=for testing

use RT::Config;

=cut

Set($rtname , “dave11”);
Set($Organization , “easa”);
Set($MinimumPasswordLength , “5”);
Set($Timezone , ‘CET’);
Set($DatabaseType , ‘mysql’);
Set($DatabaseHost , ‘ok’);
Set($DatabaseRTHost , ‘ok’);
Set($DatabasePort , ‘3306’);
Set($DatabaseUser , ‘ok’);
Set($DatabasePassword , ‘ok’);
Set($DatabaseName , ‘rt3’);
Set($DatabaseRequireSSL , undef);
Set($OwnerEmail , ‘lee.goddard===easa.eu.int’); # root
Set($LoopsToRTOwner , 1);
Set($StoreLoops , 1);
Set($MaxAttachmentSize , 10000000);
Set($TruncateLongAttachments , undef);
Set($DropLongAttachments , undef);
Set($ParseNewMessageForTicketCcs , undef);
Set($RTAddressRegexp , ‘^rt@easa’);
Set($CanonicalizeOnCreate , 0);
Set($SenderMustExistInExternalDatabase , undef);
Set($CorrespondAddress , ‘rt====.easa.local’);
Set($CommentAddress , ‘rt-====.easa.local’);
Set($MailCommand , ‘sendmail’);
Set($SendmailArguments , “-oi”);
Set($SendmailPath , “/usr/sbin/sendmail”);
Set($UseFriendlyFromLine , 1);
Set($FriendlyFromLineFormat , “"%s via RT" <%s>”);
Set($UseFriendlyToLine , 0);
Set($FriendlyToLineFormat, “"%s of $RT::rtname Ticket #%s":;”);
Set($NotifyActor, 1);
Set($RecordOutgoingEmail, 1);
Set($LogToSyslog , ‘error’);
Set($LogToScreen , ‘error’);
Set($LogDir, ‘/opt/rt3/var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log
@LogToSyslogConf = () unless (@LogToSyslogConf);
Set($LogToFile , ‘debug’);
Set($WebPath , “”);
Set($WebBaseURL , “http://rt”);
Set($WebURL , $WebBaseURL . $WebPath . “/”);
Set($WebImagesURL , $WebURL . “NoAuth/images”);
Set($LogoURL , $WebImagesURL . “rt.jpg”);
Set($WebNoAuthRegex, qr!^(?:/+NoAuth/|
/+REST/\d+.\d+/NoAuth/)!x );
Set($MessageBoxWidth , 72);
Set($MessageBoxWrap, “HARD”);
Set($TrustHTMLAttachments , undef);
Set($RedistributeAutoGeneratedMessages, 1);
Set($PreferRichText, 1);

Set($WebExternalAuth , 0);
Set($WebFallbackToInternalAuth , undef);
Set($WebExternalOnly, 1);
Set($WebExternalGecos , undef);
Set($WebExternalAuto , undef);
Set($MaxInlineBody, 13456);
Set($WebFlushDbCacheEveryRequest, ‘1’);

Set($MyTicketsLength, 15);
Set($MyRequestsLength, 10);
@MasonParameters = () unless (@MasonParameters);
Set ($DefaultSearchResultFormat, qq{
'id/TITLE:#
',
‘Subject/TI
TLE:Subject’,
Status,
QueueName,
OwnerName,
Priority,
‘NEWLINE’,
‘’,
‘Requestors’,
‘CreatedRelative’,
‘ToldRelative’,
‘LastUpdatedRelative’,
‘TimeLeft’});

@LexiconLanguages = qw(*) unless (@LexiconLanguages);
@EmailInputEncodings = qw(utf-8 iso-8859-1 us-ascii) unless
(@EmailInputEncodings);
Set($EmailOutputEncoding , ‘utf-8’);
Set($DateDayBeforeMonth , 1);
Set($AmbiguousDayInPast , 1);

@ActiveStatus = qw(new open stalled) unless @ActiveStatus;
@InactiveStatus = qw(resolved rejected deleted) unless @InactiveStatus;
Set($DevelMode, ‘1’);
Set($PathToSvn, ‘/usr/local/bin/svn’); # or wherever your svn(1) binary
lives
Set($SvnRepository, ‘http://dave11/svn/crt’);

1;

=head1 NAME

RT::Config

=for testing

use RT::Config;

=cut

1;

Goddard_Lee · January 26, 2006, 2:29pm

FWIW, if anyone has the time, here is the log of posting an e-mail to RT
3.4.5, which worked in RT 3.4.4. I took a few days off work, and assume
that nothing else in the config has changed in that time:

Tia
Lee

[Thu Jan 26 14:19:29 2006] [debug]: Converting ‘us-ascii’ to ‘utf-8’ for
text/plain - test
(/opt/rt3/lib/RT/I18N.pm:226)
[Thu Jan 26 14:19:29 2006] [debug]: About to think about scrips for
transaction #2572 (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Thu Jan 26 14:19:29 2006] [debug]: About to think about scrips for
transaction #2573 (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Thu Jan 26 14:19:29 2006] [debug]: About to think about scrips for
transaction #2574 (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Thu Jan 26 14:19:29 2006] [debug]: About to think about scrips for
transaction #2575 (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Thu Jan 26 14:19:29 2006] [debug]: About to think about scrips for
transaction #2576 (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Thu Jan 26 14:19:29 2006] [debug]: About to prepare scrips for
transaction #2576 (/opt/rt3/lib/RT/Transaction_Overlay.pm:160)
[Thu Jan 26 14:19:29 2006] [debug]: Found 5 scrips
(/opt/rt3/lib/RT/Scrips_Overlay.pm:356)
[Thu Jan 26 14:19:30 2006] [debug]: About to commit scrips for
transaction #2576 (/opt/rt3/lib/RT/Transaction_Overlay.pm:169)
[Thu Jan 26 14:19:30 2006] [info]:
rt-3.4.5-24221-1138285169-1983.354-2-0@easa #354/2576 - Scrip 2
(/opt/rt3/lib/RT/Action/SendEmail.pm:237)
[Thu Jan 26 14:19:30 2006] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
493. (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [warning]: RT::Handle=HASH(0x95e69ac)
couldn’t execute the query ‘INSERT INTO Transactions (OldValue,
NewReference, OldReference, NewValue, Creator, ObjectId, Type, Field,
ReferenceType, Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?)’ at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
506

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x95e69ac)’,
‘INSERT INTO Transactions (OldValue, NewReference, OldReferenc…’,
‘undef’, ‘undef’, ‘undef’, ‘undef’, 1, 354, ‘EmailRecord’, …) called
at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line 366

DBIx::SearchBuilder::Handle::Insert(‘RT::Handle=HASH(0x95e69ac)’,
‘Transactions’, ‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’,
‘OldReference’, ‘undef’, ‘NewValue’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle/mysql.pm
line 39

DBIx::SearchBuilder::Handle::mysql::Insert(‘RT::Handle=HASH(0x95e69ac)’,
‘Transactions’, ‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’,
‘OldReference’, ‘undef’, ‘NewValue’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
1291

DBIx::SearchBuilder::Record::Create(‘RT::Transaction=HASH(0xa946be8)’,
‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’, ‘OldReference’, ‘undef’,
‘NewValue’, ‘undef’, …) called at /opt/rt3/lib/RT/Record.pm line 300
RT::Record::Create(‘RT::Transaction=HASH(0xa946be8)’,
‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’, ‘OldReference’, ‘undef’,
‘NewValue’, ‘undef’, …) called at
/opt/rt3/lib/RT/Transaction_Overlay.pm line 150
RT::Transaction::Create(‘RT::Transaction=HASH(0xa946be8)’,
‘Ticket’, 354, ‘Type’, ‘EmailRecord’, ‘Data’,
‘rt-3.4.5-24221-1138285169-1983.354-2-0@easa’, ‘MIMEObj’,
‘MIME::Entity=HASH(0xa8866cc)’, …) called at
/opt/rt3/lib/RT/Action/SendEmail.pm line 406

RT::Action::SendEmail::RecordOutgoingMailTransaction(‘RT::Action::Autore
ply=HASH(0xa8844a8)’, ‘MIME::Entity=HASH(0xa8866cc)’) called at
/opt/rt3/lib/RT/Action/SendEmail.pm line 295

RT::Action::SendEmail::SendMessage(‘RT::Action::Autoreply=HASH(0xa8844a8
)’, ‘MIME::Entity=HASH(0xa8866cc)’) called at
/opt/rt3/lib/RT/Action/SendEmail.pm line 102

RT::Action::SendEmail::Commit(‘RT::Action::Autoreply=HASH(0xa8844a8)’)
called at /opt/rt3/lib/RT/ScripAction_Overlay.pm line 241
RT::ScripAction::Commit(‘RT::ScripAction=HASH(0xa89954c)’)
called at /opt/rt3/lib/RT/Scrip_Overlay.pm line 507
eval {…} called at /opt/rt3/lib/RT/Scrip_Overlay.pm line 506
RT::Scrip::Commit(‘RT::Scrip=HASH(0xa875dbc)’, ‘TicketObj’,
‘RT::Ticket=HASH(0xa84271c)’, ‘TransactionObj’,
‘RT::Transaction=HASH(0xa899a8c)’) called at
/opt/rt3/lib/RT/Scrips_Overlay.pm line 192
RT::Scrips::Commit(‘RT::Scrips=HASH(0xa895cf0)’) called at
/opt/rt3/lib/RT/Transaction_Overlay.pm line 170
RT::Transaction::Create(‘RT::Transaction=HASH(0xa868eb4)’,
‘ObjectId’, 354, ‘ObjectType’, ‘RT::Ticket’, ‘TimeTaken’, 0, ‘Type’,
‘Create’, …) called at /opt/rt3/lib/RT/Record.pm line 1438
RT::Record::_NewTransaction(‘RT::Ticket=HASH(0xa7f15d8)’,
‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’,
‘MIME::Entity=HASH(0xa7b0e58)’) called at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 720
RT::Create(‘RT::Ticket=HASH(0xa7f15d8)’, ‘Queue’, 6,
‘Subject’, ‘test’, ‘Requestor’, ‘ARRAY(0x9d3b9a8)’, ‘Cc’,
‘ARRAY(0x9d3b990)’, …) called at /opt/rt3/lib/RT/Interface/Email.pm
line 765
RT::Interface::Gateway(‘HASH(0x9b99d94)’) called at
/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway line 58
HTML::Mason::Commands::ANON(‘SessionType’, ‘REST’, ‘action’,
‘correspond’, ‘queue’, ‘CRT’, ‘message’, ‘From lee.goddard@easa.eu.int
Thu Jan 26 15:19:28 2006\x{a}Receive…’) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa7
b04f8)’, ‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’,
‘message’, ‘From lee.goddard@easa.eu.int Thu Jan 26 15:19:28
2006\x{a}Receive…’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1246
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’, …)
called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 459
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 459
eval {…} called 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(0xa
790210)’) 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(0xa790210)’) 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(0x95cda20)’, ‘Apache2::RequestRec=SCALAR(0x95404a4)’) called at
/opt/rt3/bin/webmux.pl line 123
eval {…} called at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x95404a4)’)
called at -e line 0
eval {…} called at -e line 0 (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
493. (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [warning]: RT::Handle=HASH(0x95e69ac)
couldn’t execute the query ‘SELECT * FROM Transactions WHERE id = ?’ at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
506

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x95e69ac)’,
‘SELECT * FROM Transactions WHERE id = ?’, 0) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
1218

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Transaction=HASH(0xa946be
8)’, ‘SELECT * FROM Transactions WHERE id = ?’, 0) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
1133

DBIx::SearchBuilder::Record::LoadByCols('RT::Transaction=HASH(0xa946be8)
', ‘id’, 0) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record/Cachable.
pm line 137

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Transaction=HASH(
0xa946be8)’, ‘id’, 0) called at /opt/rt3/lib/RT/Record.pm line 392
RT::Record::LoadByCols(‘RT::Transaction=HASH(0xa946be8)’, ‘id’,
0) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
1152

DBIx::SearchBuilder::Record::LoadById(‘RT::Transaction=HASH(0xa946be8)’,
0) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
1059

DBIx::SearchBuilder::Record::Load(‘RT::Transaction=HASH(0xa946be8)’, 0)
called at /opt/rt3/lib/RT/Transaction_Overlay.pm line 151
RT::Transaction::Create(‘RT::Transaction=HASH(0xa946be8)’,
‘Ticket’, 354, ‘Type’, ‘EmailRecord’, ‘Data’,
‘rt-3.4.5-24221-1138285169-1983.354-2-0@easa’, ‘MIMEObj’,
‘MIME::Entity=HASH(0xa8866cc)’, …) called at
/opt/rt3/lib/RT/Action/SendEmail.pm line 406

RT::Action::SendEmail::RecordOutgoingMailTransaction(‘RT::Action::Autore
ply=HASH(0xa8844a8)’, ‘MIME::Entity=HASH(0xa8866cc)’) called at
/opt/rt3/lib/RT/Action/SendEmail.pm line 295

RT::Action::SendEmail::SendMessage(‘RT::Action::Autoreply=HASH(0xa8844a8
)’, ‘MIME::Entity=HASH(0xa8866cc)’) called at
/opt/rt3/lib/RT/Action/SendEmail.pm line 102

RT::Action::SendEmail::Commit(‘RT::Action::Autoreply=HASH(0xa8844a8)’)
called at /opt/rt3/lib/RT/ScripAction_Overlay.pm line 241
RT::ScripAction::Commit(‘RT::ScripAction=HASH(0xa89954c)’)
called at /opt/rt3/lib/RT/Scrip_Overlay.pm line 507
eval {…} called at /opt/rt3/lib/RT/Scrip_Overlay.pm line 506
RT::Scrip::Commit(‘RT::Scrip=HASH(0xa875dbc)’, ‘TicketObj’,
‘RT::Ticket=HASH(0xa84271c)’, ‘TransactionObj’,
‘RT::Transaction=HASH(0xa899a8c)’) called at
/opt/rt3/lib/RT/Scrips_Overlay.pm line 192
RT::Scrips::Commit(‘RT::Scrips=HASH(0xa895cf0)’) called at
/opt/rt3/lib/RT/Transaction_Overlay.pm line 170
RT::Transaction::Create(‘RT::Transaction=HASH(0xa868eb4)’,
‘ObjectId’, 354, ‘ObjectType’, ‘RT::Ticket’, ‘TimeTaken’, 0, ‘Type’,
‘Create’, …) called at /opt/rt3/lib/RT/Record.pm line 1438
RT::Record::_NewTransaction(‘RT::Ticket=HASH(0xa7f15d8)’,
‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’,
‘MIME::Entity=HASH(0xa7b0e58)’) called at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 720
RT::Create(‘RT::Ticket=HASH(0xa7f15d8)’, ‘Queue’, 6,
‘Subject’, ‘test’, ‘Requestor’, ‘ARRAY(0x9d3b9a8)’, ‘Cc’,
‘ARRAY(0x9d3b990)’, …) called at /opt/rt3/lib/RT/Interface/Email.pm
line 765
RT::Interface::Gateway(‘HASH(0x9b99d94)’) called at
/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway line 58
HTML::Mason::Commands::ANON(‘SessionType’, ‘REST’, ‘action’,
‘correspond’, ‘queue’, ‘CRT’, ‘message’, ‘From lee.goddard@easa.eu.int
Thu Jan 26 15:19:28 2006\x{a}Receive…’) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa7
b04f8)’, ‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’,
‘message’, ‘From lee.goddard@easa.eu.int Thu Jan 26 15:19:28
2006\x{a}Receive…’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1246
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’, …)
called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 459
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 459
eval {…} called 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(0xa
790210)’) 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(0xa790210)’) 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(0x95cda20)’, ‘Apache2::RequestRec=SCALAR(0x95404a4)’) called at
/opt/rt3/bin/webmux.pl line 123
eval {…} called at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x95404a4)’)
called at -e line 0
eval {…} called at -e line 0 (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [crit]: RT::Attachment->Create couldn’t, as
you didn’t specify a transaction
(/opt/rt3/lib/RT/Attachment_Overlay.pm:147)
[Thu Jan 26 14:19:30 2006] [debug]: About to think about scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:156)
[Thu Jan 26 14:19:30 2006] [info]:
rt-3.4.5-24221-1138285169-1983.354-2-0@easa sent To:
lee.goddard@easa.eu.int Cc: Bcc:
(/opt/rt3/lib/RT/Action/SendEmail.pm:297)
[Thu Jan 26 14:19:30 2006] [info]:
rt-3.4.5-24221-1138285169-1985.354-3-0@easa #354/2576 - Scrip 3
(/opt/rt3/lib/RT/Action/SendEmail.pm:237)
[Thu Jan 26 14:19:30 2006] [info]:
rt-3.4.5-24221-1138285169-1985.354-3-0@easa No recipients found. Not
sending.
(/opt/rt3/lib/RT/Action/SendEmail.pm:249)
[Thu Jan 26 14:19:30 2006] [info]:
rt-3.4.5-24221-1138285170-1263.354-15-0@easa #354/2576 - Scrip 15
(/opt/rt3/lib/RT/Action/SendEmail.pm:237)
[Thu Jan 26 14:19:30 2006] [info]:
rt-3.4.5-24221-1138285170-1263.354-15-0@easa No recipients found. Not
sending.
(/opt/rt3/lib/RT/Action/SendEmail.pm:249)
[Thu Jan 26 14:19:30 2006] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
493. (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [warning]: RT::Handle=HASH(0x95e69ac)
couldn’t execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=?
’ at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line 506

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x95e69ac)’,
'UPDATE Tickets SET LastUpdated=? WHERE id=? ', ‘2006-01-26 14:19:30’,
354) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
413

DBIx::SearchBuilder::Handle::UpdateRecordValue(‘RT::Handle=HASH(0x95e69a
c)’, ‘Table’, ‘Tickets’, ‘IsSQLFunction’, ‘undef’, ‘Column’,
‘LastUpdated’, ‘PrimaryKeys’, ‘HASH(0xa8007e8)’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
841
DBIx::SearchBuilder::Record::__Set(‘RT::Ticket=HASH(0xa7f15d8)’,
‘Value’, ‘2006-01-26 14:19:30’, ‘Field’, ‘LastUpdated’) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record/Cachable.
pm line 158

DBIx::SearchBuilder::Record::Cachable::__Set('RT::Ticket=HASH(0xa7f15d8)
', ‘Field’, ‘LastUpdated’, ‘Value’, ‘2006-01-26 14:19:30’) called at
/opt/rt3/lib/RT/Record.pm line 550
RT::Record::_SetLastUpdated(‘RT::Ticket=HASH(0xa7f15d8)’) called
at /opt/rt3/lib/RT/Record.pm line 1460
RT::Record::_NewTransaction(‘RT::Ticket=HASH(0xa7f15d8)’,
‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’,
‘MIME::Entity=HASH(0xa7b0e58)’) called at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 720
RT::Create(‘RT::Ticket=HASH(0xa7f15d8)’, ‘Queue’, 6,
‘Subject’, ‘test’, ‘Requestor’, ‘ARRAY(0x9d3b9a8)’, ‘Cc’,
‘ARRAY(0x9d3b990)’, …) called at /opt/rt3/lib/RT/Interface/Email.pm
line 765
RT::Interface::Gateway(‘HASH(0x9b99d94)’) called at
/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway line 58
HTML::Mason::Commands::ANON(‘SessionType’, ‘REST’, ‘action’,
‘correspond’, ‘queue’, ‘CRT’, ‘message’, ‘From lee.goddard@easa.eu.int
Thu Jan 26 15:19:28 2006\x{a}Receive…’) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa7
b04f8)’, ‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’,
‘message’, ‘From lee.goddard@easa.eu.int Thu Jan 26 15:19:28
2006\x{a}Receive…’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1246
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’, …)
called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 459
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 459
eval {…} called 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(0xa
790210)’) 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(0xa790210)’) 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(0x95cda20)’, ‘Apache2::RequestRec=SCALAR(0x95404a4)’) called at
/opt/rt3/bin/webmux.pl line 123
eval {…} called at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x95404a4)’)
called at -e line 0
eval {…} called at -e line 0 (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
493. (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [warning]: RT::Handle=HASH(0x95e69ac)
couldn’t execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=?
’ at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line 506

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x95e69ac)’,
'UPDATE Tickets SET LastUpdated=? WHERE id=? ', ‘2006-01-26 14:19:30’,
354) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
413

DBIx::SearchBuilder::Handle::UpdateRecordValue(‘RT::Handle=HASH(0x95e69a
c)’, ‘Table’, ‘Tickets’, ‘IsSQLFunction’, ‘undef’, ‘Column’,
‘LastUpdated’, ‘PrimaryKeys’, ‘HASH(0xa813e8c)’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm line
841
DBIx::SearchBuilder::Record::__Set(‘RT::Ticket=HASH(0xa7f15d8)’,
‘Value’, ‘2006-01-26 14:19:30’, ‘Field’, ‘LastUpdated’) called at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record/Cachable.
pm line 158

DBIx::SearchBuilder::Record::Cachable::__Set('RT::Ticket=HASH(0xa7f15d8)
', ‘Field’, ‘LastUpdated’, ‘Value’, ‘2006-01-26 14:19:30’) called at
/opt/rt3/lib/RT/Record.pm line 550
RT::Record::_SetLastUpdated(‘RT::Ticket=HASH(0xa7f15d8)’) called
at /opt/rt3/lib/RT/Record.pm line 505
RT::Record::_Set(‘RT::Ticket=HASH(0xa7f15d8)’, ‘Field’,
‘TimeWorked’, ‘Value’, 0) called at /opt/rt3/lib/RT/Ticket_Overlay.pm
line 3534
RT::_UpdateTimeTaken(‘RT::Ticket=HASH(0xa7f15d8)’, 0)
called at /opt/rt3/lib/RT/Record.pm line 1462
RT::Record::_NewTransaction(‘RT::Ticket=HASH(0xa7f15d8)’,
‘Type’, ‘Create’, ‘TimeTaken’, 0, ‘MIMEObj’,
‘MIME::Entity=HASH(0xa7b0e58)’) called at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 720
RT::Create(‘RT::Ticket=HASH(0xa7f15d8)’, ‘Queue’, 6,
‘Subject’, ‘test’, ‘Requestor’, ‘ARRAY(0x9d3b9a8)’, ‘Cc’,
‘ARRAY(0x9d3b990)’, …) called at /opt/rt3/lib/RT/Interface/Email.pm
line 765
RT::Interface::Gateway(‘HASH(0x9b99d94)’) called at
/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway line 58
HTML::Mason::Commands::ANON(‘SessionType’, ‘REST’, ‘action’,
‘correspond’, ‘queue’, ‘CRT’, ‘message’, ‘From lee.goddard@easa.eu.int
Thu Jan 26 15:19:28 2006\x{a}Receive…’) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa7
b04f8)’, ‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’,
‘message’, ‘From lee.goddard@easa.eu.int Thu Jan 26 15:19:28
2006\x{a}Receive…’, …) called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1246
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘SessionType’, ‘REST’, ‘action’, ‘correspond’, ‘queue’, ‘CRT’, …)
called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm
line 459
eval {…} called at
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 459
eval {…} called 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(0xa
790210)’) 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(0xa790210)’) 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(0x95cda20)’, ‘Apache2::RequestRec=SCALAR(0x95404a4)’) called at
/opt/rt3/bin/webmux.pl line 123
eval {…} called at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x95404a4)’)
called at -e line 0
eval {…} called at -e line 0 (/opt/rt3/lib/RT.pm:287)
[Thu Jan 26 14:19:30 2006] [info]: Ticket 354 created in queue ‘CRT’ by
lee (/opt/rt3/lib/RT/Ticket_Overlay.pm:730)

Jesse_Vincent · January 26, 2006, 2:40pm

FWIW, if anyone has the time, here is the log of posting an e-mail to RT
3.4.5, which worked in RT 3.4.4. I took a few days off work, and assume
that nothing else in the config has changed in that time:

What’s in your mysql error log? Are you maybe submitting something big
enough to overflow mysql’s max_packet?

Goddard_Lee · January 26, 2006, 2:58pm

FWIW, if anyone has the time, here is the log of posting an
e-mail to
RT 3.4.5, which worked in RT 3.4.4. I took a few days off work, and
assume that nothing else in the config has changed in that time:

What’s in your mysql error log? Are you maybe submitting
something big enough to overflow mysql’s max_packet?

Thanks for reading. As far as I can see, it’s just:

Version: ‘4.1.9-standard’ socket: ‘/var/lib/mysql/mysql.sock’ port:
3306 Official MySQL RPM
060126 10:55:55 [ERROR] /usr/sbin/mysqld: Got error 127 from storage
engine
060126 10:55:55 [ERROR] /usr/sbin/mysqld: Sort aborted
(END)

But that’s /var/log/mysql.log: can’t find anything more specific.

The rt.log, though, was just from a simple, almost-empty post to RT. I
will check those scrips aren’t custom ones someone has put in there to
upset me, but AFAIK they’re just what was there last week with RT 3.4.4,
and which were fine.

Tia
lee

Jesse_Vincent · January 26, 2006, 2:59pm

FWIW, if anyone has the time, here is the log of posting an
e-mail to
RT 3.4.5, which worked in RT 3.4.4. I took a few days off work, and
assume that nothing else in the config has changed in that time:

What’s in your mysql error log? Are you maybe submitting
something big enough to overflow mysql’s max_packet?

Thanks for reading. As far as I can see, it’s just:

Version: ‘4.1.9-standard’ socket: ‘/var/lib/mysql/mysql.sock’ port:
3306 Official MySQL RPM
060126 10:55:55 [ERROR] /usr/sbin/mysqld: Got error 127 from storage engine
060126 10:55:55 [ERROR] /usr/sbin/mysqld: Sort aborted (END)

That does seem pretty finger-pointing. Do you perhaps have mysql
corruption? But I’d try to dig into that error 127.

Schultz_Eric · January 26, 2006, 4:10pm

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Jesse Vincent
Sent: Thursday, January 26, 2006 7:00 AM
To: Goddard Lee
Cc: rt-users
Subject: Re: [rt-users] MySQL server has gone away

FWIW, if anyone has the time, here is the log of posting an
e-mail to
RT 3.4.5, which worked in RT 3.4.4. I took a few days
off work, and
assume that nothing else in the config has changed in that time:

What’s in your mysql error log? Are you maybe submitting
something big enough to overflow mysql’s max_packet?

Thanks for reading. As far as I can see, it’s just:

Version: ‘4.1.9-standard’ socket:
‘/var/lib/mysql/mysql.sock’ port:
3306 Official MySQL RPM
060126 10:55:55 [ERROR] /usr/sbin/mysqld: Got error 127
from storage engine
060126 10:55:55 [ERROR] /usr/sbin/mysqld: Sort aborted (END)

That does seem pretty finger-pointing. Do you perhaps have mysql
corruption? But I’d try to dig into that error 127.

From a box with mysql client/server on it:

bl-devel: ~ % perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed

Looks like you need to do some table repair.

Goddard_Lee · January 27, 2006, 9:22am

Thanks for reading. As far as I can see, it’s just:

Version: ‘4.1.9-standard’ socket:
‘/var/lib/mysql/mysql.sock’ port:
3306 Official MySQL RPM 060126 10:55:55 [ERROR]
/usr/sbin/mysqld: Got
error 127 from storage engine 060126 10:55:55 [ERROR]
/usr/sbin/mysqld: Sort aborted (END)

That does seem pretty finger-pointing. Do you perhaps have
mysql corruption? But I’d try to dig into that error 127.

Rather. In fact, it’s almost a reason to get this beast playing with
Oracle.

At least I can keep playing with RT

Thanks very much for your help
lee

Goddard_Lee · January 27, 2006, 9:23am

From: Schultz, Eric [mailto:ESchultz@corp.untd.com]

That does seem pretty finger-pointing. Do you perhaps have mysql
corruption? But I’d try to dig into that error 127.

From a box with mysql client/server on it:

bl-devel: ~ % perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed

Looks like you need to do some table repair.

Thank you very much for taking the trouble!

Lee

Lee Goddard
Consultant Internet Application Analysis/Development
European Aviation Safety Agency www.easa.eu.int