Apply migrations to a fresh Postgres

Failed
df1cae84a942·drop_discussionsPR #1746s
Runner
No runner assigned
Queued in pool default
Labelslinux
Containernode:22-bookworm
Pooldefault
Logs

Live output from all steps
Logs complete · 178 chunks
[Checkout] Cloning into '/var/lib/open-git/runner-work/4b9c3bf7-7f81-4b83-bb1e-567df389e605'...
[Checkout] Note: switching to 'df1cae84a94261d233b1d97f17e5db0a1ddf89ef'.

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 df1cae8 drop discussions
[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%
(Reading database ... 75%
(Reading database ... 80%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
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 ... 
[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%
(Reading database ... 70%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 90%
(Reading database ... 95%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
Preparing to unpack .../libc-bin_2.36-9+deb12u14_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libc-bin (2.36-9+deb12u14) over (2.36-9+deb12u13) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libc-bin (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package libjson-perl.
(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%
(Reading database ... 70%
(Reading database ... 75%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ...
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.
[Boot Postgres, apply every migration, verify idempotency] 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.
[Boot Postgres, apply every migration, verify idempotency] 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] Selecting previously unselected package libc-l10n.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../04-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.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../05-locales_2.36-9+deb12u14_all.deb ...
[Boot Postgres, apply every migration, verify idempotency] 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 .../06-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 .../07-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 .../08-libpq-dev_15.18-0+deb12u1_amd64.deb ...
[Boot Postgres, apply every migration, verify idempotency] Unpacking libpq-dev (15.18-0+deb12u1) over (15.16-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../09-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 .../10-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 .../11-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.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../12-postgresql_15+248+deb12u1_all.deb ...
Unpacking postgresql (15+248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Selecting previously unselected package postgresql-client.
[Boot Postgres, apply every migration, verify idempotency] Preparing to unpack .../13-postgresql-client_15+248+deb12u1_all.deb ...
Unpacking postgresql-client (15+248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up postgresql-client-common (248+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libc-l10n (2.36-9+deb12u14) ...
[Boot Postgres, apply every migration, verify idempotency] Setting up libpq5:amd64 (15.18-0+deb12u1) ...
[Boot Postgres, apply every migration, verify idempotency] 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)...
[Boot Postgres, apply every migration, verify idempotency] Generation complete.
[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
[Boot Postgres, apply every migration, verify idempotency] creating subdirectories ... 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
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] 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 16 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: +1275
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 15, added 0
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 93, added 78
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 236, added 226
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 273, added 260
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 317, added 304
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 334, added 321
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 337, added 322
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 349, added 334
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 399, added 387
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 486, added 474
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 498, added 482
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 531, added 518
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 532, added 518
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 547, added 531
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 633, added 621
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 851, added 841
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 878, added 862
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 1071, added 1056
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 1128, added 1112
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 1236, added 1231
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1275, reused 0, downloaded 1275, added 1275, done
[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.25.12/node_modules/esbuild postinstall$ node install.js
.../node_modules/msw postinstall$ node -e "import('./config/scripts/postinstall.js').catch(() => void 0)"
.../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: Done
.../node_modules/msw 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.18.20/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] .../esbuild@0.27.3/node_modules/esbuild postinstall: Done
[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 22.3s 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'
}
[2K[1G[⣯] applying migrations...[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] {
  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'
}
[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: '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'
}
[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_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] {
  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] [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'
}
[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] 39 tables
branches 8 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
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
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 17 columns 1 indexes 3 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 14 columns 2 indexes 2 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_profiles 7 columns 2 indexes 0 fks
waitlist_entries 10 columns 3 indexes 0 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

[Boot Postgres, apply every migration, verify idempotency] [✓] Your SQL migration file ➜ drizzle/0021_zippy_joystick.sql 🚀
[Boot Postgres, apply every migration, verify idempotency] diff --git a/apps/web/drizzle/meta/_journal.json b/apps/web/drizzle/meta/_journal.json
index 3cc9481..a81ca23 100644
--- a/apps/web/drizzle/meta/_journal.json
+++ b/apps/web/drizzle/meta/_journal.json
@@ -148,6 +148,13 @@
       "when": 1778980000000,
       "tag": "0020_campfire_thread_mentions",
       "breakpoints": true
+    },
+    {
+      "idx": 21,
+      "version": "7",
+      "when": 1779355902878,
+      "tag": "0021_zippy_joystick",
+      "breakpoints": true
     }
   ]
 }
\ No newline at end of file
[Boot Postgres, apply every migration, verify idempotency] 
ERROR: after applying migrations, drizzle-kit generate produced
       a new migration. That means apps/web/drizzle/*.sql and
       apps/web/db/schema.ts disagree -- a migration file was
       likely hand-edited.
Steps
2 steps in this job.
1 passed1 failed
02Checkoutcheckout1.5s
03Boot Postgres, apply every migration, verify idempotencyrun45s