2024-07-01 03:01:50 Z flight 186613 intended real branch xen-unstable 
2024-07-01 03:01:50 Z job 186613.test-arm64-arm64-examine recipe host-examine-xen 
2024-07-01 03:01:50 Z hostalloc_maxwait_starvation: A=1 B=1.81295229035573 C=1.3 I=3600 L=198.7 Xh=200 Xt=5 
HID host FLAGS arch-arm64 arch-xen-arm64 suite-bookworm purpose-test
HID host FLAG arch-arm64
HID host FLAG arch-xen-arm64
HID host FLAG suite-bookworm
HID host FLAG purpose-test
HID host FLAGS arch-arm64,arch-xen-arm64,purpose-test,suite-bookworm + 0 host conditions(s)
2024-07-01 03:01:50 Z pre-checking resources... 
2024-07-01 03:01:50 Z (precheck) allocating hosts: host 
DB PREPARING:
            WITH f AS (
            SELECT f.flight AS flight,
                   j.job AS job,
		   f.started AS started,
                   j.status AS status
		     FROM flights f
                     JOIN jobs j USING (flight)
                     JOIN runvars r
                             ON  r.flight=f.flight
                            AND  r.job=j.job
                            AND  r.name=?
                    WHERE  f.blessing=?
                      AND  f.branch=?
                      AND  j.job=?
                      AND  r.val=?
		      AND  (j.status='pass' OR j.status='fail'
                           )
                      AND  f.started IS NOT NULL
                      AND  f.started >= ?
                 ORDER BY f.started DESC

            )
            SELECT flight, job, started, status,
            (
        WITH tsteps AS 
        (
            SELECT *
              FROM steps
             WHERE flight=f.flight AND job=f.job
        )
        SELECT (
            SELECT max(finished)-min(started)
              FROM tsteps
          ) - (
            SELECT sum(finished-started)
              FROM tsteps
             WHERE step = 'ts-hosts-allocate'
          )
                AS duration

            ) FROM f

DB PREPARING:
            WITH f AS (
            SELECT f.flight AS flight,
                   s.job AS job,
                   NULL as started,
                   NULL as status,
                   max(s.finished) AS max_finished
		      FROM steps s JOIN flights f
		        ON s.flight=f.flight
		     WHERE s.job=? AND f.blessing=? AND f.branch=?
                       AND s.finished IS NOT NULL
                       AND f.started IS NOT NULL
                       AND f.started >= ?
                     GROUP BY f.flight, s.job
                     ORDER BY max_finished DESC

            )
            SELECT flight, job, started, status,
            (
        WITH tsteps AS 
        (
            SELECT *
              FROM steps
             WHERE flight=f.flight AND job=f.job
        )
        SELECT (
            SELECT max(finished)-min(started)
              FROM tsteps
          ) - (
            SELECT sum(finished-started)
              FROM tsteps
             WHERE step = 'ts-hosts-allocate'
          )
                AS duration

            ) FROM f

HID host INTENDED real
HID host TRY host pinot0:
HID host TRY host pinot0: NEEDFLAG arch-xen-arm64
HID host TRY host pinot0: NEEDFLAG purpose-test
HID host TRY host pinot0: NEEDFLAG suite-bookworm
HID host TRY host pinot0: NEEDFLAG arch-arm64
HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-gleizes:
HID host TRY host cubietruck-gleizes: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-test
HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-gleizes: NEEDFLAG arch-arm64
HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host godello0:
HID host TRY host godello0: NEEDFLAG arch-xen-arm64
HID host TRY host godello0: NEEDFLAG purpose-test
HID host TRY host godello0: NEEDFLAG suite-bookworm
HID host TRY host godello0: NEEDFLAG arch-arm64
HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host pinot1:
HID host TRY host pinot1: NEEDFLAG arch-xen-arm64
HID host TRY host pinot1: NEEDFLAG purpose-test
HID host TRY host pinot1: NEEDFLAG suite-bookworm
HID host TRY host pinot1: NEEDFLAG arch-arm64
HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host fiano0:
HID host TRY host fiano0: NEEDFLAG arch-xen-arm64
HID host TRY host fiano0: NEEDFLAG purpose-test
HID host TRY host fiano0: NEEDFLAG suite-bookworm
HID host TRY host fiano0: NEEDFLAG arch-arm64
HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host fiano1:
HID host TRY host fiano1: NEEDFLAG arch-xen-arm64
HID host TRY host fiano1: NEEDFLAG purpose-test
HID host TRY host fiano1: NEEDFLAG suite-bookworm
HID host TRY host fiano1: NEEDFLAG arch-arm64
HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host italia0:
HID host TRY host italia0: NEEDFLAG arch-xen-arm64
HID host TRY host italia0: NEEDFLAG purpose-test
HID host TRY host italia0: NEEDFLAG suite-bookworm
HID host TRY host italia0: NEEDFLAG arch-arm64
HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host godello1:
HID host TRY host godello1: NEEDFLAG arch-xen-arm64
HID host TRY host godello1: NEEDFLAG purpose-test
HID host TRY host godello1: NEEDFLAG suite-bookworm
HID host TRY host godello1: NEEDFLAG arch-arm64
HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-braque:
HID host TRY host cubietruck-braque: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-braque: NEEDFLAG purpose-test
HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-braque: NEEDFLAG arch-arm64
HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host cubietruck-metzinger:
HID host TRY host cubietruck-metzinger: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-test
HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-metzinger: NEEDFLAG arch-arm64
HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host albana0:
HID host TRY host albana0: NEEDFLAG arch-xen-arm64
HID host TRY host albana0: NEEDFLAG purpose-test
HID host TRY host albana0: NEEDFLAG suite-bookworm
HID host TRY host albana0: NEEDFLAG arch-arm64
HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host albana1:
HID host TRY host albana1: NEEDFLAG arch-xen-arm64
HID host TRY host albana1: NEEDFLAG purpose-test
HID host TRY host albana1: NEEDFLAG suite-bookworm
HID host TRY host albana1: NEEDFLAG arch-arm64
HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-picasso:
HID host TRY host cubietruck-picasso: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-picasso: NEEDFLAG purpose-test
HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-picasso: NEEDFLAG arch-arm64
HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host rochester0:
HID host TRY host rochester0: NEEDFLAG arch-xen-arm64
HID host TRY host rochester0: NEEDFLAG purpose-test
HID host TRY host rochester0: NEEDFLAG suite-bookworm
HID host TRY host rochester0: NEEDFLAG arch-arm64
HID host TRY host rochester0: FLAGS MISSINGFLAGS: .
HID host TRY host rochester0: GOOD
DUR xen-unstable real test-arm64-arm64-examine host rochester0 SAME-HOST GOT 11
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186568 DURATION 1803 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186559 DURATION 1853 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186529 DURATION 1881 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186517 DURATION 1869 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186480 DURATION 1880 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186465 DURATION 1837 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186453 DURATION 1867 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186444 DURATION 1870 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186430 DURATION 1873 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186401 DURATION 1864 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester0 REF 186386 DURATION 1860 pass
HID host TRY host rochester0: EQUIV-MOST-RECENT 186588.test-arm64-arm64-examine rochester1 pass.
HID host TRY host rochester0: SharedMaxWear (shared max wear) FROM-DEFAULT <undef>
HID host TRY host rochester0: SharedMaxTasks (shared max tasks) FROM-DEFAULT <undef>
HID host TRY host rochester0: CANDIDATE.
HID host TRY host rochester1:
HID host TRY host rochester1: NEEDFLAG arch-xen-arm64
HID host TRY host rochester1: NEEDFLAG purpose-test
HID host TRY host rochester1: NEEDFLAG suite-bookworm
HID host TRY host rochester1: NEEDFLAG arch-arm64
HID host TRY host rochester1: FLAGS MISSINGFLAGS: .
HID host TRY host rochester1: GOOD
DUR xen-unstable real test-arm64-arm64-examine host rochester1 SAME-HOST GOT 12
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186588 DURATION 1825 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186544 DURATION 1923 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186534 DURATION 1911 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186510 DURATION 1909 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186499 DURATION 1926 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186471 DURATION 1920 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186458 DURATION 1929 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186448 DURATION 1927 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186438 DURATION 1935 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186417 DURATION 1944 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186409 DURATION 1923 pass
DUR xen-unstable real test-arm64-arm64-examine host rochester1 REF 186393 DURATION 1910 pass
HID host TRY host rochester1: EQUIV-MOST-RECENT 186588.test-arm64-arm64-examine rochester1 pass.
HID host TRY host rochester1: SharedMaxWear (shared max wear) FROM-DEFAULT <undef>
HID host TRY host rochester1: SharedMaxTasks (shared max tasks) FROM-DEFAULT <undef>
HID host TRY host rochester1: CANDIDATE.
HID host TRY host debina0:
HID host TRY host debina0: NEEDFLAG arch-xen-arm64
HID host TRY host debina0: NEEDFLAG purpose-test
HID host TRY host debina0: NEEDFLAG suite-bookworm
HID host TRY host debina0: NEEDFLAG arch-arm64
HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host debina1:
HID host TRY host debina1: NEEDFLAG arch-xen-arm64
HID host TRY host debina1: NEEDFLAG purpose-test
HID host TRY host debina1: NEEDFLAG suite-bookworm
HID host TRY host debina1: NEEDFLAG arch-arm64
HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host huxelrebe0:
HID host TRY host huxelrebe0: NEEDFLAG arch-xen-arm64
HID host TRY host huxelrebe0: NEEDFLAG purpose-test
HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm
HID host TRY host huxelrebe0: NEEDFLAG arch-arm64
HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host huxelrebe1:
HID host TRY host huxelrebe1: NEEDFLAG arch-xen-arm64
HID host TRY host huxelrebe1: NEEDFLAG purpose-test
HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm
HID host TRY host huxelrebe1: NEEDFLAG arch-arm64
HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host sabro0:
HID host TRY host sabro0: NEEDFLAG arch-xen-arm64
HID host TRY host sabro0: NEEDFLAG purpose-test
HID host TRY host sabro0: NEEDFLAG suite-bookworm
HID host TRY host sabro0: NEEDFLAG arch-arm64
HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host rimava0:
HID host TRY host rimava0: NEEDFLAG arch-xen-arm64
HID host TRY host rimava0: NEEDFLAG purpose-test
HID host TRY host rimava0: NEEDFLAG suite-bookworm
HID host TRY host rimava0: NEEDFLAG arch-arm64
HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host rimava1:
HID host TRY host rimava1: NEEDFLAG arch-xen-arm64
HID host TRY host rimava1: NEEDFLAG purpose-test
HID host TRY host rimava1: NEEDFLAG suite-bookworm
HID host TRY host rimava1: NEEDFLAG arch-arm64
HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-lakeside:
HID host TRY host arndale-lakeside: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-lakeside: NEEDFLAG purpose-test
HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm
HID host TRY host arndale-lakeside: NEEDFLAG arch-arm64
HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-metrocentre:
HID host TRY host arndale-metrocentre: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-metrocentre: NEEDFLAG purpose-test
HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm
HID host TRY host arndale-metrocentre: NEEDFLAG arch-arm64
HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-westfield:
HID host TRY host arndale-westfield: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-westfield: NEEDFLAG purpose-test
HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm
HID host TRY host arndale-westfield: NEEDFLAG arch-arm64
HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host himrod0:
HID host TRY host himrod0: NEEDFLAG arch-xen-arm64
HID host TRY host himrod0: NEEDFLAG purpose-test
HID host TRY host himrod0: NEEDFLAG suite-bookworm
HID host TRY host himrod0: NEEDFLAG arch-arm64
HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nocera0:
HID host TRY host nocera0: NEEDFLAG arch-xen-arm64
HID host TRY host nocera0: NEEDFLAG purpose-test
HID host TRY host nocera0: NEEDFLAG suite-bookworm
HID host TRY host nocera0: NEEDFLAG arch-arm64
HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nocera1:
HID host TRY host nocera1: NEEDFLAG arch-xen-arm64
HID host TRY host nocera1: NEEDFLAG purpose-test
HID host TRY host nocera1: NEEDFLAG suite-bookworm
HID host TRY host nocera1: NEEDFLAG arch-arm64
HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host himrod1:
HID host TRY host himrod1: NEEDFLAG arch-xen-arm64
HID host TRY host himrod1: NEEDFLAG purpose-test
HID host TRY host himrod1: NEEDFLAG suite-bookworm
HID host TRY host himrod1: NEEDFLAG arch-arm64
HID host TRY host himrod1: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host himrod2:
HID host TRY host himrod2: NEEDFLAG arch-xen-arm64
HID host TRY host himrod2: NEEDFLAG purpose-test
HID host TRY host himrod2: NEEDFLAG suite-bookworm
HID host TRY host himrod2: NEEDFLAG arch-arm64
HID host TRY host himrod2: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host sabro1:
HID host TRY host sabro1: NEEDFLAG arch-xen-arm64
HID host TRY host sabro1: NEEDFLAG purpose-test
HID host TRY host sabro1: NEEDFLAG suite-bookworm
HID host TRY host sabro1: NEEDFLAG arch-arm64
HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nobling0:
HID host TRY host nobling0: NEEDFLAG arch-xen-arm64
HID host TRY host nobling0: NEEDFLAG purpose-test
HID host TRY host nobling0: NEEDFLAG suite-bookworm
HID host TRY host nobling0: NEEDFLAG arch-arm64
HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nobling1:
HID host TRY host nobling1: NEEDFLAG arch-xen-arm64
HID host TRY host nobling1: NEEDFLAG purpose-test
HID host TRY host nobling1: NEEDFLAG suite-bookworm
HID host TRY host nobling1: NEEDFLAG arch-arm64
HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host italia1:
HID host TRY host italia1: NEEDFLAG arch-xen-arm64
HID host TRY host italia1: NEEDFLAG purpose-test
HID host TRY host italia1: NEEDFLAG suite-bookworm
HID host TRY host italia1: NEEDFLAG arch-arm64
HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host septiner0:
HID host TRY host septiner0: NEEDFLAG arch-xen-arm64
HID host TRY host septiner0: NEEDFLAG purpose-test
HID host TRY host septiner0: NEEDFLAG suite-bookworm
HID host TRY host septiner0: NEEDFLAG arch-arm64
HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host septiner1:
HID host TRY host septiner1: NEEDFLAG arch-xen-arm64
HID host TRY host septiner1: NEEDFLAG purpose-test
HID host TRY host septiner1: NEEDFLAG suite-bookworm
HID host TRY host septiner1: NEEDFLAG arch-arm64
HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
ORDER host
RECURSE  host...
RECURSE  CAND host rochester0
RECURSE    EVAL host rochester0
RECURSE    EVAL DURATION 1891 va=162513
RECURSE    PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0
RECURSE    FINAL start=0 va=162513 variation_bonus=7618.43348647759 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-7618.43348647759
RECURSE    FINAL BEST: host rochester0
RECURSE  CAND host rochester1
RECURSE    EVAL host rochester1
RECURSE    EVAL DURATION 1954 va=90623
RECURSE    PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0
RECURSE    FINAL start=0 va=90623 variation_bonus=5164.50234113797 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-5164.50234113797
2024-07-01 03:02:32 Z resource allocation: starting... 
2024-07-01 03:02:32 Z resource allocation: awaiting our slot... 
2024-07-01 03:02:55 Z resource allocation: obtained base plan. 
base plan = {"Events":{"host fiano1":[{"Time":0,"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"test-186608-D2GDzQ4NwtZz2qYwbZEuNbqkgSzr0LBNyBQYIA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Avail":1}],"host italia0":[{"PreviousShare":{"Shares":1,"Type":"test-186608-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1,"Type":"Unshare","Time":0}],"host pinot0":[{"PreviousShare":{"Wear":4,"Type":"test-186608-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Type":"Unshare","Avail":1,"Time":0}],"host rubintos0":[{"Avail":0,"Type":"Start","Time":-18113502},{"Time":604800,"Type":"End","Avail":1}],"host italia1":[{"Avail":1,"PreviousShare":{"Shares":1,"Type":"test-186608-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Type":"Unshare","Time":0}],"host himrod1":[{"Job":"186613.build-amd64","Share":{"Wear":1,"Shares":"3","Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":-342,"Type":"Start","Avail":2},{"Job":"186613.build-amd64","Share":{"Shares":3,"Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Time":750,"Type":"End","Avail":3},{"PreviousShare":{"Wear":1,"Shares":"3","Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1,"Type":"Unshare","Time":750}],"host nobling1":[{"PreviousShare":{"Shares":1,"Type":"test-186608-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Type":"Unshare","Avail":1,"Time":0}],"host sabro1":[{"PreviousShare":{"Shares":1,"Type":"test-186608-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":4},"Avail":1,"Type":"Unshare","Time":0}],"host cubietruck-metzinger":[{"Type":"Unshare","PreviousShare":{"Wear":10,"Shares":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1,"Time":0}],"host laxton1":[{"Time":0,"PreviousShare":{"Shares":3,"Type":"build-buster-arm64 cb303068d340f3344c760df46ac9785e08c0d889","Wear":1},"Avail":1,"Type":"Unshare"}],"host sabro0":[{"Time":0,"PreviousShare":{"Shares":1,"Type":"test-186608-Wkc-iRiTW8GdIwEw8ISckkZRTf9e8E8OzKhytA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1,"Type":"Unshare"}],"host septiner1":[{"Time":0,"Type":"Unshare","PreviousShare":{"Shares":1,"Type":"test-186608-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":2},"Avail":1}],"host rochester0":[{"Share":{"Wear":1,"Type":"build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"3"},"Job":"186613.build-arm64-pvops","Avail":2,"Type":"Start","Time":-2272},{"Time":1788,"Avail":3,"Type":"End","Job":"186613.build-arm64-pvops","Share":{"Wear":1,"Type":"build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":3}},{"Avail":1,"PreviousShare":{"Shares":"3","Type":"build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Type":"Unshare","Time":1788}],"host verdesse1":[{"Type":"Start","Avail":0,"Time":-18709288},{"Type":"End","Avail":1,"Time":604800}],"host cubietruck-gleizes":[{"Time":0,"PreviousShare":{"Shares":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":10},"Type":"Unshare","Avail":1}],"host arndale-metrocentre":[{"Job":"186608.test-armhf-armhf-libvirt-vhd","Share":{"Wear":1,"Type":"test-186608-_rpVSdnr6j4tTK4ty5aNqEm4oZm9adSOwIYj9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"},"Time":-4100,"Avail":0,"Type":"Start"},{"Job":"186608.test-armhf-armhf-libvirt-vhd","Share":{"Type":"test-186608-_rpVSdnr6j4tTK4ty5aNqEm4oZm9adSOwIYj9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1,"Wear":1},"Time":1531,"Avail":1,"Type":"End"},{"Type":"Unshare","PreviousShare":{"Shares":"1","Type":"test-186608-_rpVSdnr6j4tTK4ty5aNqEm4oZm9adSOwIYj9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1,"Time":1531}],"host huxelrebe1":[{"Time":-2873,"Avail":0,"Type":"Start","Job":"186613.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Share":{"Wear":1,"Type":"test-186613-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"}},{"Job":"186613.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Share":{"Shares":1,"Type":"test-186613-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Time":2813,"Type":"End","Avail":1},{"Avail":1,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-186613-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Type":"Unshare","Time":2813}],"host fiano0":[{"Avail":1,"PreviousShare":{"Type":"test-186600-Wkc-iRiTW8GdIwEw8ISckkZRTf9e8E8OzKhytA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1,"Wear":1},"Type":"Unshare","Time":0}],"host joubertin0":[{"Avail":0,"Type":"Start","Time":-26995416},{"Time":604800,"Type":"End","Avail":1}],"host nobling0":[{"Time":0,"Avail":1,"PreviousShare":{"Type":"build-bookworm-i386 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":3,"Wear":9},"Type":"Unshare"}],"host rochester1":[{"Time":0,"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-186608-lytAHmBP-IYQgJdOXSkmKGozhsGiAtAMsKxS0w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1,"Type":"Unshare"}],"host nocera0":[{"Avail":0,"Type":"Start","Time":-20881339},{"Avail":1,"Type":"End","Time":604800}],"host verdesse0":[{"Type":"Start","Avail":0,"Time":-18709288},{"Time":604800,"Avail":1,"Type":"End"}],"host debina0":[{"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-186608-x6Z9DHx8E-ru2LB5XnyL3AmZEJnMPUGA2tmIVA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Type":"Unshare","Avail":1,"Time":0}],"host albana1":[{"PreviousShare":{"Wear":3,"Shares":1,"Type":"test-186608-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Type":"Unshare","Avail":1,"Time":0}],"host nocera1":[{"Avail":0,"Type":"Start","Time":-20881339},{"Avail":1,"Type":"End","Time":604800}],"host septiner0":[{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":1,"Type":"test-186608-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1,"Time":0}],"host albana0":[{"Time":-605,"Avail":0,"Type":"Start","Job":"186613.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm","Share":{"Shares":"1","Type":"test-186613-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1}},{"Share":{"Wear":1,"Type":"test-186613-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Job":"186613.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm","Avail":1,"Type":"End","Time":4591},{"PreviousShare":{"Shares":"1","Type":"test-186613-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Type":"Unshare","Avail":1,"Time":4591}],"host debina1":[{"Time":0,"Type":"Unshare","PreviousShare":{"Shares":1,"Type":"test-186608-8TAMgyQXXFY3b0cUy7_a7x0Ih2_BxrZRFB66MA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1}],"host arndale-lakeside":[{"Time":0,"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":1,"Type":"test-186608-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1}],"host joubertin1":[{"Time":-26995416,"Type":"Start","Avail":0},{"Type":"End","Avail":1,"Time":604800}],"host cubietruck-braque":[{"Job":"186613.build-armhf","Share":{"Wear":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"},"Time":-4100,"Type":"Start","Avail":0},{"Type":"End","Avail":1,"Time":5927,"Share":{"Wear":1,"Shares":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Job":"186613.build-armhf"},{"Time":5927,"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"},"Avail":1}],"host godello0":[{"Avail":1,"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-186611-eN7FKc6Fe_JeyUfeMqWyUExV-wDrCKYJLtV_dw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c+"},"Type":"Unshare","Time":0}],"host huxelrebe0":[{"Time":0,"Avail":1,"PreviousShare":{"Type":"test-186608-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1,"Wear":1},"Type":"Unshare"}],"host chardonnay0":[{"PreviousShare":{"Type":"build-bookworm-i386 e79eec106ae080bc8ed8e205858411a3e4747498","Shares":3,"Wear":5},"Type":"Unshare","Avail":1,"Time":0}],"host himrod2":[{"Time":0,"Type":"Unshare","PreviousShare":{"Shares":3,"Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":10},"Avail":1}],"host rimava0":[{"PreviousShare":{"Shares":1,"Type":"test-186612-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Type":"Unshare","Avail":1,"Time":0}],"host rubintos1":[{"Avail":0,"Type":"Start","Time":-18113502},{"Time":604800,"Type":"End","Avail":1}],"host rimava1":[{"Time":0,"Avail":1,"PreviousShare":{"Wear":1,"Type":"test-186608-p0kACIJnfnkizve63p1CU80DkBBwVtb3wATFtg 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Type":"Unshare"}],"host arndale-westfield":[{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":1,"Type":"test-186608-A6Up9OPekL9azypX4XkU0WV6Xh_ajTaooJUX9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1,"Time":0}],"host godello1":[{"Time":0,"Type":"Unshare","PreviousShare":{"Shares":1,"Type":"test-186608-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1}]},"ClientNotes":{},"Start":1719802974}
2024-07-01 03:02:55 Z allocating hosts: host 
DB PREPARING:
            WITH f AS (
            SELECT f.flight AS flight,
                   j.job AS job,
		   f.started AS started,
                   j.status AS status
		     FROM flights f
                     JOIN jobs j USING (flight)
                     JOIN runvars r
                             ON  r.flight=f.flight
                            AND  r.job=j.job
                            AND  r.name=?
                    WHERE  f.blessing=?
                      AND  f.branch=?
                      AND  j.job=?
                      AND  r.val=?
		      AND  (j.status='pass' OR j.status='fail'
                           )
                      AND  f.started IS NOT NULL
                      AND  f.started >= ?
                 ORDER BY f.started DESC

            )
            SELECT flight, job, started, status,
            (
        WITH tsteps AS 
        (
            SELECT *
              FROM steps
             WHERE flight=f.flight AND job=f.job
        )
        SELECT (
            SELECT max(finished)-min(started)
              FROM tsteps
          ) - (
            SELECT sum(finished-started)
              FROM tsteps
             WHERE step = 'ts-hosts-allocate'
          )
                AS duration

            ) FROM f

DB PREPARING:
            WITH f AS (
            SELECT f.flight AS flight,
                   s.job AS job,
                   NULL as started,
                   NULL as status,
                   max(s.finished) AS max_finished
		      FROM steps s JOIN flights f
		        ON s.flight=f.flight
		     WHERE s.job=? AND f.blessing=? AND f.branch=?
                       AND s.finished IS NOT NULL
                       AND f.started IS NOT NULL
                       AND f.started >= ?
                     GROUP BY f.flight, s.job
                     ORDER BY max_finished DESC

            )
            SELECT flight, job, started, status,
            (
        WITH tsteps AS 
        (
            SELECT *
              FROM steps
             WHERE flight=f.flight AND job=f.job
        )
        SELECT (
            SELECT max(finished)-min(started)
              FROM tsteps
          ) - (
            SELECT sum(finished-started)
              FROM tsteps
             WHERE step = 'ts-hosts-allocate'
          )
                AS duration

            ) FROM f

HID host INTENDED real
HID host TRY host pinot0:
HID host TRY host pinot0: NEEDFLAG arch-xen-arm64
HID host TRY host pinot0: NEEDFLAG purpose-test
HID host TRY host pinot0: NEEDFLAG suite-bookworm
HID host TRY host pinot0: NEEDFLAG arch-arm64
HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-gleizes:
HID host TRY host cubietruck-gleizes: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-test
HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-gleizes: NEEDFLAG arch-arm64
HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host godello0:
HID host TRY host godello0: NEEDFLAG arch-xen-arm64
HID host TRY host godello0: NEEDFLAG purpose-test
HID host TRY host godello0: NEEDFLAG suite-bookworm
HID host TRY host godello0: NEEDFLAG arch-arm64
HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host pinot1:
HID host TRY host pinot1: NEEDFLAG arch-xen-arm64
HID host TRY host pinot1: NEEDFLAG purpose-test
HID host TRY host pinot1: NEEDFLAG suite-bookworm
HID host TRY host pinot1: NEEDFLAG arch-arm64
HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host fiano0:
HID host TRY host fiano0: NEEDFLAG arch-xen-arm64
HID host TRY host fiano0: NEEDFLAG purpose-test
HID host TRY host fiano0: NEEDFLAG suite-bookworm
HID host TRY host fiano0: NEEDFLAG arch-arm64
HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host fiano1:
HID host TRY host fiano1: NEEDFLAG arch-xen-arm64
HID host TRY host fiano1: NEEDFLAG purpose-test
HID host TRY host fiano1: NEEDFLAG suite-bookworm
HID host TRY host fiano1: NEEDFLAG arch-arm64
HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host italia0:
HID host TRY host italia0: NEEDFLAG arch-xen-arm64
HID host TRY host italia0: NEEDFLAG purpose-test
HID host TRY host italia0: NEEDFLAG suite-bookworm
HID host TRY host italia0: NEEDFLAG arch-arm64
HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host godello1:
HID host TRY host godello1: NEEDFLAG arch-xen-arm64
HID host TRY host godello1: NEEDFLAG purpose-test
HID host TRY host godello1: NEEDFLAG suite-bookworm
HID host TRY host godello1: NEEDFLAG arch-arm64
HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-braque:
HID host TRY host cubietruck-braque: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-braque: NEEDFLAG purpose-test
HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-braque: NEEDFLAG arch-arm64
HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host cubietruck-metzinger:
HID host TRY host cubietruck-metzinger: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-test
HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-metzinger: NEEDFLAG arch-arm64
HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host albana0:
HID host TRY host albana0: NEEDFLAG arch-xen-arm64
HID host TRY host albana0: NEEDFLAG purpose-test
HID host TRY host albana0: NEEDFLAG suite-bookworm
HID host TRY host albana0: NEEDFLAG arch-arm64
HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host albana1:
HID host TRY host albana1: NEEDFLAG arch-xen-arm64
HID host TRY host albana1: NEEDFLAG purpose-test
HID host TRY host albana1: NEEDFLAG suite-bookworm
HID host TRY host albana1: NEEDFLAG arch-arm64
HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-picasso:
HID host TRY host cubietruck-picasso: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-picasso: NEEDFLAG purpose-test
HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-picasso: NEEDFLAG arch-arm64
HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host rochester0:
HID host TRY host rochester0: NEEDFLAG arch-xen-arm64
HID host TRY host rochester0: NEEDFLAG purpose-test
HID host TRY host rochester0: NEEDFLAG suite-bookworm
HID host TRY host rochester0: NEEDFLAG arch-arm64
HID host TRY host rochester0: FLAGS MISSINGFLAGS: .
HID host TRY host rochester0: GOOD
HID host TRY host rochester0: EQUIV-MOST-RECENT 186588.test-arm64-arm64-examine rochester1 pass.
HID host TRY host rochester0: SharedMaxWear (shared max wear) FROM-DEFAULT <undef>
HID host TRY host rochester0: SharedMaxTasks (shared max tasks) FROM-DEFAULT <undef>
HID host TRY host rochester0: CANDIDATE.
HID host TRY host rochester1:
HID host TRY host rochester1: NEEDFLAG arch-xen-arm64
HID host TRY host rochester1: NEEDFLAG purpose-test
HID host TRY host rochester1: NEEDFLAG suite-bookworm
HID host TRY host rochester1: NEEDFLAG arch-arm64
HID host TRY host rochester1: FLAGS MISSINGFLAGS: .
HID host TRY host rochester1: GOOD
HID host TRY host rochester1: EQUIV-MOST-RECENT 186588.test-arm64-arm64-examine rochester1 pass.
HID host TRY host rochester1: SharedMaxWear (shared max wear) FROM-DEFAULT <undef>
HID host TRY host rochester1: SharedMaxTasks (shared max tasks) FROM-DEFAULT <undef>
HID host TRY host rochester1: CANDIDATE.
HID host TRY host debina0:
HID host TRY host debina0: NEEDFLAG arch-xen-arm64
HID host TRY host debina0: NEEDFLAG purpose-test
HID host TRY host debina0: NEEDFLAG suite-bookworm
HID host TRY host debina0: NEEDFLAG arch-arm64
HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host debina1:
HID host TRY host debina1: NEEDFLAG arch-xen-arm64
HID host TRY host debina1: NEEDFLAG purpose-test
HID host TRY host debina1: NEEDFLAG suite-bookworm
HID host TRY host debina1: NEEDFLAG arch-arm64
HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host huxelrebe0:
HID host TRY host huxelrebe0: NEEDFLAG arch-xen-arm64
HID host TRY host huxelrebe0: NEEDFLAG purpose-test
HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm
HID host TRY host huxelrebe0: NEEDFLAG arch-arm64
HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host huxelrebe1:
HID host TRY host huxelrebe1: NEEDFLAG arch-xen-arm64
HID host TRY host huxelrebe1: NEEDFLAG purpose-test
HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm
HID host TRY host huxelrebe1: NEEDFLAG arch-arm64
HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host sabro0:
HID host TRY host sabro0: NEEDFLAG arch-xen-arm64
HID host TRY host sabro0: NEEDFLAG purpose-test
HID host TRY host sabro0: NEEDFLAG suite-bookworm
HID host TRY host sabro0: NEEDFLAG arch-arm64
HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host rimava0:
HID host TRY host rimava0: NEEDFLAG arch-xen-arm64
HID host TRY host rimava0: NEEDFLAG purpose-test
HID host TRY host rimava0: NEEDFLAG suite-bookworm
HID host TRY host rimava0: NEEDFLAG arch-arm64
HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host rimava1:
HID host TRY host rimava1: NEEDFLAG arch-xen-arm64
HID host TRY host rimava1: NEEDFLAG purpose-test
HID host TRY host rimava1: NEEDFLAG suite-bookworm
HID host TRY host rimava1: NEEDFLAG arch-arm64
HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-lakeside:
HID host TRY host arndale-lakeside: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-lakeside: NEEDFLAG purpose-test
HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm
HID host TRY host arndale-lakeside: NEEDFLAG arch-arm64
HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-metrocentre:
HID host TRY host arndale-metrocentre: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-metrocentre: NEEDFLAG purpose-test
HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm
HID host TRY host arndale-metrocentre: NEEDFLAG arch-arm64
HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-westfield:
HID host TRY host arndale-westfield: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-westfield: NEEDFLAG purpose-test
HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm
HID host TRY host arndale-westfield: NEEDFLAG arch-arm64
HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host himrod0:
HID host TRY host himrod0: NEEDFLAG arch-xen-arm64
HID host TRY host himrod0: NEEDFLAG purpose-test
HID host TRY host himrod0: NEEDFLAG suite-bookworm
HID host TRY host himrod0: NEEDFLAG arch-arm64
HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nocera0:
HID host TRY host nocera0: NEEDFLAG arch-xen-arm64
HID host TRY host nocera0: NEEDFLAG purpose-test
HID host TRY host nocera0: NEEDFLAG suite-bookworm
HID host TRY host nocera0: NEEDFLAG arch-arm64
HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nocera1:
HID host TRY host nocera1: NEEDFLAG arch-xen-arm64
HID host TRY host nocera1: NEEDFLAG purpose-test
HID host TRY host nocera1: NEEDFLAG suite-bookworm
HID host TRY host nocera1: NEEDFLAG arch-arm64
HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host himrod1:
HID host TRY host himrod1: NEEDFLAG arch-xen-arm64
HID host TRY host himrod1: NEEDFLAG purpose-test
HID host TRY host himrod1: NEEDFLAG suite-bookworm
HID host TRY host himrod1: NEEDFLAG arch-arm64
HID host TRY host himrod1: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host himrod2:
HID host TRY host himrod2: NEEDFLAG arch-xen-arm64
HID host TRY host himrod2: NEEDFLAG purpose-test
HID host TRY host himrod2: NEEDFLAG suite-bookworm
HID host TRY host himrod2: NEEDFLAG arch-arm64
HID host TRY host himrod2: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host sabro1:
HID host TRY host sabro1: NEEDFLAG arch-xen-arm64
HID host TRY host sabro1: NEEDFLAG purpose-test
HID host TRY host sabro1: NEEDFLAG suite-bookworm
HID host TRY host sabro1: NEEDFLAG arch-arm64
HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nobling0:
HID host TRY host nobling0: NEEDFLAG arch-xen-arm64
HID host TRY host nobling0: NEEDFLAG purpose-test
HID host TRY host nobling0: NEEDFLAG suite-bookworm
HID host TRY host nobling0: NEEDFLAG arch-arm64
HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nobling1:
HID host TRY host nobling1: NEEDFLAG arch-xen-arm64
HID host TRY host nobling1: NEEDFLAG purpose-test
HID host TRY host nobling1: NEEDFLAG suite-bookworm
HID host TRY host nobling1: NEEDFLAG arch-arm64
HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host italia1:
HID host TRY host italia1: NEEDFLAG arch-xen-arm64
HID host TRY host italia1: NEEDFLAG purpose-test
HID host TRY host italia1: NEEDFLAG suite-bookworm
HID host TRY host italia1: NEEDFLAG arch-arm64
HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host septiner0:
HID host TRY host septiner0: NEEDFLAG arch-xen-arm64
HID host TRY host septiner0: NEEDFLAG purpose-test
HID host TRY host septiner0: NEEDFLAG suite-bookworm
HID host TRY host septiner0: NEEDFLAG arch-arm64
HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host septiner1:
HID host TRY host septiner1: NEEDFLAG arch-xen-arm64
HID host TRY host septiner1: NEEDFLAG purpose-test
HID host TRY host septiner1: NEEDFLAG suite-bookworm
HID host TRY host septiner1: NEEDFLAG arch-arm64
HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
ORDER host
RECURSE  host...
RECURSE  CAND host rochester0
RECURSE    EVAL host rochester0
RECURSE    EVAL DURATION 1891 va=162536
RECURSE    PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0
RECURSE    PLAN LOOP   OVERLAP
RECURSE    PLAN LOOP   OVERLAP ESHARE
RECURSE    PLAN LOOP   SHARE-COMPAT-OK type build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c vs. <undef> wear 1 shares 3 vs. <undef>
RECURSE    PLAN LOOP   OVERLAP BAD 1788
RECURSE    PLAN LOOP reqs[0]=host evtix=1 try=1788 confirmed=0
RECURSE    PLAN LOOP reqs[0]=host evtix=2 try=1788 confirmed=0
RECURSE    PLAN LOOP   OVERLAP
RECURSE    PLAN LOOP   OVERLAP AVAIL OK
RECURSE    PLAN NEXT reqs[0]=host try=1788 confirmed=0 reuse=0
RECURSE    PLAN LOOP   SHARE-COMPAT-OK type build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c vs. <undef> wear 1 shares 3 vs. <undef>
RECURSE    FINAL start=1788 va=162536 variation_bonus=7619.098748435 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-5831.098748435
RECURSE    FINAL BEST: host rochester0
RECURSE  CAND host rochester1
RECURSE    EVAL host rochester1
RECURSE    EVAL DURATION 1954 va=90646
RECURSE    PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0
RECURSE    PLAN LOOP   OVERLAP
RECURSE    PLAN LOOP   OVERLAP AVAIL OK
RECURSE    PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0
RECURSE    PLAN LOOP   SHARE-COMPAT-OK type test-186608-lytAHmBP-IYQgJdOXSkmKGozhsGiAtAMsKxS0w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c vs. <undef> wear 1 shares 1 vs. <undef>
RECURSE    FINAL start=0 va=90646 variation_bonus=5165.43775203378 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-5165.43775203378
2024-07-01 03:02:55 Z host allocation: planned start in 1788 seconds. 
most_optimistic: all: 1788 (@0)
most_optimistic: (period=3600): 1788 (@0)
not starving (class): no estimate
2024-07-01 03:02:55 Z resource allocation: booking @1788 host rochester0 [host]. 
bookings = {"Bookings":[{"Job":"186613.test-arm64-arm64-examine","End":3679,"Xinfo":"host","Start":"1788","Reso":"host rochester0"}],"ClientNotes":{}}
2024-07-01 03:02:55 Z resource allocation: we are in the plan. 
2024-07-01 03:02:55 Z resource allocation: deferring 
2024-07-01 03:02:55 Z resource allocation: awaiting our slot... 
2024-07-01 03:03:30 Z resource allocation: obtained base plan. 
base plan = {"ClientNotes":{},"Events":{"host verdesse0":[{"Avail":0,"Time":-18709324,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host nocera0":[{"Time":-20881375,"Avail":0,"Type":"Start"},{"Time":604800,"Avail":1,"Type":"End"}],"host arndale-metrocentre":[{"Time":-4136,"Avail":0,"Share":{"Wear":1,"Type":"test-186608-_rpVSdnr6j4tTK4ty5aNqEm4oZm9adSOwIYj9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"},"Type":"Start","Job":"186608.test-armhf-armhf-libvirt-vhd"},{"Type":"End","Share":{"Type":"test-186608-_rpVSdnr6j4tTK4ty5aNqEm4oZm9adSOwIYj9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1,"Shares":1},"Job":"186608.test-armhf-armhf-libvirt-vhd","Time":1495,"Avail":1},{"Type":"Unshare","Avail":1,"PreviousShare":{"Shares":"1","Wear":1,"Type":"test-186608-_rpVSdnr6j4tTK4ty5aNqEm4oZm9adSOwIYj9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":1495}],"host fiano0":[{"Type":"Unshare","Avail":1,"Time":0,"PreviousShare":{"Shares":1,"Wear":1,"Type":"test-186600-Wkc-iRiTW8GdIwEw8ISckkZRTf9e8E8OzKhytA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"}}],"host godello1":[{"Avail":1,"PreviousShare":{"Wear":1,"Type":"test-186608-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Time":0,"Type":"Unshare"}],"host arndale-westfield":[{"Time":0,"PreviousShare":{"Shares":1,"Wear":1,"Type":"test-186608-A6Up9OPekL9azypX4XkU0WV6Xh_ajTaooJUX9w 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Avail":1,"Type":"Unshare"}],"host nobling0":[{"Type":"Unshare","Avail":1,"PreviousShare":{"Shares":3,"Wear":9,"Type":"build-bookworm-i386 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":0}],"host sabro0":[{"Avail":1,"PreviousShare":{"Shares":1,"Type":"test-186608-Wkc-iRiTW8GdIwEw8ISckkZRTf9e8E8OzKhytA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Time":0,"Type":"Unshare"}],"host cubietruck-metzinger":[{"PreviousShare":{"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":10,"Shares":1},"Time":0,"Avail":1,"Type":"Unshare"}],"host debina0":[{"Time":0,"PreviousShare":{"Type":"test-186608-x6Z9DHx8E-ru2LB5XnyL3AmZEJnMPUGA2tmIVA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1,"Shares":1},"Avail":1,"Type":"Unshare"}],"host rimava0":[{"Type":"Unshare","Time":0,"PreviousShare":{"Type":"test-186612-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1,"Shares":1},"Avail":1}],"host joubertin0":[{"Type":"Start","Avail":0,"Time":-26995452},{"Avail":1,"Time":604800,"Type":"End"}],"host cubietruck-gleizes":[{"Type":"Unshare","Avail":1,"PreviousShare":{"Shares":1,"Wear":10,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":0}],"host himrod2":[{"Type":"Unshare","Avail":1,"PreviousShare":{"Wear":10,"Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":3},"Time":0}],"host huxelrebe1":[{"Type":"Start","Share":{"Wear":1,"Type":"test-186613-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"},"Job":"186613.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Avail":0,"Time":-2909},{"Share":{"Wear":1,"Type":"test-186613-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Job":"186613.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Type":"End","Time":2777,"Avail":1},{"Type":"Unshare","Avail":1,"Time":2777,"PreviousShare":{"Wear":1,"Type":"test-186613-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"}}],"host albana1":[{"PreviousShare":{"Shares":1,"Type":"test-186608-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":3},"Time":0,"Avail":1,"Type":"Unshare"}],"host italia1":[{"Avail":1,"Time":0,"PreviousShare":{"Wear":1,"Type":"test-186608-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Type":"Unshare"}],"host joubertin1":[{"Time":-26995452,"Avail":0,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host fiano1":[{"Type":"Unshare","PreviousShare":{"Shares":1,"Wear":1,"Type":"test-186608-D2GDzQ4NwtZz2qYwbZEuNbqkgSzr0LBNyBQYIA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":0,"Avail":1}],"host sabro1":[{"Avail":1,"PreviousShare":{"Shares":1,"Type":"test-186608-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":4},"Time":0,"Type":"Unshare"}],"host huxelrebe0":[{"Type":"Unshare","Avail":1,"Time":0,"PreviousShare":{"Shares":1,"Wear":1,"Type":"test-186608-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"}}],"host septiner1":[{"Type":"Unshare","Time":0,"PreviousShare":{"Wear":2,"Type":"test-186608-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Avail":1}],"host godello0":[{"PreviousShare":{"Shares":1,"Wear":1,"Type":"test-186611-eN7FKc6Fe_JeyUfeMqWyUExV-wDrCKYJLtV_dw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c+"},"Time":0,"Avail":1,"Type":"Unshare"}],"host rubintos0":[{"Avail":0,"Time":-18113538,"Type":"Start"},{"Type":"End","Time":604800,"Avail":1}],"host nobling1":[{"Type":"Unshare","Time":0,"PreviousShare":{"Shares":1,"Type":"test-186608-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1}],"host himrod1":[{"Share":{"Shares":"3","Wear":1,"Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Type":"Start","Job":"186613.build-amd64","Time":-378,"Avail":2},{"Type":"End","Share":{"Shares":3,"Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Job":"186613.build-amd64","Avail":3,"Time":714},{"Avail":1,"PreviousShare":{"Shares":"3","Type":"build-bookworm-amd64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Time":714,"Type":"Unshare"}],"host verdesse1":[{"Type":"Start","Avail":0,"Time":-18709324},{"Avail":1,"Time":604800,"Type":"End"}],"host rochester1":[{"Job":"186613.test-arm64-arm64-libvirt-raw","Share":{"Wear":1,"Type":"test-186613-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":"1"},"Type":"Start","Avail":0,"Time":-36},{"Job":"186613.test-arm64-arm64-libvirt-raw","Share":{"Type":"test-186613-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1,"Shares":1},"Type":"End","Avail":1,"Time":4440},{"Type":"Unshare","Time":4440,"PreviousShare":{"Shares":"1","Type":"test-186613-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1}],"host cubietruck-braque":[{"Time":-4136,"Avail":0,"Type":"Start","Share":{"Shares":"1","Wear":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Job":"186613.build-armhf"},{"Time":5891,"Avail":1,"Type":"End","Share":{"Shares":1,"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Job":"186613.build-armhf"},{"Type":"Unshare","Avail":1,"PreviousShare":{"Type":"build-bookworm-armhf 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1,"Shares":"1"},"Time":5891}],"host albana0":[{"Time":-641,"Avail":0,"Job":"186613.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm","Share":{"Type":"test-186613-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1,"Shares":"1"},"Type":"Start"},{"Avail":1,"Time":4555,"Share":{"Shares":1,"Type":"test-186613-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Job":"186613.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm","Type":"End"},{"Avail":1,"Time":4555,"PreviousShare":{"Shares":"1","Type":"test-186613-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Type":"Unshare"}],"host nocera1":[{"Time":-20881375,"Avail":0,"Type":"Start"},{"Time":604800,"Avail":1,"Type":"End"}],"host rimava1":[{"PreviousShare":{"Shares":1,"Type":"test-186608-p0kACIJnfnkizve63p1CU80DkBBwVtb3wATFtg 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Time":0,"Avail":1,"Type":"Unshare"}],"host debina1":[{"Avail":1,"PreviousShare":{"Shares":1,"Wear":1,"Type":"test-186608-8TAMgyQXXFY3b0cUy7_a7x0Ih2_BxrZRFB66MA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":0,"Type":"Unshare"}],"host chardonnay0":[{"Avail":1,"Time":0,"PreviousShare":{"Shares":3,"Wear":5,"Type":"build-bookworm-i386 e79eec106ae080bc8ed8e205858411a3e4747498"},"Type":"Unshare"}],"host laxton1":[{"Avail":1,"Time":0,"PreviousShare":{"Shares":3,"Type":"build-buster-arm64 cb303068d340f3344c760df46ac9785e08c0d889","Wear":1},"Type":"Unshare"}],"host pinot0":[{"Type":"Unshare","Avail":1,"PreviousShare":{"Shares":1,"Wear":4,"Type":"test-186608-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"},"Time":0}],"host rubintos1":[{"Avail":0,"Time":-18113538,"Type":"Start"},{"Type":"End","Avail":1,"Time":604800}],"host italia0":[{"Type":"Unshare","Time":0,"PreviousShare":{"Shares":1,"Type":"test-186608-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1}],"host septiner0":[{"Type":"Unshare","Time":0,"PreviousShare":{"Shares":1,"Type":"test-186608-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Wear":1},"Avail":1}],"host rochester0":[{"Type":"Unshare","Avail":1,"Time":0,"PreviousShare":{"Shares":3,"Wear":4,"Type":"build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c"}}],"host arndale-lakeside":[{"Avail":1,"Time":0,"PreviousShare":{"Wear":1,"Type":"test-186608-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c","Shares":1},"Type":"Unshare"}]},"Start":1719803010}
2024-07-01 03:03:30 Z allocating hosts: host 
DB PREPARING:
            WITH f AS (
            SELECT f.flight AS flight,
                   j.job AS job,
		   f.started AS started,
                   j.status AS status
		     FROM flights f
                     JOIN jobs j USING (flight)
                     JOIN runvars r
                             ON  r.flight=f.flight
                            AND  r.job=j.job
                            AND  r.name=?
                    WHERE  f.blessing=?
                      AND  f.branch=?
                      AND  j.job=?
                      AND  r.val=?
		      AND  (j.status='pass' OR j.status='fail'
                           )
                      AND  f.started IS NOT NULL
                      AND  f.started >= ?
                 ORDER BY f.started DESC

            )
            SELECT flight, job, started, status,
            (
        WITH tsteps AS 
        (
            SELECT *
              FROM steps
             WHERE flight=f.flight AND job=f.job
        )
        SELECT (
            SELECT max(finished)-min(started)
              FROM tsteps
          ) - (
            SELECT sum(finished-started)
              FROM tsteps
             WHERE step = 'ts-hosts-allocate'
          )
                AS duration

            ) FROM f

DB PREPARING:
            WITH f AS (
            SELECT f.flight AS flight,
                   s.job AS job,
                   NULL as started,
                   NULL as status,
                   max(s.finished) AS max_finished
		      FROM steps s JOIN flights f
		        ON s.flight=f.flight
		     WHERE s.job=? AND f.blessing=? AND f.branch=?
                       AND s.finished IS NOT NULL
                       AND f.started IS NOT NULL
                       AND f.started >= ?
                     GROUP BY f.flight, s.job
                     ORDER BY max_finished DESC

            )
            SELECT flight, job, started, status,
            (
        WITH tsteps AS 
        (
            SELECT *
              FROM steps
             WHERE flight=f.flight AND job=f.job
        )
        SELECT (
            SELECT max(finished)-min(started)
              FROM tsteps
          ) - (
            SELECT sum(finished-started)
              FROM tsteps
             WHERE step = 'ts-hosts-allocate'
          )
                AS duration

            ) FROM f

HID host INTENDED real
HID host TRY host pinot0:
HID host TRY host pinot0: NEEDFLAG arch-xen-arm64
HID host TRY host pinot0: NEEDFLAG purpose-test
HID host TRY host pinot0: NEEDFLAG suite-bookworm
HID host TRY host pinot0: NEEDFLAG arch-arm64
HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-gleizes:
HID host TRY host cubietruck-gleizes: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-test
HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-gleizes: NEEDFLAG arch-arm64
HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host godello0:
HID host TRY host godello0: NEEDFLAG arch-xen-arm64
HID host TRY host godello0: NEEDFLAG purpose-test
HID host TRY host godello0: NEEDFLAG suite-bookworm
HID host TRY host godello0: NEEDFLAG arch-arm64
HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host pinot1:
HID host TRY host pinot1: NEEDFLAG arch-xen-arm64
HID host TRY host pinot1: NEEDFLAG purpose-test
HID host TRY host pinot1: NEEDFLAG suite-bookworm
HID host TRY host pinot1: NEEDFLAG arch-arm64
HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host fiano0:
HID host TRY host fiano0: NEEDFLAG arch-xen-arm64
HID host TRY host fiano0: NEEDFLAG purpose-test
HID host TRY host fiano0: NEEDFLAG suite-bookworm
HID host TRY host fiano0: NEEDFLAG arch-arm64
HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host fiano1:
HID host TRY host fiano1: NEEDFLAG arch-xen-arm64
HID host TRY host fiano1: NEEDFLAG purpose-test
HID host TRY host fiano1: NEEDFLAG suite-bookworm
HID host TRY host fiano1: NEEDFLAG arch-arm64
HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host italia0:
HID host TRY host italia0: NEEDFLAG arch-xen-arm64
HID host TRY host italia0: NEEDFLAG purpose-test
HID host TRY host italia0: NEEDFLAG suite-bookworm
HID host TRY host italia0: NEEDFLAG arch-arm64
HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host godello1:
HID host TRY host godello1: NEEDFLAG arch-xen-arm64
HID host TRY host godello1: NEEDFLAG purpose-test
HID host TRY host godello1: NEEDFLAG suite-bookworm
HID host TRY host godello1: NEEDFLAG arch-arm64
HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-braque:
HID host TRY host cubietruck-braque: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-braque: NEEDFLAG purpose-test
HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-braque: NEEDFLAG arch-arm64
HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host cubietruck-metzinger:
HID host TRY host cubietruck-metzinger: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-test
HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-metzinger: NEEDFLAG arch-arm64
HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host albana0:
HID host TRY host albana0: NEEDFLAG arch-xen-arm64
HID host TRY host albana0: NEEDFLAG purpose-test
HID host TRY host albana0: NEEDFLAG suite-bookworm
HID host TRY host albana0: NEEDFLAG arch-arm64
HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host albana1:
HID host TRY host albana1: NEEDFLAG arch-xen-arm64
HID host TRY host albana1: NEEDFLAG purpose-test
HID host TRY host albana1: NEEDFLAG suite-bookworm
HID host TRY host albana1: NEEDFLAG arch-arm64
HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host cubietruck-picasso:
HID host TRY host cubietruck-picasso: NEEDFLAG arch-xen-arm64
HID host TRY host cubietruck-picasso: NEEDFLAG purpose-test
HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm
HID host TRY host cubietruck-picasso: NEEDFLAG arch-arm64
HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host rochester0:
HID host TRY host rochester0: NEEDFLAG arch-xen-arm64
HID host TRY host rochester0: NEEDFLAG purpose-test
HID host TRY host rochester0: NEEDFLAG suite-bookworm
HID host TRY host rochester0: NEEDFLAG arch-arm64
HID host TRY host rochester0: FLAGS MISSINGFLAGS: .
HID host TRY host rochester0: GOOD
HID host TRY host rochester0: EQUIV-MOST-RECENT 186588.test-arm64-arm64-examine rochester1 pass.
HID host TRY host rochester0: SharedMaxWear (shared max wear) FROM-DEFAULT <undef>
HID host TRY host rochester0: SharedMaxTasks (shared max tasks) FROM-DEFAULT <undef>
HID host TRY host rochester0: CANDIDATE.
HID host TRY host rochester1:
HID host TRY host rochester1: NEEDFLAG arch-xen-arm64
HID host TRY host rochester1: NEEDFLAG purpose-test
HID host TRY host rochester1: NEEDFLAG suite-bookworm
HID host TRY host rochester1: NEEDFLAG arch-arm64
HID host TRY host rochester1: FLAGS MISSINGFLAGS: .
HID host TRY host rochester1: GOOD
HID host TRY host rochester1: EQUIV-MOST-RECENT 186588.test-arm64-arm64-examine rochester1 pass.
HID host TRY host rochester1: SharedMaxWear (shared max wear) FROM-DEFAULT <undef>
HID host TRY host rochester1: SharedMaxTasks (shared max tasks) FROM-DEFAULT <undef>
HID host TRY host rochester1: CANDIDATE.
HID host TRY host debina0:
HID host TRY host debina0: NEEDFLAG arch-xen-arm64
HID host TRY host debina0: NEEDFLAG purpose-test
HID host TRY host debina0: NEEDFLAG suite-bookworm
HID host TRY host debina0: NEEDFLAG arch-arm64
HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host debina1:
HID host TRY host debina1: NEEDFLAG arch-xen-arm64
HID host TRY host debina1: NEEDFLAG purpose-test
HID host TRY host debina1: NEEDFLAG suite-bookworm
HID host TRY host debina1: NEEDFLAG arch-arm64
HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host huxelrebe0:
HID host TRY host huxelrebe0: NEEDFLAG arch-xen-arm64
HID host TRY host huxelrebe0: NEEDFLAG purpose-test
HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm
HID host TRY host huxelrebe0: NEEDFLAG arch-arm64
HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host huxelrebe1:
HID host TRY host huxelrebe1: NEEDFLAG arch-xen-arm64
HID host TRY host huxelrebe1: NEEDFLAG purpose-test
HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm
HID host TRY host huxelrebe1: NEEDFLAG arch-arm64
HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host sabro0:
HID host TRY host sabro0: NEEDFLAG arch-xen-arm64
HID host TRY host sabro0: NEEDFLAG purpose-test
HID host TRY host sabro0: NEEDFLAG suite-bookworm
HID host TRY host sabro0: NEEDFLAG arch-arm64
HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host rimava0:
HID host TRY host rimava0: NEEDFLAG arch-xen-arm64
HID host TRY host rimava0: NEEDFLAG purpose-test
HID host TRY host rimava0: NEEDFLAG suite-bookworm
HID host TRY host rimava0: NEEDFLAG arch-arm64
HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host rimava1:
HID host TRY host rimava1: NEEDFLAG arch-xen-arm64
HID host TRY host rimava1: NEEDFLAG purpose-test
HID host TRY host rimava1: NEEDFLAG suite-bookworm
HID host TRY host rimava1: NEEDFLAG arch-arm64
HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-lakeside:
HID host TRY host arndale-lakeside: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-lakeside: NEEDFLAG purpose-test
HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm
HID host TRY host arndale-lakeside: NEEDFLAG arch-arm64
HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-metrocentre:
HID host TRY host arndale-metrocentre: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-metrocentre: NEEDFLAG purpose-test
HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm
HID host TRY host arndale-metrocentre: NEEDFLAG arch-arm64
HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host arndale-westfield:
HID host TRY host arndale-westfield: NEEDFLAG arch-xen-arm64
HID host TRY host arndale-westfield: NEEDFLAG purpose-test
HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm
HID host TRY host arndale-westfield: NEEDFLAG arch-arm64
HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host himrod0:
HID host TRY host himrod0: NEEDFLAG arch-xen-arm64
HID host TRY host himrod0: NEEDFLAG purpose-test
HID host TRY host himrod0: NEEDFLAG suite-bookworm
HID host TRY host himrod0: NEEDFLAG arch-arm64
HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nocera0:
HID host TRY host nocera0: NEEDFLAG arch-xen-arm64
HID host TRY host nocera0: NEEDFLAG purpose-test
HID host TRY host nocera0: NEEDFLAG suite-bookworm
HID host TRY host nocera0: NEEDFLAG arch-arm64
HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nocera1:
HID host TRY host nocera1: NEEDFLAG arch-xen-arm64
HID host TRY host nocera1: NEEDFLAG purpose-test
HID host TRY host nocera1: NEEDFLAG suite-bookworm
HID host TRY host nocera1: NEEDFLAG arch-arm64
HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host himrod1:
HID host TRY host himrod1: NEEDFLAG arch-xen-arm64
HID host TRY host himrod1: NEEDFLAG purpose-test
HID host TRY host himrod1: NEEDFLAG suite-bookworm
HID host TRY host himrod1: NEEDFLAG arch-arm64
HID host TRY host himrod1: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host himrod2:
HID host TRY host himrod2: NEEDFLAG arch-xen-arm64
HID host TRY host himrod2: NEEDFLAG purpose-test
HID host TRY host himrod2: NEEDFLAG suite-bookworm
HID host TRY host himrod2: NEEDFLAG arch-arm64
HID host TRY host himrod2: FLAGS MISSINGFLAGS: arch-xen-arm64 purpose-test arch-arm64.
HID host TRY host sabro1:
HID host TRY host sabro1: NEEDFLAG arch-xen-arm64
HID host TRY host sabro1: NEEDFLAG purpose-test
HID host TRY host sabro1: NEEDFLAG suite-bookworm
HID host TRY host sabro1: NEEDFLAG arch-arm64
HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nobling0:
HID host TRY host nobling0: NEEDFLAG arch-xen-arm64
HID host TRY host nobling0: NEEDFLAG purpose-test
HID host TRY host nobling0: NEEDFLAG suite-bookworm
HID host TRY host nobling0: NEEDFLAG arch-arm64
HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host nobling1:
HID host TRY host nobling1: NEEDFLAG arch-xen-arm64
HID host TRY host nobling1: NEEDFLAG purpose-test
HID host TRY host nobling1: NEEDFLAG suite-bookworm
HID host TRY host nobling1: NEEDFLAG arch-arm64
HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host italia1:
HID host TRY host italia1: NEEDFLAG arch-xen-arm64
HID host TRY host italia1: NEEDFLAG purpose-test
HID host TRY host italia1: NEEDFLAG suite-bookworm
HID host TRY host italia1: NEEDFLAG arch-arm64
HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host septiner0:
HID host TRY host septiner0: NEEDFLAG arch-xen-arm64
HID host TRY host septiner0: NEEDFLAG purpose-test
HID host TRY host septiner0: NEEDFLAG suite-bookworm
HID host TRY host septiner0: NEEDFLAG arch-arm64
HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
HID host TRY host septiner1:
HID host TRY host septiner1: NEEDFLAG arch-xen-arm64
HID host TRY host septiner1: NEEDFLAG purpose-test
HID host TRY host septiner1: NEEDFLAG suite-bookworm
HID host TRY host septiner1: NEEDFLAG arch-arm64
HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-xen-arm64 arch-arm64.
ORDER host
RECURSE  host...
RECURSE  CAND host rochester0
RECURSE    EVAL host rochester0
RECURSE    EVAL DURATION 1891 va=162571
RECURSE    PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0
RECURSE    PLAN LOOP   OVERLAP
RECURSE    PLAN LOOP   OVERLAP AVAIL OK
RECURSE    PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0
RECURSE    PLAN LOOP   SHARE-COMPAT-OK type build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c vs. <undef> wear 4 shares 3 vs. <undef>
RECURSE    FINAL start=0 va=162571 variation_bonus=7620.11098566169 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-7620.11098566169
RECURSE    FINAL BEST: host rochester0
RECURSE  CAND host rochester1
RECURSE    EVAL host rochester1
RECURSE    EVAL DURATION 1954 va=90681
RECURSE    PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0
RECURSE    PLAN LOOP   OVERLAP
RECURSE    PLAN LOOP   OVERLAP BAD 4440
RECURSE    PLAN LOOP reqs[0]=host evtix=1 try=4440 confirmed=0
RECURSE    PLAN LOOP reqs[0]=host evtix=2 try=4440 confirmed=0
RECURSE    PLAN LOOP   OVERLAP
RECURSE    PLAN LOOP   OVERLAP AVAIL OK
RECURSE    PLAN NEXT reqs[0]=host try=4440 confirmed=0 reuse=0
RECURSE    PLAN LOOP   SHARE-COMPAT-OK type test-186613-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c vs. <undef> wear 1 shares 1 vs. <undef>
RECURSE    FINAL start=4440 va=90681 variation_bonus=5166.86097026238 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-726.86097026238
host host rochester0 ALLOC PLAIN 0 (3, 2)
host host rochester0 ALLOC ISSHARED build-bookworm-arm64 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c ready 0 4 7c0ac0107f375ee5fca9996608abb4d6d1c12c8c
host host rochester0 ALLOC ISSHARED CAN-UNSHARE
HID host ALLOC host rochester0 0
HID host GO host rochester0 0 UNSHARE
2024-07-01 03:03:30 Z allocating for host: host rochester0 
HID host GO host rochester0 0 ALLOCATE
2024-07-01 03:03:30 Z host allocation: successful, reporting to planner. 
2024-07-01 03:03:30 Z resource allocation: booking @0 host rochester0 [host]. 
bookings = {"Bookings":[{"Job":"186613.test-arm64-arm64-examine","Xinfo":"host","End":1891,"Start":"0","Reso":"host rochester0","Allocated":{"Shareix":"0","Task":"2506090"}}],"ClientNotes":{}}
2024-07-01 03:03:30 Z resource allocation: we are in the plan. 
2024-07-01 03:03:30 Z resource allocation: successful. 
2024-07-01 03:03:30 Z runvar store: host=rochester0 
2024-07-01 03:03:30 Z host allocation: all successful and recorded.