[
https://issues.apache.org/jira/browse/CASSANDRA-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13883375#comment-13883375
]
Brandon Kearby commented on CASSANDRA-6285:
-------------------------------------------
Hi [~rhatch],
Here's the full schema I'm using to test with:
create keyspace SocialData
with placement_strategy = 'NetworkTopologyStrategy'
and strategy_options = {DC-Analytics : 3}
and durable_writes = true;
use SocialData;
create column family signal
with column_type = 'Standard'
and comparator = 'UTF8Type'
and default_validation_class = 'BytesType'
and key_validation_class = 'UTF8Type'
and read_repair_chance = 0.1
and dclocal_read_repair_chance = 0.0
and gc_grace = 432000
and min_compaction_threshold = 4
and max_compaction_threshold = 32
and replicate_on_write = true
and compaction_strategy =
'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'
and caching = 'NONE'
and compaction_strategy_options = {'sstable_size_in_mb' : '160'}
and comment = 'A store of information about each individual signal.'
and column_metadata = [
{column_name : 'type',
validation_class : UTF8Type},
{column_name : 'department_id',
validation_class : LongType},
{column_name : 'ecosystem_account_id',
validation_class : UTF8Type},
{column_name : 'content_type',
validation_class : UTF8Type},
{column_name : 'rating_count',
validation_class : LongType},
{column_name : 'service_account_id',
validation_class : UTF8Type},
{column_name : 'time',
validation_class : LongType},
{column_name : 'organization_id',
validation_class : LongType},
{column_name : 'conversation_id',
validation_class : UTF8Type},
{column_name : 'favorites_count',
validation_class : LongType},
{column_name : 'dislike_count',
validation_class : LongType},
{column_name : 'url',
validation_class : UTF8Type},
{column_name : 'impressions',
validation_class : LongType},
{column_name : 'network_strength',
validation_class : LongType},
{column_name : 'parent_signal_id',
validation_class : UTF8Type},
{column_name : 'account_snapshot_id',
validation_class : UTF8Type},
{column_name : 'region_id',
validation_class : LongType},
{column_name : 'time_bucket',
validation_class : LongType},
{column_name : 'enriched_on',
validation_class : LongType},
{column_name : 'dachis_account_id',
validation_class : UTF8Type},
{column_name : 'text',
validation_class : UTF8Type},
{column_name : 'sentiment',
validation_class : LongType},
{column_name : 'like_count',
validation_class : LongType},
{column_name : 'industry_id',
validation_class : LongType},
{column_name : 'service',
validation_class : UTF8Type},
{column_name : 'cloned_from',
validation_class : UTF8Type},
{column_name : 'constituent_type',
validation_class : UTF8Type},
{column_name : 'listings_count',
validation_class : LongType},
{column_name : 'network_size',
validation_class : LongType},
{column_name : 'analyzed',
validation_class : Int32Type},
{column_name : 'username',
validation_class : UTF8Type},
{column_name : 'service_signal_id',
validation_class : UTF8Type},
{column_name : 'language',
validation_class : UTF8Type},
{column_name : 'brand_id',
validation_class : LongType},
{column_name : 'rating',
validation_class : LongType},
{column_name : 'relationship_id',
validation_class : UTF8Type}]
and compression_options = {'sstable_compression' :
'org.apache.cassandra.io.compress.LZ4Compressor'};
> LCS compaction failing with Exception
> -------------------------------------
>
> Key: CASSANDRA-6285
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6285
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: 4 nodes, shortly updated from 1.2.11 to 2.0.2
> Reporter: David Sauer
> Assignee: Tyler Hobbs
> Fix For: 2.0.5
>
>
> After altering everything to LCS the table OpsCenter.rollups60 amd one other
> none OpsCenter-Table got stuck with everything hanging around in L0.
> The compaction started and ran until the logs showed this:
> ERROR [CompactionExecutor:111] 2013-11-01 19:14:53,865 CassandraDaemon.java
> (line 187) Exception in thread Thread[CompactionExecutor:111,1,RMI Runtime]
> java.lang.RuntimeException: Last written key
> DecoratedKey(1326283851463420237,
> 37382e34362e3132382e3139382d6a7576616c69735f6e6f72785f696e6465785f323031335f31305f30382d63616368655f646f63756d656e74736c6f6f6b75702d676574426c6f6f6d46696c746572537061636555736564)
> >= current key DecoratedKey(954210699457429663,
> 37382e34362e3132382e3139382d6a7576616c69735f6e6f72785f696e6465785f323031335f31305f30382d63616368655f646f63756d656e74736c6f6f6b75702d676574546f74616c4469736b5370616365557365640b0f)
> writing into
> /var/lib/cassandra/data/OpsCenter/rollups60/OpsCenter-rollups60-tmp-jb-58656-Data.db
> at
> org.apache.cassandra.io.sstable.SSTableWriter.beforeAppend(SSTableWriter.java:141)
> at
> org.apache.cassandra.io.sstable.SSTableWriter.append(SSTableWriter.java:164)
> at
> org.apache.cassandra.db.compaction.CompactionTask.runWith(CompactionTask.java:160)
> at
> org.apache.cassandra.io.util.DiskAwareRunnable.runMayThrow(DiskAwareRunnable.java:48)
> at
> org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28)
> at
> org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:60)
> at
> org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:59)
> at
> org.apache.cassandra.db.compaction.CompactionManager$6.runMayThrow(CompactionManager.java:296)
> at
> org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724)
> Moving back to STC worked to keep the compactions running.
> Especialy my own Table i would like to move to LCS.
> After a major compaction with STC the move to LCS fails with the same
> Exception.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
