DBD::mysql::st execute failed: MySQL server has gone away

Hi.

I’m getting the following error running apache2 with modperl, mysql
4.1.18 and RT 3.4.5
error: DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/stow/perl-5.8.7/lib/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/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:70
/usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:81
/usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:87
/usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/HTML/Mason/Request.pm:1249

If anyone can help, I’d appreciate it.
Kind regards.

Luke

Hi.

I’m getting the following error running apache2 with modperl, mysql
4.1.18 and RT 3.4.5
error: DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/stow/perl-5.8.7/lib/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/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:70
/usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:81
/usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:87
/usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/HTML/Mason/Request.pm:1249

If anyone can help, I’d appreciate it.
Kind regards.

Luke

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

Hello Simon,

Do you use mod_perl2?On Tue, Apr 6, 2010 at 2:30 PM, Simon Morley | PolkaSpots simon@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@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.

Hello Simon.

It’s a recently discovered problem in mod_perl2 that affects people in
some cases in a wierd way that is hard to debug.

I believe some of your templates are incorrect. Read logs you quoted.On Tue, Apr 6, 2010 at 7:59 PM, Simon Morley | PolkaSpots simon@polkaspots.com wrote:

Ignore that last message, we’ve started getting the messages through. Not sure what was going on.

Thanks again for the help!

Out of interest, why did we need this patch?

Simon

Best regards, Ruslan.