From nobody Fri Jan 12 10:53:29 2024 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4TBJL13rn6z56b20 for ; Fri, 12 Jan 2024 10:53:29 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4TBJL12g0dz4lQM for ; Fri, 12 Jan 2024 10:53:29 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1705056809; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=rTYho1tPyVEsm5uB9HKHbXCuZEx5hHO6ZhyCpUlILmI=; b=d7VJ+1bmZlF7xMx76mgiIYjkMofJ8po87bK0xmf8YSTpaM7UC6FKvulg4AgnzwKmcFN9JR nbrhP0pfSF5ks9XZ0VGBg6lRN20WZVdcYq3sNeK9UPe3kP4SJirIbDeKE96BBpAR48rhDO njA5VWKK6Z0Vf7Jze4374Ex7cqKei/aglErA3S+Aw1i0LtUirTP/D6XqH1Z7VQ0Mat9HyD RorGp+Ai2tyw2pL6KLKNZmEYYBGMse2odda5BxClIQ1/rW3g+dCRHeYEqUxCKm5+iDIGO6 Axv21LwtblAVRuju8RCSLyemftBqdxQqDlbHqaQykT59h5tqRRctkUrs5kK/kA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1705056809; a=rsa-sha256; cv=none; b=Cu/PngZPU5DUTs/xWiXQaPg6/tv+gBjdcKw1Sn6HSZu1aS3liltRq80G2DRsPv0rPiEMA3 4CS8Z4HEiNhmqRPaO1Rii8JLY3FRYfc6/btBAxwN8U5L7j6MkwN9Ef3UggRgK5FszNusIT CAu2iOZGHUcHEpOGWL4Glba03YVxQ7XQzSYHytO6WGccUWyoK0uHceF4b13+sdKtYHjq1k 2yJ8ifaT2ihBCMYdniXrArHgH/C1cqZmH8V6Oxh7fpkaMowrjPp5pFvkiGtsGmvzEK3Y2H uGgG8ClPZ6Jod5v4nF3TB4FLfW91403DqCe2uSrHdi8cwT3UP1NZP6Dhp9UeGQ== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4TBJL11lLKz1057 for ; Fri, 12 Jan 2024 10:53:29 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 40CArTNN081354 for ; Fri, 12 Jan 2024 10:53:29 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 40CArTMt081351 for ports-bugs@FreeBSD.org; Fri, 12 Jan 2024 10:53:29 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 276272] net-mgmt/icingadb: FATAL icingadb pq: relation "history" does not exist Date: Fri, 12 Jan 2024 10:53:29 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: ohartmann@walstatt.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: dvl@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 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.=