Bug 589843

Summary:	cannot select systems in reserveworkflow
Product:	[Retired] Beaker	Reporter:	Han Pingtian <phan>
Component:	scheduler	Assignee:	Bill Peck <bpeck>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	low
Version:	0.5	CC:	bpeck, kbaker, mcsontos, rmancy
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-05-11 13:16:44 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Han Pingtian 2010-05-07 04:58:04 UTC

Description of problem:
I want to reserve a special machine, such as dell-pe2850-01.rhts.eng.bos.redhat.com, but after specifying oter items such as 'Arch' 'Distro Family' 'Method' and 'Distro' and select 'Show Systems', it only show me the machines I have reserved before. And I cannot find the dell-pe2850-01 by the 'search' function.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info:

Comment 1 Raymond Mancy 2010-05-07 05:43:45 UTC

Taking a look...

Comment 2 Raymond Mancy 2010-05-07 07:07:33 UTC

What values are you using for 'Arch', 'Disto family' etc etc ?

Comment 3 Han Pingtian 2010-05-07 09:02:03 UTC

(In reply to comment #2)
> What values are you using for 'Arch', 'Disto family' etc etc ?    

Arch: x86_64 
Disto family: RedHatEnterpriseLinux6
Method: http
Tag: none
Distro: RHEL6.0-20100506.1_http-ComputeNode-x86_64

Comment 4 Raymond Mancy 2010-05-10 06:52:15 UTC

From what I can tell, SQLAlchemy has done something whack with the SQL query. 

Until this is fixed, you could reserve your system by first searching for the system, and then selecting a distro to provision with. As per this doc

http://documentation-stage.bne.redhat.com/docs/en-US/Beaker/0.1/html/User_Guide/chap-beaker_user_guide-Provision.html#sect-beaker_user_guide-Components-System_Provisioning-Provision_by_System

Comment 5 Raymond Mancy 2010-05-11 01:09:25 UTC

Fixed
http://git.fedorahosted.org/git/?p=beaker.git;a=commit;h=ddff3dbc5940140fd740b12bad2cc143277dec70

Comment 6 Bill Peck 2010-05-11 13:16:44 UTC

merged.  Will be in next release.