[
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)
