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

    -

  • 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
  • Hey Bob,

    unfortunately there seems a problem with the user:

    without the user, it doesn't work either:

    BR

    -

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

     

    -

Reply Children
No Data