Hi Jeff,
This is very strange that the table info that the max partition is
129557750(123M):
[cid:image001.png@01D3C5E0.0A9F8910]
But why the index max partition is nearly 2G,
Table (index):
rt_ac_stat.idx_rt_ac_stat_prot_verrt_ac_stat.idx_rt_ac_stat_prot_ver
SSTable
Thanks Jeff,
So your suggestion is to first resolve the data model issue which
cause wide partition,right?
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 502
David,
Can you replace the misbehaving node to see if that resolves the problem?
Kenneth Brotman
From: Xiangfei Ni [mailto:xiangfei...@cm-dt.com]
Sent: Tuesday, March 27, 2018 3:27 AM
To: Jeff Jirsa
Cc: user@cassandra.apache.org
Subject: 答复: 答复: A node down every day in a 6 nodes clust
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 [mailto:
First, anything Jeff Jirsa says is likely very accurate, like it being a really
good idea to also get off the version you’re on and onto a version that fixes
some of the known problems of the version you’re one.
Replacing a running node:
https://docs.datastax.com/en/cassandra/3.0/cassandra/o
Hi,
I am trying to replace machines having HDD with little powerful machines
having SSD in production. The data present in each node is around 300gb.
But the newer machines have 2 X 200GB SSDs instead of a single disk.
"data_file_directories" looks like a multi-valued config which I can use.
Am I
Yes you can have multiple entries from multiple disks. No guarantee as I can
see of even distribution. If you want even distribution there are better
mechanisms for this at the filesystem later.
--
Rahul Singh
rahul.si...@anant.us
Anant Corporation
On Mar 27, 2018, 8:05 AM -0700, Venkata Hari
It may be that the wife partition is bombarded more than other partitions.
What’s your RF on that keyspace? If if it’s greater than 1 I’d expect other
nodes to get the same type of load.
--
Rahul Singh
rahul.si...@anant.us
Anant Corporation
On Mar 27, 2018, 5:56 AM -0700, Kenneth Brotman ,
wr
In Cassandra 3.2 and later, data is partitioned by token range, which
should give you even distribution of data.
If you're going to go into 3.x, please use the latest 3.11, which at this
time is 3.11.2.
On Tue, Mar 27, 2018 at 8:05 AM Venkata Hari Krishna Nukala <
n.v.harikrishna.apa...@gmail.com
Hi There -
I have noticed an issue where I consistently see high p999 read latency on
a node for a few hours after replacing the node. Before replacing the node,
the p999 read latency is ~30ms, but after it increases to 1-5s. I am
running C* 3.11.2 in EC2.
I am testing out using EBS snapshots of
Hi Mike,
Unlike normal EBS volumes for which you don't need to pre-warm, I think
you need to pre-Warm your EBS volume restored from a snapshot
Have a look at this AWS doc
https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html
It says that:
However, storage blocks on volumes that
Have you ruled out EBS snapshot initialization issues (
https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html)?
On Tue, Mar 27, 2018 at 2:24 PM, Mike Torra wrote:
> Hi There -
>
> I have noticed an issue where I consistently see high p999 read latency on
> a node for a few hour
thanks for pointing that out, i just found it too :) i overlooked this
On Tue, Mar 27, 2018 at 3:44 PM, Voytek Jarnot
wrote:
> Have you ruled out EBS snapshot initialization issues (
> https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html)?
>
> On Tue, Mar 27, 2018 at 2:24 PM,
Hi All,
I may be over the edge here, but is there a way to execute an external
program if a new row is added or if an existing row is updated on a table?
Cheers,
Earl
--
There are seven words in this sentence.
Hi All ,
I’ve installed Apache Cassandra( Tarball install )..
But there is no way to see the Cassandra status / stop option .
Anyone has the Apache Cassandra start / stop script for Cassandra 3.12
Can some one help on this ?
Thanks,
Anumod
Mob-718-844-3841
PA,USA
Sent from my iPhone
---
Hi Earl,
You probably want to check Cassandra triggers:
http://cassandra.apache.org/doc/latest/cql/triggers.html
You can write arbitrary code that is called for the DML against your table.
Cheers,
Christophe
On 28 March 2018 at 10:58, Earl Lapus wrote:
> Hi All,
>
> I may be over the edge he
Hi Anumod,
When you install Cassandra using the tarball install, you will not get a
service file installed. It becomes your responsability to write one (or to
take one from the internet).
When you install Cassandra using a package (.deb, .rpm..), the installer
should also install the service files
CDC may also work for newer versions, but it’ll happen after the mutation is
applied
--
Jeff Jirsa
> On Mar 27, 2018, at 5:31 PM, Christophe Schmitz
> wrote:
>
> Hi Earl,
>
> You probably want to check Cassandra triggers:
> http://cassandra.apache.org/doc/latest/cql/triggers.html
> You ca
Hi Anumod
Echoing what Christophe said, you should also mention what OS you are
using, so that we would be able to help you get to the solution.
Cheers,
Alex.
On Wed, 28 Mar 2018 at 11:05 Christophe Schmitz
wrote:
> Hi Anumod,
>
> When you install Cassandra using the tarball install, you will
Hi Jeff,
Today another node was shutdown,I have attached the exception log
file,could you please help to analyze?Thanks.
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
Another thins is that I have removed the index which has the wide partition
rt_ac_stat.idx_rt_ac_stat_prot_verrt_ac_stat.idx_rt_ac_stat_prot_ver as you
pointed out.
Best Regards,
倪项菲/ David Ni
中移德电网络科技有限公司
Virtue Intelligent Network Ltd, co.
Add: 2003,20F No.35 Luojia creative city,Luoyu Road,W
java.lang.OutOfMemoryError: Java heap space
You’re oom’ ing
--
Jeff Jirsa
> On Mar 27, 2018, at 6:45 PM, Xiangfei Ni wrote:
>
> Hi Jeff,
> Today another node was shutdown,I have attached the exception log
> file,could you please help to analyze?Thanks.
>
> Best Regards,
>
> 倪项菲/
Dear All,
For adding a new DC ,we need to set auto_bootstrap: false and then run the
rebuild,finally we need to change auto_bootstrap: true,but for seed nodes,it
seems that we still need to keep bootstrap false?
Could anyone please confirm?
Thanks,
Peng Xiao
You might want to follow DataStax docs on this one:
For adding a DC to an existing cluster:
https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/operations/opsAddDCToCluster.html
For adding a new node to an existing cluster:
https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_e
We followed this
https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_cluster_t.html,
but it does not mention that change bootstrap for seed nodes after the rebuild.
Thanks,
Peng Xiao
-- Original --
From: "Ali Hubail";
Date: Wed, Ma
25 matches
Mail list logo
