ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sumit Mohanty (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AMBARI-14009) Express Upgrade - SQL Exception while trying to DeregisterVersion (after install packages step failed due to invalid repo)
Date Mon, 23 Nov 2015 15:20:11 GMT

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

Sumit Mohanty updated AMBARI-14009:
-----------------------------------
    Environment:     (was: OS - CentOS7

*+Ambari.properties+*

{code}

# Copyright 2011 The Apache Software Foundation
#
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

#
#Fri Nov 20 18:46:02 UTC 2015
server.jdbc.rca.driver=oracle.jdbc.driver.OracleDriver
jdk1.7.dest-file=jdk-7u67-linux-x64.tar.gz
server.jdbc.rca.url=jdbc:oracle:thin:@172.22.106.158:1521/XE
agent.package.install.task.timeout=1800
server.connection.max.idle.millis=900000
bootstrap.script=/usr/lib/python2.6/site-packages/ambari_server/bootstrap.py
server.version.file=/var/lib/ambari-server/resources/version
server.jdbc.properties.oracle.net.CONNECT_TIMEOUT=2000
server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat
api.authenticate=true
http.strict-transport-security=max-age=31536000
server.jdbc.driver=oracle.jdbc.driver.OracleDriver
server.persistence.type=remote
jdk1.8.jcpol-url=http://public-repo-1.hortonworks.com/ARTIFACTS/jce_policy-8.zip
jdk1.8.dest-file=jdk-8u60-linux-x64.tar.gz
rolling.upgrade.skip.packages.prefixes=
common.services.path=/var/lib/ambari-server/resources/common-services
http.x-frame-options=DENY
webapp.dir=/usr/lib/ambari-server/web
jce.download.supported=true
agent.threadpool.size.max=25
jdk1.8.re=(jdk.*)/jre
ambari.python.wrap=ambari-python-wrap
ambari-server.user=root
server.jdbc.properties.oracle.net.READ_TIMEOUT=2000
jdk1.8.url=http://public-repo-1.hortonworks.com/ARTIFACTS/jdk-8u60-linux-x64.tar.gz
jdk1.7.url=http://public-repo-1.hortonworks.com/ARTIFACTS/jdk-7u67-linux-x64.tar.gz
server.jdbc.user.name=ambaricustomuser
server.jdbc.port=1521
server.os_family=redhat7
java.home=/usr/lib/jvm/java-1.7.0-openjdk
user.inactivity.timeout.default=0
java.releases=jdk1.8,jdk1.7
server.jdbc.hostname=172.22.106.158
skip.service.checks=true
shared.resources.dir=/usr/lib/ambari-server/lib/ambari_commons/resources
server.jdbc.properties.oracle.jdbc.ReadTimeout=8000
jdk.download.supported=true
recommendations.dir=/var/run/ambari-server/stack-recommendations
ulimit.open.files=10000
rolling.upgrade.min.stack=HDP-2.2
jdk1.8.desc=Oracle JDK 1.8 + Java Cryptography Extension (JCE) Policy Files 8
server.tmp.dir=/var/lib/ambari-server/data/tmp
server.os_type=centos7
views.http.strict-transport-security=max-age=31536000
resources.dir=/var/lib/ambari-server/resources
custom.action.definitions=/var/lib/ambari-server/resources/custom_action_definitions
views.http.x-frame-options=SAMEORIGIN
views.request.connect.timeout.millis=5000
jdk1.7.re=(jdk.*)/jre
server.execution.scheduler.maxDbConnections=5
jdk1.7.desc=Oracle JDK 1.7 + Java Cryptography Extension (JCE) Policy Files 7
bootstrap.setup_agent.script=/usr/lib/python2.6/site-packages/ambari_server/setupAgent.py
jdk1.8.jcpol-file=jce_policy-8.zip
rolling.upgrade.max.stack=
server.http.session.inactive_timeout=1800
jdk1.7.jcpol-file=UnlimitedJCEPolicyJDK7.zip
server.execution.scheduler.misfire.toleration.minutes=480
security.server.keys_dir=/var/lib/ambari-server/keys
stackadvisor.script=/var/lib/ambari-server/resources/scripts/stack_advisor.py
server.jdbc.rca.user.name=ambaricustomuser
server.execution.scheduler.maxThreads=5
metadata.path=/var/lib/ambari-server/resources/stacks
server.jdbc.url=jdbc:oracle:thin:@172.22.106.158:1521/XE
server.fqdn.service.url=http://169.254.169.254/latest/meta-data/public-hostname
views.http.x-xss-protection=1; mode=block
bootstrap.dir=/var/run/ambari-server/bootstrap
jdk1.7.home=/usr/jdk64/
kerberos.keytab.cache.dir=/var/lib/ambari-server/data/cache
jdk1.8.home=/usr/jdk64/
user.inactivity.timeout.role.readonly.default=0
http.x-xss-protection=1; mode=block
agent.task.timeout=900
client.threadpool.size.max=25
jdk1.7.jcpol-url=http://public-repo-1.hortonworks.com/ARTIFACTS/UnlimitedJCEPolicyJDK7.zip
server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat
server.execution.scheduler.isClustered=false
server.stages.parallel=true
views.request.read.timeout.millis=10000
server.jdbc.database=oracle
server.jdbc.database_name=XE
{code})

> Express Upgrade - SQL Exception while trying to DeregisterVersion (after install packages
step failed due to invalid repo)
> --------------------------------------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-14009
>                 URL: https://issues.apache.org/jira/browse/AMBARI-14009
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.2.0
>            Reporter: Pankaj Singh
>            Priority: Critical
>              Labels: upgrade
>
> Problem :
> *+Steps :+*
> * Through Manage Versions add a new HDP repo e.g. http://s3.amazonaws.com/dev.hortonworks.com/HDP/centos7/2.x/updates/2.3.4.0
> * Since i was sure this repo will exist so skipped repository check
> * executed install packages.
> * After it was completed, Installed count was 0 and Not Installed Count was 5
> * Went to the *Manage Version* to modify the repo location. http://s3.amazonaws.com/dev.hortonworks.com/HDP/centos7/2.x/BUILDS/2.3.4.0-3305
> *   Since the save action failed with exception "Version update error"
> * Pressed on cancel and then DeRegister the Version, which failed with error
> *+ambari-server log snapshot+*
> look at below logs for sqlException
> {code}
> 21 Nov 2015 22:57:30,978 ERROR [qtp-client-1042] AmbariManagementControllerImpl:3687
- Could not access base url . http://s3.amazonaws.com/dev.hortonworks.com/HDP/centos7/2.x/updates/2.3.4.0
. Server returned HTTP response code: 403 for URL: http://s3.amazonaws.com/dev.hortonworks.com/HDP/centos7/2.x/updates/2.3.4.0/repodata/repomd.xml
> 21 Nov 2015 22:57:59,348  WARN [pool-4-thread-1] DistributeRepositoriesActionListener:106
- Distribute repositories did not complete, will set all INSTALLING versions for host pankaj-upgrade-eu-4.novalocal
to INSTALL_FAILED.
> 21 Nov 2015 22:58:06,298  WARN [pool-4-thread-1] DistributeRepositoriesActionListener:106
- Distribute repositories did not complete, will set all INSTALLING versions for host pankaj-upgrade-eu-3.novalocal
to INSTALL_FAILED.
> 21 Nov 2015 22:58:07,538  WARN [pool-4-thread-1] DistributeRepositoriesActionListener:106
- Distribute repositories did not complete, will set all INSTALLING versions for host pankaj-upgrade-eu-1.novalocal
to INSTALL_FAILED.
> 21 Nov 2015 22:58:09,346  WARN [pool-4-thread-1] DistributeRepositoriesActionListener:106
- Distribute repositories did not complete, will set all INSTALLING versions for host pankaj-upgrade-eu-5.novalocal
to INSTALL_FAILED.
> 21 Nov 2015 22:58:10,256  WARN [pool-4-thread-1] DistributeRepositoriesActionListener:106
- Distribute repositories did not complete, will set all INSTALLING versions for host pankaj-upgrade-eu-2.novalocal
to INSTALL_FAILED.
> 21 Nov 2015 22:58:54,618 ERROR [qtp-client-25] AbstractResourceProvider:338 - Caught
AmbariException when modifying a resource
> org.apache.ambari.server.AmbariException: Upgrade pack can't be changed for repository
version which has a state of INSTALL_FAILED on cluster cl1
> 	at org.apache.ambari.server.controller.internal.RepositoryVersionResourceProvider$5.invoke(RepositoryVersionResourceProvider.java:261)
> 	at org.apache.ambari.server.controller.internal.RepositoryVersionResourceProvider$5.invoke(RepositoryVersionResourceProvider.java:235)
> 	at org.apache.ambari.server.controller.internal.AbstractResourceProvider.invokeWithRetry(AbstractResourceProvider.java:450)
> 	at org.apache.ambari.server.controller.internal.AbstractResourceProvider.modifyResources(AbstractResourceProvider.java:331)
> 	at org.apache.ambari.server.controller.internal.RepositoryVersionResourceProvider.updateResources(RepositoryVersionResourceProvider.java:235)
> 	at org.apache.ambari.server.controller.internal.ClusterControllerImpl.updateResources(ClusterControllerImpl.java:310)
> 	at org.apache.ambari.server.api.services.persistence.PersistenceManagerImpl.update(PersistenceManagerImpl.java:104)
> 	at org.apache.ambari.server.api.handlers.UpdateHandler.persist(UpdateHandler.java:42)
> 	at org.apache.ambari.server.api.handlers.BaseManagementHandler.handleRequest(BaseManagementHandler.java:72)
> 	at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:106)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:75)
> 	at org.apache.ambari.server.api.services.RepositoryVersionService.updateRepositoryVersion(RepositoryVersionService.java:130)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	……
> 21 Nov 2015 22:59:53,301 ERROR [qtp-client-25] AmbariJpaLocalTxnInterceptor:114 - [DETAILED
ERROR] Rollback reason:
> Local Exception Stack:
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity
constraint (AMBARICUSTOMUSER.FK_CLUSTER_VERSION_REPOVERS_ID) violated - child record found
> Error Code: 2292
> Call: DELETE FROM repo_version WHERE (repo_version_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:900)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
> 	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:1836)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4244)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5594)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.acquireWriteLocks(UnitOfWorkImpl.java:1646)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransactionAfterWriteChanges(UnitOfWorkImpl.java:1614)
> 	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:284)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)
> 	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:132)
> 	at org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:91)
> 	at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
> 	at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
> 	at org.apache.ambari.server.orm.dao.RepositoryVersionDAO$$EnhancerByGuice$$18a36950.remove(<generated>)
> 	at org.apache.ambari.server.controller.internal.RepositoryVersionResourceProvider.deleteResources(RepositoryVersionResourceProvider.java:333)
> 	at org.apache.ambari.server.controller.internal.ClusterControllerImpl.deleteResources(ClusterControllerImpl.java:330)
> 	at org.apache.ambari.server.api.services.persistence.PersistenceManagerImpl.delete(PersistenceManagerImpl.java:111)
> 	at org.apache.ambari.server.api.handlers.DeleteHandler.persist(DeleteHandler.java:44)
> 	at org.apache.ambari.server.api.handlers.BaseManagementHandler.handleRequest(BaseManagementHandler.java:72)
> 	at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:106)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:75)
> 	at org.apache.ambari.server.api.services.RepositoryVersionService.deleteRepositoryVersion(RepositoryVersionService.java:114)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	…..
> Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint
(AMBARICUSTOMUSER.FK_CLUSTER_VERSION_REPOVERS_ID) violated - child record found
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
> 	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
> 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
> 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
> 	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
> 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
> 	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
> 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
> 	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)
> 	... 108 more
> 21 Nov 2015 22:59:53,304 ERROR [qtp-client-25] AmbariJpaLocalTxnInterceptor:122 - [DETAILED
ERROR] Internal exception (1) :
> java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AMBARICUSTOMUSER.FK_CLUSTER_VERSION_REPOVERS_ID)
violated - child record found
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
> 	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
> 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
> 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
> 	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
> 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
> 	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
> 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
> 	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
> 	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:1836)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4244)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5594)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.acquireWriteLocks(UnitOfWorkImpl.java:1646)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransactionAfterWriteChanges(UnitOfWorkImpl.java:1614)
> 	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:284)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)
> 	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:132)
> 	at org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:91)
> 	at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
> 	at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
> 	at org.apache.ambari.server.orm.dao.RepositoryVersionDAO$$EnhancerByGuice$$18a36950.remove(<generated>)
> 	at org.apache.ambari.server.controller.internal.RepositoryVersionResourceProvider.deleteResources(RepositoryVersionResourceProvider.java:333)
> 	at org.apache.ambari.server.controller.internal.ClusterControllerImpl.deleteResources(ClusterControllerImpl.java:330)
> 	at org.apache.ambari.server.api.services.persistence.PersistenceManagerImpl.delete(PersistenceManagerImpl.java:111)
> 	at org.apache.ambari.server.api.handlers.DeleteHandler.persist(DeleteHandler.java:44)
> 	at org.apache.ambari.server.api.handlers.BaseManagementHandler.handleRequest(BaseManagementHandler.java:72)
> 	at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:106)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:75)
> 	
> 	
> 21 Nov 2015 22:59:53,309  WARN [qtp-client-25] ServletHandler:563 - /api/v1/stacks/HDP/versions/2.3/repository_versions/52
> javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence
Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity
constraint (AMBARICUSTOMUSER.FK_CLUSTER_VERSION_REPOVERS_ID) violated - child record found
> Error Code: 2292
> Call: DELETE FROM repo_version WHERE (repo_version_id = ?)
> 	bind => [1 parameter bound]
> 	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
> 	at org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:91)
> 	at org.apache.ambari.server.controller.internal.RepositoryVersionResourceProvider.deleteResources(RepositoryVersionResourceProvider.java:333)
> 	at org.apache.ambari.server.controller.internal.ClusterControllerImpl.deleteResources(ClusterControllerImpl.java:330)
> 	at org.apache.ambari.server.api.services.persistence.PersistenceManagerImpl.delete(PersistenceManagerImpl.java:111)
> 	at org.apache.ambari.server.api.handlers.DeleteHandler.persist(DeleteHandler.java:44)
> 	at org.apache.ambari.server.api.handlers.BaseManagementHandler.handleRequest(BaseManagementHandler.java:72)
> 	at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:106)
> 	at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:75)
> 	at org.apache.ambari.server.api.services.RepositoryVersionService.deleteRepositoryVersion(RepositoryVersionService.java:114)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity
constraint (AMBARICUSTOMUSER.FK_CLUSTER_VERSION_REPOVERS_ID) violated - child record found
> Error Code: 2292
> Call: DELETE FROM repo_version WHERE (repo_version_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:900)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
> 	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:1836)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4244)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5594)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.acquireWriteLocks(UnitOfWorkImpl.java:1646)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransactionAfterWriteChanges(UnitOfWorkImpl.java:1614)
> 	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:284)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)
> 	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:132)
> 	... 93 more
> Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint
(AMBARICUSTOMUSER.FK_CLUSTER_VERSION_REPOVERS_ID) violated - child record found
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
> 	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
> 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
> 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
> 	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
> 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
> 	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
> 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
> 	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
> 	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)
> 	... 105 more
> {code}



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

Mime
View raw message