[jira] [Updated] (TRAFODION-1798) Support Transactions for DDL statements

2016-02-05 Thread Prashanth Vasudev (JIRA)

 [ 
https://issues.apache.org/jira/browse/TRAFODION-1798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Prashanth Vasudev updated TRAFODION-1798:
-
Description: 
This work to support transaction for DDL operations started before Trafodion 
became part of incubation as Apache Trafodion.  The initial link to the 
blueprint is https://blueprints.launchpad.net/trafodion/+spec/dtm-ddl-support

Some of the implementation to support this feature is already in code base, 
however there are some more additional changes needed to support completely.
Additional changes include:

0. Enable existing transactional DDL support in transaction manager. Also 
enable corresponding regression test.
1. SQL executor changes to leverage transactional DDL support by transaction 
manager.
2. Issue with simultaneous transactional update to the table followed by drop. 
This manifests as a hang when a drop schema is performed.
3. Recovery in case of HA failure scenario.

  was:
This work to support transaction for DDL operations started before Trafodion 
became part of incubation as Apache Trafodion.  The initial link to the 
blueprint is https://blueprints.launchpad.net/trafodion/+spec/dtm-ddl-support

Some of the implementation to support this feature is already in code base, 
however there are some more additional changes needed to support completely.
Additional changes include:

1. SQL executor changes to leverage transactional DDL support by transaction 
manager.
2. Issue with simultaneous transactional update to the table followed by drop. 
This manifests as a hang when a drop schema is performed.
3. Recovery in case of HA failure scenario.



> Support Transactions for DDL statements
> ---
>
> Key: TRAFODION-1798
> URL: https://issues.apache.org/jira/browse/TRAFODION-1798
> Project: Apache Trafodion
>  Issue Type: New Feature
>Reporter: Prashanth Vasudev
>Assignee: Prashanth Vasudev
> Attachments: TransactionsDDL_Apache.pdf
>
>
> This work to support transaction for DDL operations started before Trafodion 
> became part of incubation as Apache Trafodion.  The initial link to the 
> blueprint is https://blueprints.launchpad.net/trafodion/+spec/dtm-ddl-support
> Some of the implementation to support this feature is already in code base, 
> however there are some more additional changes needed to support completely.
> Additional changes include:
> 0. Enable existing transactional DDL support in transaction manager. Also 
> enable corresponding regression test.
> 1. SQL executor changes to leverage transactional DDL support by transaction 
> manager.
> 2. Issue with simultaneous transactional update to the table followed by 
> drop. This manifests as a hang when a drop schema is performed.
> 3. Recovery in case of HA failure scenario.



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


[jira] [Updated] (TRAFODION-1798) Support Transactions for DDL statements

2016-02-01 Thread Prashanth Vasudev (JIRA)

 [ 
https://issues.apache.org/jira/browse/TRAFODION-1798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Prashanth Vasudev updated TRAFODION-1798:
-
Attachment: TransactionsDDL_Apache.pdf

Attached is the initial design that was performed to support this feature.


> Support Transactions for DDL statements
> ---
>
> Key: TRAFODION-1798
> URL: https://issues.apache.org/jira/browse/TRAFODION-1798
> Project: Apache Trafodion
>  Issue Type: New Feature
>Reporter: Prashanth Vasudev
>Assignee: Prashanth Vasudev
> Attachments: TransactionsDDL_Apache.pdf
>
>
> This work to support transaction for DDL operations started before Trafodion 
> became part of incubation as Apache Trafodion.  The initial link to the 
> blueprint is https://blueprints.launchpad.net/trafodion/+spec/dtm-ddl-support
> Some of the implementation to support this feature is already in code base, 
> however there are some more additional changes needed to support completely.
> Additional changes include:
> 1. SQL executor changes to leverage transactional DDL support by transaction 
> manager.
> 2. Issue with simultaneous transactional update to the table followed by 
> drop. This manifests as a hang when a drop schema is performed.
> 3. Recovery in case of HA failure scenario.



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