2024-09-30 03:31:12 Z flight 187899 intended real branch xen-unstable 2024-09-30 03:31:12 Z job 187899.build-arm64-libvirt recipe build-libvirt 2024-09-30 03:31:12 Z hostalloc_maxwait_starvation: A=1 B=1.81295229035573 C=1.3 I=3600 L=198.7 Xh=200 Xt=5 HID host FLAGS share-build-bookworm-arm64 arch-arm64 suite-bookworm purpose-build HID host FLAG share-build-bookworm-arm64 HID host FLAG share-build-bookworm-arm64 SHARE build-bookworm-arm64 3 10 HID host FLAG arch-arm64 HID host FLAG suite-bookworm HID host FLAG purpose-build HID host FLAGS arch-arm64,purpose-build,suite-bookworm + 0 host conditions(s) 2024-09-30 03:31:12 Z pre-checking resources... 2024-09-30 03:31:12 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-arm64 HID host TRY host pinot0: NEEDFLAG suite-bookworm HID host TRY host pinot0: NEEDFLAG purpose-build HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-gleizes: HID host TRY host cubietruck-gleizes: NEEDFLAG arch-arm64 HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-build HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host godello0: HID host TRY host godello0: NEEDFLAG arch-arm64 HID host TRY host godello0: NEEDFLAG suite-bookworm HID host TRY host godello0: NEEDFLAG purpose-build HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host pinot1: HID host TRY host pinot1: NEEDFLAG arch-arm64 HID host TRY host pinot1: NEEDFLAG suite-bookworm HID host TRY host pinot1: NEEDFLAG purpose-build HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host fiano0: HID host TRY host fiano0: NEEDFLAG arch-arm64 HID host TRY host fiano0: NEEDFLAG suite-bookworm HID host TRY host fiano0: NEEDFLAG purpose-build HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host fiano1: HID host TRY host fiano1: NEEDFLAG arch-arm64 HID host TRY host fiano1: NEEDFLAG suite-bookworm HID host TRY host fiano1: NEEDFLAG purpose-build HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host italia0: HID host TRY host italia0: NEEDFLAG arch-arm64 HID host TRY host italia0: NEEDFLAG suite-bookworm HID host TRY host italia0: NEEDFLAG purpose-build HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host godello1: HID host TRY host godello1: NEEDFLAG arch-arm64 HID host TRY host godello1: NEEDFLAG suite-bookworm HID host TRY host godello1: NEEDFLAG purpose-build HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-braque: HID host TRY host cubietruck-braque: NEEDFLAG arch-arm64 HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm HID host TRY host cubietruck-braque: NEEDFLAG purpose-build HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-metzinger: HID host TRY host cubietruck-metzinger: NEEDFLAG arch-arm64 HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-build HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host albana0: HID host TRY host albana0: NEEDFLAG arch-arm64 HID host TRY host albana0: NEEDFLAG suite-bookworm HID host TRY host albana0: NEEDFLAG purpose-build HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host albana1: HID host TRY host albana1: NEEDFLAG arch-arm64 HID host TRY host albana1: NEEDFLAG suite-bookworm HID host TRY host albana1: NEEDFLAG purpose-build HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-picasso: HID host TRY host cubietruck-picasso: NEEDFLAG arch-arm64 HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm HID host TRY host cubietruck-picasso: NEEDFLAG purpose-build HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rochester0: HID host TRY host rochester0: NEEDFLAG arch-arm64 HID host TRY host rochester0: NEEDFLAG suite-bookworm HID host TRY host rochester0: NEEDFLAG purpose-build HID host TRY host rochester0: FLAGS MISSINGFLAGS: . HID host TRY host rochester0: GOOD DUR xen-unstable real build-arm64-libvirt host rochester0 SAME-HOST GOT 9 DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187892 DURATION 253 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187861 DURATION 233 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187851 DURATION 254 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187839 DURATION 301 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187818 DURATION 261 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187788 DURATION 279 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187769 DURATION 288 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187737 DURATION 259 pass DUR xen-unstable real build-arm64-libvirt host rochester0 REF 187727 DURATION 230 pass HID host TRY host rochester0: EQUIV-MOST-RECENT 187892.build-arm64-libvirt rochester0 pass. HID host TRY host rochester0: SharedMaxWear (shared max wear) FROM-DEFAULT 10 HID host TRY host rochester0: SharedMaxTasks (shared max tasks) FROM-DEFAULT 3 HID host TRY host rochester0: CANDIDATE. HID host TRY host rochester1: HID host TRY host rochester1: NEEDFLAG arch-arm64 HID host TRY host rochester1: NEEDFLAG suite-bookworm HID host TRY host rochester1: NEEDFLAG purpose-build HID host TRY host rochester1: FLAGS MISSINGFLAGS: . HID host TRY host rochester1: GOOD DUR xen-unstable real build-arm64-libvirt host rochester1 SAME-HOST GOT 8 DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187884 DURATION 282 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187869 DURATION 268 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187831 DURATION 285 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187806 DURATION 279 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187794 DURATION 252 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187754 DURATION 282 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187747 DURATION 318 pass DUR xen-unstable real build-arm64-libvirt host rochester1 REF 187730 DURATION 303 pass HID host TRY host rochester1: EQUIV-MOST-RECENT 187892.build-arm64-libvirt rochester0 pass. HID host TRY host rochester1: SharedMaxWear (shared max wear) FROM-DEFAULT 10 HID host TRY host rochester1: SharedMaxTasks (shared max tasks) FROM-DEFAULT 3 HID host TRY host rochester1: CANDIDATE. HID host TRY host debina0: HID host TRY host debina0: NEEDFLAG arch-arm64 HID host TRY host debina0: NEEDFLAG suite-bookworm HID host TRY host debina0: NEEDFLAG purpose-build HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host debina1: HID host TRY host debina1: NEEDFLAG arch-arm64 HID host TRY host debina1: NEEDFLAG suite-bookworm HID host TRY host debina1: NEEDFLAG purpose-build HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host huxelrebe0: HID host TRY host huxelrebe0: NEEDFLAG arch-arm64 HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm HID host TRY host huxelrebe0: NEEDFLAG purpose-build HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host huxelrebe1: HID host TRY host huxelrebe1: NEEDFLAG arch-arm64 HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm HID host TRY host huxelrebe1: NEEDFLAG purpose-build HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host sabro0: HID host TRY host sabro0: NEEDFLAG arch-arm64 HID host TRY host sabro0: NEEDFLAG suite-bookworm HID host TRY host sabro0: NEEDFLAG purpose-build HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rimava0: HID host TRY host rimava0: NEEDFLAG arch-arm64 HID host TRY host rimava0: NEEDFLAG suite-bookworm HID host TRY host rimava0: NEEDFLAG purpose-build HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rimava1: HID host TRY host rimava1: NEEDFLAG arch-arm64 HID host TRY host rimava1: NEEDFLAG suite-bookworm HID host TRY host rimava1: NEEDFLAG purpose-build HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host arndale-lakeside: HID host TRY host arndale-lakeside: NEEDFLAG arch-arm64 HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm HID host TRY host arndale-lakeside: NEEDFLAG purpose-build HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host arndale-metrocentre: HID host TRY host arndale-metrocentre: NEEDFLAG arch-arm64 HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm HID host TRY host arndale-metrocentre: NEEDFLAG purpose-build HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host arndale-westfield: HID host TRY host arndale-westfield: NEEDFLAG arch-arm64 HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm HID host TRY host arndale-westfield: NEEDFLAG purpose-build HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host himrod0: HID host TRY host himrod0: NEEDFLAG arch-arm64 HID host TRY host himrod0: NEEDFLAG suite-bookworm HID host TRY host himrod0: NEEDFLAG purpose-build HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nocera0: HID host TRY host nocera0: NEEDFLAG arch-arm64 HID host TRY host nocera0: NEEDFLAG suite-bookworm HID host TRY host nocera0: NEEDFLAG purpose-build HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nocera1: HID host TRY host nocera1: NEEDFLAG arch-arm64 HID host TRY host nocera1: NEEDFLAG suite-bookworm HID host TRY host nocera1: NEEDFLAG purpose-build HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host himrod1: HID host TRY host himrod1: NEEDFLAG arch-arm64 HID host TRY host himrod1: NEEDFLAG suite-bookworm HID host TRY host himrod1: NEEDFLAG purpose-build HID host TRY host himrod1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host himrod2: HID host TRY host himrod2: NEEDFLAG arch-arm64 HID host TRY host himrod2: NEEDFLAG suite-bookworm HID host TRY host himrod2: NEEDFLAG purpose-build HID host TRY host himrod2: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host sabro1: HID host TRY host sabro1: NEEDFLAG arch-arm64 HID host TRY host sabro1: NEEDFLAG suite-bookworm HID host TRY host sabro1: NEEDFLAG purpose-build HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nobling0: HID host TRY host nobling0: NEEDFLAG arch-arm64 HID host TRY host nobling0: NEEDFLAG suite-bookworm HID host TRY host nobling0: NEEDFLAG purpose-build HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nobling1: HID host TRY host nobling1: NEEDFLAG arch-arm64 HID host TRY host nobling1: NEEDFLAG suite-bookworm HID host TRY host nobling1: NEEDFLAG purpose-build HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host italia1: HID host TRY host italia1: NEEDFLAG arch-arm64 HID host TRY host italia1: NEEDFLAG suite-bookworm HID host TRY host italia1: NEEDFLAG purpose-build HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host septiner0: HID host TRY host septiner0: NEEDFLAG arch-arm64 HID host TRY host septiner0: NEEDFLAG suite-bookworm HID host TRY host septiner0: NEEDFLAG purpose-build HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host septiner1: HID host TRY host septiner1: NEEDFLAG arch-arm64 HID host TRY host septiner1: NEEDFLAG suite-bookworm HID host TRY host septiner1: NEEDFLAG purpose-build HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-arm64. ORDER host RECURSE host... RECURSE CAND host rochester0 RECURSE EVAL host rochester0 RECURSE EVAL DURATION 311 va=92148 RECURSE PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0 RECURSE FINAL start=0 va=0 variation_bonus=0 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=311 RECURSE FINAL BEST: host rochester0 RECURSE CAND host rochester1 RECURSE EVAL host rochester1 RECURSE EVAL DURATION 328 va=178714 RECURSE PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0 RECURSE FINAL start=0 va=0 variation_bonus=0 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=328 2024-09-30 03:31:36 Z resource allocation: starting... 2024-09-30 03:31:36 Z resource allocation: awaiting our slot... 2024-09-30 03:32:05 Z resource allocation: obtained base plan. base plan = {"ClientNotes":{},"Events":{"host sabro1":[{"Job":"187899.test-amd64-amd64-qemuu-freebsd12-amd64","Time":-2811,"Type":"Start","Share":{"Wear":1,"Shares":"1","Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0},{"Job":"187899.test-amd64-amd64-qemuu-freebsd12-amd64","Time":971,"Share":{"Shares":1,"Wear":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"End","Avail":1},{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":971,"Avail":1}],"host himrod1":[{"Time":0,"PreviousShare":{"Shares":3,"Wear":10,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Avail":1}],"host nobling0":[{"Avail":0,"Job":"187898.test-amd64-amd64-libvirt-vhd","Time":-948,"Share":{"Wear":1,"Shares":"1","Type":"test-187898-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Start"},{"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187898-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187898.test-amd64-amd64-libvirt-vhd","Time":3656,"Avail":1},{"Avail":1,"Time":3656,"PreviousShare":{"Shares":"1","Wear":1,"Type":"test-187898-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare"}],"host himrod0":[{"Avail":0,"Time":-1473,"Job":"187898.test-amd64-amd64-xl-pvhv2-intel","Share":{"Shares":"1","Wear":1,"Type":"test-187898-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Start"},{"Time":1196,"Job":"187898.test-amd64-amd64-xl-pvhv2-intel","Share":{"Type":"test-187898-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Type":"End","Avail":1},{"Avail":1,"PreviousShare":{"Type":"test-187898-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Time":1196,"Type":"Unshare"}],"host fiano0":[{"Avail":0,"Job":"187899.test-amd64-amd64-pair","Time":-647,"Type":"Start","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}},{"Avail":1,"Type":"End","Share":{"Wear":1,"Shares":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-pair","Time":2168},{"Avail":1,"Type":"Unshare","PreviousShare":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Time":2168}],"host nocera0":[{"Avail":0,"Type":"Start","Time":-28745490},{"Time":604800,"Type":"End","Avail":1}],"host sabro0":[{"Type":"Start","Share":{"Type":"test-187899-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Time":-2811,"Avail":0},{"Avail":1,"Job":"187899.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Time":2945,"Share":{"Type":"test-187899-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Type":"End"},{"Type":"Unshare","Time":2945,"PreviousShare":{"Type":"test-187899-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":1}],"host huxelrebe0":[{"Job":"187898.test-amd64-amd64-libvirt-raw","Time":-2186,"Share":{"Type":"test-187898-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Start","Avail":0},{"Job":"187898.test-amd64-amd64-libvirt-raw","Time":222,"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187898-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1},{"Type":"Unshare","PreviousShare":{"Shares":"1","Wear":1,"Type":"test-187898-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":222,"Avail":1}],"host huxelrebe1":[{"Time":-4093,"Job":"187899.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm","Share":{"Type":"test-187899-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Start","Avail":0},{"Avail":1,"Share":{"Shares":1,"Wear":1,"Type":"test-187899-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"End","Time":1306,"Job":"187899.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm"},{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":1306,"Avail":1}],"host verdesse0":[{"Avail":0,"Time":-26573439,"Type":"Start"},{"Time":604800,"Type":"End","Avail":1}],"host laxton1":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Shares":3,"Wear":1,"Type":"build-buster-arm64 cb303068d340f3344c760df46ac9785e08c0d889"},"Time":0}],"host fiano1":[{"Type":"Start","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.test-amd64-amd64-pair","Time":-647,"Avail":0},{"Avail":1,"Type":"End","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Time":2168,"Job":"187899.test-amd64-amd64-pair"},{"Avail":1,"Time":2168,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare"}],"host cubietruck-gleizes":[{"Avail":0,"Type":"Start","Share":{"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.build-armhf","Time":-54},{"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":6746,"Job":"187899.build-armhf","Avail":1},{"Avail":1,"Type":"Unshare","PreviousShare":{"Shares":"1","Wear":1,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":6746}],"host godello1":[{"Avail":0,"Share":{"Shares":"1","Wear":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Start","Job":"187899.test-amd64-amd64-xl-vhd","Time":-3435},{"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-xl-vhd","Time":1275,"Avail":1},{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":1275,"Avail":1}],"host rubintos1":[{"Avail":0,"Type":"Start","Time":-25977653},{"Time":604800,"Type":"End","Avail":1}],"host joubertin1":[{"Avail":0,"Time":-34859567,"Type":"Start"},{"Type":"End","Time":604800,"Avail":1}],"host nocera1":[{"Avail":0,"Time":-28745490,"Type":"Start"},{"Avail":1,"Type":"End","Time":604800}],"host joubertin0":[{"Avail":0,"Time":-34859567,"Type":"Start"},{"Avail":1,"Type":"End","Time":604800}],"host septiner0":[{"Job":"187899.test-amd64-amd64-libvirt-pair","Time":-211,"Type":"Start","Share":{"Wear":1,"Shares":"1","Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0},{"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":2590,"Job":"187899.test-amd64-amd64-libvirt-pair","Avail":1},{"Type":"Unshare","Time":2590,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1}],"host cubietruck-metzinger":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":10,"Shares":1},"Time":0}],"host arndale-metrocentre":[{"Time":-3133,"Job":"187898.test-armhf-armhf-xl","Type":"Start","Share":{"Wear":1,"Shares":"1","Type":"test-187898-cDQI4bT8W7N-sTSSXe5EfboNwTzFke2Qj1ifzw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0},{"Time":244,"Job":"187898.test-armhf-armhf-xl","Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187898-cDQI4bT8W7N-sTSSXe5EfboNwTzFke2Qj1ifzw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1},{"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-cDQI4bT8W7N-sTSSXe5EfboNwTzFke2Qj1ifzw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":244,"Type":"Unshare","Avail":1}],"host debina1":[{"Avail":0,"Type":"Start","Share":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.test-amd64-amd64-migrupgrade","Time":-1131},{"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-migrupgrade","Time":1020,"Avail":1},{"Type":"Unshare","Time":1020,"PreviousShare":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":1}],"host albana1":[{"Job":"187899.test-xtf-amd64-amd64-4","Time":-1006,"Share":{"Type":"test-187899-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Start","Avail":0},{"Job":"187899.test-xtf-amd64-amd64-4","Time":911,"Share":{"Type":"test-187899-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Type":"End","Avail":1},{"Avail":1,"Type":"Unshare","Time":911,"PreviousShare":{"Type":"test-187899-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"}}],"host rimava1":[{"Job":"187898.test-amd64-amd64-xl-qemuu-debianhvm-amd64","Time":-2186,"Type":"Start","Share":{"Shares":"1","Wear":1,"Type":"test-187898-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0},{"Avail":1,"Job":"187898.test-amd64-amd64-xl-qemuu-debianhvm-amd64","Time":678,"Type":"End","Share":{"Type":"test-187898-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1}},{"Avail":1,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":678,"Type":"Unshare"}],"host cubietruck-braque":[{"Avail":1,"Time":0,"PreviousShare":{"Shares":1,"Wear":10,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare"}],"host pinot0":[{"Avail":0,"Time":-847,"Job":"187899.test-amd64-amd64-dom0pvh-xl-amd","Share":{"Wear":1,"Shares":"1","Type":"test-187899-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Start"},{"Type":"End","Share":{"Type":"test-187899-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Job":"187899.test-amd64-amd64-dom0pvh-xl-amd","Time":1799,"Avail":1},{"PreviousShare":{"Type":"test-187899-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Time":1799,"Type":"Unshare","Avail":1}],"host godello0":[{"PreviousShare":{"Type":"test-187899-jVi7QR2lpr8cB9dB6ob64BSlfjMVZ8Vm-gKO8Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Time":0,"Type":"Unshare","Avail":1}],"host arndale-westfield":[{"Job":"187898.test-armhf-armhf-xl-arndale","Time":-847,"Share":{"Type":"test-187898-4wm7sX_ZRUfi1_B4f2kxMvgAP-czx40wwPfaFg 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Type":"Start","Avail":0},{"Type":"End","Share":{"Type":"test-187898-4wm7sX_ZRUfi1_B4f2kxMvgAP-czx40wwPfaFg 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Job":"187898.test-armhf-armhf-xl-arndale","Time":2561,"Avail":1},{"Avail":1,"Time":2561,"PreviousShare":{"Type":"test-187898-4wm7sX_ZRUfi1_B4f2kxMvgAP-czx40wwPfaFg 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare"}],"host rochester1":[{"Time":-1720,"Job":"187898.test-arm64-arm64-xl","Type":"Start","Share":{"Type":"test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":0},{"Share":{"Type":"test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Type":"End","Time":1817,"Job":"187898.test-arm64-arm64-xl","Avail":1},{"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":1817,"Type":"Unshare","Avail":1}],"host himrod2":[{"Type":"Start","Share":{"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"3","Wear":1},"Job":"187901.build-amd64-pvops","Time":-1802,"Avail":2},{"Job":"187901.build-amd64","Time":-894,"Share":{"Shares":"3","Wear":2,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Start","Avail":1},{"Type":"End","Share":{"Shares":3,"Wear":2,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187901.build-amd64-pvops","Time":286,"Avail":2},{"Avail":3,"Job":"187901.build-amd64","Time":1160,"Type":"End","Share":{"Wear":2,"Shares":3,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Avail":1,"PreviousShare":{"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"3","Wear":2},"Time":1160,"Type":"Unshare"}],"host espadeiro1":[{"Avail":0,"Time":-3422029,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host arndale-lakeside":[{"Avail":0,"Type":"Start","Share":{"Type":"test-187898-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Time":-3195,"Job":"187898.test-armhf-armhf-xl-qcow2"},{"Time":1176,"Job":"187898.test-armhf-armhf-xl-qcow2","Type":"End","Share":{"Type":"test-187898-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Avail":1},{"Time":1176,"PreviousShare":{"Type":"test-187898-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare","Avail":1}],"host chardonnay0":[{"Avail":1,"Type":"Unshare","Time":0,"PreviousShare":{"Type":"build-bookworm-amd64 3ed6e92c6e8d51a06b9010da794d4eda53ff543e","Wear":1,"Shares":3}}],"host debina0":[{"Time":-1131,"Job":"187899.test-amd64-amd64-migrupgrade","Type":"Start","Share":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":0},{"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":1020,"Job":"187899.test-amd64-amd64-migrupgrade","Avail":1},{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":1020,"Avail":1}],"host rimava0":[{"Avail":0,"Share":{"Shares":"1","Wear":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Start","Time":-211,"Job":"187899.test-amd64-amd64-qemuu-nested-amd"},{"Type":"End","Share":{"Wear":1,"Shares":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":7446,"Job":"187899.test-amd64-amd64-qemuu-nested-amd","Avail":1},{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":7446,"Avail":1}],"host albana0":[{"Avail":0,"Job":"187899.test-amd64-amd64-libvirt-vhd","Time":-340,"Type":"Start","Share":{"Wear":1,"Shares":"1","Type":"test-187899-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Job":"187899.test-amd64-amd64-libvirt-vhd","Time":4210,"Type":"End","Share":{"Shares":1,"Wear":1,"Type":"test-187899-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1},{"Avail":1,"Type":"Unshare","Time":4210,"PreviousShare":{"Type":"test-187899-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}}],"host espadeiro0":[{"Type":"Start","Time":-5058008,"Avail":0},{"Time":604800,"Type":"End","Avail":1}],"host rochester0":[{"Avail":2,"Type":"Start","Share":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"3"},"Job":"187899.build-arm64","Time":-2643},{"Avail":1,"Type":"Start","Share":{"Shares":"3","Wear":2,"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.build-arm64-pvops","Time":-847},{"Avail":0,"Type":"Start","Share":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"3","Wear":3},"Time":-847,"Job":"187899.build-arm64-xsm"},{"Avail":1,"Type":"End","Share":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":3,"Shares":3},"Job":"187899.build-arm64","Time":103},{"Share":{"Shares":3,"Wear":3,"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"End","Job":"187899.build-arm64-xsm","Time":1741,"Avail":2},{"Avail":3,"Time":3299,"Job":"187899.build-arm64-pvops","Type":"End","Share":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":3,"Wear":3}},{"Avail":1,"Type":"Unshare","PreviousShare":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":3,"Shares":"3"},"Time":3299}],"host pinot1":[{"Share":{"Type":"test-187898-AF0uFllYW3VCLA1if36p6RiGIJqCHumivjjojw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Type":"Start","Time":-2156,"Job":"187898.test-amd64-amd64-xl-credit2","Avail":0},{"Job":"187898.test-amd64-amd64-xl-credit2","Time":855,"Type":"End","Share":{"Type":"test-187898-AF0uFllYW3VCLA1if36p6RiGIJqCHumivjjojw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Avail":1},{"Avail":1,"Time":855,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-AF0uFllYW3VCLA1if36p6RiGIJqCHumivjjojw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare"}],"host rubintos0":[{"Avail":0,"Time":-25977653,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host italia0":[{"Avail":0,"Share":{"Type":"test-187899-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Type":"Start","Job":"187899.test-amd64-amd64-xl","Time":-54},{"Avail":1,"Time":2913,"Job":"187899.test-amd64-amd64-xl","Share":{"Type":"test-187899-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Type":"End"},{"Avail":1,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":2913,"Type":"Unshare"}],"host septiner1":[{"Type":"Start","Share":{"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.test-amd64-amd64-libvirt-pair","Time":-211,"Avail":0},{"Type":"End","Share":{"Wear":1,"Shares":1,"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-libvirt-pair","Time":2590,"Avail":1},{"Avail":1,"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":2590}],"host nobling1":[{"Type":"Start","Share":{"Type":"test-187900-mrSxrL_vQ43E5JhU9pxjn69yQUYCPi5_4jLdDw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Time":-1967,"Job":"187900.test-amd64-amd64-xl-qemut-debianhvm-i386-xsm","Avail":0},{"Type":"End","Share":{"Type":"test-187900-mrSxrL_vQ43E5JhU9pxjn69yQUYCPi5_4jLdDw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Time":2042,"Job":"187900.test-amd64-amd64-xl-qemut-debianhvm-i386-xsm","Avail":1},{"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187900-mrSxrL_vQ43E5JhU9pxjn69yQUYCPi5_4jLdDw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":2042,"Type":"Unshare","Avail":1}],"host italia1":[{"Job":"187899.test-amd64-amd64-examine","Time":-285,"Type":"Start","Avail":0},{"Time":4959,"Job":"187899.test-amd64-amd64-examine","Type":"End","Avail":1}],"host verdesse1":[{"Type":"Start","Time":-5661881,"Avail":0},{"Avail":1,"Type":"End","Time":604800}]},"Start":1727667125} 2024-09-30 03:32:05 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-arm64 HID host TRY host pinot0: NEEDFLAG suite-bookworm HID host TRY host pinot0: NEEDFLAG purpose-build HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-gleizes: HID host TRY host cubietruck-gleizes: NEEDFLAG arch-arm64 HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-build HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host godello0: HID host TRY host godello0: NEEDFLAG arch-arm64 HID host TRY host godello0: NEEDFLAG suite-bookworm HID host TRY host godello0: NEEDFLAG purpose-build HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host pinot1: HID host TRY host pinot1: NEEDFLAG arch-arm64 HID host TRY host pinot1: NEEDFLAG suite-bookworm HID host TRY host pinot1: NEEDFLAG purpose-build HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host fiano0: HID host TRY host fiano0: NEEDFLAG arch-arm64 HID host TRY host fiano0: NEEDFLAG suite-bookworm HID host TRY host fiano0: NEEDFLAG purpose-build HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host fiano1: HID host TRY host fiano1: NEEDFLAG arch-arm64 HID host TRY host fiano1: NEEDFLAG suite-bookworm HID host TRY host fiano1: NEEDFLAG purpose-build HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host italia0: HID host TRY host italia0: NEEDFLAG arch-arm64 HID host TRY host italia0: NEEDFLAG suite-bookworm HID host TRY host italia0: NEEDFLAG purpose-build HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host godello1: HID host TRY host godello1: NEEDFLAG arch-arm64 HID host TRY host godello1: NEEDFLAG suite-bookworm HID host TRY host godello1: NEEDFLAG purpose-build HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-braque: HID host TRY host cubietruck-braque: NEEDFLAG arch-arm64 HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm HID host TRY host cubietruck-braque: NEEDFLAG purpose-build HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-metzinger: HID host TRY host cubietruck-metzinger: NEEDFLAG arch-arm64 HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-build HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host albana0: HID host TRY host albana0: NEEDFLAG arch-arm64 HID host TRY host albana0: NEEDFLAG suite-bookworm HID host TRY host albana0: NEEDFLAG purpose-build HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host albana1: HID host TRY host albana1: NEEDFLAG arch-arm64 HID host TRY host albana1: NEEDFLAG suite-bookworm HID host TRY host albana1: NEEDFLAG purpose-build HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-picasso: HID host TRY host cubietruck-picasso: NEEDFLAG arch-arm64 HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm HID host TRY host cubietruck-picasso: NEEDFLAG purpose-build HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rochester0: HID host TRY host rochester0: NEEDFLAG arch-arm64 HID host TRY host rochester0: NEEDFLAG suite-bookworm HID host TRY host rochester0: NEEDFLAG purpose-build HID host TRY host rochester0: FLAGS MISSINGFLAGS: . HID host TRY host rochester0: GOOD HID host TRY host rochester0: EQUIV-MOST-RECENT 187892.build-arm64-libvirt rochester0 pass. HID host TRY host rochester0: SharedMaxWear (shared max wear) FROM-DEFAULT 10 HID host TRY host rochester0: SharedMaxTasks (shared max tasks) FROM-DEFAULT 3 HID host TRY host rochester0: CANDIDATE. HID host TRY host rochester1: HID host TRY host rochester1: NEEDFLAG arch-arm64 HID host TRY host rochester1: NEEDFLAG suite-bookworm HID host TRY host rochester1: NEEDFLAG purpose-build HID host TRY host rochester1: FLAGS MISSINGFLAGS: . HID host TRY host rochester1: GOOD HID host TRY host rochester1: EQUIV-MOST-RECENT 187892.build-arm64-libvirt rochester0 pass. HID host TRY host rochester1: SharedMaxWear (shared max wear) FROM-DEFAULT 10 HID host TRY host rochester1: SharedMaxTasks (shared max tasks) FROM-DEFAULT 3 HID host TRY host rochester1: CANDIDATE. HID host TRY host debina0: HID host TRY host debina0: NEEDFLAG arch-arm64 HID host TRY host debina0: NEEDFLAG suite-bookworm HID host TRY host debina0: NEEDFLAG purpose-build HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host debina1: HID host TRY host debina1: NEEDFLAG arch-arm64 HID host TRY host debina1: NEEDFLAG suite-bookworm HID host TRY host debina1: NEEDFLAG purpose-build HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host huxelrebe0: HID host TRY host huxelrebe0: NEEDFLAG arch-arm64 HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm HID host TRY host huxelrebe0: NEEDFLAG purpose-build HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host huxelrebe1: HID host TRY host huxelrebe1: NEEDFLAG arch-arm64 HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm HID host TRY host huxelrebe1: NEEDFLAG purpose-build HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host sabro0: HID host TRY host sabro0: NEEDFLAG arch-arm64 HID host TRY host sabro0: NEEDFLAG suite-bookworm HID host TRY host sabro0: NEEDFLAG purpose-build HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rimava0: HID host TRY host rimava0: NEEDFLAG arch-arm64 HID host TRY host rimava0: NEEDFLAG suite-bookworm HID host TRY host rimava0: NEEDFLAG purpose-build HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rimava1: HID host TRY host rimava1: NEEDFLAG arch-arm64 HID host TRY host rimava1: NEEDFLAG suite-bookworm HID host TRY host rimava1: NEEDFLAG purpose-build HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host arndale-lakeside: HID host TRY host arndale-lakeside: NEEDFLAG arch-arm64 HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm HID host TRY host arndale-lakeside: NEEDFLAG purpose-build HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host arndale-metrocentre: HID host TRY host arndale-metrocentre: NEEDFLAG arch-arm64 HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm HID host TRY host arndale-metrocentre: NEEDFLAG purpose-build HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host arndale-westfield: HID host TRY host arndale-westfield: NEEDFLAG arch-arm64 HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm HID host TRY host arndale-westfield: NEEDFLAG purpose-build HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host himrod0: HID host TRY host himrod0: NEEDFLAG arch-arm64 HID host TRY host himrod0: NEEDFLAG suite-bookworm HID host TRY host himrod0: NEEDFLAG purpose-build HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nocera0: HID host TRY host nocera0: NEEDFLAG arch-arm64 HID host TRY host nocera0: NEEDFLAG suite-bookworm HID host TRY host nocera0: NEEDFLAG purpose-build HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nocera1: HID host TRY host nocera1: NEEDFLAG arch-arm64 HID host TRY host nocera1: NEEDFLAG suite-bookworm HID host TRY host nocera1: NEEDFLAG purpose-build HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host himrod1: HID host TRY host himrod1: NEEDFLAG arch-arm64 HID host TRY host himrod1: NEEDFLAG suite-bookworm HID host TRY host himrod1: NEEDFLAG purpose-build HID host TRY host himrod1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host himrod2: HID host TRY host himrod2: NEEDFLAG arch-arm64 HID host TRY host himrod2: NEEDFLAG suite-bookworm HID host TRY host himrod2: NEEDFLAG purpose-build HID host TRY host himrod2: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host sabro1: HID host TRY host sabro1: NEEDFLAG arch-arm64 HID host TRY host sabro1: NEEDFLAG suite-bookworm HID host TRY host sabro1: NEEDFLAG purpose-build HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nobling0: HID host TRY host nobling0: NEEDFLAG arch-arm64 HID host TRY host nobling0: NEEDFLAG suite-bookworm HID host TRY host nobling0: NEEDFLAG purpose-build HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nobling1: HID host TRY host nobling1: NEEDFLAG arch-arm64 HID host TRY host nobling1: NEEDFLAG suite-bookworm HID host TRY host nobling1: NEEDFLAG purpose-build HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host italia1: HID host TRY host italia1: NEEDFLAG arch-arm64 HID host TRY host italia1: NEEDFLAG suite-bookworm HID host TRY host italia1: NEEDFLAG purpose-build HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host septiner0: HID host TRY host septiner0: NEEDFLAG arch-arm64 HID host TRY host septiner0: NEEDFLAG suite-bookworm HID host TRY host septiner0: NEEDFLAG purpose-build HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host septiner1: HID host TRY host septiner1: NEEDFLAG arch-arm64 HID host TRY host septiner1: NEEDFLAG suite-bookworm HID host TRY host septiner1: NEEDFLAG purpose-build HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-arm64. ORDER host RECURSE host... RECURSE CAND host rochester0 RECURSE EVAL host rochester0 RECURSE EVAL DURATION 311 va=92177 RECURSE PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=1 try=0 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=2 try=0 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 103 RECURSE PLAN LOOP reqs[0]=host evtix=3 try=103 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP ESHARE RECURSE PLAN LOOP SHARE-COMPAT-OK type build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 3 shares 3 vs. 3 RECURSE PLAN LOOP SHARE-COMPAT-OK Y RECURSE PLAN LOOP OVERLAP AVAIL OK RECURSE PLAN LOOP reqs[0]=host evtix=4 try=103 confirmed=0 RECURSE PLAN NEXT reqs[0]=host try=103 confirmed=0 reuse=0 RECURSE PLAN LOOP SHARE-COMPAT-OK type build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 3 shares 3 vs. 3 RECURSE PLAN LOOP SHARE-COMPAT-OK Y RECURSE FINAL start=103 va=0 variation_bonus=0 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=1*20000 cost=-19586 RECURSE FINAL BEST: host rochester0 RECURSE CAND host rochester1 RECURSE EVAL host rochester1 RECURSE EVAL DURATION 328 va=178743 RECURSE PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 1817 RECURSE PLAN LOOP reqs[0]=host evtix=1 try=1817 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=2 try=1817 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP AVAIL OK RECURSE PLAN NEXT reqs[0]=host try=1817 confirmed=0 reuse=0 RECURSE PLAN LOOP SHARE-COMPAT-OK type test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 1 vs. 3 RECURSE FINAL start=1817 va=0 variation_bonus=0 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=2145 2024-09-30 03:32:05 Z host allocation: planned start in 103 seconds. most_optimistic: all: 103 (@0) most_optimistic: (period=3600): 103 (@0) not starving (class): no estimate 2024-09-30 03:32:05 Z resource allocation: booking @103 host rochester0 [host]. bookings = {"Bookings":[{"Job":"187899.build-arm64-libvirt","Share":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"3"},"Xinfo":"host","End":414,"Reso":"host rochester0","Start":"103"}],"ClientNotes":{}} 2024-09-30 03:32:05 Z resource allocation: we are in the plan. 2024-09-30 03:32:05 Z resource allocation: deferring 2024-09-30 03:32:05 Z resource allocation: awaiting our slot... 2024-09-30 03:32:50 Z resource allocation: obtained base plan. base plan = {"Start":1727667170,"Events":{"host cubietruck-braque":[{"PreviousShare":{"Wear":10,"Shares":1,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":0,"Type":"Unshare"}],"host debina0":[{"Avail":0,"Type":"Start","Time":-1176,"Share":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Job":"187899.test-amd64-amd64-migrupgrade"},{"Job":"187899.test-amd64-amd64-migrupgrade","Share":{"Shares":1,"Wear":1,"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Type":"End","Time":975},{"PreviousShare":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Avail":1,"Time":975,"Type":"Unshare"}],"host arndale-westfield":[{"Avail":0,"Type":"Start","Time":-892,"Share":{"Shares":"1","Wear":1,"Type":"test-187898-4wm7sX_ZRUfi1_B4f2kxMvgAP-czx40wwPfaFg 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187898.test-armhf-armhf-xl-arndale"},{"Time":2516,"Type":"End","Avail":1,"Share":{"Wear":1,"Shares":1,"Type":"test-187898-4wm7sX_ZRUfi1_B4f2kxMvgAP-czx40wwPfaFg 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187898.test-armhf-armhf-xl-arndale"},{"PreviousShare":{"Type":"test-187898-4wm7sX_ZRUfi1_B4f2kxMvgAP-czx40wwPfaFg 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Type":"Unshare","Time":2516,"Avail":1}],"host italia0":[{"Type":"Start","Time":-99,"Avail":0,"Job":"187899.test-amd64-amd64-xl","Share":{"Type":"test-187899-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}},{"Avail":1,"Time":2868,"Type":"End","Share":{"Type":"test-187899-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Job":"187899.test-amd64-amd64-xl"},{"PreviousShare":{"Type":"test-187899-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":1,"Time":2868,"Type":"Unshare"}],"host himrod0":[{"Job":"187898.test-amd64-amd64-xl-pvhv2-intel","Share":{"Wear":1,"Shares":"1","Type":"test-187898-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0,"Type":"Start","Time":-1518},{"Share":{"Wear":1,"Shares":1,"Type":"test-187898-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187898.test-amd64-amd64-xl-pvhv2-intel","Type":"End","Time":1151,"Avail":1},{"PreviousShare":{"Shares":"1","Wear":1,"Type":"test-187898-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":1151,"Avail":1}],"host septiner0":[{"Share":{"Shares":"1","Wear":1,"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-libvirt-pair","Type":"Start","Time":-256,"Avail":0},{"Share":{"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Job":"187899.test-amd64-amd64-libvirt-pair","Type":"End","Time":2545,"Avail":1},{"PreviousShare":{"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare","Time":2545,"Avail":1}],"host nobling0":[{"Avail":0,"Time":-993,"Type":"Start","Job":"187898.test-amd64-amd64-libvirt-vhd","Share":{"Type":"test-187898-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}},{"Share":{"Wear":1,"Shares":1,"Type":"test-187898-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187898.test-amd64-amd64-libvirt-vhd","Type":"End","Time":3611,"Avail":1},{"PreviousShare":{"Type":"test-187898-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare","Time":3611,"Avail":1}],"host godello0":[{"Type":"Unshare","Time":0,"Avail":1,"PreviousShare":{"Type":"test-187899-jVi7QR2lpr8cB9dB6ob64BSlfjMVZ8Vm-gKO8Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1}}],"host albana1":[{"Share":{"Wear":1,"Shares":"1","Type":"test-187899-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-xtf-amd64-amd64-4","Type":"Start","Time":-1051,"Avail":0},{"Job":"187899.test-xtf-amd64-amd64-4","Share":{"Wear":1,"Shares":1,"Type":"test-187899-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":866,"Type":"End"},{"Type":"Unshare","Time":866,"Avail":1,"PreviousShare":{"Type":"test-187899-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}}],"host huxelrebe1":[{"Avail":0,"Time":-4138,"Type":"Start","Job":"187899.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm","Share":{"Type":"test-187899-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"}},{"Time":1261,"Type":"End","Avail":1,"Share":{"Wear":1,"Shares":1,"Type":"test-187899-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-xl-qemuu-debianhvm-i386-xsm"},{"PreviousShare":{"Type":"test-187899-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Time":1261,"Type":"Unshare","Avail":1}],"host nocera1":[{"Time":-28745535,"Type":"Start","Avail":0},{"Time":604800,"Type":"End","Avail":1}],"host joubertin0":[{"Avail":0,"Type":"Start","Time":-34859612},{"Type":"End","Time":604800,"Avail":1}],"host verdesse1":[{"Type":"Start","Time":-5661926,"Avail":0},{"Type":"End","Time":604800,"Avail":1}],"host chardonnay0":[{"PreviousShare":{"Type":"build-bookworm-amd64 3ed6e92c6e8d51a06b9010da794d4eda53ff543e","Wear":1,"Shares":3},"Avail":1,"Time":0,"Type":"Unshare"}],"host rimava1":[{"Avail":0,"Type":"Start","Time":-2231,"Share":{"Type":"test-187898-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Job":"187898.test-amd64-amd64-xl-qemuu-debianhvm-amd64"},{"Job":"187898.test-amd64-amd64-xl-qemuu-debianhvm-amd64","Share":{"Type":"test-187898-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Type":"End","Time":633,"Avail":1},{"Time":633,"Type":"Unshare","Avail":1,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753"}}],"host rubintos1":[{"Avail":0,"Time":-25977698,"Type":"Start"},{"Time":604800,"Type":"End","Avail":1}],"host espadeiro1":[{"Avail":0,"Type":"Start","Time":-3422074},{"Time":604800,"Type":"End","Avail":1}],"host cubietruck-gleizes":[{"Avail":0,"Time":-99,"Type":"Start","Share":{"Wear":1,"Shares":"1","Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.build-armhf"},{"Avail":1,"Time":6701,"Type":"End","Job":"187899.build-armhf","Share":{"Shares":1,"Wear":1,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"PreviousShare":{"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare","Time":6701,"Avail":1}],"host himrod2":[{"Avail":2,"Time":-1847,"Type":"Start","Job":"187901.build-amd64-pvops","Share":{"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"3"}},{"Avail":1,"Type":"Start","Time":-939,"Job":"187901.build-amd64","Share":{"Shares":"3","Wear":2,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Job":"187901.build-amd64-pvops","Share":{"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":3,"Wear":2},"Time":347,"Type":"End","Avail":2},{"Share":{"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":3,"Wear":2},"Job":"187901.build-amd64","Avail":3,"Time":1115,"Type":"End"},{"PreviousShare":{"Shares":"3","Wear":2,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":1115,"Type":"Unshare"}],"host godello1":[{"Avail":0,"Time":-3480,"Type":"Start","Job":"187899.test-amd64-amd64-xl-vhd","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}},{"Job":"187899.test-amd64-amd64-xl-vhd","Share":{"Wear":1,"Shares":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":1230,"Type":"End"},{"PreviousShare":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Type":"Unshare","Time":1230,"Avail":1}],"host rochester1":[{"Type":"Start","Time":-1765,"Avail":0,"Share":{"Type":"test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187898.test-arm64-arm64-xl"},{"Avail":1,"Time":1772,"Type":"End","Share":{"Type":"test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Job":"187898.test-arm64-arm64-xl"},{"PreviousShare":{"Shares":"1","Wear":1,"Type":"test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Type":"Unshare","Time":1772}],"host nobling1":[{"Share":{"Type":"test-187900-mrSxrL_vQ43E5JhU9pxjn69yQUYCPi5_4jLdDw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187900.test-amd64-amd64-xl-qemut-debianhvm-i386-xsm","Time":-2012,"Type":"Start","Avail":0},{"Type":"End","Time":1997,"Avail":1,"Job":"187900.test-amd64-amd64-xl-qemut-debianhvm-i386-xsm","Share":{"Shares":1,"Wear":1,"Type":"test-187900-mrSxrL_vQ43E5JhU9pxjn69yQUYCPi5_4jLdDw 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"PreviousShare":{"Type":"test-187900-mrSxrL_vQ43E5JhU9pxjn69yQUYCPi5_4jLdDw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":1,"Time":1997,"Type":"Unshare"}],"host rubintos0":[{"Avail":0,"Time":-25977698,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host sabro0":[{"Job":"187899.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Share":{"Wear":1,"Shares":"1","Type":"test-187899-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0,"Time":-2856,"Type":"Start"},{"Avail":1,"Time":2900,"Type":"End","Job":"187899.test-amd64-amd64-xl-qemut-stubdom-debianhvm-amd64-xsm","Share":{"Wear":1,"Shares":1,"Type":"test-187899-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"PreviousShare":{"Shares":"1","Wear":1,"Type":"test-187899-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":2900,"Type":"Unshare"}],"host sabro1":[{"Avail":0,"Type":"Start","Time":-2856,"Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Job":"187899.test-amd64-amd64-qemuu-freebsd12-amd64"},{"Job":"187899.test-amd64-amd64-qemuu-freebsd12-amd64","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Avail":1,"Time":926,"Type":"End"},{"PreviousShare":{"Shares":"1","Wear":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":926,"Type":"Unshare"}],"host rimava0":[{"Avail":0,"Time":-256,"Type":"Start","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Job":"187899.test-amd64-amd64-qemuu-nested-amd"},{"Avail":1,"Time":7401,"Type":"End","Job":"187899.test-amd64-amd64-qemuu-nested-amd","Share":{"Wear":1,"Shares":1,"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"PreviousShare":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Avail":1,"Time":7401,"Type":"Unshare"}],"host cubietruck-metzinger":[{"PreviousShare":{"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":10},"Type":"Unshare","Time":0,"Avail":1}],"host verdesse0":[{"Type":"Start","Time":-26573484,"Avail":0},{"Avail":1,"Time":604800,"Type":"End"}],"host nocera0":[{"Avail":0,"Type":"Start","Time":-28745535},{"Avail":1,"Time":604800,"Type":"End"}],"host fiano1":[{"Job":"187899.test-amd64-amd64-pair","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Start","Time":-692,"Avail":0},{"Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1},"Job":"187899.test-amd64-amd64-pair","Time":2123,"Type":"End","Avail":1},{"PreviousShare":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Avail":1,"Type":"Unshare","Time":2123}],"host albana0":[{"Share":{"Type":"test-187899-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.test-amd64-amd64-libvirt-vhd","Avail":0,"Type":"Start","Time":-385},{"Share":{"Shares":1,"Wear":1,"Type":"test-187899-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-libvirt-vhd","Time":4165,"Type":"End","Avail":1},{"Time":4165,"Type":"Unshare","Avail":1,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187899-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"}}],"host arndale-metrocentre":[{"Time":-3178,"Type":"Start","Avail":0,"Share":{"Type":"test-187898-cDQI4bT8W7N-sTSSXe5EfboNwTzFke2Qj1ifzw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187898.test-armhf-armhf-xl"},{"Type":"End","Time":199,"Avail":1,"Job":"187898.test-armhf-armhf-xl","Share":{"Type":"test-187898-cDQI4bT8W7N-sTSSXe5EfboNwTzFke2Qj1ifzw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":1}},{"Time":199,"Type":"Unshare","Avail":1,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-cDQI4bT8W7N-sTSSXe5EfboNwTzFke2Qj1ifzw 40660b4b01c49f3a75a7c3865523a30074b0e753"}}],"host fiano0":[{"Job":"187899.test-amd64-amd64-pair","Share":{"Wear":1,"Shares":"1","Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0,"Type":"Start","Time":-692},{"Avail":1,"Time":2123,"Type":"End","Share":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Job":"187899.test-amd64-amd64-pair"},{"Avail":1,"Time":2123,"Type":"Unshare","PreviousShare":{"Type":"test-187899-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}}],"host himrod1":[{"Avail":1,"Type":"Unshare","Time":0,"PreviousShare":{"Wear":10,"Shares":3,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"}}],"host italia1":[{"Job":"187899.test-amd64-amd64-examine","Time":-330,"Type":"Start","Avail":0},{"Job":"187899.test-amd64-amd64-examine","Avail":1,"Type":"End","Time":4914}],"host septiner1":[{"Avail":0,"Type":"Start","Time":-256,"Share":{"Wear":1,"Shares":"1","Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-libvirt-pair"},{"Share":{"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Job":"187899.test-amd64-amd64-libvirt-pair","Time":2545,"Type":"End","Avail":1},{"PreviousShare":{"Type":"test-187899-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Avail":1,"Type":"Unshare","Time":2545}],"host joubertin1":[{"Type":"Start","Time":-34859612,"Avail":0},{"Avail":1,"Time":604800,"Type":"End"}],"host huxelrebe0":[{"Share":{"Wear":1,"Shares":"1","Type":"test-187898-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187898.test-amd64-amd64-libvirt-raw","Time":-2231,"Type":"Start","Avail":0},{"Type":"End","Time":177,"Avail":1,"Job":"187898.test-amd64-amd64-libvirt-raw","Share":{"Wear":1,"Shares":1,"Type":"test-187898-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Avail":1,"Time":177,"Type":"Unshare","PreviousShare":{"Type":"test-187898-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}}],"host debina1":[{"Share":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"},"Job":"187899.test-amd64-amd64-migrupgrade","Avail":0,"Time":-1176,"Type":"Start"},{"Share":{"Wear":1,"Shares":1,"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.test-amd64-amd64-migrupgrade","Avail":1,"Type":"End","Time":975},{"Avail":1,"Type":"Unshare","Time":975,"PreviousShare":{"Type":"test-187899-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"}}],"host rochester0":[{"Avail":2,"Time":-892,"Type":"Start","Job":"187899.build-arm64-pvops","Share":{"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"3"}},{"Share":{"Wear":1,"Shares":3,"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.build-arm64-pvops","Avail":3,"Time":3254,"Type":"End"},{"PreviousShare":{"Wear":1,"Shares":"3","Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":3254,"Type":"Unshare","Avail":1}],"host laxton1":[{"PreviousShare":{"Type":"build-buster-arm64 cb303068d340f3344c760df46ac9785e08c0d889","Shares":3,"Wear":1},"Avail":1,"Type":"Unshare","Time":0}],"host arndale-lakeside":[{"Avail":0,"Type":"Start","Time":-3240,"Job":"187898.test-armhf-armhf-xl-qcow2","Share":{"Type":"test-187898-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}},{"Avail":1,"Time":1131,"Type":"End","Job":"187898.test-armhf-armhf-xl-qcow2","Share":{"Type":"test-187898-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1}},{"Time":1131,"Type":"Unshare","Avail":1,"PreviousShare":{"Type":"test-187898-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"}}],"host espadeiro0":[{"Time":-5058053,"Type":"Start","Avail":0},{"Type":"End","Time":604800,"Avail":1}],"host pinot0":[{"Time":-892,"Type":"Start","Avail":0,"Share":{"Type":"test-187899-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187899.test-amd64-amd64-dom0pvh-xl-amd"},{"Job":"187899.test-amd64-amd64-dom0pvh-xl-amd","Share":{"Wear":1,"Shares":1,"Type":"test-187899-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Type":"End","Time":1754},{"Avail":1,"Time":1754,"Type":"Unshare","PreviousShare":{"Type":"test-187899-cYtpuo1uJhO3rt4JefREhYZGy_lnC4o7SLasjw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1,"Shares":"1"}}],"host pinot1":[{"Avail":0,"Type":"Start","Time":-2201,"Job":"187898.test-amd64-amd64-xl-credit2","Share":{"Wear":1,"Shares":"1","Type":"test-187898-AF0uFllYW3VCLA1if36p6RiGIJqCHumivjjojw 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Job":"187898.test-amd64-amd64-xl-credit2","Share":{"Shares":1,"Wear":1,"Type":"test-187898-AF0uFllYW3VCLA1if36p6RiGIJqCHumivjjojw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"End","Time":810,"Avail":1},{"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187898-AF0uFllYW3VCLA1if36p6RiGIJqCHumivjjojw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Time":810,"Type":"Unshare"}]},"ClientNotes":{}} 2024-09-30 03:32:50 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-arm64 HID host TRY host pinot0: NEEDFLAG suite-bookworm HID host TRY host pinot0: NEEDFLAG purpose-build HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-gleizes: HID host TRY host cubietruck-gleizes: NEEDFLAG arch-arm64 HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-build HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host godello0: HID host TRY host godello0: NEEDFLAG arch-arm64 HID host TRY host godello0: NEEDFLAG suite-bookworm HID host TRY host godello0: NEEDFLAG purpose-build HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host pinot1: HID host TRY host pinot1: NEEDFLAG arch-arm64 HID host TRY host pinot1: NEEDFLAG suite-bookworm HID host TRY host pinot1: NEEDFLAG purpose-build HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host fiano0: HID host TRY host fiano0: NEEDFLAG arch-arm64 HID host TRY host fiano0: NEEDFLAG suite-bookworm HID host TRY host fiano0: NEEDFLAG purpose-build HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host fiano1: HID host TRY host fiano1: NEEDFLAG arch-arm64 HID host TRY host fiano1: NEEDFLAG suite-bookworm HID host TRY host fiano1: NEEDFLAG purpose-build HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host italia0: HID host TRY host italia0: NEEDFLAG arch-arm64 HID host TRY host italia0: NEEDFLAG suite-bookworm HID host TRY host italia0: NEEDFLAG purpose-build HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host godello1: HID host TRY host godello1: NEEDFLAG arch-arm64 HID host TRY host godello1: NEEDFLAG suite-bookworm HID host TRY host godello1: NEEDFLAG purpose-build HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-braque: HID host TRY host cubietruck-braque: NEEDFLAG arch-arm64 HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm HID host TRY host cubietruck-braque: NEEDFLAG purpose-build HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-metzinger: HID host TRY host cubietruck-metzinger: NEEDFLAG arch-arm64 HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-build HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host albana0: HID host TRY host albana0: NEEDFLAG arch-arm64 HID host TRY host albana0: NEEDFLAG suite-bookworm HID host TRY host albana0: NEEDFLAG purpose-build HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host albana1: HID host TRY host albana1: NEEDFLAG arch-arm64 HID host TRY host albana1: NEEDFLAG suite-bookworm HID host TRY host albana1: NEEDFLAG purpose-build HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host cubietruck-picasso: HID host TRY host cubietruck-picasso: NEEDFLAG arch-arm64 HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm HID host TRY host cubietruck-picasso: NEEDFLAG purpose-build HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rochester0: HID host TRY host rochester0: NEEDFLAG arch-arm64 HID host TRY host rochester0: NEEDFLAG suite-bookworm HID host TRY host rochester0: NEEDFLAG purpose-build HID host TRY host rochester0: FLAGS MISSINGFLAGS: . HID host TRY host rochester0: GOOD HID host TRY host rochester0: EQUIV-MOST-RECENT 187892.build-arm64-libvirt rochester0 pass. HID host TRY host rochester0: SharedMaxWear (shared max wear) FROM-DEFAULT 10 HID host TRY host rochester0: SharedMaxTasks (shared max tasks) FROM-DEFAULT 3 HID host TRY host rochester0: CANDIDATE. HID host TRY host rochester1: HID host TRY host rochester1: NEEDFLAG arch-arm64 HID host TRY host rochester1: NEEDFLAG suite-bookworm HID host TRY host rochester1: NEEDFLAG purpose-build HID host TRY host rochester1: FLAGS MISSINGFLAGS: . HID host TRY host rochester1: GOOD HID host TRY host rochester1: EQUIV-MOST-RECENT 187892.build-arm64-libvirt rochester0 pass. HID host TRY host rochester1: SharedMaxWear (shared max wear) FROM-DEFAULT 10 HID host TRY host rochester1: SharedMaxTasks (shared max tasks) FROM-DEFAULT 3 HID host TRY host rochester1: CANDIDATE. HID host TRY host debina0: HID host TRY host debina0: NEEDFLAG arch-arm64 HID host TRY host debina0: NEEDFLAG suite-bookworm HID host TRY host debina0: NEEDFLAG purpose-build HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host debina1: HID host TRY host debina1: NEEDFLAG arch-arm64 HID host TRY host debina1: NEEDFLAG suite-bookworm HID host TRY host debina1: NEEDFLAG purpose-build HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host huxelrebe0: HID host TRY host huxelrebe0: NEEDFLAG arch-arm64 HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm HID host TRY host huxelrebe0: NEEDFLAG purpose-build HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host huxelrebe1: HID host TRY host huxelrebe1: NEEDFLAG arch-arm64 HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm HID host TRY host huxelrebe1: NEEDFLAG purpose-build HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host sabro0: HID host TRY host sabro0: NEEDFLAG arch-arm64 HID host TRY host sabro0: NEEDFLAG suite-bookworm HID host TRY host sabro0: NEEDFLAG purpose-build HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rimava0: HID host TRY host rimava0: NEEDFLAG arch-arm64 HID host TRY host rimava0: NEEDFLAG suite-bookworm HID host TRY host rimava0: NEEDFLAG purpose-build HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host rimava1: HID host TRY host rimava1: NEEDFLAG arch-arm64 HID host TRY host rimava1: NEEDFLAG suite-bookworm HID host TRY host rimava1: NEEDFLAG purpose-build HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host arndale-lakeside: HID host TRY host arndale-lakeside: NEEDFLAG arch-arm64 HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm HID host TRY host arndale-lakeside: NEEDFLAG purpose-build HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host arndale-metrocentre: HID host TRY host arndale-metrocentre: NEEDFLAG arch-arm64 HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm HID host TRY host arndale-metrocentre: NEEDFLAG purpose-build HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host arndale-westfield: HID host TRY host arndale-westfield: NEEDFLAG arch-arm64 HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm HID host TRY host arndale-westfield: NEEDFLAG purpose-build HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: arch-arm64 purpose-build. HID host TRY host himrod0: HID host TRY host himrod0: NEEDFLAG arch-arm64 HID host TRY host himrod0: NEEDFLAG suite-bookworm HID host TRY host himrod0: NEEDFLAG purpose-build HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nocera0: HID host TRY host nocera0: NEEDFLAG arch-arm64 HID host TRY host nocera0: NEEDFLAG suite-bookworm HID host TRY host nocera0: NEEDFLAG purpose-build HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nocera1: HID host TRY host nocera1: NEEDFLAG arch-arm64 HID host TRY host nocera1: NEEDFLAG suite-bookworm HID host TRY host nocera1: NEEDFLAG purpose-build HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host himrod1: HID host TRY host himrod1: NEEDFLAG arch-arm64 HID host TRY host himrod1: NEEDFLAG suite-bookworm HID host TRY host himrod1: NEEDFLAG purpose-build HID host TRY host himrod1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host himrod2: HID host TRY host himrod2: NEEDFLAG arch-arm64 HID host TRY host himrod2: NEEDFLAG suite-bookworm HID host TRY host himrod2: NEEDFLAG purpose-build HID host TRY host himrod2: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host sabro1: HID host TRY host sabro1: NEEDFLAG arch-arm64 HID host TRY host sabro1: NEEDFLAG suite-bookworm HID host TRY host sabro1: NEEDFLAG purpose-build HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nobling0: HID host TRY host nobling0: NEEDFLAG arch-arm64 HID host TRY host nobling0: NEEDFLAG suite-bookworm HID host TRY host nobling0: NEEDFLAG purpose-build HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host nobling1: HID host TRY host nobling1: NEEDFLAG arch-arm64 HID host TRY host nobling1: NEEDFLAG suite-bookworm HID host TRY host nobling1: NEEDFLAG purpose-build HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host italia1: HID host TRY host italia1: NEEDFLAG arch-arm64 HID host TRY host italia1: NEEDFLAG suite-bookworm HID host TRY host italia1: NEEDFLAG purpose-build HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host septiner0: HID host TRY host septiner0: NEEDFLAG arch-arm64 HID host TRY host septiner0: NEEDFLAG suite-bookworm HID host TRY host septiner0: NEEDFLAG purpose-build HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-arm64. HID host TRY host septiner1: HID host TRY host septiner1: NEEDFLAG arch-arm64 HID host TRY host septiner1: NEEDFLAG suite-bookworm HID host TRY host septiner1: NEEDFLAG purpose-build HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-arm64. ORDER host RECURSE host... RECURSE CAND host rochester0 RECURSE EVAL host rochester0 RECURSE EVAL DURATION 311 va=92222 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 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 3 vs. 3 RECURSE PLAN LOOP SHARE-COMPAT-OK Y RECURSE PLAN LOOP OVERLAP AVAIL OK RECURSE PLAN LOOP reqs[0]=host evtix=1 try=0 confirmed=0 RECURSE PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0 RECURSE PLAN LOOP SHARE-COMPAT-OK type build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 3 vs. 3 RECURSE PLAN LOOP SHARE-COMPAT-OK Y RECURSE FINAL start=0 va=0 variation_bonus=0 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=1*20000 cost=-19689 RECURSE FINAL BEST: host rochester0 RECURSE CAND host rochester1 RECURSE EVAL host rochester1 RECURSE EVAL DURATION 328 va=178788 RECURSE PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 1772 RECURSE PLAN LOOP reqs[0]=host evtix=1 try=1772 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=2 try=1772 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP AVAIL OK RECURSE PLAN NEXT reqs[0]=host try=1772 confirmed=0 reuse=0 RECURSE PLAN LOOP SHARE-COMPAT-OK type test-187898-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 1 vs. 3 RECURSE FINAL start=1772 va=0 variation_bonus=0 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=2100 host host rochester0 ALLOC PLAIN 0 (3, 2) host host rochester0 ALLOC ISSHARED build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753 ready 1 3 40660b4b01c49f3a75a7c3865523a30074b0e753 host host rochester0 ALLOC SHARED ST share-host ready host host rochester0 ALLOC SHARED AVAIL SLOTFREE 1 HID host ALLOC share-host rochester0 1 HID host GO share-host rochester0 1 SHARING REUSE share-host 2024-09-30 03:32:50 Z allocating for host: share-host rochester0 1 HID host GO share-host rochester0 1 ALLOCATE 2024-09-30 03:32:50 Z host allocation: successful, reporting to planner. 2024-09-30 03:32:50 Z resource allocation: booking @0 host rochester0 [host]. bookings = {"ClientNotes":{},"Bookings":[{"Xinfo":"host","Share":{"Shares":3,"Type":"build-bookworm-arm64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187899.build-arm64-libvirt","Allocated":{"Shareix":"1","Task":"2551196"},"End":311,"Reso":"host rochester0","Start":"0"}]} 2024-09-30 03:32:50 Z resource allocation: we are in the plan. 2024-09-30 03:32:50 Z resource allocation: successful. 2024-09-30 03:32:50 Z runvar store: host=rochester0 2024-09-30 03:32:50 Z host allocation: all successful and recorded.