Autopilot lifecycle against fresh Postgres

Success
6d5a4ca4e268·feat/t3-envPR #6143s
Runner

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

Live output from all steps
Logs complete · 189 chunks
[Checkout] Cloning into '/var/lib/open-git/runner-work/466acc65-ee30-42e2-86dd-82a7ab04d537'...
[Checkout] Note: switching to '6d5a4ca4e268ce555155c2e191c1e0793ef14eb6'.

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 6d5a4ca Fix PR Autopilot findings
[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 ... 
[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%
[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 .../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%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 70%
(Reading database ... 75%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (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.)
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 ... 
[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%
(Reading database ... 75%
(Reading database ... 80%
[Boot Postgres, migrate, run the Autopilot lifecycle test] (Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
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.
[Boot Postgres, migrate, run the Autopilot lifecycle test] 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] Selecting previously unselected package libc-l10n.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../04-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 .../05-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 .../06-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 .../07-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 .../08-libpq-dev_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libpq-dev (15.18-0+deb12u1) over (15.16-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../09-libpq5_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking libpq5:amd64 (15.18-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 .../10-postgresql-client-15_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-client-15 (15.18-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Selecting previously unselected package postgresql-15.
[Boot Postgres, migrate, run the Autopilot lifecycle test] Preparing to unpack .../11-postgresql-15_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Unpacking postgresql-15 (15.18-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 .../12-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 .../13-postgresql-client_15+248+deb12u1_all.deb ...
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.18-0+deb12u1) ...
[Boot Postgres, migrate, run the Autopilot lifecycle test] Setting up postgresql-client-15 (15.18-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] Setting up libpq-dev (15.18-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 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.18-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.

[Boot Postgres, migrate, run the Autopilot lifecycle test] fixing permissions on existing directory /var/lib/postgresql/15/main ... ok
creating subdirectories ... 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
creating configuration files ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
running bootstrap script ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
performing post-bootstrap initialization ... [Boot Postgres, migrate, run the Autopilot lifecycle test] ok
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] 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 19 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: +1002
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 13, added 0
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 33, added 19
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 35, added 22
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 48, added 33
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 148, added 137
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 307, added 292
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 412, added 404
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 414, added 408
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 415, added 408
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 438, added 424
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 479, added 463
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 590, added 578
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 750, added 735
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 782, added 772
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 891, added 880
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 995, added 982
[Boot Postgres, migrate, run the Autopilot lifecycle test] Progress: resolved 1002, reused 0, downloaded 1002, added 1002, done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../sharp@0.34.5/node_modules/sharp install$ node install/check.js || npm run build
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../esbuild@0.18.20/node_modules/esbuild postinstall$ node install.js
.../esbuild@0.27.3/node_modules/esbuild postinstall$ node install.js
.../node_modules/msw postinstall$ node -e "import('./config/scripts/postinstall.js').catch(() => void 0)"
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../esbuild@0.25.12/node_modules/esbuild postinstall$ node install.js
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../esbuild@0.18.20/node_modules/esbuild postinstall: Done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../esbuild@0.27.3/node_modules/esbuild postinstall: Done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../node_modules/msw postinstall: Done
.../sharp@0.34.5/node_modules/sharp install: Done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../esbuild@0.25.12/node_modules/esbuild postinstall: Done
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../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!
[Boot Postgres, migrate, run the Autopilot lifecycle test] .../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 18.6s 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'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  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'
}
{
  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'
}
[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"',
  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'
}
{
  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'
}
[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'
}
[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: '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] {
  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] [2K[1G[⣻] applying migrations...[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] {
  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'
}
[Boot Postgres, migrate, run the Autopilot lifecycle test] {
  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'
}
[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'
}
[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
[Boot Postgres, migrate, run the Autopilot lifecycle test]   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
  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] 
Fixture created 13 autopilot job(s) total.

36 passed, 0 failed
Steps

2 passed
2 steps in this job.
02Checkoutcheckout1.4s
03Boot Postgres, migrate, run the Autopilot lifecycle testrun42s