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)