Ask Your Question
1

horizon dashboard broken after removing failed instances

asked 2013-12-18 10:07:56 -0500

Sifty gravatar image

updated 2013-12-18 12:58:17 -0500

I deleted and removed 2 failed instances and now horizon is coming up with this error only under a specific project. Havana CentOS 6.4

 Error during template rendering
  In template /usr/lib/python2.6/site-packages/horizon/templates/horizon/common/_limit_summary.html, error at line 13
  cannot convert float infinity to integer

I assume something is corrupted in the database somewhere - would anyone have any pointers??

OK the issue is the project summaries are corrupted...

eg

VCPUs Used inf of 20
RAM Used -1071644672 of 50.0 GB

How can I fix the summaries ? and where are they managed in the nova database.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
1

answered 2013-12-19 10:46:15 -0500

Sifty gravatar image

OK fixed... if anyone is interested this is what i did to work out what data was wrong.

put mysqld into query log mode to find out what SQL was being called to generate summaries.... got the query

 SELECT quota_usages.created_at AS quota_usages_created_at, quota_usages.updated_at AS      quota_usages_updated_at, quota_usages.deleted_at AS quota_usages_deleted_at, quota_usages.deleted AS quota_usages_deleted, quota_usages.id AS quota_usages_id, quota_usages.project_id AS quota_usages_project_id, quota_usages.user_id AS quota_usages_user_id, quota_usages.resource AS quota_usages_resource, quota_usages.in_use AS quota_usages_in_use, quota_usages.reserved AS quota_usages_reserved, quota_usages.until_refresh AS quota_usages_until_refresh FROM quota_usages WHERE quota_usages.deleted = 0 AND quota_usages.project_id = 'fedd082a1e764aad91776940b2a38827' \G

Results showed that a user had odd statistics.

 quota_usages_created_at: 2013-11-08 15:17:10
   quota_usages_updated_at: 2013-12-19 16:19:59
    quota_usages_deleted_at: NULL
    quota_usages_deleted: 0
       quota_usages_id: 32
  quota_usages_project_id: fedd082a1e764aad91776940b2a38827
  quota_usages_user_id: d48cd282595d468fa067b7154919dc1b
 quota_usages_resource: ram
   quota_usages_in_use: -121324
 quota_usages_reserved: 0
quota_usages_until_refresh: NULL

saw that ram was set to negative figures and cores set to -1

   quota_usages_created_at: 2013-11-08 15:17:10
  quota_usages_updated_at: 2013-12-19 16:19:59
   quota_usages_deleted_at: NULL
        quota_usages_deleted: 0
                quota_usages_id: 33
    quota_usages_project_id: fedd082a1e764aad91776940b2a38827
         quota_usages_user_id: d48cd282595d468fa067b7154919dc1b
       quota_usages_resource: cores
          quota_usages_in_use: -1
       quota_usages_reserved: 0
 quota_usages_until_refresh: NULL

Manually updated db quota_usage - now Nova / Horizon is happy again.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-12-18 10:07:56 -0500

Seen: 426 times

Last updated: Dec 19 '13