Page 1 of 1
Nagios eating up database resources on end point machine
Posted: Mon Oct 29, 2018 8:39 am
by mohan23
We have recently upgraded check_oracle_health plugin to latest version as per suggestion from nagios support and after couple of months of upgrading check_oracle_heath plugin to latest version we are again seeing nagios tends to open 600+ open sessions(from perl@nagioshost) causing database performance issue. Can some one help me to fix this issue. It's impacting production database server.
Regards,
Mohan
Re: Nagios eating up database resources on end point machine
Posted: Mon Oct 29, 2018 12:28 pm
by cdienger
Do the sessions build up over time or is it a sudden jump in sessions? Is this happening with a specific check or query? You may want to reach out to the DBA to see if there are any settings available on the DB that can close idle sessions.
Re: Nagios eating up database resources on end point machine
Posted: Mon Oct 29, 2018 4:44 pm
by mohan23
Sometimes these sessions buildup over time and sometimes it's a sudden Jump . Especially table space queries/checks from check_oracle_healh plugin using to poll/query endpoint database are causing this. I will reach out to DBA and will post you update on whether we have option of closing idle sessions or not. Even if they have option of this, if a session is hung/long running session this will make session open from nagios to database. Last time also there are hell lot of hung/long running sessions causing performance issues and DBA's manaully need to kill all those hung sessions and even after killing nagios is opening bulk open sessions immediately in a shorter span of time.
For the same server, im seeing below error from last one day for all table space checks.
(No output on stdout) stderr: bumm Can't call method "execute" on an undefined value at /usr/local/nagios/libexec/check_oracle_health line 6287.
Can't use an undefined value as an ARRAY reference at /usr/local/nagios/libexec/check_oracle_health line 6301.
Re: Nagios eating up database resources on end point machine
Posted: Tue Oct 30, 2018 12:27 pm
by cdienger
Please open a ticket for this and we can take a closer look.
Re: Nagios eating up database resources on end point machine
Posted: Wed Oct 31, 2018 7:55 am
by mohan23
https://support.nagios.com/tickets/tickets.php?id=3744
support ticket has been raised . let me know when we can have webex and troubleshoot this further.
Re: Nagios eating up database resources on end point machine
Posted: Wed Oct 31, 2018 9:32 am
by cdienger
Ticket received. Locking thread.