LVSstats Error in LFD

[host97]

i get the following email from lfd

/var/log/messages:
Aug 26 09:00:10 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:00:26 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:00:41 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:00:56 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:01:11 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:01:26 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:01:41 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:01:56 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:02:11 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:02:26 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:02:41 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:02:56 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26 09:03:11 myserver lvestats-server&#91;1605&#93;: <class sqlite3.OperationalError>: no such table: last_run Aug 26

I dont think it completed installation correctly.

any advice please.

[bogdan.sh]

Looks like lvestats database is inconsistent and missing some fields. Please try to recreate it with:

/etc/init.d/lvestats stop

mv /var/lve/lveinfo.db /var/lve/lveinfo.db_bad

/etc/init.d/lvestats start

[sqh]

Bogdan, thanks for this answer. I had this same problem on a new installation today, and your instructions fixed the problem.

- Scott

[dave518]

Same here. Brand new server. First CL server (migrating away from RHEL) and have had a lot of little "bumps" in the road so far that CL tech support has been assisting with, and while looking for the source of other problems this morning (such as not being able to change inodes High number without also completely changing inodes Low number on packages) I discovered thousands of lines of "lvestats-server&#91;712756&#93;: <class sqlite3.OperationalError>: no such table: history" in the logs. Going to try Bogdans solution now.

[bogdan.sh]

Really not sure how happened that necessary table was not there. How was installation going? Any errors?