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

dashboard statistics not updating

Since a while i see that the statistics on the dashboard is stopped working.
How can this happen / where can i look to get the cause of this issue ?

regards

This thread was automatically locked due to age.

Parents

0 BAlfson over 13 years ago
Since you've already reloaded from ISO, and could do that again, just for chuckles try the following as root:
# psql -Ureporting -c"reindex database reporting;" reporting
# psql -Ureporting -c"vacuum;" reporting

If that doesn't work, then let's see if rebuilding the database solves the problem:
/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres[:P]ostgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v

I didn't invent those commands, and I haven't run them myself, but others have reported success. Did either of those help?

Cheers - Bob
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 BAlfson over 13 years ago
Since you've already reloaded from ISO, and could do that again, just for chuckles try the following as root:
# psql -Ureporting -c"reindex database reporting;" reporting
# psql -Ureporting -c"vacuum;" reporting

If that doesn't work, then let's see if rebuilding the database solves the problem:
/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres[:P]ostgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v

I didn't invent those commands, and I haven't run them myself, but others have reported success. Did either of those help?

Cheers - Bob
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data