Acknowledgements missing

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Acknowledgements missing

Post by abrist »

Is your acknowledgements table empty? (run from your offloaded db server)

Code: Select all

echo "select count(*) from nagios.nagios_acknowledgements;" | mysql -pnagiosxi
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Acknowledgements missing

Post by rajasegar »

abrist wrote:Is your acknowledgements table empty? (run from your offloaded db server)

Code: Select all

echo "select count(*) from nagios.nagios_acknowledgements;" | mysql -pnagiosxi

Code: Select all

mysql> select count(*) from nagios.nagios_acknowledgements;
+----------+
| count(*) |
+----------+
|     3527 |
+----------+
1 row in set (0.00 sec)

mysql>
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Acknowledgements missing

Post by tmcdonald »

A few posts back we asked for the "ipcs -q" output and I don't see it anywhere. Could you please provide it? We have been seeing strange issues lately with the kernel message queue filling up.
Former Nagios employee
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Acknowledgements missing

Post by rajasegar »

tmcdonald wrote:A few posts back we asked for the "ipcs -q" output and I don't see it anywhere. Could you please provide it? We have been seeing strange issues lately with the kernel message queue filling up.
Sorry must have missed it

Code: Select all

[nagios@nagiosprodxi1 logs]$ ipcs -q

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages
0xe7000002 1277952    nagios     600        292864       286
Here is ulimit -a in case you need it also.

Code: Select all

[nagios@nagiosprodxi1 logs]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 95126
max locked memory       (kbytes, -l) 128
max memory size         (kbytes, -m) unlimited
open files                      (-n) 4096
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 20480
cpu time               (seconds, -t) unlimited
max user processes              (-u) 1024
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
[nagios@nagiosprodxi1 logs]$

5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Acknowledgements missing

Post by abrist »

Kernel messages looks fine.
Well, your historical table looks intact and populated, but it is not used for runtime acknowledgements. I wish I I had better news or more information, but retention.dat is the only place the runtime acks and comments are stored. Something *must* have happened to it, and there is nothing we can do about it now.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Acknowledgements missing

Post by rajasegar »

abrist wrote:Kernel messages looks fine.
Well, your historical table looks intact and populated, but it is not used for runtime acknowledgements. I wish I I had better news or more information, but retention.dat is the only place the runtime acks and comments are stored. Something *must* have happened to it, and there is nothing we can do about it now.
Ok. Please close this case for now.
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
Locked