Unsubscribe

Please unsubscribe from this list Thanks Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 [http://c.mfcreative.com/mars/email/shared-icon/sig-logo.gif] We empower journeys of pe

Question about how sorted runs are picked for compaction with STCS

rted runs can be that on a point query, something must be fetched from all sorted runs to determine the value to return. This differs from what happens with RocksDB where the heap code can read from the iterators in (commit timestamp) order and stop once it gets a key (with a value or a tombs

TTL on UDT

When I run the command 'select ttl(udt_field) from table; I'm getting an error 'InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot use selection function ttl on collections"'. How can I get the TTL from a UDT field? Mark Furlong [cid:image001.png@01D5A92

Cassandra Schema History

to the performance limits of the gossip protocol this history makes restoring snapshots time-intensive. Is there a a way to, for lack of a better word, "rebase" the schema and sstables of a table to the latest schema to expunge the history? Thanks! -- Mark Bidewell http://www.li

Schema Management Best Practices

hese types of loads? Second, any ideas what could be creating bottlenecks for schema alteration? Thanks! -- Mark Bidewell http://www.linkedin.com/in/markbidewell

Alter table

Why would I want to use alter table vs upserts with the new document format? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.com/mars/email/shared-ic

java.lang.AssertionError: Memory was freed during index rebuild

the memory? Mark Bryant [Sumo-Logo] [Tel] +44 (0)114 2426766 [Web]www.sumo-digital.com [Address]32 Jessops Riverside, 800 Brightside Lane, Sheffield, S9 2RX, United Kingdom

Re: Why and How is Cassandra using all my ram ?

ing=summary and use jcmd to check out native memory usage from the JVM's perspective. -Mark - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

RE: Node failure

I’ll check to see what our app is using. Thanks Mark 801-705-7115 office From: Steinmaurer, Thomas [mailto:thomas.steinmau...@dynatrace.com] Sent: Friday, October 6, 2017 12:25 PM To: user@cassandra.apache.org Subject: RE: Node failure QUORUM should succeed with a RF=3 and 2 of 3 nodes

RE: Node failure

We are using quorum on our reads and writes. Thanks Mark 801-705-7115 office From: Jeff Jirsa [mailto:jji...@gmail.com] Sent: Friday, October 6, 2017 11:30 AM To: cassandra <user@cassandra.apache.org> Subject: Re: Node failure If you write with CL:ANY, CL:ONE (or LOCAL_ONE), and one node

RE: Node failure

Thanks for the detail. I’ll have to remove and then add one back in. It’s my consistency levels that may bite me in the interim. Thanks Mark 801-705-7115 office From: Jeff Jirsa [mailto:jji...@gmail.com] Sent: Friday, October 6, 2017 11:29 AM To: cassandra <user@cassandra.apache.org> S

RE: Node failure

The only time I’ll have a problem is if I have a do a read all or write all. Any other gotchas I should be aware of? Thanks Mark 801-705-7115 office From: Akshit Jain [mailto:akshit13...@iiitd.ac.in] Sent: Friday, October 6, 2017 11:25 AM To: user@cassandra.apache.org Subject: Re: Node failure

Node failure

What happens when I have a 3 node cluster with RF 3 and a node fails that needs to be removed? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.co

RE: Cassandra downgrade of 2.1.15 to 2.1.12

Great information. Thank you Mark 801-705-7115 office -Original Message- From: Michael Shuler [mailto:mshu...@pbandjelly.org] On Behalf Of Michael Shuler Sent: Monday, September 11, 2017 5:54 PM To: user@cassandra.apache.org Subject: Re: Cassandra downgrade of 2.1.15 to 2.1.12 On 09/11

Cassandra downgrade of 2.1.15 to 2.1.12

I have a requirement to test a downgrade of 2.1.15 to 2.1.12. Can someone please identify how to achieve this? Thanks, Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043

RE: Manual repair not showing in the log.

Yes, I have one validation task in my compactionstats. Thanks Mark 801-705-7115 office From: Carlos Rolo [mailto:r...@pythian.com] Sent: Thursday, September 7, 2017 2:06 PM To: user@cassandra.apache.org Subject: Re: Manual repair not showing in the log. Can you check if you have any validation

Manual repair not showing in the log.

column family in the keyspace… nothing. The repair appears to not be doing anything, what is it stuck on? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043

RE: Invalid Gossip generation

What do you recommend on taking this node out of the cluster, a decommission or a removenode? Since the communication between nodes is getting invalid gossip generation messages I would think a decommission might not be effective. Thanks Mark 801-705-7115 office From: Erick Ramirez

Invalid Gossip generation

is to upgrade this cluster to a new version of 2.1. In the meantime is there any other way then the above mentioned to get this node communicating with the cluster? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115

Rack Awareness

to identify the racks by the rack value or by the ip address? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.com/mars/email/shared-icon/sig-logo.gif]

RE: Restarting an existing node hangs

Cassandra doesn’t exit and continues to run with very little CPU usage shown in top. Thanks Mark 801-705-7115 office From: Jeff Jirsa [mailto:jji...@gmail.com] Sent: Wednesday, August 23, 2017 12:07 PM To: cassandra <user@cassandra.apache.org> Subject: Re: Restarting an existing node

Restarting an existing node hangs

I had an existing node go down. I don’t know the cause of this. I am starting Cassandra and I can see in the log that it starts and then hangs on the opening of an sstable. Is there anything I can do to fix the sstable? I’m on OSC 2.1.12. Thanks in advance, Mark Furlong Sr. Database

RE: Repair on system_auth

I’m currently on 2.1.12. Are you saying this bug exists on the current latest version 3.0.14? Thank you Mark 801-705-7115 office From: ­Fay Hou [Storage Service] [mailto:fay...@coupang.com] Sent: Thursday, July 6, 2017 2:24 PM To: User <user@cassandra.apache.org> Subject: Re:

Repair on system_auth

I have started a repair on my system_auth keyspace. The repair has started and the process shows as running with ps but am not seeing any CPU with top. I’m also note seeing any antientropy sessions building merkle trees in the log. Can I safely kill a repair and how? Mark Furlong Sr

Re-adding Decommissioned node

as ‘UN’ instead of ‘UJ’. Why is this? It has no data. Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.com/mars/email/shared-icon/sig-logo.gif]

Manual Repairs

Can a repair be paused, and if paused can it be restarted from the point of the pause, or does it start over? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043

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 of doing this? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-711

RE: Stable version apache cassandra 3.X /3.0.X

I need to reduce my disk footprint, how is 3.0.14 for stability? Also, where do I find upgrade instructions and version requirements? Thanks Mark 801-705-7115 office From: Carlos Rolo [mailto:r...@pythian.com] Sent: Wednesday, May 31, 2017 11:17 AM To: Jonathan Haddad <j...@jonhaddad.com&

Re: Weirdest problem on this mailing list

port > address to mailing list? Whoops. Looks like a couple of paypal addresses that I suspect have auto-responders managed to get themselves subscribed to this list. I'll get them removed now. Mark - To unsubscribe, e-m

RE: Decommissioned node cluster shows as down

I thought the same that the decommission would complete the removal of a node. I have heard something said about a 72 hour window, I’m not sure if that pertains to this version. Thanks Mark 801-705-7115 office From: Hannu Kröger [mailto:hkro...@gmail.com] Sent: Tuesday, May 16, 2017 10:09 AM

Decommissioned node cluster shows as down

a removenode now? Thanks, Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.com/mars/email/shared-icon/sig-logo.gif]

RE: Repairs on 2.1.12

The repair on the DC has completed in 308 hours. What would be helpful is if anyone has a good way of monitoring a manual ‘antientropy’ repair. Thanks Mark 801-705-7115 office From: kurt greaves [mailto:k...@instaclustr.com] Sent: Thursday, May 11, 2017 1:06 AM To: Mark Furlong <mf

Repairs on 2.1.12

properly. Mark Furlong Sr. Database Administrator mfurl...@ancestry.com<mailto:mfurl...@ancestry.com> M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.com/mars/email/shared-icon/sig-logo.gif]

Re: Migrating to LCS : Disk Size recommendation clashes

-- if LCS compaction can keep up. Cheers, Mark On Thu, Apr 13, 2017 at 8:23 AM, Amit Singh F <amit.f.si...@ericsson.com> wrote: > Hi All, > > > > We are in process of migrating from STCS to LCS and was just doing few > reads on line . Below is the excerpt from Datastax recom

Re: Maximum memory usage reached in cassandra!

You may have better luck switching to G1GC and using a much larger heap (16 to 30GB). 4GB is likely too small for your amount of data, especially if you have a lot of sstables. Then try increasing file_cache_size_in_mb further. Cheers, Mark On Tue, Mar 28, 2017 at 3:01 AM, Mokkapati, Bhargav

Re: Adding disk capacity to a running node

I've had luck using the st1 EBS type, too, for situations where reads are rare (the commit log still needs to be on its own high IOPS volume; I like using ephemeral storage for that). On Mon, Oct 17, 2016 at 3:03 PM, Branton Davis wrote: > I doubt that's true anymore.

Re: Is to ok restart DECOMMISION

if it died on anything. If so, the decommission process will never finish. If not, let it continue. Of particular note is that by default transferring large sstables will timeout. You can fix that by adjusting streaming_socket_timeout_in_ms to a sufficiently large value (I set it to a day). -Mark

External linking Was: Isolation in case of Single Partition Writes and Batching with LWT

On 12/09/2016 19:22, Jim Ancona wrote: > Mark, > > Is there some official Apache policy on which sites it's appropriate to > link to on an Apache mailing list? If so, could you please post a link > to it so we can all understand the rules. Or is this your personal > opinion

Re: Partition size

ntributor, committer or PMC > member) > > > Right. But policing /users/ (which Mark most certainly is) is just > douchebaggery. Users should feel free to participate with the resources > /they know best /without fear of reprisal. All of your statement > suggests this shit

Re: Isolation in case of Single Partition Writes and Batching with LWT

for "CQL" (and any similar search terms)? Mark > > Regards, > > Ryan Svihla > >> On Sep 12, 2016, at 6:34 AM, Mark Thomas <ma...@apache.org> wrote: >> >>> On 11/09/2016 23:07, Ryan Svihla wrote: >>> 1. A batch with updates to a single

Re: Isolation in case of Single Partition Writes and Batching with LWT

official Apache Cassandra docs unless there is a very good reason not to. (And if the good reason is that there’s a deficiency in the Apache Cassandra docs, please make it known on the list or in a Jira so someone can write what’s missing) Mark > Your biggest issue with such a desig

Re: Partition size

external ones. > > But Mark has absolutely no formal connection with the project, and his > contributions have only been to file a couple of JIRA (all of which have > so far been ignored by those of his colleagues who /are/ active > community members, I'll note!). Shaming

Re: Partition size

On 09/09/2016 16:46, Mark Curtis wrote: > If your partition sizes are over 100MB iirc then you'll normally see > warnings in your system.log, this will outline the partition key, at > least in Cassandra 2.0 and 2.1 as I recall. > > Your best friend here is nodetool cfstats

Re: Partition size

On 9 September 2016 at 16:47, Rakesh Kumar <rakeshkumar46...@gmail.com> wrote: > On Fri, Sep 9, 2016 at 11:46 AM, Mark Curtis <mark.cur...@datastax.com> > wrote: > > If your partition sizes are over 100MB iirc then you'll normally see > > warnings in your

Re: Partition size

quite often used to pinpoint large partitons on nodes in a cluster. More info here: https://docs.datastax.com/en/cassandra/2.1/cassandra/tools/toolsCFstats.html Thanks Mark On 9 September 2016 at 02:53, Anshu Vajpayee <anshu.vajpa...@gmail.com> wrote: > Is there any way to get parti

Re: large number of pending compactions, sstables steadily increasing

several sstables per read (higher latency than when leveled can keep up). How much data do you have per node? Do you update/insert to/delete rows? Do you TTL? Cheers, Mark On Wed, Aug 17, 2016 at 2:39 PM, Ezra Stuetzel <ezra.stuet...@riskiq.net> wrote: > I have one node in my cluster 2.

Re: My cluster shows high system load without any apparent reason

didn't see this problem with EBS. -Mark On Sat, Jul 23, 2016 at 7:21 AM, Juho Mäkinen <juho.maki...@gmail.com> wrote: > Hi Mark. > > I have an LVM volume which stripes the four ephemeral SSD:s in the system > and we use that for both data and commit log. I've used similar s

Re: My cluster shows high system load without any apparent reason

Hi Garo, Did you put the commit log on its own drive? Spiking CPU during stalls is a symptom of not doing that. The commitlog is very latency sensitive, even under low load. Do be sure you're using the deadline or noop scheduler for that reason, too. -Mark On Fri, Jul 22, 2016 at 4:44 PM, Juho

Re: My cluster shows high system load without any apparent reason

instances with the commit log on the ephemeral storage and data on st1 EBS volumes to be much more cost effective. It's something to look into if you haven't already. -Mark On Fri, Jul 22, 2016 at 8:10 AM, Juho Mäkinen <juho.maki...@gmail.com> wrote: > After a few days I've also tried disabl

Re: Cassandra event notification on INSERT/DELETE of records

+1 to what Eric said, a queue is a classic C* anti-pattern. Something like Kafka or RabbitMQ might fit your use case better. Mark On 24 May 2016 at 18:03, Eric Stevens <migh...@gmail.com> wrote: > It sounds like you're trying to build a queue in Cassandra, which is one > of the

Re: Nodes fail to reconnect after several hours of network failure.

tcp0 0 172.31.10.93:7001 172.31.10.93:56771 ESTABLISHED tcp0 0 172.31.10.93:7001 54.183.204.110:37491 ESTABLISHED Note i'm using 7001 here because my cluster uses SSL but you can use 7000 for the standard gossip port Thanks Mark On 21 January 2016 at 14

Re: Advice for asymmetric reporting cluster architecture

I hadn't considered it because I didn't think it could be configured just for a single data center; can it? On Oct 17, 2015 8:50 AM, "Jack Krupansky" <jack.krupan...@gmail.com> wrote: > Did you consider DSE Search in a DC? > > -- Jack Krupansky > > On Sat, Oct 17,

Advice for asymmetric reporting cluster architecture

I'd rather not pay to store them in all of my data centers. I wish there were a way to define secondary-indexes or materialized views to only exist in one DC of a cluster, but unless I've missed something it doesn't look possible. Any advice or case studies in this area would be greatly appreciated. -- Mark

Re: Is HEAP_NEWSIZE configuration is no more useful from cassandra 2.1 ?

Just to add some credibility to not using this setting. I've also seen information on Oracle's blogs too: http://www.oracle.com/technetwork/articles/java/g1gc-1984535.html Hope that helps Mark On 5 October 2015 at 08:59, Daniel Chia <danc...@coursera.org> wrote: > G1GC still has an

Re: Cassandra adding node issue (no UJ status)

Hey Rock, I've seen this occur as well. I've come to learn that in some cases, like a network blip, the join can fail. There is usually something in the log to the effect of "Stream failed" When I encounter this issue, I make an attempt to bootstrap the new node again. If that doesn't help, I

Re: Nodetool repair with Load times 5

Hey Jean, Did you try running a nodetool cleanup on all your nodes, perhaps one at a time? On Tue, Aug 18, 2015 at 3:59 AM, Jean Tremblay jean.tremb...@zen-innovations.com wrote: Hi, I have a phenomena I cannot explain, and I would like to understand. I’m running Cassandra 2.1.8 on a

Re: Record deletion job

No, this is what TTL is for. If you want to schedule a cron to delete data this will need to be an external task. On 19 June 2015 at 07:41, anil_ah anil...@yahoo.co.in wrote: Hi Is their any way to schedule a job in cassandra to delete the recrods which are older than a specific time

Re: connection refused error for cassandra-cli

and 2.1.5. Mark On 26 May 2015 at 10:38, Mahmood Naderan nt_mahm...@yahoo.com wrote: Hello, I have downloaded cassandra-1.2.0 for a test. The output of ./bin/cassandra and ./bin/cassandra-cli seems to be fine. Please see http://pastebin.com/Tgs7qyjS Next, I created a setup-ycsb.cql and wrote

Re: java.io.IOException: Failed during snapshot creation

Can you check your logs for any other other error message around the time of the repair? Something to look for would be Error occurred during snapshot phase. Regards, Mark On 25 May 2015 at 14:56, Sachin PK sachinpray...@gmail.com wrote: Hey I'm new to Cassandra ,I have 4 node cluster

Re: Disabling auto snapshots

To disable auto snapshots, set the property auto_snapshot: false in your cassandra.yaml file. Mark On 21 May 2015 at 08:30, Ali Akhtar ali.rac...@gmail.com wrote: Is there a config setting where automatic snapshots can be disabled? I have a use case where a table is truncated quite often

Re: Drop/Create table with same CF Name

Yes, it's a known issue. For more information on the topic see this support post from DataStax: https://support.datastax.com/hc/en-us/articles/204226339-How-to-drop-and-recreate-a-table-in-Cassandra-versions-older-than-2-1 Mark On 21 May 2015 at 15:31, Ken Hancock ken.hanc...@schange.com wrote

RepairException on C* 2.1.3

I'm receiving an exception when I run a repair process via: 'nodetool repair -par keyspace' I'm not sure if this is a bug or not but was curious to know if there was something that can be done to remedy this situation? Full stack trace from the logs: ERROR [ValidationExecutor:3] 2015-04-17

Re: Column value not getting updated

used as a guide. - https://blog.logentries.com/2014/03/synchronizing-clocks-in-a-cassandra-cluster-pt-1-the-problem/ - https://blog.logentries.com/2014/03/synchronizing-clocks-in-a-cassandra-cluster-pt-2-solutions/ -Mark On Tue, Mar 31, 2015 at 5:59 PM, Saurabh Sethi saurabh_se

Re: Steps to do after schema changes

/documentation/cassandra/2.0/cassandra/dml/dml_handle_schema_disagree_t.html Regards, Mark On 12 March 2015 at 05:47, Phil Yang ud1...@gmail.com wrote: Usually, you have nothing to do. Changes will be synced to every nodes automatically. 2015-03-12 13:21 GMT+08:00 Ajay ajay.ga...@gmail.com: Hi

Re: unsubscribe

Raman, To unsubscribe send a mail to user-unsubscr...@cassandra.apache.org On 22 February 2015 at 03:59, Raman ra...@assetcorporation.net wrote: unsubscribe

C* 2.1.3 - Incremental replacement of compacted SSTables

I saw in the NEWS.txt that this has been disabled. Does anyone know why that was the case? Is it temporary just for the 2.1.3 release? Thanks, Mark Greene

Re: Why no virtual nodes for Cassandra on EC2?

/datastax_enterprise/4.0/datastax _enterprise/ana/anaStrt.html This is specific to the example AMI and that type of workload. This is by no means a warning for users to disable vnodes on their Real-Time/Transactional Cassandra only clusters on EC2. I've used vnodes on EC2 without issue. Regards, Mark

Re: Cancel subscription

Please use user-unsubscr...@cassandra.apache.org to unsubscribe from this mailing list. Thanks Regards, Mark On 19 February 2015 at 09:14, Hilary Albutt - CEO hil...@incrediblesoftwaresolutions.com wrote: Cancel subscription

Re: Node joining take a long time

What is a long time in your scenario? What is the data size in your cluster? I'm sure Rob will be along shortly to say that 2.1.2 is, in his opinion, broken for production use...an opinion I'd agree with. So bare that in mind if you are running a production cluster. Regards, Mark On 19

Re: Cassandra install on JRE vs JDK

Yes you can use Oracle JDK if your prefer, I've been using the JDK with Cassandra in production for years without issue. Regards, Mark On 18 February 2015 at 19:49, cass savy casss...@gmail.com wrote: Can we install Oracle JDK instead of JRE in Cassandra servers? We have few clusters running

Re: High GC activity on node with 4TB on data

cluster setup (No. of CFs, read/write patterns, do you delete / update often, etc.) that may help in getting you to a better place. Regards, Mark On 8 February 2015 at 21:10, Kevin Burton bur...@spinn3r.com wrote: Do you have a lot of individual tables? Or lots of small compactions? I think

Re: Compacted_at timestamp

. If you are seeing something other than an expected timestamp value, can you post an example of what you are getting? Regards, Mark On 8 February 2015 at 13:20, Havere Shanmukhappa, Santhosh santhosh_havereshanmukha...@intuit.com wrote: When I run nodetool compactionhistory command

Re: Error while starting Cassandra for the first time

be an indication that there are some values that need to be escaped or the paths need to be quoted. Regards, Mark On 5 February 2015 at 04:29, Krish Donald gotomyp...@gmail.com wrote: I have used the yaml validator but tried to fixed based on error messages , I had to comment data_directories

Re: Case Study for Learning Cassandra

* usage: https://academy.datastax.com/ Regards, Mark On 5 February 2015 at 04:38, Krish Donald gotomyp...@gmail.com wrote: Hi, I am new to Cassandra and have setup 4 nodes Cassandra cluster using VMs. Looking for any case study which I can do to understand the Cassandra Administration

Re: Newly added column not visible

Hey Saurabh, I can't say that I have experienced this before, however if you can reliably reproduce the issue it would be worth commenting on the JIRA issue you linked to or alternatively creating a new JIRA with as much info (setup, test case, debug logs, etc) as possible. Regards, Mark On 5

Re: Error while starting Cassandra for the first time

to start. You should be able to validate your yaml file with some online validator such as http://www.yamllint.com/ Regards, Mark On 4 February 2015 at 22:23, Krish Donald gotomyp...@gmail.com wrote: Hi, I am getting below error: Not able to understand why ?? [csduser@master bin

Re: Question about use scenario with fulltext search

industries: http://planetcassandra.org/apache-cassandra-use-cases/ Regards, Mark On 1 February 2015 at 16:05, anton anto...@gmx.de wrote: Hi, I was just reading about cassandra and playing a little with it (using django www.djangoproject.com on the web server). One thing that I realized

Re: High Bloom Filter FP Ratio

We're seeing similar behavior except our FP ratio is closer to 1.0 (100%). We're using Cassandra 2.1.2. Schema --- CREATE TABLE contacts.contact ( id bigint, property_id int, created_at bigint, updated_at

Error when dropping keyspaces; One row required, 0 found

I'm running Cassandra 2.1.0. I was attempting to drop two keyspaces via cqlsh and encountered an error in the CLI as well as the appearance of losing all my keyspaces. Below is the output from my cqlsh session: $

Re: A questiion to adding a new data center

to make changes on both the current and new DCs Step 4 - Client config Step 5 - Client config Step 6 - New DC Step 7 - New DC Step 8 - New DC Mark On 21 November 2014 03:27, Lu, Boying boying...@emc.com wrote: Hi, all, I read the document about how to adding a new data center to existing

Re: [jira] Akhtar Hussain shared a search result with you

you to look at your server logs for further diagnosis. Mark On 21 November 2014 11:15, Akhtar Hussain (JIRA) j...@apache.org wrote: Akhtar Hussain shared a search result with you - https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=truejqlQuery

Re: max ttl for column

Hi Rajanish, Cassandra imposes a max TTL of 20 years. public static final int MAX_TTL = 20 * 365 * 24 * 60 * 60; // 20 years in seconds See: https://github.com/apache/cassandra/blob/8d8fed52242c34b477d0384ba1d1ce3978efbbe8/src/java/org/apache/cassandra/db/ExpiringCell.java#L37 Mark On 21

Re: logging over multi-datacenter

Hi Adil, What Cassandra version are you using? Are you using the default user or a non-default user? Mark On 20 November 2014 08:20, Adil adil.cha...@gmail.com wrote: Hi, We have two data-center, we configured PasswordAuthenticator on each node, we increment the RF of system_auth

Re: logging over multi-datacenter

Hi Adil, When using the default superuser ('cassandra') a consistency level of QUORUM is used. When using other users ONE is used. You are not supposed to use 'cassandra' user directly, except to create another superuser and use that one from that point on. Mark On 20 November 2014 14:40

Re: any way to get nodetool proxyhistograms data for an entire cluster?

To be clear, I don't believe DSE is required to use OpsCenter. My understanding is that it can be used with vanilla Apache Cassandra, but I have never actually tried to do so. Correct Rob, you can use Opscenter with vanilla Apache Cassandra. Mark On 20 November 2014 16:10, Robert Coli rc

Re: What time range does nodetool cfhistograms use?

Hi Clint, The values of SSTables, Write Latency and Read Latency will be reset on node start/restart and after running the cfhistograms command itself. The values of Row Size and Column Count are calculated at startup and then re-evaluated during compaction. Mark On 16 November 2014 17:12

Re: Netstats 100% streaming

HI Eric, It looks like you are running into CASSANDRA-7878 https://issues.apache.org/jira/browse/CASSANDRA-7878 which is fixed in 2.0.11 / 2.1.1 Mark On 1 November 2014 14:08, Eric Stevens migh...@gmail.com wrote: We've been commissioning some new nodes on a 2.0.10 community edition cluster

Re: EC2 Snitch load imbalance

Oleg, If you are running nodetool status, be sure to specify the keyspace also. If you don't specify the keyspace the results will be nonsense. https://issues.apache.org/jira/browse/CASSANDRA-7173 Regards, Mark On 28 October 2014 10:35, Oleg Dulin oleg.du...@gmail.com wrote: I have a setup

Re: Can't Add AWS Node due to /mnt/cassandra/data directory

/saved_caches And then give the cassandra user ownership of those directories: sudo chown -R cassandra:cassandra /mnt/cassandra Once this is done Cassandra will have the correct directories and permission to start up. Mark On 27 August 2014 09:50, Stephen Portanova sport...@gmail.com wrote: I

Re: Installing Cassandra Multinode on CentOs coming up with exception

: - seeds: 192.168.1.32 Regards, Mark On 26 August 2014 08:12, Vineet Mishra clearmido...@gmail.com wrote: Hi All, I am installing Cassandra Multinode Setup on a 4 node CentOs Cluster, my cassandra.yaml looks like so cluster_name: 'node' initial_token: 0 num_tokens: 256 seed_provider

Re: Installing Cassandra Multinode on CentOs coming up with exception

You are missing commitlog_sync in your cassandra.yaml. Are you generating your own cassandra.yaml or editing the package default? If you are generating your own there are several configuration options that are required and if not present, Cassandra will fail to start. Regards, Mark On 26

Re: Secondary index or dedicated CF?

-cardinality data (for example: fields with less than 1000 states).“ Mark On 22 Aug 2014, at 15:58, DuyHai Doan doanduy...@gmail.com wrote: Hello Eric Under the hood what is the difference of the both solutions? 1. Cassandra secondary index: distributed index, supports better high volume

Re: 答复: can not query data from cassandra

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, 鄢来琼 laiqiong@gtafe.com wrote: Is it related to MAX_HEAP_SIZE

Re: Cassandra Consistency Level

/cassandra/2.0/cassandra/reference/referenceTableAttributes.html Just to verify that this is in fact a consistency issue could you run a nodetool repair on that table and run the same queries again? Mark Regards, Mark On 20 August 2014 00:14, Check Peck comptechge...@gmail.com wrote: We have

Re: question about OpsCenter agent

/agentAddressConfiguration.html Mark On Fri, Aug 15, 2014 at 3:32 AM, Clint Kelly clint.ke...@gmail.com wrote: Hi all, I just installed DataStax Enterprise 4.5. I installed OpsCenter Server on one of my four machines. The port that OpsCenter usually uses () was used by something else, so I

Re: Bootstrap failures: unable to find sufficient sources for streaming range

Hi Peter, At the time of the IllegalStateException, do you see the node that it should be streaming from marked as down by the failure detector? Mark On Fri, Aug 15, 2014 at 5:45 AM, Peter Haggerty peter.hagge...@librato.com wrote: When adding nodes via bootstrap to a 27 node 2.0.9 cluster

Re: How to prevent the removed DC comes back automactically?

How can we prevent a disconnected DC from coming back automatically? You could use firewall rules to prevent the disconnected DC from contacting your live DCs when it becomes live again Mark On Thu, Aug 14, 2014 at 6:48 AM, Lu, Boying boying...@emc.com wrote: Hi, All, We are using

Re: A question to nodetool removenode command

. Mark On Thu, Aug 14, 2014 at 10:20 AM, Lu, Boying boying...@emc.com wrote: Hi, All, We have a Cassandra 2.0.7 running in three connected DCs, say DC1, DC2 and DC3. DC3 is powered off, so we run ‘nodetool removenode’ command on DC1 to remove all nodes of DC3. Do we need to run

Re: Cassandra corrupt column family

Hi, Without more information (Cassandra version, setup, topology, schema, queries performed) this list won't be able to assist you. If you can provide a more detailed explanation of the steps you took to reach your current state that would be great. Mark On Tue, Aug 12, 2014 at 12:21 PM

Re: Nodetool Repair questions

to running repairs? Mark On Tue, Aug 12, 2014 at 10:06 PM, Viswanathan Ramachandran vish.ramachand...@gmail.com wrote: Some questions on nodetool repair. 1. This tool repairs inconsistencies across replicas of the row. Since latest update always wins, I dont see inconsistencies other than ones

  1   2   3   4   >