413482 - stats not updated - charts show constant bug counts

Status: RESOLVED WORKSFORME

(Bugzilla :: Reporting/Charting, defect)

Description

[Martin West]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11
Build Identifier: 3.0.0

I enabled charting: ran collectstats and then setup the cron job to run collectstats at 1:15 am. A chart showed only one day, so I ran collectstats-regenerate and then old chart showed a time series. I subsequently noticed that the stats had not been updated, well at least from the data the chart displayed. A new chart only showed one day, the day setup the collectstats. Not sure why this is because I can see from the log it ran each day. So I ran collectstats again manually. A new chart then had two days the day I install and now. I then ran collectstats 2008-01-01, collectstats 2008-01-02 ... to the present day, Now all the new charts have flat lined. 

Confused, the new chart function may be more powerful but the usability leaves a lot to be desired. Some decent documentation might help.

Reproducible: Always

Steps to Reproduce:
1.See detail
2.
3.
Actual Results:  
See detail

Expected Results:  
See detail

Comment 1

[Martin West]

Attachment: flatlined graph

Comment 2

[Martin West]

Attachment: oldchart view

Comment 3

[Martin West]

Attachment: More informative view

Comment 4

[Frédéric Buclin]

I see you are running Bugzilla 3.0. Are you using PostgreSQL as your DB server? Note that you maybe run collectstats.pl with the wrong permissions so that the stat files cannot be updated.

Comment 5

[Martin West]

No, using mysql

collectstats runs as root. 

Forgot mention this is a solaris box, runing SunOS 5.10

Thanks

Comment 6

[Martin West]

PS the log file from collectstats.pl 2>&1 > logfile is empty.

Comment 7

[Martin West]

Question: Do I have to have already defined some chart data sets before running collectstats for the new chart function?

Comment 8

[Frédéric Buclin]

(In reply to comment #7)
> Question: Do I have to have already defined some chart data sets before running
> collectstats for the new chart function?

yes

Comment 9

[Frédéric Buclin]

Is this still a problem with Bugzilla 3.6?

Comment 10

[Frédéric Buclin]

Bugzilla 3.0 is no longer supported, and I cannot reproduce the issue.