Bug 1226076 - beakerd stuck on database when hostRequires contains <or> group specification
Summary: beakerd stuck on database when hostRequires contains <or> group specification
Alias: None
Product: Beaker
Classification: Community
Component: scheduler
Version: 20
Hardware: Unspecified
OS: Unspecified
unspecified vote
Target Milestone: 20.2
Assignee: matt jia
QA Contact: tools-bugs
Depends On:
TreeView+ depends on / blocked
Reported: 2015-05-29 00:05 UTC by Amit Saha
Modified: 2018-02-06 00:41 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2015-07-14 08:04:57 UTC

Attachments (Terms of Use)

Description Amit Saha 2015-05-29 00:05:58 UTC
Description of problem:

The following specification in hostRequires:

	<group op="=" value="group2"/>
	<group op="=" value="group3"/>

results in a query to the DB which was seen in production to be waiting for close to 6 hours and then had to be killed for beakerd to proceed.

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

How reproducible:


Steps to Reproduce:
1. Submit a recipe with the above in hostRequires

Actual results:

beakerd stuck, no recipes are processed.

Expected results:

Additional info:

Comment 3 matt jia 2015-06-02 04:37:22 UTC
We have this problem before. See BZ1183239. The thing is System.pools.contains() should not be used with many-to-many relationships.

On Gerrit:


Comment 7 matt jia 2015-06-16 00:25:22 UTC
Steps to reproduce:
1. Submit a job containing <hostRequires/> like the example in comment 1.
2. Check that Beaker schedules the job in a reasonable amount of time and nothing blows up.

Comment 8 wangdong 2015-07-13 06:26:42 UTC
Verify passed on https://beaker-devel.app.eng.bos.redhat.com/

See below job:


Change status to verified.

Comment 9 Dan Callaghan 2015-07-14 08:04:57 UTC
Beaker 20.2 has been released.

Note You need to log in before you can comment on or make changes to this bug.