Sanitycheck times out with sufficiently large attachment table

RESOLVED FIXED in Bugzilla 2.20

Status

()

Bugzilla
Bugzilla-General
P2
major
RESOLVED FIXED
14 years ago
14 years ago

People

(Reporter: Joel Peshkin, Assigned: Joel Peshkin)

Tracking

2.19.2
Bugzilla 2.20
Bug Flags:
approval +

Details

Attachments

(1 attachment, 1 obsolete attachment)

(Assignee)

Description

14 years ago
With a sufficiently large attachment table [15000 attachments totalling 12GB on
a rather busy Solaris system], sanitycheck will take a long time to process the
corss-check for attachments.submitter_id and apache2 will time out after 300
seconds with no output.
I suspect this occurs on this specific field because there is no index on
attachments.submitter_id

Workaround to increase apache2 timeout to 1200 secs works, but it probably pays
to fix this at its source.
(Assignee)

Comment 1

14 years ago
Actually, it seems the apache timeout itself is not the only issue.  
Severity: normal → major
Priority: -- → P2
Target Milestone: --- → Bugzilla 2.20
(Assignee)

Comment 2

14 years ago
Created attachment 174140 [details] [diff] [review]
Patch - index submitter_id

OK, adding an index on submitter_id makes almost no difference in DB size but
speeds sanitycheck up to seconds.  Justdave's inactive account check also
speeds up dramatically.
(Assignee)

Updated

14 years ago
Attachment #174140 - Flags: review?(justdave)
(Assignee)

Updated

14 years ago
Assignee: general → bugreport
Flags: blocking2.20?
don't suppose we'd be able to sneak an index on bugs_activity.who in here for
the same reason, could we? :)

That was the other "lack of index" that was slowing down my inactive account
check script.  It'll also speed up searches on who changed what, I would imagine.
(Assignee)

Updated

14 years ago
Attachment #174140 - Flags: review?(justdave)
(Assignee)

Comment 4

14 years ago
Created attachment 174141 [details] [diff] [review]
v2 -- handle bugs_activity.who at the same time

OK
Attachment #174140 - Attachment is obsolete: true
Attachment #174141 - Flags: review?(justdave)
Attachment #174141 - Flags: review?(justdave) → review+
Flags: blocking2.20? → approval+
(Assignee)

Comment 5

14 years ago
checked in
Status: NEW → RESOLVED
Last Resolved: 14 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.