Re: How to set datastax-angent connect with jmx an

2015-06-02 Thread Jason Wee
the error in the log output looks similar to this http://serverfault.com/questions/614810/opscenter-4-1-4-authentication-failing , in the opscenter 5.1.2 , do you configure the username/password same with the agent and cassandra node too? jason On Wed, Jun 3, 2015 at 11:13 AM, 贺伟平 wrote: > > ​

How to set datastax-angent connect with jmx an

2015-06-02 Thread 贺伟平
​ I am using opscenter 5.1.2 and just enabled JMX username/password authentication on my Cassandra cluster. I think I've updated all my opscenter configs correctly to force the agents to use JMX auth, but it is not working. I've updated the config under /etc/opscenter/Clusters/[cluster-nam

Re: Spark SQL JDBC Server + DSE

2015-06-02 Thread Ben Bromhead
If you want a web based notebook style approach (similar to ipython) check out https://github.com/apache/incubator-zeppelin And https://github.com/apache/incubator-zeppelin/pull/86 Bonus free pretty graphs! On 1 June 2015 at 11:41, Sebastian Estevez wrote: > Have you looked at job server? > >

Re: Minor Compactions Not Triggered

2015-06-02 Thread Robert Coli
On Mon, Jun 1, 2015 at 11:25 AM, Anuj Wadehra wrote: > As per the algorithm shared in the CASSANDRA 6654, I understand that > tombstone_threshold property only comes into picture if you have expirying > columns and it wont have any effect if you have manually deleted rows in > cf. Is my understan

Re: Different number of records from COPY command

2015-06-02 Thread Saurabh Chandolia
Still getting inconsistent number of records on consistency ALL and QUORUM. Following is the output of consistency ALL and QUORUM. cqlsh:adlog> CONSISTENCY ALL; Consistency level set to ALL. cqlsh:adlog> copy adclicklog20150528 (imprid) TO 'adclicklog20150528.csv'; Processed 58000 rows; Write: 306

Re: Different number of records from COPY command

2015-06-02 Thread Anuj Wadehra
I have never exported data myself but can u just try setting 'consistency ALL' on cqlsh before executing command? Thanks Anuj Wadehra Sent from Yahoo Mail on Android From:"Saurabh Chandolia" Date:Tue, 2 Jun, 2015 at 8:47 pm Subject:Different number of records from COPY command I am seeing d

Different number of records from COPY command

2015-06-02 Thread Saurabh Chandolia
I am seeing different number of records each time I export a particular table. There were no writes/reads in this table while exporting the data. I am not able to understand why it is happening. Am I missing something here? Cassandra version: 2.1.4 Java driver version: 2.1.5 Cluster Size: 4 Nodes

Re: RE: Cassandra datacenters replication advanced usage

2015-06-02 Thread Anuj Wadehra
I think you should use local_quorum for writes and read consistency of consumer can be as per application requirement. I dont think that cross dc synchronous   reads/ writes are good choice.   Knowing when a batch ends is an application level problem nothing to do with Cassandra.  May be you ca

RE: Cassandra datacenters replication advanced usage

2015-06-02 Thread Fabrice Douchant
Hello Marcus and thank you for your fast reply. Yes, we thought about that and indeed it would work. However we really have writes and reads constraints for respectively producer and consumer datacenters so we would like to keep all/most access "local". We don't need synchronization between dat

Re: Cassandra datacenters replication advanced usage

2015-06-02 Thread Marcus Olsson
Hi Fabrice, Have you considered using "each_quorum" instead of "all"? Each_quorum will require replies from a quorum of nodes from all datacenters. This could be used either: Producer using each_quorum and consumer local_quroum. (better read latencies at the cost of write latencies) or Pr

Cassandra datacenters replication advanced usage

2015-06-02 Thread Fabrice Douchant
Hi everyone. For a project, we use a Cassandra cluster in order to have fast reads/writes on a large number of (column oriented) generated data. Until now, we only had 1 datacenter for prototyping. We now plan to split our cluster in 2 datacenters to meet performance requirements (the data tra

deadlock cleanup request due to compaction

2015-06-02 Thread Desimpel, Ignace
After adding a 5-th node I started running NodeProbe:: forceKeyspaceCleanup. That function is not returning. Below I added the program stack trace information that shows that in this case and probably others cases it is possible that there is a deadlock In my case, the compactionManager is call

Re: JSON Cassandra 2.2 - insert syntax

2015-06-02 Thread Sylvain Lebresne
Well, your column is not called "address", it's called "addresses". It's your type that is called "address". On Tue, Jun 2, 2015 at 4:39 AM, Michel Blase wrote: > Zach, > > this is embarrassing.you were right, I was running 2.1 > > shame on me! but now I'm getting the error: > > *Invalid

Re: How to interpret some GC logs

2015-06-02 Thread Michał Łowicki
On Tue, Jun 2, 2015 at 9:06 AM, Sebastian Martinka < sebastian.marti...@mercateo.com> wrote: > this should help you: > > https://blogs.oracle.com/poonam/entry/understanding_cms_gc_logs > I don't see there such format. Passed options related to GC are: -XX:+PrintGCDateStamps -Xloggc:/var/log/cas

Re: How to interpret some GC logs

2015-06-02 Thread Michał Łowicki
On Mon, Jun 1, 2015 at 7:25 PM, Jason Wee wrote: > can you tell what jvm is that? > root@db2:~# java -version java version "1.7.0_80" Java(TM) SE Runtime Environment (build 1.7.0_80-b15) Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode) > > jason > > On Mon, Jun 1, 2015 at 5:4

AW: How to interpret some GC logs

2015-06-02 Thread Sebastian Martinka
this should help you: https://blogs.oracle.com/poonam/entry/understanding_cms_gc_logs Best Regards, Sebastian Martinka Von: Michał Łowicki [mailto:mlowi...@gmail.com] Gesendet: Montag, 1. Juni 2015 11:47 An: user@cassandra.apache.org Betreff: How to interpret some GC logs Hi, Normally I get lo