[jira] [Assigned] (TRAFODION-979) LP Bug: 1418142 - Parallel DDL operations sees error 8810

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

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

Suresh Subbiah reassigned TRAFODION-979:
----------------------------------------

    Assignee: Prashanth Vasudev

> 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.0-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)