[jira] [Created] (TRAFODION-437) LP Bug: 1340464 - SPJ with SQL query statements failed with SQLCODE -2005

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

Alice Chen created TRAFODION-437:
------------------------------------

             Summary: LP Bug: 1340464 - SPJ with SQL query statements failed with SQLCODE -2005
                 Key: TRAFODION-437
                 URL: https://issues.apache.org/jira/browse/TRAFODION-437
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Chong Hsu
            Assignee: Pavani Puppala
            Priority: Critical
             Fix For: 0.9 (pre-incubation)


Testing Trafodion build, 20140709-0830.  

This error occurred intermittently but frequently in SPJs that running simple SQL query statement, like "insert", "delete" "update", and DDL statements as well.  

*** ERROR[11220] A Java method completed with an uncaught java.sql.SQLException with invalid SQLSTATE. The uncaught exception had a SQLCODE of -2005 and SQLSTATE of X0205. Details: java.sql.SQLException: *** ERROR[2005] Internal error: from compilation, no errors in diagnostics yet for statement: select count(*) from TRAFODION."_MD_".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'NCI_SPJ_SCH' and object_name = 'T1'  and valid_def = 'Y'; [2014-07-07 23:00:23]
*** ERROR[11224] The Java virtual machine raised an exception. Details: java.sql.SQLException: *** ERROR[8822] The statement was not prepared. [2014-07-07 23:00:23]
*** ERROR[11224] The Java virtual machine raised an exception. Details: java.sql.SQLException: *** ERROR[4082] Object TRAFODION.NCI_SPJ_SCH.T1 does not exist or is inaccessible. [2014-07-07 23:00:23]
*** ERROR[11224] The Java virtual machine raised an exception. Details: java.sql.SQLException: *** ERROR[8822] The statement was not prepared. [2014-07-07 23:00:23]

According to Arvind, this error is also seen in developer UDR regression test too.



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