Code: Select all
echo "select count(*) from nagios.nagios_acknowledgements;" | mysql -pnagiosxiCode: Select all
echo "select count(*) from nagios.nagios_acknowledgements;" | mysql -pnagiosxiabrist 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>
Sorry must have missed ittmcdonald 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.
Code: Select all
[nagios@nagiosprodxi1 logs]$ ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0xe7000002 1277952 nagios 600 292864 286
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]$
Ok. Please close this case for now.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.