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

Fix out of sync prod database schema #12944

Open
dacook opened this issue Oct 24, 2024 · 0 comments
Open

Fix out of sync prod database schema #12944

dacook opened this issue Oct 24, 2024 · 0 comments

Comments

@dacook
Copy link
Member

dacook commented Oct 24, 2024

What we should change and why (this is tech debt)

Some production database schemas are out of sync. This can cause big problems.

So we should review all differences and evaluate which ones should be addressed (including the one linked above)

We can probably run git diff db/schema.rb on every server with ansible.

Any differences of consequence, should be fixed. Maybe we just manually update each server with psql, but it'd be much better if we can write a rails migration that does it. (Maybe a condition can check the state of the db column, and migrate if needed. maybe the rails migration handles that automatically.)

Impact and timeline

I think this should be prioritised before we forget about it. We don't want another S1

@github-project-automation github-project-automation bot moved this to All the things 💤 in OFN Delivery board Oct 24, 2024
@dacook dacook moved this from All the things 💤 to Dev ready 👋 in OFN Delivery board Oct 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Dev ready 👋
Development

No branches or pull requests

1 participant