Здравствуйте !
Имеем
zabbix_proxy 2.0.8 установленный из последних портов на FreeBSD 8.3-RELEASE.
СУБД - PostgreSQL 9.2.4 (клиент 9.2.5)
Первый запуск.
В логах имеем -
=======================================
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "groups" violates foreign key constraint "c_opgroup_2" on table "opgroup"
DETAIL: Key (groupid)=(2) is still referenced from table "opgroup".
[delete from applications where (applicationid between 227 and 232 or applicationid between 234 and 238 or applicationid between 245 and 311 or applicationid between 328 and 355 or applicationid in (1,5,7,9,13,15,17,21,23,179,206,207,214,240,241,24 2,319,320,322,323,324,325));
delete from groups where groupid in (1,2,4);
delete from dchecks where dcheckid=2;
delete from drules where druleid=2;
delete from interface where interfaceid=1;
delete from hosts where (hostid between 10065 and 10079 or hostid in (10001,10047,10050,10056,10060,10081,10082,10083,1 0084));
]
26054:20131108:124307.208 failed to update local proxy configuration copy: database error
===============================================
Явно проблема с БД. Но как починить ?
Удачи !
Имеем
zabbix_proxy 2.0.8 установленный из последних портов на FreeBSD 8.3-RELEASE.
СУБД - PostgreSQL 9.2.4 (клиент 9.2.5)
Первый запуск.
В логах имеем -
=======================================
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "groups" violates foreign key constraint "c_opgroup_2" on table "opgroup"
DETAIL: Key (groupid)=(2) is still referenced from table "opgroup".
[delete from applications where (applicationid between 227 and 232 or applicationid between 234 and 238 or applicationid between 245 and 311 or applicationid between 328 and 355 or applicationid in (1,5,7,9,13,15,17,21,23,179,206,207,214,240,241,24 2,319,320,322,323,324,325));
delete from groups where groupid in (1,2,4);
delete from dchecks where dcheckid=2;
delete from drules where druleid=2;
delete from interface where interfaceid=1;
delete from hosts where (hostid between 10065 and 10079 or hostid in (10001,10047,10050,10056,10060,10081,10082,10083,1 0084));
]
26054:20131108:124307.208 failed to update local proxy configuration copy: database error
===============================================
Явно проблема с БД. Но как починить ?
Удачи !
Comment