Site/System Statistics broken

Summary

The various Totals at the top of the Site and Team Statistics pages don’t populate.

Steps to reproduce

In Mattermost client for Mac 4.2.1, go to System Console, then click Team Statistics or Site Statistics.

Expected behavior

The information is displayed.

Observed behavior

The big graphs load and render, but the various totals say “Loading…” forever.

I see this in the logs:

{“level”:“error”,“ts”:1562590894.5129335,“caller”:“mlog/log.go:172”,“msg”:“Unable to get post counts”,“path”:"/api/v4/analytics/old",“request_id”:“tddzshsbe3rc9xkighi5xcfeiy”,“ip_addr”:“207.107.155.44”,“user_id”:“86wyy4d69tyfmjupze3orobmrc”,“method”:“GET”,“err_where”:“SqlPostStore.AnalyticsPostCount”,“http_code”:500,“err_details”:“pq: canceling statement due to user request”}

Hi @Taffer, this troubleshooting guide might help: https://docs.mattermost.com/administration/statistics.html#troubleshooting.

No luck, I see the same results via Firefox (67.0.4, with uBlock Origin and HTTPS Everywhere) and the Mattermost app (4.2.1 on Mac).

The log message is similar to the one I see in my Search issue.