columns disappearing intermittently

2013-07-03 Thread Blake Eggleston
Hi All, We're having a problem with our cassandra cluster and are at a loss as to the cause. We have what appear to be columns that disappear for a little while, then reappear. The rest of the row is returned normally during this time. This is, of course, very disturbing, and is wreaking

Re: Problem with libcassandra

2013-07-03 Thread Shubham Mittal
This is the gdb output [Thread debugging using libthread_db enabled] terminate called after throwing an instance of 'org::apache::cassandra::InvalidRequestException' what(): Default TException. Program received signal SIGABRT, Aborted. 0x770a0b25 in raise () from /lib/libc.so.6 On

Re: Problem with libcassandra

2013-07-03 Thread Shubham Mittal
no Jordan, the cassandra version I have is Cassandra 1.1.12 On Wed, Jul 3, 2013 at 5:21 PM, Shubham Mittal smsmitta...@gmail.comwrote: This is the gdb output [Thread debugging using libthread_db enabled] terminate called after throwing an instance of

Re: columns disappearing intermittently

2013-07-03 Thread Eric Stevens
I wonder if one particular node is having trouble; when you notice the missing column, what happens if you execute the read manually from cqlsh or cassandra-cli independently directly on each node? On Wed, Jul 3, 2013 at 2:00 AM, Blake Eggleston bl...@grapheffect.comwrote: Hi All, We're

Re: Problem with libcassandra

2013-07-03 Thread Shubham Mittal
Hey, I found out that the problem is caused by this line : c-createKeyspace(ks_def); because the below code works fine. #include string.h #include sstream #include iostream #include stdlib.h #include set #include string #include stdio.h #include vector #include libcassandra/cassandra_factory.h

Re: Problem with libcassandra

2013-07-03 Thread Alexis Rodríguez
That repo for libcassandra works for cassandra 0.7.x due to changes in the thrift interface we have faced some problems in the past. May be you can take a look to my fork of libcassandra https://github.com/axs -mvd/libcassandra that we are using with cassandra 1.1.11. Besides that, I recommend

Opscenter access roles

2013-07-03 Thread cscetbon.ext
Hi, When we connect to Opscenter using an account, we do not see any disconnect button to connect under another account. Thanks -- Cyril SCETBON _ Ce message et ses pieces

column sort order and reversed sort performance question

2013-07-03 Thread Hiller, Dean
We loaded 5 million columns into a single row and when accessing the first 30k and last 30k columns we saw no performance difference. We tried just loading 2 rows from the beginning and end and saw no performance difference. I am sure reverse sort is there for a reason though. In what

Re: schema management

2013-07-03 Thread Franc Carter
On Wed, Jul 3, 2013 at 2:06 AM, Silas Smith silas.sm...@gmail.com wrote: Franc, We manage our schema through the Astyanax driver. It runs in a listener at application startup. We read a self-defined schema version, update the schema if needed based on the version number, and then write the

Re: Problem with libcassandra

2013-07-03 Thread Shubham Mittal
hi Alexis, Even if I create keyspaces, column families using cassandra-cli, the column creation and insertion work will still need thrift calls. On Wed, Jul 3, 2013 at 6:05 PM, Alexis Rodríguez arodrig...@inconcertcc.com wrote: That repo for libcassandra works for cassandra 0.7.x due to

Re: Problem with libcassandra

2013-07-03 Thread Alexis Rodríguez
Shubham, You are right, my point is that with non schema-update thrift calls you can tune the consistency level used. bye. On Wed, Jul 3, 2013 at 10:10 AM, Shubham Mittal smsmitta...@gmail.comwrote: hi Alexis, Even if I create keyspaces, column families using cassandra-cli, the column

Added nodes to cluster, authentication stopped working

2013-07-03 Thread Carlos Rolo
Hi all, I have a Cassandra Cluster running and we recently duplicated the cluster. After following all the steps, the cassandra clients started failing with the following message: AuthenticationException(why='Username and/or password are incorrect') The problem is that even I can't login to

CorruptBlockException - recover?

2013-07-03 Thread ifjke
Hi together, I found that one of my cassandra nodes died recently (machine hangs). I restarted the node an run a nodetool repair, while running it has thrown a org.apache.cassandra.io.compress.CorruptBlockException. Is there any way to recover from this? Or would it be best to delete the

Re: Opscenter access roles

2013-07-03 Thread Nick Bailey
OpsCenter uses http auth so the credentials will be saved by your browser. There are a couple things you could do. * Clear the local data/cache on your browser * Open your browser in private browsing/incognito mode * Manually enter credentials into the url: http:// user:pw@opscenter_ip:/

Embedded Cassandra 1.2

2013-07-03 Thread Sávio Teles
We are using Cassandra 1.2 Embedded in a production environment. We are some issues with these lines: SocketAddress remoteSocket.get = socket (); assert socket! = null; ThriftClientState cState = activeSocketSessions.get (socket); The connection is maintained by remoteSocket thread.

Re: Opscenter access roles

2013-07-03 Thread cscetbon.ext
thanks Nick, I'll give it a try Regards -- Cyril SCETBON On Jul 3, 2013, at 5:16 PM, Nick Bailey n...@datastax.commailto:n...@datastax.com wrote: OpsCenter uses http auth so the credentials will be saved by your browser. There are a couple things you could do. * Clear the local data/cache on

Lots of replicate on write tasks pending, want to investigate

2013-07-03 Thread Andrew Bialecki
In one of our load tests, we're incrementing a single counter column as well as appending columns to a single row (essentially a timeline). You can think of it as counting the instances of an event and then keeping a timeline of those events. The ratio is of increments to appends is 1:1. When we

Re: Lots of replicate on write tasks pending, want to investigate

2013-07-03 Thread Robert Coli
On Wed, Jul 3, 2013 at 9:59 AM, Andrew Bialecki andrew.biale...@gmail.comwrote: 2. I'm assuming in our case the cause is incrementing counters because disk reads are part of the write path for counters and are not for appending columns to a row. Does that logic make sense? That's a pretty

Re: CorruptBlockException - recover?

2013-07-03 Thread Robert Coli
On Wed, Jul 3, 2013 at 7:04 AM, ifjke j.kes...@enercast.de wrote: I found that one of my cassandra nodes died recently (machine hangs). I restarted the node an run a nodetool repair, while running it has thrown a org.apache.cassandra.io.**compress.**CorruptBlockException. Is there any way to

Re: CorruptBlockException - recover?

2013-07-03 Thread Glenn Thompson
For what its worth. I did this when I had this problem. It didn't work out for me. Perhaps I did something wrong. On Wed, Jul 3, 2013 at 11:06 AM, Robert Coli rc...@eventbrite.com wrote: On Wed, Jul 3, 2013 at 7:04 AM, ifjke j.kes...@enercast.de wrote: I found that one of my cassandra

Re: column sort order and reversed sort performance question

2013-07-03 Thread Robert Coli
On Wed, Jul 3, 2013 at 6:02 AM, Hiller, Dean dean.hil...@nrel.gov wrote: We loaded 5 million columns into a single row and when accessing the first 30k and last 30k columns we saw no performance difference. We tried just loading 2 rows from the beginning and end and saw no performance

cqlsh + existing cf's + query

2013-07-03 Thread William Oberman
I've been running cassandra a while, and have used the PHP api and cassandra-cli, but never gave cqlsh a shot. I'm not quite getting it. My most simple CF is a dumping ground for testing things created as: create column family stats; I was putting random stats I was computing in it. All keys,

Cassandra with vnode and ByteOrderedPartition

2013-07-03 Thread Sávio Teles
We're using ByteOrderedPartition to programmatically choose the machine which a objet will be inserted.* *How can I use *ByteOrderedPartition *with vnode on Cassandra 1.2? * * -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando

Re: Cassandra with vnode and ByteOrderedPartition

2013-07-03 Thread Richard Low
On 3 July 2013 21:04, Sávio Teles savio.te...@lupa.inf.ufg.br wrote: We're using ByteOrderedPartition to programmatically choose the machine which a objet will be inserted.* *How can I use *ByteOrderedPartition *with vnode on Cassandra 1.2? Don't. Managing tokens with ByteOrderedPartitioner

Re: Cassandra with vnode and ByteOrderedPartition

2013-07-03 Thread Sávio Teles
We were able to implement ByteOrderedPartition on Cassandra 1.1 and insert an object in a specific machine. However, with Cassandra 1.2 and VNodes we can't implement VNode with ByteOrderedPartitioner to insert an object in a specific machine. 2013/7/3 Richard Low rich...@wentnet.com On 3 July

Re: Cassandra with vnode and ByteOrderedPartition

2013-07-03 Thread Richard Low
On 3 July 2013 22:18, Sávio Teles savio.te...@lupa.inf.ufg.br wrote: We were able to implement ByteOrderedPartition on Cassandra 1.1 and insert an object in a specific machine. However, with Cassandra 1.2 and VNodes we can't implement VNode with ByteOrderedPartitioner to insert an object

Re: Lots of replicate on write tasks pending, want to investigate

2013-07-03 Thread Andrew Bialecki
Can someone remind me why replicate on write tasks might be related to the high disk I/O? My understanding is the replicate on write involves sending the update to other nodes, so it shouldn't involve any disk activity -- disk activity would be during the mutation/write phase. The write path (not

Ranged Tombstones causing timeouts, not removed during compaction. How to remove?

2013-07-03 Thread Jeff House
We are on 1.2.5 with a 4 node cluster (RF 3) and have a cql3 wide row table. each row has about 2000 columns. While running some test data through it, it started throwing rpc_timeout errors when returning a couple specific rows (with Consistency ONE). After hunting through sstable2json results

Re: Ranged Tombstones causing timeouts, not removed during compaction. How to remove?

2013-07-03 Thread Jeremiah D Jordan
To force clean out a tombstone. 1. Stop doing deletes on the CF, or switch to performing all deletes at ALL 2. Run a full repair of the cluster for that CF. 3. Change GC grace to be small, like 5 seconds or something for that CF Either: 4. Find all sstables which have that row key in them using

Re: Ranged Tombstones causing timeouts, not removed during compaction. How to remove?

2013-07-03 Thread Jeff House
Thanks Jeremiah, those are great suggestions. Unfortunately, I have done a full repair and compaction on that CF, but the ranged tombstones remain. -Jeff On Wed, Jul 3, 2013 at 7:54 PM, Jeremiah D Jordan jeremiah.jor...@gmail.com wrote: To force clean out a tombstone. 1. Stop doing