RE: Drop schema Called "Index"

2011-12-19 Thread Michael Vaknine
Hi, I am trying to delete a keyspace called Index. Here is all the versions of the drop I tried. [default@unknown] drop keyspace 'Index'; Keyspace ''Index'' not found. [default@unknown] drop keyspace Index; Syntax error at position 14: mismatched input 'Index' expecting set null [d

Re: Cassandra stress test and max vs. average read/write latency.

2011-12-19 Thread Peter Schuller
> I'm trying to understand if this is expected or not, and if there is Without careful tuning, outliers around a couple of hundred ms are definitely expected in general (not *necessarily*, depending on workload) as a result of garbage collection pauses. The impact will be worsened a bit if you are

Re: Garbage collection freezes cassandra node

2011-12-19 Thread Peter Schuller
I should add: If you are indeed actually pausing due to "promotion failed" or "concurrent mode failure" (which you will see in the GC log if you enable it with the options I suggested), the first thing I would try to mitigate is: * Decrease the occupancy trigger (search for "occupancy") of CMS to

Re: Garbage collection freezes cassandra node

2011-12-19 Thread Peter Schuller
> During the garbage collections, Cassandra freezes for about ten seconds. I > observe the following log entries: > > > > “GC for ConcurrentMarkSweep: 11597 ms for 1 collections, 1887933144 used; max > is 8550678528” Ok, first off: Are you certain that it is actually pausing, or are you assumin

Choosing a Partitioner Type for Random java.util.UUID Row Keys

2011-12-19 Thread Drew Kutcharian
Hey Guys, I just came across http://wiki.apache.org/cassandra/ByteOrderedPartitioner and it got me thinking. If the row keys are java.util.UUID which are generated randomly (and securely), then what type of partitioner would be the best? Since the key values are already random, would it make a

setStrategy_options syntax in thrift

2011-12-19 Thread A J
What is the syntax of setStrategy_options in thrift. The following fails: Util.java:22: setStrategy_options(java.util.Map) in org.apache.cassandra.thrift.KsDef cannot be applied to (java.lang.String) newKs.setStrategy_options("{replication_factor:2}");

Re: memory estimate for each key in the key cache

2011-12-19 Thread Jeremiah Jordan
It is not telling you to multiply your key size by 10-12, it is telling you to multiply the output of the nodetool cfstats reported "key cache size" by 10-12. -Jeremiah On Dec 18, 2011, at 6:37 PM, Guy Incognito wrote: > to be blunt, this doesn't sound right to me, unless it's doing something

Re: Composite Column Queries with Hector

2011-12-19 Thread aaron morton
If you don't know the names of the columns you probably want to call ColumnSlice.getColumns() and iterate through the list of HColumns. see http://rantav.github.com/hector//source/content/API/core/1.0-1/me/prettyprint/hector/api/beans/ColumnSlice.html http://rantav.github.com/hector//source/cont

Cassandra stress test and max vs. average read/write latency.

2011-12-19 Thread Peter Fales
Has anyone looked much at the maximum latency of cassandra read/write requests? (rather than the average latency and average throughput) We've been struggling for quite some time trying to figure out why we we see occasional read or write response times in the 100s of milliseconds even on fast m

Re: Drop schema Called "Index"

2011-12-19 Thread aaron morton
Which keyspace are you trying to delete ? What happens when you use drop ; in cassandra-cli ? If nothing happens is anything logged in the server side logs ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/12/2011, at 11:48 PM, Mic

Re: "show schema" bombs in 0.8.6

2011-12-19 Thread Jonathan Ellis
I haven't seen that one before. Can you create a ticket? On Tue, Dec 13, 2011 at 1:07 PM, Maxim Potekhin wrote: > Running cli --debug: > > [default@PANDA] show schema; > null > java.lang.RuntimeException >        at > org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:310) >  

Re: Deleted rows re-appearing on repair in 0,8.6

2011-12-19 Thread Jonathan Ellis
http://wiki.apache.org/cassandra/Operations#Dealing_with_the_consequences_of_nodetool_repair_not_running_within_GCGraceSeconds On Mon, Dec 12, 2011 at 7:05 PM, Maxim Potekhin wrote: > Hello, > > I know that this problem used to exist in 0.8.1 -- > I delete rows, run a repair and these rows are ba

Composite Column Queries with Hector

2011-12-19 Thread Martin Arrowsmith
Dear Cassandra and Hector experts, I am using Hector to implement and query information from Composite Columns. I found this site to be quite useful: http://randomizedsort.blogspot.com/2011/11/cassandra-range-query-using.html It goes through the steps of creating a composite column, to perform s

Re: Garbage collection freezes cassandra node

2011-12-19 Thread Mohit Anchlia
Increasing memory in this case may not solve the problem. Share some information about your workload. Cluster configuration, cache sizes etc. You can also try getting java heap historgram to get more info on what's on the heap. On Mon, Dec 19, 2011 at 7:35 AM, Rene Kochen wrote: > I recently se

AW: Garbage collection freezes cassandra node

2011-12-19 Thread Roland Gude
Tuning garbage colletion is really hard. Espescially if you do not know why garbage collection stalls. In general I must say I have never seen a software which shipped with such a good garbage collection configuration as Cassandra. The thing that looks suspiscious is that the major collections a

Re: Garbage collection freezes cassandra node

2011-12-19 Thread Paul Loy
Giving it more memory will simply increase the time between (and duration of) the freezes. Which JVM are you using? I think that Java 7 has some nice improvements to GC especially with large heaps. On Mon, Dec 19, 2011 at 7:35 AM, Rene Kochen wrote: > I recently see the following garbage collect

Thrift error occurred during processing of message

2011-12-19 Thread Tamil selvan R.S
Hi, We are using PHPCassa to connect to Cassandra 1.0.2. After we installed the thrift extension we started noticing the following in the error logs. [We didn't notice this when we were running raw thrift library with out extension]. ERROR [pool-2-thread-5314] 2011-12-05 20:26:47,729 CustomTThrea

Drop schema Called "Index"

2011-12-19 Thread Michael Vaknine
Hi, I had Cassandra version 0.7.6 and a schema called Index. When I upgraded to 1.0.3 I realized that I cant create this keyspace maybe because Index has become a reserved word? I tried 'Index' and "Index" and still get an error so I created a new keyspace instead. Now I am not able to delet

Leveled compaction strategy and expiring columns

2011-12-19 Thread Viktor Jevdokimov
Hi, We're trying to understand how leveled compaction works. The documentation written is about new/updated columns only. What about expiring columns and TTL? When higher level sstables will be compacted and expired columns removed? Best regards/ Pagarbiai Viktor Jevdokimov Senior D