Re: JNA on Windows

Processes start differently on windows. On windows it uses mklink to make a hard link https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/utils/CLibrary.java#L170 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6

Re: CQL 3 with a right API

Row keys are distinct. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/07/2012, at 7:30 AM, Shahryar Sedghi wrote: > Hi > > I am new to to Cassandra and we started with 1.1 and modeled everything with > Composite columns a

Re: Multiple keyspace question

ch I would take.) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/07/2012, at 8:15 AM, Shahryar Sedghi wrote: > Aaron > > I am going to have many (over 50 eventually) keyspaces with limited number of > CFs (5-6) do you t

Re: Composite Slice Query returning non-sliced data

Something like: This is how I did the write in CLI and this is what it printed. and then This is how I did the read in the CLI and this is what it printed. It's hard to imagine what data is in cassandra based on code. cheers - Aaron Morton Freelance Developer @aaronm

Re: Effect of rangequeries with RandomPartitioner

for background http://wiki.apache.org/cassandra/FAQ#range_rp It maps the start key to a token, and then scans X rows from their on CL number of nodes. Rows are stored in token order. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/07

Re: cannot build 1.1.2 from source

Did you try running ant clean first ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/07/2012, at 1:57 PM, Arya Goudarzi wrote: > Hi Fellows, > > I used to be able to build cassandra 1.1 up to 1.1.1 with the same set > of p

Re: Serious issue updating Cassandra version and topology

have the same version, the -h?- part of the name. Can you repair the other CF's ? If this cannot be repaired by scrub or upgradetables you may need to cut the row out of the sstables. Using sstable2json and json2sstable. Cheers - Aaron Morton Freelance Developer @aaronm

Re: Effect of rangequeries with RandomPartitioner

Index files map keys (not tokens) to offsets in the data file. A range scan uses the index file to seek to the start position in the data file and then does a partial scan of the data file. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On

Re: Setting the Memtable allocator on a per CF basis

a plan. Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/07/2012, at 1:47 AM, Joost van de Wijgerd wrote: > Hello Cassandra Devs, > > We are currently trying to optimize our Cassandra system with > different workloads. One of our

Re: Composite Slice Query returning non-sliced data

heers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/07/2012, at 12:36 PM, Sunit Randhawa wrote: > Aaron, > > Let me start from the beginning. > > 1- I have a ColumnFamily called Rollup15 with below definition: > > cre

Re: BulkLoading sstables from v1.0.3 to v1.1.1

steps to reproduce, can you raise a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/07/2012, at 7:43 PM, rubbish me wrote: > Thanks Ivo. > > We are quite close to rel

Re: Using a node in separate cluster without decommissioning.

a lot of repair activity. Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/07/2012, at 6:35 AM, rohit bhatia wrote: > Hi > > I want to take out 2 nodes from a 8 node cluster and use in another > cluster, but can't

Re: failed to delete commitlog, cassandra can't accept writes

u also check if the file it tries to delete exists ? (I assume it does, otherwise it would be a different error). Thanks for digging into this. --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/07/2012, at 9:36 AM, Frank Hsueh wrote: > oops;

Re: snapshot issue

Make sure JNA is in the class path http://wiki.apache.org/cassandra/FAQ#jna Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/07/2012, at 9:38 PM, Adeel Akbar wrote: > Hi, > > I am trying to taking snapshot of my data but faced

Re: Connected file list in Cassandra

iterate over the Document CF and read from Page CF. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/07/2012, at 7:47 AM, David Brosius wrote: > > why not just hold the pages as different columns in the same row? colum

Re: Composite column/key creation via Hector

You may have better luck on the Hector Mailing list… https://groups.google.com/forum/?fromgroups#!forum/hector-users Here is something I found in the docs though http://hector-client.github.com/hector/build/html/content/composite_with_templates.html Cheers - Aaron Morton

Re: Concerns about Cassandra upgrade from 1.0.6 to 1.1.X

It's always a good idea to have a read of the NEWS.txt file https://github.com/apache/cassandra/blob/cassandra-1.1/NEWS.txt Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/07/2012, at 5:51 PM, Tyler Hobbs wrote: > On Wed, Jul

Re: How to come up with a predefined topology

lication can be tricky. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/07/2012, at 8:05 PM, prasenjit mukherjee wrote: > Thanks. Some follow up questions : > > 1. How do the reads use strategy/snitch information ? I am

Re: Increased replication factor not evident in CLI

Do multiple nodes say the RF is 2 ? Can you show the output from the CLI ? Do show schema and show keyspace say the same thing ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07/2012, at 7:39 AM, Dustin Wenz wrote: > We recen

Re: Concerns about Cassandra upgrade from 1.0.6 to 1.1.X

gnashing of teeth. In general, node by node: * drain * snapshot * shutdown * upgrade * turn on. When they are all up I snap shot again if there is space. Then run upgradetables. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07

Re: High RecentWriteLatencyMicro

ds(4,000-10,000) with names like > "pool-2-thread-*" These are connection threads. Use connecting pooling or try the thread pooled connection manager, see yaml for details. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/0

Re: How to come up with a predefined topology

> Is the above understanding correct ? yes, sorry. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07/2012, at 4:24 PM, prasenjit mukherjee wrote: > On Fri, Jul 13, 2012 at 4:04 AM, aaron morton wrote: >> The logic is h

Re: Never ending manual repair after adding second DC

txt#L5 Good luck. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/07/2012, at 10:16 PM, Bart Swedrowski wrote: > Hello everyone, > > I'm facing quite weird problem with Cassandra since we've added > secondary DC to our c

Re: bootstrapping problem. 1.1.2 version

Check net stats a few times to look for progress, if there is none take a look at the logs on both sides for errors. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/07/2012, at 10:53 PM, Michael Cherkasov wrote: > Hi

Re: Cassandra occupy over 80% CPU when take a compaction

Are you able to put together a test case, maybe using the stress testing tool, that models your data layout? If so can you add it to https://issues.apache.org/jira/browse/CASSANDRA-3592 Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16

Re: Enable CQL3 from Astyanax

Can you provide an example where you add data, run a CQL statement in cqlsh that does not work and maybe list the data in the CLI. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/07/2012, at 8:25 PM, Thierry Templier wrote: > He

Re: bootstrapping problem. 1.1.2 version

> DC located in different environments one on Win7 other on Linux. Running different operating systems is not supported. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 12:30 AM, Michael Cherkasov wrote: > I foun

Re: Snapshot issue in Cassandra 0.8.1

ame Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 4:00 AM, Adeel Akbar wrote: > Hi, > > I have created snapshot with following command; > > #./nodetool -h localhost snapshot cassandra_01_bkup > >

Re: Never ending manual repair after adding second DC

heers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 4:32 AM, Bill Au wrote: > I had ran into the same problem before: > > http://comments.gmane.org/gmane.comp.db.cassandra.user/25334 > > I have not fond any solutions yet. > >

Re: high i/o usage on one node

? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 5:12 AM, feedly team wrote: > I am having an issue where one node of a 2 node cluster seems to be using > much more I/O than the other node. the cassandra read/write re

Re: Truncate failing with 1.0 client against 0.7 cluster

UnavailableException is a server side error, whats the full error message ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 5:31 AM, Guy Incognito wrote: > i'm doing an upgrade of Cassandra 0.7 to 1.0 at the moment

Re: Truncate failing with 1.0 client against 0.7 cluster

truncate requires all all nodes to be available. Let us know when you have the full error. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 10:04 AM, Guy Incognito wrote: > sorry i don't have the exact text right

Re: Cassandra 1.0 hangs during GC

; for your cf's ? I would upgrade to 1.0.10 before getting too carried away though. Cheers --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/07/2012, at 8:14 PM, Nikolay Kоvshov wrote: > > This is a cluster of 2 nodes, each hav

Re: create if not exists ? create or update ?

It's not in the language as it stands. If you would like to see it add a request to https://issues.apache.org/jira/browse/CASSANDRA and maybe help out :) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 1:14 AM, Илья Ши

Re: Presentation, CQL 3 and Paging

a way to do this with it) The only way to page is to provide a start column and get the next X columns. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 3:54 AM, Bruno Di Pentima wrote: > Hello all! > > I'm new to

Re: Cassandra Evaluation/ Benchmarking: Throughput not scaling as expected neither latency showing good numbers

e the latency increase and tasks start to back up in nodetool tpstats. If you see it report dropped messages it is over loaded. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 4:48 AM, Code Box wrote: > Thanks a lot

Re: Cassandra Evaluation/ Benchmarking: Throughput not scaling as expected neither latency showing good numbers

numpy for python. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/07/2012, at 11:29 PM, Manoj Mainali wrote: > How kind of client are you using in YCSB? If you want to improve latency, try > distributing the requests among n

Re: Can't change replication factor in Cassandra 1.1.2

it applies here. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 5:27 AM, Douglas Muth wrote: > Hi folks, > > I have an interesting problem in Cassandra 1.1.2, a Google Search > wasn't much help, so I

Re: Cassandra startup times

the await time in iostat. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 4:54 PM, Ben Kaehne wrote: > Good evening, > > I am interested in improving the startup time of our cassandra cluster. > > W

Re: Tripling size of a cluster

. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 6:00 PM, Mariusz Dymarek wrote: > Hi again, > we have now moved all nodes to correct position in ring, but we can see > higher load on 2 nodes, than on other nodes: >

Re: Unreachable node, not in nodetool ring

I would: * run repair on 10.58.83.109 * run cleanup on 10.59.21.241 (I assume this was the first node). It looks like 0.56.62.211 is out of the cluster. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/07/2012, at 9:37 PM, Alain

Re: Counters values are less than expected [1.0.6 - Java/Pelops]

Nothing jumps out, can you reproduce the problem ? If you can repo it let us know and the RF / CL. Good luck. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 1:07 AM, cbert...@libero.it wrote: > Hi all, I have a problem w

Re: random partitioner and key scan

range. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 4:46 AM, prasenjit mukherjee wrote: > When a request for token change is issued ( via nodetool ) then on > what basis a node will move some of its rows to other no

Re: Seeing writes when only expecting reads

My first guess would be read repair, are you seeing any increase in ReadRepairStage tasks ? RR (in 1.X) is normally only enabled for 10% of the request. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 5:17 AM, jmodha wrote

Re: does secondary index get created(rebuilt?) every time Cassandra restarts?

the system reading the index meta data. Do you see any INFO level messages with "Submitting index build" ? cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 5:52 AM, Feng Qu wrote: > We have a CF with 11 seconda

Re: Replication factor - Consistency Questions

> But isn't QUORUM on a 2-node cluster still 2 nodes? Yes. 3 is where you start to get some redundancy - http://thelastpickle.com/2011/06/13/Down-For-Me/ Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 10:24 AM, K

Re: Batch update efficiency with composite key

I'm assuming the logical row is in a CQL 3 CF with composite PRIMARYKEY http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 It will still be a no look write. The exception being secondary indexes and counters which include reads in the write path. Cheers - Aaron M

Re: 0.8 --> 1.1 Upgrade: Any Issues?

Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/07/2012, at 4:10 PM, Peter Schuller wrote: >> We currently have a 0.8 production cluster that I would like to upgrade to >> 1.1. Are there any know compatibility or upgrade issue

Re: DSE solr HA

You may have more luck on the DS forums http://www.datastax.com/support-forums/ Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/08/2012, at 6:00 AM, Mohit Anchlia wrote: > > Going through this page and it looks like index

Re: [gem] does "disconnect!" work properly?

://github.com/twitter/cassandra/blob/master/lib/cassandra/cassandra.rb#L1043 If you still feel there is an problem the Issue list of github is probably the place to go https://github.com/twitter/cassandra/issues Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: Problem with cassandra startup on Linux

ot; #else JVM_OPTS="$JVM_OPTS -Xss128k" #fi fi Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/08/2012, at 5:16 PM, Dwight Smith wrote: > Installed 1.1.3 on my Linux cluster – the JVM_OPTS were truncated

Re: Custom Partitioner Type

k to see if the effects you could use the BOP and format the keys as (python): str(key % 2) + "{0:0>#10}".format(key) So all keys are 11 digit strings, even keys start with 0 and odd with 1. Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://w

Re: GCInspector info messages in cassandra log

down compaction. Once you have GC under control you may want to play with memory settings. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/08/2012, at 4:45 PM, Tamar Fraenkel wrote: > Hi! > I have 3 nodes ring runn

Re: What are the basic steps to improve Cassandra performance

or are you trying to get multiple rows ? Getting the columns from the start of row is the most efficient query, see my presentation here http://www.datastax.com/events/cassandrasummit2012/presentations Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://

Re: GCInspector info messages in cassandra log

s not look that way. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 3:15 AM, Tamar Fraenkel wrote: > Hi! > It helps, but before I do more actions I want to give you some more info, and > ask some questions: > > Related

Re: incremental backup and Priam?

The Priam code is looking for the //backups directory created by cassandra during incremental backups. If it finds it the files are uploaded to S3. It's taking the built in incremental backups off node. (AFAIK) Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: replace dead node? " token -1 "

ip) cause problems? If the nodes are bootstrapping an error is raised. Otherwise the token ownership is passed to the new node. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 11:07 AM, Yang wrote: > previously when a

Re: Partial composite result limit possible?

columns reversed so you can select from (0, null) to (2, null). http://pycassa.github.com/pycassa/assorted/composite_types.html?#fetching-compositetype-data Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 4:10 PM

Re: GCInspector info messages in cassandra log

ions here, which are pretty much what you have described http://www.datastax.com/docs/1.0/operations/backup_restore Cheers --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 4:57 PM, Tamar Fraenkel wrote: > Aaron, > Thank you v

Re: CQL3: Do boolean values need quoting in inserts?

Quoting false is correct from my reading of the Antlr grammar. Constant terms are either strings, UUID, int or long. I'm sure someone from DS will pickup the comment you made on the post and fix the example. Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: Migrating to a new cluster (using SSTableLoader or other approaches)

tool with DEBUG level logging and post the logs ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/08/2012, at 9:32 PM, Filippo Diotalevi wrote: > Hi, > we are trying to use SSTableLoader to bootstrap a new 7-node cassandra (v.

Re: Composite Column Slice query, wildcard first component?

> Is there a way to create a slice query that returns all columns where the > _second_ component is A? No. You can only get a contiguous slice of columns. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/08/2012, at 7:21 AM, Mik

Re: indexing question related to playOrm on github

es at a time. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/08/2012, at 12:34 PM, "Hiller, Dean" wrote: > 1. Can playOrm be listed on cassandra's list of ORMs? It supports a JQL/HQL > query on a trilli

Re: SSTable Index and Metadata - are they cached in RAM?

012-technical-deep-dive-query-performance > and Metadata? This is the meta data we hold in memory for every open sstable https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/io/sstable/SSTableMetadata.java Cheers - Aaron Morton Freelance Dev

Re: Migrating to a new cluster (using SSTableLoader or other approaches)

exception message. Also change the logging in log4j-tools.properties for get DEBUG messages so we can see what's going on. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 16/08/2012, at 8:51 PM, Filippo Diotalevi wrote: >>> ERRO

Re: wild card on query

e of weeks ago that shows denormalising data https://github.com/amorton/wdcnz-2012-site and http://www.slideshare.net/aaronmorton/hellow-world-cassandra Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 12:39 AM,

Re: indexing question related to playOrm on github

to repair it's index entries. When repairing the index entry play with the timestamp so any deletions you make only apply to the column as it was when you saw the error. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/0

Re: nodetool repair uses insane amount of disk space

What version are using ? There were issues with repair using lots-o-space in 0.8.X, it's fixed in 1.X Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 2:56 AM, Michael Morris wrote: > Occasionally as I'm doi

Re: Opscenter 2.1 vs 1.3

You may have better luck on the Data Stax forums http://www.datastax.com/support-forums/ Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 4:36 AM, Robin Verlangen wrote: > Hi there, > > I just upgraded to opsc

Re: C++ Bulk loader and Result set streaming.

ng C++ client. Is there any C++ supporting code or information on > streaming the result set into a file or something. I've not looked at the C++ client, but normally you use the last column returned as the start column for the next call. Cheers - Aaron Morton Freelance De

Re: 'WHERE' with several indexed columns

her.java > Also is index used only with an equality operator or also with greater equality Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 7:13 AM, A J wrote: > Hi > If I have a WHERE clause in CQL with several

Re: Why the StageManager thread pools have 60 seconds keepalive time?

That's some pretty old code. I would guess it was done that way to conserve resources. And _i think_ thread creation is pretty light weight. Jonathan / Brandon / others - opinions ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On

Re: nodetool repair uses insane amount of disk space

if needed. Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 11:14 AM, Michael Morris wrote: > Upgraded to 1.1.3 from 1.0.8 about 2 weeks ago. > > On Thu, Aug 16, 2012 at 5:57 PM, aaron morton wrote: > What version a

Re: Cassandra 1.0 row deletion

> If you use the remove function to delete an entire row, is that an atomic > operation? Yes. Row level deletes are atomic. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 3:39 PM, Derek Williams wrote: > On Th

Re: SSTable Index and Metadata - are they cached in RAM?

hat sorted row keys (from point 2) ) already contain bloom > filter for their columns. But bloom filter is stored together with column > index, is that correct? Yes Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, a

Re: Omitting empty columns from CQL SELECT

If you specify the columns by name in the select clause the query returns them because they should be projected in the result set. Can you use a column slice instead ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/08/2012, at 11:09

Re: Omitting empty columns from CQL SELECT

ith the amount of data pages that must be read to satisfy the query. Note though that this is better in 1.X . See slide 61 in the first link and "In Motion - Name Locality" section in the second. Hope that helps. ----- Aaron Morton Freelance Developer @aar

Re: Bad Request: Duplicate index name

Can you provide: * the CF existing schema and output from nodetool cfstats * the command you are running * the error you get Also it's handy to know what version the schema was originally created in. Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: indexing question related to playOrm on github

-written with timestamp 2. Remember I said "sometimes". Playing with timestamps often leads to questions such as "why did my inserts not work". Cheers --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/08/2012, at 1:30 AM, &

Re: Why the StageManager thread pools have 60 seconds keepalive time?

that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/08/2012, at 10:01 AM, Guillermo Winkler wrote: > Aaron, thanks for your answer. > > I'm actually tracking a problem where mutations get dropped and cfstats show >

Re: What is the ideal server-side technology stack to use with Cassandra?

> Aaron Morton (aa...@thelastpickle.com) advised: > > "If possible i would avoid using PHP. The PHP story with cassandra has > not been great in the past. There is little love for it, so it takes a > while for work changes to get in the client drivers. > > AFAIK it lack

Re: Secondary index and/or row key in the read path ?

omething that is planned for CQL. Cheers --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/08/2012, at 6:33 PM, Jean-Armel Luce wrote: > > Hello, > > I am using Cassandra 1.1.1 and CQL3. > > Could you tell me what is the best str

Re: Cassandra with large number of columns per row

more than say 32 or 64 MB of data. It's not a hard restriction but big rows cause issues and it's often easier to avoid them. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/08/2012, at 8:15 PM, Chuan-Heng

Re: Best strategy to increase cluster size and keep nodes balanced

that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 21/08/2012, at 12:57 AM, Filippo Diotalevi wrote: > What's the best strategy to increase the cluster size from 3 nodes to 7 > nodes, while keeping the nodes balanced?

Re: Why so slow?

l in source distribution that maybe of help. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 21/08/2012, at 4:16 AM, "Hiller, Dean" wrote: > Be careful on bulk as cassandra takes a bit longer to process. It was faster &g

Re: get_slice on wide rows

om/dev/blog/when-to-use-leveled-compaction > Is the solution here partitioning the wide row into multiple narrower rows? That's also sensible. I would give the approach above a try first, may give you more bang for your buck. Cheers ----- Aaron Morton Freelance Developer @aa

Re: How to add secondary index to existing column family with CLI?

the ascii code for "title" and use that. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 21/08/2012, at 5:15 AM, "Ryabin, Thomas" wrote: > I want to add a secondary index to an existing column family, but am running

Re: Heap size question

> "How do I know if my off-heap memory is not used?" If you are using the default memory mapped file access memory not used by the cassandra JVM will be used to cache files. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 2

Re: Why the StageManager thread pools have 60 seconds keepalive time?

mmediately "Enqueuing flush of …" when the Memtable starts writing the next SStable. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/08/2012, at 6:38 AM, Guillermo Winkler wrote: > Aaron, thanks for your answer. &

Re: OutOfMemory log in Cassandra

> CASSANDRA_HEAPDUMP_DIR Is for JVM out of memory. You were seeing the OS kill the JVM because of low os memory. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/08/2012, at 4:28 PM, Xu Renjie wrote: > Guille, >Thanks

Re: Facing problem while configuring key and row cache

l/index cheers --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 2:18 AM, Amit Handa wrote: > hi all, > > I am exploring apache cassandra 1.1.3. I am facing problem with how to > improve performance of cassandra using caching conf

Re: nodetool repair - when is it not needed ?

tency. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 6:59 AM, Rob Coli wrote: > On Wed, Aug 22, 2012 at 8:37 AM, Senthilvel Rangaswamy > wrote: >> We are running Cassandra 1.1.2 on EC2. Our database is primaril

Re: Deleting a row from a counter CF

I would guess that Pelops has called remove() on the Thrift API rather than remove_counter(). Check the code in Pelops. If you turn server side logging up to DEBUG it will log "remove" for the non counter call and "remove_counter" for the counter one. Cheers ------

Re: Cassandra 1.1.4 RPM required

See step 1 here http://wiki.apache.org/cassandra/GettingStarted Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 7:40 PM, Adeel Akbar wrote: > Hi, > > I would like to install Apache Cassandra 1.1.4 from RPM. Pleas

Re: nodetool repair - when is it not needed ?

When node is sending hints it waits the normal rpc_timeout. If there is a time out hint delivery for that endpoint is aborted. It will be re-tried the in the next HH round, which is every 10 minutes. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle

Re: Commit log periodic sync?

ast as the IO can keep up. Every 10s a sync messages is added to the queue. Not that the commit log segment may rotate at any time which requires a sync. A loss of data across all nodes in a DC seems odd. If you can provide some more information we may be able to help. Cheers --

Re: Data Modelling Suggestions

m +1 Have the orders somewhere, and build a time ordered custom index to show them in order. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 6:28 AM, Guillermo Winkler wrote: > I think you need another CF as inde

Re: Node forgets about most of its column families

If this is still a test environment can you try to reproduce the fault ? Or provide some more details on the sequence of events? If you still have the logs around can you see if any ERROR level messages were logged? Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: are asynchronous schema updates possible ?

Concurrent schema changes are coming in 1.2. I could not find a single issue that covered it, that may be my bad search fu. The issues for 1.2 are here https://issues.apache.org/jira/browse/CASSANDRA/fixforversion/12319262 Cheers - Aaron Morton Freelance Developer

Re: two-node cassandra cluster

ing about ? How long will it take to transfer ? What will the network latency be like between the nodes ? Latency between new nodes can be a lottery. If you are storing the data on a single node that uses RAID 0, how will you handle disk failure ? Hope that helps. ----- Aar

  1   2   3   4   5   6   7   8   9   10   >