Postgres disk activity

[avandemore]

Looks like I had the wrong syntax, please try this:

Code: Select all

# pidstat -C postgres -d 5 12

[ssax]

You may be hitting a bug, you can try running these commands and see if it resolves the issue for you:
- NOTE: Make sure you take an XI backups/VM snapshot just in case
- Running the below command will remove ALL data from Home > Event Log or Reports > Event Log (they are the same report).

Code: Select all

echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | psql nagiosxi nagiosxi

Thank you

[Fred Kroeger]

Thanks - ran the truncate command and it completed OK. However, not sure it did anything ?
I went to Home -> Event Log afterwards, and it shows that I have 100,000+ records in the last 24hrs?

[ssax]

Wow, that's a lot, how many total hosts/services do you have?

Please attach these files:

Code: Select all

/etc/cron.d/nagiosxi
/usr/local/nagiosxi/cron/event_handler.php
/usr/local/nagiosxi/cron/eventman.php

Please send the output of this command as well:

Code: Select all

ls -l /usr/local/nagiosxi/var

If you run a tail on this file does it send tons of information? Are there any errors shown?

Code: Select all

tail -F /usr/local/nagiosxi/var/event_handler.log

Thank you

[Fred Kroeger]

Hosts/Services = 1052/10252
Then we are getting events forwarded from two other Nagios Servers - Hosts/Services = 189/2017 & 237/2739
I disabled the Global Service event handler yesterday to reduce the number of events being written to the Event Log. Today it still shows 100,000+ entries for the last 24hrs.
I suppose doing the math that's almost 200,00 events an hour (assuming that they run every 5mins).

The event_handler.log file only has a single entry that the LOCK file was created.

BTW pidstat -C postgres -d 5 12 command doesn't work either... no values get returned.
Also I'm guessing that the truncate command did work as the xi-meta table is somewhat smaller today when I ran the query you sent and the other two tables don't appear in the listing now.

[ssax]

Let's move this into a ticket, please email [email protected] with a descriptive subject and detailed body and please include a link back to this thread so that we can get a remote session setup.

Thank you

[tmcdonald]

Closing, will continue in ticket.