No data in some graph

[mageru]

I have powa running now and I can see information on queries. I am, however, not seeing any data in many of the graphs. I am not sure what would cause this.

Nothing for: POWA: Calls (on database x) Powa: Blocks (on database x)

If I drill into a query, I DO have data for POWA General (on database x) but nothing for graphs POWA: Shared blocks POWA: Local blocks POWA: Temporary blocks POWA: Read/ write time

[mageru]

[mageru]

[rjuju]

Hi,

Thanks for the report. We are already investigating on this problem. Could you confirm that your logs display errors like "DBD::Pg::st execute failed: ERROR: division by zero at..." ?

[mageru]

Thanks rjuju, confirmed I am seeing those erros in the logs.

DBD::Pg::st execute failed: ERROR: division by zero at script/../lib/Powa/Statement.pm line 139. DBD::Pg::st fetchrow_array failed: no statement executing at script/../lib/Powa/Statement.pm line 150. [Wed Aug 27 12:22:06 2014] [debug] 200 OK (0.012555s, 79.650/s). [Wed Aug 27 12:22:06 2014] [debug] POST "/data/statement/dbdata". [Wed Aug 27 12:22:06 2014] [debug] Routing to controller "Powa::User" and action "check_auth". [Wed Aug 27 12:22:06 2014] [debug] Routing to controller "Powa::Statement" and action "dbdata". [Wed Aug 27 12:22:06 2014] [debug] 200 OK (0.014173s, 70.557/s). [Wed Aug 27 12:22:08 2014] [debug] GET "/statement/scm". [Wed Aug 27 12:22:08 2014] [debug] Routing to controller "Powa::User" and action "check_auth". [Wed Aug 27 12:22:08 2014] [debug] Routing to controller "Powa::Statement" and action "showdb". [Wed Aug 27 12:22:08 2014] [debug] Rendering cached template "statement/showdb.html.ep". [Wed Aug 27 12:22:08 2014] [debug] Rendering cached template "layouts/default.html.ep". [Wed Aug 27 12:22:08 2014] [debug] Rendering cached template "helpers/user_menu.html.ep". [Wed Aug 27 12:22:08 2014] [debug] Rendering cached template "helpers/main_menu.html.ep". [Wed Aug 27 12:22:08 2014] [debug] 200 OK (0.017249s, 57.974/s). [Wed Aug 27 12:22:09 2014] [debug] POST "/data/statement/dbdata_agg". [Wed Aug 27 12:22:09 2014] [debug] Routing to controller "Powa::User" and action "check_auth". [Wed Aug 27 12:22:09 2014] [debug] Routing to controller "Powa::Statement" and action "dbdata_agg". DBD::Pg::st execute failed: ERROR: division by zero at script/../lib/Powa/Statement.pm line 139. DBD::Pg::st fetchrow_array failed: no statement executing at script/../lib/Powa/Statement.pm line 150. [Wed Aug 27 12:22:09 2014] [debug] 200 OK (0.012120s, 82.508/s). [Wed Aug 27 12:22:09 2014] [debug] POST "/data/statement/dbdata_agg". [Wed Aug 27 12:22:09 2014] [debug] Routing to controller "Powa::User" and action "check_auth". [Wed Aug 27 12:22:09 2014] [debug] Routing to controller "Powa::Statement" and action "dbdata_agg". DBD::Pg::st execute failed: ERROR: division by zero at script/../lib/Powa/Statement.pm line 139. DBD::Pg::st fetchrow_array failed: no statement executing at script/../lib/Powa/Statement.pm line 150.

[rjuju]

This issue is fixed with commit df9f52a. However it's in the version 1.2 of powa which is still in development.