Some queries never complete

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Locked
jpconsilio
Posts: 12
Joined: Mon Sep 30, 2019 11:48 am

Some queries never complete

Post by jpconsilio »

Hi,
I'm not getting any results for certain queries for specific two week period. The page time out before any results are presented.
When I query the same period for events from the same period for my own username, I get results in minutes. For the user of interest: the query never completes. For successful queries of myself I see events only for a three day period, when I know there was activity for every day both weeks. I suspect there was some problem with the log servers during this period.

Occasionally when I sign in to log server, I find that each instance in the two instance cluster in Yellow health status and showing that its opposite is not running the elasticsearch or logstash services with half of the shards

There's about 750GB of data with 224GB available on disk.
Any assistance appreciated.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Some queries never complete

Post by cdienger »

Please provide me with screenshots highlighting the query that you are running as well as the results.

Please also PM me a profile from each machine. A can be gathered under Admin > System > System Status > Download System Profile or from the command line with:

Code: Select all

/usr/local/nagioslogserver/scripts/profile.sh
This will create /tmp/system-profile.tar.gz.

Note that this file can be very large and may not be able to be uploaded through the ticketing system. This is usually due to the logs in the Logstash and/or Elasticsearch directories found in it. If it is too large, please open the profile, extract these directories/files and send them separately.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked