these 19 derivations will be built: /nix/store/20vv9y46139xn888gxawp7jdgfgzz7w5-devloop-queries-clock.sql.drv /nix/store/5bqpa2qmnpdyn9k80sc1dhra6shca31d-devloop-queries-ci_attribute-old.sql.drv /nix/store/5nj61jx3psm47hvhajzzlmwn973pdyl9-devloop-queries-ci_attribute-recent.sql.drv /nix/store/671rl706fz9csz137z19144i9swhn38a-devloop-queries-ci_attribute-old.sql.drv /nix/store/90crahigqxdczw28kkd98nxmfp0zf19h-devloop-queries-reconcile_current_finish-window.sql.drv /nix/store/9hndibhjvx0jxzfx8x15mxik2iwc5693-devloop-queries-ci_attribute-old.sql.drv /nix/store/a9amixxcs762q2gs7fhjki9qd3hrspw0-devloop-queries-reconcile_attributes-window.sql.drv /nix/store/arc1wj06qi7m497pbid4pw6j17gngn3i-devloop-queries-reconcile_current_finish-window.sql.drv /nix/store/b9hlcg0zhz1z49g8svb9l9da6b3spmdf-devloop-queries-ci_build-old.sql.drv /nix/store/cscnllwnw79m7vc4zv0qwqs7sc7h79vq-devloop-queries-grants.sql.drv /nix/store/gbrg7ca0dpaw2v9i56x8jyfyfzhl5ak7-devloop-queries-reconcile_batch_builds-window.sql.drv /nix/store/ny09pzz1qs8z9y7vws58rgjnnp6h9hb4-devloop-queries-ci_build-recent.sql.drv /nix/store/qibz02li8sjkki2xsqh3cw3pnfshhkvk-devloop-queries-fixture_errors-all.sql.drv /nix/store/qs5yckc62irdbmk3kq4dl947fnpn84l4-devloop-queries-reconcile_builds-window.sql.drv /nix/store/rqh0x28rxqfw69hqk2j1zi246dlwihl8-devloop-queries-grants.sql.drv /nix/store/v1sf2ikpy91af22cyhlq4vwgbga6a11h-devloop-queries-ci_attribute-recent.sql.drv /nix/store/w7aps3bi45q7v3igbn5xkj5lrwmw5q9j-devloop-queries-ci_attribute-recent.sql.drv /nix/store/x0jdw9s30vwlq0s5jmwfzf2qvwdg4k4a-devloop-queries-grants.sql.drv /nix/store/faz1qmslp1394bbgm6w8nn190akdsvg5-devloop-queries.drv these 77 paths will be fetched (5.1 MiB download, 2.0 GiB unpacked): /nix/store/fgwmn1g1n1v3kw4nj7g6bl3n2g1wrpgr-audit-4.2.1-lib /nix/store/nilcmqdvnpv02v3n63rwnr7pl1zhbgm7-bison-3.8.2 /nix/store/ai2km55ba8bxrn64xx7p9lgvrrzdzv43-bzip2-1.0.8-bin /nix/store/wra7pnc8v3vk7xl597kq79bbmvncxz8j-clang-21.1.8 /nix/store/6vckl9z0k08nadkalhw777i9wwjki4cj-clang-21.1.8-lib /nix/store/c4r4l3xm1yzilmi5apr8qf9wn1q1gpi7-clang-wrapper-21.1.8 /nix/store/0n8ncy1wlkkhnix0m91ly7x6lpwi2bm3-compiler-rt-libc-21.1.8 /nix/store/49r7ql9sypb1f1x3i41dsw9kcl2nax88-compiler-rt-libc-21.1.8-dev /nix/store/wz8h60wc57f240dr1f6z1d9qj9sg6548-db-4.8.30 /nix/store/9mpja553cbkr2rc37kzdg8zbbg2dyyvl-diffutils-3.12 /nix/store/77d0rlxs1c4sx71ss06vnmfpjcd5mm22-ed-1.22.6 /nix/store/vl4bvv35nbwmmsd7xlkdw0zixpl7yq29-expand-response-params /nix/store/2qpmak7162vhqxjwfik4aqs9lff6sn7w-file-5.48 /nix/store/50lngyqcak682x0msmda3rfdjqhdh08f-find-xml-catalogs-hook /nix/store/99v13ig4382mngi6ggf0csqi7rfa04j5-findutils-4.11.0 /nix/store/m302wmq507k12h99k3x3l9ylnnr92y7h-flex-2.6.4 /nix/store/h96s16mjssibkvk62pvmfm3lwfc3wnwp-gawk-5.4.1 /nix/store/xpaz3fi6ibqxb9sla4gjlp0c82v566y8-gcc-16.2.0 /nix/store/j64r0mf0yy7pvcbavlqidfnpsdnrldj2-glibc-2.44-57-bin /nix/store/3zlgjcfm8j3nscrldjv8izxciybg0nh3-glibc-2.44-57-dev /nix/store/v730lk2kw7kwbvlvq60zjbznd462mgrq-gmp-6.3.0 /nix/store/b01kc8kdswrnfzlqpq0y3q9akijvn620-gnu-config-2024-01-01 /nix/store/vqjfzxpgkl3yaagpcs2ghwjp6jsc9h86-gnum4-1.4.21 /nix/store/8xz4d9wp4jy49mhl306wyg55096wis3p-gnumake-4.4.1 /nix/store/n318yf1q5vysgh2qn6fd1q8yjy9vmwvh-gnutar-1.35 /nix/store/i8jf1bw06qbvb9w7apkz1zy796fnyizw-icu4c-78.3-dev /nix/store/yi5d8g9kma5bhskfjllrjypd5d2xhvl1-isl-0.20 /nix/store/xp4zisjhcys054h2fn1pqqhkv6j319fx-krb5-1.22.2 /nix/store/36jqif7m8jgnk14zaxzs6fl9lknjch8w-krb5-1.22.2-dev /nix/store/xqhm88f6dgkah58ksrsyclswal2c2mzk-libcap-ng-0.9.6 /nix/store/ka6nj2ppyjyn7s1xs9ibd1jpzdklx12y-libedit-20260508-3.1 /nix/store/2l15gqrda27bvdh82bxrzipcsl68dnwk-libmpc-1.4.1 /nix/store/bb6la8k5x4qj2bmakzr0iv3h49ykvrmj-libpfm-4.14.1 /nix/store/d6ar9rr2bbwdrjdj2y7pfbppf8q1wydn-libxml2-2.15.4-bin /nix/store/6gsdl0abbpjsxcrf2p83jkmkgwa5x6jd-libxml2-2.15.4-dev /nix/store/m0f5xgws8lpkja6kz7lvzwl7bb4zm6w5-libxslt-1.1.45 /nix/store/2ri4m79chw5v4178rfmjlj6h9wky1gbq-libxslt-1.1.45-bin /nix/store/d2pxlphy1s0qcjafl9r23rwr73g8zpyj-linux-headers-7.2 /nix/store/18ykcs87zl2zxgdvjnl3zdzqcp7r2m44-linux-pam-1.7.2 /nix/store/3naz0qnnfax2pdvwlgmjd3j57axrass4-lld-21.1.8 /nix/store/19bnwrkj363vlbi4l02i6bs33xyvimql-llvm-21.1.8 /nix/store/yg3r0wzp22jg3gyhwccnivs6iphkn51y-llvm-21.1.8-dev /nix/store/mr6cbi3rdy6w5y4cd6875gf4y0pqn0jf-llvm-21.1.8-lib /nix/store/c8ddrgj9i2243hp59hhg52dgxyfivnwa-llvm-binutils-21.1.8 /nix/store/0xmk54jzfcdxijdn36dl130kk33l09hb-llvm-binutils-wrapper-21.1.8 /nix/store/qldkqdihi29js0gkprz4bwvgapw5cxa8-lz4-1.10.0 /nix/store/l3h34sipmkdqipjwn5x87izrr5v9bgq0-lz4-1.10.0-dev /nix/store/7xkwycvjhvfyq2sjhq8yqf75y0afikaj-lz4-1.10.0-lib /nix/store/17215c0jn632z03h33fbwql4pdjb8bfi-mpfr-4.2.2 /nix/store/8awcq8rqlfmrk2qp202fbv09zpvr6bh4-ncurses-6.6-dev /nix/store/j7jpq1bligg8qvkdh7mki29x9pg2zvwz-ncurses-6.6-man /nix/store/wps4g7kaj73d2zs53a5cfimw1bnb3c99-openssl-3.5.9-dev /nix/store/d5jz315vxbphknfawsrjs192ci9bc6df-patch-2.8 /nix/store/dl38pix4jvabi5smb9wywhp6pimmpva6-patchelf-0.19.2 /nix/store/mfmibn2mvxahm3n416xzvwbnr0fk96fs-postgresql-16.15 /nix/store/qzrzgdrh9w85rp50jpjwzfqg8sfkbph5-postgresql-16.15-dev /nix/store/6vgl94hci29sw90yij9p2a9j8hfb6i1y-postgresql-16.15-doc /nix/store/2qva48s554gv416g06qx8iwbvx8fqy43-postgresql-16.15-lib /nix/store/xpfpsj7anaf9sq02ij39nkz0qw0vglh1-postgresql-16.15-man /nix/store/h879jifb3hzkwspalhy43ck8c6pfpjhh-postgresql-test-hook /nix/store/n52w3923daw804g5x2p9xahibr9da3cq-readline-8.3p3-dev /nix/store/c3k15jk20fccs90qgffdwzhxy15b5fdj-stdenv-linux-no-cc /nix/store/cgzr5afjdbx30j7g44z2h92i8h3828k2-systemd-minimal-libs-262 /nix/store/ng72w7jyv63g1jpifggb62ydq2krpbrm-systemd-minimal-libs-262-dev /nix/store/vj95j5874ahl4ba6ydkmwhgj9wpa26x6-tcl-8.6.16 /nix/store/yj2m2q5r6ncrb0hnm5w2xagvd7fvrhsj-update-autotools-gnu-config-scripts-hook /nix/store/j20m4sdmz5ryk8bnh151i6gw2ncq42bb-util-linux-minimal-2.42.4 /nix/store/3yr53grpp9cfny1ybqsbwd9qgsl9yvlc-util-linux-minimal-2.42.4-bin /nix/store/1x8434x2fhwdlkxh1anmmhdsfg2mghxf-util-linux-minimal-2.42.4-dev /nix/store/9b21b18iq20d67isg1bwhik42rifzpvs-util-linux-minimal-2.42.4-login /nix/store/qqwfnfl9mxbq498b3nwg68id0f8izrja-util-linux-minimal-2.42.4-mount /nix/store/zrr9acf2m60fkzdhrk434wf69sfgavl6-util-linux-minimal-2.42.4-swap /nix/store/nflpm51il93hxh2rba6dvz59kaff0i7v-xz-5.8.4-bin /nix/store/a76rmqrp6l3w6h9pppfwzb3s6dzi0y4g-zlib-1.3.2-dev /nix/store/hka7hr5qp0n92dmfv6gdigcabx9dai9r-zlib-1.3.2-static /nix/store/yqgkjczmmxsp6l26nwriry7h3kq981vi-zstd-1.5.7-bin /nix/store/l9f17m3j280r2gmb7gksl4r1dycxylin-zstd-1.5.7-dev building '/nix/store/5bqpa2qmnpdyn9k80sc1dhra6shca31d-devloop-queries-ci_attribute-old.sql.drv' building '/nix/store/671rl706fz9csz137z19144i9swhn38a-devloop-queries-ci_attribute-old.sql.drv' building '/nix/store/9hndibhjvx0jxzfx8x15mxik2iwc5693-devloop-queries-ci_attribute-old.sql.drv' building '/nix/store/5nj61jx3psm47hvhajzzlmwn973pdyl9-devloop-queries-ci_attribute-recent.sql.drv' building '/nix/store/v1sf2ikpy91af22cyhlq4vwgbga6a11h-devloop-queries-ci_attribute-recent.sql.drv' building '/nix/store/w7aps3bi45q7v3igbn5xkj5lrwmw5q9j-devloop-queries-ci_attribute-recent.sql.drv' building '/nix/store/b9hlcg0zhz1z49g8svb9l9da6b3spmdf-devloop-queries-ci_build-old.sql.drv' building '/nix/store/ny09pzz1qs8z9y7vws58rgjnnp6h9hb4-devloop-queries-ci_build-recent.sql.drv' building '/nix/store/20vv9y46139xn888gxawp7jdgfgzz7w5-devloop-queries-clock.sql.drv' building '/nix/store/qibz02li8sjkki2xsqh3cw3pnfshhkvk-devloop-queries-fixture_errors-all.sql.drv' building '/nix/store/cscnllwnw79m7vc4zv0qwqs7sc7h79vq-devloop-queries-grants.sql.drv' building '/nix/store/rqh0x28rxqfw69hqk2j1zi246dlwihl8-devloop-queries-grants.sql.drv' building '/nix/store/x0jdw9s30vwlq0s5jmwfzf2qvwdg4k4a-devloop-queries-grants.sql.drv' building '/nix/store/a9amixxcs762q2gs7fhjki9qd3hrspw0-devloop-queries-reconcile_attributes-window.sql.drv' building '/nix/store/gbrg7ca0dpaw2v9i56x8jyfyfzhl5ak7-devloop-queries-reconcile_batch_builds-window.sql.drv' building '/nix/store/qs5yckc62irdbmk3kq4dl947fnpn84l4-devloop-queries-reconcile_builds-window.sql.drv' devloop-queries-ci_attribute-old.sql> structuredAttrs is enabled devloop-queries-ci_attribute-old.sql> structuredAttrs is enabled devloop-queries-ci_attribute-old.sql> structuredAttrs is enabled devloop-queries-ci_attribute-recent.sql> structuredAttrs is enabled devloop-queries-ci_attribute-recent.sql> structuredAttrs is enabled devloop-queries-ci_attribute-recent.sql> structuredAttrs is enabled devloop-queries-ci_build-old.sql> structuredAttrs is enabled devloop-queries-ci_build-recent.sql> structuredAttrs is enabled devloop-queries-clock.sql> structuredAttrs is enabled devloop-queries-fixture_errors-all.sql> structuredAttrs is enabled devloop-queries-grants.sql> structuredAttrs is enabled devloop-queries-grants.sql> structuredAttrs is enabled devloop-queries-grants.sql> structuredAttrs is enabled devloop-queries-reconcile_attributes-window.sql> structuredAttrs is enabled devloop-queries-reconcile_batch_builds-window.sql> structuredAttrs is enabled devloop-queries-reconcile_builds-window.sql> structuredAttrs is enabled building '/nix/store/90crahigqxdczw28kkd98nxmfp0zf19h-devloop-queries-reconcile_current_finish-window.sql.drv' building '/nix/store/arc1wj06qi7m497pbid4pw6j17gngn3i-devloop-queries-reconcile_current_finish-window.sql.drv' devloop-queries-reconcile_current_finish-window.sql> structuredAttrs is enabled devloop-queries-reconcile_current_finish-window.sql> structuredAttrs is enabled building '/nix/store/faz1qmslp1394bbgm6w8nn190akdsvg5-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-23 22:56:02.712 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-23 22:56:02.714 UTC [28] LOG: listening on Unix socket "/build/run/postgresql/.s.PGSQL.5432" devloop-queries> 2026-10-23 22:56:02.718 UTC [31] LOG: database system was shut down at 2026-10-23 22:56:01 UTC devloop-queries> 2026-10-23 22:56:02.721 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/x9d1q6yxj0rvanz80rsji5fkm3ynhwgc-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/x9d1q6yxj0rvanz80rsji5fkm3ynhwgc-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/x9d1q6yxj0rvanz80rsji5fkm3ynhwgc-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-23 22:56:07.626 UTC [607] ERROR: permission denied for table build_attributes devloop-queries> 2026-10-23 22:56:07.626 UTC [607] STATEMENT: EXECUTE ci_attribute('2026-10-23T22:46:07.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-23 22:56:09.030 UTC [713] ERROR: permission denied for table build_attributes devloop-queries> 2026-10-23 22:56:09.030 UTC [713] 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-23 22:56:10.207 UTC [806] ERROR: column a.cached does not exist at character 242 devloop-queries> 2026-10-23 22:56:10.207 UTC [806] 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-23 22:56:11.039 UTC [28] LOG: received fast shutdown request devloop-queries> 2026-10-23 22:56:11.040 UTC [28] LOG: aborting any active transactions devloop-queries> 2026-10-23 22:56:11.042 UTC [28] LOG: background worker "logical replication launcher" (PID 34) exited with exit code 1 devloop-queries> 2026-10-23 22:56:11.043 UTC [29] LOG: shutting down devloop-queries> 2026-10-23 22:56:11.044 UTC [29] LOG: checkpoint starting: shutdown immediate devloop-queries> ..2026-10-23 22:56:13.517 UTC [29] LOG: checkpoint complete: wrote 7978 buffers (48.7%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.082 s, sync=2.320 s, total=2.475 s; sync files=3228, longest=0.011 s, average=0.001 s; distance=38834 kB, estimate=38834 kB; lsn=0/3AE3040, redo lsn=0/3AE3040 devloop-queries> 2026-10-23 22:56:13.534 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/3dhkzdlj52qmvcy34gwclj1lf6ji9j75-devloop-queries devloop-queries> checking for references to /build/ in /nix/store/3dhkzdlj52qmvcy34gwclj1lf6ji9j75-devloop-queries... devloop-queries> patching script interpreter paths in /nix/store/3dhkzdlj52qmvcy34gwclj1lf6ji9j75-devloop-queries upload niks3: ok