[
https://issues.apache.org/jira/browse/TRAFODION-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma reassigned TRAFODION-1796:
---------------------------------------
Assignee: Anoop Sharma
> Executor TEST131 fails with <table> does not exist or is inaccessible error
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-1796
> URL: https://issues.apache.org/jira/browse/TRAFODION-1796
> Project: Apache Trafodion
> Issue Type: Test
> Components: sql-general
> Reporter: Roberta Marton
> Assignee: Anoop Sharma
>
> Executor TEST131 is failing even though the table exists:
> *** ERROR[4082] Object TRAFODION.SEABASE.T1311K does not exist or is
> inaccessible.
> Executor TEST131, which runs in sqlci (main sqlci) starts up a second sqlci
> (secondary sqlci) to run some queries. The main sqlci creates the tables and
> the secondary sqlci tries to access them. The secondary sqlci is failing
> with error 4082 when it tries to access tables created by the main sqlci.
> Background: the runregr_executor.ksh script which controls the regression
> test obeys a file called cidefs prior to running the test queries. cidefs
> sets up common information needed by the tests tests. cidefs contains the
> following statement (among others):
> set SCHEMA $$TEST_SCHEMA$$;
> In this case, TEST_SCHEMA is equivalent to trafodion.sch. So the main sqlci
> session assumes that the default schema is trafodion.sch.
> When the second sqlci session starts, it uses the default schema that is set
> by default in the system. In this case, the default schema happens to be
> trafodion.seabase. (During “initialize trafodion”, the software creates this
> schema and makes it the default.)
> So queries fail in the secondary sqlci session because it is looking in the
> wrong schema.
> So how did this ever work?
> A special test exists in the core test suite – core/TEST000 that creates a
> bunch of default information. One of the statements changes the default
> schema from trafodion.seabase to trafodion.sch (through an insert into the
> “_MD_”.defaults table). So, if you run core/TEST000, as recommended, before
> running executor/TEST131, the test passes. In this case, the second sqlci
> session uses trafodion.sch as the default schema. This matches what the main
> sqlci session uses.
> To avoid having TEST131 fail in our daily runs, TEST131 will be updated.
> However, a long term solution is needed so other can avoid this problem.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
