Thread Info
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 8 replies
  • Subscribers 5 subscribers
  • Views 1960 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

9.704: Daily Report Broken?

Alexander Busch

Anyone got problems after update 9.704 like me?
A part of our daily report seems broken, the network usage information is empty:

Tried already failover to the other node, but no change.

And yes, I opened already a ticket [#9974812] 03081025 some days ago. But got zero information related to the problem, just a zoom invitation. Of course it's support from india [^o)]

Best regards

Alex

/* 9/9/20 edit ticket number */



This thread was automatically locked due to age.
Parents
  • +1

    I bet you might have to rebuild the database, Alex.  First, try to re-create the index (haven't tried these commands in years!):

    psql -Ureporting -c"reindex database reporting;" reporting

    You might also need to:

    psql -Ureporting -c"vacuum;" reporting

    If all that doesn't work, you might have to re-initialize all PostgreSQL databases (deletes all graphs and data, but does not affect the logs)

    /etc/init.d/postgresql92 rebuild

    Let us know if Support has a better solution than a rebuild.

    Viel Glück!

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • 0 in reply to BAlfson

    BAlfson said:

    I bet you might have to rebuild the database, Alex.  First, try to re-create the index (haven't tried these commands in years!):

    psql -Ureporting -c"reindex database reporting;" reporting

    You might also need to:

    psql -Ureporting -c"vacuum;" reporting

    If all that doesn't work, you might have to re-initialize all PostgreSQL databases (deletes all graphs and data, but does not affect the logs)

    /etc/init.d/postgresql92 rebuild

    Let us know if Support has a better solution than a rebuild.

    Viel Glück!

    Cheers - Bob

     

    Hi Bob,

    thank you. The commands give an error of missing attributes:

    I'll see if support now comes with a better solution and update here.

    BR

    Alex

    -

  • 0 in reply to Alexander Busch

    Hallo Alex,

    I think "missing attributes" represents options not configured.  Did you try the vacuum command?

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • 0 in reply to BAlfson

    Hey Bob,

    unfortunately there seems a problem with the user:

    without the user, it doesn't work either:

    BR

    -

  • 0 in reply to Alexander Busch

    It looks like that command has been changed, Alex.  Wonder what Support will suggest for your problem...

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply Children
Unfiltered HTML