simple data movement ?

Hi all, I have set up a test environment with C* 2.1.2, wanting to test our applications against it. I currently have C* 1.2.9 in production and want to use that data for testing. What would be a good approach for simply taking a copy of the production data and moving it into the test env and havi

Re: simple data movement ?

. If your IP addresses are different between test and prod, follow https://engineering.eventbrite.com/changing-the-ip-address-of-a-cassandra-node-with-auto_bootstrapfalse/ On 18 December 2014 at 09:10, Langston, Jim mailto:jim.langs...@dynatrace.com>> wrote: Hi all, I have set up a test

db file missing error

Hi all, When I run nodetool repair, I'm getting an error that indicates that several of the Data.db files are missing. Is there a way to correct this error ? The files that the error message is referencing are indeed missing, I'm not sure why it is looking for them to begin with. AFAIK nothing has

Re: db file missing error

Found it, had a second repair running which was generating the error. Jim From: "Langston, Jim" mailto:jim.langs...@compuware.com>> Reply-To: mailto:user@cassandra.apache.org>> Date: Thu, 14 Nov 2013 18:34:19 + To: "user@cassandra.apache.org<mailto:user@cassa

Re: cassandra woes ----- why cant cassandra work with the outside world with port 9160

The port isn't open to the outside, only to the localhost tcp0 0 ip6-localhost:9160 *:* LISTEN you should see something like: tcp0 0 0.0.0.0:91600.0.0.0:* LISTEN 20480/jsvc.exec Jim From: David Montgomery mail

Re: Cassandra 2 Upgrade

Hi Rob, Did you every create this blog post ? Jim From: Robert Coli mailto:rc...@eventbrite.com>> Reply-To: mailto:user@cassandra.apache.org>> Date: Wed, 11 Sep 2013 10:38:58 -0700 To: "user@cassandra.apache.org" mailto:user@cassandra.apache.org>> Subject: Re:

alter column family ?

Hi all, I am trying to alter a column family to change gc_grace_seconds, and now, any of the properties The sequence: use ks ; alter table CF with gc_grace_seconds=864000 ; When listing the CF, gc_grace_seconds is set to 0, after running the CLI, gc_grace_seconds is still set to 0. I tried cha

Re: alter column family ?

e.org>> Subject: Re: alter column family ? On Tue, Jul 9, 2013 at 10:08 AM, Langston, Jim mailto:jim.langs...@compuware.com>> wrote: I am trying to alter a column family to change gc_grace_seconds, and now, any of the properties The sequence: use ks ; alter table CF with g

Re: alter column family ?

On the command (4 node cluster): nodetool gossipinfo -h localhost |grep SCHEMA |sort | uniq -c | sort -n 4 SCHEMA:60edeaa8-70a4-3825-90a5-d7746ffa8e4d On the second part, I have the same Cassandra version in staging and production, with staging being a smaller cluster. Not sure what you m

Re: alter column family ?

ilto:user@cassandra.apache.org>> Subject: Re: alter column family ? On Tue, Jul 9, 2013 at 11:52 AM, Langston, Jim mailto:jim.langs...@compuware.com>> wrote: > > On the command (4 node cluster): > > nodetool gossipinfo -h localhost |grep SCHEMA |sort | uniq -c | sort -n >

Re: alter column family ?

ilto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: alter column family ? On Thu, Jul 11, 2013 at 9:17 AM, Langston, Jim mailto:jim.langs...@compuware.com>> wrote: Are the schema's held somewhere else ? Going through the process that you sent, when I r

Re: alter column family ?

ndra.apache.org>> Subject: Re: alter column family ? On Thu, Jul 11, 2013 at 10:16 AM, Langston, Jim mailto:jim.langs...@compuware.com>> wrote: It feels like the 2 node that are not coming up with the right schema are not seeing the nodes with the correct ones. At the time that the n

Re: alter column family ?

t; Reply-To: mailto:user@cassandra.apache.org>> Date: Thu, 11 Jul 2013 11:07:55 -0700 To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: alter column family ? On Thu, Jul 11, 2013 at 11:00 AM, Langston, Jim mailt

sstable size ?

Hi all, Is there a way to get an SSTable to a smaller size ? By this I mean that I currently have an SSTable that is nearly 1.2G, so that subsequent SSTables when they compact are trying to grow to that size. The result is that when the min_compaction_threshold reaches it value and a compaction is

Re: sstable size ?

as in there about splitting up a large SSTable. http://www.mail-archive.com/user@cassandra.apache.org/msg30956.html On 07/17/2013 04:17 PM, Langston, Jim wrote: Hi all, Is there a way to get an SSTable to a smaller size ? By this I mean that I currently have an SSTable that is nearly 1.2G, so that

Re: alter column family ?

As a follow up – I did upgrade the cluster to 1.2.6 and that did take care of the issue. The upgrade went very smoothly, the longest part was being thorough on the configuration files, but I was able to able to quickly update the schema's after restarting the cluster. Jim From: "Lan

Re: sstable size ?

it somewhere safe ? Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 18/07/2013, at 2:20 PM, "Langston, Jim" mailto:jim.langs...@compuware.com>> wrote: Thanks, this does look like what I'm experiencing. Can

Re: sstable size ?

. Is this something I need to get as well ? Thanks, Jim From: "Langston, Jim" mailto:jim.langs...@compuware.com>> Reply-To: mailto:user@cassandra.apache.org>> Date: Thu, 18 Jul 2013 10:28:39 + To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>&q

Re: sstable size ?

A-4766 - happy to >review). > >On Thu, Jul 18, 2013 at 1:59 PM, Langston, Jim > wrote: >> I have been looking at the stuff in the zip file, and also the >> sstablesplit command script. This script is looking for a java >> class StandaloneSplitter located in the package >>o

nodetool cfstats write count ?

Hi all, Running nodetool and looking at the cfstats output, for the counters such as write count and read count, do those numbers reflect any replication ? For instance, if write count shows 3000 and the replication factor is 3, is that really 1000 writes ? Thanks, Jim

read ?

Hi all, Quick question I currently am looking at a 4 node cluster and I have currently stopped all writing to Cassandra, with the reads continuing. I'm trying to understand the utilization of memory within the JVM. nodetool info on each of the nodes shows them all growing in footprint, 2 of the

Re: read ?

. For a true comparison I would recommend using jconsole and call dumpHeap on com.sun.management:type=HotSpotDiagnostic with the 2nd param true (force GC). Then open the heap dump up in a tool like yourkit and you will get a better comparison and also it will tell you what it is tha

moving all data to new cluster ?

Hi all, I have built a new 4 node cluster and would like to move the data from the current 2 node cluster to the new cluster. What would be the best way to move the data and utilize it on the new cluster. I have looked at snapshot and also just copying the entire tree from the old cluster to the n

Re: moving all data to new cluster ?

Coli mailto:rc...@eventbrite.com>> Reply-To: mailto:user@cassandra.apache.org>> Date: Wed, 4 Sep 2013 12:44:12 -0700 To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: moving all data to new cluster ? On

cassandra error on restart

Hi all, I restarted my cassandra ring this morning, but it is refusing to start. Everything was fine, but now I get this error in the log: …. INFO 14:05:14,420 Compacting [SSTableReader(path='/raid0/cassandra/data/system/local/system-local-ic-20-Data.db'), SSTableReader(path='/raid0/cassandra

Re: cassandra error on restart

r Technologies Inc. http://adgear.com/ On 2013-09-10, at 10:09 AM, "Langston, Jim" mailto:jim.langs...@compuware.com>> wrote: Hi all, I restarted my cassandra ring this morning, but it is refusing to start. Everything was fine, but now I get this error in the log: …. INFO 14:05:14,420

cluster rename ?

Hi all, Following these instructions: http://comments.gmane.org/gmane.comp.db.cassandra.user/29753 I am trying to change the name of the cluster, but I'm getting an error: ERROR [main] 2013-09-10 17:52:43,250 CassandraDaemon.java (line 247) Fatal exception during initialization org.apache.cas