Atanu Mishra created TRAFODION-2062:
---------------------------------------
Summary: 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
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)
