2024-09-12 20:23:57 Z flight 187674 intended real branch linux-6.1 2024-09-12 20:23:57 Z job 187674.test-armhf-armhf-libvirt recipe test-debian 2024-09-12 20:23:57 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-armhf arch-xen-armhf suite-bookworm purpose-test PropMinVer:LinuxKernelMin:6.1 reuse-test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A HID host FLAG arch-armhf HID host FLAG arch-xen-armhf HID host FLAG suite-bookworm HID host FLAG purpose-test HID host FLAG PropMinVer:LinuxKernelMin:6.1 HID host FLAG PropMinVer:LinuxKernelMin:6.1 HCOND 6.1 >=(v) property LinuxKernelMin HID host FLAG reuse-test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A HID host FLAG reuse-test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A SHARE-REUSE test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A 1 10 HID host FLAGS arch-armhf,arch-xen-armhf,purpose-test,suite-bookworm + 1 host conditions(s) 2024-09-12 20:23:57 Z pre-checking resources... 2024-09-12 20:23:57 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 purpose-test HID host TRY host pinot0: NEEDFLAG arch-armhf HID host TRY host pinot0: NEEDFLAG suite-bookworm HID host TRY host pinot0: NEEDFLAG arch-xen-armhf HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host cubietruck-gleizes: HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-test HID host TRY host cubietruck-gleizes: NEEDFLAG arch-armhf HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm HID host TRY host cubietruck-gleizes: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host godello0: HID host TRY host godello0: NEEDFLAG purpose-test HID host TRY host godello0: NEEDFLAG arch-armhf HID host TRY host godello0: NEEDFLAG suite-bookworm HID host TRY host godello0: NEEDFLAG arch-xen-armhf HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host pinot1: HID host TRY host pinot1: NEEDFLAG purpose-test HID host TRY host pinot1: NEEDFLAG arch-armhf HID host TRY host pinot1: NEEDFLAG suite-bookworm HID host TRY host pinot1: NEEDFLAG arch-xen-armhf HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host fiano0: HID host TRY host fiano0: NEEDFLAG purpose-test HID host TRY host fiano0: NEEDFLAG arch-armhf HID host TRY host fiano0: NEEDFLAG suite-bookworm HID host TRY host fiano0: NEEDFLAG arch-xen-armhf HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host fiano1: HID host TRY host fiano1: NEEDFLAG purpose-test HID host TRY host fiano1: NEEDFLAG arch-armhf HID host TRY host fiano1: NEEDFLAG suite-bookworm HID host TRY host fiano1: NEEDFLAG arch-xen-armhf HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host italia0: HID host TRY host italia0: NEEDFLAG purpose-test HID host TRY host italia0: NEEDFLAG arch-armhf HID host TRY host italia0: NEEDFLAG suite-bookworm HID host TRY host italia0: NEEDFLAG arch-xen-armhf HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host godello1: HID host TRY host godello1: NEEDFLAG purpose-test HID host TRY host godello1: NEEDFLAG arch-armhf HID host TRY host godello1: NEEDFLAG suite-bookworm HID host TRY host godello1: NEEDFLAG arch-xen-armhf HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host cubietruck-braque: HID host TRY host cubietruck-braque: NEEDFLAG purpose-test HID host TRY host cubietruck-braque: NEEDFLAG arch-armhf HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm HID host TRY host cubietruck-braque: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host cubietruck-metzinger: HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-test HID host TRY host cubietruck-metzinger: NEEDFLAG arch-armhf HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm HID host TRY host cubietruck-metzinger: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host albana0: HID host TRY host albana0: NEEDFLAG purpose-test HID host TRY host albana0: NEEDFLAG arch-armhf HID host TRY host albana0: NEEDFLAG suite-bookworm HID host TRY host albana0: NEEDFLAG arch-xen-armhf HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host albana1: HID host TRY host albana1: NEEDFLAG purpose-test HID host TRY host albana1: NEEDFLAG arch-armhf HID host TRY host albana1: NEEDFLAG suite-bookworm HID host TRY host albana1: NEEDFLAG arch-xen-armhf HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host cubietruck-picasso: HID host TRY host cubietruck-picasso: NEEDFLAG purpose-test HID host TRY host cubietruck-picasso: NEEDFLAG arch-armhf HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm HID host TRY host cubietruck-picasso: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host rochester0: HID host TRY host rochester0: NEEDFLAG purpose-test HID host TRY host rochester0: NEEDFLAG arch-armhf HID host TRY host rochester0: NEEDFLAG suite-bookworm HID host TRY host rochester0: NEEDFLAG arch-xen-armhf HID host TRY host rochester0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host rochester1: HID host TRY host rochester1: NEEDFLAG purpose-test HID host TRY host rochester1: NEEDFLAG arch-armhf HID host TRY host rochester1: NEEDFLAG suite-bookworm HID host TRY host rochester1: NEEDFLAG arch-xen-armhf HID host TRY host rochester1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host debina0: HID host TRY host debina0: NEEDFLAG purpose-test HID host TRY host debina0: NEEDFLAG arch-armhf HID host TRY host debina0: NEEDFLAG suite-bookworm HID host TRY host debina0: NEEDFLAG arch-xen-armhf HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host debina1: HID host TRY host debina1: NEEDFLAG purpose-test HID host TRY host debina1: NEEDFLAG arch-armhf HID host TRY host debina1: NEEDFLAG suite-bookworm HID host TRY host debina1: NEEDFLAG arch-xen-armhf HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host huxelrebe0: HID host TRY host huxelrebe0: NEEDFLAG purpose-test HID host TRY host huxelrebe0: NEEDFLAG arch-armhf HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm HID host TRY host huxelrebe0: NEEDFLAG arch-xen-armhf HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host huxelrebe1: HID host TRY host huxelrebe1: NEEDFLAG purpose-test HID host TRY host huxelrebe1: NEEDFLAG arch-armhf HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm HID host TRY host huxelrebe1: NEEDFLAG arch-xen-armhf HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host sabro0: HID host TRY host sabro0: NEEDFLAG purpose-test HID host TRY host sabro0: NEEDFLAG arch-armhf HID host TRY host sabro0: NEEDFLAG suite-bookworm HID host TRY host sabro0: NEEDFLAG arch-xen-armhf HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host rimava0: HID host TRY host rimava0: NEEDFLAG purpose-test HID host TRY host rimava0: NEEDFLAG arch-armhf HID host TRY host rimava0: NEEDFLAG suite-bookworm HID host TRY host rimava0: NEEDFLAG arch-xen-armhf HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host rimava1: HID host TRY host rimava1: NEEDFLAG purpose-test HID host TRY host rimava1: NEEDFLAG arch-armhf HID host TRY host rimava1: NEEDFLAG suite-bookworm HID host TRY host rimava1: NEEDFLAG arch-xen-armhf HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host arndale-lakeside: HID host TRY host arndale-lakeside: NEEDFLAG purpose-test HID host TRY host arndale-lakeside: NEEDFLAG arch-armhf HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm HID host TRY host arndale-lakeside: NEEDFLAG arch-xen-armhf HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: . HID host TRY host arndale-lakeside: GOOD DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-lakeside SAME-HOST GOT 0 DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-lakeside ANY-HOST GOT 2 DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-lakeside REF 187566 DURATION 3576 DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-lakeside REF 187493 DURATION 3637 HID host TRY host arndale-lakeside: EQUIV-MOST-RECENT 187566.test-armhf-armhf-libvirt arndale-metrocentre pass. HID host TRY host arndale-lakeside: SharedMaxWear FROM-HID HID host TRY host arndale-lakeside: SharedMaxTasks FROM-HID HID host TRY host arndale-lakeside: CANDIDATE. HID host TRY host arndale-metrocentre: HID host TRY host arndale-metrocentre: NEEDFLAG purpose-test HID host TRY host arndale-metrocentre: NEEDFLAG arch-armhf HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm HID host TRY host arndale-metrocentre: NEEDFLAG arch-xen-armhf HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: . HID host TRY host arndale-metrocentre: GOOD DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-metrocentre SAME-HOST GOT 1 DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-metrocentre REF 187566 DURATION 3576 pass HID host TRY host arndale-metrocentre: EQUIV-MOST-RECENT 187566.test-armhf-armhf-libvirt arndale-metrocentre pass. HID host TRY host arndale-metrocentre: SharedMaxWear FROM-HID HID host TRY host arndale-metrocentre: SharedMaxTasks FROM-HID HID host TRY host arndale-metrocentre: CANDIDATE. HID host TRY host arndale-westfield: HID host TRY host arndale-westfield: NEEDFLAG purpose-test HID host TRY host arndale-westfield: NEEDFLAG arch-armhf HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm HID host TRY host arndale-westfield: NEEDFLAG arch-xen-armhf HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: . HID host TRY host arndale-westfield: GOOD DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-westfield SAME-HOST GOT 1 DUR linux-6.1 real test-armhf-armhf-libvirt host arndale-westfield REF 187493 DURATION 3637 pass HID host TRY host arndale-westfield: EQUIV-MOST-RECENT 187566.test-armhf-armhf-libvirt arndale-metrocentre pass. HID host TRY host arndale-westfield: SharedMaxWear FROM-HID HID host TRY host arndale-westfield: SharedMaxTasks FROM-HID HID host TRY host arndale-westfield: CANDIDATE. HID host TRY host himrod0: HID host TRY host himrod0: NEEDFLAG purpose-test HID host TRY host himrod0: NEEDFLAG arch-armhf HID host TRY host himrod0: NEEDFLAG suite-bookworm HID host TRY host himrod0: NEEDFLAG arch-xen-armhf HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nocera0: HID host TRY host nocera0: NEEDFLAG purpose-test HID host TRY host nocera0: NEEDFLAG arch-armhf HID host TRY host nocera0: NEEDFLAG suite-bookworm HID host TRY host nocera0: NEEDFLAG arch-xen-armhf HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nocera1: HID host TRY host nocera1: NEEDFLAG purpose-test HID host TRY host nocera1: NEEDFLAG arch-armhf HID host TRY host nocera1: NEEDFLAG suite-bookworm HID host TRY host nocera1: NEEDFLAG arch-xen-armhf HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host himrod1: HID host TRY host himrod1: NEEDFLAG purpose-test HID host TRY host himrod1: NEEDFLAG arch-armhf HID host TRY host himrod1: NEEDFLAG suite-bookworm HID host TRY host himrod1: NEEDFLAG arch-xen-armhf HID host TRY host himrod1: FLAGS MISSINGFLAGS: purpose-test arch-armhf arch-xen-armhf. HID host TRY host himrod2: HID host TRY host himrod2: NEEDFLAG purpose-test HID host TRY host himrod2: NEEDFLAG arch-armhf HID host TRY host himrod2: NEEDFLAG suite-bookworm HID host TRY host himrod2: NEEDFLAG arch-xen-armhf HID host TRY host himrod2: FLAGS MISSINGFLAGS: purpose-test arch-armhf arch-xen-armhf. HID host TRY host sabro1: HID host TRY host sabro1: NEEDFLAG purpose-test HID host TRY host sabro1: NEEDFLAG arch-armhf HID host TRY host sabro1: NEEDFLAG suite-bookworm HID host TRY host sabro1: NEEDFLAG arch-xen-armhf HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nobling0: HID host TRY host nobling0: NEEDFLAG purpose-test HID host TRY host nobling0: NEEDFLAG arch-armhf HID host TRY host nobling0: NEEDFLAG suite-bookworm HID host TRY host nobling0: NEEDFLAG arch-xen-armhf HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nobling1: HID host TRY host nobling1: NEEDFLAG purpose-test HID host TRY host nobling1: NEEDFLAG arch-armhf HID host TRY host nobling1: NEEDFLAG suite-bookworm HID host TRY host nobling1: NEEDFLAG arch-xen-armhf HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host italia1: HID host TRY host italia1: NEEDFLAG purpose-test HID host TRY host italia1: NEEDFLAG arch-armhf HID host TRY host italia1: NEEDFLAG suite-bookworm HID host TRY host italia1: NEEDFLAG arch-xen-armhf HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host septiner0: HID host TRY host septiner0: NEEDFLAG purpose-test HID host TRY host septiner0: NEEDFLAG arch-armhf HID host TRY host septiner0: NEEDFLAG suite-bookworm HID host TRY host septiner0: NEEDFLAG arch-xen-armhf HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host septiner1: HID host TRY host septiner1: NEEDFLAG purpose-test HID host TRY host septiner1: NEEDFLAG arch-armhf HID host TRY host septiner1: NEEDFLAG suite-bookworm HID host TRY host septiner1: NEEDFLAG arch-xen-armhf HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. ORDER host RECURSE host... RECURSE CAND host arndale-lakeside RECURSE EVAL host arndale-lakeside RECURSE EVAL DURATION 3647 va=7776000 RECURSE PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0 RECURSE FINAL start=0 va=7776000 variation_bonus=32478.1884469213 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-32478.1884469213 RECURSE FINAL BEST: host arndale-lakeside RECURSE CAND host arndale-metrocentre RECURSE EVAL host arndale-metrocentre RECURSE EVAL DURATION 3586 va=396631 RECURSE PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0 RECURSE FINAL start=0 va=396631 variation_bonus=12391.8707374387 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-12391.8707374387 RECURSE CAND host arndale-westfield RECURSE EVAL host arndale-westfield RECURSE EVAL DURATION 3647 va=722329 RECURSE PLAN NEXT reqs[0]=host try=0 confirmed=0 reuse=0 RECURSE FINAL start=0 va=722329 variation_bonus=16102.6286664317 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-16102.6286664317 2024-09-12 20:23:57 Z resource allocation: starting... 2024-09-12 20:23:57 Z resource allocation: awaiting our slot... 2024-09-12 20:24:33 Z resource allocation: obtained base plan. base plan = {"Start":1726172668,"ClientNotes":{},"Events":{"host joubertin0":[{"Avail":0,"Type":"Start","Time":-33365110},{"Type":"End","Time":604800,"Avail":1}],"host italia0":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Wear":2,"Shares":1,"Type":"test-187677-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":0}],"host cubietruck-braque":[{"PreviousShare":{"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":10},"Type":"Unshare","Time":0,"Avail":1}],"host pinot1":[{"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-jVi7QR2lpr8cB9dB6ob64BSlfjMVZ8Vm-gKO8Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":0,"Avail":1}],"host rimava0":[{"Avail":1,"PreviousShare":{"Shares":1,"Type":"test-187677-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Type":"Unshare","Time":0}],"host chardonnay0":[{"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"build-bookworm-amd64 3ed6e92c6e8d51a06b9010da794d4eda53ff543e","Shares":3},"Time":0,"Avail":1}],"host nocera0":[{"Type":"Start","Time":-27251033,"Avail":0},{"Avail":1,"Time":604800,"Type":"End"}],"host arndale-metrocentre":[{"Type":"Start","Time":-4763,"Share":{"Type":"test-187674-c8hmKpkOt56Y-Ce9hygJ5FDiYjVSJVuvkyguiA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Avail":0,"Job":"187674.test-armhf-armhf-xl-credit1"},{"Share":{"Type":"test-187674-c8hmKpkOt56Y-Ce9hygJ5FDiYjVSJVuvkyguiA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Avail":1,"Job":"187674.test-armhf-armhf-xl-credit1","Type":"End","Time":1759},{"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187674-c8hmKpkOt56Y-Ce9hygJ5FDiYjVSJVuvkyguiA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":1759,"Avail":1},{"Job":"187674.test-armhf-armhf-xl-credit2","Avail":0,"Share":{"Wear":1,"Type":"test-187674-A6Up9OPekL9azypX4XkU0WV6Xh_ajTaooJUX9w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Time":1759,"Type":"Start"},{"Share":{"Wear":1,"Shares":1,"Type":"test-187674-A6Up9OPekL9azypX4XkU0WV6Xh_ajTaooJUX9w 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Job":"187674.test-armhf-armhf-xl-credit2","Type":"End","Time":5176},{"Time":5176,"PreviousShare":{"Type":"test-187674-A6Up9OPekL9azypX4XkU0WV6Xh_ajTaooJUX9w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare","Avail":1},{"Type":"Start","Time":5176,"Share":{"Type":"test-187674-vXYkGzVKkZ6sf9NaQcwzEdB9fCzy7Oyv9w-cYA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Avail":0,"Job":"187674.test-armhf-armhf-xl-rtds"},{"Share":{"Shares":1,"Type":"test-187674-vXYkGzVKkZ6sf9NaQcwzEdB9fCzy7Oyv9w-cYA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Avail":1,"Job":"187674.test-armhf-armhf-xl-rtds","Type":"End","Time":8959},{"Avail":1,"Time":8959,"Type":"Unshare","PreviousShare":{"Shares":"1","Type":"test-187674-vXYkGzVKkZ6sf9NaQcwzEdB9fCzy7Oyv9w-cYA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1}}],"host debina0":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-X4RpmN67h51xgL7EejGJpiEgghq0oBBnaIcDWA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":0}],"host cubietruck-gleizes":[{"Avail":1,"Time":0,"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":1,"Type":"build-bookworm-armhf e18a358f9f62b2c547806b274bef3e8e9933b873"}}],"host rubintos0":[{"Type":"Start","Time":-24483196,"Avail":0},{"Time":604800,"Type":"End","Avail":1}],"host godello1":[{"Share":{"Wear":1,"Shares":"1","Type":"test-187679-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187679.test-amd64-amd64-xl-qemuu-ovmf-amd64","Avail":0,"Type":"Start","Time":-825},{"Share":{"Shares":1,"Type":"test-187679-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Avail":1,"Job":"187679.test-amd64-amd64-xl-qemuu-ovmf-amd64","Type":"End","Time":2789},{"Avail":1,"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"test-187679-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Time":2789}],"host huxelrebe1":[{"PreviousShare":{"Type":"test-187677-9HxhBN03nKbFdCvvWeU_tNd1nQGg5X7oE1gxnQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Type":"Unshare","Time":0,"Avail":1}],"host rubintos1":[{"Avail":0,"Time":-24483196,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host himrod1":[{"Avail":1,"PreviousShare":{"Wear":10,"Shares":3,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":0}],"host arndale-westfield":[{"Job":"187678.test-armhf-armhf-xl","Avail":0,"Share":{"Type":"test-187678-lSLuaEPp-ufw8EwsGFdcVdrdKx9xwNuWHpVQ4A 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Time":-3057,"Type":"Start"},{"Share":{"Wear":1,"Shares":1,"Type":"test-187678-lSLuaEPp-ufw8EwsGFdcVdrdKx9xwNuWHpVQ4A 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1,"Job":"187678.test-armhf-armhf-xl","Type":"End","Time":2720},{"Time":2720,"Type":"Unshare","PreviousShare":{"Shares":"1","Type":"test-187678-lSLuaEPp-ufw8EwsGFdcVdrdKx9xwNuWHpVQ4A 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Avail":1}],"host espadeiro1":[{"Time":-1927572,"Type":"Start","Avail":0},{"Time":604800,"Type":"End","Avail":1}],"host nobling0":[{"Avail":1,"PreviousShare":{"Wear":1,"Type":"test-187677-zJxwzpXnrh_7E-bya8N3OSiAFXcT87R0LuwDpQ 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1},"Type":"Unshare","Time":0}],"host sabro1":[{"Avail":1,"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":0}],"host fiano0":[{"Job":"187677.test-amd64-amd64-xl-qemut-ws16-amd64","Avail":0,"Share":{"Wear":1,"Shares":"1","Type":"test-187677-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":-5116,"Type":"Start"},{"Type":"End","Time":419,"Share":{"Type":"test-187677-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Avail":1,"Job":"187677.test-amd64-amd64-xl-qemut-ws16-amd64"},{"Avail":1,"Time":419,"Type":"Unshare","PreviousShare":{"Shares":"1","Type":"test-187677-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1}}],"host laxton1":[{"Time":0,"PreviousShare":{"Shares":3,"Type":"build-buster-arm64 cb303068d340f3344c760df46ac9785e08c0d889","Wear":1},"Type":"Unshare","Avail":1}],"host rochester1":[{"Type":"Start","Time":-2831,"Share":{"Type":"test-187673-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Job":"187673.test-arm64-arm64-libvirt-raw","Avail":0},{"Job":"187673.test-arm64-arm64-libvirt-raw","Avail":1,"Share":{"Type":"test-187673-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Time":1605,"Type":"End"},{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187673-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":1605,"Avail":1},{"Share":{"Type":"test-187674-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Avail":0,"Job":"187674.test-arm64-arm64-libvirt-raw","Type":"Start","Time":1605},{"Time":6000,"Type":"End","Avail":1,"Job":"187674.test-arm64-arm64-libvirt-raw","Share":{"Type":"test-187674-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1}},{"Avail":1,"Time":6000,"PreviousShare":{"Type":"test-187674-crMKvjavwyLPPe6Mkd77hnD6O0zdy_-d4tw1DA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare"},{"Share":{"Wear":1,"Type":"test-187674-WwVkIEokITIO5NIcrfAawDq4VlLK3kbrB9_idA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Avail":0,"Job":"187674.test-arm64-arm64-xl-credit1","Type":"Start","Time":6000},{"Type":"End","Time":9326,"Share":{"Wear":1,"Type":"test-187674-WwVkIEokITIO5NIcrfAawDq4VlLK3kbrB9_idA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1},"Avail":1,"Job":"187674.test-arm64-arm64-xl-credit1"},{"Avail":1,"Time":9326,"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187674-WwVkIEokITIO5NIcrfAawDq4VlLK3kbrB9_idA 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Time":9326,"Type":"Start","Job":"187674.test-arm64-arm64-xl-credit2","Avail":0,"Share":{"Type":"test-187674-Tu9QSbzacvdMaLrlZpMaRlAwIBrsnXWiilLPhA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1}},{"Time":12595,"Type":"End","Avail":1,"Job":"187674.test-arm64-arm64-xl-credit2","Share":{"Wear":1,"Type":"test-187674-Tu9QSbzacvdMaLrlZpMaRlAwIBrsnXWiilLPhA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1}},{"Avail":1,"Time":12595,"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"test-187674-Tu9QSbzacvdMaLrlZpMaRlAwIBrsnXWiilLPhA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"}},{"Share":{"Wear":1,"Shares":"1","Type":"test-187674-XeYks-QBwFqxp1uw07W8R3bIBbuP3E21iGIYOg 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187674.test-arm64-arm64-xl-xsm","Avail":0,"Type":"Start","Time":12595},{"Time":15757,"Type":"End","Job":"187674.test-arm64-arm64-xl-xsm","Avail":1,"Share":{"Shares":1,"Type":"test-187674-XeYks-QBwFqxp1uw07W8R3bIBbuP3E21iGIYOg 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1}},{"Time":15757,"PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187674-XeYks-QBwFqxp1uw07W8R3bIBbuP3E21iGIYOg 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Avail":1}],"host albana0":[{"PreviousShare":{"Shares":1,"Type":"test-187678-59e6JfkOo6o79tc2Yr9a8jvdl6YoJcuUg3LN6A 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Type":"Unshare","Time":0,"Avail":1}],"host debina1":[{"Avail":1,"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-r9fVz3haAySAY43anuw_MkvSirGpT4bYWhCi5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":0}],"host arndale-lakeside":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Type":"test-187674-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Time":0}],"host nocera1":[{"Time":-27251033,"Type":"Start","Avail":0},{"Type":"End","Time":604800,"Avail":1}],"host rimava1":[{"PreviousShare":{"Wear":2,"Shares":1,"Type":"test-187677-iUeEEOjmdsoSoRAstPZzPBUMHpCytd4luEFwvw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":0,"Avail":1}],"host sabro0":[{"Time":0,"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-IHYDIAK-JI-KgR1qA3wbut22VIpWIFNNln6jUw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Avail":1}],"host septiner1":[{"Avail":1,"Time":0,"Type":"Unshare","PreviousShare":{"Type":"test-187677-dqRkfERFjEdjk0FSlgMx8uySG8QTtzAmk5TD4g 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1}}],"host joubertin1":[{"Type":"Start","Time":-33365110,"Avail":0},{"Avail":1,"Type":"End","Time":604800}],"host italia1":[{"Time":0,"PreviousShare":{"Wear":1,"Type":"test-187677-Wkc-iRiTW8GdIwEw8ISckkZRTf9e8E8OzKhytA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1},"Type":"Unshare","Avail":1}],"host fiano1":[{"Avail":1,"Time":0,"PreviousShare":{"Type":"test-187677-pry8BrAek9u6PuJCFWmKtrPE-0Y4bqHYXF3jxg 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Type":"Unshare"}],"host verdesse0":[{"Avail":0,"Type":"Start","Time":-25078982},{"Type":"End","Time":604800,"Avail":1}],"host godello0":[{"Type":"Unshare","PreviousShare":{"Wear":3,"Type":"test-187677-XMUfzVXAO5OAmSvYJ5VH1-pCoEiyjZCdiGvHeA 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1},"Time":0,"Avail":1}],"host albana1":[{"Type":"Unshare","PreviousShare":{"Shares":1,"Type":"test-187677-LtoTP4avoc0reCaH6RIZfGyL6gvkPhnrXURxvw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Time":0,"Avail":1}],"host verdesse1":[{"Avail":0,"Time":-4167424,"Type":"Start"},{"Avail":1,"Time":604800,"Type":"End"}],"host espadeiro0":[{"Avail":0,"Type":"Start","Time":-3563551},{"Time":604800,"Type":"End","Avail":1}],"host rochester0":[{"Type":"Start","Time":-2001,"Share":{"Wear":1,"Type":"test-187673-oc5dY7Ri3Pzd_ICr1z1n0PHJG0hO97m7kKD7Yw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Job":"187673.test-arm64-arm64-libvirt-xsm","Avail":0},{"Type":"End","Time":1454,"Share":{"Wear":1,"Shares":1,"Type":"test-187673-oc5dY7Ri3Pzd_ICr1z1n0PHJG0hO97m7kKD7Yw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Job":"187673.test-arm64-arm64-libvirt-xsm","Avail":1},{"Avail":1,"Time":1454,"PreviousShare":{"Type":"test-187673-oc5dY7Ri3Pzd_ICr1z1n0PHJG0hO97m7kKD7Yw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare"},{"Time":1454,"Type":"Start","Avail":0,"Job":"187674.test-arm64-arm64-examine"},{"Avail":1,"Job":"187674.test-arm64-arm64-examine","Time":3402,"Type":"End"},{"Share":{"Shares":"1","Type":"test-187674-oc5dY7Ri3Pzd_ICr1z1n0PHJG0hO97m7kKD7Yw 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Avail":0,"Job":"187674.test-arm64-arm64-libvirt-xsm","Type":"Start","Time":3402},{"Time":6793,"Type":"End","Avail":1,"Job":"187674.test-arm64-arm64-libvirt-xsm","Share":{"Wear":1,"Type":"test-187674-oc5dY7Ri3Pzd_ICr1z1n0PHJG0hO97m7kKD7Yw 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1}},{"Time":6793,"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":"1","Type":"test-187674-oc5dY7Ri3Pzd_ICr1z1n0PHJG0hO97m7kKD7Yw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1},{"Share":{"Wear":1,"Shares":"1","Type":"test-187674-lytAHmBP-IYQgJdOXSkmKGozhsGiAtAMsKxS0w 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":0,"Job":"187674.test-arm64-arm64-xl-vhd","Type":"Start","Time":6793},{"Type":"End","Time":11090,"Share":{"Type":"test-187674-lytAHmBP-IYQgJdOXSkmKGozhsGiAtAMsKxS0w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Job":"187674.test-arm64-arm64-xl-vhd","Avail":1},{"Time":11090,"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"test-187674-lytAHmBP-IYQgJdOXSkmKGozhsGiAtAMsKxS0w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Avail":1},{"Time":11090,"Type":"Start","Job":"187674.test-arm64-arm64-xl","Avail":0,"Share":{"Wear":1,"Shares":"1","Type":"test-187674-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Share":{"Shares":1,"Type":"test-187674-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Avail":1,"Job":"187674.test-arm64-arm64-xl","Type":"End","Time":12351},{"Avail":1,"Time":12351,"PreviousShare":{"Type":"test-187674-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare"},{"Share":{"Shares":"1","Type":"test-187674-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Job":"187674.test-arm64-arm64-xl-thunderx","Avail":0,"Type":"Start","Time":12351},{"Job":"187674.test-arm64-arm64-xl-thunderx","Avail":1,"Share":{"Type":"test-187674-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1,"Wear":1},"Time":15467,"Type":"End"},{"Time":15467,"PreviousShare":{"Type":"test-187674-L9spQc_0XyKdmRypqJK6HbvNj2hLpTUjXqm8-w 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1","Wear":1},"Type":"Unshare","Avail":1}],"host cubietruck-metzinger":[{"Share":{"Shares":"1","Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Avail":0,"Job":"187674.build-armhf-libvirt","Type":"Start","Time":-3017},{"Time":49,"Type":"End","Job":"187674.build-armhf-libvirt","Avail":1,"Share":{"Wear":1,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":1}},{"Type":"Unshare","PreviousShare":{"Wear":1,"Type":"build-bookworm-armhf 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Time":49,"Avail":1}],"host septiner0":[{"Time":0,"Type":"Unshare","PreviousShare":{"Wear":2,"Shares":1,"Type":"test-187677-gjeSXtwWM8C2JXRPoy7iafl7V9DHjE0buDzgxA 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Avail":1}],"host nobling1":[{"Time":-1497,"Type":"Start","Avail":2,"Job":"187679.build-i386-pvops","Share":{"Wear":1,"Shares":"3","Type":"build-bookworm-i386 40660b4b01c49f3a75a7c3865523a30074b0e753"}},{"Avail":1,"Job":"187679.build-i386-libvirt","Share":{"Wear":2,"Shares":"3","Type":"build-bookworm-i386 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":-97,"Type":"Start"},{"Time":71,"Type":"End","Job":"187679.build-i386-libvirt","Avail":2,"Share":{"Type":"build-bookworm-i386 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":3,"Wear":2}},{"Job":"187679.build-i386-pvops","Avail":3,"Share":{"Type":"build-bookworm-i386 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":3,"Wear":2},"Time":1166,"Type":"End"},{"Type":"Unshare","PreviousShare":{"Wear":2,"Type":"build-bookworm-i386 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"3"},"Time":1166,"Avail":1}],"host huxelrebe0":[{"PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-3gjiQ4EgsK8PrWgNKbJ4nlq35GqfLA9Hwaaaxw 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Type":"Unshare","Time":0,"Avail":1}],"host pinot0":[{"Type":"Unshare","PreviousShare":{"Wear":1,"Shares":1,"Type":"test-187677-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":0,"Avail":1}],"host himrod2":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Wear":9,"Shares":3,"Type":"build-bookworm-amd64 40660b4b01c49f3a75a7c3865523a30074b0e753"},"Time":0}],"host himrod0":[{"Avail":1,"Type":"Unshare","PreviousShare":{"Shares":1,"Type":"test-187677-TYVTHhZCUWsVE0PXFaX-fW_DILl7nKaoqik_5Q 40660b4b01c49f3a75a7c3865523a30074b0e753","Wear":1},"Time":0}]}} 2024-09-12 20:24:33 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 purpose-test HID host TRY host pinot0: NEEDFLAG arch-armhf HID host TRY host pinot0: NEEDFLAG suite-bookworm HID host TRY host pinot0: NEEDFLAG arch-xen-armhf HID host TRY host pinot0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host cubietruck-gleizes: HID host TRY host cubietruck-gleizes: NEEDFLAG purpose-test HID host TRY host cubietruck-gleizes: NEEDFLAG arch-armhf HID host TRY host cubietruck-gleizes: NEEDFLAG suite-bookworm HID host TRY host cubietruck-gleizes: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-gleizes: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host godello0: HID host TRY host godello0: NEEDFLAG purpose-test HID host TRY host godello0: NEEDFLAG arch-armhf HID host TRY host godello0: NEEDFLAG suite-bookworm HID host TRY host godello0: NEEDFLAG arch-xen-armhf HID host TRY host godello0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host pinot1: HID host TRY host pinot1: NEEDFLAG purpose-test HID host TRY host pinot1: NEEDFLAG arch-armhf HID host TRY host pinot1: NEEDFLAG suite-bookworm HID host TRY host pinot1: NEEDFLAG arch-xen-armhf HID host TRY host pinot1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host fiano0: HID host TRY host fiano0: NEEDFLAG purpose-test HID host TRY host fiano0: NEEDFLAG arch-armhf HID host TRY host fiano0: NEEDFLAG suite-bookworm HID host TRY host fiano0: NEEDFLAG arch-xen-armhf HID host TRY host fiano0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host fiano1: HID host TRY host fiano1: NEEDFLAG purpose-test HID host TRY host fiano1: NEEDFLAG arch-armhf HID host TRY host fiano1: NEEDFLAG suite-bookworm HID host TRY host fiano1: NEEDFLAG arch-xen-armhf HID host TRY host fiano1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host italia0: HID host TRY host italia0: NEEDFLAG purpose-test HID host TRY host italia0: NEEDFLAG arch-armhf HID host TRY host italia0: NEEDFLAG suite-bookworm HID host TRY host italia0: NEEDFLAG arch-xen-armhf HID host TRY host italia0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host godello1: HID host TRY host godello1: NEEDFLAG purpose-test HID host TRY host godello1: NEEDFLAG arch-armhf HID host TRY host godello1: NEEDFLAG suite-bookworm HID host TRY host godello1: NEEDFLAG arch-xen-armhf HID host TRY host godello1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host cubietruck-braque: HID host TRY host cubietruck-braque: NEEDFLAG purpose-test HID host TRY host cubietruck-braque: NEEDFLAG arch-armhf HID host TRY host cubietruck-braque: NEEDFLAG suite-bookworm HID host TRY host cubietruck-braque: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-braque: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host cubietruck-metzinger: HID host TRY host cubietruck-metzinger: NEEDFLAG purpose-test HID host TRY host cubietruck-metzinger: NEEDFLAG arch-armhf HID host TRY host cubietruck-metzinger: NEEDFLAG suite-bookworm HID host TRY host cubietruck-metzinger: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-metzinger: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host albana0: HID host TRY host albana0: NEEDFLAG purpose-test HID host TRY host albana0: NEEDFLAG arch-armhf HID host TRY host albana0: NEEDFLAG suite-bookworm HID host TRY host albana0: NEEDFLAG arch-xen-armhf HID host TRY host albana0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host albana1: HID host TRY host albana1: NEEDFLAG purpose-test HID host TRY host albana1: NEEDFLAG arch-armhf HID host TRY host albana1: NEEDFLAG suite-bookworm HID host TRY host albana1: NEEDFLAG arch-xen-armhf HID host TRY host albana1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host cubietruck-picasso: HID host TRY host cubietruck-picasso: NEEDFLAG purpose-test HID host TRY host cubietruck-picasso: NEEDFLAG arch-armhf HID host TRY host cubietruck-picasso: NEEDFLAG suite-bookworm HID host TRY host cubietruck-picasso: NEEDFLAG arch-xen-armhf HID host TRY host cubietruck-picasso: FLAGS MISSINGFLAGS: purpose-test. HID host TRY host rochester0: HID host TRY host rochester0: NEEDFLAG purpose-test HID host TRY host rochester0: NEEDFLAG arch-armhf HID host TRY host rochester0: NEEDFLAG suite-bookworm HID host TRY host rochester0: NEEDFLAG arch-xen-armhf HID host TRY host rochester0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host rochester1: HID host TRY host rochester1: NEEDFLAG purpose-test HID host TRY host rochester1: NEEDFLAG arch-armhf HID host TRY host rochester1: NEEDFLAG suite-bookworm HID host TRY host rochester1: NEEDFLAG arch-xen-armhf HID host TRY host rochester1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host debina0: HID host TRY host debina0: NEEDFLAG purpose-test HID host TRY host debina0: NEEDFLAG arch-armhf HID host TRY host debina0: NEEDFLAG suite-bookworm HID host TRY host debina0: NEEDFLAG arch-xen-armhf HID host TRY host debina0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host debina1: HID host TRY host debina1: NEEDFLAG purpose-test HID host TRY host debina1: NEEDFLAG arch-armhf HID host TRY host debina1: NEEDFLAG suite-bookworm HID host TRY host debina1: NEEDFLAG arch-xen-armhf HID host TRY host debina1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host huxelrebe0: HID host TRY host huxelrebe0: NEEDFLAG purpose-test HID host TRY host huxelrebe0: NEEDFLAG arch-armhf HID host TRY host huxelrebe0: NEEDFLAG suite-bookworm HID host TRY host huxelrebe0: NEEDFLAG arch-xen-armhf HID host TRY host huxelrebe0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host huxelrebe1: HID host TRY host huxelrebe1: NEEDFLAG purpose-test HID host TRY host huxelrebe1: NEEDFLAG arch-armhf HID host TRY host huxelrebe1: NEEDFLAG suite-bookworm HID host TRY host huxelrebe1: NEEDFLAG arch-xen-armhf HID host TRY host huxelrebe1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host sabro0: HID host TRY host sabro0: NEEDFLAG purpose-test HID host TRY host sabro0: NEEDFLAG arch-armhf HID host TRY host sabro0: NEEDFLAG suite-bookworm HID host TRY host sabro0: NEEDFLAG arch-xen-armhf HID host TRY host sabro0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host rimava0: HID host TRY host rimava0: NEEDFLAG purpose-test HID host TRY host rimava0: NEEDFLAG arch-armhf HID host TRY host rimava0: NEEDFLAG suite-bookworm HID host TRY host rimava0: NEEDFLAG arch-xen-armhf HID host TRY host rimava0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host rimava1: HID host TRY host rimava1: NEEDFLAG purpose-test HID host TRY host rimava1: NEEDFLAG arch-armhf HID host TRY host rimava1: NEEDFLAG suite-bookworm HID host TRY host rimava1: NEEDFLAG arch-xen-armhf HID host TRY host rimava1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host arndale-lakeside: HID host TRY host arndale-lakeside: NEEDFLAG purpose-test HID host TRY host arndale-lakeside: NEEDFLAG arch-armhf HID host TRY host arndale-lakeside: NEEDFLAG suite-bookworm HID host TRY host arndale-lakeside: NEEDFLAG arch-xen-armhf HID host TRY host arndale-lakeside: FLAGS MISSINGFLAGS: . HID host TRY host arndale-lakeside: GOOD HID host TRY host arndale-lakeside: EQUIV-MOST-RECENT 187566.test-armhf-armhf-libvirt arndale-metrocentre pass. HID host TRY host arndale-lakeside: SharedMaxWear FROM-HID HID host TRY host arndale-lakeside: SharedMaxTasks FROM-HID HID host TRY host arndale-lakeside: CANDIDATE. HID host TRY host arndale-metrocentre: HID host TRY host arndale-metrocentre: NEEDFLAG purpose-test HID host TRY host arndale-metrocentre: NEEDFLAG arch-armhf HID host TRY host arndale-metrocentre: NEEDFLAG suite-bookworm HID host TRY host arndale-metrocentre: NEEDFLAG arch-xen-armhf HID host TRY host arndale-metrocentre: FLAGS MISSINGFLAGS: . HID host TRY host arndale-metrocentre: GOOD HID host TRY host arndale-metrocentre: EQUIV-MOST-RECENT 187566.test-armhf-armhf-libvirt arndale-metrocentre pass. HID host TRY host arndale-metrocentre: SharedMaxWear FROM-HID HID host TRY host arndale-metrocentre: SharedMaxTasks FROM-HID HID host TRY host arndale-metrocentre: CANDIDATE. HID host TRY host arndale-westfield: HID host TRY host arndale-westfield: NEEDFLAG purpose-test HID host TRY host arndale-westfield: NEEDFLAG arch-armhf HID host TRY host arndale-westfield: NEEDFLAG suite-bookworm HID host TRY host arndale-westfield: NEEDFLAG arch-xen-armhf HID host TRY host arndale-westfield: FLAGS MISSINGFLAGS: . HID host TRY host arndale-westfield: GOOD HID host TRY host arndale-westfield: EQUIV-MOST-RECENT 187566.test-armhf-armhf-libvirt arndale-metrocentre pass. HID host TRY host arndale-westfield: SharedMaxWear FROM-HID HID host TRY host arndale-westfield: SharedMaxTasks FROM-HID HID host TRY host arndale-westfield: CANDIDATE. HID host TRY host himrod0: HID host TRY host himrod0: NEEDFLAG purpose-test HID host TRY host himrod0: NEEDFLAG arch-armhf HID host TRY host himrod0: NEEDFLAG suite-bookworm HID host TRY host himrod0: NEEDFLAG arch-xen-armhf HID host TRY host himrod0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nocera0: HID host TRY host nocera0: NEEDFLAG purpose-test HID host TRY host nocera0: NEEDFLAG arch-armhf HID host TRY host nocera0: NEEDFLAG suite-bookworm HID host TRY host nocera0: NEEDFLAG arch-xen-armhf HID host TRY host nocera0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nocera1: HID host TRY host nocera1: NEEDFLAG purpose-test HID host TRY host nocera1: NEEDFLAG arch-armhf HID host TRY host nocera1: NEEDFLAG suite-bookworm HID host TRY host nocera1: NEEDFLAG arch-xen-armhf HID host TRY host nocera1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host himrod1: HID host TRY host himrod1: NEEDFLAG purpose-test HID host TRY host himrod1: NEEDFLAG arch-armhf HID host TRY host himrod1: NEEDFLAG suite-bookworm HID host TRY host himrod1: NEEDFLAG arch-xen-armhf HID host TRY host himrod1: FLAGS MISSINGFLAGS: purpose-test arch-armhf arch-xen-armhf. HID host TRY host himrod2: HID host TRY host himrod2: NEEDFLAG purpose-test HID host TRY host himrod2: NEEDFLAG arch-armhf HID host TRY host himrod2: NEEDFLAG suite-bookworm HID host TRY host himrod2: NEEDFLAG arch-xen-armhf HID host TRY host himrod2: FLAGS MISSINGFLAGS: purpose-test arch-armhf arch-xen-armhf. HID host TRY host sabro1: HID host TRY host sabro1: NEEDFLAG purpose-test HID host TRY host sabro1: NEEDFLAG arch-armhf HID host TRY host sabro1: NEEDFLAG suite-bookworm HID host TRY host sabro1: NEEDFLAG arch-xen-armhf HID host TRY host sabro1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nobling0: HID host TRY host nobling0: NEEDFLAG purpose-test HID host TRY host nobling0: NEEDFLAG arch-armhf HID host TRY host nobling0: NEEDFLAG suite-bookworm HID host TRY host nobling0: NEEDFLAG arch-xen-armhf HID host TRY host nobling0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host nobling1: HID host TRY host nobling1: NEEDFLAG purpose-test HID host TRY host nobling1: NEEDFLAG arch-armhf HID host TRY host nobling1: NEEDFLAG suite-bookworm HID host TRY host nobling1: NEEDFLAG arch-xen-armhf HID host TRY host nobling1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host italia1: HID host TRY host italia1: NEEDFLAG purpose-test HID host TRY host italia1: NEEDFLAG arch-armhf HID host TRY host italia1: NEEDFLAG suite-bookworm HID host TRY host italia1: NEEDFLAG arch-xen-armhf HID host TRY host italia1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host septiner0: HID host TRY host septiner0: NEEDFLAG purpose-test HID host TRY host septiner0: NEEDFLAG arch-armhf HID host TRY host septiner0: NEEDFLAG suite-bookworm HID host TRY host septiner0: NEEDFLAG arch-xen-armhf HID host TRY host septiner0: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. HID host TRY host septiner1: HID host TRY host septiner1: NEEDFLAG purpose-test HID host TRY host septiner1: NEEDFLAG arch-armhf HID host TRY host septiner1: NEEDFLAG suite-bookworm HID host TRY host septiner1: NEEDFLAG arch-xen-armhf HID host TRY host septiner1: FLAGS MISSINGFLAGS: arch-armhf arch-xen-armhf. ORDER host RECURSE host... RECURSE CAND host arndale-lakeside RECURSE EVAL host arndale-lakeside RECURSE EVAL DURATION 3647 va=7776000 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-187674-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 1 vs. 1 RECURSE FINAL start=0 va=7776000 variation_bonus=32478.1884469213 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-32478.1884469213 RECURSE FINAL BEST: host arndale-lakeside RECURSE CAND host arndale-metrocentre RECURSE EVAL host arndale-metrocentre RECURSE EVAL DURATION 3586 va=396667 RECURSE PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 1759 RECURSE PLAN LOOP reqs[0]=host evtix=1 try=1759 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=2 try=1759 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=3 try=1759 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 5176 RECURSE PLAN LOOP reqs[0]=host evtix=4 try=5176 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=5 try=5176 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=6 try=5176 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 8959 RECURSE PLAN LOOP reqs[0]=host evtix=7 try=8959 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=8 try=8959 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP AVAIL OK RECURSE PLAN NEXT reqs[0]=host try=8959 confirmed=0 reuse=0 RECURSE PLAN LOOP SHARE-COMPAT-OK type test-187674-vXYkGzVKkZ6sf9NaQcwzEdB9fCzy7Oyv9w-cYA 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 1 vs. 1 RECURSE FINAL start=8959 va=396667 variation_bonus=12392.4073289648 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-3433.40732896481 RECURSE CAND host arndale-westfield RECURSE EVAL host arndale-westfield RECURSE EVAL DURATION 3647 va=722365 RECURSE PLAN LOOP reqs[0]=host evtix=0 try=0 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP BAD 2720 RECURSE PLAN LOOP reqs[0]=host evtix=1 try=2720 confirmed=0 RECURSE PLAN LOOP reqs[0]=host evtix=2 try=2720 confirmed=0 RECURSE PLAN LOOP OVERLAP RECURSE PLAN LOOP OVERLAP AVAIL OK RECURSE PLAN NEXT reqs[0]=host try=2720 confirmed=0 reuse=0 RECURSE PLAN LOOP SHARE-COMPAT-OK type test-187678-lSLuaEPp-ufw8EwsGFdcVdrdKx9xwNuWHpVQ4A 40660b4b01c49f3a75a7c3865523a30074b0e753 vs. test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A 40660b4b01c49f3a75a7c3865523a30074b0e753 wear 1 shares 1 vs. 1 RECURSE FINAL start=2720 va=722365 variation_bonus=16102.949162211 previously_failed=0 previously_failed_equiv=0 eff.share_bonus=0*20000 cost=-13382.949162211 host host arndale-lakeside ALLOC PLAIN 0 (3, 2) host host arndale-lakeside ALLOC ISSHARED test-187674-2MYIe8lxsLB02Syx-VSHXeHNK575kq4YA--63g 40660b4b01c49f3a75a7c3865523a30074b0e753 ready 0 1 40660b4b01c49f3a75a7c3865523a30074b0e753 host host arndale-lakeside ALLOC ISSHARED CAN-UNSHARE HID host ALLOC host arndale-lakeside 0 HID host GO host arndale-lakeside 0 UNSHARE HID host GO host arndale-lakeside 0 SHARE 2024-09-12 20:24:33 Z allocating for host: share-host arndale-lakeside 1 HID host GO share-host arndale-lakeside 1 ALLOCATE 2024-09-12 20:24:33 Z host allocation: successful, reporting to planner. 2024-09-12 20:24:33 Z resource allocation: booking @0 host arndale-lakeside [host]. bookings = {"Bookings":[{"Reso":"host arndale-lakeside","Job":"187674.test-armhf-armhf-libvirt","Share":{"Type":"test-187674-9t1acbP3UDfDgESkeKvFfet13ogZUyyJGGxp4A 40660b4b01c49f3a75a7c3865523a30074b0e753","Shares":"1"},"Xinfo":"host","Allocated":{"Shareix":"1","Task":"2542931"},"End":3647,"Start":"0"}],"ClientNotes":{}} 2024-09-12 20:24:33 Z resource allocation: we are in the plan. 2024-09-12 20:24:33 Z resource allocation: successful. 2024-09-12 20:24:33 Z runvar store: host=arndale-lakeside 2024-09-12 20:24:33 Z host allocation: all successful and recorded.