SQL cache size error

Posted by senia on
URL: http://official-rtab-map-forum.206.s1.nabble.com/SQL-cache-size-error-tp1309.html

Hi,
I started to film longer videos using R200 (at 60FPS) using the rtabmap data_recorder in ROS.
When I got to an about 1.2GB of a database file(couple of minutes) and tried to open it, using database viewer or or by mapping from it, I got the following error:
[ INFO] (2016-05-17 19:05:23.287) DBDriverSqlite3.cpp:339::connectDatabaseQuery() Using database "./output1.db" from the hard drive.
[ INFO] (2016-05-17 19:05:23.288) DBDriverSqlite3.cpp:374::connectDatabaseQuery() Database version = 0.0.0
[FATAL] (2016-05-17 19:05:23.288) DBDriverSqlite3.cpp:432::executeNoResultQuery() Condition (rc == SQLITE_OK) not met! [DB error: file is encrypted or is not a database, the query is PRAGMA cache_size = 10000;]
terminate called after throwing an instance of 'UException'
  what():  [FATAL] (2016-05-17 19:05:23.288) DBDriverSqlite3.cpp:432::executeNoResultQuery() Condition (rc == SQLITE_OK) not met! [DB error: file is encrypted or is not a database, the query is PRAGMA cache_size = 10000;]
Updating the Preferences -> Database -> Sqlite3 cache size value nor adding the following in the launch file didn't work. ( without bigger than smaller than symbols)
      param name="DbSqlite3/CacheSize"        type="int" value="999999"/
Does the saved databases are corrupted?(they have info judging by their size)
How could I make sure it won't happen?
Thank you very much,
Senia.