Database malformed

Posted by Pierre on
URL: http://official-rtab-map-forum.206.s1.nabble.com/Database-malformed-tp10500.html

Hi !

I'm sorry if this problem has already been answered somewhere, but I couldn't find a solution to my specific issue. I have been scanning with an iPhone and the iPhone turned off during the scan because of low battery. The temp db file is about 5gb and it would be a real shame to lose it (extreme scanning conditions let's say).

I have tried:

- rtabmap-recovery:

[FATAL] (2024-10-06 13:03:33.633) DBDriverSqlite3.cpp:521::executeNoResultQuery() Condition (rc == SQLITE_OK) not met! [DB error: database disk image is malformed, the query is PRAGMA cache_size = 10000;]
terminate called after throwing an instance of 'UException'
  what():  [FATAL] (2024-10-06 13:03:33.633) DBDriverSqlite3.cpp:521::executeNoResultQuery() Condition (rc == SQLITE_OK) not met! [DB error: database disk image is malformed, the query is PRAGMA cache_size = 10000;]

Signal 6 caught...
Abandon (core dumped)

- sqlite3 .recover : produces a .sql file, then trying to extract a .db gives

...
Parse error near line 33252: file is not a database (26)
Parse error near line 33253: file is not a database (26)
Parse error near line 33254: file is not a database (26)
Parse error near line 33255: file is not a database (26)
Parse error near line 33256: file is not a database (26)
...

Somehow the file is big so I know everything is in there. Would be amazing if you can help with that ! :)

Thanks
Pierre