https://bugzilla.wikimedia.org/show_bug.cgi?id=68833
Bug ID: 68833
Summary: session management
Product: Analytics
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Wikimetrics
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: dandree...@wikimedia.org
CC: bugwatc...@sb-mail.wmflabs.org,
christ...@quelltextlich.at, dandree...@wikimedia.org,
dtarabore...@wikimedia.org, kle...@wikimedia.org,
nu...@wikimedia.org, tneg...@wikimedia.org
Web browser: ---
Mobile Platform: ---
There MUST be a session not being closed somewhere, as while doing a lot of
testing on wikimetrics, I encountered:
OperationalError: (OperationalError) (1203, "User u2543 already has more than
'max_user_connections' active connections") None None
This could happen if many parallel queries were open at the same time, but I
don't think the setup I was using would cause that scenario. So, we've tried
to fix this a few times in the past, I think it's time we do it properly with
flask-sqlalchemy or something else that is rock solid. Basically after a
refactor, we should never see manual calls to open sessions, they should all be
using something like:
with session_thing:
blah
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
