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
Comment #2
mikeryanIs it possible any content was manually created on the destination site between the rollback and re-import (thus creating nodes with conflicting IDs)?
Comment #3
heddnSeems like perhaps #2 has the greatest chance of being the solution. Without a response for a while there, I'm just guessing.
Comment #4
nojj commentedHi,
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