accumulo-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (ACCUMULO-4340) SQL Errror 8102 occurred when down the region server
Date Sun, 12 Jun 2016 06:24:20 GMT

     [ https://issues.apache.org/jira/browse/ACCUMULO-4340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jarek closed ACCUMULO-4340.
---------------------------

> 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
>         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)

Mime
View raw message