cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "koray sariteke (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-9301) can not insert properly for compound primary key
Date Thu, 07 May 2015 13:35:59 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-9301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14532614#comment-14532614
] 

koray sariteke edited comment on CASSANDRA-9301 at 5/7/15 1:35 PM:
-------------------------------------------------------------------

Try 3 scenarios and get same missing data result below,

scenario 1 -  three cluster and replication factor 2, consistency level one
scenario 2 - three cluster and replication factor 2, consistency level ALL
scenario 3 - one node

Also observe nothing wrong at logs

symbol  orderno  timestamp 
ALCTL 124989 27042015-110002
VKGYO 389702 27042015-170004
YKBNK 389712 27042015-170004
GLYHO 124985 27042015-110002
VKGYO 389700 27042015-170004
YKBNK 389719 27042015-170004
BJKAS 124981 27042015-110002
SANFM 389697 27042015-170004
YKBNK 389706 27042015-170004
BOYNR 389721 27042015-170004
TMSN 124978 27042015-110001 
GLYHO 124982 27042015-110002
SANFM 389698 27042015-170004
YKBNK 389709 27042015-170004
YKBNK 389710 27042015-170004
TMSN 124987 27042015-110002 
ODAS 114602 27042015-105048 
YKBNK 389708 27042015-170004
YKBNK 389716 27042015-170004
ODAS 109575 27042015-104700 
SODA 124980 27042015-110002 
SANFM 389692 27042015-170004
YKBNK 389714 27042015-170004
TMSN 124979 27042015-110001 
GLYHO 124983 27042015-110002
EUHOL 389701 27042015-170004
SODA 124986 27042015-110002 
SANFM 389699 27042015-170004
YKBNK 389715 27042015-170004
YKBNK 389707 27042015-170004
KARTN 389724 27042015-170004
SANFM 389695 27042015-170004
YKBNK 389703 27042015-170004
VADYTV 389720 27042015-170004
TMSN 124977 27042015-110001 
YKBNK 389704 27042015-170004
BOYNR 389722 27042015-170004
NTHOL 124988 27042015-110002
SANFM 389693 27042015-170004
YKBNK 389713 27042015-170004
YKBNK 389717 27042015-170004
YKBNK 389718 27042015-170004
SANFM 389694 27042015-170004
SANFM 389696 27042015-170004
DOAS 124976 27042015-110001 
GLYHO 124984 27042015-110002
YKBNK 389705 27042015-170004
YKBNK 389711 27042015-170004
KARTN 389723 27042015-170004
 


was (Author: ksaritek):
Try 3 scenarios and get same missing data result below,

scenario 1 -  three cluster and replication factor 2, consistency level one
scenario 2 - three cluster and replication factor 2, consistency level ALL
scenario 3 - one node

Also observe nothing wrong at logs

ALCTL 124989 27042015-110002
VKGYO 389702 27042015-170004
YKBNK 389712 27042015-170004
GLYHO 124985 27042015-110002
VKGYO 389700 27042015-170004
YKBNK 389719 27042015-170004
BJKAS 124981 27042015-110002
SANFM 389697 27042015-170004
YKBNK 389706 27042015-170004
BOYNR 389721 27042015-170004
TMSN 124978 27042015-110001 
GLYHO 124982 27042015-110002
SANFM 389698 27042015-170004
YKBNK 389709 27042015-170004
YKBNK 389710 27042015-170004
TMSN 124987 27042015-110002 
ODAS 114602 27042015-105048 
YKBNK 389708 27042015-170004
YKBNK 389716 27042015-170004
ODAS 109575 27042015-104700 
SODA 124980 27042015-110002 
SANFM 389692 27042015-170004
YKBNK 389714 27042015-170004
TMSN 124979 27042015-110001 
GLYHO 124983 27042015-110002
EUHOL 389701 27042015-170004
SODA 124986 27042015-110002 
SANFM 389699 27042015-170004
YKBNK 389715 27042015-170004
YKBNK 389707 27042015-170004
KARTN 389724 27042015-170004
SANFM 389695 27042015-170004
YKBNK 389703 27042015-170004
VADYTV 389720 27042015-170004
TMSN 124977 27042015-110001 
YKBNK 389704 27042015-170004
BOYNR 389722 27042015-170004
NTHOL 124988 27042015-110002
SANFM 389693 27042015-170004
YKBNK 389713 27042015-170004
YKBNK 389717 27042015-170004
YKBNK 389718 27042015-170004
SANFM 389694 27042015-170004
SANFM 389696 27042015-170004
DOAS 124976 27042015-110001 
GLYHO 124984 27042015-110002
YKBNK 389705 27042015-170004
YKBNK 389711 27042015-170004
KARTN 389723 27042015-170004
 

> can not insert properly for compound primary key
> ------------------------------------------------
>
>                 Key: CASSANDRA-9301
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9301
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: cassandra 2.1.3, oracle jdk 1.7, linux
>            Reporter: koray sariteke
>
> Schema:
> {code}
> CREATE KEYSPACE tick WITH replication = {
> 'class': 'SimpleStrategy',
> 'replication_factor': '2'
> };
> CREATE TABLE trade (
>     date_symbol text,
>     symbol text,
>     signal_time bigint,
>     signal_time_text text,
>     bidask int,
>     price double,
>     quantity bigint,
>     order_no bigint,
>     PRIMARY KEY (date_symbol, signal_time)
>     ) WITH
>     compaction={'sstable_size_in_mb': '160', 'class': 'LeveledCompactionStrategy'} AND
>     compression={'sstable_compression': 'LZ4Compressor'};
> {code}
> Tried many times for 3 million data and same data(49 data) are not inserted. Increase
data frequency but result dont change.
> sample data at https://drive.google.com/file/d/0BzHZ-rv0D5JxSDRpblFQcUdRaVU/view?usp=sharing



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message