ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yusaku Sako (JIRA)" <j...@apache.org>
Subject [jira] [Reopened] (AMBARI-17260) Remove CascadeType in ServiceComponentHistoryEntity for ServiceComponentDesiredStateEntity
Date Thu, 16 Jun 2016 22:42:05 GMT

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

Yusaku Sako reopened AMBARI-17260:
----------------------------------

Reverted from trunk and branch-2.4 due to introduction of unit test failures.
See https://builds.apache.org/job/Ambari-trunk-Commit/5088/

> Remove CascadeType in ServiceComponentHistoryEntity for ServiceComponentDesiredStateEntity
> ------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-17260
>                 URL: https://issues.apache.org/jira/browse/AMBARI-17260
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.4.0
>            Reporter: Ajit Kumar
>            Assignee: Ajit Kumar
>             Fix For: 2.4.0
>
>
> Service deletion throws '500: Server Error' due to foreign key constraint violation :
> {code}
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails (`ambaricustom`.`servicecomponent_history`,
CONSTRAINT `FK_sc_history_component_id` FOREIGN KEY (`component_id`) REFERENCES `servicecomponentdesiredstate`
(`id`))
> Error Code: 1451
> Call: DELETE FROM servicecomponentdesiredstate WHERE (id = ?)
> 	bind => [1 parameter bound]
> 	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
> {code}
> Removing CascadeType in ServiceComponentHistoryEntity for ServiceComponentDesiredStateEntity
should fix this.
> Repro steps:
> 1. Deploy HDP-2.4 cluster with Ambari 2.4.0.0 
> 2. Perform Express Upgrade to HDP 2.5
> 3. Try to delete Hive service (after stopping it)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message