[BUG] Overview page Requests/sec incorrect.

[azilber]

I'm seeing '85070586659632214952926045871129231360,000' Requests/sec for every entry (3 sites).

This is a dev server with maybe 5 requests/sec.....

[azilber]

Seeing more of the same for newly accessed hosts:

[azilber]

The graph looks messed up as well:

[azilber]

I'm still seeing the issue, any ideas?

[azilber]

It looks like the generated data is wrong... looks like maybe an issue with the cron generator:
MariaDB [pinba]> SELECT created_at, avg(req_per_sec) as req_per_sec FROM ipm_report_by_hostname_and_server limit 10;
+---------------------+-----------------------+
| created_at | req_per_sec |
+---------------------+-----------------------+
| 2014-08-11 01:28:40 | 1.6774481876547198e37 |
+---------------------+-----------------------+
1 row in set (0.00 sec)

[azilber]

It seems some of the ipm data logged is in exponential format...

MariaDB [pinba]> SELECT created_at, req_per_sec FROM ipm_report_by_hostname_and_server limit 10;
+---------------------+-------------+
| created_at | req_per_sec |
+---------------------+-------------+
| 2014-08-11 01:28:40 | 3.40282e38 |
| 2014-08-11 01:28:40 | 3.40282e38 |
| 2014-08-11 01:28:40 | 3.40282e38 |
| 2014-08-11 01:30:01 | 0.0521437 |
| 2014-08-11 01:30:01 | 0.0834299 |
| 2014-08-11 01:30:01 | 0.0023175 |
| 2014-08-11 01:45:01 | 0.0499432 |
| 2014-08-11 01:45:01 | 0.0635641 |
| 2014-08-11 01:45:01 | 0.00340522 |
| 2014-08-11 02:00:01 | 0.051168 |
+---------------------+-------------+

[azilber]

Truncating the table seems to have fixed it for now....

[azilber]

And looks like it didn't help at all. Any ideas?

[azilber]

Going through the pinba data, it looks like the following pinba tables may have wrong data:

report_by_hostname
INSERT INTO report_by_hostname VALUES (425,3.40282e38,103.853,100,3.40282e38,37.6142,100,3.40282e38,0.0301947,100,3.40282e38,1070.34,100,3.40282e38,'XXXX.com',1526500,100,0.0518176,NULL);

report_by_hostname_and_schema
INSERT INTO report_by_hostname_and_schema VALUES (425,3.40282e38,103.853,100,3.40282e38,37.6142,100,3.40282e38,0.0301947,100,3.40282e38,1070.34,100,3.40282e38,'XXXX.com','',1526500,100,0.0518176,':XXXX.com');

report_by_hostname_and_script
report_by_hostname_and_server
report_by_hostname_and_status
...

It's looking like it might be an engine problem....

[azilber]

Why was this closed? Issue is unresolved.

[muxx]

Because It is issue of pinba, not Pinboard.