Today I installed 1.8.1 and upgraded my 1.6 database. The load on the server jumped from ~0.5 to ~4 and my zabbix log shows some database errors (see below). Any thoughts on what is going on and how to fix it?
Code:
$ tail -f /tmp/zabbix_server.log|grep ERROR -A 1 -- 1479:20100210:163224.108 [Z3005] Query failed: [0] 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. -- 1479:20100210:163224.109 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block [select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime,f.function,f.parameter,f.itemid,f.lastvalue from hosts h,items i,functions f,triggers t where f.itemid=i.itemid and h.hostid=i.hostid and f.triggerid=t.triggerid and t.status in (0) and f.itemid in (27949,28005,28069,28309,28336,28337,28338,28339,28340,28341,28342,28460,28516,28517,28518,28519,28520,28521,28522,28548,28549,28551,28552,28568,28812,28821,28822,28880,28941,28996,28997,28998,28999,29000,29001,29002,29037,29038,29056,29058,29281,29282,29297,29298,29299,29300,29302,29536,29537,29539,29540,29541,29542,29544,29561,29562,29567,29568,29570,29571,29572,29584,29585,29587,29588,29600,29601,29602,29607,29608,29609,29610,29619,29626,29627,29628,29629,29656,29657,29658,29659,29660,29661,29662,29778,29779,29780,29781,29782,29836,29837,29838,29839,29840,29841,29842,29870,29871,29872,29878,29879,29901,29902,29904,29905,29927,29929,29930,29931,29932,29936,29957,29958,29959,29960,29961,29962,30020,30197,30198,30199,30200,30201,30202,30218,30219,30221,30222,30226,30227,30228,30229,30241,30242,30253,30256,30260,30261,30262,30287,30288,30316,30377,30682,30736,30737,30738,30739,30740,30741,30742,30796,30857,30916,30917,30920,30921,30922,31159,31160,31161,31162,31186,31188,31189,31190,31192,31208,31219,31220,31277,31336,31337,31456,31457,31458,31459,31460,31461,31462,31517,31639,31640,31641,31642,31699,32285,32286,32287,32288,32289,32537,32538,32550,32551,32569,32570,32572,32596,32597,32598,32599,32600,32601,32602,32603,32656,32657,32721,32836,32837,32838,32839,32840,32841,32842,32896,33136,33137,33138,33139,33140,33141,33142,33256,33257,33258,33259,33260,33261,33262,33316,33317,33318,33319,33320,33321,33322,33376,33377,33378,33379,33380,33381,33382,33496,33497,33498,33499,33500,33501,33502,33556,33557,33558,33559,33560,33561,33562,33616,33617,33618,33619,33620,33621,33622,33676,33677,33678,33679,33680,33681,33682,33737,33738,33739,33740,33741,33742,33796,33797,33798,33799,33800,33801,33802,33856,33857,33858,33859,33860,33861,33862,33916,33917,33918,33919,33920,33921,33922,33976,33977,33978,33979,33980,33981,33982,34039,34100,34156,34157,34158,34159,34276,34337,34459,34576,34577,34578,34579,34580,34581,34582,34816,34817,34818,34819,34820,34821,34822,34936,35236,35237,35238,35239,35300,35361,35417,35420,35421,35422,35597,35598,35599,35600,35601,35602,35836,35837,35838,35839,35840,35841,35842,35960,36016,36017,36018,36019,36020,36021,36022,36077)]