Cassandra Node Routinely Goes Down - 0.7 RC2

2010-12-22 Thread Christopher Kung
Hey All, I have been having problems running 0.7RC2 where one of my two nodes routinely goes down. Somtimes both of them go down. I am running the nodes using Ubuntu Lucid LTS 64-bit with kernal version 2.6.32. Currently, both nodes are running on micro instances on EC2. I will eventual migrate to

java.io.IOException: No space left on device

2010-12-22 Thread Timo Nentwig
So, this is my ring, the third node ran out of disk space: Address Status State LoadOwnsToken 139315361777093290765734121398073449298 192.168.68.76 Up Normal 37.83

Re: Create CF in Mapper's setup

2010-12-22 Thread altanis
Thank you, I hadn't realized I should use thrift. Alexander Altanis > Download the source version of the latest 0.7 from > http://cassandra.apache.org/download/ and take a look at the > contrib/word_count example. Specifically, in the > contrib/word_count/src/WordCountSetup.java file, there are

Secondary indexes for multi-value fields

2010-12-22 Thread Prasad Sunkari
Hi all, I have a column family for users of my system and I need to have tags set to these users. My current plan is to have a column that holds a string (comma separated tags). I am not clear if this the best way to do it. Specially because this may lead to a complications when more than

Re: Secondary indexes for multi-value fields

2010-12-22 Thread Jools
I have a very similar use case in my system, I've solved it as follows; If all your users have a unique id, such as a login userid. You could create a new column family, keyed by the userid, and add columns which have no value, but the column name is the tag value. Searching these tags later will

Re: Problem in using PHPcassa: Uncaught exception 'Exception' with message 'Could not connect to a cassandra server'

2010-12-22 Thread Rajkumar Gupta
Thanks Nick your suggestion just worked.!! I just tried the command 'use Keyspace1' (the keyspace i was trying to access through my php script) at cassandra-cli and it was unable to let me use that keyspace but I could successfully write another it for another keyspace that actually existed. T

Problematic usage pattern

2010-12-22 Thread Daniel Doubleday
Hi all wanted to share a cassandra usage pattern you might want to avoid (if you can). The combinations of - heavy rows, - large volume and - many updates (overwriting columns) will lead to a higher count of live ssts (at least if you're not starting mayor compactions a lot) with many ssts ac

Re: Cassandra Node Routinely Goes Down - 0.7 RC2

2010-12-22 Thread Peter Schuller
> I have been having problems running 0.7RC2 where one of my two nodes > routinely goes down. Somtimes both of them go down. I am running the nodes > using Ubuntu Lucid LTS 64-bit with kernal version 2.6.32. Currently, both > nodes are running on micro instances on EC2. I will eventual migrate to >

strange issue with timeUUID columns

2010-12-22 Thread Roland Gude
Hi, I am experiencing a strange issue when using TimeUUID as columnkeys. I am storing a number of events with timeUUId as key in a row. Later I try to query for a slice of that row with a given lower bound timeUUID and upperBoundTimeUUID (constructed as described in the wiki) If I inserted the e

Re: java.io.IOException: No space left on device

2010-12-22 Thread Peter Schuller
> And the data could be more evenly balanced, obviously. However the nodes > fails to startup because due of lacking disk space (instead of starting up > and denies further writes it appears to try to process the [6.6G!] commit > logs). So, I cannot perform any actions on it no more like re-bala

RE: Cassandra Node Routinely Goes Down - 0.7 RC2

2010-12-22 Thread Dan Hendry
The main diagnosing feature of the problem I was seeing is very high system CPU with no user CPU utilization(check with top or sar -u), vmstat showing one process waiting for run-time but never seeming to get it, a high page scan rate, and no Cassandra error messages (although nodes dying did *seem

Re: Cassandra Node Routinely Goes Down - 0.7 RC2

2010-12-22 Thread Jonathan Ellis
On Wed, Dec 22, 2010 at 9:21 AM, Dan Hendry wrote: > Does memory mapping somehow force the data to stay in memory or prevent it > memory from being reclaimed for other purposes? Google does not turn up any > nice simple answers. > No. -- Jonathan Ellis Project Chair, Apache Cassandra co-founder

Re: java.io.IOException: No space left on device

2010-12-22 Thread Timo Nentwig
On Dec 22, 2010, at 16:20, Peter Schuller wrote: >> And the data could be more evenly balanced, obviously. However the nodes >> fails to startup because due of lacking disk space (instead of starting up >> and denies further writes it appears to try to process the [6.6G!] commit >> logs). So,

Re: Cassandra Node Routinely Goes Down - 0.7 RC2

2010-12-22 Thread Peter Schuller
> Can one of the Cassandra devs or anybody who knows about memory mapping > comment on this/my particular mmap situation? I have been thinking about it > and the start of my problems seemed to correlate to my active dataset and > single sstable sizes growing beyond the amount of free system memory

Re: Secondary indexes for multi-value fields

2010-12-22 Thread Anand Somani
One approach is to ask yourself questions as to how you would use this information, for example - how often to you go from user to tags - how often would you want to go from tag->users. - What kind of reporting would you want to do on tags and how often - Can multiple people add the sa

Re: Problem in using PHPcassa: Uncaught exception 'Exception' with message 'Could not connect to a cassandra server'

2010-12-22 Thread Tyler Hobbs
You can create keyspaces and column families with cassandra-cli. Once it is running, type 'help create keyspace;' or 'help create column family;' - Tyler On Wed, Dec 22, 2010 at 8:20 AM, Rajkumar Gupta wrote: > Thanks Nick your suggestion just worked.!! > > I just tried the command 'use Key

Re: java.io.IOException: No space left on device

2010-12-22 Thread Tyler Hobbs
>>> BTW what precisely does the Owns column mean? >> >> The percentage of the token space owned by the node. > > Precisely meaning what? :) On my ring of 5 machines, 3 own about 1/3 and 2 (own only 5% - and one of these contains 1/3 more data than the two largest in the cluster, it's actually the o

Re: Secondary indexes for multi-value fields

2010-12-22 Thread Prasad Sunkari
I will frame my question in a different way. Each user in my system subscribes to updates from selected other users (updates are aggregated from outside) and tags the users to which he/she is subscribed to. In my current design, I have a column family called "Followers" keyed by userid in w

Re: cli 'list' command not returning all data, get_range_slices bug?

2010-12-22 Thread Aaron Morton
The error may be due to this https://issues.apache.org/jira/browse/CASSANDRA-1824 - but you're saying all the nodes are seeds. Perhaps connect to each via Jmx or the cli and ask them to describe the schema. Aaron On 22/12/2010, at 12:01 PM, mike dooley wrote: > hi, > > i am using version

Re: cli 'list' command not returning all data, get_range_slices bug?

2010-12-22 Thread Jonathan Ellis
what do you see in the logs during the list command at debug level? On Tue, Dec 21, 2010 at 5:01 PM, mike dooley wrote: > hi, > i am using version 0.7-rc2 and pelops-c642967 from java.  when i try > to export all the data in a column family i don't get all of the data that > was inserted.  i susp

Re: java.io.IOException: No space left on device

2010-12-22 Thread Timo Nentwig
On Dec 22, 2010, at 16:20, Peter Schuller wrote: > In any case: Monitoring disk-space is very very important. So, why doesn't cassandra monitor it itself and stop accepting writes if it runs out of space?