Apply migrations to a fresh Postgres

Success
c9ebec10f7ed·disable-ciPR #2446s
Runner
No runner assigned
Queued in pool default
Labelslinux
Containernode:22-bookworm
Pooldefault

Logs

Live output from all steps
Logs complete · 179 chunks
[Checkout] Cloning into '/var/lib/open-git/runner-work/68ceef05-bf98-44b4-b54d-89a3af88d207'...
[Checkout] Note: switching to 'c9ebec10f7edabffe433388daefb5bd5fb45bee0'.

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 c9ebec1 Merge origin/main into disable-ci.
[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%
(Reading database ... 70%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 75%
(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 .../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%
(Reading database ... 75%
(Reading database ... 80%
[Boot Postgres, apply every migration, verify idempotency] (Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
[Boot Postgres, apply every migration, verify idempotency] 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%
[Boot Postgres, apply every migration, verify idempotency] (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 ...
[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.
[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 ...
[Boot Postgres, apply every migration, verify idempotency] 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 ...
[Boot Postgres, apply every migration, verify idempotency] 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
[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] 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: +1073
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 17, added 5
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 113, added 106
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 242, added 231
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 286, added 271
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 324, added 312
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 338, added 323
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 347, added 334
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 349, added 335
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 449, added 443
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 484, added 478
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 502, added 487
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 532, added 518
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 533, added 518
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 549, added 533
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 728, added 720
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 854, added 841
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 920, added 913
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 1026, added 1016
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1073, reused 0, downloaded 1073, added 1073, 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
.../esbuild@0.25.12/node_modules/esbuild postinstall$ node install.js
.../esbuild@0.18.20/node_modules/esbuild postinstall$ node install.js
[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] .../node_modules/msw postinstall: Done
[Boot Postgres, apply every migration, verify idempotency] .../esbuild@0.18.20/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] .../esbuild@0.27.3/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 20.5s 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'
}
{
  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'
}
[⣯] 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'
}
{
  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'
}
[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: '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] [⣟] 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] {
  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] [⡿] applying migrations...[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] [✓] 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'
}
[✓] 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] 44 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
namespaces 8 columns 3 indexes 1 fks
organization_memberships 11 columns 4 indexes 2 fks
organizations 8 columns 3 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 15 columns 3 indexes 3 fks
repository_access_grants 7 columns 2 indexes 3 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_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

No schema changes, nothing to migrate 😴
Steps
2 steps in this job.
2 passed
02Checkoutcheckout1.5s
03Boot Postgres, apply every migration, verify idempotencyrun45s