Re: Cassandra compaction stuck? Should I disable?

Hi Rob, Thanks for your reply. 2015-11-09 23:17 GMT+01:00 Robert Coli : > On Mon, Nov 9, 2015 at 1:29 PM, PenguinWhispererThe . < > th3penguinwhispe...@gmail.com> wrote: >> >> In Opscenter I see one of the nodes is orange. It seems like it's working >> on compaction. I used nodetool compactionst

Re: Cassandra compaction stuck? Should I disable?

Correction... I was grepping on Segmentation on the strace and it happens a lot. Do I need to run a scrub? 2015-11-10 9:30 GMT+01:00 PenguinWhispererThe . < th3penguinwhispe...@gmail.com>: > Hi Rob, > > Thanks for your reply. > > 2015-11-09 23:17 GMT+01:00 Robert Coli : > >> On Mon, Nov 9, 2015

Re: How to organize a timeseries by device?

Thank you for all theses details. I will do a monthly bucket. On Mon, Nov 9, 2015 at 7:58 PM, Kai Wang wrote: > bucket key is just like any column of the table, you can use any type as > long as it's convenient for you to write the query. > > But I don't think you should use 5 minute as your buc

Nested Collections in Cassandra

How can we achieve Nested Collections in cassandra. My requirement : metadata map> ... Is it possible? Eg. 'mime-type' : 'MIME' 'Security' : {'SOX','FOX'} Query will be Give me all the ID's where 'Security' : {'SOX'} OR contains 'SOX' Is it Possible? Can I use UDT to do it? Eg CQL : C

cassandra 3.0 and datastax java driver 3.0.0 beta1: unresolved user type DoubleType

Hi All, When I am trying to insert an object of the attached "table_1.png" class I've got the error: com.datastax.driver.core.exceptions.UnresolvedUserTypeException: Cannot resolve user type keyspace1."org.apache.cassandra.db.marshal.DoubleType" Could you please suggest the solution? Thank you

Re: Cassandra compaction stuck? Should I disable?

Still stuck with this. However I enabled GC logging. This shows the following: [root@myhost cassandra]# tail -f gc-1447180680.log 2015-11-10T18:41:45.516+: 225.428: [GC 2721842K->2066508K(6209536K), 0.0199040 secs] 2015-11-10T18:41:45.977+: 225.889: [GC 2721868K->2066511K(6209536K), 0.0221

Re: Cassandra compaction stuck? Should I disable?

I also have the following memory usage: [root@US-BILLINGDSX4 cassandra]# free -m total used free sharedbuffers cached Mem: 12024 9455 2569 0110 2163 -/+ buffers/cache: 7180 4844 Swap: 2047 0

Re: Cassandra compaction stuck? Should I disable?

Turn off Swap. http://docs.datastax.com/en/cassandra/2.1/cassandra/install/installRecommendSettings.html?scroll=reference_ds_sxl_gf3_2k__disable-swap All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@d

Re: Cassandra compaction stuck? Should I disable?

Hi Sebastian, Thanks for your response. No swap is used. No offense, I just don't see a reason why having swap would be the issue here. I put swapiness on 1. I also have jna installed. That should prevent java being swapped out as wel AFAIK. 2015-11-10 19:50 GMT+01:00 Sebastian Estevez : > Tur

UnknownColumnFamily exception / schema inconsistencies

Hello, I've been having some strange issues with one of our test clusters (4-day-old, 3-node, 2.1.10 cluster on AWS). I saw a number of messages like the following: [] 10 Nov 20:21:00.406 * pri=WARN t=MessagingService-Incoming-/ 192.168.168.202 at=IncomingTcpConnection.run UnknownColumnFamil

Re: UnknownColumnFamily exception / schema inconsistencies

Oh and for what it's worth, I've also looked through the logs for this node, and the oldest error in the logs seems to be: [] 06 Nov 22:10:53.260 * pri=ERROR t=Thrift:16 at=CustomTThreadPoolServer.run Error occurred during processing of message. java.lang.RuntimeException: java.util.concurrent

Re: UnknownColumnFamily exception / schema inconsistencies

#1 The cause of this problem is a CREATE TABLE statement collision. Do not generate tables dynamically from multiple clients, even with IF NOT EXISTS. First thing you need to do is fix your code so that this does not happen. Just create your tables manually from cqlsh allowing time for the schema t

Multi-column slice restrictions not respected by the returned result

According to this blog: http://www.datastax.com/dev/blog/a-deep-look-to-the-cql-where-clause I should be able to do multi-column restrictions on clustering columns, as in the blog example: WHERE (server, time) >= (‘196.8.0.0’, 12:00) AND (server, time) <= (‘196.8.255.255’, 14:00) However, I am ge