Pain point · Self-hosting & upgrades · Causes churn
Upgrade migration fails when another schema has the same table
1 source thread · first seen 2026-10
Summary
A PostgreSQL upgrade migration fails because its primary-key lookup finds constraints for query_execution in multiple schemas, causing a subquery error. The reporter uses separate Metabase installations in separate schemas of one database.
- Affects
- Teams running multiple Metabase installations in separate PostgreSQL schemas
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“Migration 20260722_rename_query_execution_pkey.yaml returns the following Error:”