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 Jukka Rahkonen, 6 years ago

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.

comment:2 by rnuske, 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?

Last edited 6 years ago by rnuske (previous) (diff)

comment:3 by Even Rouault, 6 years ago

@rnuske I've granted you WIKI_CREATE permissions

comment:4 by rnuske, 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 Even Rouault, 5 years ago

Milestone: closed_because_of_github_migration
Resolution: wontfix
Status: newclosed

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.

Note: See TracTickets for help on using tickets.