Re: Left Cassandra mailing list

2016-08-02 Thread Mohammad Kermani
Thank you guys :) I hope I can join again. On Tue, Aug 2, 2016 at 11:11 AM Andrey Ilinykh wrote: > > To remove your address from the list, send a message to: > > > On Mon, Aug 1, 2016 at 11:29 PM, Mohammad Kermani <98kerm...@gmail.com> > wrote: > >> How can I leave Cassandra mailing list? >

question when using SASI indexing

2016-08-02 Thread George Webster
Hey guys and gals, I am having a strange issue with Cassandra SASI and I was hoping you could help solve the mystery. My issue is inconsistency between returned results and strange log errors. The biggest issue is that when I perform a query I am getting back inconsistent results. First few times

Re: question when using SASI indexing

2016-08-02 Thread DuyHai Doan
Hello George Can you provide more details ? 1) Cassandra version 2) CREATE CUSTOM INDEX statement for your index 3) Consistency level used for your SELECT 4) Replication factor 5) Are you creating the index when the table is EMPTY or have you created the index when the table already contains some

Re: duplicate values for primary key

2016-08-02 Thread Romain Hardouin
Just to know, did you get some errors during the nodetool upgradesstables? Romain Le Mardi 2 août 2016 8h40, Julien Anguenot a écrit : Hey Oskar, I would comment and add all possible information to that Jira issue…    J.  --Julien Anguenot (@anguenot) On Aug 2, 2016, at 8:36 AM, Oskar K

Re: Set up authentication on a live production cluster

2016-08-02 Thread DuyHai Doan
Thank you Sean for the excellent and details explanation, a lot of people out there start their Cassandra in production without security and wake up some days, too late On Wed, Apr 13, 2016 at 10:54 PM, wrote: > Do the clients already send the credentials? That is the first thing to > address. >

Re: Set up authentication on a live production cluster

2016-08-02 Thread Jai
I have done it in production without downtime on apache cassandra by manipulating the user creation using iptables on first node. Sent from my iPhone > On Aug 2, 2016, at 9:11 PM, DuyHai Doan wrote: > > Thank you Sean for the excellent and details explanation, a lot of people out > there star

Re: question when using SASI indexing

2016-08-02 Thread George Webster
Hey DuyHai, Thank you for your help. 1) Cassandra version [cqlsh 5.0.1 | Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4] 2) CREATE CUSTOM INDEX statement for your index CREATE CUSTOM INDEX objects_mime_idx ON test.objects (mime) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTION

Re: Cassandra: The Definitive Guide, 2nd Edition

2016-08-02 Thread James Carman
Congrats, Jeff! I'll definitely check it out. On Tue, Aug 2, 2016 at 12:36 PM Jeff Carpenter < jeff.carpen...@choicehotels.com> wrote: > Hello > > I’m excited to announce that the 2nd edition of Cassandra: The Definitive > Guide is now available from O’Reilly Media. > http://shop.oreilly.com/pro

Cassandra: The Definitive Guide, 2nd Edition

2016-08-02 Thread Jeff Carpenter
Hello I'm excited to announce that the 2nd edition of Cassandra: The Definitive Guide is now available from O'Reilly Media. http://shop.oreilly.com/product/0636920043041.do. If you've been around the community for awhile, you're probably familiar with Eben Hewitt's 1st edition. When released i

Re: question when using SASI indexing

2016-08-02 Thread DuyHai Doan
One possible explanation is that you're querying data while the index files are being built so that the result are different The second possible explanation is the consistency level. Try the query again using CL = QUORUM, try on several nodes to see if the results are different On Tue, Aug 2, 20

Re: Set up authentication on a live production cluster

2016-08-02 Thread Sam Tunnicliffe
> > However, the actual keyspace (system_auth) and tables are not created > until the last node is restarted with the parameters changed Actually, this is not strictly true. On 2.2+ the tables in system_auth are created up front, regardless of the auth config. Practically you can't go about setti

Re: Cassandra: The Definitive Guide, 2nd Edition

2016-08-02 Thread Rakesh Kumar
I have this book thru early release program by O'Reilly. It is a must-have book for those who want to learn how C* works under the hood.

sstabledump / sstableverify not in ddc 3.7.0

2016-08-02 Thread Jesse Hodges
Greetings, I have recently installed ddc/ddc-tools from the deb packages here - http://debian.datastax.com/datastax-ddc/pool/, but have found that sstabledump is not included in the packages. I found the following issue that seems to address it for versions 2.2.7, 3.0.6, 3.6, so I'd think it shoul

Re: duplicate values for primary key

2016-08-02 Thread Jesse Hodges
Nope - I went through the logs on all nodes they look good to me - no logged ERROR messages or exceptions. -Jesse On Tue, Aug 2, 2016 at 10:25 AM, Romain Hardouin wrote: > Just to know, did you get some errors during the nodetool upgradesstables? > > Romain > > > Le Mardi 2 août 2016 8h40, Juli

RE: Set up authentication on a live production cluster

2016-08-02 Thread SEAN_R_DURITY
Thanks for the updates on later versions. My experience on authentication was mostly 1.1 – 2.0. I am glad that it is improving a bit. However, it does seem that it is still wise to start rings with authentication on to avoid this activation procedure. Sean Durity From: li...@beobal.com [mailt

Re: question when using SASI indexing

2016-08-02 Thread George Webster
The indexes were written about 1-2 months ago. No data has been added to the servers since the indexes were created. Additionally, the indexes appeared to be stable until I noticed the issue today. ... which occurred after a made a large query without setting a LIMIT I set the consistency level an

Re: Switching to Vnodes

2016-08-02 Thread cass savy
Thanks Jeff for detailed clarifications. We tried rebuild data in Spark DC nodes one node at a time in May again but ran into issues. prod has 3 DC, DC1(9 nodes) and DC2 (9 nodes) are only C* and DC3 has spark with 3 nodes and vnodes enabled with numtokens=32 We also dropped few unused indexes.

Memory leak and lockup on our 2.2.7 Cassandra cluster.

2016-08-02 Thread Kevin Burton
We have a 60 node CS cluster running 2.2.7 and about 20GB of RAM allocated to each C* node. We're aware of the recommended 8GB limit to keep GCs low but our memory has been creeping up (probably) related to this bug. Here's what we're seeing... if we do a low level of writes we think everything g

Re: Memory leak and lockup on our 2.2.7 Cassandra cluster.

2016-08-02 Thread Kevin Burton
I have a theory as to what I think is happening here. There is a correlation between the massive content all at once, and our outags. Our scheme uses large buckets of content where we write to a bucket/partition for 5 minutes, then move to a new one. This way we can page through buckets. I thin