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

    Hi  

    Thank you for reaching out to the Community! 

    Please provide the output of the command "df -kh" from the CLI and a screenshot of the reporting settings. 

    The support case that you have provided was closed on 7th Jully and with different issues. If you already have an open case for this current issue, please provide the correct case number so that I can help follow up. 

    Thanks,

  • +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 FormerMember

    Hi H_Patel,

    output of df -kh provides:

     

    Sorry for the wrong case number, the correct one should be 03081025.

    Best regards,

    Alex

    -

  • 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
  • +1 in reply to BAlfson

    Support suggested finally to rebuild the database with 

    /etc/init.d/postgresql92 rebuild

    That worked. If there were other ways will be still the secret of support.

    BR

    Alex

     

    -

Unfiltered HTML