Autopilot lifecycle against fresh Postgres

Success
26269010166a·test/landingPR #10558s
Runner

No runner assigned
Queued in pool default
Labelslinux
Containernode:22-bookworm
Pooldefault
Logs

Live output from all steps
Logs complete · 204 chunks
[Checkout] Cloning into '/var/lib/open-git/runner-work/5d89ecee-632c-4290-933c-6399172993ab'...
[Checkout] Note: switching to '26269010166ac652142d4e37715f6a7643397fa9'.

You are in 'detached HEAD' state. You can look around, make experimental
changes and commit them, and you can discard any commits you make in this
state without impacting any branches by switching back to a branch.

If you want to create a new branch to retain commits you create, you may
do so (now or later) by using -c with the switch command. Example:

  git switch -c <new-branch-name>

Or undo this operation with:

  git switch -

Turn off this advice by setting config variable advice.detachedHead to false

HEAD is now at 2626901 Fix observer entry type safety
[Boot Postgres, migrate, run the Autopilot lifecycle test] debconf: delaying package configuration, since apt-utils is not installed
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 85%
(Reading database ... 90%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 95%
(Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../libc6-dev_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libc6-dev:amd64 (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../libc-dev-bin_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libc-dev-bin (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../libc6_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libc6:amd64 (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libc6:amd64 (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 75%
(Reading database ... 80%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
Preparing to unpack .../libc-bin_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libc-bin (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libc-bin (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package libjson-perl.
(Reading database ... 
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 70%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 95%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libjson-perl (4.10000-1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql-client-common.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../01-postgresql-client-common_248+deb12u1_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-client-common (248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package ssl-cert.
Preparing to unpack .../02-ssl-cert_1.1.2_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking ssl-cert (1.1.2) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql-common.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../03-postgresql-common_248+deb12u1_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-common (248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../04-ca-certificates_20250419~deb12u1_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking ca-certificates (20250419~deb12u1) over (20230311+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package libc-l10n.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../05-libc-l10n_2.36-9+deb12u14_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libc-l10n (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package locales.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../06-locales_2.36-9+deb12u14_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking locales (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package libz3-4:amd64.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../07-libz3-4_4.8.12-3.1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libz3-4:amd64 (4.8.12-3.1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package libllvm14:amd64.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../08-libllvm14_1%3a14.0.6-12_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libllvm14:amd64 (1:14.0.6-12) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../09-libpq-dev_15.19-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libpq-dev (15.19-0+deb12u1) over (15.16-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../10-libpq5_15.19-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libpq5:amd64 (15.19-0+deb12u1) over (15.16-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql-client-15.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../11-postgresql-client-15_15.19-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-client-15 (15.19-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql-15.
Preparing to unpack .../12-postgresql-15_15.19-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-15 (15.19-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../13-postgresql_15+248+deb12u1_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql (15+248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql-client.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../14-postgresql-client_15+248+deb12u1_all.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-client (15+248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql-client-common (248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libc-l10n (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libpq5:amd64 (15.19-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql-client-15 (15.19-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] update-alternatives: using /usr/share/postgresql/15/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode[Boot Postgres, migrate, run the Autopilot lifecycle test] 
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libpq-dev (15.19-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up locales (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Generating locales (this might take a while)...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Generation complete.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up ca-certificates (20250419~deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Updating certificates in /etc/ssl/certs...
[Boot Postgres, migrate, run the Autopilot lifecycle test] rehash: warning: skipping ca-certificates.crt,it does not contain exactly one certificate or CRL
[Boot Postgres, migrate, run the Autopilot lifecycle test] 21 added, 13 removed; done.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libz3-4:amd64 (4.8.12-3.1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up ssl-cert (1.1.2) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libllvm14:amd64 (1:14.0.6-12) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libjson-perl (4.10000-1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libc-dev-bin (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql-client (15+248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql-common (248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] 
Creating config file /etc/postgresql-common/createcluster.conf with new version
[Boot Postgres, migrate, run the Autopilot lifecycle test] Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
[Boot Postgres, migrate, run the Autopilot lifecycle test] invoke-rc.d: could not determine current runlevel
[Boot Postgres, migrate, run the Autopilot lifecycle test] invoke-rc.d: policy-rc.d denied execution of start.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up libc6-dev:amd64 (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql-15 (15.19-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Creating new PostgreSQL cluster 15/main ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] /usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15/main --auth-local peer --auth-host scram-sha-256 --no-instructions
[Boot Postgres, migrate, run the Autopilot lifecycle test] The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/15/main ... ok
creating subdirectories ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... [Boot Postgres, migrate, run the Autopilot lifecycle test] 100
selecting default shared_buffers ... [Boot Postgres, migrate, run the Autopilot lifecycle test] 128MB
selecting default time zone ... [Boot Postgres, migrate, run the Autopilot lifecycle test] Etc/UTC[Boot Postgres, migrate, run the Autopilot lifecycle test] 
creating configuration files ... ok
running bootstrap script ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
[Boot Postgres, migrate, run the Autopilot lifecycle test] performing post-bootstrap initialization ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
[Boot Postgres, migrate, run the Autopilot lifecycle test] syncing data to disk ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
[Boot Postgres, migrate, run the Autopilot lifecycle test] update-alternatives: using /usr/share/postgresql/15/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
[Boot Postgres, migrate, run the Autopilot lifecycle test] invoke-rc.d: could not determine current runlevel
[Boot Postgres, migrate, run the Autopilot lifecycle test] invoke-rc.d: policy-rc.d denied execution of start.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql (15+248+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Processing triggers for libc-bin (2.36-9+deb12u14) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Processing triggers for ca-certificates (20250419~deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Updating certificates in /etc/ssl/certs...
[Boot Postgres, migrate, run the Autopilot lifecycle test] 0 added, 0 removed; done.
Running hooks in /etc/ca-certificates/update.d...
[Boot Postgres, migrate, run the Autopilot lifecycle test] done.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Starting postgres 15
[Boot Postgres, migrate, run the Autopilot lifecycle test] CREATE ROLE
[Boot Postgres, migrate, run the Autopilot lifecycle test] CREATE DATABASE
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing pnpm@9.15.9 for immediate activation...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Scope: all 21 workspace projects
[Boot Postgres, migrate, run the Autopilot lifecycle test] Lockfile is up to date, resolution step is skipped
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1, reused 0, downloaded 0, added 0
[Boot Postgres, migrate, run the Autopilot lifecycle test] Packages: +1004
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 21, added 10
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 55, added 43
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 57, added 44
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 206, added 192
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 378, added 368
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 418, added 408
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 435, added 421
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 493, added 481
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 621, added 610
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 783, added 773
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 830, added 813
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 904, added 895
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 968, added 956
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1004, reused 0, downloaded 1004, added 1004, done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../node_modules/msw postinstall$ node -e "import('./config/scripts/postinstall.js').catch(() => void 0)"
.../sharp@0.34.5/node_modules/sharp install$ node install/check.js || npm run build
.../esbuild@0.27.3/node_modules/esbuild postinstall$ node install.js
.../esbuild@0.18.20/node_modules/esbuild postinstall$ node install.js
.../esbuild@0.25.12/node_modules/esbuild postinstall$ node install.js
.../node_modules/msw postinstall: Done
.../esbuild@0.27.3/node_modules/esbuild postinstall: Done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../esbuild@0.25.12/node_modules/esbuild postinstall: Done
.../sharp@0.34.5/node_modules/sharp install: Done
.../esbuild@0.18.20/node_modules/esbuild postinstall: Done
.../node_modules/core-js-pure postinstall$ node -e "try{require('./postinstall')}catch(e){}"
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../node_modules/core-js-pure postinstall: Thank you for using core-js ( https://github.com/zloirock/core-js ) for polyfilling JavaScript standard library!
.../node_modules/core-js-pure postinstall: The project needs your help! Please consider supporting core-js:
.../node_modules/core-js-pure postinstall: > https://opencollective.com/core-js 
.../node_modules/core-js-pure postinstall: > https://patreon.com/zloirock 
.../node_modules/core-js-pure postinstall: > https://boosty.to/zloirock 
.../node_modules/core-js-pure postinstall: > bitcoin: bc1qlea7544qtsmj2rayg0lthvza9fau63ux0fstcz 
.../node_modules/core-js-pure postinstall: I highly recommend reading this: https://github.com/zloirock/core-js/blob/master/docs/2023-02-14-so-whats-next.md 
.../node_modules/core-js-pure postinstall: Done
[Boot Postgres, migrate, run the Autopilot lifecycle test] 
devDependencies:
+ @workspace/eslint-config 0.0.0 <- packages/eslint-config
+ @workspace/typescript-config 0.0.0 <- packages/typescript-config
+ prettier 3.8.1
+ prettier-plugin-tailwindcss 0.7.4
+ turbo 2.9.6
+ typescript 5.9.3
+ vitest 4.1.5

[Boot Postgres, migrate, run the Autopilot lifecycle test] Done in 16.2s using pnpm v9.15.9
[Boot Postgres, migrate, run the Autopilot lifecycle test] --- Applying migrations ---
[Boot Postgres, migrate, run the Autopilot lifecycle test] 
> web@0.0.1 db:migrate /workspace/apps/web
> drizzle-kit migrate

[Boot Postgres, migrate, run the Autopilot lifecycle test] No config path provided, using default 'drizzle.config.ts'
[Boot Postgres, migrate, run the Autopilot lifecycle test] Reading config file '/workspace/apps/web/drizzle.config.ts'
[Boot Postgres, migrate, run the Autopilot lifecycle test] Using 'postgres' driver for database querying
[Boot Postgres, migrate, run the Autopilot lifecycle test] [⣷] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⣯] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_comments_pull_request_review_id_pull_request_reviews_id_fk" will be truncated to "pull_request_comments_pull_request_review_id_pull_request_revie"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_comments_parent_comment_id_pull_request_comments_id_fk" will be truncated to "pull_request_comments_parent_comment_id_pull_request_comments_i"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_comment_acknowledgements_pull_request_comment_id_pull_request_comments_id_fk" will be truncated to "pull_request_comment_acknowledgements_pull_request_comment_id_p"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_comment_acknowledgements_author_profile_id_user_profiles_id_fk" will be truncated to "pull_request_comment_acknowledgements_author_profile_id_user_pr"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_comments_resolved_by_profile_id_user_profiles_id_fk" will be truncated to "pull_request_comments_resolved_by_profile_id_user_profiles_id_f"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "issue_pull_request_links_linked_by_profile_id_user_profiles_id_fk" will be truncated to "issue_pull_request_links_linked_by_profile_id_user_profiles_id_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_versions_target_repository_id_repositories_id_fk" will be truncated to "pull_request_diff_versions_target_repository_id_repositories_id"',
  where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_versions_target_repository_id_repositories_id_fk" will be truncated to "pull_request_diff_versions_target_repository_id_repositories_id"',
  position: '15',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_versions_target_repository_id_repositories_id_fk" will be truncated to "pull_request_diff_versions_target_repository_id_repositories_id"',
  where: 'SQL statement "ALTER TABLE "pull_request_diff_versions" ADD CONSTRAINT "pull_request_diff_versions_target_repository_id_repositories_id_fk" FOREIGN KEY ("target_repository_id") REFERENCES "public"."repositories"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_versions_source_repository_id_repositories_id_fk" will be truncated to "pull_request_diff_versions_source_repository_id_repositories_id"',
  where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_versions_source_repository_id_repositories_id_fk" will be truncated to "pull_request_diff_versions_source_repository_id_repositories_id"',
  position: '15',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_versions_source_repository_id_repositories_id_fk" will be truncated to "pull_request_diff_versions_source_repository_id_repositories_id"',
  where: 'SQL statement "ALTER TABLE "pull_request_diff_versions" ADD CONSTRAINT "pull_request_diff_versions_source_repository_id_repositories_id_fk" FOREIGN KEY ("source_repository_id") REFERENCES "public"."repositories"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_changed_files_diff_version_id_pull_request_diff_versions_id_fk" will be truncated to "pull_request_changed_files_diff_version_id_pull_request_diff_ve"',
  where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_changed_files_diff_version_id_pull_request_diff_versions_id_fk" will be truncated to "pull_request_changed_files_diff_version_id_pull_request_diff_ve"',
  position: '15',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_changed_files_diff_version_id_pull_request_diff_versions_id_fk" will be truncated to "pull_request_changed_files_diff_version_id_pull_request_diff_ve"',
  where: 'SQL statement "ALTER TABLE "pull_request_changed_files" ADD CONSTRAINT "pull_request_changed_files_diff_version_id_pull_request_diff_versions_id_fk" FOREIGN KEY ("diff_version_id") REFERENCES "public"."pull_request_diff_versions"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_hunks_changed_file_id_pull_request_changed_files_id_fk" will be truncated to "pull_request_diff_hunks_changed_file_id_pull_request_changed_fi"',
  where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_hunks_changed_file_id_pull_request_changed_files_id_fk" will be truncated to "pull_request_diff_hunks_changed_file_id_pull_request_changed_fi"',
  position: '15',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_diff_hunks_changed_file_id_pull_request_changed_files_id_fk" will be truncated to "pull_request_diff_hunks_changed_file_id_pull_request_changed_fi"',
  where: 'SQL statement "ALTER TABLE "pull_request_diff_hunks" ADD CONSTRAINT "pull_request_diff_hunks_changed_file_id_pull_request_changed_files_id_fk" FOREIGN KEY ("changed_file_id") REFERENCES "public"."pull_request_changed_files"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⣟] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_mergeability_states_pull_request_id_pull_requests_id_fk" will be truncated to "pull_request_mergeability_states_pull_request_id_pull_requests_"',
  where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_mergeability_states_pull_request_id_pull_requests_id_fk" will be truncated to "pull_request_mergeability_states_pull_request_id_pull_requests_"',
  position: '15',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_request_mergeability_states_pull_request_id_pull_requests_id_fk" will be truncated to "pull_request_mergeability_states_pull_request_id_pull_requests_"',
  where: 'SQL statement "ALTER TABLE "pull_request_mergeability_states" ADD CONSTRAINT "pull_request_mergeability_states_pull_request_id_pull_requests_id_fk" FOREIGN KEY ("pull_request_id") REFERENCES "public"."pull_requests"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⡿] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "workflow_job_secret_references_workflow_job_id_workflow_jobs_id_fk" will be truncated to "workflow_job_secret_references_workflow_job_id_workflow_jobs_id"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⢿] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "campfire_thread_mentions_campfire_message_id_campfire_messages_id_fk" will be truncated to "campfire_thread_mentions_campfire_message_id_campfire_messages_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "campfire_thread_mentions_mentioned_by_profile_id_user_profiles_id_fk" will be truncated to "campfire_thread_mentions_mentioned_by_profile_id_user_profiles_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "repository_access_grants_granted_by_profile_id_user_profiles_id_fk" will be truncated to "repository_access_grants_granted_by_profile_id_user_profiles_id"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "repository_invitations_invited_by_profile_id_user_profiles_id_fk" will be truncated to "repository_invitations_invited_by_profile_id_user_profiles_id_f"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "repository_invitations_accepted_by_profile_id_user_profiles_id_fk" will be truncated to "repository_invitations_accepted_by_profile_id_user_profiles_id_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⣻] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "namespace_autopilot_settings_created_by_profile_id_user_profiles_id_fk" will be truncated to "namespace_autopilot_settings_created_by_profile_id_user_profile"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "agent_checkpoint_sessions_agent_checkpoint_id_agent_checkpoints_id_fk" will be truncated to "agent_checkpoint_sessions_agent_checkpoint_id_agent_checkpoints"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⣽] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "agent_session_access_requests_agent_session_id_agent_sessions_id_fk" will be truncated to "agent_session_access_requests_agent_session_id_agent_sessions_i"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "agent_session_access_requests_requester_profile_id_user_profiles_id_fk" will be truncated to "agent_session_access_requests_requester_profile_id_user_profile"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "repositories_agent_sessions_source_repository_id_repositories_id_fk" will be truncated to "repositories_agent_sessions_source_repository_id_repositories_i"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "repositories_agent_sessions_source_repository_id_repositories_id_fk" will be truncated to "repositories_agent_sessions_source_repository_id_repositories_i"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_entity_links_repository_link_id_github_repository_links_id_fk" will be truncated to "github_entity_links_repository_link_id_github_repository_links_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_installations_connected_by_profile_id_user_profiles_id_fk" will be truncated to "github_installations_connected_by_profile_id_user_profiles_id_f"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_ref_links_repository_link_id_github_repository_links_id_fk" will be truncated to "github_ref_links_repository_link_id_github_repository_links_id_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_repository_links_installation_id_github_installations_id_fk" will be truncated to "github_repository_links_installation_id_github_installations_id"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_repository_links_linked_by_profile_id_user_profiles_id_fk" will be truncated to "github_repository_links_linked_by_profile_id_user_profiles_id_f"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_sync_conflicts_repository_link_id_github_repository_links_id_fk" will be truncated to "github_sync_conflicts_repository_link_id_github_repository_link"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_sync_conflicts_resolved_by_profile_id_user_profiles_id_fk" will be truncated to "github_sync_conflicts_resolved_by_profile_id_user_profiles_id_f"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_sync_jobs_repository_link_id_github_repository_links_id_fk" will be truncated to "github_sync_jobs_repository_link_id_github_repository_links_id_"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[⣷] applying migrations...[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "github_actor_write_denials_repository_link_id_github_repository_links_id_fk" will be truncated to "github_actor_write_denials_repository_link_id_github_repository"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "pull_requests_ci_workflows_approved_by_profile_id_user_profiles_id_fk" will be truncated to "pull_requests_ci_workflows_approved_by_profile_id_user_profiles"',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] [2K[1G[✓] migrations applied successfully![Boot Postgres, migrate, run the Autopilot lifecycle test] --- Running Autopilot lifecycle scenarios ---
[Boot Postgres, migrate, run the Autopilot lifecycle test] 
> web@0.0.1 test:autopilot-lifecycle /workspace/apps/web
> tsx scripts/test-autopilot-lifecycle.ts

[Boot Postgres, migrate, run the Autopilot lifecycle test] 
Scenario 1: multiple failed checks on one commit -> one job
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    first failed check enqueues a job
  ok    second failed check on same commit dedupes to the same job
  ok    exactly one job exists
  ok    job records the failing commit

Scenario 2: trigger for a superseded commit -> no job
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    stale trigger returns no job
  ok    no job rows were created

Scenario 3: newer push cancels queued jobs for old commits
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    job queued for the old head
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    one job was canceled
  ok    job status is canceled
  ok    no comment was posted

Scenario 4: claimed job for superseded commit cancels itself
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    job canceled itself
  ok    no comment was posted

Scenario 5: summary comment defers until CI passes
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    no comment while checks are still pending
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    comment posted once CI is green
  ok    comment contains the summary
  ok    comment records that CI passed
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    no duplicate comment on repeat success
  ok    summaryPostedAt was claimed

Scenario 6: CI fails on Autopilot's commit -> no comment, retry with context
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    the never-verified success comment was not posted
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    a retry job was enqueued
  ok    retry job is queued
  ok    retry targets the failing Autopilot commit
  ok    retry can see the previous attempt

Scenario 7: attempt cap reached -> one give-up comment, job fails
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    give-up job is marked failed
  ok    exactly one give-up comment
  ok    comment explains the attempt cap
  ok    comment says it will wait for a human
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    re-trigger dedupes to the same job
  ok    still exactly one comment

Scenario 8: transient infrastructure failure -> rerun check, no agent
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    job completed without an agent run
  ok    summary records the triage decision
  ok    failed check was re-queued
  ok    no comment was posted

Scenario 9: monthly budget reached -> job fails before spending
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    job failed before starting a workspace
  ok    failure records the budget cap
  ok    no comment was posted
[Boot Postgres, migrate, run the Autopilot lifecycle test] 
Scenario 10: job is held while sibling checks on its commit still run
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    claim skips the job while a sibling check is running
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    claim picks the job up once the suite settles
  ok    holding the job posts no comment

Scenario 11: job that already pushed recovers instead of canceling
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    job is recorded as a success, not canceled
  ok    the pushed commit is kept
  ok    the summary comment was posted
  ok    comment carries the recovered summary

Scenario 12: exhausted attempts -> one comment, no silence
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    job is failed
  ok    exactly one give-up comment
  ok    comment names the failure
  ok    comment says nothing was pushed
[Boot Postgres, migrate, run the Autopilot lifecycle test]   ok    a failure with attempts left requeues
  ok    a failure with attempts left posts no comment
[Boot Postgres, migrate, run the Autopilot lifecycle test] 
Fixture created 17 autopilot job(s) total.

49 passed, 0 failed
Steps

2 passed
2 steps in this job.
02Checkoutcheckout2.2s
03Boot Postgres, migrate, run the Autopilot lifecycle testrun56s