You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jonathan Ellis (JIRA)" <ji...@apache.org> on 2011/03/10 20:17:00 UTC

[jira] Commented: (CASSANDRA-2309) Scrub resulting in "Keys must be written in ascending order" exception

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

Jonathan Ellis commented on CASSANDRA-2309:
-------------------------------------------

Well, it's right -- the "current key" sorts before the "last written key" so it's out of order.

If scrub is able to continue, then you should probably do an sstable2json, then let scrub go ahead and strip out those out-of-order keys, then use the log messages to pull the keys that were out of order out of your json dump.

> Scrub resulting in "Keys must be written in ascending order" exception
> ----------------------------------------------------------------------
>
>                 Key: CASSANDRA-2309
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2309
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.7.3
>            Reporter: Jason Harvey
>
> Getting the following when I try to scrub. The SSTable causing it is over a gig. Trying to repro on smaller tables so I have something to upload.
> {code}
> DEBUG [CompactionExecutor:1] 2011-03-10 12:07:13,264 CompactionManager.java (line 543) Reading row at 552076476
> DEBUG [CompactionExecutor:1] 2011-03-10 12:07:13,265 CompactionManager.java (line 552) row 6c6173745f636f6d6d656e74735f74335f386c387633 is 168 bytes
> DEBUG [CompactionExecutor:1] 2011-03-10 12:07:13,265 CompactionManager.java (line 581) Index doublecheck: row 6c6173745f636f6d6d656e74735f74335f386c387633 is 168 bytes
>  INFO [CompactionExecutor:1] 2011-03-10 12:07:13,265 SSTableWriter.java (line 108) Last written key : DecoratedKey(125686934811414729670440675125192621396, 627975726c2833626333626339353363353762313133373331336461303233396438303534312c66692e676f73757065726d6f64656c2e636f6d2f70726f66696c65732f2f6170706c65747265713d3132373333393332313937363529)
>  INFO [CompactionExecutor:1] 2011-03-10 12:07:13,265 SSTableWriter.java (line 109) Current key : DecoratedKey(11163129555189411157074346827960371449, 6c6173745f636f6d6d656e74735f74335f386c387633)
>  INFO [CompactionExecutor:1] 2011-03-10 12:07:13,265 SSTableWriter.java (line 110) Writing into file /var/lib/cassandra/data/reddit/permacache-tmp-f-168492-Data.db
>  WARN [CompactionExecutor:1] 2011-03-10 12:07:13,265 CompactionManager.java (line 599) Non-fatal error reading row (stacktrace follows)
> java.io.IOException: Keys must be written in ascending order.
>         at org.apache.cassandra.io.sstable.SSTableWriter.beforeAppend(SSTableWriter.java:111)
>         at org.apache.cassandra.io.sstable.SSTableWriter.append(SSTableWriter.java:128)
>         at org.apache.cassandra.db.CompactionManager.doScrub(CompactionManager.java:591)
>         at org.apache.cassandra.db.CompactionManager.access$600(CompactionManager.java:56)
>         at org.apache.cassandra.db.CompactionManager$3.call(CompactionManager.java:195)
>         at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:636)
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira