Announcement

Collapse
No announcement yet.

LVSstats Error in LFD

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • LVSstats Error in LFD

    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.

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

    Code:
    /etc/init.d/lvestats stop
    
    mv /var/lve/lveinfo.db /var/lve/lveinfo.db_bad
    
    /etc/init.d/lvestats start

    Comment


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

      - Scott

      Comment


      • #4
        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.

        Comment


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

          Comment

          Working...
          X