Re: results differ on two queries, based on secondary index key and partition key

2017-03-29 Thread Steve Robenalt
Hi Ferit, I have implemented the follower/following relationship in a manner similar to what you describe. However, I can't tell from the description of your tables if you are using the same convention I used. The two tables I used were symmetric, as with yours, but with the ids swapped. I inserte

RE: Issue with Cassandra consistency in results

2017-03-29 Thread Durity, Sean R
There have been many instances of supposed inconsistency noted on this list if nodes do not have the same system time. Make sure you have a matching clock on all nodes (ntp or similar). Sean Durity From: Shubham Jaju [mailto:shub...@vassarlabs.com] Sent: Tuesday, March 21, 2017 9:58 PM To: use

RE: Random slow read times in Cassandra

2017-03-29 Thread Durity, Sean R
Does a later query on the same ID also behave poorly? (Or perhaps it gets cached and is fast the next time…) My first thought was that perhaps the slow records had many updates that were being read (or tombstones being read over) to assemble the record. A trace on the query with that key might r

RE: results differ on two queries, based on secondary index key and partition key

2017-03-29 Thread Durity, Sean R
This looks more like a problem for a graph-based model. Have you looked at DSE Graph as a possibility? Sean Durity From: ferit baver elhuseyni [mailto:feritba...@gmail.com] Sent: Tuesday, March 14, 2017 11:40 AM To: user@cassandra.apache.org Subject: results differ on two queries, based on secon

Re: 2.1 to 3.0 upgrade problems

2017-03-29 Thread Eric Yablonowitz
Thanks Meg! Yes, we have already identified the problematics stables (there are 2 out of ~740). They are in one of our keyspaces not in system. I’m not sure what connection request exceptions you are talking about? This? ERROR [SharedPool-Worker-3] 2017-03-28 23:50:33,998 Message.java:621 -

RE: 2.1 to 3.0 upgrade problems

2017-03-29 Thread Meg Mara
Hi Eric, I am not sure why the commit logs were growing so much but I do have some suggestions regarding the Unexpected exception during request and about upgradesstables. I had recently upgraded from 2.2.5 to 3.0.10 and faced the same issue with nodetool upgradesstables not converting all SSta

Re: /etc/init.d/cassandra for RHEL

2017-03-29 Thread I PVP
This one worked fine https://blog.tomas.cat/sites/default/files/cassandra.initd On March 29, 2017 at 2:17:17 AM, I PVP (i...@hotmail.com) wrote: i tried using the https://github.com/apache/cassandra/blob/trunk/redhat/cassandra won’t start using my own values and it

Can we get username and timestamp in cqlsh_history?

2017-03-29 Thread anuja jain
Hi, I have a cassandra cluster having a lot of keyspaces and users. I want to get the history of cql commands along with the username and the time at which the command is run. Also if we are running some commands from GUI tools like Devcenter,dbeaver, can we log those commands too? If yes, how? Th

Re: Frozen type sin cassandra.

2017-03-29 Thread anuja jain
Thanks Tyler. On Tue, Mar 7, 2017 at 10:54 PM, Tyler Hobbs wrote: > > On Sun, Mar 5, 2017 at 11:53 PM, anuja jain wrote: > >> Is there is difference between creating column of type >> frozen> and frozen where list_double is UDT of >> type frozen> ? >> > > Yes, there is a difference in serializa