accumulo-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ACCUMULO-4340) SQL Errror 8102 occurred when down the region server
Date Sun, 12 Jun 2016 04:28:21 GMT
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)

Mime
View raw message