Apply migrations to a fresh Postgres
Success7e95b3e99de1·main44s
Runner
Queued in pool default
Logs
Live output from all stepsLogs complete · 172 chunks
[Checkout] Cloning into '/var/lib/open-git/runner-work/43daf13d-1edc-49fb-95f9-a7466ce1bb5b'...
[Checkout] Note: switching to '7e95b3e99de1ccebb0358e8b5796ca1b8b17a319'.
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 7e95b3e update where readme comes from
[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%
[Boot Postgres, apply every migration, verify idempotency] (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 .../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%
(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) ...
[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%
[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%
(Reading database ... 100%
(Reading database ... 23258 files and directories currently installed.)
[Boot Postgres, apply every migration, verify idempotency] 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.
Preparing to unpack .../01-postgresql-client-common_248+deb12u1_all.deb ...
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 ...
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 ...
[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
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 18 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: +1086
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 16, added 0
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 27, added 12
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 41, added 27
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 42, added 27
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 187, added 182
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 305, added 290
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 433, added 420
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 465, added 450
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 541, added 526
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 625, added 619
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 657, added 643
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 682, added 673
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 683, added 673
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 778, added 764
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 879, added 863
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 949, added 933
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 1042, added 1029
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 1060, added 1049
[Boot Postgres, apply every migration, verify idempotency] Progress: resolved 1086, reused 0, downloaded 1086, added 1086, 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] .../esbuild@0.18.20/node_modules/esbuild postinstall$ node install.js
.../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.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] .../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] .../sharp@0.34.5/node_modules/sharp install: 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 20.4s 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] [2K[1G[⣯] 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'
}
{
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] {
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'
}
[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: 'SQL statement "ALTER TABLE "pull_request_diff_hunks" ADD CONSTRAINT "pull_request_diff_hunks_changed_file_id_pull_request_changed_files_id_fk" FOREIGN KEY ("changed_file_id") REFERENCES "public"."pull_request_changed_files"("id") ON DELETE cascade ON UPDATE no action"\n' +
'PL/pgSQL function inline_code_block line 2 at SQL statement',
file: 'scansup.c',
line: '99',
routine: 'truncate_identifier'
}
[2K[1G[⣟] applying migrations...[Boot Postgres, 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] [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] [2K[1G[⣻] applying migrations...{
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] [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'
}
{
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] 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.4s
03Boot Postgres, apply every migration, verify idempotencyrun43s