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 06:28:20 UTC
[jira] [Updated] (TRAFODION-2063) SQL Errror 8102 occurred when
down the region server
[ https://issues.apache.org/jira/browse/TRAFODION-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek updated TRAFODION-2063:
-----------------------------
Attachment: coast_2016-06-08_16.05.46.ANSI.GBK.MultiThread.linux64.TRAF_GBK.log
> 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.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-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)