<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">Hi,<br><br>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.<br><br>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).<br><br>When we submit a ticket, we get the following errors:<br><br>DBD::mysql::st execute failed: MySQL server has gone away<br><br>The full log is:<br><br>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)<br>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>RT::Transaction::Create('RT::Transaction=HASH(0x84476db8)', 'Ticket', 1626, 'Type', 'EmailRecord', 'Data', '<<a href="mailto:rt-3.8.7-11035-1270464844-724.1626-4-0@ourdomain.com">rt-3.8.7-11035-1270464844-724.1626-4-0@ourdomain.com</a>>', 'MIMEObj', 'MIME::Entity=HASH(0x84468d2c)', ...) called at /opt/rt3/bin/../lib/RT/Action/SendEmail.pm line 543<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>RT::Action::SendEmail::Commit('RT::Action::Notify=HASH(0x84464444)') called at /opt/rt3/bin/../lib/RT/ScripAction_Overlay.pm line 238<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>RT::ScripAction::Commit('RT::ScripAction=HASH(0x84354b60)') called at /opt/rt3/bin/../lib/RT/Scrip_Overlay.pm line 464<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>eval {...} called at /opt/rt3/bin/../lib/RT/Scrip_Overlay.pm line 463<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>RT::Scrips::Commit('RT::Scrips=HASH(0x8437dbd8)') called at /opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 188<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br>Apr 5 11:54:05 ip-10-228-234-38<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>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<br><br>I have seen a few other threads about this but none have been answered as yet.<br><br>Please help!!<br><br>Simon<br><br><br><br></span></div></div><br></body></html>
<pre>
---------------------------------------------------------------------------------------
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
---------------------------------------------------------------------------------------