Yesterday one of our teams placed all the servers and related services in maintenance mode. Once the maintenance mode is completed, it started sending the notifications for all of the servers and services. As a result, message queue piled up. Please find the output and the message field is increasing gradually. Could you please help me sorting this issue.
Code: Select all
ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0x98000002 4292608 nagios 600 99653632 97318
Code: Select all
echo "SELECT relname AS objectname, relkind AS objecttype, reltuples, pg_size_pretty(relpages::bigint*8*1024) AS size FROM pg_class WHERE relpages >= 8 ORDER BY relpages DESC;" | psql nagiosxi nagiosxi
objectname | objecttype | reltuples | size
---------------------------------+------------+-----------+---------
pg_toast_16453 | t | 1529 | 4256 kB
xi_auditlog | r | 5636 | 1176 kB
xi_meta | r | 657 | 704 kB
xi_auditlog_ip_address | i | 5636 | 648 kB
xi_auditlog_source | i | 5636 | 616 kB
xi_auditlog_user | i | 5636 | 576 kB
xi_usermeta | r | 4963 | 504 kB
xi_auditlog_type | i | 5636 | 496 kB
pg_proc | r | 2220 | 432 kB
xi_auditlog_pkey | i | 5636 | 384 kB
xi_auditlog_log_time | i | 5636 | 384 kB
pg_attribute | r | 2397 | 368 kB
pg_depend | r | 5480 | 328 kB
xi_usermeta_user_id_key | i | 4963 | 288 kB
pg_depend_reference_index | i | 5480 | 272 kB
pg_depend_depender_index | i | 5480 | 256 kB
pg_statistic | r | 416 | 232 kB
pg_proc_proname_args_nsp_index | i | 2220 | 208 kB
pg_toast_2618 | t | 115 | 200 kB
pg_toast_2619 | t | 30 | 184 kB
xi_usermeta_autoload_idx | i | 4963 | 176 kB
pg_description | r | 2403 | 168 kB
xi_usermeta_pkey | i | 4963 | 136 kB
pg_description_o_c_o_index | i | 2403 | 128 kB
pg_attribute_relid_attnam_index | i | 2397 | 120 kB
pg_operator | r | 704 | 104 kB
xi_sysstat | r | 17 | 96 kB
pg_attribute_relid_attnum_index | i | 2397 | 80 kB
pg_rewrite | r | 86 | 72 kB
pg_proc_oid_index | i | 2220 | 64 kB
pg_toast_16453_index | i | 133 | 64 kB
(31 rows)
Code: Select all
ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0x98000002 4292608 nagios 600 123123712 120238