Настроил мониторинг log-файла postgresql через Zabbix, при появлении следующих ошибок zabbix аварийно останавливается.
Также заметил, что при отсутствии связи с сервером БД, сервер аварийно останавливается...но тут хоть понять можно-он все данные пишет в базу и читает конфиг с нее...хотя можно, наверно, предусмотреть что-нибудь типа режима бездействия при отсутствии связи с БД.
PS: версия 1.6.4.
23260:20090415:192943 Item [Mail-server:net.if.in[eth3,bytes]] error:
Not supported by ZABBIX agent
23273:20090415:192947 Item [d3526_kv:ifInOctets.14] error: Timeout
while connecting to [192.168.105.206:161]
23265:20090415:192949 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:
неверная последовательность байт имя кодировки "UTF8": 0xcbd7
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
[insert into history_log (id,clock,itemid,timestamp,value,source,severity)
values (21,1239798584,27078,0,'2009-04-15 19:29:37 NOVST admin 127.0.0.1
STATEMENT: SELECT id, name, CASE WHEN kv is NOT NULL THEN dom || \' ▒▒. \'
|| kv ELSE dom END, CASE WHEN type=\'▒▒▒▒▒▒▒\' THEN \'▒.▒.\' WHEN
type=\'▒▒▒▒▒▒▒▒▒▒▒\' THEN \'▒.▒.\' END, status, id_gw, bl_global, bl_game,
tel, ip, tel, firm FROM view_clients WHERE (ip>>=\'82.200.315\' and
ip<>\'192.168.0.0/16\') OR (gw=\'82.200.315\') OR (ip_gw=\'82.200.315\')
ORDER BY name','',0)]
23265:20090415:192949 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:
неверная последовательность байт имя кодировки "UTF8": 0xcbd7
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
[update items set
nextcheck=1239798594,prevvalue=lastvalue,lastvalue ='2009-04-15 19:29:37
NOVST admin 127.0.0.1 STATEMENT: SELECT id, name, CASE WHEN kv is NOT NULL
THEN dom || \' ▒▒. \' || kv ELSE dom END, CASE WHEN type=\'▒▒▒▒▒▒▒\' THEN
\'▒.▒.\' WHEN type=\'▒▒▒▒▒▒▒▒▒▒▒\' THEN \'▒.▒.\' END, status, id_gw,
bl_global, bl_game, tel, i',lastclock=1239798584,lastlogsize=6209 where
itemid=27078]
23265:20090415:192949 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:
current transaction is aborted, commands ignored until end of transaction
block
[select distinct function,parameter,itemid,lastvalue from functions where
itemid=27078]
23254:20090415:192949 One child process died. Exiting ...
23254:20090415:192951 ZABBIX Server stopped. ZABBIX 1.6.4.
Not supported by ZABBIX agent
23273:20090415:192947 Item [d3526_kv:ifInOctets.14] error: Timeout
while connecting to [192.168.105.206:161]
23265:20090415:192949 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:
неверная последовательность байт имя кодировки "UTF8": 0xcbd7
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
[insert into history_log (id,clock,itemid,timestamp,value,source,severity)
values (21,1239798584,27078,0,'2009-04-15 19:29:37 NOVST admin 127.0.0.1
STATEMENT: SELECT id, name, CASE WHEN kv is NOT NULL THEN dom || \' ▒▒. \'
|| kv ELSE dom END, CASE WHEN type=\'▒▒▒▒▒▒▒\' THEN \'▒.▒.\' WHEN
type=\'▒▒▒▒▒▒▒▒▒▒▒\' THEN \'▒.▒.\' END, status, id_gw, bl_global, bl_game,
tel, ip, tel, firm FROM view_clients WHERE (ip>>=\'82.200.315\' and
ip<>\'192.168.0.0/16\') OR (gw=\'82.200.315\') OR (ip_gw=\'82.200.315\')
ORDER BY name','',0)]
23265:20090415:192949 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:
неверная последовательность байт имя кодировки "UTF8": 0xcbd7
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
[update items set
nextcheck=1239798594,prevvalue=lastvalue,lastvalue ='2009-04-15 19:29:37
NOVST admin 127.0.0.1 STATEMENT: SELECT id, name, CASE WHEN kv is NOT NULL
THEN dom || \' ▒▒. \' || kv ELSE dom END, CASE WHEN type=\'▒▒▒▒▒▒▒\' THEN
\'▒.▒.\' WHEN type=\'▒▒▒▒▒▒▒▒▒▒▒\' THEN \'▒.▒.\' END, status, id_gw,
bl_global, bl_game, tel, i',lastclock=1239798584,lastlogsize=6209 where
itemid=27078]
23265:20090415:192949 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:
current transaction is aborted, commands ignored until end of transaction
block
[select distinct function,parameter,itemid,lastvalue from functions where
itemid=27078]
23254:20090415:192949 One child process died. Exiting ...
23254:20090415:192951 ZABBIX Server stopped. ZABBIX 1.6.4.
PS: версия 1.6.4.
Comment