dblink between oracle and cassandra

2015-01-30 Thread Rahul Bhardwaj
Hi All, I want make a dblink from oracle 11g and cassandra cluster. Is there any way or any alternative to do the same. please help. Regards: Rahul Bhardwaj -- Follow IndiaMART.com for latest updates on this and more:

Cassandra 2.0.11 with stargate-core read writes are slow

2015-01-30 Thread Asit KAUSHIK
Hi all, We are testing our logging application on 3 node cluster each system is virtual machine with 4 cores and 8GB RAM with RedHat enterprise. Now my question is in 3 parts 1) Am I using the right hardware as of now I am testing say 10 record reads. 2) I am using Stargate-core for full text s

Re: Unable to create a keyspace

2015-01-30 Thread Saurabh Sethi
I repeat the test after verifying that the keyspace has been dropped. Also, I do not want any replication as of now that’s why replication factor is 1. But I don’t think that should be the reason for the command not propagating to other nodes. One more thing that I observed right now is that if

Re: Unable to create a keyspace

2015-01-30 Thread Asit KAUSHIK
Saurabh a vague suggestion when you are dropping can you wait for sometime to let the change propagate to other node.Also I see a replication factor 1 but you have 3 nodes On Jan 31, 2015 6:28 AM, "Saurabh Sethi" wrote: > Thanks Adam. I upgraded to 2.1.2 but still seeing this issue. Let me go

Re: Unable to create a keyspace

2015-01-30 Thread Saurabh Sethi
Thanks Adam. I upgraded to 2.1.2 but still seeing this issue. Let me go in a bit more detail as to what I am seeing – When I create a keyspace for the first time in a 3 node cluster, it works fine but if I drop the keyspace and try to recreate it, I see that the node received the request to crea

Re: Should one expect to see hints being stored/delivered occasionally?

2015-01-30 Thread Vasileios Vlachos
Thanks for your reply Rob, I am back to this after a while... I am not sure if this is different in 1.2.18, but I remember from older versions that GC pauses would only be logged in the /system.log/ if their duration /was >= 200ms/. Also, when hints are detected, we cannot correlate it with GC

Re: Unable to create a keyspace

2015-01-30 Thread Adam Holmberg
I would first ask if you could upgrade to the latest version of Cassandra 2.1.x (presently 2.1.2). If the issue still occurs consistently, it would be interesting to turn up logging on the client side and see if something is causing the client to disconnect during the metadata refresh following th

Re: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-01-30 Thread Adam Holmberg
Assuming the truststore you are referencing is the same one the server is using, it's probably in the wrong format. You will need to export the cert into a PEM format for use in the (Python) cqlsh client. If exporting from the java keystore format, use keytool -exportcert -rfc -file If you have

RE: Tombstone gc after gc grace seconds

2015-01-30 Thread Ravi Agrawal
I did a small test. I wrote data to 4 different column family. 30MB of data. 256 rowkeys and 100K columns on an average. And then deleted all data from all of them. 1. Md_normal - created using default compaction parameters and Gc Grace seconds was 5 seconds. Data was written and then dele

Re: Timeouts but returned consistency level is invalid

2015-01-30 Thread Michał Łowicki
Thanks Philip. This explains why I see ALL. Any idea why sometimes ONE is returned? — Michał On Fri, Jan 30, 2015 at 4:18 PM, Philip Thompson wrote: > Jan is incorrect. Keyspaces do not have consistency levels set on them. > Consistency Levels are always set by the client. You are almost certa

Re: Timeouts but returned consistency level is invalid

2015-01-30 Thread Philip Thompson
Jan is incorrect. Keyspaces do not have consistency levels set on them. Consistency Levels are always set by the client. You are almost certainly running into https://issues.apache.org/jira/browse/CASSANDRA-7947 which is fixed in 2.1.3 and 2.0.12. On Fri, Jan 30, 2015 at 8:37 AM, Michał Łowicki w

Re: Timeouts but returned consistency level is invalid

2015-01-30 Thread Michał Łowicki
Hi Jan, I'm using only one keyspace. Even if it defaults to ONE why sometimes ALL is returned? On Fri, Jan 30, 2015 at 2:28 PM, Jan wrote: > HI Michal; > > The consistency level defaults to ONE for all write and read operations. > However consistency level is also set for the keyspace. > > Coul

Re: Timeouts but returned consistency level is invalid

2015-01-30 Thread Jan
HI Michal;  The consistency level defaults to ONE for all write and read operations. However consistency level is also set for the keyspace.  Could it be possible that your queries are spanning multiple keyspaces which bear different levels of consistency ?   cheersJan C* Architect On Frida

Re: Tombstone gc after gc grace seconds

2015-01-30 Thread Alain RODRIGUEZ
The point is that all the "parts" or "fragments" of the row need to be in the SSTables implied in the compaction for C* to be able to evict the row effectively. My understanding of those parameters is that they will trigger a compaction on the SSTable that exceed this ratio. This will work properl

Timeouts but returned consistency level is invalid

2015-01-30 Thread Michał Łowicki
Hi, We're using C* 2.1.2, django-cassandra-engine which in turn uses cqlengine. LOCAL_QUROUM is set as default consistency level. From time to time we get timeouts while talking to the database but what is strange returned consistency level is not LOCAL_QUROUM: code=1200 [Coordinator node timed o