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,1286104276,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,1286104281,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.
________
Sex sex

[magawake]

Here is what is coming from postgresql logs.

LOG:  statement: commit;
LOG:  statement: begin;
LOG:  statement: select itemid,status,lastclock,prevorgvalue,delta,multiplier,formula,history,trends from items where itemid in (23316,23317) order by itemid
LOG:  statement: update items set lastclock=1286115726,prevvalue=lastvalue,prevorgvalue=NULL,lastvalue='0.050000' where itemid=23316;
        update items set lastclock=1286115726,prevvalue=lastvalue,prevorgvalue=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?

________
INDICA STRAINS

[magawake]

help? Any one have any advice? Or should I switch to mysql?
________
Marijuana seeds

[magawake]

help? sounds like this is a legitimate bug.
________
Honda cbr series specifications

[magawake]

help? anyone have any suggestions?
________
SMALLVILLE FORUM