11:01 a.m.
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/comm...
<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-viola...
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(a)apache.org>
To: "Miguel Lemos" <miguel21op(a)gmail.com>, "AeroGear Developer
Mailing List" <aerogear-dev(a)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(a)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(a)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(a)apache.org >
wrote:
On Wed, Feb 26, 2014 at 3:48 PM, Bruno Oliveira < bruno(a)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(a)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(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev