[
https://issues.apache.org/jira/browse/CASSANDRA-12125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16305231#comment-16305231
]
Aditya Bharadwaj edited comment on CASSANDRA-12125 at 1/3/18 8:56 PM:
----------------------------------------------------------------------
I'm running into the same issue, every few days (19 times in the last 2 months
to be precise).
In all but one scenario, it happened on the Secondary Index tables.
The exception is that it happened on the SSTable of this table
{{CREATE TABLE productdetails_by_storeid_variants (
merchantid uuid,
languagecode text,
storeid bigint,
productid bigint,
variantproductid bigint,
quantity bigint,
brand text,
brandid text,
bundlegroups text,
catalogcode text,
deliverymode text,
deliverytime text,
h1catname text,
h2catname text,
h3catname text,
h4catname text,
h5catname text,
hierarchy1category text,
hierarchy2category text,
hierarchy3category text,
hierarchy4category text,
hierarchy5category text,
image text,
inventory bigint,
largeimage text,
longdescription text,
maximumorderquantity bigint,
minimumorderquantity bigint,
mrp float,
offerdesc text,
primaryproductid bigint,
producttitle text,
producttype text,
refid bigint,
seodescription text,
seokeywords text,
seopagetitle text,
seourlkey text,
shortdescription text,
sku text,
smallimage text,
tags text,
variantproducts list<frozen<variant>>,
variantproperty text,
variantpropertyvalueid bigint,
variantvalue text,
webprice float,
PRIMARY KEY (merchantid, languagecode, storeid, productid, variantproductid,
quantity)
) WITH CLUSTERING ORDER BY (languagecode ASC, storeid ASC, productid ASC,
variantproductid ASC, quantity ASC)
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 86400
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';
CREATE INDEX productdetails_by_storeid_variants_refid_idx ON
productdetails_by_storeid_variants (refid);}}
At this frequency, it is a blocker for us too.
was (Author: adityabharadwaj):
I'm running into the same issue, every few days (19 times in the last 2 months
to be precise).
In all but one scenario, it happened on the Secondary Index tables.
The exception is that it happened on the SSTable of this table
{{CREATE TABLE martjack.productdetails_by_storeid_variants (
merchantid uuid,
languagecode text,
storeid bigint,
productid bigint,
variantproductid bigint,
quantity bigint,
brand text,
brandid text,
bundlegroups text,
catalogcode text,
deliverymode text,
deliverytime text,
h1catname text,
h2catname text,
h3catname text,
h4catname text,
h5catname text,
hierarchy1category text,
hierarchy2category text,
hierarchy3category text,
hierarchy4category text,
hierarchy5category text,
image text,
inventory bigint,
largeimage text,
longdescription text,
maximumorderquantity bigint,
minimumorderquantity bigint,
mrp float,
offerdesc text,
primaryproductid bigint,
producttitle text,
producttype text,
refid bigint,
seodescription text,
seokeywords text,
seopagetitle text,
seourlkey text,
shortdescription text,
sku text,
smallimage text,
tags text,
variantproducts list<frozen<variant>>,
variantproperty text,
variantpropertyvalueid bigint,
variantvalue text,
webprice float,
PRIMARY KEY (merchantid, languagecode, storeid, productid, variantproductid,
quantity)
) WITH CLUSTERING ORDER BY (languagecode ASC, storeid ASC, productid ASC,
variantproductid ASC, quantity ASC)
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 86400
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';
CREATE INDEX productdetails_by_storeid_variants_refid_idx ON
martjack.productdetails_by_storeid_variants (refid);}}
At this frequency, it is a blocker for us too.
> ERROR [MemtableFlushWriter:4] 2016-07-01 06:20:41,137
> CassandraDaemon.java:185 - Exception in thread
> Thread[MemtableFlushWriter:4,5,main] java.lang.RuntimeException: Last
> written key DecoratedKey(XXXX.XX, XXXXX) >= current key DecoratedKey
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-12125
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12125
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: RHEL-6.5 64-bit Apache Cassandra 2.2.5v
> Reporter: Relish Chackochan
> Fix For: 2.2.x
>
>
> We are running on RHEL-6.5 64-bit with Apache Cassandra 2.2.5v on 4 node
> cluster and getting the following error on multiple node while running the
> repair job and when getting the error repair job is hang.
> Can some one help to identify the issue.
> {code}
> ERROR [MemtableFlushWriter:4] 2016-07-01 06:20:41,137
> CassandraDaemon.java:185 - Exception in thread
> Thread[MemtableFlushWriter:4,5,main]
> java.lang.RuntimeException: Last written key DecoratedKey(1467371986.8870,
> 313436373337313938362e38383730) >= current key DecoratedKey(,
> 313436373337323030312e38383730) writing into
> /opt/cassandra/data/proddb/log_data1-0a5092a0a4fa11e5872fc1ce0a46dc27/.maxdatetimeindex_idx/tmp-la-470-big-Data.db
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
