[
https://issues.apache.org/jira/browse/TRAFODION-979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15410112#comment-15410112
]
Prashanth Vasudev commented on TRAFODION-979:
---------------------------------------------
TRAFODION-1798 addresses support for DDL transactions. Please verify and close.
> LP Bug: 1418142 - Parallel DDL operations sees error 8810
> ---------------------------------------------------------
>
> Key: TRAFODION-979
> URL: https://issues.apache.org/jira/browse/TRAFODION-979
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Prashanth Vasudev
> Priority: Critical
> Fix For: 2.1-incubating
>
>
> To be able to run SQL regression tests in parallel on the same instance is
> one of the goals that we would like to see happen for the post-1.0 release.
> In order to do this, Trafodion needs to be able to handle parallel execution
> with a workload that has a mixture of DDLs and DMLs together. Right now,
> Trafodion is not very robust when it comes to handling concurrent DDL
> executions. (or a DDL execution with another DML execution. It’s hard to
> tell if it has to be 2 DDLs to cause all the problems that we seeing.)
> There are several problems in this area. The first noticeable one is this
> particular 8810 error. QA did an experiment last night by splitting the
> regression test suites into 2 parts and ran them together on a 4-node
> cluster. After both completed, we saw a total of 50 occurrences of this
> 8810 error:
> -bash-4.1$ grep 8810 */*.log | grep ERROR | wc -l
> 33
> -bash-4.1$ grep 8810 */*.log | grep ERROR | wc -l
> 17
> A typical error looks like this:
> SQL>drop table t10a104;
> *** ERROR[8810] Executor ran into an internal failure and returned an error
> without populating the diagnostics area. This error is being injected to
> indicate that. [2015-02-04 07:12:04]
> There is a bug report https://bugs.launchpad.net/trafodion/+bug/1413831
> ‘Phoenix tests run into several error 8810 when other tests are run in
> parallel with it´ that describes a similar problem. But that one has a
> narrower scope focusing only on phoenix tests and the severity of the bug
> report is only High. This one is intended to cover a broader issue of
> running parallel DDL operations in general. We will mark it as Critical as
> we need to remove this obstacle first to see what other problems may lie
> beneath for executing DDLs in parallel.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
