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.

Sign up for GitHub

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

Jump to bottom

Fix Alembic script upgrade "filingtype" already exists error #192

Closed
nargis-sultani opened this issue May 1, 2024 · 2 comments · Fixed by #194
Closed

Fix Alembic script upgrade "filingtype" already exists error #192

nargis-sultani opened this issue May 1, 2024 · 2 comments · Fixed by #194
Assignees
@nargis-sultani

Comments

@nargis-sultani
Copy link
Contributor

This alembic upgrade head fails and throws this error:

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.DuplicateObject) type "filingtype" already exists

We need to go through the revisions and fix this error.
@nargis-sultani nargis-sultani self-assigned this May 1, 2024
@nargis-sultani
Copy link
Contributor Author

I was connecting to the wrong database causing these errors.

@nargis-sultani
Copy link
Contributor Author

Still have to fix the errors thrown during running downgrade base.

@nargis-sultani nargis-sultani reopened this May 2, 2024
@nargis-sultani nargis-sultani mentioned this issue May 2, 2024
Merged
25 tasks
jcadam14 pushed a commit that referenced this issue May 3, 2024
@nargis-sultani
Features/192 fix alembic filingtype already exists (#194)
c1c0fa4 
closes [#192 ](#192)

## Additions

-

## Removals

-

## Changes

-

## Testing

1.

## Screenshots


## Notes

-

## Todos

-

## Checklist

- [ ] PR has an informative and human-readable title
- [ ] Changes are limited to a single goal (no scope creep)
- [ ] Code can be automatically merged (no conflicts)
- [ ] Code follows the standards laid out in the [development
playbook](https://github.com/cfpb/development)
- [ ] Passes all existing automated tests
- [ ] Any _change_ in functionality is tested
- [ ] New functions are documented (with a description, list of inputs,
and expected output)
- [ ] Placeholder code is flagged / future todos are captured in
comments
- [ ] Visually tested in supported browsers and devices (see checklist
below 👇)
- [ ] Project documentation has been updated (including the "Unreleased"
section of the CHANGELOG)
- [ ] Reviewers requested with the [Reviewers
tool](https://help.github.com/articles/requesting-a-pull-request-review/)
:arrow_right:

## Testing checklist

### Browsers

- [ ] Chrome
- [ ] Firefox
- [ ] Safari
- [ ] Internet Explorer 8, 9, 10, and 11
- [ ] Edge
- [ ] iOS Safari
- [ ] Chrome for Android

### Accessibility

- [ ] Keyboard friendly
- [ ] Screen reader friendly

### Other

- [ ] Is useable without CSS
- [ ] Is useable without JS
- [ ] Flexible from small to large screens
- [ ] No linting errors or warnings
- [ ] JavaScript tests are passing

---------

Co-authored-by: Nargis Sultani <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@nargis-sultani nargis-sultani

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Features/192 fix alembic filingtype already exists cfpb/sbl-filing-api
1 participant
@nargis-sultani