[FEAT-Infra]: Resolve Flyway Migration issues in AWS
@noarevalo-bah is already working on this.
Since Aug 19, 2026.
Assessment
This issue has not been assessed yet.
Description
Currently, migrations (via the flyway container) are part of the chart-api ECS task definition, so migrations are only run if we push sctapi to ECR - if migrations fail, changes to the chart-api service (like api endpoint updates) will not be deployed - we won't know that changes failed to be deployed via the github workflow, as that only pushes to ECR, and doesn't watch any other downstream issues.
Because only chart-api has a sidecar, pushing chart-feat-api to ECR doesn't trigger migrations in any case, which will (and has) caused drift between the api and RDS db. We need to i) add a flyway sidecar to the chart-feat-api service as well, and ii) update the api GitHub deployment workflow to push both api images in one workflow (this will be done in #723).
Create a Jira ticket that requests the following:
- Add a flyway sidecar to the chart-feat-api service
- While we're here, enable DeploymentCircuitBreaker on both api services to automatically rollback to the last known good version in the event of a failed migration
- Dominant language
- No language data
- Stars
- 2
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from USACE/chart-docs
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
USACE/chart-docs#756 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
USACE/chart-docs#750 ·
-
[FEAT-API/UI]: Add ability to download hydrograph input / outputPossibly taken @noarevalo-bah claimed this today. Open
USACE/chart-docs#759 · 1 assignee ·
-
Difficulty 5/5 Over a week Newbie friendliness 30/100
USACE/chart-docs#758 · 1 assignee ·
-
Difficulty 4/5 3-5 days Newbie friendliness 48/100
USACE/chart-docs#755 ·