Re: Deflate compressor

2017-07-05 Thread Jeff Jirsa
On 2017-07-01 02:50 (-0700), Cogumelos Maravilha wrote: > Hi list, > > Is there a way to set Deflate level of compression? > > Brotli sounds good but unstable. > > I just need more compression ratio. > > I'm using C* 3.11.0 > LZ4 compression levels are

回复:hi, i have a question.

2017-07-05 Thread 牟宗传
hi jirsa,thank you very much! i'll try it . best regards!   --发件人:Jeff Jirsa 发送时间:2017年7月6日(星期四) 13:15收件人:user 主 题:Re: hi, i have a question. On 2017-07-05 19:29 (-0700), 

Re: Does select queries objects will be allocated in new_heap ??

2017-07-05 Thread Jeff Jirsa
On 2017-07-05 21:50 (-0700), Pranay akula wrote: > Hai, > > I have a small doubt i am not much familiar with java, so when a select or > insert query is executed against a node does the output of that query will > be stored in heap ?? > SELECT will create a

Re: hi, i have a question.

2017-07-05 Thread Jeff Jirsa
On 2017-07-05 19:29 (-0700), "牟宗传" wrote: > > > hi , i have a question .    how could i connect to cassandra-cluster( > "TEST CLUSTER")? i would not connect to one node IP of cluster ,because when > the node down, i could not do something?     could

Does select queries objects will be allocated in new_heap ??

2017-07-05 Thread Pranay akula
Hai, I have a small doubt i am not much familiar with java, so when a select or insert query is executed against a node does the output of that query will be stored in heap ?? For insert query the output will stored in Memtables will is part on new_heap right ?? does select and other queries

Re: Merkle trees requests hanging

2017-07-05 Thread Anuj Wadehra
Hi Jean,  Ensure that your firewall is not timing out idle connections. Nodes should time out idle connections first (using tcp keep alive settings before firewall does it). Please refer  http://docs.datastax.com/en/archived/cassandra/2.0/cassandra/troubleshooting/trblshootIdleFirewall.html.  

hi, i have a question.

2017-07-05 Thread 牟宗传
hi , i have a question .how could i connect to cassandra-cluster( "TEST CLUSTER")? i would not connect to one node IP of cluster ,because when the node down, i could not do something? could you help me ? thanks 

Re: commitlog_total_space_in_mb tuning

2017-07-05 Thread Jay Zhuang
Thanks Jeff for the quick response. We're running with 3.0.13 which doesn't have commitlog_segment_recycling option. So it should be disabled. I think the CL flush is because commitlog full. The commitlog size is closing to 8G: #mbean =

Re: Merkle trees requests hanging

2017-07-05 Thread Jeff Jirsa
On 2017-07-04 07:11 (-0700), Jean Carlo wrote: > Hello. > > What if a node send a merkle tree to its replica but this one would never > received by any network issues. The repair will be hanging eternally ? or > Should I modify the parameter > #

Re: UDF for sorting

2017-07-05 Thread Jeff Jirsa
On 2017-07-03 16:19 (-0700), Justin Cameron wrote: > While you can't do this with Cassandra, you can get the functionality you > want with the cassandra-lucene-plugin ( >

Re: commitlog_total_space_in_mb tuning

2017-07-05 Thread Jeff Jirsa
On 2017-07-05 14:32 (-0700), Jay Zhuang wrote: > Hi, > > commitlog_total_space_in_mb is increased from 1G to 8G in > CASSANDRA-7031. Sometimes we saw the number of dropped mutations spikes. > Not sure if it's a sign that we should increase the >

commitlog_total_space_in_mb tuning

2017-07-05 Thread Jay Zhuang
Hi, commitlog_total_space_in_mb is increased from 1G to 8G in CASSANDRA-7031. Sometimes we saw the number of dropped mutations spikes. Not sure if it's a sign that we should increase the commitlog_total_space_in_mb? For bean:

Re: Best practice to add(bootstrap) multiple nodes to cluster at once

2017-07-05 Thread Alain RODRIGUEZ
Sorry about the delay, but a colleague wrote this, that I believe might be of interest: http://thelastpickle.com/blog/2017/05/23/auto-bootstrapping-part1.html. Specially this part: http://thelastpickle.com/blog/2017/05/23/auto-bootstrapping-part1.html#adding-multiple-nodes . Still unless it is

Re: Seed gossip version will not connect with that version

2017-07-05 Thread Nitan Kainth
Restart could help with hung gossip but check you network as possible root cause for this. Sent from my iPhone > On Jul 5, 2017, at 7:23 AM, Jean Carlo wrote: > > Hello > > I have repairs that hangs because this problem > > WARN

Seed gossip version will not connect with that version

2017-07-05 Thread Jean Carlo
Hello I have repairs that hangs because this problem WARN [MessagingService-Outgoing-/10.0.0.143] 2017-07-04 10:29:50,076 OutboundTcpConnection.java:416 - Seed gossip version is -2147483648; will not connect with that version INFO [HANDSHAKE-/10.0.0.143] 2017-07-04 10:29:50,076

stress tool: random seed

2017-07-05 Thread Vlad
Hi, I'm populating database with YAML. Each time I run stress tool I get the same rows, i.e. the same data generated and no new rows appear. Is there any option to generate each time new data? I would like to test growing database, but don't want insert each time all data. I found a kind of

Re: Error when starting cassandra: Unable to make UUID from 'aa' (SASI index)

2017-07-05 Thread Łukasz Biedrycki
Yes, I tested 3.11, it exists. Thank you, I'll open up a Jira. On Wed, Jul 5, 2017 at 1:27 PM, Jonathan Haddad wrote: > You should check if the same error exists in 3.11. If so, open up a Jira. > On Wed, Jul 5, 2017 at 10:38 AM Łukasz Biedrycki < >

Re: Error when starting cassandra: Unable to make UUID from 'aa' (SASI index)

2017-07-05 Thread Jonathan Haddad
You should check if the same error exists in 3.11. If so, open up a Jira. On Wed, Jul 5, 2017 at 10:38 AM Łukasz Biedrycki wrote: > Hey, > > I am using Cassandra 3.9. > > Recently I experienced a problem that prevents me to restart cassandra. I > narrowed it down to

Re: Adding a New Node With The Same IP of an Old Node

2017-07-05 Thread Shalom Sagges
Thanks Nitan! Eventually it was a firewall issue related to the Centos7 node. Once fixed, the rolling restart resolved the issue completely. Thanks again! Shalom Sagges DBA T: +972-74-700-4035

Error when starting cassandra: Unable to make UUID from 'aa' (SASI index)

2017-07-05 Thread Łukasz Biedrycki
Hey, I am using Cassandra 3.9. Recently I experienced a problem that prevents me to restart cassandra. I narrowed it down to SASI Index. Steps to reproduce: 1. start cassandra (./bin/cassandra -f) 2. create keyspace, table, index and add data: CREATE KEYSPACE testkeyspace WITH replication =