Re: Reenable data access after temporarily moving data out of data directory

2016-02-24 Thread Alain RODRIGUEZ
> > Also are there any tools to actually repair the data rather than copy it > from a replica elsewhere because with the JVM error, the database JVMs are > not staying up. Repairing data means reducing entropy between the nodes. Data on one server is rarely corrupted nowadays (the appropriate

RE: Cassandra Data Audit

2016-02-24 Thread Charulata Sharma (charshar)
Thanks for the responses. I was looking for something available in Cassandra Open Stack not DSE. Looks like there isn’t any, so planning to create a Column family and have it populated. Thanks, Charu From: Alain RODRIGUEZ [mailto:arodr...@gmail.com] Sent: Wednesday, February 24, 2016 2:57 AM

how to read parent_repair_history table?

2016-02-24 Thread Jimmy Lin
hi all, few questions regarding how to read or digest the system_distributed.parent_repair_history CF, that I am very intereted to use to find out our repair status... - Is every invocation of nodetool repair execution will be recorded as one entry in parent_repair_history CF regardless if it is

Re: DataStax .NET Driver - Converting from Row to DataRow

2016-02-24 Thread Arko Provo Mukherjee
Thanks for the link. I have posted the question there. Warm regards Arko On Wed, Feb 24, 2016 at 8:59 PM, Alex Popescu wrote: > Arko, > > Please send your question to the .Net driver mailing list where you'll have > better chances to get an answer: >

Re: DataStax .NET Driver - Converting from Row to DataRow

2016-02-24 Thread Alex Popescu
Arko, Please send your question to the .Net driver mailing list where you'll have better chances to get an answer: https://groups.google.com/a/lists.datastax.com/forum/#!forum/csharp-driver-user thanks On Wed, Feb 24, 2016 at 6:37 PM, Arko Provo Mukherjee < arkoprovomukher...@gmail.com> wrote:

DataStax .NET Driver - Converting from Row to DataRow

2016-02-24 Thread Arko Provo Mukherjee
Hello, I am trying to play with the Datastax .Net Driver for Cassandra. I understand that the .Fill() method is not implemented in CqlDataAdapter. Hence I was wondering if there is any elegant way to copy a Cassandra Row to a DataRow? I can then construct a DataSet myself. Thanks & regards

Re: Debugging write timeouts on Cassandra 2.2.5

2016-02-24 Thread Jack Krupansky
Great that you found a specific release that triggers the problem - 2.1.x has a huge number of changes. How many partitions and rows do you have? What's the largest row count for a single partition? And all of these CQL tables are COMPACT STORAGE, correct? Are you writing a large number of skinny

Re: Debugging write timeouts on Cassandra 2.2.5

2016-02-24 Thread Nate McCall
> Testing the same write path using CQL writes instead demonstrates similar behavior. Was this via Java-Driver or the thrift execute_cql_query? If the latter, what happens when you change the rpc_server_type to sync? This line in tpstats is real weird:

Re: Debugging write timeouts on Cassandra 2.2.5

2016-02-24 Thread Mike Heffner
Nate, So we have run several install tests, bisecting the 2.1.x release line, and we believe that the regression was introduced in version 2.1.5. This is the first release that clearly hits the timeout for us. It looks like quite a large release, so our next step will likely be bisecting the

Re: Cassandra Collections performance issue

2016-02-24 Thread Agrawal, Pratik
Hi Daemeon, We tried changing the behavior "we overwrite every value" to update only 1 element in the map, and still we saw the same performance degradation. Thanks, Pratik From: daemeon reiydelle > Reply-To:

Re: JBOD device space allocation?

2016-02-24 Thread Marcus Eriksson
On Wed, Feb 24, 2016 at 6:28 PM, Jack Krupansky wrote: > Thanks. I didn't pay enough attention to that statement on my initial > reading of that post (which was where I became aware of the 3.2 behavior in > the first place.) > > Considering that the doc explicitly

Re: JBOD device space allocation?

2016-02-24 Thread Jack Krupansky
Thanks. I didn't pay enough attention to that statement on my initial reading of that post (which was where I became aware of the 3.2 behavior in the first place.) Considering that the doc explicitly recommends that the byte ordered partitioner not be used, that implies that the 3.2 JBOD behavior

Re: Reenable data access after temporarily moving data out of data directory

2016-02-24 Thread Jason Kania
Thanks for the tool reference. That will help. The second part of my question was whether there is a way to actually perform data repair aside from copying data from a replica. Thanks, Jason From: Carlos Alonso To: user@cassandra.apache.org; Jason Kania

Re: Cassandra Data Audit

2016-02-24 Thread Alain RODRIGUEZ
From http://docs.datastax.com/en/datastax_enterprise/4.6/datastax_enterprise/sec/secAuditCassandraTableColumns.html I guess you will not have the previous value that easy, yet all the operations seems to be logged, so looking for the last insert operation on a specific partition should give you

Re: Cassandra Data Audit

2016-02-24 Thread Raman Gugnani
Hi Alain, As per the document. Which column of the dse_audit.audit_log will hold the previous or new data. On Wed, Feb 24, 2016 at 3:59 PM, Alain RODRIGUEZ wrote: > Hi Charu, > > Are you using DSE or Open source Cassandra ? > > I never used it, but DSE brings a feature that

Re: Reenable data access after temporarily moving data out of data directory

2016-02-24 Thread Alain RODRIGUEZ
Hi Jason, nodetool refresh should be ok. You can also restart the node. Both should work. C*heers, - Alain Rodriguez France The Last Pickle http://www.thelastpickle.com 2016-02-24 7:07 GMT+01:00 Jason Kania : > Hi, > > I encountered an error in

Re: Reenable data access after temporarily moving data out of data directory

2016-02-24 Thread Carlos Alonso
Hi Jason Try this: https://docs.datastax.com/en/cassandra/2.1/cassandra/tools/toolsRefresh.html Carlos Alonso | Software Engineer | @calonso On 24 February 2016 at 07:07, Jason Kania wrote: > Hi, > > I encountered an error in Cassandra or

Re: Cassandra Data Audit

2016-02-24 Thread Alain RODRIGUEZ
Hi Charu, Are you using DSE or Open source Cassandra ? I never used it, but DSE brings a feature that seems to be what you are looking for --> http://docs.datastax.com/en/datastax_enterprise/4.6/datastax_enterprise/sec/secAuditingCassandraTable.html Never heard about such a thing in the Open