Contrib.social

Integrity constraint violation in drupal_session_regenerate()

Open on Drupal.org →
Created on 22 October 2021, over 3 years ago
Updated 4 December 2024, 4 months ago

Hello,

I've installed this module on a site and now, after login, sometimes and only on chrome, users get an error message :

PDOException : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'PslLOHZdZSX3Nj4SaUw5OXD-djNkDIiVNqV8WeWWSl4-4ZL9y_sSJ6gIBGcoq_HV' for key 'PRIMARY': UPDATE {sessions} SET sid=:db_update_placeholder_0, ssid=:db_update_placeholder_1 WHERE (ssid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => PslLOHZdZSX3Nj4SaUw5OXD-djNkDIiVNqV8WeWWSl4 [:db_update_placeholder_1] => 4ZL9y_sSJ6gIBGcoq_HVaxEoF2c2bgTREkY3RsYqhPc [:db_condition_placeholder_0] => CnqmYV0VYl3rYHaUakMMf9uZ_42ocR8ubzVSy-sCmKU ) in drupal_session_regenerate() (ligne 431 in includes/session.inc).

I'm not able to find a reason. It not depend of the role, nor of the user.

Has someone already see this problem ?

Thanks

🐛 Bug report
Status

Active

Version

2.0

Component

Code

Created by

marieAscomedia

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

Comments & Activities

Not all content is available!

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

  • Comment 4 months ago →
    🇸🇰Slovakia sano

    I see the same thing in Chrome. Starting as an anonymous user, after putting a product into cart, and advancing to the page where user can continue as anonymous, log in, or register, the system crashes when the user chooses to log in, or register. I do not see this issue in Safari.

    Not sure why this bug was filled in this module though, as I do not have the Commerce Checkout Redirect module installed on my system.

    PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'aHjRUa71IYdjqpwTo8WkYV1S0M2oThJfUmPqAhy54Qk-5ezhmn0AgWxIaIOEt...' for key 'PRIMARY': UPDATE {sessions} SET sid=:db_update_placeholder_0, ssid=:db_update_placeholder_1 WHERE (ssid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => aHjRUa71IYdjqpwTo8WkYV1S0M2oThJfUmPqAhy54Qk [:db_update_placeholder_1] => 5ezhmn0AgWxIaIOEtkdqiC0TrOuWaFl8IK6IXzmnYI4 [:db_condition_placeholder_0] => JD_UuAR3rPUtDflVuR55K7VcgQFrzoMJNAtJApMh6zA ) in drupal_session_regenerate() (line 434 of .../includes/session.inc).

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024