this derivation will be built: /nix/store/s3gpahn8w8qk1c6bxkma71w2335n2mnq-devloop-queries.drv these 21 paths will be fetched (5.1 MiB download, 25.6 MiB unpacked): /nix/store/11kaq9dy8pblq0vnx4br4wc268yp79gs-devloop-queries-ci_attribute-old.sql /nix/store/l93cp743a3swcrmpblzkchp4097wcyy0-devloop-queries-ci_attribute-old.sql /nix/store/lmmgxdrpmxwjks7vlskkdssb4sf5w27c-devloop-queries-ci_attribute-old.sql /nix/store/1lgc333b87r91k9l9vcqxrqqdrwxkj4h-devloop-queries-ci_attribute-recent.sql /nix/store/g14f4w6v4ig3h7s9fq9jk1b4im3w5mfb-devloop-queries-ci_attribute-recent.sql /nix/store/gvmknhsyskfl1i3w6i0bmd4rzlk929xs-devloop-queries-ci_attribute-recent.sql /nix/store/z7cysg6j2mmpkdb95qqvlkicmm9a092z-devloop-queries-ci_build-old.sql /nix/store/93dcras54glngsnnrmjflbnyxwnhmx8g-devloop-queries-ci_build-recent.sql /nix/store/cfzblq5cq80w3fag1i9sgvxw59zlw78v-devloop-queries-clock.sql /nix/store/5ncy1zyjgbk6zqqpjsg891gp9917kfbz-devloop-queries-fixture_errors-all.sql /nix/store/3wybdrc9cp5g3k4am5sa2bfi9iyw3nbm-devloop-queries-grants.sql /nix/store/a2mw3mp3sbmvqg39v2c6nc7r0kp5z7z2-devloop-queries-grants.sql /nix/store/h68l5hb4jwgcx1b24linx50kz3s41fhc-devloop-queries-grants.sql /nix/store/a4q9frhff0z4kw12s0mnqhr0c90913p4-devloop-queries-reconcile_attributes-window.sql /nix/store/bgh4pkfj8819hiz8wchxgy4i6pqm1i6r-devloop-queries-reconcile_batch_builds-window.sql /nix/store/6kpsf46wc7srah8pdqjagkzb03507k24-devloop-queries-reconcile_builds-window.sql /nix/store/m6c0fjr1yikpsi3w8hv1i7fzn8pjcr1p-devloop-queries-reconcile_current_finish-window.sql /nix/store/qwsiaz4a8iaw5zy9m8l99vynralxg0qq-devloop-queries-reconcile_current_finish-window.sql /nix/store/qzrzgdrh9w85rp50jpjwzfqg8sfkbph5-postgresql-16.15-dev /nix/store/6vgl94hci29sw90yij9p2a9j8hfb6i1y-postgresql-16.15-doc /nix/store/h879jifb3hzkwspalhy43ck8c6pfpjhh-postgresql-test-hook building '/nix/store/s3gpahn8w8qk1c6bxkma71w2335n2mnq-devloop-queries.drv' devloop-queries> Running phase: patchPhase devloop-queries> Running phase: updateAutotoolsGnuConfigScriptsPhase devloop-queries> Running phase: checkPhase devloop-queries> initializing postgresql devloop-queries> The files belonging to this database system will be owned by user "nixbld". devloop-queries> This user must also own the server process. devloop-queries> devloop-queries> The database cluster will be initialized with locale "C". devloop-queries> The default text search configuration will be set to "english". devloop-queries> devloop-queries> Data page checksums are disabled. devloop-queries> devloop-queries> creating directory /build/postgresql ... ok devloop-queries> creating subdirectories ... ok devloop-queries> selecting dynamic shared memory implementation ... posix devloop-queries> selecting default max_connections ... 100 devloop-queries> selecting default shared_buffers ... 128MB devloop-queries> selecting default time zone ... UTC devloop-queries> creating configuration files ... ok devloop-queries> running bootstrap script ... ok devloop-queries> performing post-bootstrap initialization ... ok devloop-queries> syncing data to disk ... ok devloop-queries> devloop-queries> initdb: warning: enabling "trust" authentication for local connections devloop-queries> initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. devloop-queries> devloop-queries> Success. You can now start the database server using: devloop-queries> devloop-queries> pg_ctl -D /build/postgresql -l logfile start devloop-queries> devloop-queries> starting postgresql devloop-queries> waiting for server to start....2026-10-27 23:01:07.357 UTC [28] LOG: starting PostgreSQL 16.15 on x86_64-pc-linux-gnu, compiled by clang version 21.1.8, 64-bit devloop-queries> 2026-10-27 23:01:07.358 UTC [28] LOG: listening on Unix socket "/build/run/postgresql/.s.PGSQL.5432" devloop-queries> 2026-10-27 23:01:07.366 UTC [31] LOG: database system was shut down at 2026-10-27 23:01:06 UTC devloop-queries> 2026-10-27 23:01:07.370 UTC [28] LOG: database system is ready to accept connections devloop-queries> done devloop-queries> server started devloop-queries> setting up postgresql devloop-queries> CREATE ROLE devloop-queries> CREATE DATABASE devloop-queries> ok: the patch's production code returns abandonMarker as an abandoned attribute's error devloop-queries> psql:/nix/store/xlv03xvmrbn2xabh4msznpa4b2dq5dvh-source/nixbot/nixbot/migrations/0033_effect_runs_catchup.sql:11: NOTICE: column "owner" of relation "effect_runs" already exists, skipping devloop-queries> psql:/nix/store/xlv03xvmrbn2xabh4msznpa4b2dq5dvh-source/nixbot/nixbot/migrations/0033_effect_runs_catchup.sql:12: NOTICE: column "lock" of relation "effect_runs" already exists, skipping devloop-queries> psql:/nix/store/xlv03xvmrbn2xabh4msznpa4b2dq5dvh-source/nixbot/nixbot/migrations/0033_effect_runs_catchup.sql:20: NOTICE: relation "effect_eval_errors" already exists, skipping devloop-queries> ok: abandoned is true only for the ignored_failure row whose error is exactly the marker devloop-queries> ok: no ci_attribute cell holds any error text the fixtures stored devloop-queries> ok: outputs_out is empty for a null outputs devloop-queries> ok: with a cursor 10 min old, the rows tied with the cursor and the rows 4 min old are returned devloop-queries> ok: with a cursor 1 min old, the rows 4 min old are returned and the rows 7 min old are not devloop-queries> ok: reconcile: attributes returns nixbot's (build_id, attr, finished_at) in the window, the start included, as devloop-reconcile devloop-queries> ok: reconcile: builds returns nixbot's (id, finished_at) in the window, the start included and the end excluded, as devloop-reconcile devloop-queries> ok: reconcile: batchBuilds counts the one gitea-mq/batch/ build finished in the window as devloop-reconcile devloop-queries> ok: reconcile: currentFinish returns exactly the stored keys nixbot does not explain, as devloop-reconcile devloop-queries> mutant currentFinishIgnoresDuplicates rejected: FAIL: reconcile: currentFinish returns exactly the stored keys nixbot does not explain, as devloop-reconcile devloop-queries> mutant errorUnderAlias rejected: FAIL: no ci_attribute cell holds any error text the fixtures stored devloop-queries> 2026-10-27 23:01:11.271 UTC [615] ERROR: permission denied for table build_attributes devloop-queries> 2026-10-27 23:01:11.271 UTC [615] STATEMENT: EXECUTE ci_attribute('2026-10-27T22:51:11.000000Z'); devloop-queries> mutant grantWithoutError rejected: psql:/nix/store/l93cp743a3swcrmpblzkchp4097wcyy0-devloop-queries-ci_attribute-old.sql:23: ERROR: permission denied for table build_attributes devloop-queries> 2026-10-27 23:01:12.069 UTC [723] ERROR: permission denied for table build_attributes devloop-queries> 2026-10-27 23:01:12.069 UTC [723] STATEMENT: EXECUTE reconcile_attributes('2026-10-20T00:00:00.000000Z', '2026-10-21T00:00:00.000000Z'); devloop-queries> mutant reconcileGrantWithoutFinishedAt rejected: psql:/nix/store/a4q9frhff0z4kw12s0mnqhr0c90913p4-devloop-queries-reconcile_attributes-window.sql:6: ERROR: permission denied for table build_attributes devloop-queries> 2026-10-27 23:01:12.845 UTC [818] ERROR: column a.cached does not exist at character 242 devloop-queries> 2026-10-27 23:01:12.845 UTC [818] STATEMENT: PREPARE ci_attribute(text) AS devloop-queries> SELECT '' AS "body", devloop-queries> coalesce((b.id)::text, '') AS "build_id", devloop-queries> coalesce((a.attr)::text, '') AS "attr", devloop-queries> coalesce((a.system)::text, '') AS "system", devloop-queries> coalesce((a.status)::text, '') AS "status", devloop-queries> coalesce((a.cached)::text, '') AS "cached", devloop-queries> coalesce(((a.status = 'ignored_failure' AND a.error IS NOT DISTINCT FROM 'not finished when the required attributes had settled'))::text, '') AS "abandoned", devloop-queries> coalesce((a.drv_path)::text, '') AS "drv_path", devloop-queries> coalesce((a.outputs ->> 'out')::text, '') AS "outputs_out", devloop-queries> coalesce(to_char(a.started_at AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"'), '') AS "started_at", devloop-queries> coalesce(to_char(a.finished_at AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"'), '') AS "finished_at", devloop-queries> coalesce((a.eval_wall_ms)::text, '') AS "eval_wall_ms", devloop-queries> coalesce((a.eval_alloc_bytes)::text, '') AS "eval_alloc_bytes", devloop-queries> coalesce((b.commit_sha)::text, '') AS "commit_sha", devloop-queries> coalesce((b.branch)::text, '') AS "branch", devloop-queries> coalesce((b.pr_number)::text, '') AS "pr_number", devloop-queries> coalesce((p.owner || '/' || p.name)::text, '') AS "project" devloop-queries> FROM build_attributes a JOIN builds b ON b.id = a.build_id JOIN projects p ON p.id = b.project_id devloop-queries> WHERE a.finished_at >= least($1::timestamptz, now() - interval '5 minutes') devloop-queries> ORDER BY a.finished_at devloop-queries> LIMIT 10000; devloop-queries> mutant renameCached rejected: psql:/nix/store/l93cp743a3swcrmpblzkchp4097wcyy0-devloop-queries-ci_attribute-old.sql:22: ERROR: column a.cached does not exist devloop-queries> mutant selectError rejected: FAIL: no ci_attribute cell holds any error text the fixtures stored devloop-queries> stopping postgresql devloop-queries> waiting for server to shut down....2026-10-27 23:01:13.672 UTC [28] LOG: received fast shutdown request devloop-queries> 2026-10-27 23:01:13.673 UTC [28] LOG: aborting any active transactions devloop-queries> 2026-10-27 23:01:13.674 UTC [28] LOG: background worker "logical replication launcher" (PID 34) exited with exit code 1 devloop-queries> 2026-10-27 23:01:13.676 UTC [29] LOG: shutting down devloop-queries> 2026-10-27 23:01:13.676 UTC [29] LOG: checkpoint starting: shutdown immediate devloop-queries> .2026-10-27 23:01:15.477 UTC [29] LOG: checkpoint complete: wrote 7999 buffers (48.8%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.087 s, sync=1.692 s, total=1.801 s; sync files=3263, longest=0.004 s, average=0.001 s; distance=39042 kB, estimate=39042 kB; lsn=0/3B173E8, redo lsn=0/3B173E8 devloop-queries> 2026-10-27 23:01:15.498 UTC [28] LOG: database system is shut down devloop-queries> done devloop-queries> server stopped devloop-queries> Running phase: fixupPhase devloop-queries> shrinking RPATHs of ELF executables and libraries in /nix/store/n6yp2m1k7vkabghb7yx8qknzlk52c8yy-devloop-queries devloop-queries> checking for references to /build/ in /nix/store/n6yp2m1k7vkabghb7yx8qknzlk52c8yy-devloop-queries... devloop-queries> patching script interpreter paths in /nix/store/n6yp2m1k7vkabghb7yx8qknzlk52c8yy-devloop-queries upload niks3: ok