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

Tue Apr 6 06:30:54 EDT 2010

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100406/9d816bd4/attachment.htm>