[jira] [Commented] (SQOOP-1625) Repository upgrade issue

["Veena Basavaraj (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SQOOP-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14186244#comment-14186244 ] 

Veena Basavaraj commented on SQOOP-1625:
----------------------------------------

It does not happen to me. is this on the latest code?

> Repository upgrade issue
> ------------------------
>
>                 Key: SQOOP-1625
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1625
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.99.4
>            Reporter: Qian Xu
>
> I'm facing a SQL error, while Sqoop2 tries to add an existing constraint again. It happens when I recompile Sqoop project and restart Sqoop server. Here is the error message:
> {code}
> Caused by: ERROR 42Z93: Constraints 'FK_SQB_NAME_UNIQUE' and 'FK_SQB_NAME_UNIQUE' have the same set of columns, which is not allowed.
> {code}
> In DerbyRepositoryHandler.java, constraints will be added to repository, if repository version is greater than 3. According to the code, the code can be executed at every Sqoop server startup. Obviously, the code cannot be 
> executed twice, so Sqoop server cannot start up.
> {code}
>     // Add unique constraints on job and links for version 4 onwards
>     if (repositoryVersion > 3) {
>       runQuery(QUERY_UPGRADE_TABLE_SQ_JOB_ADD_UNIQUE_CONSTRAINT_NAME, conn);
>       runQuery(QUERY_UPGRADE_TABLE_SQ_LINK_ADD_UNIQUE_CONSTRAINT_NAME, conn);
>       runQuery(QUERY_UPGRADE_TABLE_SQ_CONFIGURABLE_ADD_UNIQUE_CONSTRAINT_NAME, conn);
>     }
> {code}
> Compare with other code of repository version upgrade, after version number is increased, related code never executed again. But the highlighted code is not. 
> Shall we
> 1. Increase the current repository version to 5 (instead of 4) and
> 2. Change the following code
> {code}
> if (repositoryVersion > 3) {
> // Change to 
> if (repositoryVersion <= 4) {
> {code}



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