<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Leo,</p>
<p>could you provide your GeoPackage file and the layer you're
converting ? (privately possibly)</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 02/01/2024 à 15:09, Leo Fuhrmann via
gdal-dev a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:A0357B4D-4DFB-4070-86F4-EB7975C4140F@icloud.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Hi,
<div><br>
</div>
<div>I’m using ogr2ogr 3.8.2 to import a (layer of a) GeoPackage
into a PostGIS database:</div>
<div><br>
</div>
<div>```</div>
<div>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">ogr2ogr
--debug ON -f PostgreSQL </span><span
style="font-variant-ligatures: no-common-ligatures; color: #9fa01c">"PG:dbname=XX
host=XX port=XX user=XX password=XX”</span><span
style="font-variant-ligatures: no-common-ligatures"> <path/to/gpkg.gpkg>
<layer></span></p>
</div>
<div>```</div>
<div><br>
</div>
<div>However, I’m seeing an error in the logs that I cannot sort
out (see mail subject and/or logs below). Despite the error, the
data gets written to the database, yet I’m worried that
something is messed up along the way.</div>
<div><br>
</div>
<div>Using the official docker image to execute the command (from
a MacBook with M1 Pro) works without an error. Then again, using
a cloud service (IBM Code Engine in this case) with the official
image also throws the error. I tried with different image
versions but found no difference.</div>
<div><br>
</div>
<div>I tried to track down the error and found <a
href="https://github.com/OSGeo/gdal/blob/1df855eb676e17278c337e9b14774d1bb298df90/ogr/ogrsf_frmts/gpkg/ogrgeopackagetablelayer.cpp#L8352"
moz-do-not-send="true" class="moz-txt-link-freetext">https://github.com/OSGeo/gdal/blob/1df855eb676e17278c337e9b14774d1bb298df90/ogr/ogrsf_frmts/gpkg/ogrgeopackagetablelayer.cpp#L8352</a></div>
<div><br>
</div>
<div>The comment suggests that I might have messed with
GetNextFeature(), but I’m sure I haven’t.</div>
<div><br>
</div>
<div>Can someone help me to make sense of this error? I’m sorry to
say that I can’t share the GeoPackage at the moment.</div>
<div><br>
</div>
<div>Thanks, Leo</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Here are the logs:</div>
<div><br>
</div>
<div>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GPKG:
GeoPackage v1.2.0</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GDAL:
GDALOpen(<path/to/gpkg.gpkg>, this=0x14c053e00)
succeeds as GPKG.</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GDAL:
GDALDriver::Create(PostgreSQL,PG:dbname=XX host=XX port=XX
user=XX password=XX</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
Client encoding: 'UTF8'</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
PostGIS schema: 'public'</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
PostgreSQL version string : 'PostgreSQL 16.1 (Debian
16.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc
(Debian 10.2.1-6) 10.2.1 20210110, 64-bit'</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
PostGIS version string : '3.4 USE_GEOS=1 USE_PROJ=1
USE_STATS=1'</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
Could not retrieve table oid for <layer></span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GDALVectorTranslate:
Using FID=fid and -preserve_fid</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
Could not retrieve table oid for </span><layer></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">OGR2OGR:
Using WriteArrowBatch()</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GPKG:
GeoPackage v1.2.0</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GPKG:
GeoPackage v1.2.0</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GPKG:
GeoPackage v1.2.0</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">ERROR 1:
Worker thread task has not expected m_iStartShapeId value</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">PG:
PQputCopyEnd()</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GDAL:
GDALClose(<path/to/gpkg.gpkg>, this=0x14c053e00)</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GDAL:
GDALClose(PG:dbname=XX host=XX port=XX user=XX password=XX
this=0x14b721fb0)</span></p>
<p
style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: "MesloLGS NF"; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-variant-emoji: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span
style="font-variant-ligatures: no-common-ligatures">GDAL: In
GDALDestroy - unloading GDAL shared library.</span></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>