[jira] [Updated] (TRAFODION-979) LP Bug: 1418142 - Parallel DDL operations sees error 8810
[ https://issues.apache.org/jira/browse/TRAFODION-979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-979: - Fix Version/s: (was: 2.2.0) > 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 > > 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 (v7.6.3#76005)
[jira] [Updated] (TRAFODION-979) LP Bug: 1418142 - Parallel DDL operations sees error 8810
[ https://issues.apache.org/jira/browse/TRAFODION-979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pierre Smits updated TRAFODION-979: --- Fix Version/s: (was: 2.1-incubating) 2.2.0 > 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.2.0 > > > 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 (v7.6.3#76005)