[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