Title: Error: Duplicate key (subst_id) in ego_grid_mv_griddistrict in ego_dp_mv_griddistrict.sql · Issue #360 · openego/data_processing · GitHub
Open Graph Title: Error: Duplicate key (subst_id) in ego_grid_mv_griddistrict in ego_dp_mv_griddistrict.sql · Issue #360 · openego/data_processing
X Title: Error: Duplicate key (subst_id) in ego_grid_mv_griddistrict in ego_dp_mv_griddistrict.sql · Issue #360 · openego/data_processing
Description: When executing ego_dp_mv_griddistrict.sql I get the following error: sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ego_grid_mv_griddistrict_pkey" DETAIL: Key (subst_id)=(...
Open Graph Description: When executing ego_dp_mv_griddistrict.sql I get the following error: sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ego_grid_mv_gri...
X Description: When executing ego_dp_mv_griddistrict.sql I get the following error: sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ego_grid_m...
Opengraph URL: https://github.com/openego/data_processing/issues/360
X: @github
Domain: patch-diff.githubusercontent.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error: Duplicate key (subst_id) in ego_grid_mv_griddistrict in ego_dp_mv_griddistrict.sql","articleBody":"When executing ego_dp_mv_griddistrict.sql I get the following error:\r\n\r\nsqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint \"ego_grid_mv_griddistrict_pkey\"\r\nDETAIL: Key (subst_id)=(155) already exists.\r\n\r\nbut looking at the code and the input / temporary tables I am not able to find where the duplication comes from (many of the temporary table also have a primary key, hence there could not be a duplicated key in them either). ","author":{"url":"https://github.com/OriolRaventos","@type":"Person","name":"OriolRaventos"},"datePublished":"2020-04-14T12:25:42.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/360/data_processing/issues/360"}| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:a0ae9a79-33b3-4ce9-60bf-c096c8351d29 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | ACD4:11F0A4:71BB73:94F72C:698E9252 |
| html-safe-nonce | a5a4065843f6dcce6502313ec91bbd4d3dbfecfdf3014b975f0b3762a264441d |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBQ0Q0OjExRjBBNDo3MUJCNzM6OTRGNzJDOjY5OEU5MjUyIiwidmlzaXRvcl9pZCI6IjIyMTIwODQ4OTI4MjAyMTQzNTUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 2d9bfd521d001d3392ba977838c28a84d8361a5b4668b92155d5894defc872b5 |
| hovercard-subject-tag | issue:599534092 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/openego/data_processing/360/issue_layout |
| twitter:image | https://opengraph.githubassets.com/b250ee288b6da7983381cf894b2db71c0209e638709d7ebbe27a19715348f2ab/openego/data_processing/issues/360 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/b250ee288b6da7983381cf894b2db71c0209e638709d7ebbe27a19715348f2ab/openego/data_processing/issues/360 |
| og:image:alt | When executing ego_dp_mv_griddistrict.sql I get the following error: sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ego_grid_mv_gri... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | OriolRaventos |
| hostname | github.com |
| expected-hostname | github.com |
| None | cb2828a801ee6b7be618f3ac76fbf55def35bbc30f053a9c41bf90210b8b72ba |
| turbo-cache-control | no-preview |
| go-import | github.com/openego/data_processing git https://github.com/openego/data_processing.git |
| octolytics-dimension-user_id | 15909192 |
| octolytics-dimension-user_login | openego |
| octolytics-dimension-repository_id | 54381958 |
| octolytics-dimension-repository_nwo | openego/data_processing |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 54381958 |
| octolytics-dimension-repository_network_root_nwo | openego/data_processing |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | e6b91a7e6e46287d26887e3fb7a4161657bab8f7 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width