Hi Regina,
This was over-optimistic.
I now again see the "value out of range: underflow" error. However, this
now happened after upgrade of PROJ 6.3.1 to 8.2.0. Note that last time,
I also did this upgrade, as it was a forced and automatic one suggested
by the Ubuntu "Software Updater". So in both cases after restoring my
VM, this update from PROJ 6.3.1 to 8.2.0 happened before the issue
started appearing. So it appears the issue is related to the PROJ
update, not the GEOS update as I initially suspected.
One interesting thing I noted, is that the postgis_full_version still
shows 'PROJ="6.3.1"', instead of 8.2.0, despite the Synaptic Package
Manager clearly showing only 8.2.0 is installed:
PostGIS version: POSTGIS="3.2.0 c3e3cc0" [EXTENSION] PGSQL="130" GEOS="3.10.1-CAPI-1.16.0" PROJ="6.3.1"
LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
Now I remember a similar issue with outdated version number for GEOS
from last year when I attempted to update GEOS from 3.6.0 to 3.8.0,
where Paul remarked something like that it meant that my PostGIS "wasn't
compiled with GEOS 3.8.0 support", so does this possibly also mean my
current PostGIS 3.2.0 installed from the official Ubuntu repository is
also not compiled with PROJ 8.2.0 support, and I should downgrade to 6.3.1?
Marco
Op 9-2-2022 om 12:57 schreef Marco Boeringa:
Hi Regina,
After restoring my VM a second time, I dug a little deeper into the
problem, and I now think I understand what went wrong:
I had initially attempted to upgrade my GEOS 3.8.0 that comes by
default in the Ubuntu 20.04 install to GEOS 3.10.1 from the
'ubuntugis-unstable' PPA.
To do this, after adding the PPA in Ubuntu, I checked the
'libgeos3.10.1' entry in the Synaptic Package Manager, and clicked
"Apply". This succeeded, but I did not uninstall 'libgeos3.8.0' in the
same process, so I had two 'libgeos' versions installed.
This seems to have caused the issue, as after I now uninstalled
'libgeos3.8.0', I noticed the Synaptic Package manager updated a
couple of dependent libraries to the 3.10.1 version:
'libgeos++dev','libgeos-c1v5','libgeos-dev'. So I guess the issue with
the underflow was caused by having the outdated 3.8.0 versions of
these libraries still installed.
Marco
Op 8-2-2022 om 19:23 schreef Regina Obe:
You have the create table statement we can test with?
-----Original Message-----
From: postgis-users [mailto:[email protected]] On
Behalf Of Marco Boeringa
Sent: Monday, February 7, 2022 2:34 PM
To: [email protected]
Subject: Re: [postgis-users] "value out of range: underflow" blocking
error
One additional remark: in my case, there is no involvement of a GiST
index
as
per the PostgresPro link. It fails in a "CREATE TABLE" type
statement that
also
includes some calculations, so there isn't any indexes yet at that
stage.
Op 7-2-2022 om 08:17 schreef Marco Boeringa:
Hi,
Anyone else seeing this issue pop up, possibly after a recent update
to a PostgreSQL related component, or something that PostgreSQL /
PostGIS is dependent on?
I am still not sure if it is caused by something in my own coding, and
I first though this might be related to an attempt to upgrade to
PostgreSQL 14, but after restoring my machine to PostgreSQL 13(.5), I
still see this error blocking the successful execution of a crucial
query in my toolchain, that used to run fine up until recently.
I noticed there has been some very recent discussion about this same
type of error on a PostgreSQL mailing list:
https://postgrespro.ru/list/thread-id/2580248
Marco
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
