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

2023-10-17 Thread Rahkonen Jukka via gdal-dev
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 
Lähetetty: tiistai 17. lokakuuta 2023 19.57
Vastaanottaja: Rahkonen Jukka 
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 
mailto:jukka.rahko...@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 
mailto:gdal-dev-boun...@lists.osgeo.org>> 
Puolesta Shayan Ghofrany via gdal-dev
Lähetetty: tiistai 17. lokakuuta 2023 18.52
Vastaanottaja: gdal-dev@lists.osgeo.org<mailto:gdal-dev@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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev


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

2023-10-17 Thread Rahkonen Jukka via gdal-dev
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  Puolesta Shayan Ghofrany 
via gdal-dev
Lähetetty: tiistai 17. lokakuuta 2023 18.52
Vastaanottaja: gdal-dev@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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev