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

Top Replies

  • +1 verified

    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

    Jump to answer
Parents
  • 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,

Reply
  • 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,

Children