← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1217918] Re: List servers filtered by name wildcard failed for database do not support REGEXP

 

*** This bug is a duplicate of bug 1230102 ***
    https://bugs.launchpad.net/bugs/1230102

Looks like the fix for bug 1230102 should also resolve this:

https://review.openstack.org/#/c/45026/

** Tags added: db2

** This bug has been marked a duplicate of bug 1230102
   For oracle database, the usage of REGEXP is not correct for List Servers by filter.

-- 
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):
  Invalid

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