Rollback does not remove data from node table [#2831923]

I ran drush migrate-rollback --all to rollback my migration. Once It finished I tried to re-migrate but I am getting the following error for every node:

 [error]  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '484' for key 'PRIMARY': INSERT INTO {node} (nid, vid, type, uuid, langcode) VALUES (: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] => 484
    [:db_insert_placeholder_1] => 484
    [:db_insert_placeholder_2] => post
    [:db_insert_placeholder_3] => 968fa3f4-0c02-44ec-a5b3-f4a4bdf91c0f
    [:db_insert_placeholder_4] => und
)
 (/var/www/mysite/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:770)

I'm guessing somehow during the migration rollback it doesn't remove rows from the node table.

Comments

Comment #1

30 November 2016 at 21:15

albertski created an issue. See original summary.

Comment #2

albertski CreditAttribution: albertski at Xeno Media, Inc. commented 30 November 2016 at 22:17

Actually just tried to do a drush migrate-import --update instead of rollingback and I got the same errors.

Comment #3

30 November 2016 at 22:17

Version:

8.2.x-dev

» 8.3.x-dev

Drupal 8.2.6 was released on February 1, 2017 and is the final full bugfix release for the Drupal 8.2.x series. Drupal 8.2.x will not receive any further development aside from critical and security fixes. Sites should prepare to update to 8.3.0 on April 5, 2017. (Drupal 8.3.0-alpha1 is available for testing.)

Bug reports should be targeted against the 8.3.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.4.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Comment #4

mikeryan

he/him

English

Murphysboro, IL, USA

CreditAttribution: mikeryan as a volunteer and at Virtuoso Performance commented 6 June 2017 at 21:42

Status:

Active

» Postponed (maintainer needs more info)

Is there any more info you can provide? I have not seen any problem with rolling back and reimporting nodes. Are you mapping nid in your node migration (preserving a specific ID)?

Comment #5

6 June 2017 at 21:42

Version:

8.3.x-dev

» 8.4.x-dev

Drupal 8.3.6 was released on August 2, 2017 and is the final full bugfix release for the Drupal 8.3.x series. Drupal 8.3.x will not receive any further development aside from critical and security fixes. Sites should prepare to update to 8.4.0 on October 4, 2017. (Drupal 8.4.0-alpha1 is available for testing.)

Bug reports should be targeted against the 8.4.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.5.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.