You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Veena Basavaraj (JIRA)" <ji...@apache.org> on 2014/11/14 00:25:33 UTC

[jira] [Updated] (SQOOP-1728) Sqoop2: Force HDFS connector as a configurable fixes

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

Veena Basavaraj updated SQOOP-1728:
-----------------------------------
    Description: 

THe HDFS connector is a first class citizen as a connector( configurable) in 1.99.4. Its is converted to a first class citizen as part of the repository manager upgrade.

The repository manager is upgrading the schema first and then force creating a new connector called HDFS in it.

This code needs to match the code names used for configs and its inputs, if not the validation will fail during upgrade.
 

  was:
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.



> Sqoop2: Force HDFS connector as a configurable fixes
> ----------------------------------------------------
>
>                 Key: SQOOP-1728
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1728
>             Project: Sqoop
>          Issue Type: Bug
>          Components: docs
>    Affects Versions: 1.99.4
>            Reporter: Veena Basavaraj
>            Assignee: Veena Basavaraj
>             Fix For: 1.99.4
>
>
> THe HDFS connector is a first class citizen as a connector( configurable) in 1.99.4. Its is converted to a first class citizen as part of the repository manager upgrade.
> The repository manager is upgrading the schema first and then force creating a new connector called HDFS in it.
> This code needs to match the code names used for configs and its inputs, if not the validation will fail during upgrade.
>  



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