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?

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

    -

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

    -

Children