Thanks for your suggestion, Jukka! I tried all the advice from stackoverflow. I can do ".recover", but get only the features that have been visible all along. In the original .gpkg, I cannot DROP the affected RTree-Index. It gives me the same disk malformed error. But that would also have been my initial idea...
On Mon, Feb 14, 2022 at 9:26 AM Rahkonen Jukka (MML) < [email protected]> wrote: > 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 <[email protected]> *Puolesta *Isabel > Kiefer > *Lähetetty:* maanantai 14. helmikuuta 2022 10.17 > *Vastaanottaja:* [email protected] > *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 > > > > [email protected] > > >
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
