[rt-users] DBD::mysql::st execute failed: MySQL server has gone away

Tue Apr 6 06:59:04 EDT 2010

Hello Simon,

Do you use mod_perl2?

On Tue, Apr 6, 2010 at 2:30 PM, Simon Morley | PolkaSpots
<simon at polkaspots.com> wrote:
> Hi,
>
> We are having issues with a RT DB migration from one server to another. I
> have confirmed by setting up some basic queues etc. with a brand new DB that
> the RT system is working on the server in question.
>
> We have done a mysqldump from one server to this one. Same version of RT but
> different mysql version (one is x86, the other i386).
>
> When we submit a ticket, we get the following errors:
>
> DBD::mysql::st execute failed: MySQL server has gone away
>
> The full log is:
>
> Apr  5 11:54:05 ip-10-228-234-38 RT: DBD::mysql::st execute failed: MySQL
> server has gone away at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509.
> (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
> Apr  5 11:54:05 ip-10-228-234-38 RT: RT::Handle=HASH(0x821d2710) couldn't
> execute the query 'INSERT INTO Transactions (OldValue, NewReference,
> OldReference, NewValue, Creator, ObjectId, Field, Type, ReferenceType,
> Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
> Apr  5 11:54:05 ip-10-228-234-38
> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x821d2710)',
> 'INSERT INTO Transactions (OldValue, NewReference, OldReferenc...', 'undef',
> 'undef', 'undef', 'undef', 1, 1626, 'undef', ...) called at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357
> Apr  5 11:54:05 ip-10-228-234-38
> DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x821d2710)',
> 'Transactions', 'OldValue', 'undef', 'NewReference', 'undef',
> 'OldReference', 'undef', 'NewValue', ...) called at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 36
> Apr  5 11:54:05 ip-10-228-234-38
> DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x821d2710)',
> 'Transactions', 'OldValue', 'undef', 'NewReference', 'undef',
> 'OldReference', 'undef', 'NewValue', ...) called at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293
> Apr  5 11:54:05 ip-10-228-234-38
> DBIx::SearchBuilder::Record::Create('RT::Transaction=HASH(0x84476db8)',
> 'OldValue', 'undef', 'NewReference', 'undef', 'OldReference', 'undef',
> 'NewValue', 'undef', ...) called at /opt/rt3/bin/../lib/RT/Record.pm line
> 289
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Record::Create('RT::Transaction=HASH(0x84476db8)', 'OldValue', 'undef',
> 'NewReference', 'undef', 'OldReference', 'undef', 'NewValue', 'undef', ...)
> called at /opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 151
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Transaction::Create('RT::Transaction=HASH(0x84476db8)', 'Ticket', 1626,
> 'Type', 'EmailRecord', 'Data',
> '<rt-3.8.7-11035-1270464844-724.1626-4-0 at ourdomain.com>', 'MIMEObj',
> 'MIME::Entity=HASH(0x84468d2c)', ...) called at
> /opt/rt3/bin/../lib/RT/Action/SendEmail.pm line 543
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Action::SendEmail::RecordOutgoingMailTransaction('RT::Action::Notify=HASH(0x84464444)',
> 'MIME::Entity=HASH(0x84468d2c)') called at
> /opt/rt3/bin/../lib/RT/Action/SendEmail.pm line 138
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Action::SendEmail::Commit('RT::Action::Notify=HASH(0x84464444)') called
> at /opt/rt3/bin/../lib/RT/ScripAction_Overlay.pm line 238
> Apr  5 11:54:05 ip-10-228-234-38
> RT::ScripAction::Commit('RT::ScripAction=HASH(0x84354b60)') called at
> /opt/rt3/bin/../lib/RT/Scrip_Overlay.pm line 464
> Apr  5 11:54:05 ip-10-228-234-38  eval {...} called at
> /opt/rt3/bin/../lib/RT/Scrip_Overlay.pm line 463
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Scrip::Commit('RT::Scrip=HASH(0x84386c24)', 'TicketObj',
> 'RT::Ticket=HASH(0x8437fe08)', 'TransactionObj',
> 'RT::Transaction=HASH(0x84380330)') called at
> /opt/rt3/bin/../lib/RT/Scrips_Overlay.pm line 196
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Scrips::Commit('RT::Scrips=HASH(0x8437dbd8)') called at
> /opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 188
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Transaction::Create('RT::Transaction=HASH(0x8437d0bc)', 'ObjectId',
> 1626, 'ObjectType', 'RT::Ticket', 'TimeTaken', 0, 'Type', 'Create', ...)
> called at /opt/rt3/bin/../lib/RT/Record.pm line 1457
> Apr  5 11:54:05 ip-10-228-234-38
> RT::Record::_NewTransaction('RT::Ticket=HASH(0x84354e30)', 'Type', 'Create',
> 'TimeTaken', 0, 'MIMEObj', 'MIME::Entity=HASH(0x842b73c4)', 'CommitScrips',
> 1, ...) called at /opt/rt3/bin/../lib/RT/Ticket_Overlay.pm line 656
>
> I have seen a few other threads about this but none have been answered as
> yet.
>
> Please help!!
>
> Simon
>
>
>
>
>
> ---------------------------------------------------------------------------------------
> The information contained in this email and its attachments is confidential
> and may be the subject of legal, professional or other privilege. It is
> intended only for the named addressees and may not be disclosed to anyone
> else without consent from PolkaSpots Limited. If you are not the named
> addressee you must not use, disclose, distribute, copy, print or rely on the
> contents of this email and should destroy it immediately. Whilst PolkaSpots
> Limited takes care to protect its systems from electronic virus attack or
> other harmful event, the firm gives no warranty that this email message
> (including any attachments to it) is free of any virus or other harmful
> matter and accepts no responsibility for any loss or damage resulting from
> the recipient receiving, opening or using it. If you need any further
> information, please contact the originator of this message on +44 (0) 20
> 7183 1471.
>
> PolkaSpots Limited is registered in the UK, number 05508105. Registered
> Office: 204 Buspace Studios, Conlan Street, London W10 5AP
>
> Website: www.polkaspots.com
> ---------------------------------------------------------------------------------------
>
>
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

-- 
Best regards, Ruslan.