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

Task 'zensus-inside-germany' fails #166

Closed
ClaraBuettner opened this issue Mar 19, 2021 · 1 comment · Fixed by #170
Closed

Task 'zensus-inside-germany' fails #166

ClaraBuettner opened this issue Mar 19, 2021 · 1 comment · Fixed by #170
Assignees
@gplssm
Labels
🐛 bug Something isn't working

Comments

@ClaraBuettner
Copy link
Contributor

The task 'zensus-inside-germany' fails with the following error when the task already run before since the data is not deleted from the table.

> psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "destatis_zensus_population_per_ha_inside_germany_pkey"
> DETAIL:  Key (gid)=(173) already exists.

I also noticed that the index of this table is still called 'gid' but we decided in #140 to rename it to 'id'.
@ClaraBuettner ClaraBuettner added the 🐛 bug Something isn't working label Mar 19, 2021
@gplssm
Copy link
Contributor

gplssm commented Mar 22, 2021

I change it to empty/delete the table if it exists prio to this task

@gplssm gplssm mentioned this issue Mar 22, 2021
Merged
gplssm added a commit that referenced this issue Mar 22, 2021
@gplssm
Merge pull request #170 from openego/fixes/#166-task-zensus-inside-ge…
039efb5 
…rmany-fails

Drop tables before creation and data insertation
ClaraBuettner added a commit that referenced this issue Mar 25, 2021
@ClaraBuettner
Merge pull request #182 from openego/fixes/#166-task-zensus-inside-ge…
2abef9a 
…rmany-fails

Delete zensus-inside-germany tables only if they exist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@gplssm gplssm

Labels
🐛 bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Drop tables before creation and data insertation openego/eGon-data
2 participants
@gplssm @ClaraBuettner