[jira] [Resolved] (TRAFODION-2952) large amount of data will cause error in sequence generating

["liu ming (JIRA)" <ji...@apache.org>]

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

liu ming resolved TRAFODION-2952.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 2.4

> large amount of data will cause error in sequence generating
> ------------------------------------------------------------
>
>                 Key: TRAFODION-2952
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2952
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Major
>             Fix For: 2.4
>
>
> insert error
> ** ERROR[1583] Sequence metadata could not be updated.
> create table test1
> (id LARGEINT not null
> ) primary key(id)
>  SALT USING 48 PARTITIONS
> ATTRIBUTES ALIGNED FORMAT
>  HBASE_OPTIONS
>  (
>  DATA_BLOCK_ENCODING = 'FAST_DIFF',
>  COMPRESSION = 'SNAPPY',
>  MEMSTORE_FLUSH_SIZE = '1073741824'
>  );
> create table test2
> (id LARGEINT not null
> ) primary key(id)
>  SALT USING 48 PARTITIONS
> ATTRIBUTES ALIGNED FORMAT
>  HBASE_OPTIONS
>  (
>  DATA_BLOCK_ENCODING = 'FAST_DIFF',
>  COMPRESSION = 'SNAPPY',
>  MEMSTORE_FLUSH_SIZE = '1073741824'
>  );
> create sequence seq ;
> alter sequence seq cache 20000;
> upsert into test2 select seqnum(seq, next) from test1;
> test1 table has about 4 billion rows. When error raised , next value of seq is 5300001
> CREATE SEQUENCE TRAFODION.SEABASE.SEQ 
>  START WITH 1 /* NEXT AVAILABLE VALUE 5300001 */
>  INCREMENT BY 1
>  MAXVALUE 9223372036854775806
>  MINVALUE 1
>  CACHE 20000
>  NO CYCLE
>  LARGEINT 
> ;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)