backend connection problem

[Dmitriy Kirhlarov]

I trying to setup zabbix
Time-to-time zabbix server die on the fly. I can't find reason in log file:

20183:20070625:203507 Spent 0 seconds while processing HTTP tests
20183:20070625:203507 Query [select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,5)=3 and t.httptestid>=100000000000000*0 and t.httptestid<=(100000000000000*0+99999999999999) ]
20183:20070625:203507 Nextcheck:-1 Time:1182789307
20183:20070625:203507 Sleeping for 5 seconds
^^^^^^^^^^^^^^
we are working

20177:20070625:203507 Connection to database 'zabbix' failed.
20175:20070625:203507 Connection to database 'zabbix' failed.
20159:20070625:203507 Connection to database 'zabbix' failed.
^^^^^^^^^^^^^^
we can't connect to database? How it possible? database on same host and doesn't restarted

20159:20070625:203507 Watchdog: Database is up
^^^^^^^^^^^^^^
and zabbix can see database

20159:20070625:203507 One child process died. Exiting ...
20164:20070625:203507 Got signal. Exiting ...
^^^^^^^^^^^^^^
but dying

zabbix-1.4 with postgresql backend on freebsd 6.2
any hints?

[Alexei]

Database watchdog works correctly only for MySQL in 1.4.

[Dmitriy Kirhlarov]

ok. watchdog is lier.
but how zabbix can lost connection?
How I can debug this problem?

[Alexei]

Check PostgreSQL log files. I'm pretty sure the PostgreSQL was stopped or restarted at some point.

[Dmitriy Kirhlarov]

I find "connection limit exceeded for non-superusers" in postgresql log.
postgresql accept 40 connections.
How many connections to database need for zabbix?

Also, Alexei, could you please answer me to data from snmp *Descr in graphing legend. Is it planned and when, if planned?

[Alexei]

I find "connection limit exceeded for non-superusers" in postgresql log.

I bet most of the connections comes from Apache and PHP. ZABBIX does not require more than one database connection per each ZABBIX server process.