Ad Widget

Collapse

zabbix 1.4.2, postgresql 8.2.5, freebsd 7.0 amd64

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dmitriy Kirhlarov
    Member
    • Jun 2007
    • 40

    #1

    zabbix 1.4.2, postgresql 8.2.5, freebsd 7.0 amd64

    zabbix stop with log:
    45057:20071211:011102 Timeout while connecting to [10.25.0.51:161]
    45057:20071211:011113 Timeout while answering request
    45057:20071211:011113 Get value from agent failed. Error: Cannot connect to [10.25.0.52:10050] [Interrupted system call]
    WARNING: terminating connection because of crash of another server process
    DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
    HINT: In a moment you should be able to reconnect to the database and repeat your command.
    45040:20071211:011115 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_typ
    e,h.errors_from,i.snmp_port,i.delta,i.prevorgvalue ,i.lastclock,i.units,i.multiplier,i.snmpv3_securit yname,i.snmpv3_securitylevel,i.snmpv3_authpassphra se,i.snmpv3_privpassphrase,i.formula,h.available,i .status,i.tr
    apper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex ,h.dns from hosts h, items i where i.nextcheck<=1197335474 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1197335474 and h.er
    rors_from=0 and h.hostid=i.hostid and mod(i.itemid,9)=8 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) order
    by i.nextcheck
    45040:20071211:011115 Query failed:PGRES_FATAL_ERROR:PANIC: stuck spinlock (0x8019290c0) detected at lwlock.c:379
    server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

    WARNING: terminating connection because of crash of another server process
    DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
    HINT: In a moment you should be able to reconnect to the database and repeat your command.
    45037:20071211:011115 Query::begin;
    45037:20071211:011115 Query failed:PGRES_FATAL_ERROR:server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

    45037:20071211:011115 Query::insert into history (clock,itemid,value) values (1197335475,22514,5.129032)
    45037:20071211:011115 Query failed:Result is NULL
    45037:20071211:011115 Query::select num,value_min,value_avg,value_max from trends where itemid=22514 and clock=1197334800
    45037:20071211:011115 Query failed:Result is NULL
    45034:20071211:011115 Query::begin;
    45034:20071211:011115 Query failed:PGRES_FATAL_ERROR:server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

    45034:20071211:011115 Query::insert into history_str (clock,itemid,value) values (1197335475,23114,' da0')
    45034:20071211:011115 Query failed:Result is NULL
    45034:20071211:011115 Query::update items set nextcheck=1197335504,prevvalue=lastvalue,lastvalue =' da0',lastclock=1197335475 where itemid=23114
    45034:20071211:011115 Query failed:Result is NULL
    45034:20071211:011115 Query::select distinct function,parameter,itemid,lastvalue from functions where itemid=23114
    45034:20071211:011115 Query failed:Result is NULL
    45015:20071211:011115 One child process died. Exiting ...

    after restart zabbix ignoring several checks.
Working...