Hi,
Without being able to see your database it is hard to give more advice that
https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642
gives. Did you try all of them? Because the problem has something to do with
the spatial index I would have a try be dropping it and repeating the suggested
tricks.
-Jukka Rahkonen-
Lähettäjä: gdal-dev <gdal-dev-boun...@lists.osgeo.org> Puolesta Isabel Kiefer
Lähetetty: maanantai 14. helmikuuta 2022 10.17
Vastaanottaja: gdal-dev@lists.osgeo.org
Aihe: [gdal-dev] Corrupted geopackage
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
but without success.
Thanks in advance for your help!
Isabel
--
Isabel Kiefer
OPENGIS.ch
isa...@opengis.ch<mailto:isa...@opengis.ch>
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
