Apply migrations to a fresh Postgres

Success
6ad87855a78c·main46s
Runner

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

Live output from all steps
Logs complete · 176 chunks
[Checkout] Cloning into '/var/lib/open-git/runner-work/981fae3c-b306-41b1-a66e-8c8d0c0af4e4'...
[Checkout] Note: switching to '6ad87855a78c228b68d8d26146fc625219681f2e'.

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

[Checkout] HEAD is now at 6ad8785 open-beta
[Boot Postgres, apply every migration, verify idempotency] debconf: delaying package configuration, since apt-utils is not installed
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 
[Boot Postgres, apply every migration, verify idempotency] (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, apply every migration, verify idempotency] (Reading database ... 70%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 75%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 80%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 85%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 90%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 95%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../libc6-dev_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libc6-dev:amd64 (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../libc-dev-bin_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libc-dev-bin (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../libc6_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libc6:amd64 (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libc6:amd64 (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] (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%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
Preparing to unpack .../libc-bin_2.36-9+deb12u14_amd64.deb ...
Unpacking libc-bin (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
Setting up libc-bin (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] 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%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(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, apply every migration, verify idempotency] Unpacking libjson-perl (4.10000-1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package postgresql-client-common.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../01-postgresql-client-common_248+deb12u1_all.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking postgresql-client-common (248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package ssl-cert.
Preparing to unpack .../02-ssl-cert_1.1.2_all.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking ssl-cert (1.1.2) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package postgresql-common.
Preparing to unpack .../03-postgresql-common_248+deb12u1_all.deb ...
[Boot Postgres, apply every migration, verify idempotency] Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
[Boot Postgres, apply every migration, verify idempotency] Unpacking postgresql-common (248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../04-ca-certificates_20250419~deb12u1_all.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking ca-certificates (20250419~deb12u1) over (20230311+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package libc-l10n.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../05-libc-l10n_2.36-9+deb12u14_all.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libc-l10n (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package locales.
Preparing to unpack .../06-locales_2.36-9+deb12u14_all.deb ...
Unpacking locales (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package libz3-4:amd64.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../07-libz3-4_4.8.12-3.1_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libz3-4:amd64 (4.8.12-3.1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package libllvm14:amd64.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../08-libllvm14_1%3a14.0.6-12_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libllvm14:amd64 (1:14.0.6-12) ...
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../09-libpq-dev_15.18-0+deb12u1_amd64.deb ...
Unpacking libpq-dev (15.18-0+deb12u1) over (15.16-0+deb12u1) ...
Preparing to unpack .../10-libpq5_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libpq5:amd64 (15.18-0+deb12u1) over (15.16-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package postgresql-client-15.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../11-postgresql-client-15_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking postgresql-client-15 (15.18-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package postgresql-15.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../12-postgresql-15_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking postgresql-15 (15.18-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package postgresql.
Preparing to unpack .../13-postgresql_15+248+deb12u1_all.deb ...
Unpacking postgresql (15+248+deb12u1) ...
Selecting previously unselected package postgresql-client.
Preparing to unpack .../14-postgresql-client_15+248+deb12u1_all.deb ...
Unpacking postgresql-client (15+248+deb12u1) ...
Setting up postgresql-client-common (248+deb12u1) ...
Setting up libc-l10n (2.36-9+deb12u14) ...
Setting up libpq5:amd64 (15.18-0+deb12u1) ...
Setting up postgresql-client-15 (15.18-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] 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, apply every migration, verify idempotency] Setting up libpq-dev (15.18-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up locales (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Generating locales (this might take a while)...
Generation complete.
[Boot Postgres, apply every migration, verify idempotency] Setting up ca-certificates (20250419~deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Updating certificates in /etc/ssl/certs...
[Boot Postgres, apply every migration, verify idempotency] rehash: warning: skipping ca-certificates.crt,it does not contain exactly one certificate or CRL
[Boot Postgres, apply every migration, verify idempotency] 21 added, 13 removed; done.
[Boot Postgres, apply every migration, verify idempotency] Setting up libz3-4:amd64 (4.8.12-3.1) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up ssl-cert (1.1.2) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libllvm14:amd64 (1:14.0.6-12) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libjson-perl (4.10000-1) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libc-dev-bin (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up postgresql-client (15+248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up postgresql-common (248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] 
Creating config file /etc/postgresql-common/createcluster.conf with new version
[Boot Postgres, apply every migration, verify idempotency] Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
[Boot Postgres, apply every migration, verify idempotency] invoke-rc.d: could not determine current runlevel
[Boot Postgres, apply every migration, verify idempotency] invoke-rc.d: policy-rc.d denied execution of start.
[Boot Postgres, apply every migration, verify idempotency] Setting up libc6-dev:amd64 (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up postgresql-15 (15.18-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Creating new PostgreSQL cluster 15/main ...
[Boot Postgres, apply every migration, verify idempotency] /usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15/main --auth-local peer --auth-host scram-sha-256 --no-instructions
[Boot Postgres, apply every migration, verify idempotency] 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, apply every migration, verify idempotency] ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... [Boot Postgres, apply every migration, verify idempotency] 100
selecting default shared_buffers ... [Boot Postgres, apply every migration, verify idempotency] 128MB
selecting default time zone ... [Boot Postgres, apply every migration, verify idempotency] Etc/UTC
creating configuration files ... [Boot Postgres, apply every migration, verify idempotency] ok
running bootstrap script ... [Boot Postgres, apply every migration, verify idempotency] ok
[Boot Postgres, apply every migration, verify idempotency] performing post-bootstrap initialization ... [Boot Postgres, apply every migration, verify idempotency] ok
syncing data to disk ... [Boot Postgres, apply every migration, verify idempotency] ok
[Boot Postgres, apply every migration, verify idempotency] 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, apply every migration, verify idempotency] invoke-rc.d: could not determine current runlevel
[Boot Postgres, apply every migration, verify idempotency] invoke-rc.d: policy-rc.d denied execution of start.
[Boot Postgres, apply every migration, verify idempotency] Setting up postgresql (15+248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Processing triggers for libc-bin (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Processing triggers for ca-certificates (20250419~deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Updating certificates in /etc/ssl/certs...
[Boot Postgres, apply every migration, verify idempotency] 0 added, 0 removed; done.
Running hooks in /etc/ca-certificates/update.d...
[Boot Postgres, apply every migration, verify idempotency] done.
[Boot Postgres, apply every migration, verify idempotency] Starting postgres 15
[Boot Postgres, apply every migration, verify idempotency] CREATE ROLE
[Boot Postgres, apply every migration, verify idempotency] CREATE DATABASE
[Boot Postgres, apply every migration, verify idempotency]                                                            version                                                           
-----------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 15.18 (Debian 15.18-0+deb12u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
(1 row)

[Boot Postgres, apply every migration, verify idempotency] Preparing pnpm@9.15.9 for immediate activation...
[Boot Postgres, apply every migration, verify idempotency] Scope: all 21 workspace projects
[Boot Postgres, apply every migration, verify idempotency] Lockfile is up to date, resolution step is skipped
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1, reused 0, downloaded 0, added 0
[Boot Postgres, apply every migration, verify idempotency] Packages: +1002
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 54, added 41
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 171, added 161
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 419, added 409
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 467, added 459
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 777, added 770
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 962, added 956
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1002, reused 0, downloaded 1002, added 1002, done
[Boot Postgres, apply every migration, verify idempotency] .../node_modules/msw postinstall$ node -e "import('./config/scripts/postinstall.js').catch(() => void 0)"
[Boot Postgres, apply every migration, verify idempotency] .../sharp@0.34.5/node_modules/sharp install$ node install/check.js || npm run build
[Boot Postgres, apply every migration, verify idempotency] .../esbuild@0.27.3/node_modules/esbuild postinstall$ node install.js
[Boot Postgres, apply every migration, verify idempotency] .../esbuild@0.18.20/node_modules/esbuild postinstall$ node install.js
[Boot Postgres, apply every migration, verify idempotency] .../esbuild@0.25.12/node_modules/esbuild postinstall$ node install.js
[Boot Postgres, apply every migration, verify idempotency] .../node_modules/msw postinstall: Done
[Boot Postgres, apply every migration, verify idempotency] .../esbuild@0.18.20/node_modules/esbuild postinstall: Done
.../esbuild@0.27.3/node_modules/esbuild postinstall: Done
[Boot Postgres, apply every migration, verify idempotency] .../sharp@0.34.5/node_modules/sharp install: Done
[Boot Postgres, apply every migration, verify idempotency] .../esbuild@0.25.12/node_modules/esbuild postinstall: Done
[Boot Postgres, apply every migration, verify idempotency] .../node_modules/core-js-pure postinstall$ node -e "try{require('./postinstall')}catch(e){}"
[Boot Postgres, apply every migration, verify idempotency] .../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, apply every migration, verify idempotency] .../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, apply every migration, verify idempotency] 
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, apply every migration, verify idempotency] Done in 8.7s using pnpm v9.15.9
[Boot Postgres, apply every migration, verify idempotency] --- Applying migrations to fresh DB ---
[Boot Postgres, apply every migration, verify idempotency] 
> web@0.0.1 db:migrate /workspace/apps/web
> drizzle-kit migrate

[Boot Postgres, apply every migration, verify idempotency] No config path provided, using default 'drizzle.config.ts'
[Boot Postgres, apply every migration, verify idempotency] Reading config file '/workspace/apps/web/drizzle.config.ts'
[Boot Postgres, apply every migration, verify idempotency] Using 'postgres' driver for database querying
[Boot Postgres, apply every migration, verify idempotency] [⣷] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] [2K[1G[⣯] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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'
}
[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] [2K[1G[⣟] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] [2K[1G[⡿] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] [2K[1G[⢿] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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'
}
{
  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'
}
{
  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'
}
[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] [2K[1G[⣻] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] {
  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, apply every migration, verify idempotency] [2K[1G[✓] migrations applied successfully![Boot Postgres, apply every migration, verify idempotency] --- Re-applying migrations (idempotency check, expect no-op) ---
[Boot Postgres, apply every migration, verify idempotency] 
> web@0.0.1 db:migrate /workspace/apps/web
> drizzle-kit migrate

[Boot Postgres, apply every migration, verify idempotency] No config path provided, using default 'drizzle.config.ts'
[Boot Postgres, apply every migration, verify idempotency] Reading config file '/workspace/apps/web/drizzle.config.ts'
[Boot Postgres, apply every migration, verify idempotency] Using 'postgres' driver for database querying
[Boot Postgres, apply every migration, verify idempotency] [⣷] applying migrations...[Boot Postgres, apply every migration, verify idempotency] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P06',
  message: 'schema "drizzle" already exists, skipping',
  file: 'schemacmds.c',
  line: '131',
  routine: 'CreateSchemaCommand'
}
[Boot Postgres, apply every migration, verify idempotency] {
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P07',
  message: 'relation "__drizzle_migrations" already exists, skipping',
  file: 'parse_utilcmd.c',
  line: '207',
  routine: 'transformCreateStmt'
}
[Boot Postgres, apply every migration, verify idempotency] [2K[1G[✓] migrations applied successfully![Boot Postgres, apply every migration, verify idempotency] --- Post-apply drift check ---
[Boot Postgres, apply every migration, verify idempotency] 
> web@0.0.1 db:generate /workspace/apps/web
> drizzle-kit generate

[Boot Postgres, apply every migration, verify idempotency] No config path provided, using default 'drizzle.config.ts'
[Boot Postgres, apply every migration, verify idempotency] Reading config file '/workspace/apps/web/drizzle.config.ts'
[Boot Postgres, apply every migration, verify idempotency] 70 tables
agent_checkpoint_sessions 25 columns 2 indexes 1 fks
agent_checkpoints 19 columns 2 indexes 1 fks
agent_session_access_requests 6 columns 2 indexes 2 fks
agent_sessions 12 columns 2 indexes 3 fks
autopilot_jobs 27 columns 6 indexes 6 fks
autopilot_logs 6 columns 2 indexes 1 fks
branches 9 columns 2 indexes 1 fks
campfire_channels 6 columns 2 indexes 1 fks
campfire_messages 7 columns 2 indexes 3 fks
campfire_thread_mentions 9 columns 2 indexes 4 fks
check_runs 11 columns 2 indexes 2 fks
check_suites 8 columns 2 indexes 2 fks
ci_secrets 10 columns 2 indexes 3 fks
commits 13 columns 2 indexes 1 fks
git_access_tokens 11 columns 1 indexes 1 fks
github_actor_write_denials 11 columns 1 indexes 2 fks
github_entity_links 19 columns 3 indexes 1 fks
github_installations 12 columns 2 indexes 2 fks
github_ref_links 11 columns 1 indexes 1 fks
github_repository_links 17 columns 3 indexes 3 fks
github_sync_conflicts 13 columns 1 indexes 2 fks
github_sync_jobs 14 columns 3 indexes 1 fks
github_webhook_events 14 columns 2 indexes 0 fks
gitty_pets 17 columns 1 indexes 1 fks
indexing_jobs 12 columns 2 indexes 0 fks
issue_comments 7 columns 0 indexes 3 fks
issue_pull_request_links 5 columns 1 indexes 3 fks
issues 10 columns 1 indexes 2 fks
namespace_autopilot_settings 12 columns 1 indexes 2 fks
namespace_billing 4 columns 1 indexes 1 fks
namespace_wallets 5 columns 0 indexes 1 fks
namespaces 8 columns 3 indexes 1 fks
organization_memberships 11 columns 4 indexes 2 fks
organizations 8 columns 3 indexes 2 fks
pull_request_access 6 columns 2 indexes 3 fks
pull_request_changed_files 14 columns 2 indexes 1 fks
pull_request_comment_acknowledgements 4 columns 1 indexes 2 fks
pull_request_comments 15 columns 0 indexes 5 fks
pull_request_diff_hunks 8 columns 1 indexes 1 fks
pull_request_diff_lines 7 columns 1 indexes 1 fks
pull_request_diff_versions 16 columns 2 indexes 3 fks
pull_request_mergeability_states 14 columns 2 indexes 1 fks
pull_request_reviews 6 columns 0 indexes 2 fks
pull_requests 21 columns 1 indexes 4 fks
repo_docs_pages 11 columns 3 indexes 1 fks
repo_language_stats 8 columns 1 indexes 1 fks
repo_readmes 8 columns 1 indexes 1 fks
repositories 27 columns 3 indexes 3 fks
repository_access_grants 7 columns 2 indexes 3 fks
repository_donations 17 columns 5 indexes 2 fks
repository_invitations 10 columns 2 indexes 3 fks
runner_pools 11 columns 3 indexes 2 fks
runner_tokens 11 columns 2 indexes 2 fks
runners 10 columns 1 indexes 1 fks
tree_entries 13 columns 2 indexes 1 fks
user_avatars 4 columns 0 indexes 1 fks
user_profiles 13 columns 3 indexes 1 fks
waitlist_entries 6 columns 1 indexes 1 fks
wallet_ledger_entries 12 columns 3 indexes 1 fks
workflow_artifacts 11 columns 2 indexes 2 fks
workflow_job_logs 8 columns 1 indexes 2 fks
workflow_job_secret_references 6 columns 1 indexes 1 fks
workflow_job_steps 12 columns 1 indexes 1 fks
workflow_jobs 19 columns 3 indexes 4 fks
workflow_runs 14 columns 3 indexes 4 fks
workflows 11 columns 2 indexes 1 fks
auth_accounts 13 columns 1 indexes 1 fks
auth_sessions 8 columns 1 indexes 1 fks
auth_users 7 columns 0 indexes 0 fks
auth_verifications 6 columns 1 indexes 0 fks

No schema changes, nothing to migrate 😴
Steps

2 passed
2 steps in this job.
02Checkoutcheckout3.9s
03Boot Postgres, apply every migration, verify idempotencyrun42s