Opened 6 years ago
Closed 5 years ago
#7214 closed enhancement (wontfix)
add a hint to geopackage documentation about trouble with NFS / Samba Shares
Reported by: | rnuske | Owned by: | warmerdam |
---|---|---|---|
Priority: | normal | Milestone: | closed_because_of_github_migration |
Component: | default | Version: | unspecified |
Severity: | normal | Keywords: | |
Cc: |
Description
Would it be possible to add the known SQLite Limitations to the description of the GPKG Driver documentation or link to SQLite more prominently?
This question is based on the assumption, that the Geopackage driver uses the SQLite Driver internally and such shares its limitations.
I tried to write a Geopackage on a samba share via the st_write function of the R package sf and failed. Same with ogr2ogr, eg. ogr2ogr -f GPKG dat1.gpkg dat1.shp
Lorenzo Busetto hinted (https://github.com/r-spatial/sf/issues/628), that I was probably bitten by the fact, that SQLite has problems writing on networked file systems (in my case: a samba share mounted on a linux system). Roger Bivand pointed out that there is a note on the SQLite Driver Documentation, which I missed looking only at the Geopackage Documentation.
Could the sentence SQLite databases often due not work well over NFS, or some other networked file system protocols due to the poor support for locking. It is safest to operate only on SQLite files on a physical disk of the local system.
from http://gdal.org/drv_sqlite.html be copied to the Limitations section of http://www.gdal.org/drv_geopackage.html?
Thanks
Robert
Change History (5)
comment:1 by , 6 years ago
comment:2 by , 6 years ago
Could someone help me start a new page in the wiki? I tried to start a wiki page https://trac.osgeo.org/gdal/wiki/UserDocs#FileFormats and failed. Maybe I lack appropriate permissions?
comment:4 by , 6 years ago
Thanks @Even Rouault for write permissions.
I started a wiki page based on the above hints by @Jukka Rahkonen.
Some parts are still very sketchy (especially the point about R-Tree indexes and spatial views). Please help.
comment:5 by , 5 years ago
Milestone: | → closed_because_of_github_migration |
---|---|
Resolution: | → wontfix |
Status: | new → closed |
This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to https://github.com/OSGeo/gdal/issues if it is not already reported there.
I think that there is too much good-to-know-about-SQLite stuff to include into the driver page. A wiki page in the users area could be a better place and some first topics could be
Feel free to start the wiki page at https://trac.osgeo.org/gdal/wiki. If you could create this ticket you should have rights to the wiki as well. We can then mention the wiki page in the manual pages of the SQLite based drivers.