Duplicate entry for key 'block_content_field__uuid__value'

Problem

Reusing the same layout from the library with existing custom Inline Block causes duplicate entry in database.

How to Reproduce

Add Layout

Add custom block content to section

Add two separate entities with new layout selected

Second entity will fail

Error

Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3cf3c837-5e04-4feb-b446-47b84e058a3f' for key 'block_content_field__uuid__value': INSERT INTO {block_content} (revision_id, type, uuid, langcode) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => basic [:db_insert_placeholder_2] => 3cf3c837-5e04-4feb-b446-47b84e058a3f [:db_insert_placeholder_3] => en ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 847 of /app/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

First commit to issue fork.
Open in Jenkins → Open on Drupal.org →
Core: 9.5.x + Environment: PHP 7.3 & MySQL 5.7
last update almost 2 years ago
9 pass
Status changed to Needs review almost 2 years ago10:18pm 30 June 2023
Open in Jenkins → Open on Drupal.org →
Core: 9.5.x + Environment: PHP 7.3 & MySQL 5.7
last update almost 2 years ago
7 pass, 2 fail
Comment almost 2 years ago →
🇸🇪Sweden marcusml
I've added tests and rebased the current work.

I ran into this issue when saving a layout override with an inline block from the layout library which I included a test for as well.