yahoo-eng-team team mailing list archive

[Matt Riedemann <mriedem@xxxxxxxxxx>]

If DB2 uses LIKE then it sounds like it should work given the default in
the code:

https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L1932

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

** Bug watch added: code.google.com/p/sqlalchemy-migrate/issues #151
   http://code.google.com/p/sqlalchemy-migrate/issues/detail?id=151

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