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
主题:
: 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 ==
rg"<user@cassandra.apache.org>
Date : Mon, 28 May 2018 11:04:06 +0430
Subject : 答复: Re: cassandra update vs insert + delete
Forwarded message
Yes, you are correct.
Best Regards,
倪项菲/ David Ni
中移德电网络科技有限公司
Virtue Intelligent Network Ltd, co.
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
Thanks very much,Hannu,I got your point.
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
发件人: Hannu Kröger
发送时间: 2018年5月3日 15:16
收件人: user@cassandra.apache.or
Thanks Hannu,
Another question is that,do I need to stop the frontend application during the
upgrade?
I have 3 nodes cluster,let’s say:
Cassandra01
Cassandra02
Cassandra03
First I upgrade the cassandra01 node,
1,nodetool drain
2,backup data
3,install new binary
4,configure the configuration file
: Re: 答复: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing
Hi,
I believe there is no such official apache documentation, and since Datastax
removed the old guide to redirect to the apache one, you are left with Google
to look for guidance.
As a general advice (from what I can recall
科技有限公司
>
> 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
>
>
>
> *发件人:* Nicolas Guyomar
> *发送时间:* 2018年4月20日 15:44
> *收件人:* user@cassandra.apache.org
> *主题:*
Luojia creative city,Luoyu Road,Wuhan,HuBei
Mob: +86 13797007811|Tel: + 86 27 5024 2516
发件人: Nicolas Guyomar
发送时间: 2018年4月20日 15:44
收件人: user@cassandra.apache.org
主题: Re: 答复: Cassandra 3.7 - Problem with Repairs - all nodes failing
Hi,
You can have a look to https://github.com/apache/cassandra
Hi,
You can have a look to
https://github.com/apache/cassandra/blob/trunk/NEWS.txt which list every
modification / advice for upgrading between each C* version
On 20 April 2018 at 09:25, Xiangfei Ni wrote:
> By the way,is there official documentation for online upgrade cassandra
> from 3.9 to
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
Jon,
Great article. Thank you. (I have nothing to do with this issue, but I
appreciate nuggets of information I glean from the list)
Regards,
Eric
On Tue, Apr 17, 2018 at 10:57 PM Jonathan Haddad wrote:
> To add to what Nate suggested, we have an entire blog post on scaling time
> series data
To add to what Nate suggested, we have an entire blog post on scaling time
series data models:
http://thelastpickle.com/blog/2017/08/02/time-series-data-modeling-massive-scale.html
Jon
On Tue, Apr 17, 2018 at 7:39 PM Nate McCall wrote:
> I disagree. Create date as a raw integer is an excellen
: user@cassandra.apache.org
主题: Re: 答复: Time serial column family design
Hi David,
Could you describe why you chose to include the create date in the partition
key? If the vin in enough "partitioning", meaning that the size (number of rows
x size of row) of each partition is less than 1
I disagree. Create date as a raw integer is an excellent surrogate for
controlling time series "buckets" as it gives you complete control over the
granularity. You can even have multiple granularities in the same table -
remember that partition key "misses" in Cassandra are pretty lightweight as
th
Hi David,
Could you describe why you chose to include the create date in the
partition key? If the vin in enough "partitioning", meaning that the size
(number of rows x size of row) of each partition is less than 100MB, then
remove the date and just use the create_time, because the date is already
Your table design will work fine as you have appropriately bucketed by an
integer-based 'create_date' field.
Your goal for this refactor should be to remove the "IN" clause from your
code. This will move the rollup of multiple partition keys being retrieved
into the client instead of relying on th
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
发件人:
Hi James and Jon,
Thank you very much for your advice, I will go through the article.
By the way,is there any official documentation for instructing the detail of
nodetool command,the web pages in datastax are just brief instruction.
Best Regards,
倪项菲/ David Ni
中移德电网络科技有限公司
Virtue Intelligent N
@cassandra.apache.org
Subject: RE: 答复: 答复: A node down every day in a 6 nodes cluster
If you think that will fix the problem, maybe you could add a little more
memory to each machine as a short term fix.
From: Xiangfei Ni [mailto:xiangfei...@cm-dt.com]
Sent: Wednesday, March 28, 2018 5:24 AM
To: user
If you think that will fix the problem, maybe you could add a little more
memory to each machine as a short term fix.
From: Xiangfei Ni [mailto:xiangfei...@cm-dt.com]
Sent: Wednesday, March 28, 2018 5:24 AM
To: user@cassandra.apache.org
Subject: 答复: 答复: 答复: A node down every day in a 6 nodes
Brotman
发送时间: 2018年3月28日 20:16
收件人: user@cassandra.apache.org
主题: RE: 答复: 答复: A node down every day in a 6 nodes cluster
David,
Did you figure out what to do about the data model problem? It could be that
your data files finally grow to the point that the data model problem caused
the Java heap
model.
Kenneth Brotman
From: Kenneth Brotman [mailto:kenbrot...@yahoo.com]
Sent: Wednesday, March 28, 2018 4:46 AM
To: 'user@cassandra.apache.org'
Subject: RE: 答复: 答复: A node down every day in a 6 nodes cluster
Was any change to hardware done around the time the problem star
-dt.com]
Sent: Wednesday, March 28, 2018 4:40 AM
To: user@cassandra.apache.org
Subject: 答复: 答复: 答复: A node down every day in a 6 nodes cluster
Hi Kenneth,
The cluster has been running for 4 months,
The problem occurred from last week,
Best Regards,
倪项菲/ David Ni
中移德电网络科技有限公司
: Kenneth Brotman
发送时间: 2018年3月28日 19:34
收件人: user@cassandra.apache.org
主题: RE: 答复: 答复: A node down every day in a 6 nodes cluster
David,
How long has the cluster been operating?
How long has the problem been occurring?
Kenneth Brotman
From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, March 27
David,
How long has the cluster been operating?
How long has the problem been occurring?
Kenneth Brotman
From: Jeff Jirsa [mailto:jji...@gmail.com]
Sent: Tuesday, March 27, 2018 7:00 PM
To: Xiangfei Ni
Cc: user@cassandra.apache.org
Subject: Re: 答复: 答复: A node down every day in a 6
st 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
,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
: + 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
m/en/cassandra/3.0/cassandra/operations/opsReplaceLiveNode.html
>
> Kenneth Brotman
>
>
> From: Xiangfei Ni [mailto:xiangfei...@cm-dt.com]
> Sent: Tuesday, March 27, 2018 5:44 AM
> To: user@cassandra.apache.org
> Subject: Re:RE: 答复: A node down every day in a 6 nodes clu
/operations/opsReplaceLiveNode.html
Kenneth Brotman
From: Xiangfei Ni [mailto:xiangfei...@cm-dt.com]
Sent: Tuesday, March 27, 2018 5:44 AM
To: user@cassandra.apache.org
Subject: Re:RE: 答复: A node down every day in a 6 nodes cluster
Thanks,Kenneth,this is production database,and it is
[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 cluster
Thanks Jeff,
So your suggestion is to first resolve the data model issue which
cause wide partition,right?
Best Regards
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
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
@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 dont see anything in nodetool that explains it, though you certainly have a
data
27 5024 2516
发件人: daemeon reiydelle
发送时间: 2018年3月27日 11:42
收件人: user
主题: Re: 答复: A node down every day in a 6 nodes cluster
Look for errors on your network interface. I think you have periodic errors in
your network connectivity
<==>
"Who do you think made the first stone
Only one node having the problem is suspicious. May be that your
application is improperly pooling connections, or you have a hardware
problem.
I dont see anything in nodetool that explains it, though you certainly have
a data model likely to cause problems over time (the cardinality of
rt_ac_sta
Look for errors on your network interface. I think you have periodic errors
in your network connectivity
<==>
"Who do you think made the first stone spear? The Asperger guy.
If you get rid of the autism genetics, there would be no Silicon Valley"
Temple Grandin
*Daemeon C.M. ReiydelleSan Fr
>* wrote
>>>
>>> The solution maybe work. However, the play list will grow over time and
>>> somebody maybe has ten thousands that will slow down the query and sort .
>>> Do you mean the oldest one should be removed when a new play is added?
>>>
>>> BTW, the ve
that will slow down the query and sort .
>> Do you mean the oldest one should be removed when a new play is added?
>>
>> BTW, the version is 2.1.16 in our live system.
>>
>>
>> BRs,
>>
>> BEN
>> --
>>
>>
gt;
>>> On Wed, 09 Nov 2016 20:47:05 -0500*Diamond ben
>>> >* wrote
>>>
>>> The solution maybe work. However, the play list will grow over time and
>>> somebody maybe has ten thousands that will slow down the query and sort .
>>> Do you
list will grow over time and
>>> somebody maybe has ten thousands that will slow down the query and sort .
>>> Do you mean the oldest one should be removed when a new play is added?
>>>
>>> BTW, the version is 2.1.16 in our live system.
>>>
>>>
>
removed when a new play is added?
>>
>> BTW, the version is 2.1.16 in our live system.
>>
>>
>> BRs,
>>
>> BEN
>> --
>>
>> *发件人:* Vladimir Yudovin
>> *发送时间:* 2016年11月9日 18:11:26
>> *收件人:* user
ten thousands that will slow down the query and sort .
> Do you mean the oldest one should be removed when a new play is added?
>
> BTW, the version is 2.1.16 in our live system.
>
>
> BRs,
>
> BEN
> --
>
> *发件人:* Vladimir Yudovin
>
is added?
BTW, the version is 2.1.16 in our live system.
BRs,
BEN
发件人: Vladimir Yudovin <vla...@winguzone.com>
发送时间: 2016年11月9日 18:11:26
收件人: user
主题: Re: 答复: A difficult data model with C*
You are welcome! )
>recent ten movies watched by the user within 30 days.
In this ca
发件人: Vladimir Yudovin
发送时间: 2016年11月9日 18:11:26
收件人: user
主题: Re: 答复: A difficult data model with C*
You are welcome! )
>recent ten movies watched by the user within 30 days.
In this case you can't use PRIMARY KEY (user_name, video_id), as video_id is
demanded to fetch row
You are welcome! )
>recent ten movies watched by the user within 30 days.
In this case you can't use PRIMARY KEY (user_name, video_id), as video_id is
demanded to fetch row, so all this stuff may be
CREATE TYPE play (video_id text, position int, last_time timestamp);
CREATE TABLE recent (use
Hi Vladimir Yudovin,
Thank you very much for your detailed explaining. Maybe I didn't describe
the requirement clearly. The use cases should be:
1. a user login our app.
2. show the recent ten movies watched by the user within 30 days.
3. the user can click any one of the ten movie and co
Hello,
Reading more codes. I can reproduce the exception. Over long
slice parameter can cause the exception.
Code :
char[] chs = new char[7]; //over 64k
Arrays.fill(chs,'b');
String end = String.valueOf(chs);
Composite c2 = nameType.make(new Object[] {2, end ,11});
Colu
Using java/C# rewrite the test case, the results are consistency.
Is there any problem for the python driver?
发件人: 鄢来琼
发送时间: Friday, July 31, 2015 9:03 AM
收件人: 'user@cassandra.apache.org'
主题: query statement return empty
Hi ALL
The result of “select * from t_test where id = 1” statement is not c
Hi ,
There is a “possible memory leak “ issue with c* 2.1.2.
https://issues.apache.org/jira/browse/CASSANDRA-8248
It happen with our c* 2.1.2 cluster . In /proc/{pid}/maps there are a lot of
deleted file maps .
_
Stephen li
发件人: Joe Ramsey [mailto:joe.ram...@m
Better yet, if you're using a client where you can pass the time in, you
can validate it is indeed clock skew. Do all your writes with timestamp =
0, all your deletes with timestamp = 1.
On Wed, Dec 24, 2014 at 7:47 AM, Ryan Svihla wrote:
> Every time I've heard this but one this has been clock
Why don't you use incremental repairs? Is there a known issue with
incremental repairs in 2.1.x?
On Tue, Dec 30, 2014 at 10:22 PM, 李建奇 wrote:
> We also suffer some problem from 2.1.2 . But I think we can deal with .
>
> First I don’t use incremental repair.
>
> Second we restart node after repa
We also suffer some problem from 2.1.2 . But I think we can deal with .
First I don’t use incremental repair.
Second we restart node after repair . It will release sstable tmplink .
Third , don’t use stop COMPACTION command.
If we read 2.1.2 release notes ,we find it solve some issues wit
Every time I've heard this but one this has been clock skew (and that was
swallowed exceptions), however it can just be you have a test that is prone
to race conditions (delete followed by an immediate select with a low
consistency level), without more detail it's hard to say.
I'd check the nodes
Yeah, I also have the question.
My solution is not delete the row, but insert the right row to a new table.
Thanks & Regards,
Peter YAN
发件人: Sávio S. Teles de Oliveira [mailto:savio.te...@cuia.com.br]
发送时间: 2014年8月26日 4:25
收件人: user@cassandra.apache.org
主题:
We're using cassandra 2.0.9 with data
It does appear to be a ulimit issue to some degree as some settings are
lower than recommended by a few factors (namely nproc).
http://www.datastax.com/documentation/cassandra/2.0/cassandra/install/installRecommendSettings.html
* - memlock unlimited
* - nofile 10
* - nproc 32768
* - as unlimi
What's your vm.max_map_count setting?
Best Regards,
Liang
发件人: Leon Oosterwijk
发送时间: 2014年12月19日 11:55
收件人: user@cassandra.apache.org
主题: Cassandra 2.1.0 Crashes the JVM with OOM with heaps of memory free
All,
We have a Cassandra cluster which seems to be s
Hi,
It looks like you are running into a known issue:
https://issues.apache.org/jira/browse/CASSANDRA-7780 and its being worked
on here: https://issues.apache.org/jira/browse/CASSANDRA-7145
Mark
On 20 August 2014 09:06, 鄢来琼 wrote:
> Is it related to MAX_HEAP_SIZE and HEAP_NEWSIZE?
>
> My sy
Is it related to MAX_HEAP_SIZE and HEAP_NEWSIZE?
My system memory size is 4G,but the MAX_HEAP_SIZE and HEAP_NEWSIZE are set to
2G and 800M, respectively.
Thanks and regards,
GTA Data
Peter.YAN
E-Mail：laiqiong@gtafe.com
http://www.gtafe.com/
[说明: cid:image001.
On 12/02/2013 03:43 PM, Kumar Ranjan wrote:
> Hey Folks,
>
> I have been using ccm for some time and it's pretty awesome tool to test
> out admin stuff. Now, I really want to test modeling data by trying to
> access ccm running cassandra using Thrift based pycassaShell client from
> remote hosts (
Hey why dont you try Datastax Opscenter? Its a cool Gui tool to
start/stop/manage your cluster(even remotely) . It also provides
administrative tools fr checking on the performance with vital statistics.
Definitely worth it.
On Dec 3, 2013 3:14 AM, "Kumar Ranjan" wrote:
> Hey Folks,
>
> I have b
Hey Folks,
I have been using ccm for some time and it's pretty awesome tool to test
out admin stuff. Now, I really want to test modeling data by trying to
access ccm running cassandra using Thrift based pycassaShell client from
remote hosts (not locally). My setup is like this:
Lets say, private
Thanks, But I suppose it’s just for Debian? Am I right?
Any others?
Best Regards,
Boole Guo
Software Engineer, NESC-SH.MIS
+86-021-51530666*41442
Floor 19, KaiKai Plaza, 888, Wanhangdu Rd, Shanghai (200042)
发件人: Mike Adamson [mailto:mikeat...@gmail.com]
发送时间: 2013年11月21日 17:16
收件人: user@cassandra
Thanks very much. I will try.
The goal of ccm and ccmlib is to make is easy to create, manage and destroy a
small cluster on a local box. It is meant for testing of a Cassandra cluster.
Best Regards,
Boole Guo
Software Engineer, NESC-SH.MIS
+86-021-51530666*41442
Floor 19, KaiKai Plaza, 888, Wanha
Thanks. Bellow is my log4j-server.properties.
log4j.rootLogger=info,stdout
# stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p %d{HH:mm
Your ParNew size is way too small. Generally 4GB ParNew (-Xmn) works out
best for 16GB heap
On Mon, Sep 23, 2013 at 9:05 PM, 谢良 wrote:
> it looks to me that "MaxTenuringThreshold" is too small, do you have any
> chance to try with a bigger one, like 4 or 8 or sth else?
>
> __
it looks to me that "MaxTenuringThreshold" is too small, do you have any chance
to try with a bigger one, like 4 or 8 or sth else?
发件人: André Cruz [andre.c...@co.sapo.pt]
发送时间: 2013年9月23日 22:51
收件人: user@cassandra.apache.org
主题: Frequent Full GC that take
You have to log in and then you can create topic only below some sections
(opscenter, feedbacks, ...) if I remember well.
Alain
2013/8/1 yue.zhang
> thanks Alain
>
> ** **
>
> I don’t know why not permited to create topic on datastax forum*.*
>
> ** **
>
> ** **
>
> *发件人:* Alain RODRIGUEZ
thanks Alain
I don’t know why not permited to create topic on datastax forum.
发件人: Alain RODRIGUEZ [mailto:arodr...@gmail.com]
发送时间: 2013年7月31日 18:11
收件人: user@cassandra.apache.org
主题: Re: two problems about opscenter 3.2
Here is the pointer to the topic on the DS support forum.
http://www.dat
This means there were 12 times the code wanted to put an memtable in the queue
to be flushed to disk but the queue was full.
---
seem not a serious problem. what's the different between 'Blocked' and 'All
time blocked'.
thx
-heipark
-邮件原件-
发件人: aaron morton [mailto:aa...@thelastp
71 matches
Mail list logo
