Postgresql errors in zabbix_Server log

[magawake]

I've noticed these message in zabbix_log.


5433:20101003:071113.650 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select distinct t.triggerid,t.type,t.value,t.error,t.expression,f. itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (22170,22171) order by t.triggerid]
5432:20101003:071118.651 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at or near ","
LINE 1: ...value) values (22170,1286104275,2529124181.000000),(22171,12...
^
[insert into history (itemid,clock,value) values (22170,1286104275,2529124181.000000),(22171,128610 4276,686486234.000000);
]
5432:20101003:071118.652 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select distinct t.triggerid,t.type,t.value,t.error,t.expression,f. itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (22170,22171) order by t.triggerid]
5431:20101003:071123.653 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at or near ","
LINE 1: ...value) values (22170,1286104280,2529124181.000000),(22171,12...
^
[insert into history (itemid,clock,value) values (22170,1286104280,2529124181.000000),(22171,128610 4281,686486234.000000),(22162,1286104282,0.930000) ,(22163,1286104283,1.030000);
]
5431:20101003:071123.654 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select distinct t.triggerid,t.type,t.value,t.error,t.expression,f. itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (22170,22171,22162,22163) order by t.triggerid]

If I run "select distinct t.triggerid,t.type,t.value,t.error,t.expression,f. itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (22170,22171) order by t.triggerid" on Postgresql i get no results back. There is no syntax with the query.:confused:
________
Sex sex (http://www.fucktube.com/)

[magawake]

Here is what is coming from postgresql logs.

LOG: statement: commit;
LOG: statement: begin;
LOG: statement: select itemid,status,lastclock,prevorgvalue,delta,multipl ier,formula,history,trends from items where itemid in (23316,23317) order by itemid
LOG: statement: update items set lastclock=1286115726,prevvalue=lastvalue,prevorgva lue=NULL,lastvalue='0.050000' where itemid=23316;
update items set lastclock=1286115726,prevvalue=lastvalue,prevorgva lue=NULL,lastvalue='0.010000' where itemid=23317;

ERROR: syntax error at or near "," at character 76
LOG: statement: select distinct t.triggerid,t.type,t.value,t.error,t.expression,f. itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (23317,23316) order by t.triggerid
ERROR: current transaction is aborted, commands ignored until end of transaction block
LOG: statement: commit;


There maybe a problem with zabbix deamon itself. Perhaps a bug?
:confused:
________
INDICA STRAINS (http://strainindex.com)

[magawake]

help? Any one have any advice? Or should I switch to mysql?
________
Marijuana seeds (http://marijuanaseeds.org/)

[magawake]

help? sounds like this is a legitimate bug.
________
Honda cbr series specifications (http://www.honda-wiki.org/wiki/Honda_CBR_series)

[magawake]

help? anyone have any suggestions?
________
SMALLVILLE FORUM (http://www.tv-gossip.com/smallville/)