Page MenuHomePhabricator

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

Description

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

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 subscriber: Praveenp.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 19 2015, 2:56 PM
bd808 added a subscriber: bd808.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 subscriber: gerritbot.

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

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 Done to Archive on the Wikimedia-Wikimania-Scholarships board.