Ad Widget

Collapse

zabbix 1.4.4 crash

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

    #1

    zabbix 1.4.4 crash

    58603:20080214:170640 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_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)
    58603:20080214:170640 Query failed:Result is NULL
    58584:20080214:170640 One child process died. Exiting ...

    # uname -rsm ; pkg_info -Ix zabbix ; pkg_info -Ix postgres
    FreeBSD 7.0-20071107-SNAP amd64
    zabbix-1.4.4,1 Application and network monitoring solution
    zabbix-agent-1.4.4,1 Application and network monitoring solution
    postgresql-client-8.2.6_1 PostgreSQL database (client)
    postgresql-server-8.2.6 The most advanced open-source database available anywhere
  • Dmitriy Kirhlarov
    Member
    • Jun 2007
    • 40

    #2
    71220:20080215:102233 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_ty
    pe,h.errors_from,i.snmp_port,i.delta,i.prevorgvalu e,i.lastclock,i.units,i.multiplier,i.snmpv3_securi tyname,i.snmpv3_securitylevel,i.snmpv3_authpassphr ase,i.snmpv3_privpassphrase,i.formula,h.available, i.status,i.
    trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_fl ex,h.dns from hosts h, items i where i.nextcheck<=1203070953 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1203070953 and h
    .errors_from=0 and h.hostid=i.hostid and mod(i.itemid,9)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) o
    rder by i.nextcheck
    71220:20080215:102233 Query failed:PGRES_FATAL_ERROR:PANIC: stuck spinlock (0x80190ca80) detected at lwlock.c:379
    server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.



    I know, zabbix_server can reconnect to mysql database. Alexey, is it possible -- extend this functionality to postgresql?

    Comment

    • Dmitriy Kirhlarov
      Member
      • Jun 2007
      • 40

      #3
      new crashe

      46208:20080216:235011 Query::insert into history (clock,itemid,value) values (1203205811,25536,1203205254000.000000)
      46208:20080216:235011 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow
      DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.

      Comment

      • Dmitriy Kirhlarov
        Member
        • Jun 2007
        • 40

        #4
        new crash

        46208:20080216:235011 Query::insert into history (clock,itemid,value) values (1203205811,25536,1203205254000.000000)
        46208:20080216:235011 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow
        DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.

        Comment

        Working...