Bug 1088120 - Rules Engine can use all available database connections
Summary: Rules Engine can use all available database connections
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: Internal Tools
Version: 4.4
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: 4.4
Assignee: Simon Green
QA Contact: Simon Green
URL:
Whiteboard:
Depends On:
Blocks: bre, bugbot2
TreeView+ depends on / blocked
 
Reported: 2014-04-16 05:19 UTC by Simon Green
Modified: 2018-12-09 06:29 UTC (History)
3 users (show)

Fixed In Version: 4.4.4019
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-05-07 00:58:00 UTC
Embargoed:


Attachments (Terms of Use)

Description Simon Green 2014-04-16 05:19:03 UTC
Description of problem:
When processing many rules, it is possible that the number of available MySQL connections is exhausted.

Version-Release number of selected component (if applicable):
4.4.2018-2

How reproducible:
always

Steps to Reproduce:
1. Add many hundreds of bugs to the Rule Engine


Actual results:
E-mails get sent about "Error: Too many connections", and the web site becomes available. This fixes itself after the script terminates (since DBI cleanup removes those connections when the script exits)


Expected results:
No errors.

Additional info:
Obviously my understanding of how the Job Queue handles database connections is incorrect. I'll look at the mail queue and BMO's generate mail to see how it should be done :)

Comment 2 Simon Green 2014-05-07 00:58:00 UTC
This change is now live. If there are any issues, do not reopen this bug.
Instead, you should create a new bug and reference this bug.

  -- simon


Note You need to log in before you can comment on or make changes to this bug.