Unable to add agent to move then one queue

Bug #1255663 reported by Paul Belanger on 2013-11-27
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Paul Belanger

Bug Description

If an agent is already assigned to a queue, you get the following exception when you add them to another queue. We'll need to be able to support the same agent in multiple queues.

pabelanger@hal9000:~/git/pabelanger/python-payloadclient$ .tox/py27/bin/payload queue-member-add 26a71142-efd4-4a83-8679-214597a7505a d8b72b5790b84435aea6702ccef8c8d7
2013-11-27 15:10:58.381 25826 INFO requests.packages.urllib3.connectionpool [-] Starting new HTTP connection (1):
2013-11-27 15:10:58.989 25826 WARNING payloadclient.common.http [-] Request returned failure status.
2013-11-27 15:10:58.989 25826 ERROR cliff.app [-] (IntegrityError) column agent_uuid is not unique u'INSERT INTO queue_member (created_at, updated_at, agent_uuid, queue_uuid) VALUES (?, ?, ?, ?)' ('2013-11-27 20:11:06.979266', None, u'd8b72b5790b84435aea6702ccef8c8d7', u'26a71142-efd4-4a83-8679-214597a7505a') (HTTP N/A)

Changed in payload:
status: New → Triaged
status: Triaged → Confirmed
Changed in payload:
assignee: nobody → Sergey Fedoseev (sir-sigurd)

Fix proposed to branch: master
Review: http://review.kickstand-project.org/437

Changed in payload:
status: Confirmed → In Progress
CaptPants (captpants) wrote :

Fix proposed to branch: master
Review: http://review.kickstand-project.org/438

Changed in payload:
assignee: Sergey Fedoseev (sir-sigurd) → Paul Belanger (pabelanger)
CaptPants (captpants) wrote :

Fix proposed to branch: master
Review: http://review.kickstand-project.org/440

CaptPants (captpants) wrote :

Fix proposed to branch: master
Review: http://review.kickstand-project.org/443

CaptPants (captpants) wrote :

Fix proposed to branch: master
Review: http://review.kickstand-project.org/444

CaptPants (captpants) wrote :

Fix proposed to branch: master
Review: http://review.kickstand-project.org/445

Reviewed: http://review.kickstand-project.org/445
Committed: http://github.com/kickstandproject/payload/commit/e8590c506975ce73ae1647ea5e4aa445079a9ed6
Submitter: Jenkins (<email address hidden>)
Branch: master

commit e8590c506975ce73ae1647ea5e4aa445079a9ed6
Author: Sergey Fedoseev <email address hidden>
Date: Sat Nov 30 00:43:42 2013 +0600

    allow agents to be in multiple queue

    Change-Id: I80fd3293325a9b14cf3b46268751ec28872f3008
    Closes-Bug: #1255663

Changed in payload:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers