Cassandra nodes in VirtualBox

Hi, I did the Cassandra cluster set up as below: Node 1 : Seed Node Node 2 Node 3 Node 4 All 4 nodes are Virtual Box VMs with Ubuntu 14.10. I have set the listen_address, rpc_address as the inet address with SimpleSnitch. When I start Node2 after Node1 is started, I get the "java.lang.RuntimeEx

Re: Cassandra nodes in VirtualBox

Hi Ajay, 1. you should have at least 2 Seed nodes as it will help, Node1 (only one seed node) is down. 2. Check you should be using internal ip address in listen_address and rpc_address. On Mon, Jan 5, 2015 at 2:07 PM, Ajay wrote: > Hi, > > I did the Cassandra cluster set up as below: > > Nod

Implications of ramping up max_hint_window_in_ms

Hi, Since repair is a slow and daunting process*, I am considering increasing max_hint_window_in_ms from its default value of one (1) hour to something like 24-48 hours. This will give me and my team more time to fix the underlying problem of a node. I understand that  - repair is the only way

Re: Cassandra nodes in VirtualBox

Neha, This is just for a trial set up. Anyway, thanks for the suggestion(more than 1 seed node). I figured out the problem. The Node2 was having the incorrect Cluster name. The error seems to be misleading though. Thanks Ajay Garga On Mon, Jan 5, 2015 at 4:21 PM, Neha Trivedi wrote: > Hi Aj

[no subject]

Hi All, I have designed a column family prodgroup text, prodid int, status int, , PRIMARY KEY ((prodgroup), prodid, status) The data model is to cater - Get list of products from the product group - get list of products for a given range of ids - Get details of a specific product -

Cassandra primary key design to cater range query

Hi All, I have designed a column family prodgroup text, prodid int, status int, , PRIMARY KEY ((prodgroup), prodid, status) The data model is to cater - Get list of products from the product group - get list of products for a given range of ids - Get details of a specific product -

deletedAt and localDeletion

Hi all, Can anyone explain what mine deletedAt and localDeletion in SliceQueryFilter log. SliceQueryFilter.java (line 225) Read 6 live and 2688 tombstoned cells in ks.mytable (see tombstone_warn_threshold). 10 columns was requested, slices=[-], delInfo={deletedAt=-9223372036854775808, localDeleti

Re:

Just an arrow in the dark: Doucment "CQL for Cassandra 2.x Documentation" informs that cassandra allows to query on a column when it is indexed. Regards, Seenu. On Mon, Jan 5, 2015 at 5:14 PM, Nagesh wrote: > Hi All, > > I have designed a column family > > prodgroup text, prodid int, status int

Re: Number of SSTables grows after repair

@Robert could you point me to some of those issues? I would be very graceful for some explanation why this is semi-expected. On Fri, Jan 2, 2015 at 8:01 PM, Robert Coli wrote: > On Mon, Dec 15, 2014 at 1:51 AM, Michał Łowicki > wrote: > >> We've noticed that number of SSTables grows radically

Re: 答复:

Better yet, if you're using a client where you can pass the time in, you can validate it is indeed clock skew. Do all your writes with timestamp = 0, all your deletes with timestamp = 1. On Wed, Dec 24, 2014 at 7:47 AM, Ryan Svihla wrote: > Every time I've heard this but one this has been clock

ttl in collections

Hi guys, I have to work with the following model: userid : text categories: [3, 4, 55, 623, ...] in my use case, the list of values is updated every day, with 100 millons of users and a total of 500 categories at most. There is a way to assign a TT to each item in the category list?

Re: ttl in collections

Hi, using the following updates i made expire the direfent values in deferent times: update categories_sync using ttl 60 set category = category + {'2'} where userid = 'u1'; update categories_sync using ttl 120 set category = category + {'3'} where userid = 'u1'; update categories_sync using

Re: Implications of ramping up max_hint_window_in_ms

On Mon, Jan 5, 2015 at 2:52 AM, Jens Rantil wrote: > Since repair is a slow and daunting process*, I am considering increasing > max_hint_window_in_ms from its default value of one (1) hour to something > like 24-48 hours. > ... > Are there any other implications of making this change that I hav

How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

Hi, All, I turned on the dbclient_encryption_options like this: client_encryption_options: enabled: true keystore: path-to-my-keystore-file keystore_password: my-keystore-password truststore: path-to-my-truststore-file truststore_password: my-truststore-password ... I can use following cassand

subscribe me on this list

-- Follow IndiaMART.com for latest updates on this and more: Mobile Channel:

Cassandra consuming whole RAM (64 G)

Hi, We are using cassandra 2.1 version in a cluster of three machines each with 64 GB RAM The processes are killed by kernel, coz they are eating all memory (oom-killer). We have set JAVA heap to default (i.e. it is using 8G) because we have 64 GB RAM. Please help. Regards: Rahul Bhardwaj --

Re: Cassandra consuming whole RAM (64 G)

Did you try generating a heap dump so you can look through it to see what’s actually happened? > On Jan 6, 2015, at 12:58 AM, Rahul Bhardwaj > wrote: > > Hi, > > We are using cassandra 2.1 version in a cluster of three machines each with > 64 GB RAM > > The processes are killed by kernel,

Re: Cassandra consuming whole RAM (64 G)

Hi Joe, PFA heap dump regards: Rahul Bhardwaj On Tue, Jan 6, 2015 at 11:35 AM, Joe Ramsey wrote: > Did you try generating a heap dump so you can look through it to see > what’s actually happened? > > > On Jan 6, 2015, at 12:58 AM, Rahul Bhardwaj > wrote: > > Hi, > > We are using cassandra

Re: Cassandra consuming whole RAM (64 G)

Hi Joe, PFB output of system.log tail -n 100 system.log INFO [CompactionExecutor:164] 2015-01-06 11:58:28,555 CompactionTask.java:251 - Compacted 4 sstables to [/var/lib/cassandra/data/clickstream/im_csl_log-22207f2081bb11e4abd4a9d4f1e0b940/clickstream-im_csl_log.im_csl_log_catalog_owner_glusr_

Re: Cassandra consuming whole RAM (64 G)

I’m not an expert. Really just learning this myself but it looks like according to the stack you’re getting an exception waiting too many bytes to the commit log. That’s controlled by commit_log_segment_size_in_mb setting. The maximum write size that C* will allow is half of the value set f

Re: Cassandra consuming whole RAM (64 G)

That should be “writing too many bytes” not “waiting too many bytes” just for clarity’s sake. > On Jan 6, 2015, at 2:03 AM, Joe Ramsey wrote: > > I’m not an expert. Really just learning this myself but it looks like > according to the stack you’re getting an exception waiting too many bytes t

Re: Cassandra consuming whole RAM (64 G)

Thanks for your response.. i will get back to you with my findings. On Tue, Jan 6, 2015 at 12:36 PM, Joe Ramsey wrote: > That should be “writing too many bytes” not “waiting too many bytes” just > for clarity’s sake. > > On Jan 6, 2015, at 2:03 AM, Joe Ramsey wrote: > > I’m not an expert. Real

Re: Cassandra consuming whole RAM (64 G)

Thanks Rahul and good luck! I’m really curious to hear what the result is. > On Jan 6, 2015, at 2:10 AM, Rahul Bhardwaj > wrote: > > Thanks for your response.. i will get back to you with my findings. > > On Tue, Jan 6, 2015 at 12:36 PM, Joe Ramsey > wrote: > That

答复: Cassandra consuming whole RAM (64 G)

Hi , There is a “possible memory leak “ issue with c* 2.1.2. https://issues.apache.org/jira/browse/CASSANDRA-8248 It happen with our c* 2.1.2 cluster . In /proc/{pid}/maps there are a lot of deleted file maps . _ Stephen li 发件人: Joe Ramsey [mailto:joe.ram...@m

Re: Implications of ramping up max_hint_window_in_ms

Thanks for input, Rob. Just making sure, is "older version" the same as "less than version 2"? On Mon, Jan 5, 2015 at 8:13 PM, Robert Coli wrote: > On Mon, Jan 5, 2015 at 2:52 AM, Jens Rantil wrote: >> Since repair is a slow and daunting process*, I am considering increasing >> max_hint_window