Re: Experiencing Timeouts on one node

3. How do we rebuild System keyspace? wipe this node and start it all over. hth jason On Tue, Jul 7, 2015 at 12:16 AM, Shashi Yachavaram wrote: > When we reboot the problematic node, we see the following errors in > system.log. > > 1. Does this mean hints column family is corrupted? > 2. Can

RE: Example Data Modelling

The data model suggested isn’t optimal for the “end of month” query you want to run since you are not querying by partition key. The query would look like “select EmpID, FN, LN, basic from salaries where month = 1” which requires filtering and has unpredictable performance. For this type of quer

Re: Question on 'Average tombstones per slice' when running cfstats

Wouldn't it suggest a delete heavy workload, rather than update? On Mon, Jul 6, 2015 at 5:21 PM Robert Coli wrote: > On Mon, Jul 6, 2015 at 4:19 PM, Venkatesh Kandaswamy < > ve...@walmartlabs.com> wrote: > >> I cannot find documentation on the last two parameters given by >> cfstats below. I

Re: Question on 'Average tombstones per slice' when running cfstats

On Mon, Jul 6, 2015 at 4:19 PM, Venkatesh Kandaswamy wrote: > 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? > Average live cells per slice (last five

Question on 'Average tombstones per slice' when running cfstats

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 Count: 60601817 Read Latency: 6.107321156707232 ms. Write Count: 185864222 Write Latency:

Re: Compaction issues, 2.0.12

I’ve seen the same thing: https://issues.apache.org/jira/browse/CASSANDRA-9577 I’ve had cases where a restart clears the old tables, and I’ve had cases where a restart considers the old tables to be live. > On Jul 6, 2015, at 1:51 PM, Rober

Re: Wrong peers

There is a bug in Jira related to this, it is not a driver issue, is a Cassandra issue. It is solved on 2.0.14 I think. I will post the ticket once I find it. Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo | Linkedin: *linkedin.com/in/c

Re: What are problems with schema disagreement

On Mon, Jul 6, 2015 at 1:30 PM, John Wong wrote: > But is there a problem with letting schema disagreement running for a long > time? > It depends on what the nature of the desynch is, but generally speaking there may be. If you added a column or a columnfamily, and one node didn't get that upd

Re: Compaction issues, 2.0.12

On Mon, Jul 6, 2015 at 1:46 PM, Jeff Williams wrote: > 1) Cassandra version is 2.0.12. > > 2) Interesting. Looking at JMX org.apache.cassandra.db -> ColumnFamilies > -> trackcontent -> track_content -> Attributes, I get: > > LiveDiskSpaceUsed: 17788740448, i.e. ~17GB > LiveSSTableCount: 3 > Tot

Re: Wrong peers

Anton, I have also seen this issue with decommissioned nodes remaining in the system.peers table. On the bright side, they can be safely removed from the system.peers table without issue. You will have to check every node in the cluster since this is a local setting per node. Jeff On 6 July 201

Re: Compaction issues, 2.0.12

Thanks Rob. 1) Cassandra version is 2.0.12. 2) Interesting. Looking at JMX org.apache.cassandra.db -> ColumnFamilies -> trackcontent -> track_content -> Attributes, I get: LiveDiskSpaceUsed: 17788740448, i.e. ~17GB LiveSSTableCount: 3 TotalDiskSpaceUsed: 55714084629, i.e. ~55GB So it obviously

Wrong peers

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.  = Status=Up/Down |/ State=Normal/Leaving/Joining/Moving --  Address       Load       Tokens  

Re: What are problems with schema disagreement

Thanks. Yeah we typically restart the nodes in the minor version to force resync. But is there a problem with letting schema disagreement running for a long time? Thanks. John On Mon, Jul 6, 2015 at 2:29 PM, Robert Coli wrote: > > > On Thu, Jul 2, 2015 at 9:31 PM, John Wong wrote: > >> Hi Gr

Re: What are problems with schema disagreement

On Thu, Jul 2, 2015 at 9:31 PM, John Wong wrote: > Hi Graham. Thanks. We are still running on 1.2.16, but we do plan to > upgrade in the near future. The load on the cluster at the time was very > very low. All nodes were responsive, except nothing was show up in the logs > after certain time, wh

Re: Compaction issues, 2.0.12

On Mon, Jul 6, 2015 at 7:25 AM, Jeff Williams wrote: > So it appears that the 10 sstables that were compacted > to > /var/lib/cassandra/data/trackcontent/track_content/trackcontent-track_content-jb-57372 > are still sitting around, with a couple of them being very large! > Any ideas for what I c

Re: Experiencing Timeouts on one node

When we reboot the problematic node, we see the following errors in system.log. 1. Does this mean hints column family is corrupted? 2. Can we scrub system column family on problematic node and its replication partners? 3. How do we rebuild System keyspace?

Re: Example Data Modelling

Hi Srinivasa, I think you're right, In Cassandra you should favor denormalisation when in RDBMS you find a relationship like this. I'd suggest a cf like this CREATE TABLE salaries ( EmpID varchar, FN varchar, LN varchar, Phone varchar, Address varchar, month integer, basic integer,

Re: Bootstrap code

For 2.1- https://github.com/apache/cassandra/blob/cassandra-2.1/src/java/org/apache/cassandra/dht/BootStrapper.java#L61 All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.p

Compaction issues, 2.0.12

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 not removed after compaction. Here is a view of the data directory Data files before compaction (I

Example Data Modelling

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 end of each month and the slip contains emp name and his other details. Now, if

BATCH consistency level VS. individual statement consistency level

Hi, I’m not sure how consistency level is applied on batch statement. I didn’t found detailed information on datastax.com (1) regarding that. - It is possible to set a CL on individual statements. - It is possible to set a

JDBC connectivity for Cassandra?

Hi Is their any official JDBC connectivity for Datastax Cassandra (or Cassandra in general). I am looking to fire "insert into" cassandra like that I can do in CQL. Thanks