Re: Repair Hangs while requesting Merkle Trees

2015-11-11 Thread daemeon reiydelle
Have you checked the network statistics on that machine? (netstats -tas) while attempting to repair ... if netstats show ANY issues you have a problem. If you can put the command in a loop running every 60 seconds for maybe 15 minutes and post back? Out of curiousity, how many remote DC nodes are

Re: Repair Hangs while requesting Merkle Trees

2015-11-11 Thread Anuj Wadehra
Hi, we are using 2.0.14. We have 2 DCs at remote locations with 10GBps connectivity.We are able to complete repair (-par -pr) on 5 nodes. On only one node in DC2, we are unable to complete repair as it always hangs. Node sends Merkle Tree requests, but one or more nodes in DC1 (remote) never sho

Repair Hangs while requesting Merkle Trees

2015-11-11 Thread Anuj Wadehra
Hi, We have 2 DCs at remote locations with 10GBps connectivity.We are able to complete repair (-par -pr) on 5 nodes. On only one node in DC2, we are unable to complete repair as it always hangs. Node sends Merkle Tree requests, but one or more nodes in DC1 (remote) never show that they sent the

Timeout with static column

2015-11-11 Thread Brice Figureau
Hi, Following my previous Read query timing out, I'm now running in another timeout issue, on cassandra 2.1.11. Still with the same schema from the Akka Persistence Cassandra journal: CREATE TABLE akka.messages ( persistence_id text, partition_nr bigint, sequence_nr bigint, messa

Re: UnknownColumnFamily exception / schema inconsistencies

2015-11-11 Thread Maciek Sakrejda
On Wed, Nov 11, 2015 at 9:55 AM, Sebastian Estevez < sebastian.este...@datastax.com> wrote: > Stupid question, but how do I find the problem table? The error message >> complains about a keyspace (by uuid); I haven't seen errors relating to a >> specific table. I've poked around in the data direct

Re: Multi-column slice restrictions not respected by the returned result

2015-11-11 Thread Tyler Hobbs
Correct, it's a full tuple comparison. On Wed, Nov 11, 2015 at 1:43 PM, Yuri Shkuro wrote: > Thanks, Tyler. > > I also realized that I misunderstood multi-column restriction. Evidently, > (a, b) > (x, y) does not imply component-wise restriction (a>x && b>y) in > CQL, it only implies full tuple

Re: Multi-column slice restrictions not respected by the returned result

2015-11-11 Thread Yuri Shkuro
Thanks, Tyler. I also realized that I misunderstood multi-column restriction. Evidently, (a, b) > (x, y) does not imply component-wise restriction (a>x && b>y) in CQL, it only implies full tuple comparison. That explains why my condition (a, b) > (2, 10) was matching row (2, 11). On Wed, Nov 11,

Re: Multi-column slice restrictions not respected by the returned result

2015-11-11 Thread Tyler Hobbs
This is a known problem with multi-column slices and mixed ASC/DESC clustering orders. See https://issues.apache.org/jira/browse/CASSANDRA-7281 for details. On Tue, Nov 10, 2015 at 11:02 PM, Yuri Shkuro wrote: > According to this blog: > http://www.datastax.com/dev/blog/a-deep-look-to-the-cql-w

Re: UnknownColumnFamily exception / schema inconsistencies

2015-11-11 Thread Sebastian Estevez
> > Stupid question, but how do I find the problem table? The error message > complains about a keyspace (by uuid); I haven't seen errors relating to a > specific table. I've poked around in the data directory, but I'm not sure > what I'm looking for. Is the message complaining about a *keyspace*

Re: UnknownColumnFamily exception / schema inconsistencies

2015-11-11 Thread Maciek Sakrejda
On Tue, Nov 10, 2015 at 3:20 PM, Sebastian Estevez < sebastian.este...@datastax.com> wrote: > #1 The cause of this problem is a CREATE TABLE statement collision. Do not > generate tables > dynamically from multiple clients, even with IF NOT EXISTS. First thing you > need to do is > fix your code

Re: scylladb

2015-11-11 Thread Carlos Rolo
Sure! I have a lot of blog post on backlog to blog asap about this, otherwise I would only share results mid 2016 :P Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: @cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo

Re: scylladb

2015-11-11 Thread Dani Traphagen
Killer, @cjrolo. Will you update via this thread? On Wed, Nov 11, 2015 at 7:57 AM, Carlos Rolo wrote: > Not yet, but not far from doing it. No rain here yet! :) > > On a more serious tone, should be done before end of the Month. > > -- > > > > -- [image: datastax_logo.png]

Re: scylladb

2015-11-11 Thread Carlos Rolo
Not yet, but not far from doing it. No rain here yet! :) On a more serious tone, should be done before end of the Month. -- --

Re: scylladb

2015-11-11 Thread Carlos Alonso
Any update about this? @Carlos Rolo, did you tried it? Thoughts? Carlos Alonso | Software Engineer | @calonso On 5 November 2015 at 14:07, Carlos Rolo wrote: > Something to do on a expected rainy weekend. Thanks for the information. > > Regards, > > Carlos Juzarte

Re: Cassandra compaction stuck? Should I disable?

2015-11-11 Thread Sebastian Estevez
Use 'nodetool compactionhistory' all the best, Sebastián On Nov 11, 2015 3:23 AM, "PenguinWhispererThe ." < th3penguinwhispe...@gmail.com> wrote: > Does compactionstats shows only stats for completed compactions (100%)? It > might be that the compaction is running constantly, over and over again

答复: org.apache.cassandra.net.OutboundTcpConnection.run(OutboundTcpConnection.java:218 throws java.lang.AssertionError

2015-11-11 Thread 李建奇
Hello, Reading more codes. I can reproduce the exception. Over long slice parameter can cause the exception. Code : char[] chs = new char[7]; //over 64k Arrays.fill(chs,'b'); String end = String.valueOf(chs); Composite c2 = nameType.make(new Object[] {2, end ,11}); Colu

Re: Cassandra compaction stuck? Should I disable?

2015-11-11 Thread PenguinWhispererThe .
Does compactionstats shows only stats for completed compactions (100%)? It might be that the compaction is running constantly, over and over again. In that case I need to know what I might be able to do to stop this constant compaction so I can start a nodetool repair. Note that there is a lot of