Cannot connect to Mysql From Rails Application

Question

I am having my application and database hosted in EngineYard. Suddenly my application is down. I am getting this error when I looked into the log

Mysql2::Error: This connection is still waiting for a result, try again once you have the result

I tried to run some read queries from Rails console in Staging. This is working fine. Database queries returns the expected answers.

Also I checked out the Staging branch in local and checked. I could not reproduce the error in my local. So I assume there is no error in the code.

@saurabh, krishna is getting error on staging it means it doesn't use `rails server`. — oj5th, Nov 25 '16 at 06:57
@krishna, did you try to restart your mysql server on staging or reboot the server instance if restarting mysql doesn't work? — oj5th, Nov 25 '16 at 07:00

score 0 · Answer 1 · edited May 23 '17 at 12:13

0

Restarting the App Server worked for me.

Syntax:

ey ssh "/engineyard/bin/app_<appname> restart" -e your_env_name --app-servers

edited May 23 '17 at 12:13

Community

answered Nov 25 '16 at 07:08

krishna

1 Answers1