Good day everyone!
We are no longer seeing anything via the webui. I suspect it is due to a loss of network connectivity over the weekend. Seeing the following in the db.log now:
Failed dbQuery (#2006 - MySQL server has gone away)
Initial investigation seems to suggest that the client has become disconnected from the mariadb server (they are the same system) and so I'm wondering if there is an easy recovery method. Restarting services has not worked and the server has been rebooted. Still no change. Any help is greatly appreciated!
Cheers, Jason
Can you actually connect to the mysql server via other methods?
Adam.
Sent from BlueMail
On 1 Nov 2016, 20:32, at 20:32, "Macklin, Jason" jason.macklin@roche.com wrote:
Good day everyone!
We are no longer seeing anything via the webui. I suspect it is due to a loss of network connectivity over the weekend. Seeing the following in the db.log now:
Failed dbQuery (#2006 - MySQL server has gone away)
Initial investigation seems to suggest that the client has become disconnected from the mariadb server (they are the same system) and so I'm wondering if there is an easy recovery method. Restarting services has not worked and the server has been rebooted. Still no change. Any help is greatly appreciated!
Cheers, Jason
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA 94588 | USA T: +1 925 730 8458 | M: +1 925 353 7409 | E: *jason.macklin@roche.com jason.macklin@roche.com*
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Yes, connecting with command line is successful.
On Tue, Nov 1, 2016 at 1:51 PM, Adam Armstrong adama@memetic.org wrote:
Can you actually connect to the mysql server via other methods?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 1 Nov 2016, at 20:32, "Macklin, Jason" jason.macklin@roche.com wrote:
Good day everyone!
We are no longer seeing anything via the webui. I suspect it is due to a loss of network connectivity over the weekend. Seeing the following in the db.log now:
Failed dbQuery (#2006 - MySQL server has gone away)
Initial investigation seems to suggest that the client has become disconnected from the mariadb server (they are the same system) and so I'm wondering if there is an easy recovery method. Restarting services has not worked and the server has been rebooted. Still no change. Any help is greatly appreciated!
Cheers, Jason
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA 94588 | USA T: +1 925 730 8458 | M: +1 925 353 7409 | E: *jason.macklin@roche.com jason.macklin@roche.com*
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Adding an increased value for "max_allowed_packet=16M" to my.cnf seems to have fixed the issue. Not sure how/why this correlated with a network outage. Perhaps that was just coincidence...??
On Tue, Nov 1, 2016 at 1:54 PM, Jason Macklin jason.macklin@roche.com wrote:
Yes, connecting with command line is successful.
On Tue, Nov 1, 2016 at 1:51 PM, Adam Armstrong adama@memetic.org wrote:
Can you actually connect to the mysql server via other methods?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 1 Nov 2016, at 20:32, "Macklin, Jason" jason.macklin@roche.com wrote:
Good day everyone!
We are no longer seeing anything via the webui. I suspect it is due to a loss of network connectivity over the weekend. Seeing the following in the db.log now:
Failed dbQuery (#2006 - MySQL server has gone away)
Initial investigation seems to suggest that the client has become disconnected from the mariadb server (they are the same system) and so I'm wondering if there is an easy recovery method. Restarting services has not worked and the server has been rebooted. Still no change. Any help is greatly appreciated!
Cheers, Jason
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA 94588 | USA T: +1 925 730 8458 | M: +1 925 353 7409 | E: *jason.macklin@roche.com jason.macklin@roche.com*
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA 94588 | USA T: +1 925 730 8458 | M: +1 925 353 7409 | E: *jason.macklin@roche.com jason.macklin@roche.com*
Who knows why things happen \o/
Probably a setting was changed at some point but the server wasn't restarted.
Adam.
Sent from BlueMail
On 1 Nov 2016, 21:35, at 21:35, "Macklin, Jason" jason.macklin@roche.com wrote:
Adding an increased value for "max_allowed_packet=16M" to my.cnf seems to have fixed the issue. Not sure how/why this correlated with a network outage. Perhaps that was just coincidence...??
On Tue, Nov 1, 2016 at 1:54 PM, Jason Macklin jason.macklin@roche.com wrote:
Yes, connecting with command line is successful.
On Tue, Nov 1, 2016 at 1:51 PM, Adam Armstrong adama@memetic.org
wrote:
Can you actually connect to the mysql server via other methods?
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 1 Nov 2016, at 20:32, "Macklin, Jason" jason.macklin@roche.com wrote:
Good day everyone!
We are no longer seeing anything via the webui. I suspect it is
due to
a loss of network connectivity over the weekend. Seeing the
following in
the db.log now:
Failed dbQuery (#2006 - MySQL server has gone away)
Initial investigation seems to suggest that the client has become disconnected from the mariadb server (they are the same system) and
so I'm
wondering if there is an easy recovery method. Restarting services
has not
worked and the server has been rebooted. Still no change. Any
help is
greatly appreciated!
Cheers, Jason
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA
94588 |
USA T: +1 925 730 8458 | M: +1 925 353 7409 | E:
*jason.macklin@roche.com
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA 94588
| USA
T: +1 925 730 8458 | M: +1 925 353 7409 | E: *jason.macklin@roche.com jason.macklin@roche.com*
--
*Jason Macklin*
Lead Consultant - Sequencing
Solution Center R&D
Roche Molecular Systems | 4300 Hacienda Drive | Pleasanton, CA 94588 | USA T: +1 925 730 8458 | M: +1 925 353 7409 | E: *jason.macklin@roche.com jason.macklin@roche.com*
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Adam Armstrong -
Macklin, Jason