Re: Guaranteed order for syncing Records

Cassandra uses the writetime to resolve the conflict. Highest time stamp wins. There's no guarantee on the order the mutations arrive in. On Thu, Jul 6, 2017 at 7:14 AM suraj pasuparthy wrote: > thanks Pranay, > But is the order maintained across tables? > As in the client in DC1 first writes rec

Re: Guaranteed order for syncing Records

thanks Pranay, But is the order maintained across tables? As in the client in DC1 first writes record A in table A and then immediately writes Record B in Table B, So will the order be maintained, where in Table A gets synced first and then Table B? Thanks again -Suraj On Wed, Jul 5, 2017 at 11:0

Re: Guaranteed order for syncing Records

Hello suraj, Nope there will no out sync between same tables in different Datacenters, so Record A in Table A in Datacenter 1 will also be in Table A in Datacenter 2, just make sure there is no communication issues between Datacenters. Thanks Pranay. On Thu, Jul 6, 2017 at 2:01 AM, suraj pasupa

Guaranteed order for syncing Records

Hello Experts, I had a question We have a multi DC cluster for cassandra and wanted to confirm one behavior. Are the records order maintained while syncing to the backup datacenter? What i mean is, if say, Record A is written to a Table A and Record B is written to Table B on Datacenter 1, Does ca

Re: Deflate compressor

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 configurable as of cassandra 3.6 (

回复：hi, i have a question.

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), "牟宗传"  wrote:  >  >  > hi , i have a que

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

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 number of short-lived objects on t

Re: hi, i have a question.

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 you help me ? > thanks  >

Does select queries objects will be allocated in new_heap ??

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 also

Re: Merkle trees requests hanging

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.   T

hi, i have a question.

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

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 = org.apache.cassandra.metrics:name=TotalCommitLogSize,type=Co

Re: Merkle trees requests hanging

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 > # streaming_socket_timeout_in_ms: 0 to avoid this

Re: UDF for sorting

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 ( > https://github.com/Stratio/cassandra-lucene-index/blob/branch-3.0.10/doc/documentation.rst#searching > ). > > Keep in mind

Re: commitlog_total_space_in_mb tuning

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? 8G seems pretty ty

commitlog_total_space_in_mb tuning

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: org.apache.cassandra.metrics:name=WaitingOnSegmentAllocation,type=Commi

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

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

Re: Seed gossip version will not connect with that version

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 [MessagingService-Outgoing-/10.0.0.143] 2017-07-04 10:29:50,07

Seed gossip version will not connect with that version

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 OutboundTcpConne

stress tool: random seed

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 worka

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

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 < > lukasz.biedry...@gmail.com> wrote: > >> Hey, >>

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

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 SASI Index. > > Steps to repro

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

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)

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 = {'c