cloudfoundry mysql updates don't work

0
votes

I have a grails app deployed on cloudfoundry with mysql db. The updates into the tables are flaky - when I change values it works sometimes and it doesn't work most of the times. There are no errors. It looks as if updates are going into a different db. I looked up vmc services and there is only one db associated with the application.

Since they work sometimes, it looks like a cloudfoundry problem. Has anyone seen this? Is there a special config for updates to work consistently ? Any information is appreciated.

1
mysqlgrailscloud-foundry
It is unlikely a cloudfoundry problem. Have you checked the DataSource? docs.cloudfoundry.com/services/mysql/grails-mysql.html – Jayan
Can you show some pieces of code where you store the data? Are you sure the data is already flushed when you are saving it? – david
Thank you for responses. – Soumya Pothu
I think you are right may not be cloudfoundry problem. I have second level cache and query cache enabled. However, this is not problem on local deployments, started seeing them only on cloud deployment. – Soumya Pothu

1 Answers

0
votes

You can use tunneling via vmc command to check the db bound to your app and see if the desired record is there. Would probably some app issue if you find it missing.