Failed to create queue due to bad query for pools

[Feilong Wang]

Control plane: sqlalchemy
Data plane: redis

When create a queue, zaqar will query pools' table to see if there is any pool available, but by default, the pool group name is None.
That said, if all the pools in db has a group, the result will be empty. So we need to check if the group is None or not to decide if the query condition should be applied.

Trace:

2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues [req-a0418209-5937-4d63-9068-4e903c55701e - - - - -] [project_id:f0669027f2894ba989174ae1bb480c13] No pools registered
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues Traceback (most recent call last):
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues File "/home/feilong/MyWorkspace/workspace_community/zaqar/zaqar/transport/wsgi/v2_0/queues.py", line 82, in on_put
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues project=project_id)
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues File "/home/feilong/MyWorkspace/workspace_community/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues tmp = target(*args, **kwargs)
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues File "/home/feilong/MyWorkspace/workspace_community/zaqar/zaqar/storage/base.py", line 360, in create
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues return self._create(name, metadata, project)
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues File "/home/feilong/MyWorkspace/workspace_community/zaqar/zaqar/storage/pooling.py", line 183, in _create
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues self._pool_catalog.register(name, project=project, flavor=flavor)
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues File "/home/feilong/MyWorkspace/workspace_community/zaqar/zaqar/storage/pooling.py", line 504, in register
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues raise errors.NoPoolFound()
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues NoPoolFound: No pools registered
2015-09-07 21:20:44.286 13271 ERROR zaqar.transport.wsgi.v2_0.queues

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/220849

[Feilong Wang (flwang)]

Ｉcan't recreate it with mongodb as the control plane

[OpenStack Infra (hudson-openstack)]

Change abandoned by Fei Long Wang (<email address hidden>) on branch: master
Review: https://review.openstack.org/220849