Jarek created ACCUMULO-4340:
-------------------------------
Summary: SQL Errror 8102 occurred when down the region server
Key: ACCUMULO-4340
URL: https://issues.apache.org/jira/browse/ACCUMULO-4340
Project: Accumulo
Issue Type: Bug
Affects Versions: 2.0.0
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
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)
