Closed
Bug 849036
Opened 12 years ago
Closed 12 years ago
SQL Alchemy connection pool bug quick fix for Sync
Categories
(Cloud Services Graveyard :: Server: Sync, defect)
Tracking
(Not tracked)
RESOLVED
WONTFIX
People
(Reporter: bobm, Assigned: bobm)
References
Details
Attachments
(1 file)
Apply quick fix to Sync SQL Alchemy configuration while Bug 692383 is being addressed. The installed version of SQL Alchemy, 0.6.6-1, behaves like the one here:
http://stackoverflow.com/questions/5549940/sqlalchemy-connections-arent-closed-when-pool-is-overflowed
The quick fix is to set pool_size += 10, and max_overflow to 0. This will keep the DB connection pool per gunicorn worker where it is currently, without allowing unused established connections to accumulate.
Assignee | ||
Updated•12 years ago
|
Assignee: nobody → bobm
Status: NEW → ASSIGNED
Assignee | ||
Comment 1•12 years ago
|
||
Attachment #722550 -
Flags: review?(bbangert)
Attachment #722550 -
Flags: feedback?(rfkelly)
Comment 2•12 years ago
|
||
Comment on attachment 722550 [details]
Diff document displaying Quick Fix change for sync.conf
This seems sensible to me, no need for an overflow if we're constantly operating at capacity anyway.
Attachment #722550 -
Flags: feedback?(rfkelly) → feedback+
Assignee | ||
Updated•12 years ago
|
QA Contact: jbonacci
Comment 3•12 years ago
|
||
Comment on attachment 722550 [details]
Diff document displaying Quick Fix change for sync.conf
Looks fine here.
Attachment #722550 -
Flags: review?(bbangert) → review+
Assignee | ||
Comment 4•12 years ago
|
||
This change attempted in stage with no result: http://pencil.scl2.stage.svc.mozilla.com/dash/stage/syncstorage_details/socket_counts?from=1362804540&until=1362805491
It appears that setting max_overflow to 0 does not resolve the problem. Closing this bug.
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → WONTFIX
Updated•2 years ago
|
Product: Cloud Services → Cloud Services Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•