Updates is not happening when using the same time stamp.

2013-12-02 Thread srinivas rao
Hi Team, i am facing an issue, with updating the data with same time stamp. The column values with string type which multiple fields are delimited with |, example (1|2|3|4|5|6|). if i chage one of the field, some times its updating properly with same time stamp (column internal clock). however

Re: Updates is not happening when using the same time stamp.

2013-12-02 Thread srinivas rao
Hi Team, i am facing an issue, with updating the data with same time stamp. The column values with string type which multiple fields are delimited with |, example (1|2|3|4|5|6|). if i chage one of the field, some times its updating properly with same time stamp (column internal clock).

Repair hangs - Cassandra 1.2.10

2013-12-02 Thread Tamar Rosen
Hi, On AWS, we had a 2 node cluster with RF 2. We added 2 more nodes, then changed RF to 3 on all our keyspaces. Next step was to run nodetool repair, node by node. (In the meantime, we found that we must use CL quorum, which is affecting our application's performance). Started with node 1,

Re: Sample Trigger Code to get inserted value

2013-12-02 Thread J Ramesh Kumar
Finally I got it working... Below are the code snippet which will be useful for trigger users, public CollectionRowMutation augment(ByteBuffer key, ColumnFamily cf) { try { ByteBuffer id_bb = CompositeType.extractComponent(key, 0); UUID

Re: Updates is not happening when using the same time stamp.

2013-12-02 Thread Julien Campan
Hi, The internal timestamp is used when you try to read a row. Cassandra checks all the versions of the same row and returns the one with the most recent timestamp. If you make many writes (updates) of the same row with the same timestamp and then read it, Cassandra is not going to be able to

Configuration of multiple nodes in a single machine

2013-12-02 Thread Santosh Shet
Hi, I have requirement to setup multiple nodes to the existing single node Cassandra cluster. I am new to Cassandra and I don't have idea whether do I need to setup multiple nodes in a single machine by copying Cassandra configuration or do I require separate physical machines to create

Re: Configuration of multiple nodes in a single machine

2013-12-02 Thread Kais Ahmed
You can try https://github.com/pcmanus/ccm 2013/12/2 Santosh Shet santosh.s...@vista-one-solutions.com Hi, I have requirement to setup multiple nodes to the existing single node Cassandra cluster. I am new to Cassandra and I don’t have idea whether do I need to setup multiple nodes in

replica verification

2013-12-02 Thread chandra Varahala
Hello Team, I have cassandra cluster with 5 nodes with 1 replication factor initially. Now i changed to replication factor 3 and ran nodetool repair. Is there way i can verify that i have 3 replicas ? Thanks Chandra

Re: Data loss when swapping out cluster

2013-12-02 Thread Robert Coli
On Fri, Nov 29, 2013 at 6:36 PM, Anthony Grasso anthony.gra...@gmail.comwrote: In this case would it be possible to do the following to replace a seed node? With the quoted procedure, you are essentially just changing the ip address of a node, which will work as long as you set

Table Creation Error

2013-12-02 Thread Charlie Andrews
Hi all, When I try to create a new table, I get the following error: cqlsh:userdata CREATE TABLE f6f5e6a90a90a7ebb69d84a3d6f807 (item_id uuid PRIMARY KEY); TSocket read 0 bytes This error means nothing to me, so I check the logs that were created and I get the error, ‘Cannot modify index

Re: Cassandra shows java exceptions

2013-12-02 Thread Robert Coli
On Thu, Nov 28, 2013 at 8:47 AM, Nate McCall n...@thelastpickle.com wrote: I can reproduce this with the mx4j lib loaded by setting to max hint window to 'empty': max_hint_window_in_ms: I guess you could call this a bug, but given that it has 2 defaults, you have to explicitly set this to

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 11:51 AM, Charlie Andrews charlieandrews@gmail.com wrote: Has anyone ever seen this behavior before? No. What version of Cassandra? Easiest fix is probably to dump-and-reload schema. =Rob

Re: Table Creation Error

2013-12-02 Thread Charlie Andrews
I am on version 2.0.2. Do you have any resources on how to dump and reload the schema? On Dec 2, 2013, at 2:52 PM, Robert Coli rc...@eventbrite.com wrote: On Mon, Dec 2, 2013 at 11:51 AM, Charlie Andrews charlieandrews@gmail.com wrote: Has anyone ever seen this behavior before? No.

Re: Recommended amount of free disk space for compaction

2013-12-02 Thread Robert Coli
On Thu, Nov 28, 2013 at 7:21 PM, Robert Wille rwi...@fold3.com wrote: So here’s my question. If Cassandra only compacts one table at a time, then I should be safe if I keep as much free space as there is data in the largest table. If Cassandra can compact multiple tables simultaneously, then

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 11:54 AM, Charlie Andrews charlieandrews@gmail.com wrote: I am on version 2.0.2. Do you have any resources on how to dump and reload the schema? I guess I should write a blog post on this guy, but the rough outline is : 1) echo DESCRIBE KEYSPACE keyspace_name; |

Re: Table Creation Error

2013-12-02 Thread Charlie Andrews
Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or is the keyspace schema separate from the data it describes? -Charlie On Dec 2, 2013, at 3:10 PM, Robert Coli rc...@eventbrite.com wrote: On Mon, Dec 2, 2013 at 11:54 AM, Charlie Andrews charlieandrews@gmail.com

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews charlieandrews@gmail.com wrote: Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or is the keyspace schema separate from the data it describes? Lol, sorry, yes. You will have to restore the data from the

Re: Table Creation Error

2013-12-02 Thread Charlie Andrews
Just out of curiosity, what do you think occurred to cause this problem? I thought it was quite strange that I didn’t get a useable error since my experience with this project has always been pretty helpful errors. Thanks, Charlie On Dec 2, 2013, at 3:20 PM, Robert Coli rc...@eventbrite.com

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 12:24 PM, Charlie Andrews charlieandrews@gmail.com wrote: Just out of curiosity, what do you think occurred to cause this problem? I thought it was quite strange that I didn’t get a useable error since my experience with this project has always been pretty helpful

Re: sstable2json hangs for authenticated keyspace?

2013-12-02 Thread Robert Coli
On Fri, Nov 29, 2013 at 4:11 PM, Josh Dzielak j...@keen.io wrote: Having an issue with sstable2json. It appears to hang when I run it against an SSTable that's part of a keyspace with authentication turned on. Running it against any other keyspace works, and as far as I can tell the only

changing several things (almost) at once; is this the right order to make the changes?

2013-12-02 Thread Brian Tarbox
We're making several changes and I'd to confirm that our order of making them is reasonable. Right now we have 4 node system at replicationFactor=2 running 1.1.6. We've moving to a 6 node system at rf=3 running 1.2.12 (I guess). We think the order should be: 1) change to rf=3 and run repair on

bin/cqlsh is missing cqlshlib

2013-12-02 Thread Ritchie Iu
Hello, I am trying to install and setup Cassandra on Fedora. So far I have successfully installed it using Yum by following the startup guide: http://www.datastax.com/documentation/cassandra/1.2/webhelp/index.html#cassandra/install/installRHEL_t.html My problem is that when I run bin/cqlsh,

Re: 答复: How to configure linux service for Cassandra?

2013-12-02 Thread Kumar Ranjan
Hey Folks, I have been using ccm for some time and it's pretty awesome tool to test out admin stuff. Now, I really want to test modeling data by trying to access ccm running cassandra using Thrift based pycassaShell client from remote hosts (not locally). My setup is like this: Lets say, private

Re: replica verification

2013-12-02 Thread Jason Wee
You could probably use one of these nodetool getendpoints keyspace cf key - Print the end points that owns the key using cqlsh and desc keyspace; /Jason On Tue, Dec 3, 2013 at 12:16 AM, chandra Varahala hadoopandcassan...@gmail.com wrote: Hello Team, I have cassandra cluster with 5

Re: bin/cqlsh is missing cqlshlib

2013-12-02 Thread Jason Wee
Check if you have the cqlshlib installed? For debian, it is located at /usr/share/pyshared/cqlshlib /Jason On Tue, Dec 3, 2013 at 5:42 AM, Ritchie Iu r...@ixl.com wrote: Hello, I am trying to install and setup Cassandra on Fedora. So far I have successfully installed it using Yum by

Stack trace from a node during a repair

2013-12-02 Thread John Pyeatt
We are running a 6-node AWS EC2 (m1.large) cluster of cassandra 1.2.9 across three availability zones with Ec2Snitch and NetworkTopologyStrategy. One of our nodes was apparently sharing a physical box with another customer who was really hogging the IO. So we needed to bring the node up on a new

Re: Stack trace from a node during a repair

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 2:59 PM, John Pyeatt john.pye...@singlewire.comwrote: Caused by: java.io.IOException: Unable to create directory /data-1/cassandra/data/SinglewireSupport/Binaries/backups This is an exception directly from a core java method. The cause is 99.9% likely to be

Re: changing several things (almost) at once; is this the right order to make the changes?

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 1:08 PM, Brian Tarbox tar...@cabotresearch.comwrote: We're making several changes and I'd to confirm that our order of making them is reasonable. Right now we have 4 node system at replicationFactor=2 running 1.1.6. We've moving to a 6 node system at rf=3 running

Re: replica verification

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 8:16 AM, chandra Varahala hadoopandcassan...@gmail.com wrote: I have cassandra cluster with 5 nodes with 1 replication factor initially. Now i changed to replication factor 3 and ran nodetool repair. Is there way i can verify that i have 3 replicas ? Use findrow from

Re: bin/cqlsh is missing cqlshlib

2013-12-02 Thread Ritchie Iu
No, there is no cqlshlib found at /usr/share/pyshared/cqlshlib although it might because I'm using Fedora which isn't debian. I did a search and I've found that cqlshlib is in several locations: /opt_build/fc17/lib/cassandra/pylib/cqlshlib, /opt_build/fc17/lib/cassandra/pylib/cqlshlib,

Re: 答复: How to configure linux service for Cassandra?

2013-12-02 Thread Krishna Chaitanya
Hey why dont you try Datastax Opscenter? Its a cool Gui tool to start/stop/manage your cluster(even remotely) . It also provides administrative tools fr checking on the performance with vital statistics. Definitely worth it. On Dec 3, 2013 3:14 AM, Kumar Ranjan winnerd...@gmail.com wrote: Hey

Re: 答复: How to configure linux service for Cassandra?

2013-12-02 Thread Michael Shuler
On 12/02/2013 03:43 PM, Kumar Ranjan wrote: Hey Folks, I have been using ccm for some time and it's pretty awesome tool to test out admin stuff. Now, I really want to test modeling data by trying to access ccm running cassandra using Thrift based pycassaShell client from remote hosts (not