Tables missing a primary key, required for HA with Galera Cluster
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Sahara |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
Two tables from the sahara scheme are missing a primary key. A primary key is strongly recommended when using Galera Cluster for HA.
CREATE TABLE `libs_association` (
`Job_id` varchar(36) DEFAULT NULL,
`JobBinary_id` varchar(36) DEFAULT NULL,
KEY `JobBinary_id` (`JobBinary_id`),
KEY `Job_id` (`Job_id`),
CONSTRAINT `libs_associati
CONSTRAINT `libs_associati
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `mains_association` (
`Job_id` varchar(36) DEFAULT NULL,
`JobBinary_id` varchar(36) DEFAULT NULL,
KEY `JobBinary_id` (`JobBinary_id`),
KEY `Job_id` (`Job_id`),
CONSTRAINT `mains_
CONSTRAINT `mains_
) ENGINE=InnoDB DEFAULT CHARSET=utf8
sahara --version
0.7.3
Changed in sahara: | |
assignee: | nobody → li,chen (chen-li) |
Changed in sahara: | |
assignee: | li,chen (chen-li) → nobody |
status: | In Progress → Confirmed |
Changed in sahara: | |
status: | Incomplete → Confirmed |
Fix proposed to branch: master /review. openstack. org/208809
Review: https:/