Failed to create queue due to bad query for pools

Bug #1492507 reported by Feilong Wang on 2015-09-05
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
zaqar
Medium
Feilong Wang

Bug Description

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

Feilong Wang (flwang) on 2015-09-05
Changed in zaqar:
assignee: nobody → Fei Long Wang (flwang)

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

Changed in zaqar:
status: New → In Progress
Feilong Wang (flwang) wrote :

Ican't recreate it with mongodb as the control plane

Changed in zaqar:
importance: Undecided → Medium
Changed in zaqar:
milestone: none → liberty-rc1
Feilong Wang (flwang) on 2015-09-07
description: updated
Changed in zaqar:
milestone: liberty-rc1 → mitaka-1

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers