Bad groupset 8162774324608996 found in bug 12600

[David Miller]

On 2/4/2004 7:07 PM +0530, ajaya at renewal-iis.com wrote:

> HI Friends,
>  We had been using bugzilla for defect tracking from last one year and it
>has lot of production data. Two days back we started facing problem
>   the problem is
>  once a issue is logged and than  we  try to go back on to that, it says "
>
> Permission denied.
>
> Sorry; you do not have the permissions necessary to see bug 12600. "
>  while the user have permission on the project and    when I run sanity
>check than it gives error
>  Bad groupset 8162774324608996 found in bug 12600  It is giving this
>error for all the new bugs/review defects.
>  This is urgent as production  server  is down. Please  suggest

This should be on mozilla-webtools at mozilla.org, not here on the developers
list.  CCing there for followups.

What version of Bugzilla are you using?  This is very important to know
when you ask questions like this.  Things can change from one version to
the next.

If it's less than 2.16.4, there are bugs dealing with groupsets that can
cause that error (usually triggered if you have more than 40 groups
defined). If that's the problem, upgrading in itself will not fix the
error, but will prevent it from happening again.  The damage will have to
be cleaned up by hand.

Based on the symptoms I'm going to assume thats what happened, if you're
already using 2.16.4, then this won't apply and please post more details to
help us figure out what's going on.   First thing to do is upgrade to
2.16.4, because it's just going to break again if you don't.  Once that's
done, you'll need to fix the group itself...  at line 297 in editgroups.cgi
(in version 2.16.4 - don't use an earlier version) is a table of the valid
bit numbers.  Due to math errors prior versions of Bugzilla had incorrect
values for some of the higher numbers in this table (which is what broke
things).  Keeping that table handy for reference...

SELECT bit FROM groups ORDER BY bit;

Compare the results of that command to that table and make sure all the
numbers match.  If any of them don't (probably the higher ones), change
them to match the closest value in that table from editgroups.cgi.

UPDATE groups SET bit = newvalue WHERE bit = oldvalue;

replacing newvalue and oldvalue with the broken and fixed values.

You will then need to do the same fix on each affected bug.  Bugs could
have more than one group bit set on them (they have all of the bit numbers
added together).  The groupset number that sanitycheck is reporting in the
error you quoted seems to indicate this is the case.  You'll need to figure
out which groups were supposed to be set, add those group bits together,
and update the groups on those bugs to the correct values.  It's also
possible that the groupset permissions given to specific users are messed
up the same way, so you'll need to doublecheck the groupset values of all
your users as well.

If you need any additional help with it, feel free to follow up on
mozilla-webtools at mozilla.org and we'll try to help within reason. :)

-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/