Step by step:

1. We have upgrade_d7_node_content_name 88 total, 88 imported, 0 unprocessed after first full import (drush mi --all)
2. drush mr upgrade_d7_node_content_name
3. Now we have upgrade_d7_node_content_name 88 total, 0 imported, 88 unprocessed
so far, so good...
4. drush mi upgrade_d7_node_content_name

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '121808' for key 'PRIMARY': INSERT INTO {node} (nid, vid, t
(:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array
(
    [:db_insert_placeholder_0] => 121808
    [:db_insert_placeholder_1] => 22936
    [:db_insert_placeholder_2] => content_name
    [:db_insert_placeholder_3] => uuid here
    [:db_insert_placeholder_4] => und
)
 in Drupal\Core\Database\Connection->handleQueryException() (line 668 of /srv/site_name/core/lib/Drupal/Core/Database/Connection.php).
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '121808' for key 'PRIMARY': INSERT INTO {node} (nid, vid, type, uuid, langcode) VALUES (:db_insert_placeholder_0, :db_i
:db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array
(
    [:db_insert_placeholder_0] => 121808
    [:db_insert_placeholder_1] => 22936
    [:db_insert_placeholder_2] => content_name
    [:db_insert_placeholder_3] =>  uuid here
    [:db_insert_placeholder_4] => und
)
 (/srv/site_name/modules/deploy/multiversion/src/Entity/Storage/ContentEntityStorageTrait.php:152)

x 88...

5. drush ms
6. 88 total, 0 imported, 0 unprocessed

-------------------------------------------------------------------------------------------------

Results:

0 nodes of that content type in /admin/content

SELECT * FROM site_database.node where nid="any of those 88 failed nids";
and still there

Comments

ghyjek created an issue. See original summary.

mikeryan’s picture

Title: Integrity constraint violation: 1062 Duplicate entry after rollback » Duplicate entry error after rollback
Category: Bug report » Support request
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)
Issue tags: -rollback duplicate error import mi mr

Is it possible any content was manually created on the destination site between the rollback and re-import (thus creating nodes with conflicting IDs)?

heddn’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Seems like perhaps #2 has the greatest chance of being the solution. Without a response for a while there, I'm just guessing.

nojj’s picture

Hi,
I have the exact that problem.
I added some new content on the Drupal 9 side and have problems to load new content from the Drupal 7 side and get these errors.
How can that be achieved?
Thanks in advance

nojj