yahoo-eng-team team mailing list archive

[Sean Dague <sean@xxxxxxxxx>]

** Changed in: nova/icehouse
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1271541

Title:
  Quota usage data wrong after instance resized by admin

Status in OpenStack Compute (nova):
  Fix Released
Status in OpenStack Compute (nova) icehouse series:
  Fix Released

Bug description:
  If the instance of a normal user is resized by admin, the user_id for
  quota usage will be changed to admin.

  Reproduce:
  We have two user 'admin' and 'test1' which is a normal user. 
  1. Create an instance by 'test1', the quota_usage table should be like:
  mysql> select * from quota_usages;
  +---------------------+---------------------+------------+----+----------------------------------+-----------+--------+----------+---------------+---------+----------------------------------+
  | created_at          | updated_at          | deleted_at | id | project_id                       | resource  | in_use | reserved | until_refresh | deleted | user_id                          |
  +---------------------+---------------------+------------+----+----------------------------------+-----------+--------+----------+---------------+---------+----------------------------------+
  | 2014-01-13 08:31:28 | 2014-01-13 08:31:28 | NULL       |  7 | 6a47816024ef4860b1a218510a1658a9 | instances |      1 |        0 |          NULL |       0 | ea75fd9954244be9b92c2aec99305f63 |
  | 2014-01-13 08:31:28 | 2014-01-13 08:31:28 | NULL       |  8 | 6a47816024ef4860b1a218510a1658a9 | ram       |    512 |        0 |          NULL |       0 | ea75fd9954244be9b92c2aec99305f63 |
  | 2014-01-13 08:31:28 | 2014-01-13 08:31:28 | NULL       |  9 | 6a47816024ef4860b1a218510a1658a9 | cores     |      1 |        0 |          NULL |       0 | ea75fd9954244be9b92c2aec99305f63 |
  +---------------------+---------------------+------------+----+----------------------------------+-----------+--------+----------+---------------+---------+----------------------------------+

  
  2. Resize the instance by admin:
  # nova list --all-tenants
  +--------------------------------------+------+--------+------------+-------------+-----------------+
  | ID                                   | Name | Status | Task State | Power State | Networks        |
  +--------------------------------------+------+--------+------------+-------------+-----------------+
  | a05f62b8-3f14-473c-9d64-b950b4dbfc9e | test | ACTIVE | None       | Running     | test=10.10.10.2 |
  +--------------------------------------+------+--------+------------+-------------+-----------------+

  # nova flavor-list
  +--------------------------------------+-----------+-----------+------+-----------+------+-------+-------------+-----------+
  | ID                                   | Name      | Memory_MB | Disk | Ephemeral | Swap | VCPUs | RXTX_Factor | Is_Public |
  +--------------------------------------+-----------+-----------+------+-----------+------+-------+-------------+-----------+
  | 1                                    | m1.tiny   | 512       | 1    | 0         |      | 1     | 1.0         | True      |
  | 2                                    | m1.small  | 2048      | 20   | 0         |      | 1     | 1.0         | True      |
  | 2ee75e0f-37e1-4561-a5e2-43b8fd677547 | m2.tiny   | 512       | 0    | 0         |      | 2     | 1.0         | True      |
  | 3                                    | m1.medium | 4096      | 40   | 0         |      | 2     | 1.0         | True      |
  | 4                                    | m1.large  | 8192      | 80   | 0         |      | 4     | 1.0         | True      |
  | 5                                    | m1.xlarge | 16384     | 160  | 0         |      | 8     | 1.0         | True      |
  +--------------------------------------+-----------+-----------+------+-----------+------+-------+-------------+-----------+

  # nova resize a05f62b8-3f14-473c-9d64-b950b4dbfc9e 2ee75e0f-
  37e1-4561-a5e2-43b8fd677547

  quota_usage table would create new records with the user_id for the admin.
  mysql> select * from quota_usages;
  +---------------------+---------------------+------------+----+----------------------------------+-----------+--------+----------+---------------+---------+----------------------------------+
  | created_at          | updated_at          | deleted_at | id | project_id                       | resource  | in_use | reserved | until_refresh | deleted | user_id                          |
  +---------------------+---------------------+------------+----+----------------------------------+-----------+--------+----------+---------------+---------+----------------------------------+
  | 2014-01-13 08:31:28 | 2014-01-13 08:31:28 | NULL       |  7 | 6a47816024ef4860b1a218510a1658a9 | instances |      1 |        0 |          NULL |       0 | ea75fd9954244be9b92c2aec99305f63 |
  | 2014-01-13 08:31:28 | 2014-01-13 08:31:28 | NULL       |  8 | 6a47816024ef4860b1a218510a1658a9 | ram       |    512 |        0 |          NULL |       0 | ea75fd9954244be9b92c2aec99305f63 |
  | 2014-01-13 08:31:28 | 2014-01-13 08:31:28 | NULL       |  9 | 6a47816024ef4860b1a218510a1658a9 | cores     |      1 |        0 |          NULL |       0 | ea75fd9954244be9b92c2aec99305f63 |
  | 2014-01-13 08:39:28 | 2014-01-13 08:39:28 | NULL       | 10 | 6a47816024ef4860b1a218510a1658a9 | cores     |      0 |        1 |          NULL |       0 | ad99c3d4311b4940b083b52fbf73789c |
  | 2014-01-13 08:39:28 | 2014-01-13 08:39:28 | NULL       | 11 | 6a47816024ef4860b1a218510a1658a9 | instances |      0 |        0 |          NULL |       0 | ad99c3d4311b4940b083b52fbf73789c |
  | 2014-01-13 08:39:28 | 2014-01-13 08:39:28 | NULL       | 12 | 6a47816024ef4860b1a218510a1658a9 | ram       |      0 |        0 |          NULL |       0 | ad99c3d4311b4940b083b52fbf73789c |
  +---------------------+---------------------+------------+----+----------------------------------+-----------+--------+----------+---------------+---------+----------------------------------+

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1271541/+subscriptions