[
https://issues.apache.org/jira/browse/TRAFODION-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming reassigned TRAFODION-2062:
-----------------------------------
Assignee: liu ming
> Query fails with SQL ERROR[1583] when the Hive Metastore Server Instance
> process is killed
> ------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2062
> URL: https://issues.apache.org/jira/browse/TRAFODION-2062
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: 2.0-incubating, 2.1-incubating
> Reporter: Atanu Mishra
> Assignee: liu ming
>
> Below test scenarios for multi threads program enhanced test, and tried it
> several times,
> HMSI - Hive Metastore Server Instance
> Step 0. HMSI is running.
> Step 1. Start multi threads program
> Step 2. Total 32 mxosrvr(s) connected in multi threads program.
> Step 3. Stop HMSI.
> Step 4. Back to multi threads program, it still running, waiting it completed.
> At the same time, after HMSI stopped completely, 32 mxosrvr(s) still
> connected, that’s expected.
> Step 5. Check multi threads program output and the log file.
>
> DEBUG: plan to delete total rows is 291488
> DEBUG: remaining rows to delete is 291400
> DEBUG: Remaining rows 310909
> DEBUG: Total rows 311000
> DEBUG: Deleted rows 88
> DEBUG: Missing insertion rows 3 # please note that here 3 is
> not fixed, if you run several times, it will be changed other number.
> Total Tests=1 Failed=1
>
> In the log file we can see the error below, which is not expected.
>
> 13:46:52 ***ERROR: SQLExecDirect: Expected: SQL_SUCCESS Actual: SQL_ERROR
> File: ../../../../src/coast/coast_unified/src/jmtload.c Line: 187
> # please note that here 187 line is used to insert a row
> into table
> State: X01G7
> Native Error: 4294965713
> Error: [Trafodion ODBC Driver][Trafodion Database] SQL ERROR:***
> ERROR[1583] Sequence metadata could not be updated. [2016-06-07 13:46:52]
>
> If skip step 3, this error does not show up,
>
> DEBUG: plan to delete total rows is 145895
> DEBUG: remaining rows to delete is 145809
> DEBUG: Remaining rows 310914
> DEBUG: Total rows 311000
> DEBUG: Deleted rows 86
> DEBUG: Missing insertion rows 0
> Total Tests=1 Failed=0
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
