Limitations on secondary indexes

2013-03-07 Thread Edward Sargisson
Hi, Please correct me if this statement is wrong. Secondary indexes are limited to indexing 2 billion rows - because they turn a row into a column and C* has a limit of 2 billion columns. Cheers, Edward

Re: Force data to a specific node

2013-01-02 Thread Edward Sargisson
Why would you want to? From: Everton Lima To: Cassandra-User Sent: Wed Jan 02 18:03:49 2013 Subject: Force data to a specific node It is possible to force a data to stay in a specific node? -- Everton Lima Aleixo Bacharel em Ciência da Computação pela UFG Mestr

Re: cannot parse 'name' as hex bytes

2012-12-05 Thread Edward Sargisson
You're not casting the types. Cassandra stores everything as bytes. You either need to set the key_validation_class to UTF8Type or use the utf8() function to convert. http://www.datastax.com/docs/1.1/dml/using_cli On 12-12-05 03:14 AM, Yogesh Dhari wrote: Hi all, I am very new to Cassandra

Java 7 support?

2012-10-16 Thread Edward Sargisson
/install_deb, step 1 -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net <mailto:edward.sargis...@globalrelay.net> *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.3158.1301) Global Relay Archive supports email, i

Re: Nodetool repair, exit code/status?

2012-10-09 Thread Edward Sargisson
re is no way to verify the repair has completed successfully: https://issues.apache.org/jira/browse/CASSANDRA-2666 Is this still a problem? What is the best way to monitor the final status of the repair command to make sure all is well? Thank you ahead of time for any info. - David -- Edward Sa

Re: Losing keyspace on cassandra upgrade

2012-09-19 Thread Edward Sargisson
https://issues.apache.org/jira/browse/CASSANDRA-4583 On 12-09-19 08:30 AM, Michael Kjellman wrote: @Edward Do you have a bug number for that by chance? On Sep 19, 2012, at 8:25 AM, "Edward Sargisson" mailto:edward.sargis...@globalrelay.net>> wrote: We've seen that befor

Re: Losing keyspace on cassandra upgrade

2012-09-19 Thread Edward Sargisson
other resources on all Barracuda Networks solutions. Visit http://barracudanetworks.com/facebook -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net <mailto:edward.sargis...@globalrelay.net> *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9

Re: How to replace a dead *seed* node while keeping quorum

2012-09-12 Thread Edward Sargisson
stname change and retry the scenario as needed if you've got any ideas. HTH, JAmes" Cheers, Edward On 12-09-12 03:53 PM, Rob Coli wrote: On Tue, Sep 11, 2012 at 4:21 PM, Edward Sargisson wrote: If the downed node is a seed node then neither of the replace a dead node procedures

How to replace a dead *seed* node while keeping quorum

2012-09-11 Thread Edward Sargisson
? Cheers, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net <mailto:edward.sargis...@globalrelay.net> *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.3158.1301) Global Relay Archive supports

Re: Schema Disagreement after migration from 1.0.6 to 1.1.4

2012-09-05 Thread Edward Sargisson
iption, we tried running nodetool upgradesstables. When this had done, describe schema in the cli showed a schema definition which seemed correct, but was indeed different from the schema on the other nodes in the cluster. Any clues on how we should proceed? Thanks, /Martin Koch -- Edward Sargis

Re: Node forgets about most of its column families

2012-08-29 Thread Edward Sargisson
ate a ticket on https://issues.apache.org/jira/browse/CASSANDRA Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/08/2012, at 8:38 AM, Edward Sargisson <mailto:edward.sargis...@globalrelay.net>> wrote: For the record, we just

Re: Automating nodetool repair

2012-08-28 Thread Edward Sargisson
; do nodetool -h $n repair sleep 120 done A lot easier then managing a bunch of individual crontabs IMHO although I suppose I could of done it with puppet, but then you always have to keep an eye out that your repairs don't overlap over time. On Mon, Aug 27, 2012 at 4:52 PM, Edward Sargisson

Re: Node forgets about most of its column families

2012-08-28 Thread Edward Sargisson
etool resetlocalschema works. But the following nodetool repair crashes. It has to be stopped and then re-started. Are there any suggestions for logging or similar so that we can get a clue next time this happens. Cheers, Edward On 12-08-24 11:18 AM, Edward Sargisson wrote: Sadly, I don'

Automating nodetool repair

2012-08-27 Thread Edward Sargisson
at once. Or, perhaps, a central orchestrator that is given some known quiet time and works its way through the list, running nodetool repair one at a time (using RPC?) until it runs out of time. Cheers, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis

Re: Node forgets about most of its column families

2012-08-24 Thread Edward Sargisson
--- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 8:33 AM, Edward Sargisson <mailto:edward.sargis...@globalrelay.net>> wrote: Ah, yes, I forgot that bit thanks! 1.1.2 running on Centos. Running nodetool resetlocalschema then nodetool

Re: Node forgets about most of its column families

2012-08-23 Thread Edward Sargisson
Ah, yes, I forgot that bit thanks! 1.1.2 running on Centos. Running nodetool resetlocalschema then nodetool repair fixed the problem but not understanding what happened is a concern. Cheers, Edward On 12-08-23 12:40 PM, Rob Coli wrote: On Thu, Aug 23, 2012 at 11:47 AM, Edward Sargisson

Node forgets about most of its column families

2012-08-23 Thread Edward Sargisson
line 103) Skipped 3013 mutations from unknown (probably removed) CF with id 1017 ... and so on. Hector is saying: InvalidRequestException(why:unconfigured columnfamily user_conversations) Thanks for any comments or advice, Edward -- Edward Sargisson senior java developer Global Relay

Node doesn't rejoin ring after restart

2012-08-03 Thread Edward Sargisson
docs. I'm working on the assumption that a small outage on one node shouldn't cause extraordinary action. Nor do I want to have to stop every node before bringing them up one by one. What am I missing? Am I forced into those time consuming methods every time I want to restart? Th

Change of behaviour in multiget_slice query for unknown keys between 0.7 and 1.1?

2012-06-18 Thread Edward Sargisson
this behaviour? I'd like to see if there was an explanation before I change the unit test for it. Many thanks in advance, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net <mailto:edward.sargis...@globalrelay.net> *866.484.6630* New York

Performance impact of static vs dynamic columns and mixing the two in the same CF

2012-06-05 Thread Edward Sargisson
odel? Thanks in advance for any comments. Cheers, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net <mailto:edward.sargis...@globalrelay.net> *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.31