9.704: Daily Report Broken?

Question

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 · Accepted Answer

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&uuml;ck! 
 Cheers - Bob

Alexander Busch · Answer

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

9.704: Daily Report Broken?

Top Replies