Re: [EXTERNAL] Cassandra copy command is giving OverflowError

That did not work. It was giving me the same error. However I came to know that it can happen if there is out of range date values. Now I ran the following query and got result: select id,created_date from table1 where solr_query = > '{"q":"*:*","sort":"created_date desc"}' limit 2; Traceback (

RE: [EXTERNAL] Cassandra copy command is giving OverflowError

Try this. COPY keyspace1.table1 TO '/tmp/table1.csv' WITH PAGETIMEOUT=40 AND PAGESIZE=20; Thanks Kishore Mohapatra Principal Operations DBA Seattle, WA Email : kishore.mohapa...@nuance.com From: AI Rumman [mailto:rumman...@gmail.com] Sent: Thursday, Septemb

Re: Commitlog without header

I will try the fixes, thanks Benjamin & Jeff. On Thu, Sep 21, 2017 at 8:55 PM, Jeff Jirsa wrote: > https://issues.apache.org/jira/plugins/servlet/mobile# > issue/CASSANDRA-11995 > > > > -- > Jeff Jirsa > > > On Sep 19, 2017, at 4:36 PM, Dikang Gu wrote: > > Hello, > > In our production cluster,

Re: Pending-range-calculator during bootstrapping

This has been reported by other users with very large clusters and vnodes. https://issues.apache.org/jira/browse/CASSANDRA-9258 Both this thread and 9258 call this a regression, but don’t mention which version you’re upgrading from (or which of your two versions below see the high CPU). This

Interrogation about expected performance

Hello, we recently added a new 5 node cluster used only for a single service, and right now it's not even read from, we're just loading data into it. Each node are identical: 32Gib of RAM, 4 core Xeon E5-1630, 2 SSDs in Raid 0, Cassandra v3.11 We have two tables with roughly this schema: CREATE T

RE: Massive deletes -> major compaction?

Additional to Kurt’s reply. Double disk usage is really the worst case. Most of the time you are fine having > largest column family free disk available. Also take local snapshots into account. Even after a finished major compaction, disk space may have not been reclaimed, if snapshot sym links

RE: Pending-range-calculator during bootstrapping

I don't know a specific issue with these versions, but in general you do not want to do ANY streaming operations (bootstrap or repair) between Cassandra versions. I would get all the nodes (in all DCs) to the same version and then try the bootstrap. Sean Durity From: Peng Xiao [mailto:2535...

RE: Massive deletes -> major compaction?

yes, yes, yes. A compaction on a single sstable will only get rid of tombstones if there is no live data that tombstone shadows in any other sstable. to actually remove data with a tombstone the compaction needs to include other sstables that contain data the tombstone covers, and the tombstone wi

RE: Pending-range-calculator during bootstrapping

I don't know a specific issue with these versions, but in general you do not want to do ANY streaming operations (bootstrap or repair) between Cassandra versions. I would get all the nodes (in all DCs) to the same version and then try the bootstrap. Sean Durity From: Peng Xiao [mailto:2535...

RE: Massive deletes -> major compaction?

Thanks for the pointer. I had never heard of this. While it seems that it could help, I think our rules for determining which records to keep are not supported. Also, this requires adding a new jar to production. Too risky at this point. Sean Durity From: Jon Haddad [mailto:jonathan.had...@gm

Re: add new nodes in two DCs at the same time

Theoretically yes, but you should stick to 1 node at a time to keep things simple. only add multiple nodes simultaneously if you really know what you're doing and have good reason to. Also by default Cassandra will stop you from adding multiple nodes at once unless you pass certain flags.

Re: Understanding Messages in the Debug.log

I see a lot of that on one of our clusters. There is pretty much no load on it. Clocks are quite well synchronized. date +start:%H:%M:%S.%N ; for d in 2 3 4 5 6 8 9; do ssh 10.3.0.17$d date +%H:%M:%S.%N & done;date +end:%H:%M:%S.%N start:01:22:45.478726356 end:01:22:45.480993049 01:22:45.570313

add new nodes in two DCs at the same time

Hi, as Datastax suggests,we should only bootstrap one new node one time. but can we add new nodes in two DCs at the same time? Thanks, Peng Xiao

Pending-range-calculator during bootstrapping

Dear All, when we are bootstrapping a new node,we are experiencing high cpu load which affect the rt ,and we noticed that it's mainly costing on Pending-range-calculator ,this did not happen before. We are using C* 2.1.13 in one DC,2.1.18 in another DC. Could anyone please advise on this? Than