https://pulp.plan.io/https://pulp.plan.io/favicon.ico2021-01-29T09:29:41ZPulpMigration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=669552021-01-29T09:29:41Zttereshcttereshc@redhat.com
<ul><li><strong>Priority</strong> changed from <i>High</i> to <i>Urgent</i></li><li><strong>Sprint/Milestone</strong> set to <i>0.9.0</i></li><li><strong>Sprint</strong> set to <i>Sprint 89</i></li></ul> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=669712021-01-29T22:03:13Zggainey
<ul></ul><p>Hard to figure out what's going on without more info.</p>
<p>Could I ask anyone who is seeing this, to grab some more data for us?</p>
<ul>
<li>log info</li>
<li>erratum</li>
<li>specific repo</li>
</ul>
<p>To find the erratum, grab the "(pulp2content_id)=" from th etraceback and look for it in mongo:</p>
<pre><code>$ mongo
MongoDB shell version v3.4.24
connecting to: mongodb://127.0.0.1:27017
MongoDB server version: 3.4.24
...
> use pulp_database
switched to db pulp_database
> db.units_erratum.find({ "_id": "ID-HERE" });
{ "_id" : "9f6c6313-3fcb-4409-b3fa-0bd69b3fad77", "pulp_user_metadata" : { }, "_last_updated" : 1611955176, "errata_id" : "RHBA-2020:4548", "status" : "final", "updated" : "2020-11-03 19:39:00 UTC", "description" : "For detailed information on changes in this release, see the Red Hat\nEnterprise Linux 8.3 Release Notes linked from the References section.", "issued" : "2020-11-03 12:14:39 UTC", "pushcount" : "2", "references" : [ { "href" : "https://access.redhat.com/errata/RHBA-2020:4548", "type" : "self", "id" : "RHBA-2020:4548", "title" : "RHBA-2020:4548" }, { "href" : "https://bugzilla.redhat.com/show_bug.cgi?id=1829822", "type" : "bugzilla", "id" : "1829822", "title" : "Rebase gpgme to version 1.13.1 to accommodate gnupg-2.2.20" }, { "href" : "https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/8.3_release_notes/index", "type" : "other", "id" : "ref_0", "title" : "other_reference_0" } ], "reboot_suggested" : false, "relogin_suggested" : false, "restart_suggested" : false, "from" : "release-engineering@redhat.com", "severity" : "None", "rights" : "Copyright 2020 Red Hat Inc", "version" : "2", "release" : "0", "type" : "bugfix", "pkglist" : [ ], "title" : "gpgme bug fix and enhancement update", "solution" : "Before applying this update, make sure all previously released errata\nrelevant to your system have been applied.\n\nFor details on how to apply this update, refer to:\n\nhttps://access.redhat.com/articles/11258", "summary" : "An update for gpgme is now available for Red Hat Enterprise Linux 8.", "_ns" : "units_erratum", "_content_type_id" : "erratum" }
>
</code></pre>
<p>To get the repo and remote(s):</p>
<pre><code>$ mongo
> use pulp_database
> db.repo_content_units.find({"unit_id": "ID-HERE"});
{ "_id" : ObjectId("60147be84f26977bc0cc7b49"), "repo_id" : "rhel8-base", "unit_id" : "9f6c6313-3fcb-4409-b3fa-0bd69b3fad77", "unit_type_id" : "erratum", "updated" : "2021-01-29T21:19:36Z", "created" : "2021-01-29T21:19:36Z" }
> db.repo_importers.find({ "repo_id": "REPO-ID-ABOVE"} );
{...}
</code></pre>
<p>Hopefully we can recreate this more directly than via "Something went wrong in one of the 34K repos in this dataset. Go fish." :)</p> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=669722021-01-29T22:03:25Zggainey
<ul><li><strong>Status</strong> changed from <i>NEW</i> to <i>ASSIGNED</i></li><li><strong>Assignee</strong> set to <i>ggainey</i></li></ul> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=672322021-02-04T22:09:59Zrchan
<ul><li><strong>Sprint</strong> changed from <i>Sprint 89</i> to <i>Sprint 90</i></li></ul> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=676642021-02-15T20:05:07Zggainey
<ul><li><strong>Status</strong> changed from <i>ASSIGNED</i> to <i>POST</i></li></ul><p><a href="https://github.com/pulp/pulp-2to3-migration/pull/312" class="external">https://github.com/pulp/pulp-2to3-migration/pull/312</a></p> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=677532021-02-16T18:25:55Zggainey
<ul><li><strong>Status</strong> changed from <i>POST</i> to <i>MODIFIED</i></li></ul><p>Applied in changeset <a class="changeset" title="Removed no-longer-needed pre_migration codepath. Removes part of the changes for #7280. fixes #..." href="https://pulp.plan.io/projects/pulp/repository/pulp-2to3-migration/revisions/c7d0e2dbb416607005d826cfe4a637bd03b0430d">pulp:pulp-2to3-migration|c7d0e2dbb416607005d826cfe4a637bd03b0430d</a>.</p> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=678292021-02-18T19:03:05Zttereshcttereshc@redhat.com
<ul><li><strong>Sprint/Milestone</strong> changed from <i>0.9.0</i> to <i>0.8.0</i></li></ul> Migration Plugin - Issue #8166: Migration fails with ForeignKeyViolation: insert or update on table "pulp_2to3_migration_pulp2erratum" violates foreign key constraint "pulp_2to3_migrationhttps://pulp.plan.io/issues/8166?journal_id=678422021-02-18T20:44:02Zpulpbot
<ul><li><strong>Status</strong> changed from <i>MODIFIED</i> to <i>CLOSED - CURRENTRELEASE</i></li></ul>