Amazon RDS connection issue

dane's Avatar

dane

24 Apr, 2012 07:03 PM

Hi,

I think I have an issue that has come up where my app is no longer connecting to my RDS instance from Appharbor. I haven't submitted a new build in a long while... and it used to work?

Is this still your security group # on amazon? 136621386816 with name "web"... I know the post that described this setup mentioned maintenance may be required in the future.

Thanks,
Dane

  1. Support Staff 2 Posted by friism on 24 Apr, 2012 08:07 PM

    friism's Avatar

    Hi Dane, this should still be current and only if you used the AppHarbor IP range to grant access would you require updates. Here's the relevant kb article: http://support.appharbor.com/kb/tips-and-tricks/application-server-...

    Have you ruled out other possible problems?
    Michael

  2. 3 Posted by dane on 25 Apr, 2012 01:49 PM

    dane's Avatar

    Hi,

    I have found that it is definitely the RDS connection...

    System.InvalidOperationException: Connection must be valid and open. at MySql.Data.MySqlClient.MySqlCommand.CheckState() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at MySmartFuel.HLdatabaseaccess.login(String un, String pw)

    Note: This connection works fine when running the project on my local machine while connecting to RDS.

    This worked fine for months on Appharbor...

    I'm not sure but I think the change might have been Sunday around 11:30AM PST? That is not definite but I have some other evidence that it could have been then... was there a system update or change around that time?

    Thanks,
    Dane

  3. Support Staff 4 Posted by friism on 26 Apr, 2012 04:53 AM

    friism's Avatar

    Hi Dane, we have not introduced any changes that would affect this. You should probably verify that your application is running with the correct connectionstring (and that AppHarbor is not somehow overwriting or transforming it) and that we're using the mysql-driver versions you expect (you can do this by downloading the build output).

    Does it work if you roll back to the previous commit?

    Michael

  4. 5 Posted by dane on 26 Apr, 2012 04:45 PM

    dane's Avatar

    Hi,
    Previous commits do not work either.... I've dug a bit deeper... does this look familar to you?

    I'm not using NewRelic add-on

    Could not load type 'NewRelic.Agent.Core.AgentShim' from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. at MySql.Data.MySqlClient.MySqlConnection.Open() at MySmartFuel.HLdatabaseaccess.login(String un, String pw) in C:\Users\Dane\Dropbox\MySmartFuel\MySmartFuel\HLclasses\HLdatabaseaccess.vb:line 1185

  5. Support Staff 6 Posted by friism on 26 Apr, 2012 08:41 PM

    friism's Avatar

    Thanks for following up -- this is an issue that surfaced last week. Unless New Relic provides a resolution, we'll be removing the offending client today or tomorrow.

    Sorry about the breakage.
    Michael

  6. 7 Posted by dane on 27 Apr, 2012 10:33 PM

    dane's Avatar

    We have to have this fixed! Any word!

  7. Support Staff 8 Posted by friism on 27 Apr, 2012 10:57 PM

    friism's Avatar

    The New Relic agent is gone now, let us know if that didn't resolve the issue.

    Sorry about the breakage.
    Michael

  8. 9 Posted by dane on 27 Apr, 2012 11:13 PM

    dane's Avatar

    Oh, I didn't know it was taken b/c I thought it would automatically come back up. But my MySQL instance started blocking the connection b/c of too many failed attempts. So I had to run FLUSH HOSTS and then it came back! Great news!

  9. Support Staff 10 Posted by friism on 27 Apr, 2012 11:15 PM

    friism's Avatar

    Great, glad you're up again.

    Again, we apologize for the inconvenience.

    Michael

  10. 11 Posted by dane on 03 Dec, 2012 11:18 PM

    dane's Avatar

    This can be closed.

  11. friism closed this discussion on 03 Dec, 2012 11:31 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

01 Aug, 2014 04:43 AM
01 Aug, 2014 12:40 AM
01 Aug, 2014 12:35 AM
01 Aug, 2014 12:17 AM
30 Jul, 2014 10:35 PM