<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Regina,</p>
<p>This was over-optimistic. <br>
</p>
<p>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.<br>
</p>
<p>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:<br>
</p>
<pre style="margin: 0px; padding: 0px 0px 0.25rem; font-family: monospace, monospace; font-weight: 400; color: rgb(51, 51, 51); background-color: rgb(255, 255, 255); white-space: pre-wrap; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">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)"
</pre>
<p>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?</p>
<p>Marco<br>
</p>
<div class="moz-cite-prefix">Op 9-2-2022 om 12:57 schreef Marco
Boeringa:<br>
</div>
<blockquote type="cite"
cite="mid:8ba05286-79ae-3370-f78c-1093520860aa@boeringa.demon.nl">Hi
Regina,
<br>
<br>
After restoring my VM a second time, I dug a little deeper into
the problem, and I now think I understand what went wrong:
<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
Marco
<br>
<br>
Op 8-2-2022 om 19:23 schreef Regina Obe:
<br>
<blockquote type="cite">You have the create table statement we can
test with?
<br>
<br>
<blockquote type="cite">-----Original Message-----
<br>
From: postgis-users
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] On
<br>
Behalf Of Marco Boeringa
<br>
Sent: Monday, February 7, 2022 2:34 PM
<br>
To: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<br>
Subject: Re: [postgis-users] "value out of range: underflow"
blocking
<br>
</blockquote>
error
<br>
<blockquote type="cite">One additional remark: in my case, there
is no involvement of a GiST index
<br>
</blockquote>
as
<br>
<blockquote type="cite">per the PostgresPro link. It fails in a
"CREATE TABLE" type statement that
<br>
</blockquote>
also
<br>
<blockquote type="cite">includes some calculations, so there
isn't any indexes yet at that stage.
<br>
<br>
Op 7-2-2022 om 08:17 schreef Marco Boeringa:
<br>
<blockquote type="cite">Hi,
<br>
<br>
Anyone else seeing this issue pop up, possibly after a
recent update
<br>
to a PostgreSQL related component, or something that
PostgreSQL /
<br>
PostGIS is dependent on?
<br>
<br>
I am still not sure if it is caused by something in my own
coding, and
<br>
I first though this might be related to an attempt to
upgrade to
<br>
PostgreSQL 14, but after restoring my machine to PostgreSQL
13(.5), I
<br>
still see this error blocking the successful execution of a
crucial
<br>
query in my toolchain, that used to run fine up until
recently.
<br>
<br>
I noticed there has been some very recent discussion about
this same
<br>
type of error on a PostgreSQL mailing list:
<br>
<br>
<a class="moz-txt-link-freetext" href="https://postgrespro.ru/list/thread-id/2580248">https://postgrespro.ru/list/thread-id/2580248</a>
<br>
<br>
Marco
<br>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<br>
</blockquote>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<br>
</blockquote>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<br>
</blockquote>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<br>
</blockquote>
</body>
</html>