After applying the update to address deadlocks found in https://www.drupal.org/project/sqlsrv/issues/3106869, I began occasionally seeing "Violation of PRIMARY KEY constraint" errors. After chatting with @Beakerboy in that issue, he supplied an update (see https://www.drupal.org/project/sqlsrv/issues/3106869#comment-13558073) to Upsert.php which appears to have addressed this issue. I will shortly be creating a patch for that supplied code and attaching here.

Comments

afireintheattic created an issue. See original summary.

afireintheattic’s picture

Attaching the aforementioned patch here.

beakerboy’s picture

Status: Active » Reviewed & tested by the community

When you supply a patch, please change the status to ‘Needs Review’.

I’ll merge this into the GitLab repo shortly.

  • Beakerboy committed 1da800b on 8.x-1.x
    Issue #3129336 by afireintheattic, Beakerboy: Prevent "Violation of...
beakerboy’s picture

Version: 8.x-1.0-rc5 » 8.x-1.x-dev
Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.