unsubscribe

2025-04-12 Thread A via user
unsubscribe Sent from Yahoo Mail for iPhone

Re: [RELEASE] Apache Cassandra 4.1.8 released

2025-02-03 Thread A via user
UNSUBSCRIBE Sent from Yahoo Mail for iPhone On Monday, February 3, 2025, 6:00 PM, Štefan Miklošovič wrote: The Cassandra team is pleased to announce the release of Apache Cassandra version 4.1.8. Apache Cassandra is a fully distributed database. It is the right choice when you need

UNSUBSCRIBE

2025-01-14 Thread A via user
UNSUBSCRIBE Sent from Yahoo Mail for iPhone On Monday, January 13, 2025, 10:43 PM, Bret McGuire wrote: The Cassandra team is pleased to announce the release of Cassandra Java Driver version 3.12.0.  This is the first release of the 3.x Java driver since its donation to the Apache Software

Re: Hints not being sent from 3.0/3.11 to 4.0?

2022-09-14 Thread Morten A. Iversen via user
Hi, I have finally had time to test this a bit. And the issue seems to be there with Cassandra 3.11.13 as well as 3.0.27. Hinted handoff from these versions to version 4.0.6 does not seem to work. The way I tested this was by setting up a 2 node cluster, 1 node in each of dc1 and dc2. Install

Hints not being sent from 3.0 to 4.0?

2022-08-23 Thread Morten A. Iversen via user
Hi, We are currently in the process of upgrading our environment from 3.0.27 to 4.0.4. However I see some issues with hints not being sent from v3 nodes to v4 nodes. We have a test environment with 2DCs, we are currently writing to DC1 and DC2 have been upgraded from version 3.0.27 -> 4.

sstable processing times

2020-10-23 Thread James A. Robinson
Hi folks, I'm running a job on an offline node to test how long it takes to run sstablesplit several large sstable. I'm a bit dismayed to see it took about 22 hours to process a 1.5 gigabyte sstable! I worry about the 32 gigabyte sstable that is my ultimate target to split. This is

cassandra tracing's source_elapsed microseconds

2020-10-08 Thread James A. Robinson
Hi folks, I've been looking at various articles on the TRACING ON output of cassandra. I'm not finding a definitive description of what the output means. https://docs.datastax.com/en/dse/6.7/cql/cql/cql_reference/cqlsh_commands/cqlshTracing.html says "Note: The source_elapsed

Re: Running Large Clusters in Production

2020-07-13 Thread Isaac Reath (BLOOMBERG/ 919 3RD A)
Thanks for the info Jeff, all very helpful! From: user@cassandra.apache.org At: 07/11/20 12:30:36To: user@cassandra.apache.org Subject: Re: Running Large Clusters in Production Gossip related stuff eventually becomes the issue For example, when a new host joins the cluster (or replaces a

Re: Running Large Clusters in Production

2020-07-11 Thread Isaac Reath (BLOOMBERG/ 919 3RD A)
Thank you John and Jeff, I was leaning towards sharding and this really helps support that opinion. Would you mind explaining a bit more what about vnodes caused those issues? From: user@cassandra.apache.org At: 07/10/20 19:06:27To: user@cassandra.apache.org Cc: Isaac Reath (BLOOMBERG/ 919

Running Large Clusters in Production

2020-07-10 Thread Isaac Reath (BLOOMBERG/ 919 3RD A)
Hi All, I’m currently dealing with a use case that is running on around 200 nodes, due to growth of their product as well as onboarding additional data sources, we are looking at having to expand that to around 700 nodes, and potentially beyond to 1000+. To that end I have a couple of

Re: Minimum System Requirements

2020-03-28 Thread A
Thank you. Sent from Yahoo Mail for iPhone On Friday, March 27, 2020, 9:02 PM, Erick Ramirez wrote: It really depends on your definition of "stable" but you can run C* on as little as a single-core machine with 4-6GB of RAM. It will be stable enough to do 1 or 2 queries per

Minimum System Requirements

2020-03-27 Thread A
What are the minimum system requirements for running a stable install of Cassandra? Sent from Yahoo Mail for iPhone

Re: sstableloader - warning vs. failure?

2020-02-07 Thread James A. Robinson
en SSTables are being cached and the cache fills > up faster than objects are evicted from it. Note that the message is logged > at INFO level (instead of WARN or ERROR) because there is no detrimental > effect but there will be a performance hit in the form of read latency. > When spac

sstableloader - warning vs. failure?

2020-02-07 Thread James A. Robinson
Hi folks, When sstableloader hits a very large sstable cassandra may end up logging a message like this: INFO [pool-1-thread-4] 2020-02-08 01:35:37,946 NoSpamLogger.java:91 - Maximum memory usage reached (536870912), cannot allocate chunk of 1048576 The loading process doesn't abort, an

Cassandra and UTF-8 BOM?

2019-10-29 Thread James A. Robinson
Hi folks, I'm looking at a table that has a primary key defined as "publisher_id text". I've noticed some of the entries have what appears to me to be a UTF-8 BOM marker and some do not. https://docs.datastax.com/en/archived/cql/3.3/cql/cql_reference/cql_data_types_c.html

n00b q re UPDATE v. INSERT in CQL

2019-10-25 Thread James A. Robinson
Hi folks, I'm working on a clean-up task for some bad data in a cassandra db. The bad data in this case are values with mixed case that will need to be lowercased. In some tables the value that needs to be changed is a primary key, in other cases it is not. >From the reading I'

Re: Ram & Space...

2019-10-23 Thread A
Thank you. But I have added any tables yet. It’s empty... Sent from Yahoo Mail for iPhone On Tuesday, October 22, 2019, 1:15 AM, Matthias Pfau wrote: Did you check nodetool status and logs? If so, what is reported? Regarding that more and more memory is used. This might be a problem with

Ram & Space...

2019-10-19 Thread A
What are minimum and recommended ram and space requirements to run Cassandra in AWS? Every like 24 hours Cassandra stops working. Even though the service is active, it’s dead and non responsive until I restart the service. Top shows %MEM slowly creeping upwards. Yesterday it showed 75%.  In the l

snapshots and 'dot' prefixed _index directories

2019-10-01 Thread James A. Robinson
Hi folks, I took a nodetool snapshot of a keyspace in my cassandra 3.11 cluster and it included directories with a 'dot' prefix (often called a hidden file/directory). As an example: /var/lib/cassandra/data/impactvizor/tableau_notification-04bfb600291e11e7aeab31f0f0e5804b/snapshots/

Re: Update/where statement Adds Row

2019-09-13 Thread A
Thank you. Sent from Yahoo Mail for iPhone On Thursday, September 12, 2019, 1:09 AM, Hossein Ghiyasi Mehr wrote: Update in Cassandra is upsert (update or insert). So when you update a row which isn't exist, it will create it."IF EXIST" can be used in some queries. On Thu, Se

Re: Update/where statement Adds Row

2019-09-11 Thread A
#yiv9726893009 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv9726893009 div.yiv9726893009WordSection1 {}#yiv9726893009 Use if exists clause.   UPDATE table SET column ='something' WHERE key = ‘value’ IF EXISTS;           From: A Sent: Wednesday, September 11, 2019 11:05 P

Re: Update/where statement Adds Row

2019-09-11 Thread A
;} _filtered #yiv9726893009 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv9726893009 div.yiv9726893009WordSection1 {}#yiv9726893009 Use if exists clause.   UPDATE table SET column ='something' WHERE key = ‘value’ IF EXISTS;           From: A Sent: Wednesday, September 11, 2019 1

Update/where statement Adds Row

2019-09-11 Thread A
I have an update statement that has a where clause with the primary key (email,companyid). When executed it always creates a new row. It’s like it’s not finding the existing row with the primary key. I’m using Cassandra-driver. What am I doing wrong? I don’t want a new row. Why doesn’t it seem

RE: Datafile Corruption

2019-08-08 Thread ZAIDI, ASAD A
Did you check if packets are NOT being dropped for network interfaces Cassandra instances are consuming (ifconfig –a) internode compression is set for all endpoint – may be network is playing any role here? is this corruption limited so certain keyspace/table | DCs or is that wide spread – the

RE: Repair failed and crash the node, how to bring it back?

2019-08-01 Thread ZAIDI, ASAD A
I don’t think anyone can predict with certainty if instance won’t crash but there are good chances it will - unless you take remedial actions. If you are not doing subrange repair, a lot of merkle tree data can potentially be scanned/streamed taking toll on memory resources – that , taking

RE: Repair / compaction for 6 nodes, 2 DC cluster

2019-07-31 Thread ZAIDI, ASAD A
Hello, Good day. This is Martin. Can someone help me with the following query regarding Cassandra repair and compaction? Currently we have a large keyspace (keyspace_event) with 1TB of data (in /var/lib/cassandra/data/keyspace_event); There is a cluster with Datacenter 1 contains 3 nodes, Data

RE: Jmx metrics shows node down

2019-07-29 Thread ZAIDI, ASAD A
9, 2019 10:56 AM To: user@cassandra.apache.org Subject: Re: Jmx metrics shows node down Is there workaround to shorten 72 hours to something shorter?(you said by default, wondering if one can set a non-default value?) Thanks, Yuping On Jul 29, 2019, at 7:28 AM, Oleksandr Shulgin mailto:olek

RE: Performance impact with ALLOW FILTERING clause.

2019-07-25 Thread ZAIDI, ASAD A
Thank you all for your insights. When spark-connector adds allows filtering to a query, it makes the query to just ‘run’ no matter if it is expensive for larger table OR not so expensive for table with fewer rows. In my particular case, nodes are reaching 2TB/per node load in 50 node cluster

Performance impact with ALLOW FILTERING clause.

2019-07-25 Thread ZAIDI, ASAD A
we see unpredictability in application performance – just as documentation says. I’m trying to understand why would a connector add a clause in query when this can cause negative impact on database/application performance. Is that data model that is driving connector make its decision and add

RE: Rebooting one Cassandra node caused all the application nodes go down

2019-07-19 Thread ZAIDI, ASAD A
grafana. Zaidi, In latest aws Linux Ami they took care of this bug . And also changing the Ami needs rebuild of all the nodes so didn't took that route. On Fri, Jul 19, 2019, 12:32 PM ZAIDI, ASAD A mailto:az1...@att.com>> wrote: “aws asked to set nvme_timeout to higher number in et

RE: Rebooting one Cassandra node caused all the application nodes go down

2019-07-19 Thread ZAIDI, ASAD A
and comit logs are stored in gp2 ebs. C5 instance type had a bug which aws asked to set nvme_timeout to higher number in etc/grub.conf. after setting the parameter and did run nodetool drain and reboot the node in east Instance cameup but Cassandra didn't come up normal had to start the Cass

Difficulties after nodetool removenode

2019-06-29 Thread Morten A. Iversen
Hi, We had a hardware issue with one node in a Cassandra cluster and had to use the "nodetool removenode UUID" command from a different node. This seems to be running fine, but one node was restarted after the "nodetool removenode" command was run, and now it seems all str

node re-start delays , busy Deleting mc-txn-compaction/ Adding log file replica

2019-06-18 Thread ZAIDI, ASAD A
I’m on environment with apache Cassandra 3.11.1 with java 1.8.0_144. One Node went OOM and crashed. Re-starting this crashed node is taking long time. Trace level debug log is showing messages like: Debug.log trace excerpt: TRACE [main] 2019-06-18 21:30:43,449 LogTr

RE: postmortem on 2.2.13 scale out difficulties

2019-06-12 Thread ZAIDI, ASAD A
Adding one node at a time – is that successful? Check value of streaming_socket_timeout_in_ms parameter in cassandra.yaml and increase if needed. Have you tried Nodetool bootstrap resume & jvm option i.e. JVM_OPTS="$JVM_OPTS -Dcassandra.consistent.rangemovement=false" ? From

Unsubscribe

2019-05-21 Thread A
Sent from Yahoo Mail for iPhone

RE: Bootstrapping to Replace a Dead Node vs. Adding a New Node:Consistency Guarantees

2019-05-01 Thread ZAIDI, ASAD A
The article you mentioned here clearly says “For new users to Cassandra, the safest way to add multiple nodes into a cluster is to add them one at a time. Stay tuned as I will be following up with another post on bootstrapping.” When extending cluster it is indeed recommended to go slow

RE: cassandra node was put down with oom error

2019-05-01 Thread ZAIDI, ASAD A
case, all the nodes of the cluster have the same problem. Thanks. On 2019/05/01 06:13:06, Ayub M wrote: > Do you have search on the same nodes or is it only cassandra. In my > case it was due to a memory leak bug in dse search that consumed more > memory resulting in oom. > >

RE: Decommissioning a new node when the state is JOINING

2019-04-30 Thread ZAIDI, ASAD A
30, 2019 6:35 AM To: user@cassandra.apache.org Subject: Decommissioning a new node when the state is JOINING Hi Experts, I have a cassandra cluster running with 5 nodes. For some reason, I was creating a new cassandra cluster, but one of the nodes intended for new cluster had the same

UNSUBSCRIBE

2019-01-13 Thread A
Sent from Yahoo Mail for iPhone

Amy Tobey's tuning guide for Cassandra 3 ?

2018-09-04 Thread Jeronimo de A. Barros
Hi guys, Does anyone know about a CAS3 tuning guide like the excellent Amy's Cassandra 2.1 tuning guide <https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html> ? It would be much appreciated. Regards, Jero

Re: Java 10 for Cassandra 3.11.3

2018-09-03 Thread Jeronimo de A. Barros
Andrew, Thank you, it's a valuable information. Regards, Jero On Mon, Sep 3, 2018 at 12:04 PM Andy Tolbert wrote: > Hi Jeronimo, > > Until Cassandra 4.0, JDK 8 is required. See CASSANDRA-9608 > <https://jira.apache.org/jira/browse/CASSANDRA-9608> for more details. &g

Java 10 for Cassandra 3.11.3

2018-09-03 Thread Jeronimo de A. Barros
Hi guys, I'd like to know which java version to use with Cassandra 3.11.3. Is Java 10 already supported ? Is it safe ? Thanks.

RE: SSTable Compression Ratio -1.0

2018-08-28 Thread ZAIDI, ASAD A
Compression ratio is ratio of compression to its original size - smaller is better; see it like compressed/uncompressed 1 would mean no change in size after compression! -Original Message- From: Vitaliy Semochkin [mailto:vitaliy...@gmail.com] Sent: Tuesday, August 28, 2018 12:03 PM To

RE: Upgrade from 2.1 to 3.11

2018-08-28 Thread ZAIDI, ASAD A
ga mailto:mundeg...@gmail.com>> wrote: 120G data 28G heap out of 48 on system 9 node cluster, RF3 On Thu, Aug 23, 2018, 17:19 Mohamadreza Rostami mailto:mohamadrezarosta...@gmail.com>> wrote: Hi, How much data do you have? How much RAM do your servers have? How much do you have a heep? On Thu,

Cassandra 3.11 with NFS mounted system

2018-08-28 Thread ZAIDI, ASAD A
Hello Folks, I've an virtualized environment running with VMware where Cassandra is humming on NFS mounted storage. As the application load increases ,they increase number of nodes in data center however writes are getting slower, nodes are flapping and application complains in write performan

RE: Maximum SSTable size

2018-06-27 Thread ZAIDI, ASAD A
lto:lu...@maurobenevides.com.br] Sent: Wednesday, June 27, 2018 7:02 AM To: user@cassandra.apache.org Subject: Maximum SSTable size Hello Community, Is there a maximum SSTable Size? If there is not, does it go up to the maximum Operational System values? Thanks in advance, Lucas Benevides

RE: Problem with dropped mutations

2018-06-26 Thread ZAIDI, ASAD A
Are you also seeing time-outs on certain Cassandra operations?? If yes, you may have to tweak *request_timeout parameter in order to get rid of dropped mutation messages if application data model is not upto mark! You can also check if network isn't dropping packets (ifconfig -a

Error creating pool to / Pool was closed during initialization

2018-06-25 Thread ZAIDI, ASAD A
Hello Folks, I’m looking for possible reasons and solution for these frequently appearing warning messages I’m seeing in spark <>cassandra job’s log file. The message suggest Cassandra host server machine is acting up and throwing messages like: 18/06/25 14:07:44 WARN Session: Error creating po

Re: Text or....

2018-04-04 Thread Jeronimo de A. Barros
Hi, We use a pseudo file-system table where the chunks are blobs of 64 KB and we never had any performance issue. Primary-key structure is ((file-uuid), chunck-id). Jero On Wed, Apr 4, 2018 at 9:25 AM, shalom sagges wrote: > Hi All, > > A certain application is writing ~55,000 chara

Re: Measuring eventual consistency latency

2018-03-26 Thread Jeronimo de A. Barros
Jeff and Christophe, Thank you very much ! I'll take a look. Jero On Sun, Mar 25, 2018 at 10:21 PM, Jeff Jirsa wrote: > Probably closer to https://issues.apache.org/jira/browse/CASSANDRA-13289 > > > Will be in 4.0 > -- > Jeff Jirsa > > > On Mar 25, 2018

Measuring eventual consistency latency

2018-03-25 Thread Jeronimo de A. Barros
I'd like to know if there is a reasonable method to measure how long take to have the data available across all replica nodes in a multi DC environment using LOCAL_ONE or LOCAL_QUORUM consistency levels. If already there be a study about this topic in some place and someone could point m

unsubscribe

2018-03-23 Thread Nate Bruce (BLOOMBERG/ 919 3RD A)

Re: Data Deleted After a few days of being off

2018-02-27 Thread A
No. I inserted using USING TTL 86400;  On Monday, February 26, 2018, 11:45:07 PM PST, Oleksandr Shulgin wrote: On Tue, Feb 27, 2018 at 7:37 AM, A wrote: I started going through the logs and haven't noticed anything yet... Very unexpected behavior. Maybe I'm asking the ob

RE: Jon Haddad on Diagnosing Performance Problems in Production

2018-02-27 Thread ZAIDI, ASAD A
Problems in Production Nicolas, I think you had the link to the other version I was thinking of. I couldn’t find it. I think it might have gotten taken down; a lot of other stuff seems to be gone too. Maybe it will be back. Maybe they are just redoing stuff. Either way, it’s another sign of Mom

RE: Cassandra Daemon not coming up

2018-02-27 Thread ZAIDI, ASAD A
Can you check if you’ve enough disk space available ? ~Asad From: mahesh rajamani [mailto:rajamani.mah...@gmail.com] Sent: Tuesday, February 27, 2018 10:11 AM To: user@cassandra.apache.org Subject: Cassandra Daemon not coming up I am using Cassandra 3.0.9 version on a 12 node cluster. I have

Re: Data Deleted After a few days of being off

2018-02-26 Thread A
as well as through node.js.  I started going through the logs and haven't noticed anything yet... Very unexpected behavior. Thanks.A Sent from Yahoo Mail for iPad On Monday, February 26, 2018, 9:23 PM, @Nandan@ wrote: Hi A,As I am able to  understand your question :-1) You inserted s

Data Deleted After a few days of being off

2018-02-26 Thread A
I'm new to Cassandra.  Trying it out to see if it will work for my upcoming project.  I created a test keyspace and table on my dev laptop.  Loaded it with some data on a Friday and closed her down.  Returned on Monday and looked up the data and it was gone.  The keyspace and table was

RE: Old tombstones not being cleaned up

2018-02-01 Thread ZAIDI, ASAD A
M To: user@cassandra.apache.org Subject: Re: Old tombstones not being cleaned up I, almost, tried that today :) I ran a repair, changed the compaction algorithm from leveled to sizetierd and back. This definitely forced a compaction, but the tombstones are still there. Will setting

RE: Converting from Apache Cassandra 2.2.6 to 3.x

2018-02-01 Thread ZAIDI, ASAD A
You may want to upgrade python and java/JDK version with Cassandra upgrade. please refer to CHANGES.txt for all updates & improvement made in your selected 3.x version. From: William Boutin [mailto:william.bou...@ericsson.com] Sent: Thursday, February 01, 2018 4:49 PM To: user@cassandra.apache

RE: Old tombstones not being cleaned up

2018-02-01 Thread ZAIDI, ASAD A
, 2018 at 11:35 PM Bo Finnerup Madsen mailto:bo.gunder...@gmail.com>> wrote: Hi, We are running a small 9 node Cassandra v2.1.17 cluster. The cluster generally runs fine, but we have one table that are causing OOMs because an enormous amount of tombstones. Looking at the data in the

RE: [announce] Release of Cassandra Prometheus metrics exporter

2018-01-31 Thread ZAIDI, ASAD A
omain Gerard [mailto:romain.ger...@erebe.eu] Sent: Wednesday, January 10, 2018 9:06 AM To: user@cassandra.apache.org Subject: [announce] Release of Cassandra Prometheus metrics exporter Hello C*, A little mail to announce that we released today our internal tool at Criteo to monitor Cassandra nodes

RE: Connection refused - 127.0.0.1-Gossip

2017-12-06 Thread ZAIDI, ASAD A
2:19 AM To: user@cassandra.apache.org Subject: Re: Connection refused - 127.0.0.1-Gossip Thanks for any ideas/hints, any straw is worth checking at this point ☺ Well, the clusters “work”, data is correctly stored and queries. I’m interested in why it tries to open a gossip to localhost, and what

Re: Running Cassandra on FreeBSD

2017-11-20 Thread Jeronimo de A. Barros
Jens, Al Tobey's Cassandra 2.1 tuning guide has excellents infos about running Cassandra. Apparently he uses Arch Linux and we've been using Slackware Linux in a 12 node cluster (2 DCs 6/6) for the last 3 years with no problems. https://tobert.github.io/pages/als-cassandra-21-tuning-

table repair question

2017-10-04 Thread ZAIDI, ASAD A
Hello folk, I'm wondering if there is way to find out list of table(s) which need repair OR if there Is way to find out what %age of data would need to be repaired on a table? Is such information available from Cassandra db engine through some other means? TIA~ Asad

Re: cassandra hardware requirements (STAT/SSD)

2017-10-03 Thread Jeronimo de A. Barros
Hello, It's a bit old but at least for me, still a great guide: https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html My 2 cents: We deal with electronic invoices and our load is about 10,000 transactions/s during the peak housr. We are not located in USA, so AWS would be

detail of compactionstats, pending tasks

2017-09-21 Thread ZAIDI, ASAD A
corporate station_data 108 MB 267.68 MB bytes 40.35% Active compaction remaining time :n/a == [cassandra@server]$ nodetool tpstats Pool NameActive Pending Completed Blocked All time blocked MutationStage

RE: Re[6]: Modify keyspace replication strategy and rebalance the nodes

2017-09-19 Thread Myron A. Semack
satisfied)? Sincerely, Myron A. Semack From: Jeff Jirsa [mailto:jji...@gmail.com] Sent: Monday, September 18, 2017 6:02 PM To: cassandra Subject: Re: Re[6]: Modify keyspace replication strategy and rebalance the nodes Using CL:ALL basically forces you to always include the first replica in the

RE: Re[6]: Modify keyspace replication strategy and rebalance the nodes

2017-09-18 Thread Myron A. Semack
How would setting the consistency to ALL help? Wouldn’t that just cause EVERY read/write to fail after the ALTER until the repair is complete? Sincerely, Myron A. Semack From: Jeff Jirsa [mailto:jji...@gmail.com] Sent: Monday, September 18, 2017 2:42 PM To: user@cassandra.apache.org Subject

RE: Attempted to write commit log entry for unrecognized table

2017-08-16 Thread Myron A. Semack
Restarting the Cassandra service resolved this issue. Thanks for your advice! Sincerely, Myron A. Semack From: kurt greaves [mailto:k...@instaclustr.com] Sent: Tuesday, August 15, 2017 6:10 PM To: User Subject: Re: Attempted to write commit log entry for unrecognized table what does nodetool

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-15 Thread Harikrishnan A
n cqlsh 5.0.1). Best I can offer is https://docs.datastax.com/en/ cql/3.3/cql/cql_reference/ cqlshExpand.html > On 14 Aug 2017, at 16:17, Jim Witschey wrote: > > Not knowing the problem you're trying to solve, I'm going to guess > cqlsh is a bad tool for this job. If you wan

Attempted to write commit log entry for unrecognized table

2017-08-15 Thread Myron A. Semack
We have a Cassandra 2.2.10 cluster of 9 nodes, hosted in AWS. One of the nodes had a problem where it ran out of space on its root volume (NOT the Cassandra volume which holds the Cassandra data and commit logs). I resolved the issue with free space on the root volume and restarted the node

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-14 Thread Harikrishnan A
I have column values with Pipe separator, hence unable to replace this default delimiter from the output. Thanks Hari On Monday, August 14, 2017 12:12 AM, algermissen1971 wrote: On 14.08.2017, at 07:49, Harikrishnan A wrote: Hello, When I execute cqlsh -e "SELECT stat

cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-13 Thread Harikrishnan A
Hello, When I execute cqlsh -e "SELECT statement .."  , it gives the output with a pipe ('|') separator. Is there anyway I can change this default delimiter in the output of cqlsh -e " SELECT statement ..".  Thanks & Regards,Hari

MemtablePostFlush pending

2017-08-11 Thread ZAIDI, ASAD A
Hello Folks, I’m using Cassandra 2.2 on 14 node cluster. Now a days, I’m observing memtablepostflush pending number going high , this happens intermittently. I’m looking if Is there way to ‘tune’ memtablepostflush stage? Thanks/ASad

RE: rebuild constantly fails, 3.11

2017-08-08 Thread ZAIDI, ASAD A
causing the failure and network is supposedly stable. ~Asad -Original Message- From: Micha [mailto:mich...@fantasymail.de] Sent: Tuesday, August 08, 2017 8:35 AM To: user@cassandra.apache.org; ZAIDI, ASAD A ; user@cassandra.apache.org Subject: Re: rebuild constantly fails, 3.11 no, I have

RE: rebuild constantly fails, 3.11

2017-08-08 Thread ZAIDI, ASAD A
build constantly fails, 3.11 Hi, it seems I'm not able to add add 3 node dc to a 3 node dc. After starting the rebuild on a new node, nodetool netstats show it will receive 1200 files from node-1 and 5000 from node-2. The stream from node-1 completes but the stream from node-2 allways fails, after

Cassandra upgrade from 2.2.8 to 3.10

2017-08-07 Thread ZAIDI, ASAD A
Hi folks, I’ve question on upgrade method I’m thinking to execute. I’m planning from apache-Cassandra 2.2.8 to release 3.10. My Cassandra cluster is configured like one rack with two Datacenters like: 1. DC1 has 4 nodes 2. DC2 has 16 nodes We’re adding another 12 nodes and would

RE: Different data size between datacenters

2017-08-07 Thread ZAIDI, ASAD A
Are you using same number of token/vnodes in both data centers? From: Chuck Reynolds [mailto:creyno...@ancestry.com] Sent: Monday, August 07, 2017 1:51 PM To: user@cassandra.apache.org Subject: Different data size between datacenters I have a cluster that spans two datacenters running Cassandra

RE: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-08-03 Thread ZAIDI, ASAD A
rted every 5000ms. If you are looking to tweak the number of ms after which a message is considered dropped then you need to use the write_request_timeout_in_ms. The write_request_timeout_in_ms (http://docs.datastax.com/en/cassandra/2.1/cassandra/configuration/configCassandra_yaml_r.html<https://u

RE: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-21 Thread ZAIDI, ASAD A
Hi Akhil, Thank you for your reply. Previously, I did ‘tune’ various timeouts – basically increased them a bit but none of those parameter listed in the link matches with that “were dropped in last 5000 ms”. I was wondering from where that [5000ms] number is coming from when, like I mentioned

RE: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-21 Thread ZAIDI, ASAD A
cross node timeout In a cloud environment, cross_node_timeout = true can cause issues; we had this issue in our environment and it is set to false now. Dropped messages is an another issue Subroto On Jul 20, 2017, at 8:27 AM, ZAIDI, ASAD A mailto:az1...@att.com>> wrote: Hello Folks – I’m

RE: MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-21 Thread ZAIDI, ASAD A
optimal. Thank you again. From: Anuj Wadehra [mailto:anujw_2...@yahoo.co.in] Sent: Thursday, July 20, 2017 12:17 PM To: ZAIDI, ASAD A ; user@cassandra.apache.org Subject: Re: MUTATION messages were dropped in last 5000 ms for cross node timeout Hi Asad, You can do following things: 1

MUTATION messages were dropped in last 5000 ms for cross node timeout

2017-07-20 Thread ZAIDI, ASAD A
Hello Folks - I'm using apache-cassandra 2.2.8. I see many messages like below in my system.log file. In Cassandra.yaml file [ cross_node_timeout: true] is set and NTP server is also running correcting clock drift on 16node cluster. I do not see pending or blocked HintedHandoff in tpstats out

reduced num_token = improved performance ??

2017-07-11 Thread ZAIDI, ASAD A
Hi Folks, Pardon me if I’m missing something obvious. I’m still using apache-cassandra 2.2 and planning for upgrade to 3.x. I came across this jira [https://issues.apache.org/jira/browse/CASSANDRA-7032] that suggests reducing num_token may improve general performance of Cassandra like having

RE: READ Queries timing out.

2017-07-07 Thread ZAIDI, ASAD A
>> I analysed the GC logs not having any issues with major GC's If you don’t have issues on GC , than why do you want to [tune] GC parameters ? Instead focus on why select queries are taking time.. may be take a look on their trace? From: Pranay akula [mailto:pr

RE: Understanding of cassandra metrics

2017-07-07 Thread ZAIDI, ASAD A
What exactly does mean CoordinatorScanLatency for example CoordinatorScanLatency is a timer metric that present coordinator range scan latency for table. Is it latency on full table scan or maybe range scan by clustering key? It is range scan.. clustering key is used to only

RE: Node failure Due To Very high GC pause time

2017-07-03 Thread ZAIDI, ASAD A
your tables with [tombstones], A quick [grep –i tombstone /path/to/system.log] command would tell you what objects are suffering with tombstones! From: Karthick V [mailto:karthick...@zohocorp.com] Sent: Monday, July 03, 2017 11:47 AM To: user Subject: Re: Node failure Due To Very high GC pa

Cassandra Cluster Expansion Criteria

2017-06-29 Thread ZAIDI, ASAD A
Hello Folks, I’m on Cassandra 2.2.8 cluster with 14 nodes , each with around 2TB of data volume. I’m looking for a criteria /or data points that can help me decide when or if I should add more nodes to the cluster and by how many nodes. I’ll really appreciate if you guys can share your

RE: COUNT

2017-06-21 Thread ZAIDI, ASAD A
BIGINT, "body" TEXT, PRIMARY KEY ("groupId","createTime","mailId") )WITH CLUSTERING ORDER BY ("createTime" DESC); This table is frequency updated (250K per second) and each between 10-1000 new record is inserted in each &

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

2017-06-20 Thread ZAIDI, ASAD A
adding multiple nodes at once tax system more and caused me issues on existing nodes. I prefer to add one node at a time … From: techpyaasa . [mailto:techpya...@gmail.com] Sent: Tuesday, June 20, 2017 9:32 AM To: user@cassandra.apache.org Subject: Best practice to add(bootstrap) multiple nodes

RE: Secondary Index

2017-06-20 Thread ZAIDI, ASAD A
repair data your secondary index will NOT be automatically repaired so you’ll need to maintain them On each cluster node. Depending on size of your cluster that could be a significant effort. Be prepared to rebuild your new index (nodetool rebuild_index) as often as you change the data

RE: Adding nodes and cleanup

2017-06-19 Thread ZAIDI, ASAD A
! From: Mark Furlong [mailto:mfurl...@ancestry.com] Sent: Monday, June 19, 2017 2:28 PM To: user@cassandra.apache.org Subject: Adding nodes and cleanup I have added a few nodes and now am running some cleanups. Can I add an additional node while these cleanups are running? What are the ramifications

RE: Partition range incremental repairs

2017-06-19 Thread ZAIDI, ASAD A
pair --in-local-dc --partitioner-range” and "nodetool repair --in-local-dc” Since 2.2 I believe inc repairs are the default - that seems to be confirmed in the logs that list the repair details when a repair starts. 2) From looks at a few runsr, on average: with -pr repairs, each node is appr

RE: Secondary Index

2017-06-19 Thread ZAIDI, ASAD A
If you’re only creating index so that your query work, think again! You’ll be storing secondary index on each node , queries involving index could create issues (slowness!!) down the road the when index on multiple node Is involved and not maintained! Tables involving a lot of inserts/delete

RE: Question: Large partition warning

2017-06-14 Thread ZAIDI, ASAD A
ttps://stackoverflow.com/questions/20512710/cassandra-has-a-limit-of-2-billion-cells-per-partition-but-whats-a-partition] From: Thakrar, Jayesh [mailto:jthak...@conversantmedia.com] Sent: Wednesday, June 14, 2017 3:14 PM To: User Subject: Question: Large partition warning We are on Cassandra 2.2.5 a

Apache Cassandra - Memory usage on server

2017-06-14 Thread ZAIDI, ASAD A
Hi folks, I’m using apache Cassandra 2.2. Instance is configured with max_heap_size set at 16G, memtable_allocation_type is offheap_objects – total available memory is 62G on the server. There is nothing but Cassandra is running on my Linux server. My Cassandra instance is consuming all availa

RE: Data in multi disks is not evenly distributed

2017-06-08 Thread ZAIDI, ASAD A
Check status of load with nodetool status command. Make sure your there isn’t huge number of pending compactions for your tables. Ideally speaking data distribution should be even across your nodes. you should have reserved extra 15% of free space relative to your maximum size of your table i.e

RE: Local_serial >> Adding nodes

2017-06-08 Thread ZAIDI, ASAD A
cation dirvers are configuared to use LOCAL_SERIAL. As we are adding multiple nodes at a time we used option "-Dcassandra.consistent.rangemovement=false" we added all nodes with gap of 10 mins each We are facing lot of timeouts more 30k transactions over 8 hours of period . i

RE: Convert single node C* to cluster (rebalancing problem)

2017-06-08 Thread ZAIDI, ASAD A
problem) not evenly, i have setup a new cluster with subset of data (around 5gb). using the configuration above I am getting these results Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns

MemtablePostFlush pending

2017-06-01 Thread ZAIDI, ASAD A
Hello Folks, I'm adding another node on my 14 node open source apache cassandra 2.2.8 cluster. New node is taking long time to join the cluster. I see there are bunch of pending [memtablepostflush] threads. I did increase memtable_flush_writers from 8 to 24 , though it is not helping with situa

  1   2   3   4   >