[Bug 276272] net-mgmt/icingadb: FATAL icingadb pq: relation "history" does not exist
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Fri, 12 Jan 2024 10:53:29 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=276272
Bug ID: 276272
Summary: net-mgmt/icingadb: FATAL icingadb pq:
relation "history" does not exist
Product: Ports & Packages
Version: Latest
Hardware: Any
OS: Any
Status: New
Severity: Affects Many People
Priority: ---
Component: Individual Port(s)
Assignee: dvl@FreeBSD.org
Reporter: ohartmann@walstatt.org
Flags: maintainer-feedback?(dvl@FreeBSD.org)
Assignee: dvl@FreeBSD.org
Host is 14.0-RELEASE-p3.
Installed:
icinga2-2.14.0_2 net-mgmt/icinga2
icingadb-1.1.1_6 net-mgmt/icingadb
Backend ist PostgreSQL 15 Server on another db-host, carrying a database named
"icingadb" and accessible by the host in question. Application of the
icingadb-schema provided via
/usr/local/share/examples/icingadb/schema/pgsql/schema.sql (psql -f ...)
results in some errors, like:
ERROR: relation "history" does not exist
ERROR: relation "idx_history_event_time" does not exist
ERROR: relation "idx_history_host_service_id" does not exist
When starting
service icingadb start
service starts and stops immediately with dropping an error:
icingadb[65506]: 2024-01-12T10:43:16.972Z FATAL icingadb pq:
relation "history" does not exist
can't perform "INSERT INTO \"history\" (\"environment_id\", \"host_id\",
\"state_history_id\", \"endpoint_id\", \"object_type\", \"service_id\",
\"event_type\", \"id\", \"event_time\") VALUES
(:environment_id,:host_id,:state_history_id,:endpoint_id,:object_type,:service_id,:event_type,:id,:event_time)
ON CONFLICT ON CONSTRAINT pk_history DO UPDATE SET \"id\" = EXCLUDED.\"id\""
I'm out of ideas here. The problem occurs even on a fresh installation were no
IDO is supposed to be installed.
Something is broken.
--
You are receiving this mail because:
You are the assignee for the bug.