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
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?
Support Staff4 Posted by friism on 26 Apr, 2012 04:53 AM
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?
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=220.127.116.11, Culture=neutral,
MySmartFuel.HLdatabaseaccess.login(String un, String pw) in
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!