[jira] [Created] (TRAFODION-370) LP Bug: 1328698 - Get schemas does not return a schema being used in Trafci

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

Alice Chen created TRAFODION-370:
------------------------------------

             Summary: LP Bug: 1328698 - Get schemas does not return a schema being used in Trafci
                 Key: TRAFODION-370
                 URL: https://issues.apache.org/jira/browse/TRAFODION-370
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Suresh Subbiah
            Priority: Critical
             Fix For: 1.1 (pre-incubation)


This is a strange behavior that we sometimes saw in Trafci.  As shown in the following execution output, the schema ‘TRAF_SYNTAX_MISC’ is being used.  It contains the table MYTABLE and MYVIEW, but ‘get schemas’ does not return the schema name at all.  This problem only seem to exist in Trafci.  Running the same sequence of commands from sqlci returns the schema name just fine.

This problem is seen on the GIT 0606_0930 build installed on a cluster (centos-mapr1 in this case).  There may be a caching issue somewhere.  This problem may seem minor, but we have seen our Trafodion metadata falls into an inconsistent state and suspect that this strange behavior may be related.  Therefore we want to document it.

-bash-4.1$ trafci.sh -h centos-mapr1.hpl.hp.com:37800 -u dontcare -p dontcare

Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.

Host Name/IP Address: centos-mapr1.hpl.hp.com:37800
User Name: dontcare

Connected to Trafodion

SQL>get schemas;

Schemas in Catalog TRAFODION
============================

G_ARKCASEDB
G_CMUREG
G_SQLDOPT
G_SQLDPOP
G_TPCDS1X
OPENCART
SCH2
SEABASE
T001A
T001B
VOLATILE_SCHEMA_MXID110030325812122688891779899280000000002
_MD_

--- SQL operation complete.

SQL>set schema TRAF_SYNTAX_MISC;

--- SQL operation complete.

SQL>create table mytable (a int);

--- SQL operation complete.

SQL>get schemas;

Schemas in Catalog TRAFODION
============================

G_ARKCASEDB
G_CMUREG
G_SQLDOPT
G_SQLDPOP
G_TPCDS1X
OPENCART
SCH2
SEABASE
T001A
T001B
VOLATILE_SCHEMA_MXID110030325812122688891779899280000000002
_MD_

--- SQL operation complete.

SQL>create view myview as select * from mytable;

--- SQL operation complete.

SQL>get schemas;

Schemas in Catalog TRAFODION
============================

G_ARKCASEDB
G_CMUREG
G_SQLDOPT
G_SQLDPOP
G_TPCDS1X
OPENCART
SCH2
SEABASE
T001A
T001B
VOLATILE_SCHEMA_MXID110030325812122688891779899280000000002
_MD_

--- SQL operation complete.

SQL>



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