Add primary key to occurrence tables
>>> [!note] Migrated issue
<!-- Drupal.org comment -->
<!-- Migrated from issue #3205682. -->
Reported by: [akalata](https://www.drupal.org/user/498926)
Related to !23 !35
>>>
<h3 id="summary-problem-motivation">Problem/Motivation</h3>
<p>While attempting to deploy a site onto new infrastructure, we received the following message:</p>
<blockquote><p>[error] Drupal\\Core\\Database\\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 3098 The table does not comply with the requirements by an external plugin.: INSERT INTO {date_recur__entityType__fieldName}</p></blockquote>
<p>We believe that this is due to the absence of a primary key, which is required when using MySQL's group replication.</p>
<h4 id="summary-steps-reproduce">Steps to reproduce</h4>
<p>Install in an environment where MySQL's group replication is configured.</p>
<h3 id="summary-proposed-resolution">Proposed resolution</h3>
<p>Specify primary keys for the precreated date tables.</p>
issue