Page MenuHomePhabricator
Create Task
Maniphest T87182

Database 'max_user_connections' limit exceeded for Scholarships app
Closed, ResolvedPublic
Actions

Description

While submitting scholorship application (https://scholarships.wikimedia.org/apply), server gives a 503 error. Screenshot:

Wikimedia_Error_-_Mozilla_Firefox_002.png (741×1 px, 78 KB)

Details

SubjectRepoBranchLines +/-
Remove use of persistent database connectionswikimedia/wikimania-scholarshipsmaster+0 -1
Customize query in gerrit

Related Objects

Event Timeline

Praveenp created this task.Jan 19 2015, 2:56 PM
Praveenp raised the priority of this task from to Needs Triage.
Praveenp updated the task description. (Show Details)
Praveenp added a project: Wikimedia-Wikimania-Scholarships.
Praveenp subscribed.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 19 2015, 2:56 PM
bd808 subscribed.Jan 19 2015, 8:28 PM

I see several errors in the server logs that say:

SQLSTATE[42000] [1226] User 'scholarships_app' has exceeded the 'max_user_connections' resource (current value: 10)

A couple of these occurred near the timestamp show for this bug report being filed.

bd808 added a comment.Jan 19 2015, 8:44 PM

@Praveenp Thanks for pointing this problem out. We had configured the backing database server to throttle concurrent connections but apparently set the limit too low. We have raised the limit from 10 to 50 and I'll keep an eye on things to see if that is enough.

bd808 renamed this task from While trying to submit Wikimania 2015 application form, 503 error resulted. to Database 'max_user_connections' limit exceeded for Scholarships app.Jan 19 2015, 8:44 PM
bd808 claimed this task.
bd808 triaged this task as High priority.
bd808 set Security to None.
bd808 moved this task from Backlog to In Dev/Progress on the Wikimedia-Wikimania-Scholarships board.
gerritbot added a project: Patch-For-Review.Jan 19 2015, 9:46 PM
gerritbot subscribed.

Change 185917 had a related patch set uploaded (by BryanDavis):
Remove use of persistent database connections

https://gerrit.wikimedia.org/r/185917

Patch-For-Review

gerritbot added a comment.Jan 19 2015, 9:47 PM

Change 185917 merged by jenkins-bot:
Remove use of persistent database connections

https://gerrit.wikimedia.org/r/185917

bd808 closed this task as Resolved.Feb 5 2015, 4:57 PM

Sean raised the limit for the app and I removed the use of persistent connections. Seems to have fixed things.

bd808 moved this task from In Dev/Progress to Done on the Wikimedia-Wikimania-Scholarships board.Feb 5 2015, 4:57 PM
bd808 moved this task from Done to Archive on the Wikimedia-Wikimania-Scholarships board.
bd808 mentioned this in rWWSC9949c60ef510: Remove use of persistent database connections.Mar 3 2015, 9:10 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL