Migration issue on pgmq with branching?
I am facing this weird issue on migration. We use branching and when I create a pr the migration check is failing on supabase. This migration file is already run though and passed other branches but failed for main branch.
11 Replies
Have you enabled queue from integrations? I wonder if that could be causing issues
Yes queue is enabled, this migration did run successfully before in the same branch and now its throwing this error.
What changes were made to this branch since it was last running
i'm guessing you added a new migration file?
Yes we have multiple new migration file, but this migration is from almost 7 months ago. Merged multiple migration file after that. Never had this issue before.
anything mention of pgmq in those new migration files
No, nothing new related to pgmq in new migration files.
1 more abnormal thing, I ignored the error and merged the pr, I can see all changes in database were migrated but its stuck in logs.
what region are you in?
us-east-1
Hmm, you shouldn't be affected by anything in infra though from #status
it can take a while
I thought you sai this was was main branch? I don't understand what you mean with you merged a branch?
By the way i am seeing other reports of migrations not working
Not sure if it is related to what you are doing though
So far the other 3 posts here are all a specific auth migration on running instances.
hmm, probably not related then i think