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

[Matthew Hartwell]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060817/0ee3cf01/attachment.htm>