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?

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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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

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: 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 >

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: 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

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

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: 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

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

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