Jarek created TRAFODION-2061:
--------------------------------
Summary: SQL Error 1583 "Sequence metadata could not be updated"
Key: TRAFODION-2061
URL: https://issues.apache.org/jira/browse/TRAFODION-2061
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Affects Versions: 2.1-incubating
Environment: OS Type and Version: Centos release 6.7
Trafodion SW Version: 2.1
CDH Version: 5.5.4
JDK Version: 1.7.0_67
Reporter: Jarek
Issue Description:
When insert data using multi threads program, some insertion data is missing
because of SQL error 1583 "Sequence metadata could not be updated" occurred.
Test Steps:
Step 0. Hive Metastore Server Instance is running.
Step 1. Start multi threads program.
Step 2. Stop Hive Metastore Server Instance.
Step 3. Back to multi threads program, it still running, waiting it completed.
Step 4. Check multi threads program output and the log file.
1) output is,
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
2) log file attached,
"coast_2016-06-07_13.43.58.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log"
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]
By the way, if skip step 3, no this kind error occurred, the output and log
file below,
1) output is,
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
2) log file attached,
"coast_2016-06-07_13.53.49.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
