Date: Fri, 12 Jan 2024 10:53:29 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 276272] net-mgmt/icingadb: FATAL icingadb pq: relation "history" does not exist Message-ID: <bug-276272-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D276272 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 na= med "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,:serv= ice_id,:event_type,:id,:event_time) ON CONFLICT ON CONSTRAINT pk_history DO UPDATE SET \"id\" =3D EXCLUDED.\"id= \"" I'm out of ideas here. The problem occurs even on a fresh installation were= no IDO is supposed to be installed.=20 Something is broken. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-276272-7788>