[
https://issues.apache.org/jira/browse/SQOOP-1725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14216613#comment-14216613
]
Hudson commented on SQOOP-1725:
-------------------------------
FAILURE: Integrated in Sqoop2-hadoop100 #686 (See
[https://builds.apache.org/job/Sqoop2-hadoop100/686/])
SQOOP-1734: Port SQOOP-1725 to sqoop2 branch (jarcec:
https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=dacf889c7d2ed51b9d3e761b1a1f32e555ef045c)
*
repository/repository-common/src/main/java/org/apache/sqoop/repository/common/CommonRepositoryInsertUpdateDeleteSelectQuery.java
*
repository/repository-common/src/main/java/org/apache/sqoop/repository/common/CommonRepositoryHandler.java
> 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)
