Guest User!

You are not Sophos Staff.

Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 2 subscribers
  • Views 1583 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

'Today's threat status' all zero

BAlfson
I just noticed that these stats are all zero.  Is there a way to fix that short of reloading[:(]?

Thanks - Bob


This thread was automatically locked due to age.
Parents
  • 0
    Does the system log show any signs of a database problem?  We may need to rebuild the reporting DB for you.

    Jack
  • 0 in reply to Jack Daniel
    Indeed
    21-21:18:06 (none) ulogd[2557]: pg1: ERROR: index "accounting_pkey" contains unexpected zero page at block 0 HINT: Please REINDEX it.

    Whoa! The system logfile was 8.7KB on the 13th and 519kb on the 16th.
  • 0 in reply to BAlfson
    Hi,
    which version are you running?

    What needs to be done depends on the kind of error you're running into. If the above error is the only problem it is easy to fix, you just need to rebuild the index as stated in the hint. As root, do the following:
    # psql -U reporting -c "REINDEX DATABASE reporting"

    Cheers,
     andreas
Reply
  • 0 in reply to BAlfson
    Hi,
    which version are you running?

    What needs to be done depends on the kind of error you're running into. If the above error is the only problem it is easy to fix, you just need to rebuild the index as stated in the hint. As root, do the following:
    # psql -U reporting -c "REINDEX DATABASE reporting"

    Cheers,
     andreas
Children