MYSQL READ-COMMITTED For this to work correctly, all tables must have a primary key.

Created on 1 May 2023, over 1 year ago
Updated 15 May 2023, over 1 year ago

Problem/Motivation

MYSQL READ-COMMITTED
For this to work correctly, all tables must have a primary key. The following table(s) do not have a primary key: webform_timeout, date_recur__node__field_mydaterecur, poll_vote, user_activity_send, amazon_item_participant, activity_notification_status, regcode_users, user_activity_digest. 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

Active

Version

1.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States SocialNicheGuru

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

Comments & Activities

  • Issue created by @SocialNicheGuru
  • πŸ‡¬πŸ‡§United Kingdom naheemsays

    The only relevant from that is poll_vote.

    However the code suggests it already has a primary key? Look at poll.install:

    'primary key' => array('pid', 'uid', 'hostname'),

  • πŸ‡ΊπŸ‡ΈUnited States SocialNicheGuru

    advpoll removes the primary key.

    Can a primary key be added back to support the function of advpoll?

    /**
    * implements hook_install
    */
    function advpoll_install() {
    // remove primary key lock on poll vote table so that other vote types can be
    // recorded.
    $schema = Database::getConnection()->schema();
    $schema->dropPrimaryKey('poll_vote');
    }

Production build 0.71.5 2024