Codeimportworker using too many DB connections.
Bug #239569 reported by
Herb McNew
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Medium
|
Michael Hudson-Doyle |
Bug Description
It has been noticed on a couple of occassions since we rolled out the new code import system that the codeimportworker has anywhere from 30-50 DB connections open at any given time. Using today as an example there hasn't been less that 30 connections open and has ranged as high as 56. Attached you'll find a debug log with some additional information.
Related branches
lp:~mwhudson/launchpad/no-codeimportworker-db-access
Merged
into
lp:launchpad
- Tim Penhey (community): Approve
-
Diff: 1534 lines (+585/-360)15 files modifieddatabase/schema/security.cfg (+0/-22)
lib/canonical/config/schema-lazr.conf (+2/-2)
lib/canonical/launchpad/interfaces/librarian.py (+1/-1)
lib/canonical/launchpad/xmlrpc/faults.py (+10/-0)
lib/lp/code/interfaces/codeimportscheduler.py (+26/-0)
lib/lp/code/model/tests/test_codeimportjob.py (+4/-27)
lib/lp/code/xmlrpc/codeimportscheduler.py (+66/-5)
lib/lp/code/xmlrpc/tests/test_codeimportscheduler.py (+140/-0)
lib/lp/codehosting/codeimport/dispatcher.py (+1/-1)
lib/lp/codehosting/codeimport/tests/test_workermonitor.py (+244/-179)
lib/lp/codehosting/codeimport/workermonitor.py (+58/-111)
lib/lp/codehosting/inmemory.py (+12/-2)
lib/lp/testing/__init__.py (+1/-1)
scripts/code-import-worker-monitor.py (+19/-8)
scripts/code-import-worker.py (+1/-1)
Changed in launchpad-code: | |
status: | Triaged → In Progress |
visibility: | private → public |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad-code: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Do we have a limit to the number of open connections? What problem is this causing?