flarum / flarum/issue-archive

Primary Key required on tables

Open
#49 4 comments 1 reaction 0 assignees View on GitHub
type/infrastructure type/performance
Dominant language
No language data
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

## Bug Report

**Current Behavior**
When using a clustered SQL environment, installation fails due to missing primary keys on the database tables.
```
Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
```

This issue seems to be present on any percona and clustered database

CC : @luceos

Contributor guide

Open the contributing guide

Research direction

Start by reproducing installation in a clustered or Percona SQL environment with sql_require_primary_key enabled, then inspect the database table creation used during installation. Done means installation completes without the missing-primary-key error and every created table satisfies the environment's primary-key requirement.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.