[
https://issues.apache.org/jira/browse/SQOOP-1725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211428#comment-14211428
]
Abraham Elmahrek commented on SQOOP-1725:
-----------------------------------------
[~vybs], can you create a patch that applies to sqoop2 branch as well?
> Sqoop2: Connector upgrade in 1.99.4 fails with delete configs
> -------------------------------------------------------------
>
> Key: SQOOP-1725
> URL: https://issues.apache.org/jira/browse/SQOOP-1725
> Project: Sqoop
> Issue Type: Bug
> Components: docs
> Affects Versions: 1.99.4
> Reporter: Veena Basavaraj
> Assignee: Veena Basavaraj
> Fix For: 1.99.4
>
> Attachments: SQOOP-1725.1.99.4.patch
>
>
> Caused by: java.sql.SQLIntegrityConstraintViolationException: DELETE on table
> 'SQ_CONFIG' caused a violation of foreign key constraint
> 'FK_SQ_CFG_DIR_CONFIG' for key (5). The statement has been rolled back.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
> Source)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at
> org.apache.sqoop.repository.derby.DerbyRepositoryHandler.updateConnectorAndDeleteConfigs(DerbyRepositoryHandler.java:1314)
> ... 24 more
> Caused by: java.sql.SQLException: DELETE on table 'SQ_CONFIG' caused a
> violation of foreign key constraint 'FK_SQ_CFG_DIR_CONFIG' for key (5). The
> statement has been rolled back.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 37 more
> Caused by: ERROR 23503: DELETE on table 'SQ_CONFIG' caused a violation of
> foreign key constraint 'FK_SQ_CFG_DIR_CONFIG' for key (5). The statement has
> been rolled back.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
