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: [email protected]
          Reporter: [email protected]
                CC: [email protected],
                    [email protected], [email protected],
                    [email protected], [email protected],
                    [email protected], [email protected]
       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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to