Tables missing a primary key, required for HA with Galera Cluster

[Philip Stoev]

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_association_ibfk_1` FOREIGN KEY (`JobBinary_id`) REFERENCES `job_binaries` (`id`),
  CONSTRAINT `libs_association_ibfk_2` FOREIGN KEY (`Job_id`) REFERENCES `jobs` (`id`)
) 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_association_ibfk_1` FOREIGN KEY (`JobBinary_id`) REFERENCES `job_binaries` (`id`),
  CONSTRAINT `mains_association_ibfk_2` FOREIGN KEY (`Job_id`) REFERENCES `jobs` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

sahara --version
0.7.3

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/208809

[OpenStack Infra (hudson-openstack)]

Change abandoned by li,chen (<email address hidden>) on branch: master
Review: https://review.openstack.org/208809

[Sergey Reshetnyak (sreshetniak)]

This bug is > 60 days without activity. We are unsetting assignee and milestone and setting status to Incomplete in order to allow its expiry in 60 days.

If the bug is still valid, then update the bug status.