Re: cql 3 qualification failing?

2012-06-17 Thread Sylvain Lebresne
On Thu, Jun 14, 2012 at 7:04 PM, Greg Fausak wrote: > But, I just attended a class on this.  I thought that once I used my > indices the remaining qualifications would be satisfied via a filtering > method. The actual rule is that you need to at least qualify one of the indexed column with an EQU

Re: 48 character cap on Keyspace + CF name length?

2012-06-17 Thread Tharindu Mathew
Oh, the world of windows... sigh. Thanks Aaron for the pointer. On Mon, Jun 18, 2012 at 8:02 AM, aaron morton wrote: > Has to do with the file name length on windows > https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/config/Schema.java#L49 > > > Cheers > > > -

Re: Question on SSTable Configuration Parameters......

2012-06-17 Thread aaron morton
> Where can I find parameters to control the SSTable files - e.g. their min/max > sizes, etc. It's not normally something you need to worry about. The initial size of the files is not really controlled by settings. The data is flushed to disk when either the commit log reaches a certain size, o

Re: GCInspector works every 10 seconds!

2012-06-17 Thread aaron morton
> It is also strange that although no data in Cassandra can fulfill the query > conditions, but it takes more time if we have more data in Cassandra. These log messages: > DEBUG [ReadStage:89] 2012-06-17 20:17:26,958 SliceQueryFilter.java (line 123) > collecting 0 of 5000: > 7fff0

Re: Cassandra out of Heap memory

2012-06-17 Thread rohit bhatia
I am using 1.0.5 . The logs suggest that it was one single instance of failure and I'm unable to reproduce it. >From the logs, In a span of 30 seconds, heap usage went from 4.8 gb to 8.8 gb With stop-the-world gc running 20 times. I believe that parNew was unable to clean up memory due to some prob

Re: Unbalanced ring in Cassandra 0.8.4

2012-06-17 Thread aaron morton
Assuming you have been running repair, it' can't hurt. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/06/2012, at 4:06 AM, Raj N wrote: > Nick, do you think I should still run cleanup on the first node. > > -Rajesh > > On Fri, Jun 15

Re: Cassandra atomicity/isolation/transaction in multithread counter updates

2012-06-17 Thread aaron morton
> I'm in a pseudo-deadlock BOOM BOOM ! :) > (N.B. The updates requires a read of current value before the update write. > Otherwise counter column can be used, but in my opinion the problem still > remain). Writes in the cassandra server do not require a read. > My simple question is: what h

Re: Cassandra error while processing message

2012-06-17 Thread aaron morton
Check are using framed transport on the client. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/06/2012, at 2:40 AM, Jim Ancona wrote: > It's hard to tell exactly what happened--are there other messages in your > client log before the

Re: Problem with streaming with sstableloader into ubuntu node

2012-06-17 Thread aaron morton
Cross platform clusters are not really supported. That said it sounds like a bug. If you can create some steps to reproduce it please create a ticket here https://issues.apache.org/jira/browse/CASSANDRA it may get looked it. Cheers - Aaron Morton Freelance Developer @aaronmor

Re: Limited row cache size

2012-06-17 Thread aaron morton
cassandra 1.1.1 ships with concurrentlinkedhashmap-lru-1.3.jar row_cache_size_in_mb starts life as an int but the byte size is stored as a long https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/service/CacheService.java#L143 Cheers - Aaron Morton Fre

Re: 48 character cap on Keyspace + CF name length?

2012-06-17 Thread aaron morton
Has to do with the file name length on windows https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/config/Schema.java#L49 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/06/2012, at 6:32 AM, Tharindu Mathew wro

Re: cql 3 qualification failing?

2012-06-17 Thread aaron morton
> So, my main primary key is on the ac_c column, text, and > the secondary composite key is on ac_creation, which is a date. These > queries perform correctly: In your CF there is only one primary key (aka row key), it is a composite of ac_c and ac_creation. > select * from at_event_ac_c where a

Re: Random slow connects.

2012-06-17 Thread aaron morton
You could also try adding some logging in the client to track down the exactly where the delay is. If it is in waiting for the socket to open on the server or say managing the connection client side. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickl

Re: Supercolumn behavior on writes

2012-06-17 Thread aaron morton
Writing to a super column family does not involve deserialisation, other than writing to the commit log it is an in memory operation. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/06/2012, at 3:36 AM, Greg Fausak wrote: > Derek, > >

Re: is this something to be concerned about - MUTATION message dropped

2012-06-17 Thread aaron morton
http://wiki.apache.org/cassandra/FAQ#dropped_messages https://www.google.com/#q=cassandra+dropped+messages Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/06/2012, at 12:54 AM, Poziombka, Wade L wrote: > INFO [ScheduledTasks:1] 2012-06

Re: MurmurHash NPE during compaction

2012-06-17 Thread aaron morton
Can you please create a ticket on https://issues.apache.org/jira/browse/CASSANDRA Please include: * CF definition including the bloom_filter_fp_chance * If the data was upgraded from a previous version of cassandra. * The names of the files that were being compacted. As a work around you can t

Re: Composite as row key

2012-06-17 Thread aaron morton
> Row key is a combo of 2 uuid, the first it's the user's uuid, if i want a > select of all the watchdog entrys of a user.how can i do? is it > possible? I justk know user uuid, the other part of key is unknow uuid. No. You would be doing a range scan (from key foo to key blah) and would

Question on SSTable Configuration Parameters......

2012-06-17 Thread Jayesh Thakrar
Hi All, I am a getting started with Cassandra and have been reading the O'Reilly Book and some other documentation. I understand that data is persisted in SSTable files. Where can I find parameters to control the SSTable files - e.g. their min/max sizes, etc. I looked up http://wiki.apache.org/

Re: Cassandra out of Heap memory

2012-06-17 Thread aaron morton
Not commenting on the GC advice but Cassandra memory usage has improved a lot since that was written. I would take a look at what was happening and see if tweeking Cassandra config helped before modifying GC settings. > "GCInspector.java(line 88): Heap is .9934 full." Is this expected? or > shou

Re: Help with configuring replication

2012-06-17 Thread aaron morton
Some docs here http://www.datastax.com/docs/1.0/initialize/index Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/06/2012, at 8:14 AM, Leonid Ilyevsky wrote: > Before going into complex clustering topologies, I would like to try the most

Re: cassandra as a client in zookeeper

2012-06-17 Thread aaron morton
Why do you want to do that ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/06/2012, at 7:43 PM, Ambes Hagos wrote: > Dear all, > I am using cassandra as distributed data base. > I want to register my cluster in a zookeeper. > Do you h

Re: GCInspector works every 10 seconds!

2012-06-17 Thread Jason Tang
Hi After I change log level to DEBUG, I found some log. Although we don't have traffic to Cassandra, but we have scheduled the task to perform the sliceQuery. We use time-stamp as the index, we will perform the query by every second to check if we have tasks to do. After 24 hours, we h

GCInspector works every 10 seconds!

2012-06-17 Thread Jason Tang
Hi After running load testing for 24 hours(insert, update and delete), now no new traffic to Cassandra, but Cassnadra shows still have high load(CPU usage), from the system.log, it shows it always perform GC. I don't know why it work as that, seems memory is not low. Here is some configuration