You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Dmytro Grinenko (JIRA)" <ji...@apache.org> on 2018/01/02 15:27:00 UTC

[jira] [Updated] (AMBARI-22690) Registering existing hdp version failed with sql exception

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

Dmytro Grinenko updated AMBARI-22690:
-------------------------------------
    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

Committed

   29ffc7ef99..4d3d57b64a  branch-2.6 -> branch-2.6
   aa5b0fe762..a95759d2fe  trunk -> trunk

> Registering existing hdp version failed with sql exception
> ----------------------------------------------------------
>
>                 Key: AMBARI-22690
>                 URL: https://issues.apache.org/jira/browse/AMBARI-22690
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.6.2
>            Reporter: Dmytro Grinenko
>            Assignee: Dmytro Grinenko
>            Priority: Critical
>             Fix For: 2.6.2
>
>         Attachments: AMBARI-22690.branch-2.6.patch
>
>
> While trying to register existing HDP version below sql exception were noticed. 
> STR:
> - Register HDP version 2.6.4 via manage versions screen of Ambari.
> - Try re-registering the same version again. Below exception is thrown.
> {code}
> ERROR [ambari-client-thread-3696] AmbariJpaLocalTxnInterceptor:180 - [DETAILED ERROR] Rollback reason:
> Local Exception Stack:
> 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_repo_version_stack_id"
> Error Code: 0
> Call: INSERT INTO repo_version (repo_version_id, display_name, hidden, legacy, repositories, resolved, repo_type, version, version_url, version_xml, version_xsd, parent_id, stack_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
>         bind => [13 parameters bound]
>         at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1620)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
>         at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:149)
> {code}



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