[ https://issues.apache.org/jira/browse/TRAFODION-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15460114#comment-15460114 ]
liu ming commented on TRAFODION-2063: ------------------------------------- there is potential race condition in sequence function, will need more time to investigate on this. > 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)