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

Failure to restore DB from fixture #2091

Open
iaindillingham opened this issue Oct 18, 2024 · 0 comments
Open

Failure to restore DB from fixture #2091

iaindillingham opened this issue Oct 18, 2024 · 0 comments

Comments

@iaindillingham
Copy link
Member

Restoring the DB from core-data-2024-10-16.json fails with the following:

django.db.utils.IntegrityError: Problem installing fixtures:
The row in table 'codelists_codelistversion' with primary key '10' has an invalid foreign key:
codelists_codelistversion.coding_system_release_id contains a value '5'
that does not have a corresponding value in versioning_codingsystemrelease.id.

It also took nearly 1:45 to get this far.

real    102m26.526s
user    97m2.226s
sys     2m21.664s

Restoring the DB from a fixture is recommended for local development (#2088) and is, of course, necessary should the production DB become unusable. Should we temporarily disable integrity constraints when restoring the DB from a fixture?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant