blocker Delay | 57079 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 29113 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 blocker Delay | 1746 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 blocker Delay | 1247 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 668 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X blocker Delay | 419 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X blocker Delay | 260 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 257 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Delay | 224 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 blocker Delay | 201 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 189 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') blocker Delay | 187 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC blocker Delay | 176 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 158 COPY public.runvars (flight, job, name, val, synth) TO stdout; blocker Delay | 152 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 137 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 112 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 93 COMMIT blocker Delay | 89 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 blocker Delay | 84 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout; blocker Delay | 79 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 71 | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 50 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 41 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; blocker Delay | 41 UPDATE tasks SET live = 'f' WHERE taskid = 366548 blocker Delay | 34 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t' blocker Delay | 34 commit blocker Delay | 30 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; blocker Delay | 27 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | in transaction blocker Delay | 21 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') blocker Delay | 20 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 20 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14 blocker Delay | 20 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | in transaction blocker Delay | 20 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 16 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5 blocker Delay | 15 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X blocker Delay | 13 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13 blocker Delay | 13 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 13 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1 blocker Delay | 13 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING') blocker Delay | 12 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X) blocker Delay | 12 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Delay | 12 autovacuum: ANALYZE pg_catalog.pg_depend blocker Delay | 10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 10 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 blocker Delay | 9 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X blocker Delay | 8 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 8 autovacuum: VACUUM public.tasks blocker Delay | 7 commit | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 6 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 6 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6 blocker Delay | 5 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Delay | 4 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING') blocker Delay | 3 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 3 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1 blocker Delay | 2 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING') blocker Delay | 0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 blocker Delay | 0 UPDATE tasks SET live = 'f' WHERE taskid = 366700 blocker Delay | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3 blocker Delay | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1 blocker Delay | 0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Delay | 0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE blocker Delay | 0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; blocker Delay | 0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend blocker Delay | 0 blocker Delay | 0 BEGIN blocker Delay | 0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL ) blocker Delay | 0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing' blocker Delay | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13 blocker Delay | 0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check') blocker Delay | 0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING') blocker Delay | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC blocker Delay | 0 SELECT hostflag FROM hostflags WHERE hostname=$X blocker Delay | 0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass' blocker Delay | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | in transaction blocker Delay | 0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE blocker Delay | 0 commit | in transaction blocker Delay | 0 SELECT blessing FROM flights WHERE flight=$X blocker Delay | 0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X blocker Delay | 0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X blocker Delay | 0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3 blocker Delay | 0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X blocker Delay | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction blocker Delay | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20 blocker Delay | 0 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | in transaction blocker Delay | -1 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | in transaction blocker Delay | -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | in transaction blocker Delay | -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 blocker Delay | -1 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | in transaction blocker Delay | -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' blocker Delay | -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | in transaction blocker Delay | -2 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | in transaction blocker Delay | -2 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno blocker Delay | -3 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X blocker Delay | -3 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | in transaction blocker Delay | -4 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X blocker Delay | -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | in transaction blocker Delay | -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val blocker Delay | -8 | LOCK TABLE flights IN EXCLUSIVE MODE | in transaction blocker Delay | -12 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC blocker Delay | -14 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction blocker Delay | -15 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | in transaction blocker Delay | -29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' blocker Delay | -93 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' blocker Delay | -96 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC blocker Delay | -142 | in transaction blocker Delay | -3372 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid blocker Tasks | 6702 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid blocker Tasks | 4188 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1253 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 blocker Tasks | 880 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; blocker Tasks | 360 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 323 | in transaction blocker Tasks | 196 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC blocker Tasks | 187 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' blocker Tasks | 90 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC blocker Tasks | 61 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' blocker Tasks | 48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 44 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 blocker Tasks | 39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 34 COMMIT blocker Tasks | 29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction blocker Tasks | 29 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | in transaction blocker Tasks | 29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Tasks | 24 | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 19 | LOCK TABLE flights IN EXCLUSIVE MODE | in transaction blocker Tasks | 18 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') blocker Tasks | 17 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 16 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X blocker Tasks | 16 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 blocker Tasks | 16 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X blocker Tasks | 13 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1 blocker Tasks | 11 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | in transaction blocker Tasks | 10 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val blocker Tasks | 10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; blocker Tasks | 10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 9 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X blocker Tasks | 9 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC blocker Tasks | 9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 9 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X blocker Tasks | 8 commit blocker Tasks | 8 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; blocker Tasks | 7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 6 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | in transaction blocker Tasks | 5 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' blocker Tasks | 5 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | in transaction blocker Tasks | 5 COPY public.runvars (flight, job, name, val, synth) TO stdout; blocker Tasks | 5 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno blocker Tasks | 5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 5 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout; blocker Tasks | 4 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | in transaction blocker Tasks | 4 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 blocker Tasks | 4 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X blocker Tasks | 4 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 blocker Tasks | 4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 4 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 4 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | in transaction blocker Tasks | 4 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | in transaction blocker Tasks | 3 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Tasks | 3 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1 blocker Tasks | 3 blocker Tasks | 2 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') blocker Tasks | 2 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X blocker Tasks | 2 autovacuum: VACUUM public.tasks blocker Tasks | 2 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | in transaction blocker Tasks | 2 SELECT blessing FROM flights WHERE flight=$X blocker Tasks | 2 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | in transaction blocker Tasks | 2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction blocker Tasks | 2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Tasks | 1 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | in transaction blocker Tasks | 1 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC blocker Tasks | 1 autovacuum: ANALYZE pg_catalog.pg_depend blocker Tasks | 1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 1 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X) blocker Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5 blocker Tasks | 1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING') blocker Tasks | 1 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13 blocker Tasks | 1 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING') blocker Tasks | 1 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend blocker Tasks | 1 UPDATE tasks SET live = 'f' WHERE taskid = 366548 blocker Tasks | 1 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 blocker Tasks | 1 commit | in transaction blocker Tasks | 1 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING') blocker Tasks | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | in transaction blocker Tasks | 1 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 blocker Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6 blocker Tasks | 1 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass' blocker Tasks | 1 BEGIN blocker Tasks | 1 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check') blocker Tasks | 1 UPDATE tasks SET live = 'f' WHERE taskid = 366700 blocker Tasks | 1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Tasks | 1 commit | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE blocker Tasks | 1 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3 blocker Tasks | 1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | in transaction blocker Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3 blocker Tasks | 1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 SELECT hostflag FROM hostflags WHERE hostname=$X blocker Tasks | 1 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing' blocker Tasks | 1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13 blocker Tasks | 1 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X blocker Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20 blocker Tasks | 1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1 blocker Tasks | 1 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X blocker Tasks | 1 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X blocker Tasks | 1 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t' blocker Tasks | 1 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL ) blocker Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14 blocker Tasks | 1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE blocker Tasks | 1 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING') blocker Tasks | 0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 4188 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 359 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 29 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 24 | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 17 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 4 | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 commit | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE blocker Waiters | 1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE blocker Waiters | 0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') blocker Waiters | 0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X blocker Waiters | 0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | in transaction blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC blocker Waiters | 0 autovacuum: ANALYZE pg_catalog.pg_depend blocker Waiters | 0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' blocker Waiters | 0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X blocker Waiters | 0 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X blocker Waiters | 0 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X) blocker Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5 blocker Waiters | 0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC blocker Waiters | 0 autovacuum: VACUUM public.tasks blocker Waiters | 0 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING') blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction blocker Waiters | 0 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13 blocker Waiters | 0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING') blocker Waiters | 0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend blocker Waiters | 0 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid blocker Waiters | 0 | LOCK TABLE flights IN EXCLUSIVE MODE | in transaction blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Waiters | 0 commit blocker Waiters | 0 UPDATE tasks SET live = 'f' WHERE taskid = 366548 blocker Waiters | 0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val blocker Waiters | 0 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 blocker Waiters | 0 commit | in transaction blocker Waiters | 0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | in transaction blocker Waiters | 0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | in transaction blocker Waiters | 0 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING') blocker Waiters | 0 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | in transaction blocker Waiters | 0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 blocker Waiters | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 blocker Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6 blocker Waiters | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1 blocker Waiters | 0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 blocker Waiters | 0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass' blocker Waiters | 0 BEGIN blocker Waiters | 0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 blocker Waiters | 0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | in transaction blocker Waiters | 0 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X blocker Waiters | 0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC blocker Waiters | 0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X blocker Waiters | 0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check') blocker Waiters | 0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 blocker Waiters | 0 | in transaction blocker Waiters | 0 UPDATE tasks SET live = 'f' WHERE taskid = 366700 blocker Waiters | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Waiters | 0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3 blocker Waiters | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | in transaction blocker Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3 blocker Waiters | 0 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1 blocker Waiters | 0 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 blocker Waiters | 0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | in transaction blocker Waiters | 0 SELECT hostflag FROM hostflags WHERE hostname=$X blocker Waiters | 0 SELECT blessing FROM flights WHERE flight=$X blocker Waiters | 0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing' blocker Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13 blocker Waiters | 0 blocker Waiters | 0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X blocker Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20 blocker Waiters | 0 COMMIT blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1 blocker Waiters | 0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X blocker Waiters | 0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X blocker Waiters | 0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | in transaction blocker Waiters | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Waiters | 0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' blocker Waiters | 0 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t' blocker Waiters | 0 COPY public.runvars (flight, job, name, val, synth) TO stdout; blocker Waiters | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | in transaction blocker Waiters | 0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | in transaction blocker Waiters | 0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno blocker Waiters | 0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; blocker Waiters | 0 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC blocker Waiters | 0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X blocker Waiters | 0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL ) blocker Waiters | 0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') blocker Waiters | 0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' blocker Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14 blocker Waiters | 0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING') blocker Waiters | 0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | in transaction blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction blocker Waiters | 0 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout; blocker Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 blocker Waiters | 0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | in transaction direct Delay | 57079 | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 29113 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 direct Delay | 1746 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 direct Delay | 1247 | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 668 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X direct Delay | 419 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X direct Delay | 260 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 257 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Delay | 224 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 direct Delay | 201 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 189 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') direct Delay | 187 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC direct Delay | 176 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 158 COPY public.runvars (flight, job, name, val, synth) TO stdout; direct Delay | 152 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 137 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 112 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 93 COMMIT direct Delay | 89 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 direct Delay | 84 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout; direct Delay | 79 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 71 | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 50 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 41 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; direct Delay | 41 UPDATE tasks SET live = 'f' WHERE taskid = 366548 direct Delay | 34 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t' direct Delay | 34 commit direct Delay | 30 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; direct Delay | 27 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | in transaction direct Delay | 21 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') direct Delay | 20 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 20 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14 direct Delay | 20 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | in transaction direct Delay | 20 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 16 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5 direct Delay | 15 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X direct Delay | 13 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13 direct Delay | 13 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 13 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1 direct Delay | 13 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING') direct Delay | 12 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X) direct Delay | 12 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Delay | 12 autovacuum: ANALYZE pg_catalog.pg_depend direct Delay | 10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 10 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 direct Delay | 9 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X direct Delay | 8 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 8 autovacuum: VACUUM public.tasks direct Delay | 7 commit | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 6 | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 6 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6 direct Delay | 5 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Delay | 4 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING') direct Delay | 3 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 3 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1 direct Delay | 2 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING') direct Delay | 0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 direct Delay | 0 UPDATE tasks SET live = 'f' WHERE taskid = 366700 direct Delay | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3 direct Delay | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1 direct Delay | 0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Delay | 0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE direct Delay | 0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; direct Delay | 0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend direct Delay | 0 direct Delay | 0 BEGIN direct Delay | 0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL ) direct Delay | 0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing' direct Delay | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13 direct Delay | 0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check') direct Delay | 0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING') direct Delay | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC direct Delay | 0 SELECT hostflag FROM hostflags WHERE hostname=$X direct Delay | 0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass' direct Delay | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | in transaction direct Delay | 0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE direct Delay | 0 commit | in transaction direct Delay | 0 SELECT blessing FROM flights WHERE flight=$X direct Delay | 0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X direct Delay | 0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X direct Delay | 0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3 direct Delay | 0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X direct Delay | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction direct Delay | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20 direct Delay | 0 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | in transaction direct Delay | -1 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | in transaction direct Delay | -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | in transaction direct Delay | -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 direct Delay | -1 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | in transaction direct Delay | -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' direct Delay | -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | in transaction direct Delay | -2 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | in transaction direct Delay | -2 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno direct Delay | -3 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X direct Delay | -3 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | in transaction direct Delay | -4 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X direct Delay | -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | in transaction direct Delay | -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val direct Delay | -8 | LOCK TABLE flights IN EXCLUSIVE MODE | in transaction direct Delay | -12 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC direct Delay | -14 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction direct Delay | -15 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | in transaction direct Delay | -29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' direct Delay | -93 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' direct Delay | -96 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC direct Delay | -142 | in transaction direct Delay | -3372 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid direct Tasks | 6702 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid direct Tasks | 4188 | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1253 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 direct Tasks | 880 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; direct Tasks | 360 | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 323 | in transaction direct Tasks | 196 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC direct Tasks | 187 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' direct Tasks | 90 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC direct Tasks | 61 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' direct Tasks | 48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 44 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 direct Tasks | 39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 34 COMMIT direct Tasks | 29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction direct Tasks | 29 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | in transaction direct Tasks | 29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Tasks | 24 | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 19 | LOCK TABLE flights IN EXCLUSIVE MODE | in transaction direct Tasks | 18 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 18 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') direct Tasks | 16 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X direct Tasks | 16 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 direct Tasks | 16 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X direct Tasks | 13 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1 direct Tasks | 11 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | in transaction direct Tasks | 10 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val direct Tasks | 10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; direct Tasks | 10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 9 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X direct Tasks | 9 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC direct Tasks | 9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 9 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X direct Tasks | 8 commit direct Tasks | 8 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; direct Tasks | 7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 6 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | in transaction direct Tasks | 5 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' direct Tasks | 5 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | in transaction direct Tasks | 5 COPY public.runvars (flight, job, name, val, synth) TO stdout; direct Tasks | 5 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno direct Tasks | 5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 5 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout; direct Tasks | 4 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | in transaction direct Tasks | 4 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 direct Tasks | 4 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X direct Tasks | 4 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 direct Tasks | 4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 4 | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 4 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | in transaction direct Tasks | 4 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | in transaction direct Tasks | 3 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Tasks | 3 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1 direct Tasks | 3 direct Tasks | 2 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') direct Tasks | 2 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X direct Tasks | 2 autovacuum: VACUUM public.tasks direct Tasks | 2 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | in transaction direct Tasks | 2 SELECT blessing FROM flights WHERE flight=$X direct Tasks | 2 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 2 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | in transaction direct Tasks | 2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction direct Tasks | 2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Tasks | 1 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | in transaction direct Tasks | 1 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC direct Tasks | 1 autovacuum: ANALYZE pg_catalog.pg_depend direct Tasks | 1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X) direct Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5 direct Tasks | 1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING') direct Tasks | 1 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13 direct Tasks | 1 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING') direct Tasks | 1 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend direct Tasks | 1 UPDATE tasks SET live = 'f' WHERE taskid = 366548 direct Tasks | 1 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 direct Tasks | 1 commit | in transaction direct Tasks | 1 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING') direct Tasks | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | in transaction direct Tasks | 1 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 direct Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6 direct Tasks | 1 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass' direct Tasks | 1 BEGIN direct Tasks | 1 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check') direct Tasks | 1 UPDATE tasks SET live = 'f' WHERE taskid = 366700 direct Tasks | 1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Tasks | 1 commit | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE direct Tasks | 1 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3 direct Tasks | 1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | in transaction direct Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3 direct Tasks | 1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 SELECT hostflag FROM hostflags WHERE hostname=$X direct Tasks | 1 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing' direct Tasks | 1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13 direct Tasks | 1 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X direct Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20 direct Tasks | 1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1 direct Tasks | 1 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X direct Tasks | 1 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X direct Tasks | 1 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t' direct Tasks | 1 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL ) direct Tasks | 1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14 direct Tasks | 1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE direct Tasks | 1 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING') direct Waiters | 4188 | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 359 | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 29 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 24 | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 18 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 4 | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 2 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 commit | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE direct Waiters | 1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE direct Waiters | 0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') direct Waiters | 0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X direct Waiters | 0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | in transaction direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC direct Waiters | 0 autovacuum: ANALYZE pg_catalog.pg_depend direct Waiters | 0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' direct Waiters | 0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X direct Waiters | 0 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X direct Waiters | 0 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X) direct Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5 direct Waiters | 0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC direct Waiters | 0 autovacuum: VACUUM public.tasks direct Waiters | 0 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING') direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction direct Waiters | 0 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13 direct Waiters | 0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING') direct Waiters | 0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend direct Waiters | 0 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid direct Waiters | 0 | LOCK TABLE flights IN EXCLUSIVE MODE | in transaction direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Waiters | 0 commit direct Waiters | 0 UPDATE tasks SET live = 'f' WHERE taskid = 366548 direct Waiters | 0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val direct Waiters | 0 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 direct Waiters | 0 commit | in transaction direct Waiters | 0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | in transaction direct Waiters | 0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | in transaction direct Waiters | 0 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING') direct Waiters | 0 | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | in transaction direct Waiters | 0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14 direct Waiters | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 direct Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6 direct Waiters | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1 direct Waiters | 0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 direct Waiters | 0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass' direct Waiters | 0 BEGIN direct Waiters | 0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1 direct Waiters | 0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | in transaction direct Waiters | 0 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X direct Waiters | 0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC direct Waiters | 0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X direct Waiters | 0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check') direct Waiters | 0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 direct Waiters | 0 | in transaction direct Waiters | 0 UPDATE tasks SET live = 'f' WHERE taskid = 366700 direct Waiters | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Waiters | 0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3 direct Waiters | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | in transaction direct Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3 direct Waiters | 0 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1 direct Waiters | 0 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 direct Waiters | 0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | in transaction direct Waiters | 0 SELECT hostflag FROM hostflags WHERE hostname=$X direct Waiters | 0 SELECT blessing FROM flights WHERE flight=$X direct Waiters | 0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing' direct Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13 direct Waiters | 0 direct Waiters | 0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X direct Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20 direct Waiters | 0 COMMIT direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1 direct Waiters | 0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X direct Waiters | 0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X direct Waiters | 0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | in transaction direct Waiters | 0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Waiters | 0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' direct Waiters | 0 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t' direct Waiters | 0 COPY public.runvars (flight, job, name, val, synth) TO stdout; direct Waiters | 0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | in transaction direct Waiters | 0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | in transaction direct Waiters | 0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno direct Waiters | 0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; direct Waiters | 0 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC direct Waiters | 0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X direct Waiters | 0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL ) direct Waiters | 0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') direct Waiters | 0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' direct Waiters | 0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14 direct Waiters | 0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING') direct Waiters | 0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | in transaction direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | in transaction direct Waiters | 0 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout; direct Waiters | 0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 direct Waiters | 0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | in transaction