ava:79)
> at java.lang.Thread.run(Thread.java:745)
>
No hints present /no mutation dropped, but still the above exception is
thrown quite frequently.
Could someone help us out in finding out the root cause.
Thanks in advance
TechPyaasa
/articles/206502913-FAQ-How-to-reduce-the-impact-of-streaming-errors-or-failures
and ran 'nodetool rebuild' one node at a time but was of NO USE . Still we
are getting above exception.
Can someone please help me in debugging and fixing this.
Thanks,
techpyaasa
essageHandler.run(ConnectionHandler.java:245)*
*at java.lang.Thread.run(Thread.java:745)*
Thanks in advance
techpyaasa
On Wed, Sep 28, 2016 at 6:09 PM, Alain RODRIGUEZ wrote:
> Just saw a very similar question from Laxmikanth (laxmikanth...@gmail.com)
> on an other thread, with th
@Paulo
We have done changes as you said
net.ipv4.tcp_keepalive_time=60
net.ipv4.tcp_keepalive_probes=3
net.ipv4.tcp_keepalive_intvl=10
and increased streaming_socket_timeout_in_ms to 48 hours ,
"phi_convict_threshold : 9".
And once again recommissioned new data center (DC3) , ran " nodetool
reb
Very sorry...I got the reason for this issue..
Please ignore.
On Wed, Sep 28, 2016 at 10:14 PM, techpyaasa . wrote:
> @Paulo
>
> We have done changes as you said
> net.ipv4.tcp_keepalive_time=60
> net.ipv4.tcp_keepalive_probes=3
> net.ipv4.tcp_keepalive_intvl=10
Forgot to set replication for new data center :(
On Wed, Sep 28, 2016 at 11:33 PM, Jonathan Haddad wrote:
> What was the reason?
>
> On Wed, Sep 28, 2016 at 9:58 AM techpyaasa . wrote:
>
>> Very sorry...I got the reason for this issue..
>> Please ignore.
>>
>&
space
keyspace_name1"
The count of ranges , it is supposed to be *2304*(256*9) as we have 9
nodes in one data center right but why it is showing as 2647 ranges ??
Can someone please clarify why this difference in token ranges count?
Thanks
techpyaasa
gt;> On Fri, Sep 30, 2016 at 8:08 AM techpyaasa .
>> wrote:
>>
>>> Hi ,
>>>
>>> We have c*-2.0.17 with 3 data centers . Each data center has 9 nodes.
>>> vnodes enabled in all nodes.
>>>
>>> When I ran -local repair(./nodetool -local
*COPY keyspace1.columnFamily1 FROM 'dump_data.csv' WITH TTL = '7200';*
Version is as below
*[cqlsh 4.1.1 | Cassandra 2.0.17 | CQL spec 3.1.1 | Thrift protocol
19.39.0]*
Can some one please tell me how to set TTL using COPY command?
Thanks
Techpyaasa
quot; :( :(
>
> On Wed, Oct 26, 2016 at 8:53 PM, Lahiru Gamathige
> wrote:
>
>> You have to use with default_time_to_live = 7200.
>>
>> On Wed, Oct 26, 2016 at 8:07 AM, techpyaasa .
>> wrote:
>>
>>> Hi all,
>>>
>>> I'm
w would be there any possibility during this mismatch of c*
version among nodes in cluster during this upgrade process?
Thanks
Techpyaasa
Thank you @Alain
On Wed, Nov 16, 2016 at 9:13 PM, Alain RODRIGUEZ wrote:
> Hey Techpyaasa,
>
> Are you aware of this documentation?
>
> https://docs.datastax.com/en/upgrade/doc/upgrade/cassandra/
> upgrdCassandraDetails.html
>
> Basically yes, you can have multiple v
ot;attr6":"3.112"}}');"*
Using UDF/UDA , I want attributes values of json data to be aggregated
something like below
*"select json_aggr(jsonData) from test; //SUM*
*{"node1":{"attr1":"130","attr2":"61","attr3":"611"},"node2":{"attr4":"4.13","attr5":"6.772","attr6":"6.344"}}"*
//130=91+22+17 etc.,
Can we do something like this , can we import java classes from thirdparty
jars for parsing/updating json in UDF defined? And how?
Can somebody please provide outline code for this?
Thanks,
Techpyaasa
nks in advance
Techpyaasa.
e to its real external IP
> address.
>
> Best regards, Vladimir Yudovin,
>
> *Winguzone <https://winguzone.com?from=list> - Hosted Cloud
> CassandraLaunch your cluster in minutes.*
>
>
> On Mon, 21 Nov 2016 05:47:00 -0500*techpyaasa .
> >* wrote
>
to other Cassandra nodes*
*# Leaving this blank will set it to the same value as listen_address*
*# broadcast_address: 1.2.3.4 #It is commented, I have not made any changes
for itrpc_address: 0.0.0.0*
*rpc_port: 9160*
Thanks
TechPyaasa
On Mon, Nov 21, 2016 at 6:48 PM, Vladimir Yudovin
wrote
irewall (if there is one).
> Can you connect to cluster with cqlsh?
>
> Best regards, Vladimir Yudovin,
>
> *Winguzone <https://winguzone.com?from=list> - Hosted Cloud
> CassandraLaunch your cluster in minutes.*
>
>
> On Mon, 21 Nov 2016 08:26:54 -0500*techpy
jar.
In cassandra.yaml following were set
rpc_address: 0.0.0.0 , broadcast_address: 1.2.3.4
This exception thrown for both READ & WRITE queries. Can someone please
help me out in debugging things?
Thanks
Techpyaasa
isted
> (192.168.198.168, 192.168.198.169, 192.168.198.75) that indicates they had
> problems at that time, perhaps GCInspector or StatusLogger messages about
> pauses, or any drops in network utilization to indicate a networking
> problem?
>
>
>
>
>
>
> *From: *"
this cluster.
Can someone please suggest *safest* way to do so.
Thanks in advance,
Techpyaasa
Thanks a lot kurt Greaves
On Fri, Dec 30, 2016 at 5:58 AM, kurt Greaves wrote:
>
> If you're already using the cluster in production and require no downtime
> you should perform a datacenter migration first to change the RF to 3.
> Rough process would be as follows:
>
>1. Change keyspace to
group to which it is added)
OR
Boootstrap/add 2(multiple nodes) at a time?
Please suggest better way to fix this.
Thanks in advance
Techpyaasa
at 11:56 AM, Jonathan Haddad
>> wrote:
>>
>> Are you using the same number of tokens on the new node as the old ones?
>>
>> On Fri, Feb 3, 2017 at 8:31 PM techpyaasa . wrote:
>>
>> Hi,
>>
>> We are using c* 2.0.17 , 2 DCs , RF=3.
>>
>&
TechPyaasa
On Wed, Nov 9, 2016 at 1:28 AM, Dikang Gu wrote:
> Michael, thanks for the info. It sounds to me a very serious performance
> regression. :(
>
> On Tue, Nov 8, 2016 at 11:39 AM, Michael Kjellman <
> mkjell...@internalcircle.com> wrote:
>
>> Yes, We hit th
restrict
inserts at client side by calculating *dataSize* of insert/batch statements
before sending it to c* servers.
We are using datastax java drivers , how can I get dataSize here??
Any ideas??
Thanks in advance
TechPyaasa
Hi Nicolas
I think only DataStax Enterprise(paid) c* version can ask questions/get
support from datastax :(
On Tue, May 23, 2017 at 9:44 PM, techpyaasa . wrote:
> Thanks for your reply..
>
> On Tue, May 23, 2017 at 7:40 PM, Nicolas Guyomar <
> nicolas.guyo...@gmail.com&
reshold, size -
warnThreshold);*
*}*
*}*
Thanks
TechPyaasa
.slideshare.net/planetcassandra/cassandra-summit-2014-lesser-known-features-of-cassandra-21>
>
>
> Cheers,
> Justin
>
> On Thu, 8 Jun 2017 at 18:49 techpyaasa . wrote:
>
>> Hi ,
>>
>> Recently we are seeing huge batches and log prints as below in c* logs
>>
time it would take for this process?
Thanks in advance,
TechPyaasa
ial situation by leveraging composite key, if
> that is possible for you?
>
>
>
>
>
> *From:* techpyaasa . [mailto:techpya...@gmail.com]
> *Sent:* Monday, June 19, 2017 1:01 PM
> *To:* user@cassandra.apache.org
> *Subject:* Secondary Index
>
>
>
> Hi,
>
&g
Hi,
What is the best practice to add(bootstrap) multiple nodes at once to c*
cluster.
Using c*-2.1.17 , 2 DCs , 3 groups in each DC
Thanks
TechPyaasa
ly get a hit cause index rebuilding is expensive operation on CPU
> ..
>
>
>
> See please http://docs.datastax.com/en/cql/3.1/cql/ddl/ddl_when_use_
> index_c.html
>
>
>
>
>
>
>
> *From:* techpyaasa . [mailto:techpya...@gmail.com]
> *Sent:* Tuesday, June 20, 201
k1=123 and cc1=345;*
and
*select * from ks.cf <http://ks.cf> where pk1=123 and status=1;*
In this case , I want rows to be sorted based on 'disp_name' (asc/desc) .
Can I achieve the same using UDF or anything else ?? (Sorry If my
understanding about UDF is wrong).
Thanks in advance
TechPyaasa
cumentation.rst#performance-tips
>
> On Tue, 4 Jul 2017 at 07:17 DuyHai Doan wrote:
>
>> Plain answer is no you can't
>>
>> The reason is that UDF only transform column values on each row but does
>> not have the ability to modify rows ordering
>>
>>
tions.
And also is there any way to make sure that last UPDATE was success??
We are using c* - 2.1.17 , datastax java driver 2.1.18.
Can someone point out what the issue is or anybody faced such strange issue?
Any help is appreciated.
Thanks in advance
TechPyaasa
are you using on those queries?
>
> On 11 Jul 2017 19:09, "techpyaasa ." wrote:
>
>> Hi,
>>
>> We have a table with following schema:
>>
>> CREATE TABLE ks1.cf1 ( pid bigint, cid bigint, resp_json text, status
>> int, PRIMARY KEY (pid, ci
ase let me know how can I achieve the same in
cassandra(c*-2.1.17). I'm ok with applying indexes etc,
Thanks
TechPyaasa
d=1 order by dispName asc;*
> You can use *in condition* on last partition key *status *in table
>
> *test.user_index.*
>
>
>
> *It depends on your use case and amount of data as well. It can be
> optimized more...*
> Thanks!!
>
> On Sun, Jul 23, 2017 at 2:48 AM, tech
(pid ASC);
>
I mean get all rows within same partition(account_id) whose
status=0(say some value) using *UDF/UDA* in c* ?
>
> select group_by_status from test.user;
where group_by_status is UDA/UDF
Thanks in advance
TechPyaasa
On Sun, Jul 23, 2017 at 10:42 PM, Vladimir Yudovin
wro
te;';
CREATE or REPLACE AGGREGATE groupbystatus (int)
> SFUNC countstatus STYPE map
> INITCOND{};
select groupbystatus(status) from test.cs where pid=1;
> test.groupbystatus(status)
>
>{0: 2, 1: 3, 2: 1, 5: 1}
In the same way I want to achieve Map> .
How can I do the same ?
Using c*-2.2.8
Thanks in advance
TechPyaasa
d to clarify is there any limit/drawback having huge
cluster/too many nodes in a c* cluster
Thanks in advance
TechPyaasa
ache.org/>
>
> Best regards, Vladimir Yudovin,
> *Winguzone <https://winguzone.com?from=list> - Cloud Cassandra Hosting*
>
>
> On Mon, 21 Aug 2017 08:35:37 -0400 *techpyaasa .
> >* wrote
>
> Hi
>
> Is there any limit on having number of nodes in c*
ing to manage 2 clusters
you should be able to apply it to manage 20 (reality always gets in the way
though…)
Jon
On Aug 21, 2017, at 9:15 AM, techpyaasa . wrote:
Thanks lot for reply :)
On Aug 21, 2017 6:44 PM, "Vladimir Yudovin" wrote:
Actually there are clusters of thou
Thanks
Techpyaasa
44 matches
Mail list logo
