[SQOOP-1725] Sqoop2: Connector upgrade in 1.99.4 fails with delete configs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.99.4
• Fix Version/s: 1.99.4
• Component/s: docs
• Assignee: Veena Basavaraj
• Reporter: Veena Basavaraj
• Created: 13/Nov/14 16:48
• Updated: 18/Nov/14 19:03
• Resolved: 13/Nov/14 23:24

Description

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.

Issue Links

• is a clone of: SQOOP-1724 Sqoop2: Support old config types for backward compatibility in connector data upgrade
• is cloned by: SQOOP-1728 Sqoop2: Force HDFS connector as a configurable fixes