Problem/Motivation
Encountering an Integrity Constraint violation error when editing a node with Workflow and Workflow Access Enabled:
Steps to reproduce
1. Enable both Workflow and Workflow Access as normal
2. Setup Workflow Access on the Workflow
3. Add/edit a node with the Workflow -> Should throw this error:
Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '234188-102-workflow_access-en' for key 'node_access.PRIMARY': INSERT INTO "node_access" ("nid", "langcode", "fallback", "realm", "gid", "grant_view", "grant_update", "grant_delete") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15), (:db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31), (:db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39), (:db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47); Array ( [:db_insert_placeholder_0] => 234188 [:db_insert_placeholder_1] => en [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => workflow_access_owner [:db_insert_placeholder_4] => 3150 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 234188 [:db_insert_placeholder_9] => en [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => workflow_access [:db_insert_placeholder_12] => 100 [:db_insert_placeholder_13] => 1 [:db_insert_placeholder_14] => 0 [:db_insert_placeholder_15] => 0 [:db_insert_placeholder_16] => 234188 [:db_insert_placeholder_17] => en [:db_insert_placeholder_18] => 1 [:db_insert_placeholder_19] => workflow_access [:db_insert_placeholder_20] => 101 [:db_insert_placeholder_21] => 1 [:db_insert_placeholder_22] => 0 [:db_insert_placeholder_23] => 0 [:db_insert_placeholder_24] => 234188 [:db_insert_placeholder_25] => en [:db_insert_placeholder_26] => 1 [:db_insert_placeholder_27] => workflow_access [:db_insert_placeholder_28] => 102 [:db_insert_placeholder_29] => 1 [:db_insert_placeholder_30] => 1 [:db_insert_placeholder_31] => 1 [:db_insert_placeholder_32] => 234188 [:db_insert_placeholder_33] => en [:db_insert_placeholder_34] => 1 [:db_insert_placeholder_35] => workflow_access [:db_insert_placeholder_36] => 102 [:db_insert_placeholder_37] => 1 [:db_insert_placeholder_38] => 0 [:db_insert_placeholder_39] => 0 [:db_insert_placeholder_40] => 234188 [:db_insert_placeholder_41] => en [:db_insert_placeholder_42] => 1 [:db_insert_placeholder_43] => workflow_access [:db_insert_placeholder_44] => 103 [:db_insert_placeholder_45] => 1 [:db_insert_placeholder_46] => 1 [:db_insert_placeholder_47] => 0 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 817 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).