You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Hadoop QA (JIRA)" <ji...@apache.org> on 2016/06/22 20:59:16 UTC
[jira] [Commented] (AMBARI-17371) Unable To Delete A Service After
Upgrade Due To Foreign Key Violation
[ https://issues.apache.org/jira/browse/AMBARI-17371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15345158#comment-15345158 ]
Hadoop QA commented on AMBARI-17371:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12812515/AMBARI-17371.patch
against trunk revision .
{color:green}+1 @author{color}. The patch does not contain any @author tags.
{color:green}+1 tests included{color}. The patch appears to include 1 new or modified test files.
{color:green}+1 javac{color}. The applied patch does not increase the total number of javac compiler warnings.
{color:green}+1 release audit{color}. The applied patch does not increase the total number of release audit warnings.
{color:red}-1 core tests{color}. The patch failed these unit tests in ambari-server:
org.apache.ambari.server.controller.internal.ConfigGroupResourceProviderTest
Test results: https://builds.apache.org/job/Ambari-trunk-test-patch/7480//testReport/
Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/7480//console
This message is automatically generated.
> Unable To Delete A Service After Upgrade Due To Foreign Key Violation
> ---------------------------------------------------------------------
>
> Key: AMBARI-17371
> URL: https://issues.apache.org/jira/browse/AMBARI-17371
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.4.0
> Reporter: Jonathan Hurley
> Assignee: Jonathan Hurley
> Priority: Blocker
> Fix For: 2.4.0
>
> Attachments: AMBARI-17371.patch
>
>
> # Deploy HDP-2.4.2 cluster with Ambari 2.4.0.0 (secure, non-HA cluster, Ambari DB - MySQL)
> # Perform Express Upgrade to 2.5.0.0-723
> # Try to delete Hive service (after stopping it)
> {code}
> 14 Jun 2016 07:30:06,144 INFO [ambari-client-thread-31] ClusterImpl:2217 - Deleting service for cluster, clusterName=cl1, serviceName=HIVE
> 14 Jun 2016 07:30:06,145 INFO [ambari-client-thread-31] ServiceImpl:610 - Deleting all components for service, clusterName=cl1, serviceName=HIVE
> 14 Jun 2016 07:30:06,145 INFO [ambari-client-thread-31] ServiceComponentImpl:712 - Deleting all servicecomponenthosts for component, clusterName=cl1, serviceName=HIVE, componentName=HIVE_SERVER, recoveryEnabled=false
> 14 Jun 2016 07:30:06,146 INFO [ambari-client-thread-31] ServiceComponentImpl:712 - Deleting all servicecomponenthosts for component, clusterName=cl1, serviceName=HIVE, componentName=HIVE_METASTORE, recoveryEnabled=false
> 14 Jun 2016 07:30:06,146 INFO [ambari-client-thread-31] ServiceComponentImpl:712 - Deleting all servicecomponenthosts for component, clusterName=cl1, serviceName=HIVE, componentName=HIVE_CLIENT, recoveryEnabled=false
> 14 Jun 2016 07:30:06,190 INFO [ambari-client-thread-31] ServiceComponentImpl:712 - Deleting all servicecomponenthosts for component, clusterName=cl1, serviceName=HIVE, componentName=HCAT, recoveryEnabled=false
> 14 Jun 2016 07:30:06,215 ERROR [ambari-client-thread-31] 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: 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)
> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902)
> 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)
> at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)
> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1845)
> at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4300)
> at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5592)
> at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:456)
> at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874)
> at org.eclipse.persistence.internal.jpa.QueryImpl.performPreQueryFlush(QueryImpl.java:967)
> at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:207)
> at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:521)
> at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
> at org.apache.ambari.server.orm.dao.HostDAO.findByName(HostDAO.java:60)
> at org.apache.ambari.server.orm.AmbariLocalSessionInterceptor.invoke(AmbariLocalSessionInterceptor.java:53)
> at org.apache.ambari.server.orm.dao.HostComponentStateDAO.remove(HostComponentStateDAO.java:180)
> at org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:118)
> at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.removeEntities(ServiceComponentHostImpl.java:1625)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)