Hello Simon, Do you use mod_perl2?
On Tue, Apr 6, 2010 at 2:30 PM, Simon Morley | PolkaSpots <si...@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-...@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. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com