You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Jarek (JIRA)" <ji...@apache.org> on 2016/06/12 03:09:20 UTC
[jira] [Updated] (TRAFODION-2061) SQL Error 1583 "Sequence metadata
could not be updated"
[ https://issues.apache.org/jira/browse/TRAFODION-2061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek updated TRAFODION-2061:
-----------------------------
Attachment: coast_2016-06-07_13.53.49.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log
coast_2016-06-07_13.43.58.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log
> 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)