Contrib.social

Integrity constraint violation during INSERT INTO vgwort_entity_registration

Open on Drupal.org →
Created on 28 November 2023, about 1 year ago
Updated 6 December 2023, about 1 year ago

Problem/Motivation

We see following errors in our logs from VG Wort module.

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'node-<NODE ID>-<COUNTER ID>' for key 'vgwort_entity_registration.PRIMARY': INSERT INTO "vgwort_entity_registration" ("entity_type", "entity_id", "counter_id", "job_id") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array
(
    [:db_insert_placeholder_0] => node
    [:db_insert_placeholder_1] => <NODE ID>
    [:db_insert_placeholder_2] => <COUNTER ID>
    [:db_insert_placeholder_3] => <JOB ID>
)
 in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 50 of /var/www/html/docroot/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Seems to happen when scheduler cron is running.

Steps to reproduce

@alexpott: Maybe we could have a look into our Sentry logs, if you need more information how we could reproduce this issue.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Fixed

Version

2.0

Component

Code

Created by

🇩🇪Germany IT-Cru Munich

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Not all content is available!

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

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024