D10.1 alpha generates "Transaction isolation level" error

Created on 10 May 2023, almost 2 years ago

Problem/Motivation

Drupal 10.1 now sets READ COMMITTED transaction isolation level by default, which generates new error.

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

Steps to reproduce

Add module to Drupal 10.1 alpha and configure. Logging in with module will generate error.

Proposed resolution

Not sure about DB changes being added. For now, would have to manually set isolation level to "REPEATABLE READ". However, this will now generate a warning message.

More info here https://www.drupal.org/node/3264101 β†’ .

πŸ› Bug report
Status

Active

Version

4.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States esch

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

Comments & Activities

Production build 0.71.5 2024