When running zabbix_server after a fresh installation, constant crashing within 5 minutes of start up. I am able to easily reproduce the bug. I do know that the errors in the SQL log were also in 1.9.7, 1.9.6 but do not have logs from them.
I am open to any and all testing.

Thank you,
-Myles

Error in zabbix_server.log as follows:

24666:20111218:165628.410 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: deadlock detected
DETAIL: Process 2303 waits for ShareLock on transaction 26230605; blocked by process 2305.
Process 2305 waits for ShareLock on transaction 26230631; blocked by process 2303.
HINT: See server log for query details.
[update ids set nextid=nextid+3 where nodeid=0 and table_name='triggers' and field_name='triggerid']
zabbix_server [24666]: ERROR file:db.c,line:1401 Something impossible has just happened.
zabbix_server: str.c:220: zbx_vsnprintf: Assertion `str' failed.
24646:20111218:165628.411 One child process died (PID:24666,exitcode/signal:6). Exiting ...
24646:20111218:165630.486 syncing history data...
24646:20111218:165631.738 syncing history data done
24646:20111218:165631.738 syncing trends data...
24646:20111218:165632.086 syncing trends data done
24646:20111218:165632.086 Zabbix Server stopped. Zabbix 1.9.9 (revision 24052).

—

Possibly relevant errors in PostgreSQL error log:

ERROR: update or delete on table "hosts" violates foreign key constraint "c_optemplate_2" on table "optemplate"
DETAIL: Key (hostid)=(10001) is still referenced from table "optemplate".
STATEMENT: delete from hosts where hostid in (10001,10002,10003,10004,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10038,10039,10040,10041,10042,10043,10044,10045,10046)