答复: sstabledump and liveness_info question

Hi Anyone can help on this would be highly appreciated. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: Xiangfei Ni 发送时间: 2018年6月8日 13:37 收件人: user 主题

sstabledump and liveness_info question

Hi Expert, I have questions about sstabledump 1,create table and insert data: create table test2(a text,b text,primary key (a)); insert into test2(a,b) values ('a','b'); 2,flush data to disk 3,sstabledump the sstable [cassandra@concar-cassandra01] /opt/database/apache-cassandra

答复: 答复: Re: cassandra update vs insert + delete

: Fwd: 答复: Re: cassandra update vs insert + delete It seems that i can't update a part of primary key in cqlsh update: message "PRIMARY Key part column found in SET part" Sent using Zoho Mail<https://www.zoho.com/mail/> Forwarded message ======

答复: Re: cassandra update vs insert + delete

Yes, you are correct. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: onmstester onmstester 发送时间: 2018年5月28日 14:33 收件人: user 主题: Fwd: Re: cassandra upda

3.11.2 io.netty.channel.unix.FileDescriptor.readAddress(...)(Unknown Source)

Hi Expert, I have this error in the Cassandra logs,the nodes are ok and behave as normal, INFO [epollEventLoopGroup-2-8] 2018-05-05 16:57:45,537 Message.java:623 - Unexpected exception during request; channel = [id: 0xa4879fdd, L:/10.175.20.112:9042 - R:/10.175.20.73:2508] io.netty.channel.uni

答复: upgrade from 3.9 to 3.11.2

after the upgrade. It’s a no-op if there is nothing to upgrade. Hannu On 3 May 2018, at 09:57, Xiangfei Ni mailto:xiangfei...@cm-dt.com>> wrote: Hi Community I have a question regarding upgrading Cassandra from 3.9 to 3.11.2, Do I need to run nodetool upgradesstables when I do the u

答复: upgrade from 3.9 to 3.11.2

13797007811|Tel: + 86 27 5024 2516 发件人: Hannu Kröger 发送时间: 2018年5月3日 15:00 收件人: user 主题: Re: upgrade from 3.9 to 3.11.2 Hello, it never hurts to run “nodetool upgradesstables" after the upgrade. It’s a no-op if there is nothing to upgrade. Hannu On 3 May 2018, at 09:57, Xiangf

upgrade from 3.9 to 3.11.2

Hi Community I have a question regarding upgrading Cassandra from 3.9 to 3.11.2, Do I need to run nodetool upgradesstables when I do the upgrade?we know that we don’t need to run this command when we do minor version upgrade.But from 3.9 to 3.11.2,I have no idea. Also I suggest that the com

答复: 答复: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

On 20 April 2018 at 10:21, Xiangfei Ni mailto:xiangfei...@cm-dt.com>> wrote: Hi Nicolas, Thanks for your reply. The doc you sent to me only includes what have been upgrade between every version,but I want the doc of how to do the online upgrade,do you have this kind of doc? Best Rega

答复: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

/blob/trunk/NEWS.txt which list every modification / advice for upgrading between each C* version On 20 April 2018 at 09:25, Xiangfei Ni mailto:xiangfei...@cm-dt.com>> wrote: By the way,is there official documentation for online upgrade cassandra from 3.9 to 3.11.2 which I can follow?

答复: Cassandra 3.7 - Problem with Repairs - all nodes failing

By the way,is there official documentation for online upgrade cassandra from 3.9 to 3.11.2 which I can follow? Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516

答复: 答复: Time serial column family design

ys being retrieved into the client instead of relying on the coordinator assembling the results. You have to do more work and add some complexity, but the trade off will be much higher performance as you are removing the single coordinator as the bottleneck. On Tue, Apr 17, 2018 at 10:05 P

答复: Time serial column family design

Hi Nate, Thanks for your reply! Is there other way to design this table to meet this requirement? Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人:

Time serial column family design

Hi Experts, We have a design requirement, for example, Create table test( vin text, create_date int, create_time timestamp, a text, b text, primary key ((vin,create_date),create_time)) with clustering order by (create_time DESC); we store data in this table like thi

答复: nodetool repair and compact

tombstones, they’re only removed through compaction. I advise taking care with nodetool compact, most of the time it’s not a great idea for a variety of reasons. Check out the above post, if you still have questions, ask away. On Apr 1, 2018, at 9:41 PM, Xiangfei Ni mailto:xiangfei..

nodetool repair and compact

Hi All, I want to delete the expired tombstone, someone uses nodetool repair ,but someone uses compact,so I want to know which one is the correct way, I have read the below pages from Datastax,but the page just tells us how to use the command,but doesn’t tell us what it is exactly dose, ht

答复: 答复: 答复: A node down every day in a 6 nodes cluster

down every day in a 6 nodes cluster Was any change to hardware done around the time the problem started ? Was any change to the client software done around the time the problem started? Was any change to the database schema done around the time the problem started? Kenneth Brotman From: X

答复: 答复: 答复: A node down every day in a 6 nodes cluster

, 2018 7:00 PM To: Xiangfei Ni Cc: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: Re: 答复: 答复: A node down every day in a 6 nodes cluster java.langOutOfMemoryError: Java heap space You’re oom’ ing -- Jeff Jirsa On Mar 27, 2018, at 6:45 PM, Xiang

答复: 答复: A node down every day in a 6 nodes cluster

,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: Xiangfei Ni 发送时间: 2018年3月28日 9:45 收件人: Jeff Jirsa 抄送: user@cassandra.apache.org 主题: 答复: 答复: A node down every day in a 6 nodes cluster Hi Jeff, Today another node was shutdown,I have attached the exception log file,could you

答复: 答复: A node down every day in a 6 nodes cluster

: + 86 27 5024 2516 发件人: Jeff Jirsa 发送时间: 2018年3月27日 11:50 收件人: Xiangfei Ni 抄送: user@cassandra.apache.org 主题: Re: 答复: A node down every day in a 6 nodes cluster Only one node having the problem is suspicious. May be that your application is improperly pooling connections, or you have a hardware

Re:RE: 答复: A node down every day in a 6 nodes cluster

Thanks,Kenneth,this is production database,and it is one of three seed nodes,do you have doc for replacing a seed node? 发自我的小米手机 在 Kenneth Brotman ，2018年3月27日 下午7:45写道： David, Can you replace the misbehaving node to see if that resolves the problem? Kenneth Brotman From: Xiangfei Ni

答复: 答复: A node down every day in a 6 nodes cluster

5024 2516 发件人: Jeff Jirsa 发送时间: 2018年3月27日 11:50 收件人: Xiangfei Ni 抄送: user@cassandra.apache.org 主题: Re: 答复: A node down every day in a 6 nodes cluster Only one node having the problem is suspicious. May be that your application is improperly pooling connections, or you have a hardware problem. I

答复: 答复: A node down every day in a 6 nodes cluster

): 0 Dropped Mutations: 0 Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: Jeff Jirsa 发送时间: 2018年3月27日 11:50 收件人: Xiangfei Ni 抄送: user

答复: 答复: A node down every day in a 6 nodes cluster

spear? The Asperger guy. If you get rid of the autism genetics, there would be no Silicon Valley" Temple Grandin Daemeon C.M. Reiydelle San Francisco 1.415.501.0198 London 44 020 8144 9872 On Mon, Mar 26, 2018 at 8:26 PM, Xiangfei Ni mailto:xiangfei...@cm-dt.com>> wrote: Hi Jeff, I ne

A node down every day in a 6 nodes cluster

Hi Cassandra experts, I am facing an issue,a node downs every day in a 6 nodes cluster,the cluster is just in one DC, Every node has 4C 16G,and the heap configuration is MAX_HEAP_SIZE=8192m HEAP_NEWSIZE=512m,every node load about 200G data,the RF for the business CF is 3,a node downs one tim