[
https://issues.apache.org/jira/browse/TRAFODION-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming reassigned TRAFODION-2063:
-----------------------------------
Assignee: liu ming
> SQL Errror 8102 occurred when down the region server
> ----------------------------------------------------
>
> Key: TRAFODION-2063
> URL: https://issues.apache.org/jira/browse/TRAFODION-2063
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: 2.0-incubating, 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
> Assignee: liu ming
> Attachments:
> coast_2016-06-08_16.05.46.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log
>
>
> Issue Description:
> The following SQL Error 8102 occurred when down an region server.
> "16:09:28 ***ERROR: SQLExecDirect: Expected: SQL_SUCCESS Actual: SQL_ERROR
> File: ../../../../src/coast/coast_unified/src/jmtload.c Line: 187
> State: 23000
> Native Error: 4294959194
> Error: [Trafodion ODBC Driver][Trafodion Database] SQL ERROR:***
> ERROR[8102] The operation is prevented by a unique constraint. [2016-06-08
> 16:09:28]"
>
> Steps:
> Steps (cluster administrator page http://10.10.10.161:7180, username: admin,
> password: admin)
> Step 1. Enable High Availability in cluster testing environment.
> Step 2. Run multi threads program that have connected to 32 mxosrsvr(s).
> Step 3. Stop region server on centosha-5.novalocal node
> Step 4. Check output of the multi threads program.
> 1) output as below,
> DEBUG: plan to delete total rows is 180385
> DEBUG: remaining rows to delete is 180296
> DEBUG: Remaining rows 310886
> DEBUG: Total rows 311000
> DEBUG: Deleted rows 89
> DEBUG: Missing insertion rows 25 # please note
> the missing insertion rows because of the above error 8102.
> Total Tests=1 Failed=1
> 2) log file attached,
> “/opt/share/jarek/testing/odbc/builds_unix/coast/unified/linux64/coast_2016-06-08_16.05.46.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log”.
> BTW, our table structure is below, and we can see the cache size is 25 that
> is used to avoid concurrency conflict when insert data by multi threads
> program, but it still occurred.
>
> SQL>showddl trafodion.j_schema_2.j_table_1;
>
>
> CREATE TABLE TRAFODION.J_SCHEMA_2.J_TABLE_1
> (
> C0 LARGEINT GENERATED BY DEFAULT AS IDENTITY
> ( START WITH 1 INCREMENT BY 1 MAXVALUE 9223372036854775806 MINVALUE
> 1
> CACHE 25 NO CYCLE LARGEINT ) NOT NULL NOT DROPPABLE SERIALIZED
> , C1 CHAR(20) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , C2 INT NO DEFAULT SERIALIZED
> , C3 SMALLINT NO DEFAULT NOT NULL NOT
> DROPPABLE
> SERIALIZED
> , C4 DOUBLE PRECISION DEFAULT
> -1.7272337110188889E-76 NOT SERIALIZED
> , C5 DOUBLE PRECISION DEFAULT
> -2.2250738585072014E-308 NOT NULL NOT DROPPABLE NOT SERIALIZED
> , C6 DATE DEFAULT CURRENT NOT SERIALIZED
> , C7 TIME(0) DEFAULT CURRENT NOT SERIALIZED
> , C8 DECIMAL(18, 10) DEFAULT
> 12345678.1234567890 NOT NULL NOT DROPPABLE NOT SERIALIZED
> , C9 LARGEINT DEFAULT 9.223E18 SERIALIZED
> , C10 NUMERIC(128, 0) DEFAULT
>
> 12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678
> NOT NULL NOT DROPPABLE NOT SERIALIZED
> , C11 REAL DEFAULT -1.1579208E38 NOT SERIALIZED
> , C12 INTERVAL YEAR(5) TO MONTH DEFAULT NULL
> NOT
> SERIALIZED
> , C13 CHAR(12) CHARACTER SET ISO88591 COLLATE
> DEFAULT UPSHIFT DEFAULT _ISO88591'defaULT' SERIALIZED
> , C14 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT _ISO88591'summer' SERIALIZED
> , C15 VARCHAR(10) CHARACTER SET ISO88591
> COLLATE
> DEFAULT DEFAULT _ISO88591'china' SERIALIZED
> , C TIMESTAMP(6) DEFAULT CURRENT NOT
> SERIALIZED
> , PRIMARY KEY (C0 ASC)
> )
> ;
>
> -- The following sequence is a system created sequence --
>
> CREATE SEQUENCE TRAFODION.J_SCHEMA_2."_TRAFODION_J_SCHEMA_2_J_TABLE_1_C0_" /*
> INTERNAL */
> START WITH 1 /* NEXT AVAILABLE VALUE 311001 */
> INCREMENT BY 1
> MAXVALUE 9223372036854775806
> MINVALUE 1
> CACHE 25
> NO CYCLE
> LARGEINT
> ;
>
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
