Grouper Users - Open Discussion List

[Shilen Patel <>]

Hi Rahul,

If the upgrade is done and verified, you can just drop those tables.  They are not needed after the legacy attribute migration is done.  But if you want primary keys added, yes Jira please.

Thanks!

— Shilen

From: Rahul Doshi <>
Date: Monday, December 29, 2014 at 10:23 AM
To: "" <>
Subject: [grouper-users] missing primary key

Shilen,

We recently upgraded to grouper 2.2.1 in our test environment with MariaDB Galera Cluster as the backend.  Our DBA’s identified few tables in grouper that doesn’t have primary key and recommended to add primary keys to those tables as deletes in Galera replicated databases are not supported if the table does not have a primary key.  Can primary key be added to below tables in the database upgrade script?  I can open a JIRA if you’d like.

grouper.grouper_attributes_legacy

grouper.grouper_fields_legacy

grouper.grouper_groups_types_legacy

grouper.grouper_types_legacy

Thanks,

Rahul