Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 18 Aug 2022 08:29:15 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 265924] net-mgmt/netbox: FAILURE: DETAIL:  PostgreSQL does not support leap seconds.
Message-ID:  <bug-265924-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
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.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-265924-7788>