Sometimes paragraphs doesn't delete old paragraphs becoming in ERROR: duplicated key value

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "paragraphs_item__paragraph_field__uuid__value__key" DETAIL: Key (uuid)=(1e7f7a47-85e2-4a84-8962-9813faec0ac2) already exists.: INSERT INTO paragraphs_item (revision_id, type, uuid, langcode) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( ) in Drupal\Core\Database\Connection->handleQueryException() (line 673 of /var/www/arenabolaget.se/docroot/web/core/lib/Drupal/Core/Database/Connection.php).

Comments

killua99 created an issue. See original summary.

miro_dietiker’s picture

miro_dietiker
Location Switzerland
commented
Status: Active » Postponed (maintainer needs more info)

Please describe step by step how to reproduce such a situation.
From what you describe, i can not fully understand why a paragraph that is not deleted (staying as stale item) will result in any conflict. Paragraphs should just create a new one when new ones are added again.

dimr’s picture

dimr commented

Are you using Postgresql? I think that this error can be related with this other issue:
https://www.drupal.org/node/2918164