box / box/Anemometer

All graph points show timestamp of 12/31/1899

Open
#109 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
1.4k
Forks
306
PR merge metrics
No merged PRs in 30d

Description

For any graph display all points plot in a vertical bar in the center of the graph. Y values are correct but all X values (time) plot as 1:00:00 and the mouseover shows 12/31/1899. The computed values used for the time value seem OK, appearing at the expected 5 minute collection intervals, here are a few:

select unix_timestamp(substring(ts_min,1,16)) from global_query_review_history where ts_min > "2014-05-01 16:50:30"

1398984900.000000
1398984960.000000
1398984960.000000
1398985200.000000
1398985200.000000

Timezone is set in /etc/php.ini:
date.timezone =('America/Denver')

I did apply the suggested modification to the table and the collection script to speed up report generation, but that didn't have any effect on these values.

Sorry, I posted the wrong graph_defaults, should be:

$conf['graph_defaults'] = array(
'fact-group' => 'minute_ts',
'fact-order' => 'minute_ts',
'fact-limit' => '',
'dimension-ts_min_start' => date("Y-m-d H:i:s", strtotime( '-7 day')),
'dimension-ts_min_end' => date("Y-m-d H:i:s"),
'table_fields' => array('minute_ts'),
// hack ... fix is to make query builder select the group and order fields,
// then table fields only has to contain the plot_field
'plot_field' => 'Query_time_sum',
);
Latest code, Centos 6.4, PHP 5.3.3

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.