[gdal-dev] Corrupted geopackage

[Jonathan Moules]

Hi Isabel,

If you don't get an answer here, you may want to try the SQLite forum: 
https://sqlite.org/forum/forum - If anyone knows, it'll be someone there.

Maybe also of interest: https://sqlite.org/howtocorrupt.html#cfgerr

Cheers,

Jonathan

On 2022-02-14 08:17, Isabel Kiefer wrote:
> Hi everyone,
>
> I've a problem with a corrupted geopackage.
> It should contain a table with 694 entries, but only 78 are visible 
> when opening the file with DB Browser for SQLite or QGIS. The table 
> gpkg_ogr_contents says 694 though. When opening the .gpkg with a 
> Notepad or similar, I can see that there are more than 78 entries.
>
> The error message in DB Browser is "database disk image is malformed 
> in "PRAGMA "main".TABLE_INFO("rtree_XXX");" So it seems that there is 
> a problem with the index of the concerned table.
>
> Does anyone know how to fix this? I tried 
> https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642 
> <https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642> but 
> without success.
>
> Thanks in advance for your help!
> Isabel
>
> -- 
> Isabel Kiefer
> OPENGIS.ch
>
> isabel at opengis.ch
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220216/0f61d3d7/attachment.html>