Comment 1 for bug 148687

The SQLite database is used by the "Statistics Plugin"; you can turn it on and off by going to Settings -> Configure Plugins...

From what I can tell the Statistics plugin records when contacts were last seen online (and perhaps other similar things I haven't noticed yet).

According to the SQLite FAQ, SQLite doesn't work well over NFS. (http://www.sqlite.org/faq.html)
"SQLite uses reader/writer locks to control access to the database. <snip> But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is broken on many NFS implementations. You should *avoid putting SQLite database files on NFS* if multiple processes might try to access the file at the same time." (emphasis added)

As far as I can tell, the messages don't cause problems if you have one Kopete running at any given time, although if you launch kopete from a Terminal (emulator, or xterm, or uxterm or konsole or whatever you call it) it can be kind of annoying.