[
https://issues.apache.org/jira/browse/AIRAVATA-2350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie resolved AIRAVATA-2350.
---------------------------------------
Resolution: Fixed
Assignee: Marcus Christie
Fixed this and deployed to the Jetstream testing environment.
I verified the fix by creating a USER_RESOURCE_PROFILE in the seagrid test
gateway and the scigap test gateway, producing two rows in
USER_RESOURCE_PROFILE for my user_id='marcus'.
{noformat}
MySQL [master_app_catalog]> select * from USER_RESOURCE_PROFILE where USER_ID =
'marcus';
+---------+---------------------+--------------------------------------+------------+--------------------------------+------------------------+---------------------+
| USER_ID | CREATION_TIME | CS_TOKEN |
GATEWAY_ID | IDENTITY_SERVER_PWD_CRED_TOKEN | IDENTITY_SERVER_TENANT |
UPDATE_TIME |
+---------+---------------------+--------------------------------------+------------+--------------------------------+------------------------+---------------------+
| marcus | 2017-03-29 16:14:16 | fa1839f8-841e-4096-89f0-e44ee75d552b | scigap
| NULL | NULL | NULL
|
| marcus | 2017-03-27 17:57:30 | cf55583a-3381-43b5-bee2-9b4cd11309b3 |
seagrid | NULL | NULL |
2017-03-29 16:08:05 |
+---------+---------------------+--------------------------------------+------------+--------------------------------+------------------------+---------------------+
2 rows in set (0.01 sec)
{noformat}
> USER_RESOURCE_PROFILE DB Primary Key should include the gateway_id
> ------------------------------------------------------------------
>
> Key: AIRAVATA-2350
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2350
> Project: Airavata
> Issue Type: Bug
> Components: Registry API
> Affects Versions: 0.17
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Fix For: 0.17
>
>
> If I recall correctly, the problem that this caused was that a user with the
> same username in two gateways was not able to create a USER_RESOURCE_PROFILE
> in the second gateway because of the PK violation.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
