RE: Consistency Issues

No such thing as a stupid question☺ I know they exist in some nodes, but if they replicated correctly is a different story. I’m checking this one now, Ok, hooked up OpsCenter to see what it was saying, Out of the 100 keyspaces creted, 9 are missing one CF 2 are missing two CF’s 1 is missing

Re: Consistency Issues

Couple things to try. 1. nodetool resetlocalschema on the nodes with missing CFs. This will refresh the schema on the local node. 2. upgrade to 2.1.9. There are some pretty major issues in 2.1.6 (nothing specific to this problem but worth upgrading)

Re: Consistency Issues

And that's a stupid one, I know, but does the column you're trying to access actually exist? Carlos Alonso | Software Engineer | @calonso On 1 October 2015 at 11:09, Walsh, Stephen wrote: > I did think of that and they are all the same

Re: Consistency Issues

Which versions of Cassandra and OpsCenter are you using? Because probably opscenter and your app are using cql and cqlsh is using thrift or vice versa and that's why depending on where you access from you see different things? Carlos Alonso | Software Engineer | @calonso

Re: Consistency Issues

Thank you Jake. The issue is I do not have missing CF's and upgrading beyond 2.1.3 is not a possibility because of the deprecation of cql dialects. Our application is using Hector and migrating to cql3 is a huge refactoring. On 01/10/15 15:48, Jake Luciani wrote: Couple things to try. 1.

cqlsh strange inconsistency

Hello, I have a table with a status field and a secondary index on that table. Every row has 1 or -1 status values. I have these queries run from cqlsh with the results: consistency all; select count(*) from table; /** 1901 Select count(*) from table where status=1; /** 27 select count(*)

Re: Consistency Issues

Onur, was responding to Stephen's issue. On Thu, Oct 1, 2015 at 8:56 AM, Onur Yalazı wrote: > Thank you Jake. > > The issue is I do not have missing CF's and upgrading beyond 2.1.3 is not > a possibility because of the deprecation of cql dialects. Our application > is

RE: Consistency Issues

I did think of that and they are all the same version ☺ From: Carlos Alonso [mailto:i...@mrcalonso.com] Sent: 01 October 2015 10:11 To: user@cassandra.apache.org Subject: Re: Consistency Issues Hi Stephen. The UnknownColumnFamilyException made me thought of a possible schema disagreement in

RE: Consistency Issues

Thanks Jake, I’ll try test out 2.1.9 to see if it resolved the issue and ill try “nodetool resetlocalschema” now to see if it helps. Cassandra is 2.1.6 OpsCenter is 5.2.1 From: Jake Luciani [mailto:jak...@gmail.com] Sent: 01 October 2015 14:00 To: user Subject: Re:

Re: Fwd: Column family ID mismatch

Check this post & my response: http://stackoverflow.com/questions/31576180/cassandra-2-1-system-schema-missing=0CBoQFjAAahUKEwit6uK1uqHIAhXLcD4KHWsxDK8=AFQjCNFfvPld2OOInC6B_M0X_QpfqHUbxA=aLeCqqe7vhpQlL10p9WFJA On Oct 1, 2015 4:33 AM, "kedar" wrote: > Got this error

Re: Consistency Issues

You say that you don't think GC is your issue... but did you actually check? The reasons you suggest aren't very convincing. Can you provide your GC settings, and take a look at jstat --gccause? http://docs.oracle.com/javase/7/docs/technotes/tools/share/jstat.html#gccause_option On Thu, Oct

JSON Order By

Hi All , I have a question related to JSON sorting I have a below structure stored in cassandra and i would like to get the internal array sorted by a property when i select it , Please let me know if there is way to do that . I need to sort the rules Array by property ruleOrder when i select

Re: Consistency Issues

Well... I wasn't expecting that, as both OpsCenter 5.2.1 and cqlsh in Cassandra 2.1.x both use native protocol. I was expecting them having different protocols, so Have no further ideas :( Carlos Alonso | Software Engineer | @calonso On 1 October 2015 at 14:36,

RE: Consistency Issues

You're running describe with CL quorum aren't you? To see the inconsistency you'd have to check the system.schema_column family tables on each node. On Oct 1, 2015 8:07 AM, "Walsh, Stephen" wrote: > No such thing as a stupid questionJ > > I know they exist in some

Cassandra certification

Hi, Did anybody took the Cassandra (Administrator) certification on the Summit? Any feedback? How was the test? Thanks Ruben

Re: Cassandra certification

Check this out: Get Trained, Get Certified, Get Better Paid https://www.linkedin.com/pulse/get-trained-certified-better-paid-tushar-agrawal Thanks, Tushar (Sent from iPhone) > On Oct 1, 2015, at 9:00 AM, Fernandez Gomara, Ruben (CCI-Atlanta) > wrote: > > Hi, >

Re: memory usage problem of Metadata.tokenMap.tokenToHost

I confirm that the optional schema metadata feature (JAVA-828 ) has been merged upstream and is included in driver 3.0.0-alpha3 and will as well be included in the forthcoming 2.1.8 version. On a side note, JAVA-664

Re: cqlsh strange inconsistency

On Thu, Oct 1, 2015 at 5:37 AM, Onur Yalazı wrote: > What is happening? How can this situation happen? Do you have any ideas? ... > This is really strange. If I select status from the table, I see 1901 > rows with status 1 or -1. I rebuild the index and the results

RE: Cassandra certification

I took (and passed) the Admin exam at the Cassandra Summit. Tushar does hit the main points in his article. One of the conditions of the test is to not reveal details on the test, so we shouldn’t reveal anything very substantial. I will say that the exam was about the same difficulty level as

GossipingPropertyFileSnitch and nodetool info

I am using C* 2.1.9 and GossipingPropertyFileSnitch. I noticed that when I run nodetool info I am seeing the data center and rack as DC1 r1 which comes from the default entry from cassandra-topology.properties. From my understanding, this should only be used when PropertyFileSnitch is used and

Re: broadcast address on EC2 without Elastic IPs.

Hey Renato, As far as I can tell, the reason you're getting private IP addresses back is that the node you're connecting to is relaying back the way that _it_ knows where to find other nodes, which is a function of the gossip state. This is expected behavior. Mixed Private/Public IP spaces

Re: addition of nodes with auth enabled on a datacenter causes existing nodes to loose their permissions

You are seeing https://issues.apache.org/jira/browse/CASSANDRA-9519 > On Oct 1, 2015, at 9:16 PM, K F wrote: > > Hi, > > I have 3 DCs out of which in one of the DC, I added 20 nodes. All of the DCs > had auth

addition of nodes with auth enabled on a datacenter causes existing nodes to loose their permissions

Hi, I have 3 DCs out of which in one of the DC, I added 20 nodes. All of the DCs had auth enabled, it was functioning fine. But after addition of 20 nodes in one of the DC, the permissions just got messed-up on the existing nodes. My application started getting errors while querying using the

Re: Cassandra users survey

Hi Jonathan, The survey asks about "your application." We have multiple applications using Cassandra. Are you looking for information about each application separately, or the sum of all of them? Jim On Wed, Sep 30, 2015 at 2:18 PM, Jonathan Ellis wrote: > With 3.0

Fwd: Column family ID mismatch

Got this error again on a single node cassandra. Would appreciate some pointers. Forwarded Message Subject:Column family ID mismatch Date: Thu, 13 Aug 2015 20:44:04 +0530 From: kedar Reply-To: user@cassandra.apache.org To:

RE: Consistency Issues

There is no load balancer in front of Cassandra, it’s in front of our application. Everyone seems hung up on this point? But it’s not the root causing of the inconsistency issue. Can anyone verify the best practice for number of CF’s? From: Robert Coli [mailto:rc...@eventbrite.com] Sent: 30

RE: Consistency Issues

If you’re looking for the clean-up of the old gen in the jvm heap, it doesn’t happen. We have a new gen turning 15 times before its pushed to old gen. Seems all our data only has a TTL of 10 seconds – very little data is sent to the old gen. Add in heap size of 8GB with a new gen size of 2GB, I

Re: Consistency Issues

Hi Stephen. The UnknownColumnFamilyException made me thought of a possible schema disagreement in which any of your nodes has a different version and therefore you cannot reach quorum? Can you run nodetool describecluster and see if all nodes have the same schema versions? Cheers! Carlos

RE: Consistency Issues

Can you tell us how much time your gcs are taking? Do you see any especially long ones? On 1 Oct 2015 09:37, "Walsh, Stephen" wrote: > There is no load balancer in front of Cassandra, it’s in front of our > application. > > Everyone seems hung up on this point? But