Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allowing multiple connections can lead to set role commands not being run against every connection #49

Open
JAForbes opened this issue Jun 3, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@JAForbes
Copy link
Owner

JAForbes commented Jun 3, 2024

We've recently observed this, a prior migration used:

export const connection = {
  max: 4
}

And then the subsequent migration created a table but the set role $migration_user command must have run on a different connection because the roles were created with postgres ownership.

Will need to potentially bring back killing all connections between migration files if we allow parallel connections, or at least if the prior migration had max > 1.

@JAForbes JAForbes added the bug Something isn't working label Jun 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant