nfsdcltrack: sqlite_query_reclaiming: unable to prepare select statement: no such column: has_session
Posted on February 22, 2016 • 1 minutes • 97 words • Suggest Changes
Buggers, again nfsdcltrack. This time its again a sqlite error :
nfsdcltrack : sqlite_query_reclaiming: unable to prepare select statement: no such column: has_session
Luckily, this time there is a workaround to remove the error. Thanks to Zenon Panoussis.
open up the database :
add the field to the table clients :
alter table clients add column has_session INTEGER;
note : I changed it from tinyint to integer, as sqlite doesn’t know the difference internally anyway. (everything is INTEGER)
Then just exit and restart the nfs service
.exit systemctl restart nfs
A happy nfsdcltrack service again!