Search Discussions
-
Try with the correct IP address as below: cqlsh 192.248.15.219 -u sinmin -p xxxxxx CQL documentation - http://docs.datastax.com/en/cql/3.0/cql/cql_reference/cqlsh.html
Ajay
Jul 19, 2015 at 8:38 am
Jul 27, 2015 at 4:04 pm -
Hi, I have a 2 node setup on Azure (east us region) running Ubuntu server 14.04LTS. Both nodes have 8GB RAM. One of the nodes (seed node) died with OOM - so, I am trying to add a replacement node ...
Kunal Gangakhedkar
Jul 10, 2015 at 7:59 am
Jul 13, 2015 at 5:28 pm -
Hello, I have a 4 node cluster with SimpleSnitch. Cassandra : Cassandra 2.1.3 I am trying to add a new node (cassandra 2.1.7) and I get the following error. ERROR [STREAM-IN-] 2015-06-30 05:13:48,516 ...
Neha Trivedi
Jul 1, 2015 at 4:17 am
Jul 2, 2015 at 2:11 pm -
Data structures that have a recently-modified access pattern seem to be a poor fit for Cassandra. I’m wondering if any of you smart guys can provide suggestions. For the sake of discussion, lets ...
Robert Wille
Jul 21, 2015 at 4:00 am
Jul 24, 2015 at 4:24 pm -
Hi, I have basic doubt: I have an RDBMS with the following two tables: Emp - EmpID, FN, LN, Phone, Address Sal - Month, Empid, Basic, Flexible Allowance My use case is to print the Salary slip at the ...
Srinivasa T N
Jul 6, 2015 at 12:02 pm
Jul 11, 2015 at 9:57 pm -
I know you can use `nodetool removenode` from the command line but is there a way to remove a node from a cluster using OpsCenter?
Sid Tantia
Jul 7, 2015 at 7:30 pm
Jul 29, 2015 at 1:29 am -
Hi, I am currently performing benchmarks on Cassandra. Independently from each other I am seeing ~100k writes/sec and ~50k reads/sec. When I read and write at the same time, writing drops down to ...
Soerian Lieve
Jul 23, 2015 at 9:53 pm
Jul 29, 2015 at 8:53 pm -
Hi everyone, Recently I've noticed that most of the nodes have OpsCenter agents running at 300% CPU. Each node has 4 cores, so agents are using 75% of total available CPU. We're running 5 nodes with ...
Mikhail Strebkov
Jul 14, 2015 at 6:58 pm
Jul 20, 2015 at 3:42 pm -
Hi All, After I added node, I run node tool cleanup on the old notes , but it takes forever, no error message, and I don't see space are freed. What should I do ? Repair first ? Thanks Rock
Rock zhang
Jul 24, 2015 at 10:57 pm
Jul 25, 2015 at 7:05 pm -
Hi there, Within our Cassandra cluster, we're observing, on occasion, one or two nodes at a time becoming partially unresponsive. We're running 2.1.7 across the entire cluster. nodetool still reports ...
Bryan Cheng
Jul 22, 2015 at 9:55 pm
Jul 23, 2015 at 1:24 am -
Is it ok to run this https://blog.mozilla.org/it/2012/06/30/mysql-and-the-leap-second-high-cpu-and-the-fix/ Seeing high cpu consumption for cassandra process
Snair123 .
Jul 1, 2015 at 2:55 am
Jul 1, 2015 at 8:23 pm -
We have a primary table and we need search capability by batchid column. So we are creating a manual index for search by batch id. We are using buckets to restrict a row size in batch id index table ...
Anuj Wadehra
Jul 23, 2015 at 5:27 pm
Jul 29, 2015 at 3:10 am -
All, I have a 4 node Cassandra system running on 4 Ubuntu boxes. After updating to Cassandra 2.2.0 and keeping the same cassandra.yaml file, the nodes cannot see each other. When I do a nodetool ...
Carlos Scheidecker
Jul 22, 2015 at 9:45 pm
Jul 23, 2015 at 1:19 am -
My understanding is that Cassandra File Structure follows below naming convention /cassandra/data/ <key-spaces <table Whereas our file structure is as below, each table has multiple names and when we ...
Saladi Naidu
Jul 10, 2015 at 4:16 pm
Jul 14, 2015 at 1:02 pm -
Hi, I have a keyspace which is using about 19GB on most nodes in the cluster. However on one node the data directory for the only table in that keyspace now uses 52GB. It seems that old sstables are ...
Jeff Williams
Jul 6, 2015 at 2:26 pm
Jul 7, 2015 at 10:08 am -
We have a 28 node cluster, out of which only one node is experiencing timeouts. We thought it was the raid, but there are two other nodes on the same raid without any problem. Also The problem goes ...
Shashi Yachavaram
Jul 1, 2015 at 4:59 pm
Jul 7, 2015 at 6:45 am -
Hi. Here is a schema disagreement we encountered. Schema versions: b6467059-5897-3cc1-9ee2-73f31841b0b0: [10.0.1.100, 10.0.1.109] c8971b2d-0949-3584-aa87-0050a4149bbd: [10.0.1.55, 10.0.1.16, ...
John Wong
Jul 3, 2015 at 2:38 am
Jul 6, 2015 at 8:53 pm -
Hi. First, some details; * Ubuntu 14.04.2 LTS. * Oracle Java 8 * Cassandra 2.2 (from datastax repo) * AWS VPC - two regions (Oregon, Ireland) * A pair of 3 node DCs in a single cluster - 1 DC per ...
James Vanns
Jul 30, 2015 at 4:24 pm
Aug 3, 2015 at 3:28 pm -
I'm wondering how the Cassandra protocol brings a newly bootstrapped node "up to speed". for ease of illustration, let's say we just have one key, K, and the value is continually updated: 1,2 ,3 ,4 ...
Yang
Jul 28, 2015 at 8:31 am
Jul 28, 2015 at 9:24 pm -
Hello all, After updating to Cassandra 2.2.0 from 2.1.6 I am having SSL issues: My JVM is java version "1.8.0_45" Java(TM) SE Runtime Environment (build 1.8.0_45-b14) Java HotSpot(TM) 64-Bit Server ...
Carlos Scheidecker
Jul 23, 2015 at 3:22 am
Jul 23, 2015 at 9:03 pm -
Hi, I am currently benchmarking Cassandra with three machines, and on each machine I am seeing an unbalanced distribution of data among the data directories (1 per disk). I am concerned that this ...
Soerian Lieve
Jul 17, 2015 at 9:08 pm
Jul 20, 2015 at 7:01 pm -
Hello, I cannot find documentation on the last two parameters given by cfstats below. It looks like most examples show 0 for these metrics, but our table has large numbers. What do these mean? Read ...
Venkatesh Kandaswamy
Jul 6, 2015 at 11:24 pm
Jul 9, 2015 at 7:39 pm -
Hi, I have weird driver behaviour. Can you help me please to find the problem? Problem: I try to insert data using 10 threads. I see that 10 thread starts, they start to insert some data and then ...
Serega Sheypak
Jul 2, 2015 at 8:00 am
Jul 3, 2015 at 12:59 pm -
Hello, I start a node with the write survey = true -Dcassandra.write_survey=true Log: INFO [main] 2015-07-29 15:29:35,697 StorageService.java (line 853) Startup complete, but write survey mode is ...
Aeljami Ext
Jul 29, 2015 at 3:05 pm
Jul 30, 2015 at 5:32 pm -
Hello! I've noticed a strange CPU utilisation patterns on machines in our cluster. After C* daemon restart it behaves in a normal way, after a few weeks since a restart CPU usage starts to raise ...
Marcin Pietraszek
Jul 20, 2015 at 7:16 am
Jul 28, 2015 at 2:30 pm -
Hi, I am starting to setup Usergrid on Cassandra, but I run into an issue that I debugged into and which does not seem to be related to Usergrid or my setup, since I run into an AssertionError (which ...
Andreas Schlüter
Jul 25, 2015 at 4:22 pm
Jul 28, 2015 at 8:17 am -
Hi All, I have 6 node, most of them are using node1 as seed, but I just find out 2 nodes are using node3 as seed, but everything looks fine. Does that mean seed node does not have to be same on all ...
Rock zhang
Jul 25, 2015 at 7:29 pm
Jul 26, 2015 at 5:04 pm -
Problem: Log analytics. Solutions: 1) Aggregating logs using Flume and storing the aggregations into Cassandra. Spark reads data from Cassandra, make some computations and write the results in ...
Renato Perini
Jul 23, 2015 at 12:06 am
Jul 23, 2015 at 4:01 pm -
Hi, I have a running cluster running with version 2.1.7. Two of the machines went down and they are not joining the cluster even after restart. I see the following WARN message in system.log in all ...
Amlan Roy
Jul 1, 2015 at 10:46 am
Jul 21, 2015 at 4:43 pm -
Hi all, Please, is that possible to change this command: nodetool getendpoints MyKeyspace MyTable text 10.147.243.4 10.147.243.5 to nodetool getendpoints MyKeyspace MyTable text="Hello" ? is there a ...
Thouraya TH
Jul 20, 2015 at 11:55 am
Jul 20, 2015 at 4:16 pm -
Regards to all Cassandra´s users. I just wanted to inform there is a new Java Zero Day exploit recently discovered by Trend Micro around the Hacking Team massive leak. This exploit is affecting the ...
Marcos Ortiz
Jul 14, 2015 at 7:34 pm
Jul 15, 2015 at 1:01 am -
We get lots of write timeouts when we decommission a node. About 80% of them are write timeout and just about 20% of them are read timeout. We’ve tried to adjust streamthroughput (and compaction ...
Kevin Burton
Jul 1, 2015 at 9:23 pm
Jul 2, 2015 at 1:11 am -
ERROR [Reference-Reaper:1] 2015-07-29 12:34:45,941 Ref.java:179 - LEAK DETECTED: a reference (org.apache.ca[email protected]) to class ...
Frisch, Michael
Jul 29, 2015 at 1:56 pm
Jul 31, 2015 at 3:20 pm -
Hi ALL The result of “select * from t_test where id = 1” statement is not consistency, Could you tell me why? test case, I = 0; While I < 5: result = cassandra_session.execute(“select ratio from ...
鄢来琼
Jul 31, 2015 at 1:03 am
Jul 31, 2015 at 1:54 am -
Hi, I get the following error intermittently while writing to Cassandra. I am using version 2.1.7. Not sure how to fix the actual issue without increasing the timeout in cassandra.yaml. Regards, ...
Amlan Roy
Jul 15, 2015 at 7:28 am
Jul 28, 2015 at 9:36 pm -
We have a transaction table,3 manually created index tables and few tables for reporting. One option is to go for atomic batch mutations so that for each transaction every index table and other ...
Anuj Wadehra
Jul 23, 2015 at 5:47 pm
Jul 25, 2015 at 11:10 am -
Hi, I have a simple (perhaps stupid) question. If I want to *search* data in cassandra, how could find in a text field all records which start with 'Cas' ( in sql I do select * from table where field ...
Anton
Jul 21, 2015 at 4:53 pm
Jul 22, 2015 at 9:06 am -
Hi all, I've been upgrading several of our rings from 2.1.6 to 2.1.8 and I've noticed that after the upgrade our storage load drops significantly (I've seen up to an 80% drop). I believe most of the ...
Mike Heffner
Jul 17, 2015 at 3:25 pm
Jul 20, 2015 at 3:40 am -
Hi, I'm trying to migrate from Cassandra 1.1 and Hector to a more up-to-date stack like Cassandra 1.2+ and CQL3. I have read http://www.datastax.com/dev/blog/thrift-to-cql3 ...
Clement Honore
Jul 16, 2015 at 9:23 am
Jul 17, 2015 at 8:43 am -
Hi, We're using Cassandra 2.0.10 ( 2 DC, 3 Nodes each RF=3 for each DC). During one of the weekly repairs, we received the following error: ERROR [ValidationExecutor:1280] 2015-07-12 22:18:10,992 ...
Modha, Digant
Jul 16, 2015 at 12:46 pm
Jul 16, 2015 at 1:10 pm -
Hi, I have a use case wherein I receive a daily batch of data; it's about 50M--100M records (a record is a list of integers, keyed by a UUID). The target is a 12-node cluster. Using a simple-minded ...
David Haguenauer
Jul 13, 2015 at 10:33 pm
Jul 14, 2015 at 1:51 pm -
Hey guys, I have a table with RF=3 and LCS. Data model makes use of "wide rows". A certain query run against this table times out and tracing reveals the following error on two out of three nodes ...
Roman Tkachenko
Jul 5, 2015 at 8:41 pm
Jul 12, 2015 at 3:11 pm -
Suppose I have a row of existing data with set of values for attributes I call this State1, and issue an update to some columns with Quorum consistency. If the write is succeeded in one node, Node1 ...
Saladi Naidu
Jul 8, 2015 at 9:08 pm
Jul 8, 2015 at 11:13 pm -
Hey guys, I'm using Ruby driver( http://datastax.github.io/ruby-driver/ ) for backup scripts. I tried to discover all peers and got wrong peers that are different with nodetool status ...
Nowarry
Jul 6, 2015 at 8:46 pm
Jul 6, 2015 at 9:34 pm -
I have two test clusters, both 2.0.15. One has a single node and one has three nodes. Truncate on the three node cluster is really slow, but is quite fast on the single-node cluster. My test cases ...
Robert Wille
Jul 1, 2015 at 9:53 pm
Jul 1, 2015 at 10:25 pm -
HI I have a 6 node cluster and I ran a major compaction on node 1 but I found that the load reached very high levels on node 2. Is this explainable? Attaching tpstats and metrics: cassandra-2 ~]$ ...
Jayapandian Ponraj
Jul 1, 2015 at 2:03 pm
Jul 1, 2015 at 5:01 pm -
All, Would you please point me to location where I can adjust/reconfig, so that I can insert into Blob field more than 500 bytes chunks without Cluster crash on me. I read from the user forum and saw ...
Noah chanmala
Jul 30, 2015 at 5:05 pm
Jul 31, 2015 at 12:14 pm -
Hello everyone, we are experiencing performance issues with Cassandra overloading effects (dropped mutations and node drop-outs) with the following workload: create table test (year bigint, spread ...
Petter. Andreas
Jul 23, 2015 at 10:55 am
Jul 23, 2015 at 6:15 pm -
Hi there, I am running a 6 node cluster on 2.1.7 with a table using DTCS to store time series data, for up to 12 hours (using ttl of 12h). Data are written as they arrive, without any update or ...
Christophe Schmitz
Jul 21, 2015 at 1:21 am
Jul 21, 2015 at 8:32 pm -
Hi, So since, I upgraded to 2.2-rc2 I get the CASSANDRA-9643 warning : WARN o.a.c.i.s.f.b.BigTableWriter - Compacting large partition XXXX bytes Some of my partitions may have ~20 millions of rows, ...
Pierre Devops
Jul 20, 2015 at 1:33 pm
Jul 20, 2015 at 6:32 pm
Group Overview
group | user |
categories | cassandra |
discussions | 81 |
posts | 338 |
users | 116 |
website | cassandra.apache.org |
irc | #cassandra |
116 users for July 2015
Archives
- June 2016 (205)
- May 2016 (300)
- April 2016 (382)
- March 2016 (604)
- February 2016 (513)
- January 2016 (568)
- December 2015 (273)
- November 2015 (398)
- October 2015 (528)
- September 2015 (445)
- August 2015 (286)
- July 2015 (338)
- June 2015 (499)
- May 2015 (312)
- April 2015 (483)
- March 2015 (564)
- February 2015 (519)
- January 2015 (555)
- December 2014 (566)
- November 2014 (427)
- October 2014 (380)
- September 2014 (484)
- August 2014 (475)
- July 2014 (545)
- June 2014 (535)
- May 2014 (487)
- April 2014 (473)
- March 2014 (567)
- February 2014 (605)
- January 2014 (465)
- December 2013 (485)
- November 2013 (421)
- October 2013 (464)
- September 2013 (598)
- August 2013 (583)
- July 2013 (712)
- June 2013 (545)
- May 2013 (566)
- April 2013 (730)
- March 2013 (836)
- February 2013 (712)
- January 2013 (736)
- December 2012 (395)
- November 2012 (612)
- October 2012 (629)
- September 2012 (692)
- August 2012 (604)
- July 2012 (612)
- June 2012 (719)
- May 2012 (723)
- April 2012 (627)
- March 2012 (755)
- February 2012 (608)
- January 2012 (621)
- December 2011 (604)
- November 2011 (714)
- October 2011 (696)
- September 2011 (840)
- August 2011 (1,053)
- July 2011 (984)
- June 2011 (1,090)
- May 2011 (932)
- April 2011 (999)
- March 2011 (1,198)
- February 2011 (1,420)
- January 2011 (1,066)
- December 2010 (771)
- November 2010 (584)
- October 2010 (670)
- September 2010 (669)
- August 2010 (790)
- July 2010 (962)
- June 2010 (913)
- May 2010 (1,021)
- April 2010 (1,477)
- March 2010 (964)
- February 2010 (419)
- January 2010 (379)
- December 2009 (446)
- November 2009 (465)
- October 2009 (347)
- September 2009 (173)
- August 2009 (177)
- July 2009 (259)
- June 2009 (40)
- May 2009 (48)
- April 2009 (16)
- March 2009 (12)