[gdal-dev] GDALPolygonize fails with "failed to execute insert : disk I/O error"

[Rahkonen Jukka]

Hi,

SQLite is known to have problems with network disks (NFS) but that is not your case. But maybe WSL can have same kind of problems, at least there has been some https://github.com/microsoft/WSL/issues/2395.

I would try to run the program on true Linux or true Windows and see if the issue happens to go away.

-Jukka Rahkonen-

Lähettäjä: Shayan Ghofrany <shayanghofrany at gmail.com>
Lähetetty: tiistai 17. lokakuuta 2023 19.57
Vastaanottaja: Rahkonen Jukka <jukka.rahkonen at maanmittauslaitos.fi>
Aihe: Re: [gdal-dev] GDALPolygonize fails with "failed to execute insert : disk I/O error"

Thanks for the response,

I've had this issue also with Shapefiles, but haven't tested the other formats you mentioned. I am not sure what you mean by what kind of file system I'm using, my program is being run on Windows Subsystem for Linux. I'm not familiar with journal mode or pragma synchronous, so it's most likely the default option.

Shayan G.

On Tue, Oct 17, 2023 at 12:45 PM Rahkonen Jukka <jukka.rahkonen at maanmittauslaitos.fi<mailto:jukka.rahkonen at maanmittauslaitos.fi>> wrote:
Hi,

I believe that the i/o error is something that comes from SQLite. Does error happen if you save into other formats like shapefile flatgeobuf, or parquet? In what kind of file system the new geopackage is? What journal mode do you use? Is “pragma synchronous” on or off?

-Jukka Rahkonen-

Lähettäjä: gdal-dev <gdal-dev-bounces at lists.osgeo.org<mailto:gdal-dev-bounces at lists.osgeo.org>> Puolesta Shayan Ghofrany via gdal-dev
Lähetetty: tiistai 17. lokakuuta 2023 18.52
Vastaanottaja: gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
Aihe: [gdal-dev] GDALPolygonize fails with "failed to execute insert : disk I/O error"

I'm attempting to polygonize a GeoTIFF using the built-in GDALPolygonize, but sometimes it fails to write to file. I'm not attempting any sort of multi-threaded functionality so everything is running synchronously. Here is the code I'm using to polygonize: https://gist.github.com/Irantwomiles/c5f38b3e81fc3014be4e859048ad523f
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20231017/955eaef5/attachment-0001.htm>