[jira] [Created] (TRAFODION-386) LP Bug: 1331083 - Phoenix tests fail at drop table with ERROR 1389

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-386:
------------------------------------

             Summary: LP Bug: 1331083 - Phoenix tests fail at drop table with ERROR 1389
                 Key: TRAFODION-386
                 URL: https://issues.apache.org/jira/browse/TRAFODION-386
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Apache Trafodion
            Priority: Blocker


Phoenix tests have started to fail with some new check-ins.  The first occurrence of failures showed up in the GIT 6/14/2014 daily build testing https://sea-jenkins01.hpl.hp.com/job/traf-pub-release/31/.  With the 0616_0930 build installed on centos-mapr, a 6-node cluster, these failures show up randomly, but frequently enough that the tests have never been able to get a single clean run.  Most failures happen at ‘drop table … cascade’.  The drop table statement would error out with an error message saying that a dependent object does not exist.  Here are some examples of such failures.  Notice that the error message is not about the user table itself, but some internal objects created for the user table:

drop table LongInKeyTest cascade; *** ERROR[1389] Object LONGINKEYTEST_994122785_6819 does not exist in Trafodion. [2014-06-17 08:30:44]
drop table IntIntKeyTest cascade; *** ERROR[1389] Object INTINTKEYTEST_672253851_2786 does not exist in Trafodion. [2014-06-17 08:31:30]
drop table FUNKY_NAMES cascade; *** ERROR[1389] Object FUNKY_NAMES_231124197_5291 does not exist in Trafodion. [2014-06-17 08:36:04]
drop table GROUPBYTEST cascade *** ERROR[1389] Object GROUPBYTEST_227547817_8298 does not exist in Trafodion.
drop table source cascade: *** ERROR[1389] Object SOURCE_974349377_2522 does not exist in Trafodion. [2014-06-17 09:05:37]
drop table target cascade *** ERROR[1389] Object TARGET_366349377_2522 does not exist in Trafodion. [2014-06-17 09:05:44]

At this moment, it is hard to say if this is a problem in SQL, or in DTM.  For now, the bug report is filed against sql-exe to do some initial analysis first.
Assigned to LaunchPad User Mike Hanlon



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