[jira] [Commented] (TRAFODION-2074) Create index should avoid populating the index within a transaction

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

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

ASF GitHub Bot commented on TRAFODION-2074:
-------------------------------------------

GitHub user selvaganesang opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/550

    [TRAFODION-2074] Create index should avoid populating the index withi…

    …n a transaction
    
    Create index is now done in multiple transactions when there is no
    active transaction.
    1) creating the index table in transaction 1.
    2) populate the index without any transaction. If it fails,
       cleanup the index table.
    3) If it succeeds complete the rest of the index creation in transaction 2.
    4) If there are any failures, cleanup the index table.
    
    When there is an active transaction while the create index is issued, then
    all the above steps are done within the user transaction.
    
    Also did some cleanup to return proper errors instead of dumping core

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/selvaganesang/incubator-trafodion index_issue

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/550.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #550
    
----
commit bcdbfbc2e0f2350ca109d8b5947aa80d71c40e28
Author: selvaganesang <se...@esgyn.com>
Date:   2016-06-17T22:11:47Z

    [TRAFODION-2074] Create index should avoid populating the index within a transaction
    Create index is now done in multiple transactions when there is no
    active transaction.
    1) creating the index table in transaction 1.
    2) populate the index without any transaction. If it fails,
       cleanup the index table.
    3) If it succeeds complete the rest of the index creation in transaction 2.
    4) If there are any failures, cleanup the index table.
    
    When there is an active transaction while the create index is issued, then
    all the above steps are done within the user transaction.
    
    Also did some cleanup to return proper errors instead of dumping core

----


> Create index should avoid populating the index within a transaction
> -------------------------------------------------------------------
>
>                 Key: TRAFODION-2074
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2074
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-exe
>    Affects Versions: 2.0-incubating
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Selvaganesan Govindarajan
>             Fix For: 2.1-incubating
>
>
> Populating the index is done via load command. Load command doesn't need transaction. Transactions in Trafodion have 2hr expiry period. If the load takes more than 2 hours to populate the index the create index will always fail. 



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