Re: Adding Options to Create Statements...

On Fri, Apr 1, 2016 at 10:43 AM, James Carman wrote: > A, my bad. One might wonder why the heck the Java driver is "owned" > by an outside entity, eh? > FWIW, the status quo prior to the Datastax drivers was a wide assortment of non-compatible drivers in

Re: Consistency Level (QUORUM vs LOCAL_QUORUM)

On Thu, Mar 31, 2016 at 4:35 AM, Alain RODRIGUEZ wrote: > My understanding is using RF 3 and LOCAL_QUORUM for both reads and writes > will provide a strong consistency and a high availability. One node can go > down and also without lowering the consistency. Or RF = 5, Quorum

Re: Speeding up "nodetool rebuild"

On Wed, Mar 30, 2016 at 1:44 PM, Anubhav Kale wrote: > Will changing compactionthroughput and streamingthroughput help with > reducing the “rebuild” time on a brand new node ? We will do it both on the > new node, and the nodes in source DC from where data is

Re: How is the coordinator node in LOCAL_QUORUM chosen?

On Fri, Mar 25, 2016 at 1:04 PM, X. F. Li wrote: > Suppose I have replication factor 3. If one of the node fails, will > queries with ALL consistency fail if the queried partition is on the failed > node? Or would they continue to work with 2 replicas during the time while >

Re: Counter values become under-counted when running repair.

On Thu, Mar 24, 2016 at 7:17 AM, Jack Krupansky wrote: > Can you advise us on your thinking when you selected RF=2? > I figure he was probably thinking "I want to operate in a bunch of different regions and don't need to use QUORUM for my use cases, and want to save

Re: Rack aware question.

59284402364209. > > > > So, few questions because things don’t add up: > > > >1. How come 127.0.0.1 is shown as an endpoint holding the ID when its >token range doesn’t contain it ? Does “nodetool ring” shows all > token-ranges for a node or just the primary

Re: Large number of tombstones without delete or update

On Wed, Mar 23, 2016 at 9:50 AM, Ralf Steppacher wrote: > How come I end up with that large a number of tombstones? > Are you inserting NULLs? =Rob

Re: Read consistency

On Tue, Mar 15, 2016 at 6:43 PM, Arko Provo Mukherjee < arkoprovomukher...@gmail.com> wrote: > I am designing a system where for a situation, I need to have SERIAL > consistency during writes. > Be sure to understand the implications of : https://issues.apache.org/jira/browse/CASSANDRA-9328

Re: Deploy latest cassandra on top of datastax-ddc ?

On Fri, Mar 18, 2016 at 5:00 PM, Mohamed Lrhazi < mohamed.lrh...@georgetown.edu> wrote: > FYI.. for the curious.. what I did resulted in a cluster where i tested > these two things: > ... > I have no inclination to keep using such a setup.. just reporting the > experiment :) > FWIW, given the

Re: Deploy latest cassandra on top of datastax-ddc ?

On Fri, Mar 18, 2016 at 2:18 PM, Mohamed Lrhazi < mohamed.lrh...@georgetown.edu> wrote: > So, after doing an ant build from the latest source... how would one > "install" or deploy cassandra? Could not find a document on the install > from source part... any pointers? All I find makes use of

Re: Cassandra Upgrade 3.0.x vs 3.x (Tick-Tock Release)

On Mon, Mar 14, 2016 at 12:40 PM, Kathiresan S wrote: > We are planning for Cassandra upgrade in our production environment. > Which version of Cassandra is stable and is advised to upgrade to, at the > moment? >

Re: Regarding cassandra-stress results

On Mon, Mar 14, 2016 at 11:38 AM, Rajath Subramanyam wrote: > When cassandra-stress tool dumps the output at the end of the benchmarking > run, what is the unit of latency statistics ? > This is becoming a FAQ. Perhaps the docs for the tool (and/or the tool itself) should be

Re: JMX liveSSTableCount

On Fri, Mar 11, 2016 at 10:04 AM, Hazel Bobins wrote: > Does anyone know if the removal of the liveSSTableCount JMX attribute > from the 'org.apache.cassandra.db:type=Tables,keyspaces=' mbean was > intentional in 3.x? I can not see reference to its removal in any Jira etc >

Re: ntpd clock sync

On Wed, Mar 9, 2016 at 9:03 AM, K F wrote: > the clock is about 30 to 40 seconds behind. > If you don't want to get ntp working there, why not just... manually... set the clocks? =Rob

Re: How can I make Cassandra stable in a 2GB RAM node environment ?

On Thu, Mar 10, 2016 at 3:27 AM, Alain RODRIGUEZ wrote: > So, like Jack, I globally really not recommend it unless you know what you > are doing and don't care about facing those issues. > Certainly a spectrum of views here, but everyone (including OP) seems to agree with

Re: How can I make Cassandra stable in a 2GB RAM node environment ?

On Fri, Mar 4, 2016 at 8:27 PM, Jack Krupansky wrote: > Please review the minimum hardware requirements as clearly documented: > > http://docs.datastax.com/en/cassandra/3.x/cassandra/planning/planPlanningHardware.html > That is a document for Datastax Cassandra, not

Re: Unexplainably large reported partition sizes

On Sat, Mar 5, 2016 at 9:16 AM, Tom van den Berge wrote: > I don't think compression can be the cause of the difference, because of > two reasons: > Your two reasons seem legitimate. Though you say you do not frequently do DELETE and so it shouldn't be due to tombstones,

Re: moving keyspaces to another disk while Cassandra is running

On Mon, Mar 7, 2016 at 2:57 AM, Krzysztof Księżyk wrote: > I see on lsof output that even if keyspace > is not queried, Cassandra keeps files opened, so I guess it's not safe to > hotswap, but I'd like to make sure. > It is not safe for exactly this reason. Just restart your

Re: Unexplainably large reported partition sizes

On Fri, Mar 4, 2016 at 5:56 AM, Tom van den Berge wrote: > Compacting large partition > drillster/subscriberstats:rqtPewK-1chi0JSO595u-Q (1,470,058,292 bytes) > > This means that this single partition is about 1.4GB large. This is much > larger that it can possibly be,

Re: Broken links in Apache Cassandra home page

On Wed, Mar 2, 2016 at 7:00 AM, Eric Evans wrote: > On Tue, Mar 1, 2016 at 8:30 PM, ANG ANG wrote: > > "#cassandra channel": http://freenode.net/ > > The latter, while not presently useful, links to a "coming soon..." > for Freenode. It might be

Re: Snitch for AWS EC2 nondefaultVPC

On Wed, Mar 2, 2016 at 7:21 AM, Arun Sandu wrote: > > All the nodes in both datacenters are in DSE Search Mode(Solr). We may > have analytics datacenter as well in future. Will this have any impact in > using Ec2MultiRegionSnitch? > This list does not support DSE, but as

Re: Removing Node causes bunch of HostUnavailableException

On Wed, Mar 2, 2016 at 8:10 AM, Peddi, Praveen wrote: > We have few dead nodes in the cluster (Amazon ASG removed those thinking > there is an issue with health). Now we are trying to remove those dead > nodes from the cluster so that other nodes can take over. As soon as I >

Re: Snitch for AWS EC2 nondefaultVPC

On Tue, Mar 1, 2016 at 12:12 PM, Arun Sandu wrote: > All our nodes are launched in AWS EC2 VPC (private). We have 2 > datacenters(1 us-east , 1- asiapacific) and all communication is through > private IP's and don't have any public IPs. What is the recommended snitch > to

Re: List of List

On Tue, Mar 1, 2016 at 3:23 PM, Jonathan Haddad wrote: > Thrift is deprecated, and will be removed in Cassandra 4.0 Don't do any > new development with it. > +infinity this. =Rob

Re: Handling uncommitted paxos state

On Thu, Feb 25, 2016 at 1:23 AM, Nicholas Wilson < nicholas.wil...@realvnc.com> wrote: > If a WriteTimeoutException with WriteType.SIMPLE is thrown for a CAS > write, that means that the paxos phase was successful, but the data > couldn't be committed during the final 'commit/reset' phase. On the

Re: copy and rename sstable files as keyspace migration approach

On Tue, Feb 23, 2016 at 6:44 AM, Jarod Guertin wrote: > Being fairly new to Cassandra, I'd like to run the following with the > experts to make sure it's an ok thing to do. > > We have a particular case where we have multiple keyspaces with multiple > tables each and

Re: Cassandra nodes reduce disks per node

On Tue, Feb 16, 2016 at 11:29 PM, Anishek Agarwal wrote: > > To accomplish this can I just copy the data from disk1 to disk2 with in > the relevant cassandra home location folders, change the cassanda.yaml > configuration and restart the node. before starting i will shutdown

Re: Sudden disk usage

On Sat, Feb 13, 2016 at 4:30 PM, Branton Davis wrote: > We use SizeTieredCompaction. The nodes were about 67% full and we were > planning on adding new nodes (doubling the cluster to 6) soon. > Be sure to add those new nodes one at a time. Have you checked for, and

Re: Cassandra Collections performance issue

On Mon, Feb 8, 2016 at 2:10 PM, Agrawal, Pratik wrote: > Recently we added one of the table fields from as Map in > *Cassandra > 2.1.11*. Currently we read every field from Map and overwrite map values. > Map is of size 3. We saw that writes are 30-40% slower

Re: Restart Cassandra automatically

On Thu, Feb 4, 2016 at 8:26 PM, Debraj Manna wrote: > What is the best way to keep cassandra running? My requirement is if for > some reason cassandra stops then it should get started automatically. > I recommend against this mode of operation. When automatically

Re: "Not enough replicas available for query" after reboot

On Thu, Feb 4, 2016 at 12:53 PM, Flavien Charlon wrote: > My cluster was running fine. I rebooted all three nodes (one by one), and > now all nodes are back up and running. "nodetool status" shows UP for all > three nodes on all three nodes: > > -- AddressLoad

Re: Want inputs about super column family vs map/list

On Thu, Feb 4, 2016 at 2:37 AM, Bhuvan Rawal wrote: > 1. Using super column family: > Super columns have been not-recommended for use for about five years now. =Rob

Re: Re : Possibility of using 2 different snitches in the Multi_DC cluster

On Tue, Feb 2, 2016 at 1:23 PM, sai krishnam raju potturi < pskraj...@gmail.com> wrote: > What is the possibility of using GossipingPropertFileSnitch on datacenters > in our private cloud, and Ec2MultiRegionSnitch in AWS? > You should just use GPFS everywhere. This is also the reason why you

Re: Session timeout

On Fri, Jan 29, 2016 at 3:12 PM, Jack Krupansky wrote: > One last time, I'll simply renew my objection to the way you are abusing > this list. > FWIW, while I appreciate that OP (Oleg) is attempting to do a service for the community, I agree that the flood of single

Re: Rename Keyspace offline

On Wed, Jan 27, 2016 at 6:49 AM, Jean Tremblay < jean.tremb...@zen-innovations.com> wrote: > Since it takes me 2 days to load my data, I was planning to load the new > set on a new keyspace (KS-Y), and when loaded drop KS-X and rename KS-Y to > KS-X. > Why bother with the rename? Just have two

Re: Strategy / order for upgradesstables during rolling upgrade.

On Thu, Jan 21, 2016 at 11:37 AM, Kevin Burton wrote: > I think there are two strategies to upgradesstables after a release. > > We're doing a 2.0 to 2.1 upgrade (been procrastinating here). > > I think we can go with B below... Would you agree? > > Strategy A: > > -

Re: Using cassandra a BLOB store / web cache.

On Mon, Jan 18, 2016 at 6:52 PM, Kevin Burton wrote: > Internally we have the need for a blob store for web content. It's MOSTLY > key, ,value based but we'd like to have lookups by coarse grained tags. > I know you know how to operate and scale MySQL, so I suggest MogileFS

Re: Using cassandra a BLOB store / web cache.

On Tue, Jan 19, 2016 at 2:07 PM, Richard L. Burton III wrote: > I would ask why do this over say HDFS, S3, etc. seems like this problem > has been solved with other solutions that are specifically designed for > blob storage? > HDFS's default block size is 64mb. If you are

Re: Help debugging a very slow query

On Wed, Jan 13, 2016 at 12:40 PM, Bryan Cheng wrote: > 1) What's up with the megapartition? What's the best way to debug this? > Our data model is largely write once, we don't do any updates. We do > DELETE, but the partitions that are giving us issues haven't been

Re: max connection per user

On Wed, Jan 13, 2016 at 1:41 PM, oleg yusim wrote: > Quick question, here: does Cassandra have a configuration switch to limit > number of connections per user (protection of DoS attack, security)? > Quick answer : no. =Rob

Re: Too many compactions, maybe keyspace system?

On Mon, Jan 11, 2016 at 9:12 PM, Shuo Chen wrote: > I have a assumption that, lots of pending compaction tasks jam the memory > and raise full gc. The full chokes the process and slows down compaction. > And this causes more pending compaction tasks and more pressure on

Re: Cassandra 1.2.19 and Java 8

On Tue, Jan 12, 2016 at 2:31 PM, Tim Heckman wrote: > We still have an installation of Cassandra on the 1.2.19 release, > running on Java 7. We do plan on upgrading to a newer version, but in > the mean time there has been some questions internally about running > 1.2 on Java

Re: Sorting & pagination in apache cassandra 2.1

On Mon, Jan 11, 2016 at 11:30 PM, anuja jain wrote: > 1 more question, what does it mean by "cassandra inherently sorts data"? > SSTable = Sorted Strings Table. It doesn't contain "Strings" anymore, really, but that's a hint.. :) =Rob

Re: Repair with "-pr" and vnodes

On Tue, Jan 12, 2016 at 3:46 PM, Roman Tkachenko wrote: > The documentation for the "-pr" repair option says it repairs only the > first range returned by the partitioner. However, with vnodes a node owns a > lot of small ranges. > > Does that mean that if I run rolling

Re: Too many compactions, maybe keyspace system?

The lines you are looking for look like this : INFO [CompactionExecutor:48] 2016-01-12 09:07:59,995 CompactionTask.java (line 120) Compacting [SSTableReader(path='/usr/local/cassandra/data/system/sstable_activity/system-sstable_activity-jb-4959-Data.db'),

Re: Too many compactions, maybe keyspace system?

On Sat, Jan 9, 2016 at 8:23 AM, Shuo Chen wrote: > I don't know what exactly compaction logs is like in system.log. But I see > logs like this in system.log, I think maybe this is the compaction log > grep -i compact /path/to/system.log =Rob

Re: Too many compactions, maybe keyspace system?

On Thu, Jan 7, 2016 at 6:30 PM, Shuo Chen wrote:, > > I am using Cassandra 2.0.16 with 4 nodes and found too many compactions > for this cluster. This caused too much full gc and choked the system. I > have discussed the high gc in previous mails but didnot get the

Re: Revisit Cassandra EOL Policy

On Fri, Jan 8, 2016 at 9:45 AM, Anuj Wadehra wrote: > *"Unfortunately how to get firm agreement on what criteria should be used > to judge "Production Ready" is unclear."* > Only you know how comfortable you are with the various types of risk that are involved in a

Re: Data rebalancing algorithm

On Thu, Jan 7, 2016 at 11:42 PM, Jonathan Haddad wrote: > num_tokens is the number of tokens per node, not per cluster. > MySQL docs are enumerated in the manual along with their scope. I have seen the enumeration in the Cassandra docs, but I don't remember seeing scope

Re: Revisit Cassandra EOL Policy

On Wed, Jan 6, 2016 at 5:26 PM, Anuj Wadehra wrote: > I would like to understand how various users are dealing with the > situation. Are you upgrading Cassandra every 3-6 mths? How do you cut short > your planning,test and release cycles for Cassandra upgrades in your >

Re: Slow performance after upgrading from 2.0.9 to 2.1.11

On Wed, Jan 6, 2016 at 11:41 AM, Peddi, Praveen wrote: > We have upgraded Cassandra from 2.0.9 to 2.1.11 in our loadtest > environment with pretty much same yaml settings in both (removed unused > yaml settings and renamed few others) and we have noticed performance on > 2.1.11

Re: CQL Composite Key Seen After Table Creation

On Wed, Jan 6, 2016 at 12:54 PM, Chris Burroughs wrote: > I work with Amir and further experimentation I can shed a little more > light on what exactly is going on under the hood. For background our goal > is to take data that is currently being read and written to

Re: Slow performance after upgrading from 2.0.9 to 2.1.11

On Wed, Jan 6, 2016 at 11:49 AM, Peddi, Praveen wrote: > 2nd column is replication factor (RF). I have 2 rows for reads and 2 for > writes. First row is RF=1 and 2nd row is RF=3. So when I said increasing RF > , I meant from 1 to 3. Sorry the table is probably not clear. > Ah,

Re: compaction_throughput_mb_per_sec

On Tue, Jan 5, 2016 at 6:50 AM, Ken Hancock wrote: > As to why I think it's cluster-wide, here's what the documentation says: > Do you see "system" used in place of "cluster" anywhere else in the docs? I think you are correct that the docs should standardize on

Re: Node stuck when joining a Cassandra 2.2.0 cluster

On Tue, Jan 5, 2016 at 3:01 AM, Herbert Fischer < herbert.fisc...@crossengage.io> wrote: > We run a small Cassandra 2.2.0 cluster, with 5 nodes, on bare-metal > servers and we are going to replace those nodes with other nodes. I planned > to add all the new nodes first, one-by-one, and later

Re: cassandra full gc too often

On Sun, Jan 3, 2016 at 5:54 PM, Shuo Chen wrote: > There are client operation in these days. Besides most columnfamily in the > cluster are supercolumnfamily created by cassandra-cli. Most rows have > average 30 sub-rows and each sub-row has 20 columns. > Supercolumns,

Re: Upgrade from 2.0.9 to 2.2.4

On Tue, Dec 29, 2015 at 2:31 PM, Mir Tanvir Hossain < mir.tanvir.hoss...@gmail.com> wrote: > Hello, is it possible to do a rolling upgrade from 2.0.9 to 2.2.4? > It is never supported to upgrade more than one major version of Cassandra. =Rob

Re: cassandra full gc too long

On Mon, Dec 28, 2015 at 5:57 PM, xutom wrote: > I have 5 nodes in my C* cluster, and each node has the same > configuration file(Cassandra-env.sh: MAX_HEAP_SIZE="32G" and > HEAP_NEWSIZE="8G"), and My Cassandra version is 2.1.1. Now I want to > export all data of one table,

Re: CQL Composite Key Seen After Table Creation

On Tue, Dec 22, 2015 at 6:55 AM, Amir Hassani wrote: > Defining the “column_metadata” after table creation vs during table > creation seems to affect the cql schema. We are running a large > high-throughput Cassandra 2.1.10 cluster. During table creation, the client >

Re: can't make any permissions change in 2.2.4

On Thu, Dec 17, 2015 at 9:10 AM, Kai Wang wrote: > I used to able to add/drop users and modify permissions in 2.1.1. After > upgrading to 2.2.4, I can't modify any of those. "List all permissions" > returns me all the permissions I setup before the upgrade. But I can't add >

Re: Would data be lost by nodetool removenode force

On Thu, Dec 17, 2015 at 4:44 PM, Shuo Chen wrote: >I have a 4 node cluster with status 3 UN and 1 DN. I am trying to add a > new node into the cluster but it is also dead. So the cluster is now 3 UN > and 2 DN. However I didnot run nodetool cleanup on any nodes. And

Re: Better setup to start using in production on one server

On Mon, Dec 14, 2015 at 10:53 PM, Vladimir Prudnikov wrote: > Save money. I don’t have huge enterprise behind me nor investor’s money on > my bank account. I just created an app and want to launch it and see if it > is what users will use and pay for. Once I get users

Re: Better setup to start using in production on one server

On Mon, Dec 14, 2015 at 10:53 PM, Vladimir Prudnikov wrote: > Is it hard to start with 3 nodes on one server running in docker and then > just move 2 nodes to the separate servers? > FWIW, if you *absolutely knew* that you were going to need the scale and for some reason

Re: Usage volume of older versions of Cassandra

On Tue, Dec 15, 2015 at 6:28 AM, Andy Kruth wrote: > We are trying to decide how to proceed with development and support of > YCSB bindings for older versions of Cassandra, namely Cassandra 7, 8, and > 10. > > We would like to continue dev and support on these if the use of

Re: Better setup to start using in production on one server

On Tue, Dec 15, 2015 at 11:15 AM, Jonathan Haddad wrote: > If I had to choose between running 3x docker instances and 1x instance on > a single server, I'd choose the single one. Instead of dealing with RF > changing nonsense I'd just set up a 2nd data center w/ 3 nodes and

Re: Unable to start one Cassandra node: OutOfMemoryError

On Tue, Dec 15, 2015 at 4:41 PM, Jack Krupansky wrote: > Can a core Cassandra committer verify if removing the compactions_in_progress > folder is indeed to desired and recommended solution to this problem, or > whether it might in fact be a bug that this workaround is

Re: Fatal Issues after upgrading to Cassandra 3.0.0/3.0.1 and using latest java driver 3.0.0-beta1

On Mon, Dec 14, 2015 at 1:17 PM, Carlos A wrote: > I had logged a bug on JIRA as I think it might be a better way of > reporting this: https://issues.apache.org/jira/browse/CASSANDRA-10861 > Thanks for keeping the list looped in on the JIRA URL. =Rob

Re: Better setup to start using in production on one server

On Mon, Dec 14, 2015 at 3:46 AM, Vladimir Prudnikov wrote: > [I want to run Cassandra on a single server] I struggle to imagine the purpose of doing this. You are going to sign yourself up for repeated painful changes of RF, as well as downtimes. As Michael says, you

Re: Fatal Issues after upgrading to Cassandra 3.0.0/3.0.1 and using latest java driver 3.0.0-beta1

On Mon, Dec 14, 2015 at 12:52 PM, Carlos A wrote: > We had upgrade to Cassandra 3.0.0 and later to 3.0.1. That went well. > System seems stable. > https://www.eventbrite.com/engineering/what-version-of-cassandra-should-i-run/ Running cutting edge versions of server and

Re: Fatal Issues after upgrading to Cassandra 3.0.0/3.0.1 and using latest java driver 3.0.0-beta1

On Mon, Dec 14, 2015 at 1:02 PM, Carlos A wrote: > Indeed you are correct, thanks for that. But It is not production it is > DEV server. We need some features of Cassandra 3 hence the need to upgrade > it. > Sure, consider my response "response to a nick I don't recognize

Re: read time coprocessor?

On Fri, Dec 11, 2015 at 8:34 AM, DuyHai Doan wrote: > The new UDF (User Defined Function) and UDA (User Defined Aggregate) > introduced since Cassandra 2.2 is the feature to closest HBase co-processor. > Aren't "Prototype Triggers" (which probably no one should use)

Re: Want to run repair on a node without it taking traffic

On Fri, Dec 4, 2015 at 11:44 AM, Anuj Wadehra wrote: > Did u say "longer than gc_grace_seconds" ? > Wont deletes pop back during repair? > Unfortunately, you are correct. Since CASSANDRA-4905 [1], such tombstones will not be propagated. The actual way to fully repair a

Re: Rebuilding a new Cassandra node at 100Mb/s

On Thu, Dec 3, 2015 at 7:51 AM, Jonathan Ballet wrote: > I noticed it's not really fast and my monitoring system shows that the > traffic incoming on this node is exactly at 100Mb/s (12.6MB/s). I know it > can be much more than that (I just tested sending a file through SSH >

Re: Restoring a snapshot into a new cluster - thoughts on replica placement

On Wed, Dec 2, 2015 at 5:06 AM, Peer, Oded wrote: > It seems it is not enough to restore the token ranges on an equal-size > cluster since you also need to restore the rack information. > Yep, if you're using a rack-aware snitch, that is correct. Because in that case, rack

Re: Want to run repair on a node without it taking traffic

On Wed, Dec 2, 2015 at 8:54 AM, K F wrote: > How can I run repair on a node without it taking any coordinator/client > traffic. So, I can complete the repair on the node without it taking any > traffic, except the streams from other nodes. Is that possible? > In general you

Re: Running sstableloader from every node when migrating?

On Thu, Nov 19, 2015 at 7:01 AM, George Sigletos wrote: > We would like to migrate one keyspace from a 6-node cluster to a 3-node > one. > http://www.pythian.com/blog/bulk-loading-options-for-cassandra/ =Rob

Re: Strategy tools for taking snapshots to load in another cluster instance

On Wed, Nov 18, 2015 at 2:23 AM, Anishek Agarwal wrote: > We have 5 node prod cluster and 3 node test cluster. Is there a way i can > take snapshot of a table in prod and load it test cluster. The cassandra > versions are same. >

Re: Does the rebuild tools rebuild all each time it start Or rebuild the rest?

On Fri, Nov 20, 2015 at 8:54 AM, wateray wrote: > *is it rebuild all rang of tokens which belong to the node or just rebuild > the rest rang of tokens from last rebuild.(since last rebuild we get some > data).* > There is no resume in versions before 2.2.x, it will

Re: Cassandra 3.0.0 connection problem

On Wed, Nov 18, 2015 at 11:13 PM, Enrico Sola wrote: > Hi, I'm new to Cassandra and I've recently upgraded to 3.0.0 on Ubuntu > Linux 14.04 LTS > https://www.eventbrite.com/engineering/what-version-of-cassandra-should-i-run/ =Rob

Re: handling down node cassandra 2.0.15

On Wed, Nov 18, 2015 at 6:16 AM, Anuj Wadehra wrote: > Suppose, gc grace seconds=10days, max hinted handoff period=3 hrs, 3 nodes > are there A,B & C,RF =3 and my client is reading at CL ONE. C remains down > for 5 hours and misses many updates including those which

Re: Moving SSTables from one disk to another

On Mon, Nov 30, 2015 at 11:29 AM, S C wrote: > It is inevitable that the repairs are needed to keep consistency > guarantees. Is it worthwhile to consider RAID-0 as we get more storage? One > can treat loss of disk as loss of node and rebuild the node and repair. Any > other

Re: Huge ReadStage Pending tasks during startup

On Fri, Nov 27, 2015 at 2:52 AM, Vasiliy I Ozerov wrote: > We have some strange troubles with cassandra startup. Cluster consists of > 4 nodes. 32 Gb RAM per node, each node has about 30Gb of data, 8 CPU. > > So, just after start it has 2753202 pending readstage tasks. And it

Re: Cassandra Cleanup and disk space

On Thu, Nov 26, 2015 at 12:55 AM, Luigi Tagliamonte wrote: > I'd like to understand what cleanup does on a running cluster when there > is no cluster topology change, i did a test and i saw the cluster disk > space shrink of 200GB. > "writes out files 1:1 with their input

Re: Nodetool rebuild on vnodes enabled

On Tue, Nov 17, 2015 at 3:24 PM, cass savy wrote: > I am exploring vnodes on DSE spark enabled DC. I added new nodes with 64 > vnodes, stream thruput 100mb instead of default 200mb, sokcet_timeout set > to 1hr. > 1) what version of Cassandra (please the version of Apache

Re: Help diagnosing performance issue

On Tue, Nov 17, 2015 at 11:08 AM, Sebastian Estevez < sebastian.este...@datastax.com> wrote: > You're sstables are probably falling out of page cache on the smaller > nodes and your slow disks are killing your latencies. > +1 most likely. Are the heaps the same size on both machines? =Rob

Re: Ingesting Large Number of files

On Tue, Nov 17, 2015 at 6:32 AM, Tushar Agrawal wrote: > We get periodic bulk load (twice a month) in form of delimited data files. > We get about 10K files with average size of 50 MB. Each record is a row in > Cassandra table. >

Re: handling down node cassandra 2.0.15

On Tue, Nov 17, 2015 at 4:33 AM, Anuj Wadehra wrote: > Only if gc_grace_seconds havent passed since the failure. If your machine > is down for more than gc_grace_seconds you need to delete the data > directory and go with auto bootstrap = true . > Since CASSANDRA-6961

Re: Deletes Reappeared even when nodes are not down

On Sat, Nov 14, 2015 at 9:58 AM, Peddi, Praveen wrote: > I checked tpstats and there are no dropped mutations (though I checked it > after restating the affected nodes). If the problem occurs again, I will > check tpstats again. Is there any stat that shows failed hints? The

Re: UnknownColumnFamily exception / schema inconsistencies

On Fri, Nov 13, 2015 at 12:31 PM, Maciek Sakrejda wrote: > On Fri, Nov 13, 2015 at 9:56 AM, Sebastian Estevez < > sebastian.este...@datastax.com> wrote: > >> I think you're just missing the steps in *Bold*: >> >> Thanks, but I wasn't clear on what to do if the "new" directory

Re: Deletes Reappeared even when nodes are not down

On Fri, Nov 13, 2015 at 1:09 PM, Peddi, Praveen wrote: > We are seeing a scenario where some of the rows in the table reappears > even after they are deleted. We have seen this in Prod 3 times in last 1 > week and *coincidentally all 3 times on the same partition*. We have >

Re: Deletes Reappeared even when nodes are not down

On Fri, Nov 13, 2015 at 1:47 PM, Peddi, Praveen wrote: > We do not currently run repairs because we know our deployment time for > each cassandra node is very short. I do understand we have to run repairs > but would repair be in the picture here when no nodes in the cluster

Re: too many full gc in one node of the cluster

On Thu, Nov 12, 2015 at 10:35 PM, Shuo Chen wrote: > We have a small cassandra cluster with 4 nodes for production. All the > nodes have similar hardware configuration and similar data load. The C* > version is 1.0.7 (prretty old) > > One of the node has much higher cpu

Re: Data.db too large and after sstableloader still large

On Thu, Nov 12, 2015 at 6:44 AM, qihuang.zheng wrote: > question is : why sstableloader can’t balance data file size? > Because it streams ranges from the source SStable to a distributed set of ranges, especially if you are using vnodes. It is a general property

Re: Cassandra compaction stuck? Should I disable?

On Mon, Nov 9, 2015 at 1:29 PM, PenguinWhispererThe . < th3penguinwhispe...@gmail.com> wrote: > > In Opscenter I see one of the nodes is orange. It seems like it's working > on compaction. I used nodetool compactionstats and whenever I did this the > Completed nad percentage stays the same (even

Re: Unable to bootstrap another DC in my cluster

On Mon, Nov 9, 2015 at 12:08 PM, K F wrote: > As I am trying to bring up a new DC in my cluster, my first seed node that > I bring-up in the new DC that I am adding to the existing cluster. It's not > able to receive reply back for the GossipDigestSyn request sent to other >

Re: Do I have to use the cql in the datastax java driver?

On Sun, Nov 8, 2015 at 6:57 AM, Jonathan Haddad wrote: > You shouldn't use thrift, it's effectively dead. > > On Fri, Nov 6, 2015 at 10:30 PM Dikang Gu wrote: > >> Can I still use thrift interface to talk to cassandra? Any reason that we >> should not

Re: Best way to recreate a cassandra node with data

On Sun, Nov 8, 2015 at 9:11 PM, John Wong wrote: > If we recreate an instance with the same IP, what is the best way to get > the node up and running with the previous data? Right now I am relying on > backup. > replace_address if you don't mind decreasing unique replica

Re: Does nodetool cleanup clears tombstones in the CF?

On Wed, Nov 4, 2015 at 12:56 PM, K F wrote: > Quick question, in order for me to purge tombstones on particular nodes if > I run nodetool cleanup will that help in > purging the tombstones from that node? > cleanup is for removing data from ranges the node no longer owns.

Re: Incremental repair from the get go

On Mon, Nov 2, 2015 at 3:02 PM, Maciek Sakrejda wrote: > Following up on this older question: as per the docs, one *should* still > do full repair periodically (the docs say weekly), right? And run > incremental more often to fill in? > Something that amounts to full repair

Re: Keyspaces missing after restarting cassandra service

On Mon, Nov 2, 2015 at 1:37 PM, Arun Sandu wrote: > After restarting the cassandra, all of my keyspaces got missing. I can > only see system_traces, system, dse_system. I didn't make any changes to > cassandra.yaml. > > But, I can see all the keyspaces data in my */data/

  1   2   3   4   5   6   7   8   9   10   >