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/13 17:49:34 UTC
[jira] [Updated] (SQOOP-1725) Sqoop2: Connector upgrade in 1.99.4
fails with delete configs
[ https://issues.apache.org/jira/browse/SQOOP-1725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Veena Basavaraj updated SQOOP-1725:
-----------------------------------
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.
was:
Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.sqoop.model.MConfigType.CONNECTION
at java.lang.Enum.valueOf(Enum.java:236)
at org.apache.sqoop.model.MConfigType.valueOf(MConfigType.java:23)
at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.loadConnectorConfigTypes(DerbyRepositoryHandler.java:2738)
at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.loadJobs(DerbyRepositoryHandler.java:2302)
at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.findJobsForConnector(DerbyRepositoryHandler.java:1645)
> 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
>
>
> 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)