Nagios Support Forum

Code: Select all

 OR eventqueue_id = 5311130 OR eventqueue_id = 5311131 OR eventqueue_id = 5311132 OR eventqueue_id = 5311133 OR eventqueue_id = 5311136 OR eventqueue_id = 5311137 OR eventqueue_id = 5311138 OR eventqueue_id = 5311139 OR eventqueue_id = 5311140 OR eventqueue_id = 5311141 OR eventqueue_id = 5311142 OR eventqueue_id = 5311143 OR eventqueue_id = 5311144 OR eventqueue_id = 5311145 OR eventqueue_id = 5311146 OR eventqueue_id = 5311147 OR eventqueue_id = 5311148 OR eventqueue_id = 5311149 OR eventqueue_id = 5311150 OR eventqueue_id = 5311151 OR eventqueue_id = 5311153 OR eventqueue_id = 5311154 OR eventqueue_id = 5311155 OR eventqueue_id = 5311156 OR eventqueue_id = 5311157 OR eventqueue_id = 5311158 OR eventqueue_id = 5311159 OR eventqueue_id = 5311160 OR eventqueue_id = 5311161 OR eventqueue_id = 5311162 OR eventqueue_id = 5311163 OR eventqueue_id = 5311164 OR eventqueue_id = 5311165 OR eventqueue_id = 5311166 OR eventqueue_id = 5311167 OR eventqueue_id = 5311168 OR eventqueue_id = 5311169 OR eventqueue_id = 5311170 OR eventqueue_id = 5311171 OR eventqueue_id = 5311172 OR eventqueue_id = 5311173 OR eventqueue_id = 5311174 OR eventqueue_id = 5311175 OR eventqueue_id = 5311176 OR eventqueue_id = 5311177 OR eventqueue_id = 5311178 OR eventqueue_id = 5311179 OR eventqueue_id = 5311180 OR eventqueue_id = 5311181 OR eventqueue_id = 5311182 OR eventqueue_id = 5311183 OR eventqueue_id = 5311184 OR eventqueue_id = 5311185 OR eventqueue_id = 5311186 OR eventqueue_id = 5311187 OR eventqueue_id = 5311188 OR eventqueue_id = 5311189 OR eventqueue_id = 5311190 OR eventqueue_id = 5311191 OR eventqueue_id = 5311192 OR eventqueue_id = 5311193 OR eventqueue_id = 5311194 OR eventqueue_id = 5311195 OR eventqueue_id = 5311196 OR eventqueue_id = 5311197 OR eventqueue_id = 5311198 OR eventqueue_id = 5311199 OR eventqueue_id = 5311200 OR eventqueue_id = 5311201 OR eventqueue_id = 5311202 OR eventqueue_id = 5311203 OR eventqueue_id = 5311204 OR eventqueue_id = 5311205 OR eventqueue_id = 5311206 OR eventqueue_id = 5311207 OR eventqueue_id = 5311208 OR eventqueue_id = 5311209 OR eventqueue_id = 5311210 OR eventqueue_id = 5311211 OR eventqueue_id = 5311212 OR eventqueue_id = 5311213 OR eventqueue_id = 5311214 OR eventqueue_id = 5311215 OR eventqueue_id = 5311216 OR eventqueue_id = 5311217 OR eventqueue_id = 5311218 OR eventqueue_id = 5311219 OR eventqueue_id = 5311220 OR eventqueue_id = 5311221 OR eventqueue_id = 5311222 OR eventqueue_id = 5311223 OR eventqueue_id = 5311224 OR eventqueue_id = 5311225 OR eventqueue_id = 5311226 OR eventqueue_id = 5311227 OR eventqueue_id = 5311228 OR eventqueue_id = 5311229 OR eventqueue_id = 5311230 OR eventqueue_id = 5311231 OR eventqueue_id = 5311232 OR eventqueue_id = 5311233 OR eventqueue_id = 5311234 OR eventqueue_id = 5311235 OR eventqueue_id = 5311236 OR eventqueue_id = 5311237 OR eventqueue_id = 5311238 OR eventqueue_id = 5311239 OR eventqueue_id = 5311240 OR eventqueue_id = 5311241 OR eventqueue_id = 5311242 OR eventqueue_id = 5311243 OR eventqueue_id = 5311244 OR eventqueue_id = 5311245 OR eventqueue_id = 5311246
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (11 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (11 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".
LOG:  checkpoints are occurring too frequently (10 seconds apart)
HINT:  Consider increasing the configuration parameter "checkpoint_segments".

Code: Select all

    [event_time] =>
    [2] => 2
    [event_source] => 2
    [3] => 1
    [event_type] => 1
    [4] => YToyMDp7czoxMjoiaGFuZGxlci10eXBlIjtzOjc6InNlcnZpY2UiO3M6NDoiaG9zdCI7czoxNzoiSkhSX0JSX0JnblBlbGFuZ2kiO3M6Nzoic2VydmljZSI7czoyODoiUG9ydCAwNiBTdGF0dXMgLSBTZXJpYWwwLzAvMCI7czoxMToiaG9zdGFkZHJlc3MiO3M6MTE6IjEwLjEuMTUuMjU0IjtzOjk6Imhvc3RzdGF0ZSI7czoyOiJVUCI7czoxMToiaG9zdHN0YXRlaWQiO3M6MToiMCI7czoxMToiaG9zdGV2ZW50aWQiO3M6ODoiMTAzMjkyODMiO3M6MTM6Imhvc3Rwcm9ibGVtaWQiO3M6MToiMCI7czoxMjoic2VydmljZXN0YXRlIjtzOjI6Ik9LIjtzOjE0OiJzZXJ2aWNlc3RhdGVpZCI7czoxOiIwIjtzOjE2OiJsYXN0c2VydmljZXN0YXRlIjtzOjc6IlVOS05PV04iO3M6MTg6Imxhc3RzZXJ2aWNlc3RhdGVpZCI7czoxOiIzIjtzOjE2OiJzZXJ2aWNlc3RhdGV0eXBlIjtzOjQ6IkhBUkQiO3M6MTQ6ImN1cnJlbnRhdHRlbXB0IjtzOjE6IjIiO3M6MTE6Im1heGF0dGVtcHRzIjtzOjE6IjIiO3M6MTQ6InNlcnZpY2VldmVudGlkIjtzOjg6IjEwMzMyMjM1IjtzOjE2OiJzZXJ2aWNlcHJvYmxlbWlkIjtzOjE6IjAiO3M6MTM6InNlcnZpY2VvdXRwdXQiO3M6MjU6Ik9LIC0gU2VyaWFsMC8wLzAgaXMgdXAvdXAiO3M6MTc6ImxvbmdzZXJ2aWNlb3V0cHV0IjtiOjA7czoxNToic2VydmljZWRvd250aW1lIjtzOjE6IjAiO30=
    [event_meta] => YToyMDp7czoxMjoiaGFuZGxlci10eXBlIjtzOjc6InNlcnZpY2UiO3M6NDoiaG9zdCI7czoxNzoiSkhSX0JSX0JnblBlbGFuZ2kiO3M6Nzoic2VydmljZSI7czoyODoiUG9ydCAwNiBTdGF0dXMgLSBTZXJpYWwwLzAvMCI7czoxMToiaG9zdGFkZHJlc3MiO3M6MTE6IjEwLjEuMTUuMjU0IjtzOjk6Imhvc3RzdGF0ZSI7czoyOiJVUCI7czoxMToiaG9zdHN0YXRlaWQiO3M6MToiMCI7czoxMToiaG9zdGV2ZW50aWQiO3M6ODoiMTAzMjkyODMiO3M6MTM6Imhvc3Rwcm9ibGVtaWQiO3M6MToiMCI7czoxMjoic2VydmljZXN0YXRlIjtzOjI6Ik9LIjtzOjE0OiJzZXJ2aWNlc3RhdGVpZCI7czoxOiIwIjtzOjE2OiJsYXN0c2VydmljZXN0YXRlIjtzOjc6IlVOS05PV04iO3M6MTg6Imxhc3RzZXJ2aWNlc3RhdGVpZCI7czoxOiIzIjtzOjE2OiJzZXJ2aWNlc3RhdGV0eXBlIjtzOjQ6IkhBUkQiO3M6MTQ6ImN1cnJlbnRhdHRlbXB0IjtzOjE6IjIiO3M6MTE6Im1heGF0dGVtcHRzIjtzOjE6IjIiO3M6MTQ6InNlcnZpY2VldmVudGlkIjtzOjg6IjEwMzMyMjM1IjtzOjE2OiJzZXJ2aWNlcHJvYmxlbWlkIjtzOjE6IjAiO3M6MTM6InNlcnZpY2VvdXRwdXQiO3M6MjU6Ik9LIC0gU2VyaWFsMC8wLzAgaXMgdXAvdXAiO3M6MTc6ImxvbmdzZXJ2aWNlb3V0cHV0IjtiOjA7czoxNToic2VydmljZWRvd250aW1lIjtzOjE6IjAiO30=
)
    <p><pre>SQL Error [nagiosxi] : ERROR:  stack depth limit exceeded
HINT:  Increase the configuration parameter "max_stack_depth", after ensuring the platform's stack depth limit is adequate.</pre></p>

Code: Select all

SNMP TRAP SENDER NOT CONFIGURED!
PROCESS EVENT: ID=167049178, SOURCE=2, TYPE=1, TIME=2018-07-10 00:00:18.478106
*** GLOBAL HANDLER...
Array
(
    [event_id] => 167049178
    [event_source] => 2
    [event_type] => 1
    [event_time] => 2018-07-10 00:00:18.478106
    [event_meta] => Array
        (
            [handler-type] => service
            [host] => MBCMAIL01
            [service] => CPU Load
            [hostaddress] => 10.23.18.25
            [hoststate] => UP
            [hoststateid] => 0
            [hosteventid] => 10219291
            [hostproblemid] => 0
            [servicestate] => UNKNOWN
            [servicestateid] => 3
            [lastservicestate] => UNKNOWN
            [lastservicestateid] => 3
            [servicestatetype] => SOFT
            [currentattempt] => 3
            [maxattempts] => 6
            [serviceeventid] => 10301295
            [serviceproblemid] => 4560075
            [serviceoutput] => CHECK_NRPE: Socket timeout after 60 seconds.
            [longserviceoutput] =>
            [servicedowntime] => 0
        )

    [logging_enabled] => 1
)

Code: Select all

service nagios stop
service ndo2db stop
service crond stop
pkill -9 -u nagios
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | psql nagiosxi nagiosxi
echo "vacuum;vacuum analyze;vacuum full;"|psql nagiosxi postgres
service postgresql restart
service crond start
service ndo2db start
service nagios start
service npcd restart

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

Code: Select all

[root@nagiosprodxi1 ~]# 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
---------------------------------+------------+-----------+---------
 xi_options                      | r          |      4114 | 1016 kB
 pg_proc                         | r          |      2220 | 432 kB
 pg_attribute                    | r          |      2397 | 336 kB
 pg_depend                       | r          |      5659 | 336 kB
 xi_options_name_idx             | i          |      4114 | 312 kB
 pg_depend_reference_index       | i          |      5659 | 280 kB
 pg_depend_depender_index        | i          |      5659 | 272 kB
 xi_auditlog                     | r          |      1956 | 264 kB
 xi_auditlog_ip_address          | i          |      1956 | 232 kB
 xi_auditlog_user                | i          |      1956 | 208 kB
 pg_proc_proname_args_nsp_index  | i          |      2220 | 208 kB
 pg_toast_2618                   | t          |       115 | 200 kB
 xi_usermeta                     | r          |      1234 | 176 kB
 pg_description                  | r          |      2403 | 168 kB
 xi_auditlog_source              | i          |      1956 | 136 kB
 pg_statistic                    | r          |       420 | 136 kB
 pg_description_o_c_o_index      | i          |      2403 | 128 kB
 xi_auditlog_type                | i          |      1956 | 128 kB
 xi_options_pkey                 | i          |      4114 | 128 kB
 pg_attribute_relid_attnam_index | i          |      2397 | 120 kB
 pg_toast_2619                   | t          |        56 | 104 kB
 xi_usermeta_user_id_key         | i          |      1234 | 104 kB
 pg_operator                     | r          |       704 | 104 kB
 pg_attribute_relid_attnum_index | i          |      2397 | 80 kB
 xi_usermeta_autoload_idx        | i          |      1234 | 72 kB
 pg_rewrite                      | r          |        86 | 72 kB
 xi_auditlog_pkey                | i          |      1956 | 72 kB
 xi_auditlog_log_time            | i          |      1956 | 72 kB
 pg_proc_oid_index               | i          |      2220 | 64 kB
 pg_type                         | r          |       328 | 64 kB
(30 rows)