[aerogear-dev] Issue

[Farah Juma]

Hi Miguel,

I've taken a look at the logs and it seems like the issues with connecting to the MySQL database occur after the MySQL cartridge has been restarted. Similar MySQL connection issues were also seen recently with the JBoss AS cartridge on OpenShift [1]. To help prevent stale connections from being used after the MySQL cartridge has been restarted, please try the following:

1) Stop your application: rhc app stop <APP>

2) ssh into your instance and add the following lines to the PushEEDS and SimplePushDS datasource configuration in aerogear-push/standalone/configuration/standalone.xml, as shown here:
https://github.com/aerogear/openshift-origin-cartridge-aerogear-push/commit/44a1a2eb4f4f72fc7abc80aee78fbe74c802d9ce

<background-validation-millis>60000</background-validation-millis>
<!--<validate-on-match>true</validate-on-match>-->

3) Start your application: rhc app start <APP>

This fix decreases the connection validation period from 10 minutes to 1 minute. Please let us know if this improves things for you. If you find that it's still not frequent enough, you can also try uncommenting "validate-on-match" (this will validate the connection each time it is checked out of the pool). You can also try decreasing the "background-validation-millis" amount even further.

To help us better understand what's been causing the MySQL cartridge to be restarted, have you been manually restarting your application or are you finding that your application appears to be restarting automatically? If it's the latter, it would be good to check if you're running into any memory limit violations as described here:

https://www.openshift.com/kb/kb-e1082-how-to-check-for-memory-limit-violations
https://www.openshift.com/forums/openshift/mysql-shutting-itself-down   

Thanks,
Farah

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1051349 


----- Original Message -----
> From: "Matthias Wessendorf" <matzew at apache.org>
> To: "Miguel Lemos" <miguel21op at gmail.com>, "AeroGear Developer Mailing List" <aerogear-dev at lists.jboss.org>
> Sent: Wednesday, February 26, 2014 12:41:24 PM
> Subject: Re: [aerogear-dev] Issue
> 
> thanks,
> 
> will pass over to Openshift folks; sounds like an issue w/ the database
> 
> On Wed, Feb 26, 2014 at 6:22 PM, Miguel Lemos < miguel21op at gmail.com > wrote:
> 
> 
> 
> This is what I get issuing a "cat server.log | grep jboss" at my Openshift /
> Aerogear server console:
> 
> 
> https://gist.github.com/miguel21op/92c565ed1a8220ceada7
> 
> 
> On Wed, Feb 26, 2014 at 3:03 PM, Matthias Wessendorf < matzew at apache.org >
> wrote:
> 
> 
> 
> Miguel,
> 
> can you ssh into your OpenShift instance to read the log files (e.g. for
> jboss) and make them a gist ( gist.github.com ), so that we can take a look
> as well ?
> That also helps the OpenShift team, to read the log files
> 
> -Matthias
> 
> 
> 
> On Wed, Feb 26, 2014 at 3:53 PM, Matthias Wessendorf < matzew at apache.org >
> wrote:
> 
> 
> 
> 
> 
> 
> On Wed, Feb 26, 2014 at 3:48 PM, Bruno Oliveira < bruno at abstractj.org >
> wrote:
> 
> 
> Hi Miguel, we are here to help and probably by “outside of the scope” I think
> Matthias means that our knowledge about every single detail on OpenShift
> might be limited,
> 
> yes, exactly. It's better to ask the experts.
> 
> 
> 
> in this case OpenShift team are the best people to explain what’s going on
> with your instance.
> 
> I 100% agree, especially since the 'service' is running on OpenShift
> 
> 
> -Matthias
> 
> 
> 
> --
> abstractj
> 
> On February 26, 2014 at 11:45:16 AM, Miguel Lemos ( miguel21op at gmail.com )
> wrote:
> > > I understand. But people don't care if it's "outside our scope"
> > or not. They just expect a given solution to work properly...
> > ;-)
> 
> 
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
> 
> 
> 
> --
> Matthias Wessendorf
> 
> blog: http://matthiaswessendorf.wordpress.com/
> sessions: http://www.slideshare.net/mwessendorf
> twitter: http://twitter.com/mwessendorf
> 
> 
> 
> --
> Matthias Wessendorf
> 
> blog: http://matthiaswessendorf.wordpress.com/
> sessions: http://www.slideshare.net/mwessendorf
> twitter: http://twitter.com/mwessendorf
> 
> 
> 
> 
> --
> Matthias Wessendorf
> 
> blog: http://matthiaswessendorf.wordpress.com/
> sessions: http://www.slideshare.net/mwessendorf
> twitter: http://twitter.com/mwessendorf
> 
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev