Re: decommissioning a node

2014-05-27 Thread Steven A Robenalt
Hi Tim, In case the above doesn't work, another thing to be aware of is that JMX uses 2 different ports. The initial connection to 7199 causes a second port to be opened, which is normally assigned randomly to an available and otherwise unused port above 1024. If your server has a firewall/ACL/Sec

Re: Bootstrap Timing

2014-04-25 Thread Steven A Robenalt
40GB >>>> each. Any ideas why this is happening? >>>> >>>> >>>> On Sat, Apr 19, 2014 at 9:19 PM, Phil Burress >>> > wrote: >>>> >>>>> Thank you all for your advice and good info. The node has died a >>&g

Re: nodetool hangs

2014-04-24 Thread Steven A Robenalt
There's a little-known change in the way JMX uses ports that was add to JDK7u4 which simplifies the use of JMX in a firewalled environment. The standard RMI registry port for JMX is controlled by the com.sun.management.jmxremote.port property. The change to Java 7 was to introduce the related com.

Re: Deleting column names

2014-04-21 Thread Steven A Robenalt
Is there a reason you can't use: DELETE FROM table_name WHERE s = ? AND p = ? AND o = ? AND c = ?; On Mon, Apr 21, 2014 at 6:51 PM, Eric Plowe wrote: > Also I don't think you can null out columns that are part of the primary > key after they've been set. > > > On Monday, April 21, 2014, Andrea

Re: Bootstrap Timing

2014-04-18 Thread Steven A Robenalt
netstats), > right now it appears to be running compaction and building secondary index > (according to compactionstats). Just sit and wait I guess? > > > On Fri, Apr 18, 2014 at 2:23 PM, Steven A Robenalt > wrote: > >> Looking back through this email chain, it looks like

Re: Bootstrap Timing

2014-04-18 Thread Steven A Robenalt
Looking back through this email chain, it looks like Phil said he wasn't using vnodes. For the record, we are using vnodes since we brought up our first cluster, and have not seen any issues with bootstrapping new nodes either to replace existing nodes, or to grow/shrink the cluster. We did adhere

Re: Finding cut-off points

2014-04-01 Thread Steven A Robenalt
Hi Kasper, I'd suggest taking a look at Spark, Storm, or Samza (all are Apache projects) for a possible approach. Depending on your needs and your existing infrastructure, one of those may work better than others for you. Steve On Tue, Apr 1, 2014 at 2:51 AM, Kasper Petersen wrote: > Hi, >

Re: Proposal: freeze Thrift starting with 2.1.0

2014-03-11 Thread Steven A Robenalt
I should add that I'm not trying to ignite a flame war. Just trying to understand your intentions. On Tue, Mar 11, 2014 at 6:50 PM, Steven A Robenalt wrote: > Okay, I'm officially lost on this thread. If you plan on forking Cassandra > to preserve and continue to enhance the

Re: Proposal: freeze Thrift starting with 2.1.0

2014-03-11 Thread Steven A Robenalt
Okay, I'm officially lost on this thread. If you plan on forking Cassandra to preserve and continue to enhance the Thrift interface, you would also want to add a bunch of relational features to CQL as part of that same fork? On Tue, Mar 11, 2014 at 6:20 PM, Edward Capriolo wrote: > "one of the t

Re: Handling data consistency

2014-02-25 Thread Steven A Robenalt
this is > possible to do efficiently. > > Do you have any thoughts on this? > > > /Kasper > > > On Tue, Feb 25, 2014 at 1:30 AM, Steven A Robenalt > wrote: > >> Hi Kasper, >> >> I am assuming that your friend list is symmetric (i.e. If I am your >

Re: Handling data consistency

2014-02-24 Thread Steven A Robenalt
Hi Kasper, I am assuming that your friend list is symmetric (i.e. If I am your friend then you are also my friend), which your comments seem to indicate. First, I would suggest that you drop the friends score as a part of the clustering key, which eliminates the need to read-before-write. With t

Re: Is it possible to set a counter to zero using CQL?

2014-02-12 Thread Steven A Robenalt
Hi Jacob, I get the same effect using: update mytable set count = count + 0 where day = "20140103" The count field is changed from null to zero as a result. Steve On Wed, Feb 12, 2014 at 6:31 PM, Jacob Rhoden wrote: > Hi Guys, > My question is probably best described by example. Is it poss

Re: Cassandra 2.0 with Hadoop 2.x?

2014-02-06 Thread Steven A Robenalt
I am as well. Thanks, Steve On Thu, Feb 6, 2014 at 4:13 PM, Alex Popescu wrote: > > On Thu, Feb 6, 2014 at 3:50 PM, Clint Kelly wrote: > >> I can >> post a link if anyone is curious (once it is done). >> > > I'm curious... thanks > > > -- > > :- a) > > > @al3xandru > -- Steve Robenalt So

Re: Periodic rpc_timeout errors on select query

2014-02-05 Thread Steven A Robenalt
ntion of those > timeouts under earlier 2.x versions and really hoped they were the source > of our problem but unfortunately that doesn't seem to be the case. > > Thanks again, > Chap > > > On 5 Feb 2014, at 17:49, Steven A Robenalt wrote: > > Hi Chap, >> >

Re: Periodic rpc_timeout errors on select query

2014-02-05 Thread Steven A Robenalt
Hi Chap, You don't indicate which version of Cassandra and what client side driver you are using, but I have seen the same behavior with Cassandra 2.0.2 and earlier versions of the Java Driver. With Cassandra 2.0.3 and the 2.0.0rc2 driver, my read timeouts are basically nonexistent at my current l

Re: Assistence required to find Apache-Cassandra-2.0.4 version supported cassandra-jdbc jar

2014-01-24 Thread Steven A Robenalt
x driver ( > https://github.com/datastax/java-driver) source and created jar ,but no > luck. > > Where can we found pre compiled Jar which is suitable for Apache > Cassandra 2.0.4 version. > > > Regards, > Chiru > > On 25-Jan-2014, at 1:15 AM, Steven A Robenalt

Re: Assistence required to find Apache-Cassandra-2.0.4 version supported cassandra-jdbc jar

2014-01-24 Thread Steven A Robenalt
Hi Chiru, I would recommend that you consider building your Java application around CQL3 and the Datastax Java Driver instead. While a JDBC driver gives a familiar interface, it doesn't give you access to the full power of Cassandra. If you really want to use JDBC, you may be better off with an ac

Re: Read/Write consistency issue

2014-01-10 Thread Steven A Robenalt
ite) are actually very likely to be a >> great fit for this, but they still won't have TTL. That, however, could >> easily be worked around, IMO. It would just require a bit of housekeeping >> to keep track of your counters and lazily delete them. >> >> But yes, I third

Re: Read/Write consistency issue

2014-01-10 Thread Steven A Robenalt
n knowing more on why read-before-write is an anti-pattern. > In the next month or so, I intend to use Cassandra as a doc store. One very > common operation will be to read the document, make a change, and write it > back. These would be interactive users modifying their own documents, so >

Re: Read/Write consistency issue

2014-01-10 Thread Steven A Robenalt
My understanding is that it's generally a Cassandra anti-pattern to do read-before-write in any case, not just because of this issue. I'd agree with Robert's suggestion earlier in this thread of writing each update independently and aggregating on read. Steve On Fri, Jan 10, 2014 at 2:35 PM, Ro

Re: Broken pipe with Thrift

2013-12-24 Thread Steven A Robenalt
gt; One question, which is confusing , it's a server side issue or client side? > > -Vivek > > > > > On Tue, Dec 24, 2013 at 12:30 PM, Vivek Mishra wrote: > >> Hi Steven, >> Thanks for your reply. We are using version 1.2.9. >> >> -Vivek &g

Re: Broken pipe with Thrift

2013-12-23 Thread Steven A Robenalt
Hi Vivek, Which release are you using? We had an issue with 2.0.2 that was solved by a fix in 2.0.3. On Mon, Dec 23, 2013 at 10:47 PM, Vivek Mishra wrote: > Also to add. It works absolutely fine on single node. > > -Vivek > > > On Tue, Dec 24, 2013 at 12:15 PM, Vivek Mishra wrote: > >> Hi, >> I

Re: Cassandra 2.0.2 - Frequent Read timeouts and delays in replication on 3-node cluster in AWS VPC

2013-11-21 Thread Steven A Robenalt
/CASSANDRA-6299 I built and deployed a 2.0.3 snapshot this morning, which includes this fix, and my cluster is now behaving normally (no read timeouts so far). On Tue, Nov 19, 2013 at 4:55 PM, Steven A Robenalt wrote: > It seems that with NTP properly configured, the replication is now working &

Re: Cassandra 2.0.2 - Frequent Read timeouts and delays in replication on 3-node cluster in AWS VPC

2013-11-19 Thread Steven A Robenalt
It seems that with NTP properly configured, the replication is now working as expected, but there are still a lot of read timeouts. The troubleshooting continues... On Tue, Nov 19, 2013 at 8:53 AM, Steven A Robenalt wrote: > Thanks Michael, I will try that out. > > > On Tue, Nov 1

Re: Cassandra 2.0.2 - Frequent Read timeouts and delays in replication on 3-node cluster in AWS VPC

2013-11-19 Thread Steven A Robenalt
Thanks Michael, I will try that out. On Tue, Nov 19, 2013 at 5:28 AM, Laing, Michael wrote: > We had a similar problem when our nodes could not sync using ntp due to > VPC ACL settings. -ml > > > On Mon, Nov 18, 2013 at 8:49 PM, Steven A Robenalt > wrote: > >> Hi al

Cassandra 2.0.2 - Frequent Read timeouts and delays in replication on 3-node cluster in AWS VPC

2013-11-18 Thread Steven A Robenalt
Hi all, I am attempting to bring up our new app on a 3-node cluster and am having problems with frequent read timeouts and slow inter-node replication. Initially, these errors were mostly occurring in our app server, affecting 0.02%-1.0% of our queries in an otherwise unloaded cluster. No exceptio