Status Report Error: Transaction isolation level on D10

Created on 2 November 2023, about 1 year ago
Updated 11 April 2024, 8 months ago

Problem/Motivation

For this to work correctly, all tables must have a primary key. The following table(s) do not have a primary key: coh_usage, acquia_perz_push_export_tracking, acquia_contenthub_publisher_export_tracking. See the setting MySQL transaction isolation level page for more information.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Fixed

Version

4.1

Component

Code

Created by

🇮🇳India chaithanya.m

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

Comments & Activities

  • Issue created by @chaithanya.m
  • Status changed to Needs review about 1 year ago
  • Open on Drupal.org →
    Core: 10.1.4 + Environment: PHP 8.1 & MySQL 5.7
    last update about 1 year ago
    Waiting for branch to pass
  • Status changed to Needs work about 1 year ago
  • 🇧🇪Belgium BramDriesen Belgium 🇧🇪

    Code review:

    1. +++ b/acquia_perz/modules/acquia_perz_push/acquia_perz_push.install
      @@ -60,3 +60,13 @@ function acquia_perz_push_schema() {
      +  $new_primary_keys = ['entity_id'];
      +  $database->schema()->addPrimaryKey('acquia_perz_push_export_tracking', $new_primary_keys);
      

      Move the array into the function, no need to cast it to a variable for single use.

    2. +++ b/acquia_perz/modules/acquia_perz_push/acquia_perz_push.install
      @@ -60,3 +60,13 @@ function acquia_perz_push_schema() {
      \ No newline at end of file
      

      Missing newline

  • 🇨🇦Canada scor Toronto

    the primary key cannot be entity_uuid because there may be multiple rows with the same entity_uuid but different langcode. we need to introduce a new auto-increment id column.

  • Status changed to Fixed 8 months ago
  • 🇨🇦Canada scor Toronto

    fixed in 4.1.6

  • Automatically closed - issue fixed for 2 weeks with no activity.

Production build 0.71.5 2024