gnats/218: PRs fail to show up in index

[dirk@juniper.net]

>Number:         218
>Category:       gnats
>Synopsis:       PRs fail to show up in index
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    unassigned
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Fri Jul 13 15:34:00 PDT 2001
>Closed-Date:
>Last-Modified:
>Originator:     dirk bergstrom, juniper networks, inc.
>Release:        gnats 4.0a
>Organization:
>Environment:
FreeBSD aphid.juniper.net 4.2-STABLE FreeBSD 4.2-STABLE
a gnats database with ~16000 PRs, and ~100 frequent users.
~60 PRs modified per day, ~30 PRs added per day.
>Description:
several times a week, PRs disappear from the index (or, in the
case of new PRs, never show up).  this renders them effectively
invisible, and causes great consternation among users.

regenerating the index fixes the problem, but that locks up the
the database for a couple minutes, which annoys users.

interestingly, gnats comes with a database monitoring script,
check-db.sh, which looks for inconsistencies in the index, so
this would appear to be a known problem.
>How-To-Repeat:
run a busy gnats installation.
>Fix:

>Release-Note:
>Audit-Trail:
>Unformatted: