Unable to add agent to move then one queue

Bug #1255663 reported by Paul Belanger
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
payload
Fix Committed
Undecided
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): 166.78.145.144
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)
Revision history for this message
CaptPants (captpants) wrote : Fix proposed to payload (master)

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

Changed in payload:
status: Confirmed → In Progress
Revision history for this message
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)
Revision history for this message
CaptPants (captpants) wrote :

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

Revision history for this message
CaptPants (captpants) wrote :

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

Revision history for this message
CaptPants (captpants) wrote :

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

Revision history for this message
CaptPants (captpants) wrote :

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

Revision history for this message
CaptPants (captpants) wrote : Fix merged to payload (master)

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.