Closed Bug 150976 Opened 22 years ago Closed 16 years ago

bugs_activity query in processmail blocks access to database

Categories

(Bugzilla :: Bugzilla-General, defect)

Product:
Bugzilla
Component:
Bugzilla-General
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED WORKSFORME

People

(Reporter: myk, Unassigned)

References

Details

The bugs_activity query on line 175 of processmail blocks access to the bugs
database for other queries.  It shouldn't do that.
Blocks: bz-perf
Welcome to mysql's table level locks!

I guess we could run a separate query for the short_desc, but since the entire
of processmail needs to be running under a lock anyway for consistency purposes
(there is a bug on that), I don't know if its worth it.
ok, processmail got moved into Bugzilla/BugMail.pm.  That have any effect on this?
Not really. We should move to innodb, or postgres :)
Reassigning bugs that I'm not actively working on to the default component owner
in order to try to make some sanity out of my personal buglist.  This doesn't
mean the bug isn't being dealt with, just that I'm not the one doing it.  If you
are dealing with this bug, please assign it to yourself.
Assignee: justdave → general
QA Contact: mattyt-bugzilla → default-qa
I suspect this is no longer a problem, now that we're using InnoDB. If anybody still sees this with Bugzilla 3.2 or later, feel free to reopen this.
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.