Re: Trim/truncate frames in a database

Posted by matlabbe on
URL: http://official-rtab-map-forum.206.s1.nabble.com/Trim-truncate-frames-in-a-database-tp3967p3968.html

Got

 
"[ WARN] (2017-12-11 15:36:58.971) Memory.cpp:316::loadDataFromDb() _vwd->getUnusedWordsSize() must be empty... size=8286"

for unreferenced words in the vocabulary. I edited the answer above with the following:

$ sqlite3 map.db "delete from Word where id in (select id from Word left join Feature on id=word_id where node_id is null)"

then the warning disappeared when reloading the database for mapping.