Re: Bootstrapping Question for Cassandra 2.0

2016-04-19 Thread Carlos Alonso
It will be possible after the tokens reassignment has finished. Actually Cassandra itself will tell you. If you try the remove command and is not possible it will fail with an error indicating that the operation is not possible while there are nodes in Joining status. Regards Carlos Alonso | Sof

Re: Proper use of COUNT

2016-04-19 Thread Sylvain Lebresne
> > > Accept for relatively small or narrow queries, it seems to have a > propensity for timing out. > For recent enough version of C*, it shouldn't since it pages internally (it will be slow and as always be, but it shouldn't time out if some decent page size is used, which should be the default)

A few misbehaving nodes

2016-04-19 Thread Erik Forsberg
Hi! I have this problem where 3 of my 84 nodes misbehave with too long GC times, leading to them being marked as DN. This happens when I load data to them using CQL from a hadoop job, so quite a lot of inserts at a time. The CQL loading job is using TokenAwarePolicy with fallback to DCAwareR

Re: A few misbehaving nodes

2016-04-19 Thread sai krishnam raju potturi
hi; do we see any hung process like Repairs on those 3 nodes? what does "nodetool netstats" show?? thanks Sai On Tue, Apr 19, 2016 at 8:24 AM, Erik Forsberg wrote: > Hi! > > I have this problem where 3 of my 84 nodes misbehave with too long GC > times, leading to them being marked as DN. >

Re: Proper use of COUNT

2016-04-19 Thread Jack Krupansky
Thanks for that clarification, Sylvain. 1. Another clarification: All of the aggregate functions, AVG, SUM, MIN, MAX are in exactly the same boat as COUNT, right? 2. Is the paging for COUNT, et al, done within the coordinator node? 3. Does dedupe on the coordinator node consume memory proportion

Discrepancy while paging through table, and static column updated inbetween

2016-04-19 Thread Siddharth Verma
Hi, We are using cassandra(dsc3.0.3) on production. For some purpose, we were doing a full table scan (setPagingState and getPagingState used on ResultSet in java program), and there has been some discrepancy when we ran the same job multiple times. Each time some new data was added to the output

Re: Traffic inconsistent across nodes

2016-04-19 Thread Eric Stevens
Glad that worked out, that was going to be my next suspicion, since everything thought it was up and happy, I can't think of a way that Cassandra and the driver could both consider the cluster happy if some nodes were not transmitting at least some data (they have to at least for gossip). On Mon,

Re: Proper use of COUNT

2016-04-19 Thread Tyler Hobbs
On Tue, Apr 19, 2016 at 9:51 AM, Jack Krupansky wrote: > > 1. Another clarification: All of the aggregate functions, AVG, SUM, MIN, > MAX are in exactly the same boat as COUNT, right? > Yes. > > 2. Is the paging for COUNT, et al, done within the coordinator node? > Yes. > > 3. Does dedupe o

Re: Proper use of COUNT

2016-04-19 Thread Jack Krupansky
Thanks, Tyler. "Deduping (i.e. normal conflict resolution) happens per-page" Are the queries sent from the coordinator to other nodes sequencing through partitions in token order and that's what allows the coordinator to dedupe with just a single page at a time? IOW, if a target node responds wit

Re: Proper use of COUNT

2016-04-19 Thread Tyler Hobbs
On Tue, Apr 19, 2016 at 11:32 AM, Jack Krupansky wrote: > > Are the queries sent from the coordinator to other nodes sequencing > through partitions in token order and that's what allows the coordinator to > dedupe with just a single page at a time? IOW, if a target node responds > with a row fro

Re: Discrepancy while paging through table, and static column updated inbetween

2016-04-19 Thread Tyler Hobbs
This sounds similar to https://issues.apache.org/jira/browse/CASSANDRA-10010, but that only affected 2.x. Can you open a Jira ticket with your table schema, the problematic query, and the details you posted here? On Tue, Apr 19, 2016 at 10:25 AM, Siddharth Verma < verma.siddha...@snapdeal.com> wr

nodetool -h fails Connection refused

2016-04-19 Thread Alaa Zubaidi (PDF)
Hi, I am trying to run nodetool remotely. but its not working: I am running Cassandra 2.2.5 on CentOS 6. listen_address: is set to rpc_address: is set to 0.0.0.0 broadcast_rpc_address: is set to I changed the following in cassadnra-env.sh JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=" -Dcom.s

Re: Proper use of COUNT

2016-04-19 Thread Jack Krupansky
Sylvain & Tyler, this Jira is for a user reporting a timeout for SELECT COUNT(*) using 3.3: https://issues.apache.org/jira/browse/CASSANDRA-11566 I'll let one of you guys follow up on that. I mean, I thought it was timing out die to the amount of data, but you guys are saying that paging should ma

Re: Bootstrapping Question for Cassandra 2.0

2016-04-19 Thread Mir Tanvir Hossain
Thank you Carlos. -Mir On Tue, Apr 19, 2016 at 2:08 AM, Carlos Alonso wrote: > It will be possible after the tokens reassignment has finished. > > Actually Cassandra itself will tell you. If you try the remove command and > is not possible it will fail with an error indicating that the operatio

Re: Proper use of COUNT

2016-04-19 Thread Jack Krupansky
BTW, I did notice this Jira for setting a client timeout for cqlsh, so maybe this is the culprit for that user: CASSANDRA-7516 - Configurable client timeout for cqlsh https://issues.apache.org/jira/browse/CASSANDRA-7516 Or, should they actually be using the --request-timeout command line option f

Re: Proper use of COUNT

2016-04-19 Thread DuyHai Doan
Jack, you should have a look at my blog post, I did some testing with various value for paging using aggregate functions: http://www.doanduyhai.com/blog/?p=2015 On Tue, Apr 19, 2016 at 10:23 PM, Jack Krupansky wrote: > BTW, I did notice this Jira for setting a client timeout for cqlsh, so > mayb

Optional TLS CQL Encryption

2016-04-19 Thread Jason J. W. Williams
Hey Guys, Is there a way to make TLS encryption optional for the CQL listener? We'd like to be able to use for remote management connections but not for same datacenter usage (since the build/up tear down cost is too high for things that don't use pools). Right now it appears if we enable encryp

Cassandra 2.0.x OOM during bootstrap

2016-04-19 Thread Michael Fong
Hi, all, We have recently encountered a Cassandra OOM issue when Cassandra is brought up sometimes (but not always) in our 4-node cluster test bed. After analyzing the heap dump, we could find the Internal-Response thread pool (JMXEnabledThreadPoolExecutor) is filled with thounds of 'org.apach

Re: Cassandra causing OOM Killer to strike on new cluster running 3.4

2016-04-19 Thread Satoshi Hikida
Hi, I'm looking forward to a patch (file) for this bug(CASSANDRA-11344) to apply C* version 2.2.5. Is there available patch for that version? I watched link(https://issues.apache.org/jira/browse/CASSANDRA-11344) but couldn't find patch file or something like that. Or is there any workaround to a

Re: Optional TLS CQL Encryption

2016-04-19 Thread Ben Bromhead
Hi Jason If you enable encryption it will be always on. Optional encryption is generally a bad idea (tm). Also always creating a new session every query is also a bad idea (tm) even without the minimal overhead of encryption. If you are really hell bent on doing this you could have a node that is