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

Tue Aug 22 11:25:54 EDT 2006

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 at lanier.com> 
Sent by: rt-users-bounces at lists.bestpractical.com
08/17/2006 08:33 AM

To
rt-users at 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 at bestpractical.com

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060822/c886f247/attachment.htm>