Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-1725

Sqoop2: Connector upgrade in 1.99.4 fails with delete configs

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.99.4
    • 1.99.4
    • docs
    • None

    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.

      Attachments

        1. SQOOP-1725.1.99.4.patch
          3 kB
          Veena Basavaraj

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              vybs Veena Basavaraj
              vybs Veena Basavaraj
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: