From nobody Thu Aug 18 08:29:15 2022 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 4M7dMv65C9z4YqMG for ; Thu, 18 Aug 2022 08:29:15 +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 4M7dMv543Yz3Kwg for ; Thu, 18 Aug 2022 08:29:15 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) 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 4M7dMv3x20z1M8h for ; Thu, 18 Aug 2022 08:29:15 +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 27I8TFHq007376 for ; Thu, 18 Aug 2022 08:29:15 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 27I8TFJJ007375 for ports-bugs@FreeBSD.org; Thu, 18 Aug 2022 08:29:15 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 265924] net-mgmt/netbox: FAILURE: DETAIL: PostgreSQL does not support leap seconds. Date: Thu, 18 Aug 2022 08:29:15 +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: kai@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 ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1660811355; 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=IGDjV02QbSpZMEsaNP49VmFdzmTduOcv4apDz0kJ3IA=; b=XBtOaohdY47pt+GAzBj4Y8J1oN6MPUdxsJx/NxUN8ZxkuX2doqSQXZ7hAntPcR/sSKxgTt l8a+faV4tw1yUhsGv0HWn8qEVN42hXAZ9wp1LVLSj4Hks9JP+Fw6PerNfgLjDthV2s7f85 oJLDDkGt/inQrkgAkb+teg4Nh0ARHRes5GtCSHLl8hdTvjnuy3G/iUY0D+4KWleemd+LfC Mwnm6hm1vZ4gLYbwOnJzHradoeeWrFR2X627WO2Aq14HxO8CsCfzesSzl4WFLOLMuOH53B XjDTyV2rkBD3n8Lj24QItuldvSqM3oUJYeFdNEd+A8+FHfm1bV/6wZB/uE2Aew== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1660811355; a=rsa-sha256; cv=none; b=XgnmNZOca5XrjrdZWSRQUjostaz4MgreXlYAXVWnNAYXBvKwv2hoksEyS4qH0st2ulfQDv XLsMeRk28r4KhHgw1YyPxGmPcjvNhBXoaObHrVHfHPs/3IdcG5mYvx3kkvDGyTO17j/jot ojwVERZNhysXkfrWofwa2CN68PKc5ePSajQWlK3nLLh9dSQasyFo5HcW1KUhsnZVLCtcu9 0yZJAARfZjA4eO727FB7X681EJjkSxN+cFQXZpb/hrvuhSlSOK4ds5lZDlpW3zdSlqIXy1 YYTU/2wyNrtOyUGyQdnF0RnCof/5t69oLDjSuaMn21T8N6RoYg1swZfx3evBxw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D265924 Bug ID: 265924 Summary: net-mgmt/netbox: FAILURE: DETAIL: PostgreSQL does not support leap seconds. Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Many People Priority: --- Component: Individual Port(s) Assignee: kai@FreeBSD.org Reporter: ohartmann@walstatt.org Flags: maintainer-feedback?(kai@FreeBSD.org) Assignee: kai@FreeBSD.org Upgrading a 13.1-RELENG-p1 jail from python3.8 - > python3.9 as recommended= in UPDATING via pkg and updating net-mgmt/netbox from 3.1.11 to 3.2.8 (most re= cent version as of today) in this vain results in a dysfunctional netbox installation and in non-working migration procedure, as recommended at the = end of the install/upgrade process of net-mgmt/netbox.=20 Issuing the first step: python3.9 manage.py migrate results in: Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", l= ine 244, in ensure_connection self.connect() File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", li= ne 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", l= ine 227, in connect self.init_connection_state() File "/usr/local/lib/python3.9/site-packages/django/db/backends/postgresql/base.= py", line 241, in init_connection_state timezone_changed =3D self.ensure_timezone() File "/usr/local/lib/python3.9/site-packages/django/db/backends/postgresql/base.= py", line 234, in ensure_timezone cursor.execute(self.ops.set_time_zone_sql(), [timezone_name]) psycopg2.errors.InvalidParameterValue: time zone "UTC" appears to use leap seconds DETAIL: PostgreSQL does not support leap seconds. [...] and more follow and it is always the same error report regarding PostgreSQL= is not supporting leap second (using databases/postgresql13-{server|client} as from latest official repo). I tried to search the net to figure out what is wrong here, I also can't fi= nd ad hoc a solution/workaround. --=20 You are receiving this mail because: You are the assignee for the bug.=