[ https://issues.apache.org/jira/browse/TRAFODION-2061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek closed TRAFODION-2061. ---------------------------- Resolution: Duplicate > 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 > Attachments: > coast_2016-06-07_13.43.58.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log, > coast_2016-06-07_13.53.49.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log > > > 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)