Failures on the smoke test here are related to DNS propagation, possibly related to my own network stack at home as only the initial post-upgrade SQL exec has a connection failure to the DB DNS record, I would consider this a pass ❯ ./scripts/test-postgres-smoke.sh https://github.com/supabase/postgres/pull/1714============================================================Supadev PostgreSQL Smoke Upgrade Test Suite============================================================[INFO] Testing PostgresEngines: 15 17[INFO] Using region: us-east-1[INFO] Project prefix: supadev-smoke-1766099724[INFO] SQL smoke directory: /Users/lgug2z/supadev/sql/smoke[INFO] GitHub PR URL: https://github.com/supabase/postgres/pull/1714============================================================Testing PostgreSQL Smoke Upgrade: 15============================================================[INFO] Project name: supadev-smoke-1766099724-pg15[INFO] Region: us-east-1[INFO] Start time: 2025-12-18 15:15:24[STEP] Resolving version from PR for upgrade target engine 17...[SUCCESS] Resolved version: 17.6.1.064-update-nixpkgs-5[STEP] Ensuring version 17.6.1.064-update-nixpkgs-5 is withdrawn...INSERT 0 0UPDATE 1 version | region | provider_image_id | release_channel | postgres_engine-----------------------------------------------+-----------+-----------------------+-----------------+----------------- supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn | 17(1 row)[STEP] Creating project with PostgresEngine 15...Creating project on release channel "ga" with version "supabase-postgres-15.14.1.063"Project URL: http://localhost:8082/project/hodldlmwicpgnddusnbyAdmin URL: http://localhost:4000/projects?identifier=hodldlmwicpgnddusnbyDatabase status is not yet available, waiting...Database status is currently COMING_UP, waiting...Database status is currently COMING_UP, waiting...Database status is currently COMING_UP, waiting...Database status is now ACTIVE_HEALTHY[SUCCESS] Project supadev-smoke-1766099724-pg15 created and reached ACTIVE_HEALTHY status[INFO] Time to ACTIVE_HEALTHY: 194 seconds[INFO] Sleeping for 10 seconds before checking project health[STEP] Checking project health for supadev-smoke-1766099724-pg15...[ { "name": "PostgREST", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "db_schema": "public,graphql_public" } }, { "name": "Auth", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "description": "GoTrue is a user registration and authentication API", "name": "GoTrue", "version": "v2.184.0" } }, { "name": "Storage", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Realtime", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "connected_cluster": 0, "db_connected": false, "healthy": true, "node": "realtime@2600:1f14:2de3:6d00:845:3edb:f6ce:3436", "region": "us-west-2" } }, { "name": "Postgres (Admin)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Postgres (User)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Supavisor (TXN)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "PgBouncer", "healthy": true, "status": "ACTIVE_HEALTHY" }][STEP] Printing project information before upgrade...{ "cloud_provider": "AWS", "db_host": "db.hodldlmwicpgnddusnby.supabase.red", "id": 21, "inserted_at": "2025-12-18T23:15:27.656531", "name": "supadev-smoke-1766099724-pg15", "organization_id": 1, "ref": "hodldlmwicpgnddusnby", "region": "us-east-1", "status": "ACTIVE_HEALTHY", "subscription_id": "Avx7DALGCeGDjvVm", "connectionString": "U2FsdGVkX198tVEcPCp+GcwI55hCZgWoNQyGMJ6BWfhJr4YgeNlWc9KOAmoYRtjY7u9LxPOcrwgmA9Ji+4FTQTCHly6bH+s/jc087A+3QsKr8IpdkjnXRpIGrK8QH2OsrFgR6nx0KqpyFFGuX3EOL9bKF1Ju0Hga96juYhWsXW+xBXt64WguflfwIZ9puD5D", "restUrl": "https://hodldlmwicpgnddusnby.supabase.red/rest/v1/", "volumeSizeGb": 8, "maxDatabasePreprovisionGb": null, "lastDatabaseResizeAt": null, "is_branch_enabled": false, "is_physical_backups_enabled": false, "infra_compute_size": "nano", "dbVersion": "supabase-postgres-15.14.1.063"}============================================================Executing pre-upgrade SQL files============================================================[STEP] Executing SQL: 01-pgmq.sql[INFO] SQL output:CREATE EXTENSION create--------(1 row) send------ 1(1 row)[SUCCESS] Found expected string (line 1): CREATE EXTENSION[SUCCESS] Found expected string (line 2): create[SUCCESS] Found expected string (line 3): send[SUCCESS] Found expected string (line 4): 1[SUCCESS] Verification passed for: 01-pgmq.sql[STEP] Executing SQL: 02-items.sql[INFO] SQL output:CREATE TABLEINSERT 0 2 name-------- First Second(2 rows)[SUCCESS] Found expected string (line 1): CREATE TABLE[SUCCESS] Found expected string (line 2): INSERT 0 2[SUCCESS] Found expected string (line 3): name[SUCCESS] Found expected string (line 4): First[SUCCESS] Found expected string (line 5): Second[SUCCESS] Verification passed for: 02-items.sql[STEP] Executing SQL: 03-event_trigger.sql[INFO] SQL output:CREATE FUNCTIONCREATE EVENT TRIGGER[SUCCESS] Found expected string (line 1): CREATE FUNCTION[SUCCESS] Found expected string (line 2): CREATE EVENT TRIGGER[SUCCESS] Verification passed for: 03-event_trigger.sql[STEP] Executing SQL: 04-subitems.sql[INFO] SQL output:CREATE TABLE name--------------------------------------------------------------------------- First Second CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:18:55.116992+00(3 rows)[SUCCESS] Found expected string (line 1): CREATE TABLE[SUCCESS] Found expected string (line 2): name[SUCCESS] Found expected string (line 3): First[SUCCESS] Found expected string (line 4): Second[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public[SUCCESS] Verification passed for: 04-subitems.sql[SUCCESS] All pre-upgrade SQL files executed and verified successfully[STEP] Inserting version 17.6.1.064-update-nixpkgs-5 as GA...INSERT 0 0UPDATE 1 version | region | provider_image_id | release_channel | postgres_engine-----------------------------------------------+-----------+-----------------------+-----------------+----------------- supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | ga | 17(1 row)[SUCCESS] Version 17.6.1.064-update-nixpkgs-5 inserted as GA[STEP] Printing project upgrade eligibility...{ "eligible": true, "current_app_version": "supabase-postgres-15.14.1.063", "current_app_version_release_channel": "ga", "latest_app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5", "target_upgrade_versions": [ { "postgres_version": "17", "release_channel": "ga", "app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5" }, { "postgres_version": "17", "release_channel": "internal", "app_version": "supabase-postgres-17.4.1.077" } ], "duration_estimate_hours": 1, "legacy_auth_custom_roles": [], "objects_to_be_dropped": [], "unsupported_extensions": [], "user_defined_objects_in_internal_schemas": []}[STEP] Upgrading project to PostgresEngine 17 version 17.6.1.064-update-nixpkgs-5...Upgrade status is not yet available, waiting...Upgrade status is currently 1_started, waiting...Upgrade status is currently 1_started, waiting...Upgrade status is currently 1_started, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade completed (status inferred by empty API response)[SUCCESS] Project supadev-smoke-1766099724-pg15 upgraded successfully[INFO] Time to complete upgrade: 636 seconds[INFO] Sleeping for 60 seconds before checking project health[STEP] Checking project health for supadev-smoke-1766099724-pg15...Waiting for all project components to become healthy, 9 retry attempt(s) remaining...Waiting for all project components to become healthy, 8 retry attempt(s) remaining...[ { "name": "PostgREST", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "db_schema": "public,graphql_public" } }, { "name": "Auth", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "description": "GoTrue is a user registration and authentication API", "name": "GoTrue", "version": "v2.184.0" } }, { "name": "Storage", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Realtime", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "connected_cluster": 0, "db_connected": false, "healthy": true, "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214", "region": "us-west-2" } }, { "name": "Postgres (Admin)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Postgres (User)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Supavisor (TXN)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "PgBouncer", "healthy": true, "status": "ACTIVE_HEALTHY" }][STEP] Printing project information after upgrade...{ "cloud_provider": "AWS", "db_host": "db.hodldlmwicpgnddusnby.supabase.red", "id": 21, "inserted_at": "2025-12-18T23:15:27.656531", "name": "supadev-smoke-1766099724-pg15", "organization_id": 1, "ref": "hodldlmwicpgnddusnby", "region": "us-east-1", "status": "ACTIVE_HEALTHY", "subscription_id": "Avx7DALGCeGDjvVm", "connectionString": "U2FsdGVkX1/YnVHAYABon/GHOWCgxErIS9Uc+oQWvSe0CLD+/RlHWeldEDoOfu75ds45dNq2pxUjl0r3k+qyNOZJH3sVL/E8U323Sc/JsRk2ojNBHh9G2cR3WbFUEHwDP4VEupYwQLX94zxNMFPsljBU91WV1IaA2MH4iEYQiJXqyvKA0ag7GWy1ClB3QEJZ", "restUrl": "https://hodldlmwicpgnddusnby.supabase.red/rest/v1/", "volumeSizeGb": 8, "maxDatabasePreprovisionGb": null, "lastDatabaseResizeAt": null, "is_branch_enabled": false, "is_physical_backups_enabled": false, "infra_compute_size": "nano", "dbVersion": "supabase-postgres-17.6.1.064-update-nixpkgs-5"}============================================================Executing post-upgrade SQL files============================================================[STEP] Executing SQL: 01-pgmq.sql [ERROR] Failed to execute SQL file: 01-pgmq.sql[ERROR] Output: Error: 0: psql failed: psql: error: connection to server at "db.hodldlmwicpgnddusnby.supabase.red" (2600:1f18:22a5:ad04:bf53:b9ed:e042:30d5), port 5432 failed: Network is unreachable Is the server running on that host and accepting TCP/IP connections?Location: src/psql.rs:137 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ BACKTRACE ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⋮ 6 frames hidden ⋮ 7: supadev::psql::execute_sql_file::hfe1c523b5fb4db2d at <unknown source file>:<unknown line> 8: supadev::main::h2456504d0c926344 at <unknown source file>:<unknown line> 9: std::sys::backtrace::__rust_begin_short_backtrace::h3544633b4c27a310 at <unknown source file>:<unknown line> 10: std::rt::lang_start::{{closure}}::h2e5ceb56fe3b4c49 at <unknown source file>:<unknown line> 11: std::rt::lang_start_internal::hd700ba983d3377dc at <unknown source file>:<unknown line> 12: _main<unknown> at <unknown source file>:<unknown line>Run with COLORBT_SHOW_HIDDEN=1 environment variable to disable frame filtering.Run with RUST_BACKTRACE=full to include source snippets.[STEP] Executing SQL: 02-items.sql[INFO] SQL output: name--------------------------------------------------------------------------- First Second CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:18:55.116992+00(3 rows)[SUCCESS] Found expected string (line 1): name[SUCCESS] Found expected string (line 2): First[SUCCESS] Found expected string (line 3): Second[SUCCESS] Found expected string (line 4): CREATE TABLE - public.subitems_1 - public[SUCCESS] Verification passed for: 02-items.sql[STEP] Executing SQL: 03-subitems.sql[INFO] SQL output:CREATE TABLE name--------------------------------------------------------------------------- First Second CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:18:55.116992+00 CREATE TABLE - public.subitems_2 - public - 2025-12-18 23:32:02.461059+00(4 rows)[SUCCESS] Found expected string (line 1): CREATE TABLE[SUCCESS] Found expected string (line 2): name[SUCCESS] Found expected string (line 3): First[SUCCESS] Found expected string (line 4): Second[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public[SUCCESS] Found expected string (line 6): CREATE TABLE - public.subitems_2 - public[SUCCESS] Verification passed for: 03-subitems.sql[ERROR] post-upgrade SQL verification failed[ERROR] Post-upgrade SQL verification failed[INFO] Project supadev-smoke-1766099724-pg15 left intact for manual inspectionINSERT 0 0UPDATE 1 version | region | provider_image_id | release_channel | postgres_engine-----------------------------------------------+-----------+-----------------------+-----------------+----------------- supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn | 17(1 row)============================================================Testing PostgreSQL Smoke Upgrade: 17============================================================[INFO] Project name: supadev-smoke-1766099724-pg17[INFO] Region: us-east-1[INFO] Start time: 2025-12-18 15:32:04[STEP] Resolving version from PR for upgrade target engine 17...[SUCCESS] Resolved version: 17.6.1.064-update-nixpkgs-5[STEP] Ensuring version 17.6.1.064-update-nixpkgs-5 is withdrawn...INSERT 0 0UPDATE 1 version | region | provider_image_id | release_channel | postgres_engine-----------------------------------------------+-----------+-----------------------+-----------------+----------------- supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn | 17(1 row)[STEP] Creating project with PostgresEngine 17...Creating project on release channel "ga" with version "supabase-postgres-17.6.1.063"Project URL: http://localhost:8082/project/fbuixzflrwchmiztbbieAdmin URL: http://localhost:4000/projects?identifier=fbuixzflrwchmiztbbieDatabase status is not yet available, waiting... Database status is now ACTIVE_HEALTHYMING_UP, waiting....[SUCCESS] Project supadev-smoke-1766099724-pg17 created and reached ACTIVE_HEALTHY status[INFO] Time to ACTIVE_HEALTHY: 133 seconds[INFO] Sleeping for 10 seconds before checking project health[STEP] Checking project health for supadev-smoke-1766099724-pg17...Waiting for all project components to become healthy, 4 retry attempt(s) remaining...Waiting for all project components to become healthy, 3 retry attempt(s) remaining...Waiting for all project components to become healthy, 2 retry attempt(s) remaining...[ { "name": "PostgREST", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "db_schema": "public,graphql_public" } }, { "name": "Auth", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "description": "GoTrue is a user registration and authentication API", "name": "GoTrue", "version": "v2.184.0" } }, { "name": "Storage", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Realtime", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "connected_cluster": 0, "db_connected": false, "healthy": true, "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214", "region": "us-west-2" } }, { "name": "Postgres (Admin)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Postgres (User)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Supavisor (TXN)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "PgBouncer", "healthy": true, "status": "ACTIVE_HEALTHY" }][STEP] Printing project information before upgrade...{ "cloud_provider": "AWS", "db_host": "db.fbuixzflrwchmiztbbie.supabase.red", "id": 22, "inserted_at": "2025-12-18T23:32:07.178628", "name": "supadev-smoke-1766099724-pg17", "organization_id": 1, "ref": "fbuixzflrwchmiztbbie", "region": "us-east-1", "status": "ACTIVE_HEALTHY", "subscription_id": "Avx7DALGCeGDjvVm", "connectionString": "U2FsdGVkX1/y33ryKx1337UewtXfQGlPcdHYdP5COvFAJDP/+6VKqe1Up/JWrjkJBMj1J08BJWpW8TS6hAQAqU+kkPR9Up9xN0fjdsQVRarkK2qP/6rGbFe1nbpm8Ep/JUkJVh2LmyjScZSSNVi/XNZ66I0jqdT+9WTf/i1ob5zQKemaFZB4QqYfswO+KGQC", "restUrl": "https://fbuixzflrwchmiztbbie.supabase.red/rest/v1/", "volumeSizeGb": 8, "maxDatabasePreprovisionGb": null, "lastDatabaseResizeAt": null, "is_branch_enabled": false, "is_physical_backups_enabled": false, "infra_compute_size": "nano", "dbVersion": "supabase-postgres-17.6.1.063"}============================================================Executing pre-upgrade SQL files============================================================[STEP] Executing SQL: 01-pgmq.sql[INFO] SQL output:CREATE EXTENSION create--------(1 row) send------ 1(1 row)[SUCCESS] Found expected string (line 1): CREATE EXTENSION[SUCCESS] Found expected string (line 2): create[SUCCESS] Found expected string (line 3): send[SUCCESS] Found expected string (line 4): 1[SUCCESS] Verification passed for: 01-pgmq.sql[STEP] Executing SQL: 02-items.sql[INFO] SQL output:CREATE TABLEINSERT 0 2 name-------- First Second(2 rows)[SUCCESS] Found expected string (line 1): CREATE TABLE[SUCCESS] Found expected string (line 2): INSERT 0 2[SUCCESS] Found expected string (line 3): name[SUCCESS] Found expected string (line 4): First[SUCCESS] Found expected string (line 5): Second[SUCCESS] Verification passed for: 02-items.sql[STEP] Executing SQL: 03-event_trigger.sql[INFO] SQL output:CREATE FUNCTIONCREATE EVENT TRIGGER[SUCCESS] Found expected string (line 1): CREATE FUNCTION[SUCCESS] Found expected string (line 2): CREATE EVENT TRIGGER[SUCCESS] Verification passed for: 03-event_trigger.sql[STEP] Executing SQL: 04-subitems.sql[INFO] SQL output:CREATE TABLE name------------------------------------------------------------------------- First Second CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:35:25.7128+00(3 rows)[SUCCESS] Found expected string (line 1): CREATE TABLE[SUCCESS] Found expected string (line 2): name[SUCCESS] Found expected string (line 3): First[SUCCESS] Found expected string (line 4): Second[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public[SUCCESS] Verification passed for: 04-subitems.sql[SUCCESS] All pre-upgrade SQL files executed and verified successfully[STEP] Inserting version 17.6.1.064-update-nixpkgs-5 as GA...INSERT 0 0UPDATE 1 version | region | provider_image_id | release_channel | postgres_engine-----------------------------------------------+-----------+-----------------------+-----------------+----------------- supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | ga | 17(1 row)[SUCCESS] Version 17.6.1.064-update-nixpkgs-5 inserted as GA[STEP] Printing project upgrade eligibility...{ "eligible": true, "current_app_version": "supabase-postgres-17.6.1.063", "current_app_version_release_channel": "ga", "latest_app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5", "target_upgrade_versions": [ { "postgres_version": "17", "release_channel": "ga", "app_version": "supabase-postgres-17.6.1.064-update-nixpkgs-5" } ], "duration_estimate_hours": 1, "legacy_auth_custom_roles": [], "objects_to_be_dropped": [], "unsupported_extensions": [], "user_defined_objects_in_internal_schemas": []}[STEP] Upgrading project to PostgresEngine 17 version 17.6.1.064-update-nixpkgs-5...Upgrade status is not yet available, waiting...Upgrade status is currently 1_started, waiting...Upgrade status is currently 1_started, waiting...Upgrade status is currently 1_started, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade status is currently 5_initiated_data_upgrade, waiting...Upgrade completed (status inferred by empty API response)[SUCCESS] Project supadev-smoke-1766099724-pg17 upgraded successfully[INFO] Time to complete upgrade: 687 seconds[INFO] Sleeping for 60 seconds before checking project health[STEP] Checking project health for supadev-smoke-1766099724-pg17...Waiting for all project components to become healthy, 9 retry attempt(s) remaining...Waiting for all project components to become healthy, 8 retry attempt(s) remaining...Waiting for all project components to become healthy, 7 retry attempt(s) remaining...[ { "name": "PostgREST", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "db_schema": "public,graphql_public" } }, { "name": "Auth", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "description": "GoTrue is a user registration and authentication API", "name": "GoTrue", "version": "v2.184.0" } }, { "name": "Storage", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Realtime", "healthy": true, "status": "ACTIVE_HEALTHY", "info": { "connected_cluster": 0, "db_connected": false, "healthy": true, "node": "realtime@2600:1f14:2de3:6d02:237:d20e:a670:a214", "region": "us-west-2" } }, { "name": "Postgres (Admin)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Postgres (User)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "Supavisor (TXN)", "healthy": true, "status": "ACTIVE_HEALTHY" }, { "name": "PgBouncer", "healthy": true, "status": "ACTIVE_HEALTHY" }][STEP] Printing project information after upgrade...{ "cloud_provider": "AWS", "db_host": "db.fbuixzflrwchmiztbbie.supabase.red", "id": 22, "inserted_at": "2025-12-18T23:32:07.178628", "name": "supadev-smoke-1766099724-pg17", "organization_id": 1, "ref": "fbuixzflrwchmiztbbie", "region": "us-east-1", "status": "ACTIVE_HEALTHY", "subscription_id": "Avx7DALGCeGDjvVm", "connectionString": "U2FsdGVkX1+AvpdkZoDa+rsxGNvh5JSgLB9owSD1kzIaioiGyDd5U1IKu90tlgy1Iyx85jkMwkESUGSohCmTbx+sVJcCv+ageP94XG2e6lT7hnrfTjrqMp924V/syJ2yEeV3LuLgz3egbhuehsDiWylDOxlOGTAt7pR9UUPhlM2chgKDQUp2nIVP+kKHpwpA", "restUrl": "https://fbuixzflrwchmiztbbie.supabase.red/rest/v1/", "volumeSizeGb": 8, "maxDatabasePreprovisionGb": null, "lastDatabaseResizeAt": null, "is_branch_enabled": false, "is_physical_backups_enabled": false, "infra_compute_size": "nano", "dbVersion": "supabase-postgres-17.6.1.064-update-nixpkgs-5"}============================================================Executing post-upgrade SQL files============================================================[STEP] Executing SQL: 01-pgmq.sql[ERROR] Failed to execute SQL file: 01-pgmq.sql[ERROR] Output: Error: 0: psql failed: psql: error: connection to server at "db.fbuixzflrwchmiztbbie.supabase.red" (2600:1f18:22a5:ad01:d49a:4b94:e56e:9371), port 5432 failed: Network is unreachable Is the server running on that host and accepting TCP/IP connections?Location: src/psql.rs:137 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ BACKTRACE ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⋮ 6 frames hidden ⋮ 7: supadev::psql::execute_sql_file::hfe1c523b5fb4db2d at <unknown source file>:<unknown line> 8: supadev::main::h2456504d0c926344 at <unknown source file>:<unknown line> 9: std::sys::backtrace::__rust_begin_short_backtrace::h3544633b4c27a310 at <unknown source file>:<unknown line> 10: std::rt::lang_start::{{closure}}::h2e5ceb56fe3b4c49 at <unknown source file>:<unknown line> 11: std::rt::lang_start_internal::hd700ba983d3377dc at <unknown source file>:<unknown line> 12: _main<unknown> at <unknown source file>:<unknown line>Run with COLORBT_SHOW_HIDDEN=1 environment variable to disable frame filtering.Run with RUST_BACKTRACE=full to include source snippets.[STEP] Executing SQL: 02-items.sql[INFO] SQL output: name------------------------------------------------------------------------- First Second CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:35:25.7128+00(3 rows)[SUCCESS] Found expected string (line 1): name[SUCCESS] Found expected string (line 2): First[SUCCESS] Found expected string (line 3): Second[SUCCESS] Found expected string (line 4): CREATE TABLE - public.subitems_1 - public[SUCCESS] Verification passed for: 02-items.sql[STEP] Executing SQL: 03-subitems.sql[INFO] SQL output:CREATE TABLE name--------------------------------------------------------------------------- First Second CREATE TABLE - public.subitems_1 - public - 2025-12-18 23:35:25.7128+00 CREATE TABLE - public.subitems_2 - public - 2025-12-18 23:48:43.945853+00(4 rows)[SUCCESS] Found expected string (line 1): CREATE TABLE[SUCCESS] Found expected string (line 2): name[SUCCESS] Found expected string (line 3): First[SUCCESS] Found expected string (line 4): Second[SUCCESS] Found expected string (line 5): CREATE TABLE - public.subitems_1 - public[SUCCESS] Found expected string (line 6): CREATE TABLE - public.subitems_2 - public[SUCCESS] Verification passed for: 03-subitems.sql[ERROR] post-upgrade SQL verification failed[ERROR] Post-upgrade SQL verification failed[INFO] Project supadev-smoke-1766099724-pg17 left intact for manual inspectionINSERT 0 0UPDATE 1 version | region | provider_image_id | release_channel | postgres_engine-----------------------------------------------+-----------+-----------------------+-----------------+----------------- supabase-postgres-17.6.1.064-update-nixpkgs-5 | us-east-1 | ami-03b48a495293e9a2c | withdrawn | 17(1 row)============================================================Test Summary============================================================ENGINE RESULT------ ------15 FAILED (post-upgrade SQL)17 FAILED (post-upgrade SQL)============================================================Total: 2 | Passed: 0 | Failed: 2============================================================[ERROR] Some tests failed!
|
samrose left a comment
Uh oh!
There was an error while loading.Please reload this page.
Use one recent version of nixpkgs in the flake inputs.
a76c4553d7e741e17f289224eda135423de0491d ->f61125a668a320878494449750330ca58b78c557