-
Incident report
-
Resolution: Won't fix
-
Blocker
-
None
-
2.4.0
-
None
-
10.0-RELEASE-p9,x64
psql (PostgreSQL) 9.3.5, with table partitions
hi support,
after tricky upgrade from 2.2.4 to 2.4.0 -> ZBX-8775, i get this error message now, if i will update a host with new template (unlink, link).
Error message frontend:
pg_query(): Query failed: ERROR: null value in column "nodeid" violates not-null constraint
DETAIL: Failing row contains (null, item_condition, item_conditionid, 39842). [hosts.php:518 ? CFrontendApiWrapper->update() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CDiscoveryRule->syncTemplates() ? CDiscoveryRule->inherit() ? CDiscoveryRule->createReal() ? DB::save() ? DB::insert() ? DB::reserveIds() ? DB::refreshIds() ? DBexecute() ? pg_query() in /usr/local/www/zabbix22/include/db.inc.php:520]
Error message psql logfiles:
2014-09-19 14:25:47.162 CEST zabbix@zabbix 48231 127.0.0.1(36874) ERROR: null value in column "nodeid" violates not-null constraint 2014-09-19 14:25:47.162 CEST zabbix@zabbix 48231 127.0.0.1(36874) DETAIL: Failing row contains (null, item_condition, item_conditionid, 39842). 2014-09-19 14:25:47.162 CEST zabbix@zabbix 48231 127.0.0.1(36874) STATEMENT: INSERT INTO ids (table_name,field_name,nextid) VALUES ('item_condition','item_conditionid',39842)
When will resolve the current problem, which is a further problem of ZBX-8775 ?
I need v2.4.0 so i can use the new feature to disable "Use bulk requests" here.
Thanks for any help