[jira] [Resolved] (AMBARI-21808) Create registry failing with unique constraint violation after a failed registry request

["Madhuvanthi Radhakrishnan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-21808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Madhuvanthi Radhakrishnan resolved AMBARI-21808.
------------------------------------------------
    Resolution: Fixed

> Create registry failing with unique constraint violation after a failed registry request
> ----------------------------------------------------------------------------------------
>
>                 Key: AMBARI-21808
>                 URL: https://issues.apache.org/jira/browse/AMBARI-21808
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>            Reporter: Madhuvanthi Radhakrishnan
>            Assignee: Madhuvanthi Radhakrishnan
>             Fix For: 3.0.0
>
>
>  Aug 2017 20:59:12,903 ERROR [ambari-client-thread-131] ContainerResponse:419 - The RuntimeException could not be mapped to a response, re-throwing to the HTTP container
> javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "uq_registry_name"
> Error Code: 0
> Call: INSERT INTO registries (id, registry_name, registry_type, registry_uri) VALUES (?, ?, ?, ?)
>         bind => [4 parameters bound]
> Issue - Database entry is made before validating the url for its existence.
> Fix - Add url validation check before calling addRegistries functionality



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)