[rt-devel] Owner permissions

Rich West Rich.West at wesmo.com
Mon Aug 25 12:27:07 EDT 2003


I looked through the DB table "CachedGroupMembers" for anything having 
to do with '2679', and I had no luck.  In fact, '2679' was the next 
GroupID, so it was throwing me for a loop..

On a whim, I thought to try optimizing the table.  It processed for a 
moment, gave the 'warning' that the "Number of rows changed from 2626 to 
2627" and then the happy "OK".

Once that was done, I had no problems updating the ticket.. Hrmm.. Weird.

-Rich


Rich West wrote:

> Just as an FYI, I'm seeing the following in my logs:
> [Mon Aug 25 12:07:10 2003] [error] [client 65.174.157.32] FastCGI: 
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
> execute failed: Duplicate entry '2679' for key 1 at 
> /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
> [Mon Aug 25 12:07:10 2003] [error] [client 65.174.157.32] FastCGI: 
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: 
> RT::Handle=HASH(0x90b9f58) couldn't execute the query 'INSERT INTO 
> CachedGroupMembers (GroupId, Via, MemberId, ImmediateParentId, 
> Disabled) VALUES (?, ?, ?, ?, ?)' at 
> /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
>
>
> Rich West wrote:
>
>> Just upgraded from RT 3.0.2 to RT 3.0.4 and all seems well.  Except, 
>> when I try to alter the ownership of a ticket (from "nobody" to me), 
>> it throws the following error.
>>
>> I updated DBD::mysql and DBIx::SearchBuilder, and, after the error 
>> showed up, I updated Log::Dispatch (no change to the 'can't locate 
>> method "warn"' error as you can see) and I updated HTML::Mason.
>>
>> Any ideas as to where to start to debug this?  It worked fine under 
>> 3.0.2.... :(
>>
>> -Rich
>>
>>
>> Can't locate object method "warn" via package 
>> "Log::Dispatch" at 
>> /opt/rt3/lib/RT/CachedGroupMember_Overlay.pm line 91.
>>
>>
>> Trace begun at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Exceptions.pm line 131
>> HTML::Mason::Exceptions::rethrow_exception('Can\'t locate object 
>> method "warn" via package "Log::Dispatch" at 
>> /var/www/html/adm.wesmo.com/rt3/lib/RT/CachedGroupMember_Overlay.pm 
>> line 91.^J') called at /opt/rt3/lib/RT/CachedGroupMember_Overlay.pm 
>> line 91
>> RT::CachedGroupMember::Create('RT::CachedGroupMember=HASH(0x9739fa0)', 
>> 'Member', 'RT::Principal=HASH(0x97387dc)', 'Group', 
>> 'RT::Principal=HASH(0x973b5c8)', 'ImmediateParent', 
>> 'RT::Principal=HASH(0x973b5c8)', 'Via', 0) called at 
>> /opt/rt3/lib/RT/GroupMember_Overlay.pm line 134
>> RT::GroupMember::Create('RT::GroupMember=HASH(0x9739f94)', 'Member', 
>> 'RT::Principal=HASH(0x97387dc)', 'Group', 
>> 'RT::Principal=HASH(0x973b5c8)', 'InsideTransaction', 1) called at 
>> /opt/rt3/lib/RT/Group_Overlay.pm line 975
>> RT::Group::_AddMember('RT::Group=HASH(0x96f250c)', 'PrincipalId', 
>> 200, 'InsideTransaction', 1) called at 
>> /var/www/html/adm.wesmo.com/rt3/lib/RT/Ticket_Overlay.pm line 3098
>> RT::Ticket::SetOwner('RT::Ticket=HASH(0x96ade08)', 200, 'Give') 
>> called at /var/www/html/adm.wesmo.com/rt3/lib/RT/Interface/Web.pm 
>> line 1016
>> HTML::Mason::Commands::ProcessTicketBasics('TicketObj', 
>> 'RT::Ticket=HASH(0x96ade08)', 'ARGSRef', 'HASH(0x96fbe84)') called at 
>> /opt/rt3/share/html/Ticket/ModifyPeople.html line 48
>> HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 
>> 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'WatcherTypeEmail3', 
>> '', 'WatcherAddressEmail1', '', 'WatcherTypeEmail2', '', 'Owner', 
>> 200, 'WatcherTypeEmail1', '', 'id', 215, 'UserString', '', 
>> 'WatcherAddressEmail2', '', 'WatcherAddressEmail3', '', 'UserField', 
>> 'Name', 'GroupField', 'Name', 'UserOp', 'LIKE', 'WatcherTypeEmail3', 
>> '', 'GroupString', '', 'GroupOp', 'LIKE', 'Owner', 200, 
>> 'WatcherTypeEmail2', '', 'WatcherAddressEmail1', '', 
>> 'WatcherTypeEmail1', '', 'id', 215, 'WatcherAddressEmail3', '', 
>> 'WatcherAddressEmail2', '', 'UserString', '', 'UserField', 'Name') 
>> called at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm line 
>> 134
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9684304)', 
>> 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 
>> 'GroupString', '', 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', 
>> '', 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 
>> 'id', 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name', 'GroupField', 
>> 'Name', 'UserOp', 'LIKE', 'WatcherTypeEmail3', '', 'GroupString', '', 
>> 'GroupOp', 'LIKE', 'Owner', 200, 'WatcherTypeEmail2', '', 
>> 'WatcherAddressEmail1', '', 'WatcherTypeEmail1', '', 'id', 215, 
>> 'WatcherAddressEmail3', '', 'WatcherAddressEmail2', '', 'UserString', 
>> '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1062
>> eval {...}('HTML::Mason::Component::FileBased=HASH(0x9684304)', 
>> 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 
>> 'GroupString', '', 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', 
>> '', 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 
>> 'id', 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name', 'GroupField', 
>> 'Name', 'UserOp', 'LIKE', 'WatcherTypeEmail3', '', 'GroupString', '', 
>> 'GroupOp', 'LIKE', 'Owner', 200, 'WatcherTypeEmail2', '', 
>> 'WatcherAddressEmail1', '', 'WatcherTypeEmail1', '', 'id', 215, 
>> 'WatcherAddressEmail3', '', 'WatcherAddressEmail2', '', 'UserString', 
>> '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1056
>> HTML::Mason::Request::comp(undef, undef, 'GroupField', 'Name', 
>> 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 
>> 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', '', 
>> 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 'id', 
>> 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name', 'GroupField', 
>> 'Name', 'UserOp', 'LIKE', 'WatcherTypeEmail3', '', 'GroupString', '', 
>> 'GroupOp', 'LIKE', 'Owner', 200, 'WatcherTypeEmail2', '', 
>> 'WatcherAddressEmail1', '', 'WatcherTypeEmail1', '', 'id', 215, 
>> 'WatcherAddressEmail3', '', 'WatcherAddressEmail2', '', 'UserString', 
>> '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 752
>> HTML::Mason::Request::call_next('HTML::Mason::Request::CGI=HASH(0x96b5900)', 
>> 'GroupField', 'Name', 'UserOp', 'LIKE', 'WatcherTypeEmail3', '', 
>> 'GroupString', '', 'GroupOp', 'LIKE', 'Owner', 200, 
>> 'WatcherTypeEmail2', '', 'WatcherAddressEmail1', '', 
>> 'WatcherTypeEmail1', '', 'id', 215, 'WatcherAddressEmail3', '', 
>> 'WatcherAddressEmail2', '', 'UserString', '', 'UserField', 'Name') 
>> called at /opt/rt3/share/html/autohandler line 148
>> HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 
>> 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'WatcherTypeEmail3', 
>> '', 'WatcherAddressEmail1', '', 'WatcherTypeEmail2', '', 'Owner', 
>> 200, 'WatcherTypeEmail1', '', 'id', 215, 'UserString', '', 
>> 'WatcherAddressEmail2', '', 'WatcherAddressEmail3', '', 'UserField', 
>> 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm line 134
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x899c7c4)', 
>> 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 
>> 'GroupString', '', 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', 
>> '', 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 
>> 'id', 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1062
>> eval {...}('HTML::Mason::Component::FileBased=HASH(0x899c7c4)', 
>> 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 
>> 'GroupString', '', 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', 
>> '', 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 
>> 'id', 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1056
>> HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 
>> 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 
>> 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', '', 
>> 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 'id', 
>> 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 333
>> eval {...}(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 
>> 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'WatcherTypeEmail3', 
>> '', 'WatcherAddressEmail1', '', 'WatcherTypeEmail2', '', 'Owner', 
>> 200, 'WatcherTypeEmail1', '', 'id', 215, 'UserString', '', 
>> 'WatcherAddressEmail2', '', 'WatcherAddressEmail3', '', 'UserField', 
>> 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 333
>> eval {...}(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 
>> 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'WatcherTypeEmail3', 
>> '', 'WatcherAddressEmail1', '', 'WatcherTypeEmail2', '', 'Owner', 
>> 200, 'WatcherTypeEmail1', '', 'id', 215, 'UserString', '', 
>> 'WatcherAddressEmail2', '', 'WatcherAddressEmail3', '', 'UserField', 
>> 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 290
>> HTML::Mason::Request::exec('HTML::Mason::Request::CGI=HASH(0x96b5900)') 
>> called at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Interp.pm line 207
>> HTML::Mason::Interp::exec(undef, undef, 'GroupField', 'Name', 
>> 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 
>> 'WatcherTypeEmail3', '', 'WatcherAddressEmail1', '', 
>> 'WatcherTypeEmail2', '', 'Owner', 200, 'WatcherTypeEmail1', '', 'id', 
>> 215, 'UserString', '', 'WatcherAddressEmail2', '', 
>> 'WatcherAddressEmail3', '', 'UserField', 'Name') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/CGIHandler.pm line 87
>> HTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x90afa10)', 
>> 'HASH(0x8c72f10)') called at 
>> /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/CGIHandler.pm line 70
>> HTML::Mason::CGIHandler::handle_cgi_object('HTML::Mason::CGIHandler=HASH(0x90afa10)', 
>> 'CGI::Fast=HASH(0x902406c)') called at 
>> /opt/rt3/bin/mason_handler.fcgi line 50
>
>
>
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel





More information about the Rt-devel mailing list