Page 1 of 1

XI DB Connection Error on OPS Screen

Posted: Mon Sep 25, 2017 1:08 pm
by blariv
hi getting this error intermittently, not sure what is happening.

Could not connect to the database!

it automatically reconnects though.

Brian

Re: XI DB Connection Error on OPS Screen

Posted: Mon Sep 25, 2017 2:52 pm
by dwasswa
Hi @blariv,

Are you monitoring the DB locally or its a remote?

The reason why i am asking is to see if its a network issue or not because you mentioned that it disconnects and reconnects itself right?

Re: XI DB Connection Error on OPS Screen

Posted: Mon Sep 25, 2017 3:16 pm
by blariv
it is local. this is the actual db for the ops screen, not something I am monitoring.

Re: XI DB Connection Error on OPS Screen

Posted: Mon Sep 25, 2017 4:12 pm
by scottwilkerson
you may need it increase your max-connection for mysqld

If you edit your /etc/my.cnf

You can add the following under the [mysqld] sectio

Code: Select all

max-connections=500
Then restart mysqld

Code: Select all

service mysqld restart

Re: XI DB Connection Error on OPS Screen

Posted: Mon Sep 25, 2017 4:16 pm
by dwasswa

Re: XI DB Connection Error on OPS Screen

Posted: Tue Sep 26, 2017 6:56 am
by blariv
added, I will monitor today and let you know if its fixed.

Re: XI DB Connection Error on OPS Screen

Posted: Tue Sep 26, 2017 9:03 am
by scottwilkerson
blariv wrote:added, I will monitor today and let you know if its fixed.
Sounds great let us know if the error returns.