[jira] [Comment Edited] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15613271#comment-15613271 ] Hau Phan edited comment on CASSANDRA-12805 at 10/27/16 9:26 PM: Thanks [~eprothro], [~rustyrazorblade], updated commit and verified formatting via sphinx. was (Author: nothau): Updated, also compiled and formatting verified with sphinx. > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/f90038e9f35281bdd58dabb25f21836a690e56f5 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15613271#comment-15613271 ] Hau Phan commented on CASSANDRA-12805: -- Updated, also compiled and formatting verified with sphinx. > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/f90038e9f35281bdd58dabb25f21836a690e56f5 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Description: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/f90038e9f35281bdd58dabb25f21836a690e56f5 was: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/876d395b4188bb230f869a161c3d7fe317506b34 > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/f90038e9f35281bdd58dabb25f21836a690e56f5 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: (was: 12805-trunk.txt) > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/f90038e9f35281bdd58dabb25f21836a690e56f5 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: 12805-trunk.txt > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/f90038e9f35281bdd58dabb25f21836a690e56f5 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: 12805-trunk.txt > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/876d395b4188bb230f869a161c3d7fe317506b34 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Description: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/876d395b4188bb230f869a161c3d7fe317506b34 was: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/876d395b4188bb230f869a161c3d7fe317506b34 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: (was: 12805-trunk.txt) > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Description: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 was: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/b8b8b6c18d4ab19558b5489f73ebc4f6ffdb52f1 > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: 12805-trunk.txt > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15602534#comment-15602534 ] Hau Phan commented on CASSANDRA-12805: -- Updated commit and patch file per Romain Hardouin comments. > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: (was: 12805-trunk.txt) > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/0c461134b18c75bbd63b18186547a6428f865422 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Attachment: 12805-trunk.txt > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > Attachments: 12805-trunk.txt > > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/b8b8b6c18d4ab19558b5489f73ebc4f6ffdb52f1 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Description: Updated Storage Engine page for commitlogs Commit: https://github.com/nothau/cassandra/commit/b8b8b6c18d4ab19558b5489f73ebc4f6ffdb52f1 was: Updated Storage Engine page for commitlogs > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > > Updated Storage Engine page for commitlogs > Commit: > https://github.com/nothau/cassandra/commit/b8b8b6c18d4ab19558b5489f73ebc4f6ffdb52f1 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CASSANDRA-12805) Website documentation for commitlog
[ https://issues.apache.org/jira/browse/CASSANDRA-12805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12805: - Labels: documentation (was: ) Status: Patch Available (was: Open) Updated website documentation for http://cassandra.apache.org/doc/latest/architecture/storage_engine.html > Website documentation for commitlog > --- > > Key: CASSANDRA-12805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 > Project: Cassandra > Issue Type: Improvement > Components: Documentation and Website >Reporter: Hau Phan >Priority: Minor > Labels: documentation > > Updated Storage Engine page for commitlogs -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CASSANDRA-12805) Website documentation for commitlog
Hau Phan created CASSANDRA-12805: Summary: Website documentation for commitlog Key: CASSANDRA-12805 URL: https://issues.apache.org/jira/browse/CASSANDRA-12805 Project: Cassandra Issue Type: Improvement Components: Documentation and Website Reporter: Hau Phan Priority: Minor Updated Storage Engine page for commitlogs -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-7190) Add schema to snapshot manifest
[ https://issues.apache.org/jira/browse/CASSANDRA-7190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15536106#comment-15536106 ] Hau Phan commented on CASSANDRA-7190: - https://issues.apache.org/jira/browse/CASSANDRA-12734 > Add schema to snapshot manifest > --- > > Key: CASSANDRA-7190 > URL: https://issues.apache.org/jira/browse/CASSANDRA-7190 > Project: Cassandra > Issue Type: Improvement > Components: Tools >Reporter: Jonathan Ellis >Assignee: Alex Petrov >Priority: Minor > Labels: client-impacting, doc-impacting, lhf > Fix For: 3.0.9, 3.10 > > > followup from CASSANDRA-6326 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CASSANDRA-12734) Materialized View schema file for snapshots created as tables
Hau Phan created CASSANDRA-12734: Summary: Materialized View schema file for snapshots created as tables Key: CASSANDRA-12734 URL: https://issues.apache.org/jira/browse/CASSANDRA-12734 Project: Cassandra Issue Type: Bug Components: Tools Reporter: Hau Phan Fix For: 3.0.9 The materialized view schema file that gets created and stored with the sstables is created as a table instead of a materialized view. Can the materialized view be created and added to the corresponding table's schema file? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-7190) Add schema to snapshot manifest
[ https://issues.apache.org/jira/browse/CASSANDRA-7190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533480#comment-15533480 ] Hau Phan edited comment on CASSANDRA-7190 at 9/29/16 6:46 PM: -- I noticed that the schema.cql file that gets generated with snapshots for materialized views are being treated as a table instead of a materialized view. Also to note, the mv schema is not included with the table schema.cql from which it's linked to. Should I create a new ticket? was (Author: nothau): I noticed that the schema.cql file that gets generated with snapshots for materialized views are being treated as a table instead of a materialized view. Should I create a new ticket? > Add schema to snapshot manifest > --- > > Key: CASSANDRA-7190 > URL: https://issues.apache.org/jira/browse/CASSANDRA-7190 > Project: Cassandra > Issue Type: Improvement > Components: Tools >Reporter: Jonathan Ellis >Assignee: Alex Petrov >Priority: Minor > Labels: client-impacting, doc-impacting, lhf > Fix For: 3.0.9, 3.10 > > > followup from CASSANDRA-6326 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-7190) Add schema to snapshot manifest
[ https://issues.apache.org/jira/browse/CASSANDRA-7190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533480#comment-15533480 ] Hau Phan commented on CASSANDRA-7190: - I noticed that the schema.cql file that gets generated with snapshots for materialized views are being treated as a table instead of a materialized view. Should I create a new ticket? > Add schema to snapshot manifest > --- > > Key: CASSANDRA-7190 > URL: https://issues.apache.org/jira/browse/CASSANDRA-7190 > Project: Cassandra > Issue Type: Improvement > Components: Tools >Reporter: Jonathan Ellis >Assignee: Alex Petrov >Priority: Minor > Labels: client-impacting, doc-impacting, lhf > Fix For: 3.0.9, 3.10 > > > followup from CASSANDRA-6326 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15389596#comment-15389596 ] Hau Phan commented on CASSANDRA-12215: -- Sure, with tracing on; here's the error message of the select * from friendships_by_owner. {code} code=1300 [Replica(s) failed to execute read] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} {code} Here's logs from system.log when the error occurs: {code} WARN [SharedPool-Worker-2] 2016-07-22 09:24:47,589 AbstractLocalAwareExecutorService.java:169 - Uncaught exception on thread Thread[SharedPool-Worker-2,5,main]: {} java.lang.RuntimeException: java.lang.NullPointerException at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2453) ~[main/:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_65] at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:164) ~[main/:na] at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$LocalSessionFutureTask.run(AbstractLocalAwareExecutorService.java:136) [main/:na] at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [main/:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] Caused by: java.lang.NullPointerException: null {code} > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at >
[jira] [Commented] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15388331#comment-15388331 ] Hau Phan commented on CASSANDRA-12215: -- If a copy of our sstables will help, please don't hesitate to ask. > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > at > org.apache.cassandra.db.compaction.CompactionManager$8.runMayThrow(CompactionManager.java:606) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at >
[jira] [Commented] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15387984#comment-15387984 ] Hau Phan commented on CASSANDRA-12215: -- Implemented the patch from CASSANDRA-11988, the noticeable change is when gc_grace_seconds is set to a year, a select * will now show the data + tombstone'd partitions. > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > at > org.apache.cassandra.db.compaction.CompactionManager$8.runMayThrow(CompactionManager.java:606) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at >
[jira] [Comment Edited] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15387984#comment-15387984 ] Hau Phan edited comment on CASSANDRA-12215 at 7/21/16 4:25 PM: --- Implemented the patch from CASSANDRA-11988, the noticeable change is when gc_grace_seconds is set to a year, a select * will now show the data + tombstone'd partitions. With gc_grace_seconds set to 1 day, still getting the java.lang.NullPointerException error. was (Author: nothau): Implemented the patch from CASSANDRA-11988, the noticeable change is when gc_grace_seconds is set to a year, a select * will now show the data + tombstone'd partitions. > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > at >
[jira] [Commented] (CASSANDRA-11988) NullPointerExpception when reading/compacting table
[ https://issues.apache.org/jira/browse/CASSANDRA-11988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15387981#comment-15387981 ] Hau Phan commented on CASSANDRA-11988: -- FYI, we're having the same issue (CASSANDRA-12215). I implemented the patch, set gc_grace_seconds to 86400, and still ran into the error. Setting the gc_grace_seconds to something high, all rows show up, including the ones that are supposed to be tombstones. > NullPointerExpception when reading/compacting table > --- > > Key: CASSANDRA-11988 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11988 > Project: Cassandra > Issue Type: Bug >Reporter: Nimi Wariboko Jr. >Assignee: Sylvain Lebresne > Fix For: 3.0.9, 3.9 > > > I have a table that suddenly refuses to be read or compacted. Issuing a read > on the table causes a NPE. > On compaction, it returns the error > {code} > ERROR [CompactionExecutor:6] 2016-06-09 17:10:15,724 CassandraDaemon.java:213 > - Exception in thread Thread[CompactionExecutor:6,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:38) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:76) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:182) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:82) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.6.jar:3.6] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:264) > ~[apache-cassandra-3.6.jar:3.6] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_45] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_45] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_45] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_45] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] > {code} > Schema: > {code} > CREATE TABLE cmpayments.report_payments ( > reportid timeuuid, > userid timeuuid, > adjustedearnings decimal, > deleted set static, > earnings map, > gross map , > organizationid text, > payall timestamp static, > status text, > PRIMARY KEY (reportid, userid) > ) WITH CLUSTERING ORDER BY (userid 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 = 864000 > 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'; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15386470#comment-15386470 ] Hau Phan edited comment on CASSANDRA-12215 at 7/20/16 8:13 PM: --- One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table shows 4 tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run - COPY table TO 'file' - DROP table - rm -rf'd the table directory on the file system - CREATE table (with same schema) - COPY table FROM 'file' - Ran the select * again, and the tombstones still exist. Expected behavior would be a clean table with no tombstones, yet the 4 tombstones exist. Reviewing the 'dump' file shows no tombstones. was (Author: nothau): One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table shows 4 tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run a COPY TO, truncated the table, then ran a COPY FROM, ran the select * again, and the tombstones still exist. Reviewing the 'dump' file, I'm not seeing anything marked tombstones and the data looks fine. My understanding is, compaction should remove the tombstone records if it's past the gc_grace_seconds limit. Also, if the 'dump' file doesn't show tombstones, where is cassandra retrieving that info? > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null >
[jira] [Comment Edited] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15386470#comment-15386470 ] Hau Phan edited comment on CASSANDRA-12215 at 7/20/16 8:00 PM: --- One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table shows 4 tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run a COPY TO, truncated the table, then ran a COPY FROM, ran the select * again, and the tombstones still exist. Reviewing the 'dump' file, I'm not seeing anything marked tombstones and the data looks fine. My understanding is, compaction should remove the tombstone records if it's past the gc_grace_seconds limit. Also, if the 'dump' file doesn't show tombstones, where is cassandra retrieving that info? was (Author: nothau): One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table shows tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run a COPY TO, truncated the table, then ran a COPY FROM, ran the select * again, and the tombstones still exist. Reviewing the 'dump' file, I'm not seeing anything marked tombstones and the data looks fine. My understanding is, compaction should remove the tombstone records if it's past the gc_grace_seconds limit. Also, if the 'dump' file doesn't show tombstones, where is cassandra retrieving that info? > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting
[jira] [Comment Edited] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15386470#comment-15386470 ] Hau Phan edited comment on CASSANDRA-12215 at 7/20/16 8:00 PM: --- One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table shows tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run a COPY TO, truncated the table, then ran a COPY FROM, ran the select * again, and the tombstones still exist. Reviewing the 'dump' file, I'm not seeing anything marked tombstones and the data looks fine. My understanding is, compaction should remove the tombstone records if it's past the gc_grace_seconds limit. Also, if the 'dump' file doesn't show tombstones, where is cassandra retrieving that info? was (Author: nothau): One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table still shows tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run a COPY TO, truncated the table, then ran a COPY FROM, ran the select * again, and the tombstones still exist. Reviewing the 'dump' file, I'm not seeing anything marked tombstones and the data looks fine. My understanding is, compaction should remove the tombstone records if it's past the gc_grace_seconds limit. Also, if the 'dump' file doesn't show tombstones, where is cassandra retrieving that info? > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 >
[jira] [Commented] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15386470#comment-15386470 ] Hau Phan commented on CASSANDRA-12215: -- One thing I noticed, when setting the gc_grace_seconds to 864 (100 days), the tables are readable and compaction runs without error. Enabling tracing, doing a select * from the table still shows tombstones: {code} Read 124 live and 4 tombstone cells [SharedPool-Worker-2] | 2016-07-20 14:09:17.236000 | 127.0.0.1 | 1849 {code} I have run a COPY TO, truncated the table, then ran a COPY FROM, ran the select * again, and the tombstones still exist. Reviewing the 'dump' file, I'm not seeing anything marked tombstones and the data looks fine. My understanding is, compaction should remove the tombstone records if it's past the gc_grace_seconds limit. Also, if the 'dump' file doesn't show tombstones, where is cassandra retrieving that info? > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at >
[jira] [Issue Comment Deleted] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12215: - Comment: was deleted (was: One thing to note, this occurs when attempting to delete a row, the owner_id and username values still exist. {code} delete from friendships_by_owner where owner_id = and friend_id = ; {code} ) > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > at > org.apache.cassandra.db.compaction.CompactionManager$8.runMayThrow(CompactionManager.java:606) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at >
[jira] [Issue Comment Deleted] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hau Phan updated CASSANDRA-12215: - Comment: was deleted (was: {code} hau@cqlsh:adsfadfafd> select * from friendships_by_owner ; owner_id | friend_id| username | created_at | friend_status | friend_username | status | temp_friend --+--+--+--+---+-+--+- 0533a340-4d36-11e6-8fb9-53ec422f025f | 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | nothau | 2016-07-18 22:23:22+ | accepted | haunot | accepted |null 0533a340-4d36-11e6-8fb9-53ec422f025f | ec08f3de-4d35-11e6-ada9-39e33de03af2 | nothau | 2016-07-18 22:23:09+ | accepted | hau | accepted |null ec08f3de-4d35-11e6-ada9-39e33de03af2 | 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | hau | 2016-07-18 22:23:12+ | accepted | haunot | accepted |null ec08f3de-4d35-11e6-ada9-39e33de03af2 | 0533a340-4d36-11e6-8fb9-53ec422f025f | hau | 2016-07-18 22:23:09+ | accepted | nothau | accepted |null 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | 0533a340-4d36-11e6-8fb9-53ec422f025f | haunot | 2016-07-18 22:23:22+ | accepted | nothau | accepted |null 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | ec08f3de-4d35-11e6-ada9-39e33de03af2 | haunot | 2016-07-18 22:23:12+ | accepted | hau | accepted |null (6 rows) hau@cqlsh:adsfadfafd> DELETE FROM friendships_by_owner WHERE owner_id = 0533a340-4d36-11e6-8fb9-53ec422f025f AND friend_id = ec08f3de-4d35-11e6-ada9-39e33de03af2; hau@cqlsh:adsfadfafd> DELETE FROM friendships_by_owner WHERE owner_id = ec08f3de-4d35-11e6-ada9-39e33de03af2 AND friend_id = 0533a340-4d36-11e6-8fb9-53ec422f025f; hau@cqlsh:adsfadfafd> select * from friendships_by_owner ; owner_id | friend_id| username | created_at | friend_status | friend_username | status | temp_friend --+--+--+--+---+-+--+- 0533a340-4d36-11e6-8fb9-53ec422f025f | 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | nothau | 2016-07-18 22:23:22+ | accepted | haunot | accepted |null ec08f3de-4d35-11e6-ada9-39e33de03af2 | null | hau | null | null |null | null |null 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | 0533a340-4d36-11e6-8fb9-53ec422f025f | haunot | 2016-07-18 22:23:22+ | accepted | nothau | accepted |null (3 rows) {code}) > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) >
[jira] [Commented] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15383195#comment-15383195 ] Hau Phan commented on CASSANDRA-12215: -- {code} hau@cqlsh:adsfadfafd> select * from friendships_by_owner ; owner_id | friend_id| username | created_at | friend_status | friend_username | status | temp_friend --+--+--+--+---+-+--+- 0533a340-4d36-11e6-8fb9-53ec422f025f | 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | nothau | 2016-07-18 22:23:22+ | accepted | haunot | accepted |null 0533a340-4d36-11e6-8fb9-53ec422f025f | ec08f3de-4d35-11e6-ada9-39e33de03af2 | nothau | 2016-07-18 22:23:09+ | accepted | hau | accepted |null ec08f3de-4d35-11e6-ada9-39e33de03af2 | 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | hau | 2016-07-18 22:23:12+ | accepted | haunot | accepted |null ec08f3de-4d35-11e6-ada9-39e33de03af2 | 0533a340-4d36-11e6-8fb9-53ec422f025f | hau | 2016-07-18 22:23:09+ | accepted | nothau | accepted |null 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | 0533a340-4d36-11e6-8fb9-53ec422f025f | haunot | 2016-07-18 22:23:22+ | accepted | nothau | accepted |null 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | ec08f3de-4d35-11e6-ada9-39e33de03af2 | haunot | 2016-07-18 22:23:12+ | accepted | hau | accepted |null (6 rows) hau@cqlsh:adsfadfafd> DELETE FROM friendships_by_owner WHERE owner_id = 0533a340-4d36-11e6-8fb9-53ec422f025f AND friend_id = ec08f3de-4d35-11e6-ada9-39e33de03af2; hau@cqlsh:adsfadfafd> DELETE FROM friendships_by_owner WHERE owner_id = ec08f3de-4d35-11e6-ada9-39e33de03af2 AND friend_id = 0533a340-4d36-11e6-8fb9-53ec422f025f; hau@cqlsh:adsfadfafd> select * from friendships_by_owner ; owner_id | friend_id| username | created_at | friend_status | friend_username | status | temp_friend --+--+--+--+---+-+--+- 0533a340-4d36-11e6-8fb9-53ec422f025f | 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | nothau | 2016-07-18 22:23:22+ | accepted | haunot | accepted |null ec08f3de-4d35-11e6-ada9-39e33de03af2 | null | hau | null | null |null | null |null 10c58a5c-4d36-11e6-bb31-615a3fd451c6 | 0533a340-4d36-11e6-8fb9-53ec422f025f | haunot | 2016-07-18 22:23:22+ | accepted | nothau | accepted |null (3 rows) {code} > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) >
[jira] [Commented] (CASSANDRA-12215) NullPointerException during Compaction
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15382994#comment-15382994 ] Hau Phan commented on CASSANDRA-12215: -- One thing to note, this occurs when attempting to delete a row, the owner_id and username values still exist. {code} delete from friendships_by_owner where owner_id = and friend_id = ; {code} > NullPointerException during Compaction > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > at > org.apache.cassandra.db.compaction.CompactionManager$8.runMayThrow(CompactionManager.java:606) > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at >
[jira] [Commented] (CASSANDRA-12215) Read failure in cqlsh
[ https://issues.apache.org/jira/browse/CASSANDRA-12215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15379911#comment-15379911 ] Hau Phan commented on CASSANDRA-12215: -- CREATE TABLE adsfadfafd.friendships_by_owner ( owner_id uuid, friend_id uuid, created_at timestamp, friend_status text, friend_username text, status text, temp_friend boolean, username text static, PRIMARY KEY (owner_id, friend_id) ) WITH CLUSTERING ORDER BY (friend_id DESC) 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 = 0 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'; > Read failure in cqlsh > -- > > Key: CASSANDRA-12215 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 > Project: Cassandra > Issue Type: Bug > Components: Compaction > Environment: Cassandra 3.0.8, cqlsh 5.0.1 >Reporter: Hau Phan > Fix For: 3.0.x > > > Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = > 1 and class SimpleStrategy. > Attempting to run a 'select * from ' and receiving this error: > ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation > failed - received 0 responses and 1 failures" info={'failures': 1, > 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Cassandra system.log prints this: > {code} > ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 > - Exception in thread Thread[CompactionExecutor:5,1,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) > ~[apache-cassandra-3.0.8.jar:3.0.8] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > {code} > Doing a sstabledump -d shows a few rows with the column value of > "", telling me compaction doesn't seem to be working correctly. > # nodetool compactionstats > pending tasks: 1 > attempting to run a compaction gets: > # nodetool compact > error: null > -- StackTrace -- > java.lang.NullPointerException > at > org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) > at > org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) > at > org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) > at > org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) > at >
[jira] [Created] (CASSANDRA-12215) Read failure in cqlsh
Hau Phan created CASSANDRA-12215: Summary: Read failure in cqlsh Key: CASSANDRA-12215 URL: https://issues.apache.org/jira/browse/CASSANDRA-12215 Project: Cassandra Issue Type: Bug Components: Compaction Environment: Cassandra 3.0.8, cqlsh 5.0.1 Reporter: Hau Phan Running 3.0.8 on a single standalone node with cqlsh 5.0.1, the keyspace RF = 1 and class SimpleStrategy. Attempting to run a 'select * from ' and receiving this error: ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} Cassandra system.log prints this: ERROR [CompactionExecutor:5] 2016-07-15 13:42:13,219 CassandraDaemon.java:201 - Exception in thread Thread[CompactionExecutor:5,1,main] java.lang.NullPointerException: null at org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) ~[apache-cassandra-3.0.8.jar:3.0.8] at org.apache.cassandra.db.compaction.CompactionManager$BackgroundCompactionCandidate.run(CompactionManager.java:263) ~[apache-cassandra-3.0.8.jar:3.0.8] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_65] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_65] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_65] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_65] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] Doing a sstabledump -d shows a few rows with the column value of "", telling me compaction doesn't seem to be working correctly. # nodetool compactionstats pending tasks: 1 attempting to run a compaction gets: # nodetool compact error: null -- StackTrace -- java.lang.NullPointerException at org.apache.cassandra.db.transform.UnfilteredRows.isEmpty(UnfilteredRows.java:58) at org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:64) at org.apache.cassandra.db.partitions.PurgeFunction.applyToPartition(PurgeFunction.java:24) at org.apache.cassandra.db.transform.BasePartitions.hasNext(BasePartitions.java:96) at org.apache.cassandra.db.compaction.CompactionIterator.hasNext(CompactionIterator.java:226) at org.apache.cassandra.db.compaction.CompactionTask.runMayThrow(CompactionTask.java:177) at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) at org.apache.cassandra.db.compaction.CompactionTask.executeInternal(CompactionTask.java:78) at org.apache.cassandra.db.compaction.AbstractCompactionTask.execute(AbstractCompactionTask.java:60) at org.apache.cassandra.db.compaction.CompactionManager$8.runMayThrow(CompactionManager.java:606) at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Since the table is pretty small, I can do a copy to, truncate the table, and copy from, and the table is fine. But my concern is if compaction fails to remove those rows, and the table will eventually be very large in a production environment, the copy, truncate, and copy will no longer be an option. -- This message was sent by Atlassian JIRA (v6.3.4#6332)