Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.