275280 - Saved Searches not refreshing

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task, P1)

Description

[alanjstr]

I have a search to return all bugs in the Update Listings category that are
open.   I resolved bug 274863.  Any time I re-execute that saved search, the bug
is still listed as being New. So either the report isn't being re-executed, or
the query only db isn't getting updated.

Comment 1

[alanjstr]

Attachment: Saved Search showing wrong status

I even did a shift reload to make sure it refreshed.

Comment 2

[Dave Miller [:justdave]]

This would be the shadow database not replicating, and has nothing to do with
the recent upgrade, and is also mozilla.org-specific.

The replication process died yesterday because mecha ran out of disk space
(ironically because I was trying to compress a backup in order to create more
space, and the size of the compressed copy of said backup filled up the
remaining disk space before the original could be deleted).

Replication did get restarted, but it's quite possible that it lost changes that
happened while it was crashed (since there was no space to add them to the
replication log).  If this turns out to be the case, we'll have to re-sync the
databases, which will involve taking Bugzilla offline for about 10 minutes in
order to make a backup of the production database to re-seed the slave with.

Comment 3

[:Gavin Sharp [email: [e-mail]]]

I've experienced rather long (2-5 minute) delays between when a bug was resolved
and when the query showed the change. Same issue?

Comment 4

[Dave Miller [:justdave]]

(In reply to comment #3)
> I've experienced rather long (2-5 minute) delays between when a bug was resolved
> and when the query showed the change. Same issue?

No, different issue.  Looking at that bug, the status change timestamp does
appear to line up with when that replication failure happened, and that bug is
indeed out of sync in the shadow database. :(

Looks like time to re-sync the databases. :(

Comment 5

[Dave Miller [:justdave]]

Done.