yahoo-eng-team team mailing list archive

[Qing Xin Meng <mengqxqx@xxxxxxxxxx>]

** Description changed:

- For DB2 database,  try to list servers using filter and provide partial server name, it's failed!
+ For non MySQL database(such as DB2 or others),  try to list servers using filter and provide partial server name, it's failed!
  ---
  [root@localhost sqlalchemy]# nova list
  +--------------------------------------+---------+--------+------------+-------------+-------------------+
  | ID                                   | Name    | Status | Task State | Power State | Networks          |
  +--------------------------------------+---------+--------+------------+-------------+-------------------+
  | 17ebc832-7947-40a1-9aeb-423bded822bd | fortest | ACTIVE | None       | Running     | network1=10.0.1.4 |
  | 7ca3b1f5-7a17-4217-92b0-4175ecfa3c94 | mabc%2  | ACTIVE | None       | Running     | network1=10.0.1.3 |
  +--------------------------------------+---------+--------+------------+-------------+-------------------+
  [root@localhost sqlalchemy]#
  ---
  
  Try to list this server with below request.
  ---
  http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers?name=m
  ---
  
  Response:
  ---
  {
-     "servers": []
+     "servers": []
  }
  ---
  
  But for MySQL database, it's worked.
  Request:
  ---
  http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers?name=m
  ---
  
  reponse:
  ---
  {
-     "servers": [
-         {
-             "id": "7ca3b1f5-7a17-4217-92b0-4175ecfa3c94",
-             "links": [
-                 {
-                     "href": "http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";,
-                     "rel": "self"
-                 },
-                 {
-                     "href": "http://10.1.0.40:8774/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";,
-                     "rel": "bookmark"
-                 }
-             ],
-             "name": "mabc%2"
-         }
-     ]
+     "servers": [
+         {
+             "id": "7ca3b1f5-7a17-4217-92b0-4175ecfa3c94",
+             "links": [
+                 {
+                     "href": "http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";,
+                     "rel": "self"
+                 },
+                 {
+                     "href": "http://10.1.0.40:8774/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";,
+                     "rel": "bookmark"
+                 }
+             ],
+             "name": "mabc%2"
+         }
+     ]
  }
  ---

** Changed in: nova
       Status: Invalid => New

-- 
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/1217918

Title:
  List servers filtered by name wildcard failed for database do not
  support REGEXP

Status in OpenStack Compute (Nova):
  New

Bug description:
  For non MySQL database(such as DB2 or others),  try to list servers using filter and provide partial server name, it's failed!
  ---
  [root@localhost sqlalchemy]# nova list
  +--------------------------------------+---------+--------+------------+-------------+-------------------+
  | ID                                   | Name    | Status | Task State | Power State | Networks          |
  +--------------------------------------+---------+--------+------------+-------------+-------------------+
  | 17ebc832-7947-40a1-9aeb-423bded822bd | fortest | ACTIVE | None       | Running     | network1=10.0.1.4 |
  | 7ca3b1f5-7a17-4217-92b0-4175ecfa3c94 | mabc%2  | ACTIVE | None       | Running     | network1=10.0.1.3 |
  +--------------------------------------+---------+--------+------------+-------------+-------------------+
  [root@localhost sqlalchemy]#
  ---

  Try to list this server with below request.
  ---
  http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers?name=m
  ---

  Response:
  ---
  {
      "servers": []
  }
  ---

  But for MySQL database, it's worked.
  Request:
  ---
  http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers?name=m
  ---

  reponse:
  ---
  {
      "servers": [
          {
              "id": "7ca3b1f5-7a17-4217-92b0-4175ecfa3c94",
              "links": [
                  {
                      "href": "http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";,
                      "rel": "self"
                  },
                  {
                      "href": "http://10.1.0.40:8774/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";,
                      "rel": "bookmark"
                  }
              ],
              "name": "mabc%2"
          }
      ]
  }
  ---

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