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 */
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
-
Hey Bob,
unfortunately there seems a problem with the user:
without the user, it doesn't work either:
BR
-
