Re: Keyspace lost after restart

2012-05-11 Thread Conan Cook
Hi, OK we're pretty sure we dropped and re-created the keyspace before restarting the Cassandra nodes during some testing (we've been migrating to a new cluster). The keyspace was created via the cli: create keyspace m7 with placement_strategy = 'NetworkTopologyStrategy' and strategy_options

Re: Keyspace lost after restart

2012-05-11 Thread Jeff Williams
Conan, Good to see I'm not alone in this! I just set up a fresh test cluster. I first did a fresh install of 1.1.0 and was able to replicate the issue. I then did a fresh install using 1.0.10 and didn't see the issue. So it looks like rolling back to 1.0.10 could be the answer for now. Jeff O

Re: Keyspace lost after restart

2012-05-11 Thread Conan Cook
Hi Jeff, Great! We'll roll back for now, thanks for letting me know. Conan On 11 May 2012 10:18, Jeff Williams wrote: > Conan, > > Good to see I'm not alone in this! I just set up a fresh test cluster. I > first did a fresh install of 1.1.0 and was able to replicate the issue. I > then did a

RE: Behavior on inconsistent reads

2012-05-11 Thread Carpenter, Curt
I (now) understand that the point of this is to get the most recent copy (at least of the nodes checked) if all replicas simply haven't been updated to the latest changes. But what about dealing with corruption? What if the most recent copy is corrupt? With a Zookeeper-based transaction system on t

Re: Thrift error occurred during processing of message

2012-05-11 Thread Alain RODRIGUEZ
Hi, I guess you finally solved this issue. I'm experimenting the same one when trying to upgrade to phpcass 1.0.a.1. Do you remember how you fixed it or what the problem was exactly ? Thanks, Alain 2011/12/19 Tamil selvan R.S > Hi, > We are using PHPCassa to connect to Cassandra 1.0.2. After

Re: Thrift error occurred during processing of message

2012-05-11 Thread Alain RODRIGUEZ
I got the error above in cassandra logs. In my web browser I have the following error : "500 | Internal Server Error | TApplicationException Required field 'reversed' was not found in serialized data! Struct: SliceRange(start:80 01 00 01 00 00 00 0E 6D 75 6C 74 69 67 65 74 5F 73 6C 69 63 65 00 0

primary keys query

2012-05-11 Thread cyril auburtin
Sorry for askign that but Why is it necessary to always have at least one EQ comparison [default@Keyspace1] get test where birth_year>1985; No indexed columns present in index clause with operator EQ It oblige to have one dummy indexed column, to do this query [default@Keyspace1] get test wh

Re: Cassandra stucks

2012-05-11 Thread David Leimbach
What's the version number of Cassandra? On Fri, May 11, 2012 at 7:38 AM, Pavel Polushkin wrote: > Hello, > > ** ** > > We faced with a strange problem while testing performance on Cassandra > cluster. After some time all nodes went to down state for several days. Now > all nodes went back to

Re: primary keys query

2012-05-11 Thread Dave Brosius
Inequalities on secondary indices are always done in memory, so without at least one EQ on another secondary index you will be loading every row in the database, which with a massive database isn't a good idea. So by requiring at least one EQ on an index, you hopefully limit the set of rows tha

RE: Cassandra stucks

2012-05-11 Thread Pavel Polushkin
We use 1.0.8 version. From: David Leimbach [mailto:leim...@gmail.com] Sent: Friday, May 11, 2012 18:48 To: user@cassandra.apache.org Subject: Re: Cassandra stucks What's the version number of Cassandra? On Fri, May 11, 2012 at 7:38 AM, Pavel Polushkin wrote: Hello, We faced with a s

Re: Cassandra stucks

2012-05-11 Thread Madalina Matei
Are you using EC2 ? On 11 May 2012, at 16:13, Pavel Polushkin wrote: > We use 1.0.8 version. > > From: David Leimbach [mailto:leim...@gmail.com] > Sent: Friday, May 11, 2012 18:48 > To: user@cassandra.apache.org > Subject: Re: Cassandra stucks > > What's the version number of Cassandra? > >

RE: Cassandra stucks

2012-05-11 Thread Pavel Polushkin
No We are using dedicated phisical hardware. Currently we have 5 nodes. From: Madalina Matei [mailto:madalinaima...@gmail.com] Sent: Friday, May 11, 2012 19:40 To: user@cassandra.apache.org Subject: Re: Cassandra stucks Are you using EC2 ? On 11 May 2012, at 16:13, Pavel Polushkin wrot

Re: Cassandra stucks

2012-05-11 Thread Madalina Matei
Check your JMX port in cassandra-env.sh and see if that's open. Also if you have enabled JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=" and you are using an ip address for -Djava.rmi.server.hostname make sure that is the correct ip. On 11 May 2012, at 16:42, Pavel Polushkin wrote: > No

Re: Losing key cache on restart

2012-05-11 Thread Omid Aladini
Hey, Sorry for the late response. On Wed, Apr 25, 2012 at 1:36 AM, aaron morton wrote: > - Cassandra log reports 12,955,585 of them have been saved on the last save > events. > > Has their been much activity between saves ? For testing I set the key_cache_save_period to a short period of 10 min

RE: Cassandra stucks

2012-05-11 Thread Pavel Polushkin
Hello, Actually there is no problems with JMX, it works fine when node are in UP state. But after a while cluster goes to inadequate state. For now it seems that it's a bug of connection handling in Cassandra. Pavel. From: Madalina Matei [mailto:madalinaima...@gmail.com] Sent: Friday, May

Re: primary keys query

2012-05-11 Thread cyril auburtin
I was thinking of a CF with many many rows with id, type, latitude and longitude (indexed), and do geolocation queries: type=all and lat < 43 and lat >42.9 and lon < 7.3 and lon > 7.2 where all rows have type=all (at least try how Cassandra deals with that) So it seems it's not a good idea, to use

Re: Cassandra backup question regarding commitlogs

2012-05-11 Thread Vijay
The incremental backups are generated when the flush is complete (Only during the flush), If the node crash before the flush completes then the commit logs in the local node's backup for the data in memory. It wouldn't help to copy the Commit log across because they are not immutable (They are recy

Select on indexed columns and with IN clause for the PRIMARY KEY

2012-05-11 Thread Roland Mechler
I am using C* 1.1 and CQL 3.0. Am trying to do a select with an IN clause for the primary key, and on an indexed column, which appears to not be supported: cqlsh:Keyspace1> SELECT * FROM TestTable WHERE id IN ('1', '2') AND data = 'b'; Bad Request: Select on indexed columns and with IN cla

Re: Thrift error occurred during processing of message

2012-05-11 Thread Tyler Hobbs
Can you paste a snippet of your code showing how you're creating the ColumnSlice and calling get()? On Fri, May 11, 2012 at 8:16 AM, Alain RODRIGUEZ wrote: > I got the error above in cassandra logs. > > In my web browser I have the following error : > > "500 | Internal Server Error | TApplicatio

Re: cassandra 1.0.9 error - "Read an invalid frame size of 0"

2012-05-11 Thread Gurpreet Singh
This is hampering our testing of cassandra a lot, and our move to cassandra 1.0.9. Has anyone seen this before? Should I be trying a different version of cassandra? /G On Thu, May 10, 2012 at 11:29 PM, Gurpreet Singh wrote: > Hi, > i have created 1 node cluster of cassandra 1.0.9. I am setting t

C 1.1 & CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
I have C* 1.1 but it seems to only come with cql 2.0 INFO 19:35:21,579 Cassandra version: 1.1.0 INFO 19:35:21,581 Thrift API version: 19.30.0 INFO 19:35:21,583 CQL supported versions: 2.0.0,3.0.0-beta1 (default: 2.0.0) the problem is I would like to create such CF : CREATE COLUMNFAMILY TaggedP

Re: Thrift error occurred during processing of message

2012-05-11 Thread Alain RODRIGUEZ
Thank you for the fast answer Tylor, I just discover the existence of the "ColumnSlice" class. I was using phpcassa for a while and didn't notice about this evolution. If I want to get just a column should I do : $slice = new ColumnSlice('name', 'name'); $result = $cf->get($key, $slice); or $r

RE: C 1.1 & CQL 2.0 or 3.0?

2012-05-11 Thread Jason Wellonen
Version 2 is the default for your connection. Are you using cqlsh? If so, use the "-3" parameter for version 3... From: cyril auburtin [mailto:cyril.aubur...@gmail.com] Sent: Friday, May 11, 2012 10:51 AM To: user@cassandra.apache.org Subject: C 1.1 & CQL 2.

Re: Thrift error occurred during processing of message

2012-05-11 Thread Tyler Hobbs
If you're only fetching a single column and you know its name, use the second form. However, they should both technically work. I introduced it because PHP only has positional parameters and most of the parameters are optional, so having 6 or 10 parameters was annoying when you only needed to set

Re: Thrift error occurred during processing of message

2012-05-11 Thread ruslan usifov
Looks like you used TBUfferedTransport, but sinve 1.0.x cassandra support only framed 2011/12/19 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

Re: C 1.1 & CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
thx just: can't connect to keyspace with cql 3.0 tic@my:~$ cqlsh Connected to My Cluster at 127.0.0.1:4201. [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 2.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use mykeyspace; cqlsh:mykeyspace> exit; tic@my:~$ cqlsh -3 Connected to My Cluster at 127

RE: C 1.1 & CQL 2.0 or 3.0?

2012-05-11 Thread Jason Wellonen
I think you need to create the keyspace under the context of a v3 connection. Maybe someone else can confirm? From: cyril auburtin [mailto:cyril.aubur...@gmail.com] Sent: Friday, May 11, 2012 11:46 AM To: user@cassandra.apache.org Subject: Re: C 1.1 & CQL 2.0

Re: C 1.1 & CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
it works with a 'raw' keyspace (create keyspace mykeyspace;) but not with create keyspace mykeyspace with placement_strategy='SimpleStrategy' and strategy_options = {replication_factor:1}; ( ^ the config mykeyspace had) 2012/5/11 cyril auburtin > thx just: can't connect to keyspace with cql 3.0

Re: C 1.1 & CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
yes it seems so as long as I create (more than just create keyspace mykeyspace) it with cassandra cli, by creating CF, then I can't connect to it with cqlsh -3 I'll need to translate it in cql3 then 2012/5/11 Jason Wellonen > ** > I think you need to create the keyspace under the context of a

Does or will Cassandra support OpenJDK ?

2012-05-11 Thread ramesh
I've had problem downloading the Sun (Oracle) JDK and found this thread where the Oracle official is insisting or rather forcing Linux users to move to OpenJDK. Here is the thread https://forums.oracle.com/forums/thread.jspa?threadID=2365607 I need this because I run Cassandra. Just curious to

zabbix templates

2012-05-11 Thread Cord MacLeod
I've seen some Cacti templates for Cassandra and a JMX bridge called zap cat, but has anyone created Zabbix templates for Cassandra?