Ad Widget

Collapse

ZABBIX 1.4.5 + PostgreSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • d_pilot
    Junior Member
    • Jun 2008
    • 11

    #1

    ZABBIX 1.4.5 + PostgreSQL

    Hi.
    I'm having a trouble with ZABBIX Server 1.4.5 + PostgreSQL 8.3 + FreeBSD 7.0
    DB and Server is on different hosts.
    Here is log from DB host:
    Code:
    postgres[878]: [4-1] ERROR:  numeric field overflow
    postgres[878]: [4-2] DETAIL:  A field with precision 24, scale 6 must round to an absolute value less than 10^18.
    postgres[878]: [4-3] STATEMENT:  insert into trends (clock,itemid,num,value_min,value_avg,value_max) values
    postgres[878]: [4-4]  (1212620400,19763,1,9223372036854775808.000000,9223372036854775808.000000,9223372036854775808.000000)
    postgres[878]: [5-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
    postgres[878]: [5-2] STATEMENT:  update items set nextcheck=1212623963,prevvalue=lastvalue,lastvalue='9223372036854775807',lastclock=1212623956 where
    postgres[878]: [5-3]  itemid=19763
    postgres[878]: [6-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
    postgres[878]: [6-2] STATEMENT:  select distinct function,parameter,itemid,lastvalue from functions where itemid=19763
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    This will be officially fixed in 1.6. For now you may use a patch already posted in the forums.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • vinny
      Senior Member
      • Jan 2008
      • 145

      #3
      To solve the pb directly, increase in the DB - table trends - the field size.
      vinny
      -------
      Zabbix 1.8.3, 1200+ Hosts, 40 000+ Items...zabbix's everywhere

      Comment

      • d_pilot
        Junior Member
        • Jun 2008
        • 11

        #4
        Where is this patch?
        Give me link, please.

        Comment

        Working...