Problems creating ticket in RT v3.6.1

Hey all,

A bit of background –
We’ve just upgraded our RT install from v3.4.5 to v3.6.1. We’re running
Apache 2.0.54, mod_perl 2.0.1, perl 5.8.6, and mysql 4.1.20 under Fedora
Core 4.

Currently non-superusers are able to query and update the database, but
get the error below when trying to create a ticket on the ‘Create a New
Ticket’ page (or via email). The really odd thing is that when a superuser
tries to create a ticket the same way, no error occurs. I’ve checked the
mysqld.log and no errors are being shown there and the users can see the
rest of the tickets so I’m sure the database is actually still there are
running. Any thoughts?

Thanks,

Matthew T. Hartwell
Lead Systems Analyst
Lanier Worldwide, Inc.
Ph: (770) 723-4229
Fx: (770) 723-4284

System error

error:
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6/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/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm:70
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm:81
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm:87
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1259

raw error

DBD::mysql::st execute failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line 70.

Trace begun at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Exceptions.pm
line 129
HTML::Mason::Exceptions::rethrow_exception(‘DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line 70.^J’)
called at /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line
70
Apache::Session::lock::MySQL::release_read_lock(‘Apache::Session::lock::MySQL=HASH(0xb80dba0)’)
called at /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line
81
Apache::Session::lock::MySQL::release_all_locks(‘Apache::Session::lock::MySQL=HASH(0xb80dba0)’)
called at /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line
87
Apache::Session::lock::MySQL::DESTROY(‘Apache::Session::lock::MySQL=HASH(0xb80dba0)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1259
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
1259
HTML::Mason::Request::comp(undef, undef, undef, ‘TimeEstimated’, ‘’,
‘Status’, ‘new’, ‘new-DependsOn’, ‘’, ‘Queue’, ‘General’, ‘AdminCc’, ‘’,
‘Requestors’, ‘’, ‘Object-RT::Ticket–CustomField-2-Values’, ‘’,
‘InitialPriority’, 0, ‘Starts’, ‘’, ‘Attach’, ‘’, ‘TimeWorked’, ‘’, ‘id’,
‘new’, ‘Object-RT::Ticket–CustomField-4-Value’, ‘’,
‘TimeEstimated-TimeUnits’, ‘minutes’, ‘Cc’, ‘’, ‘Subject’, ‘Test ticket
4’, ‘Object-RT::Ticket–CustomField-4-Values-Magic’, 1, ‘new-RefersTo’,
’’, ‘FinalPriority’, 0, ‘RefersTo-new’, ‘’, ‘TimeLeft-TimeUnits’,
‘minutes’, ‘TimeLeft’, ‘’, ‘DependsOn-new’, ‘’, ‘Owner’, 10,
‘new-MemberOf’, ‘’, ‘MemberOf-new’, ‘’, ‘Content’, ‘This is test ticket
4’, ‘Due’, ‘’, ‘TimeWorked-TimeUnits’, ‘minutes’,
‘Object-RT::Ticket–CustomField-2-Values-Magic’, 1) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 460
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
460
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xb6602f8)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xb6602f8)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line
826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0xa551970)’,
‘Apache2::RequestRec=SCALAR(0xbb5c2f4)’) called at
/opt/rt3.6.1/bin/webmux.pl line 123
eval {…} at /opt/rt3.6.1/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xbb5c2f4)’) called at -e
line 0
eval {…} at -e line 0

Hi all,

I never received a response to my initial question so I wiped out the
entire machine and started from scratch. It’s now running Fedora Core 5,
mysql 5.0.22, apache 2.2.2, mod_perl 2.0.2, and perl 5.8.8. I installed
rt3.6.1, built the database and then loaded it from an export I took
before doing the upgrade. Everything seems fine, but then I see the
following error in /var/log/messages:
Aug 22 10:56:13 eaisvr RT: DBD::mysql::st execute failed: MySQL server has
gone away at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 492.
(/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:492)

This line seems to be before and after the above line:
Aug 22 10:51:55 eaisvr RT: RT::Handle=HASH(0xa9929e0) couldn’t execute the
query 'SELECT main.* FROM Attributes main WHERE ((main.ObjectId = 1))
AND ((main.ObjectType = ‘RT::System’)) ’ at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xa9929e0)’,
‘SELECT main.* FROM Attributes main WHERE ((main.ObjectId = …’) called
at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 231
DBIx::SearchBuilder::_DoSearch(‘RT::Attributes=HASH(0xbdee4b0)’) called at
/opt/rt3/lib/RT/Attributes_Overlay.pm line 71
RT::Attributes::_DoSearch(‘RT::Attributes=HASH(0xbdee4b0)’) called at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 491
DBIx::SearchBuilder::Next(‘RT::Attributes=HASH(0xbdee4b0)’) called at
/opt/rt3/lib/RT/Attributes_Overlay.pm line 79
RT::Attributes::_BuildAccessTable(‘RT::Attributes=HASH(0xbdee4b0)’) called
at /opt/rt3/lib/RT/Attributes_Overlay.pm line 72
RT::Attributes::_DoSearch('RT::Attributes=HASH(0x

Since I’ve changed out everything else and I’m still getting the same
results I’m starting to think this is related to the mysqld config
(my.cnf), the actual data, or the RT code. Can anyone point me in some
direction to narrow this down?

Thanks,

Matthew T. Hartwell
Lead Systems Analyst
Lanier Worldwide, Inc.
Ph: (770) 723-4229
Fx: (770) 723-4284

Matthew Hartwell mhartwel@lanier.com
Sent by: rt-users-bounces@lists.bestpractical.com
08/17/2006 08:33 AM

To
rt-users@lists.bestpractical.com
cc

Subject
[rt-users] Problems creating ticket in RT v3.6.1

Hey all,

A bit of background –
We’ve just upgraded our RT install from v3.4.5 to v3.6.1. We’re running
Apache 2.0.54, mod_perl 2.0.1, perl 5.8.6, and mysql 4.1.20 under Fedora
Core 4.

Currently non-superusers are able to query and update the database, but
get the error below when trying to create a ticket on the ‘Create a New
Ticket’ page (or via email). The really odd thing is that when a superuser
tries to create a ticket the same way, no error occurs. I’ve checked the
mysqld.log and no errors are being shown there and the users can see the
rest of the tickets so I’m sure the database is actually still there are
running. Any thoughts?

Thanks,

Matthew T. Hartwell
Lead Systems Analyst
Lanier Worldwide, Inc.
Ph: (770) 723-4229
Fx: (770) 723-4284

System error

error:
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6/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/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm:70
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm:81
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm:87
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1259

raw error

DBD::mysql::st execute failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line 70.

Trace begun at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Exceptions.pm
line 129
HTML::Mason::Exceptions::rethrow_exception(‘DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line 70.^J’)
called at /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line
70
Apache::Session::lock::MySQL::release_read_lock(‘Apache::Session::lock::MySQL=HASH(0xb80dba0)’)
called at /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line
81
Apache::Session::lock::MySQL::release_all_locks(‘Apache::Session::lock::MySQL=HASH(0xb80dba0)’)
called at /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Lock/MySQL.pm line
87
Apache::Session::lock::MySQL::DESTROY(‘Apache::Session::lock::MySQL=HASH(0xb80dba0)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1259
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
1259
HTML::Mason::Request::comp(undef, undef, undef, ‘TimeEstimated’, ‘’,
‘Status’, ‘new’, ‘new-DependsOn’, ‘’, ‘Queue’, ‘General’, ‘AdminCc’, ‘’,
‘Requestors’, ‘’, ‘Object-RT::Ticket–CustomField-2-Values’, ‘’,
‘InitialPriority’, 0, ‘Starts’, ‘’, ‘Attach’, ‘’, ‘TimeWorked’, ‘’, ‘id’,
‘new’, ‘Object-RT::Ticket–CustomField-4-Value’, ‘’,
‘TimeEstimated-TimeUnits’, ‘minutes’, ‘Cc’, ‘’, ‘Subject’, ‘Test ticket
4’, ‘Object-RT::Ticket–CustomField-4-Values-Magic’, 1, ‘new-RefersTo’,
’’, ‘FinalPriority’, 0, ‘RefersTo-new’, ‘’, ‘TimeLeft-TimeUnits’,
‘minutes’, ‘TimeLeft’, ‘’, ‘DependsOn-new’, ‘’, ‘Owner’, 10,
‘new-MemberOf’, ‘’, ‘MemberOf-new’, ‘’, ‘Content’, ‘This is test ticket
4’, ‘Due’, ‘’, ‘TimeWorked-TimeUnits’, ‘minutes’,
‘Object-RT::Ticket–CustomField-2-Values-Magic’, 1) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 460
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
460
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xb6602f8)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xb6602f8)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line
826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0xa551970)’,
‘Apache2::RequestRec=SCALAR(0xbb5c2f4)’) called at
/opt/rt3.6.1/bin/webmux.pl line 123
eval {…} at /opt/rt3.6.1/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xbb5c2f4)’) called at -e
line 0
eval {…} at -e line 0
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com