Dropping index

So we have decided to drop those unused indexes. Please let us know what could be the consequences of dropping indexes from such a huge table . And what steps should be followed to keep cluster stable. Regards Rahul Bhardwaj -- Download IndiaMART App <https://itunes.apple.com/WebObjects/MZS

compaction occurring very frequently

long time in compacting. Par New collection time and CMS collection time have also increased on those node. Please suggest what could be the problem. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.g

jvm unstable

='Cannot allocate memory' (errno=12) please help in solving it. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <https://www.facebook.com/IndiaMART> <https://twitter

Re: error='Cannot allocate memory' (errno=12)

Hi Robert, I saw somewhere you answering the same prob but no solution found. plz check again. regards: Rahul Bhardwaj On Mon, May 11, 2015 at 5:49 PM, Rahul Bhardwaj < rahul.bhard...@indiamart.com> wrote: > Bu it is giving same error with java 7 and open jdk > > On Mon, Ma

Re: error='Cannot allocate memory' (errno=12)

th 2.0.14+ cassandra is tested but not sure about > 2.1.x versions. > > > On Mon, May 11, 2015 at 4:04 PM, Rahul Bhardwaj < > rahul.bhard...@indiamart.com> wrote: > >> PFA of error log​ >> hs_err_pid9656.log >> <https://docs.google.com/a/indiamart.com/

Re: error='Cannot allocate memory' (errno=12)

PFA of error log​ hs_err_pid9656.log <https://docs.google.com/a/indiamart.com/file/d/0B0hlSlesIPVfaU9peGwxSXdsZGc/edit?usp=drive_web> ​ On Mon, May 11, 2015 at 3:58 PM, Rahul Bhardwaj < rahul.bhard...@indiamart.com> wrote: > free RAM: > > > free -m >

Re: error='Cannot allocate memory' (errno=12)

ram on the box ? > > On Mon, May 11, 2015 at 3:28 PM, Rahul Bhardwaj < > rahul.bhard...@indiamart.com> wrote: > >> Hi All, >> >> We have cluster of 3 nodes with 64GB RAM each. My cluster was running in >> healthy state. Suddenly one machine's cass

error='Cannot allocate memory' (errno=12)

; error='Cannot allocate memory' (errno=12 This is our production cluster and rest 2 nodes are still in healthy state. We have also changed heap size from 10G to 20 G but problem still persists. Please help in finding the reason behind this. Regards: Rahul Bhardwaj -- F

bulk uploading

loader but how will it sync three nodes data into 5 nodes. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <https://www.facebook.com/IndiaMART> <https://twitter.com/India

Re: calculation of disk size

ence: > http://docs.datastax.com/en/cassandra/2.0/cassandra/architecture/architecturePlanningDiskCapacity_t.html > > Thanks > > On Wed, Apr 29, 2015 at 9:20 PM, Rahul Bhardwaj < > rahul.bhard...@indiamart.com> wrote: > >> Hi All, >> >> >> We are planning to set up a cluste

calculation of disk size

we would require. Kindly suggest. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART>

check active queries on cluster

Hi All, We want to track active queries on cassandra cluster. Is there any tool or way to find all active queries on cassandra ? Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart

Re: sstable loader

Hi Venessa, Thanks for sharing. But when after compiling BulkLoad.java, on executing it is returning Exception in thread "main" java.lang.NoClassDefFoundError: BulkLoad (wrong name: bulkload/BulkLoad) had you also seen this. Regards: Rahul Bhardwaj On Mon, Mar 30, 2015 at 12:57 P

Re: sstable loader

wrong , actually not good java developer, so plz guide. Regards: Rahul Bhardwaj On Fri, Mar 27, 2015 at 2:55 PM, Amila Paranawithana wrote: > Hi, > > This post[1] may be useful. But note that this was done with cassandra > older version. So there may be new way to do this. > >

Re: ('Unable to complete the operation against any hosts', {})

Hi All, awaiting any response.. please help regards: rahul On Fri, Mar 27, 2015 at 5:54 PM, Rahul Bhardwaj < rahul.bhard...@indiamart.com> wrote: > Hi All, > > > > We are using cassandra version 2.1.2 with cqlsh 5.0.1 (cluster of three > nodes with rf 2) > > I

('Unable to complete the operation against any hosts', {})

inserts few more records and gives the same error without any specific. please help if any one have some idea about this error. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart>

sstable loader

Hi All, Can we use sstable loader for loading external flat file or csv file. If yes , kindly share the steps or manual. I need to put 40 million data into a table of around 70 columns Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates o

error in bulk loading

Hi all, I need to import a csv file to a table using copy command, but file contains carriage returns which causing me problem in doing so, Is there any way in cassandra to solve this Regards: Rahul -- Follow IndiaMART.com for latest updates on this and more:

Re: cassandra triggers

Yes Asit you can share it with me, let c if we can implement with our requirement. Regards: Rahul Bhardwaj On Mon, Mar 23, 2015 at 1:43 PM, Asit KAUSHIK wrote: > Hi Rahul, > > i have created a trigger which inserts a default value into the table. But > everyone are against using i

cassandra triggers

Hi All, I want to use triggers in cassandra. Is there any tutorial on creating triggers in cassandra . Also I am not good in java. Pl help !! Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+

Re: active queries

Thanks to all, I will get back to you after looking all. On Fri, Mar 20, 2015 at 2:56 AM, Robert Coli wrote: > On Thu, Mar 19, 2015 at 1:30 PM, Jan wrote: > >> Answer: nodetool tpstats & nodetool cfsstats >> > > For a better view of this : > > https://github.com/hailocab/ctop > > =Rob >

active queries

Hi , Can we see active queries on cassandra cluster. Is there any tool? Please help. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <https://www.facebook.com/In

dblink between oracle and cassandra

Hi All, I want make a dblink from oracle 11g and cassandra cluster. Is there any way or any alternative to do the same. please help. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+

Re: error while bulk loading using copy command

> <http://en.wikipedia.org/wiki/Lakh> isn't a common unit where I'm from, > by 18 lacs I assume you mean 1.8 million (1,800,000)? > > On Wed, Jan 28, 2015 at 10:28 PM, Rahul Bhardwaj < > rahul.bhard...@indiamart.com> wrote: > >> Hi All, >> &g

error while bulk loading using copy command

ause after loading this data we want to use functionality of counter data type. Kindly help is there any way to do this. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <https://w

problem in exporting large table

live cells per slice (last five minutes): 102.0 Average tombstones per slice (last five minutes): 0.0 Maximum tombstones per slice (last five minutes): 0.0 regards Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on thi

error on using sstable loader

r.java:155) at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:94) Please help in resolving the same. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <

Re: how dump a query result into csv file

On Mon, Jan 12, 2015 at 4:07 PM, Rahul Bhardwaj < rahul.bhard...@indiamart.com> wrote: > Hi, > > Thanks for your quick reply. > > But I know this command , but for one table which has around 10lacs rows, > this command (Copy table_name to 'table_name.csv' ) get stu

Re: how dump a query result into csv file

cells per slice (last five minutes): 2.0 Average tombstones per slice (last five minutes): 0.0 Maximum tombstones per slice (last five minutes): 0.0 Please help in finding the cause. Regards: Rahul Bhardwaj On Mon, Jan 12, 2015 at 3:05 PM, Andreas Finke wr

how dump a query result into csv file

Hi All, I want to dump a query result into a csv file with custom column delimiter. Please help. Regards: Rahul Bhardwaj -- Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this and more: <https://plus.google.com/+indiamart> <https://www.facebook.com/In

Re: Cassandra consuming whole RAM (64 G)

the reason for these errors.* regards: Rahul Bhardwaj On Tue, Jan 6, 2015 at 10:46 PM, Ryan Svihla wrote: > That even with that patch you'll likely run heap pressure with batches of > that size, so either increase your heap and take the GC hit on CPU (and > have longer GCs) or do

Re: Cassandra consuming whole RAM (64 G)

, this will cause a signficant amount of heap pressure. > > The root cause fix is not to use giant batches in the first place. > > On Tue, Jan 6, 2015 at 4:43 AM, Rahul Bhardwaj < > rahul.bhard...@indiamart.com > > wrote: > >> Hi Joe.. >> >> Thanks fo

Re: Cassandra consuming whole RAM (64 G)

://issues.apache.org/jira/browse/CASSANDRA-8248 ?? regards: Rahul Bhardwaj On Tue, Jan 6, 2015 at 12:42 PM, Joe Ramsey wrote: > Thanks Rahul and good luck! I’m really curious to hear what the result is. > > > On Jan 6, 2015, at 2:10 AM, Rahul Bhardwaj > wrote: > > Thanks for your

Re: Cassandra consuming whole RAM (64 G)

_log_segment_size_in_mb from 32 to 64 and see > if the error goes away. It really should get tuned for the amount of > writes but that’ll tell you at least if this is the issue. > > Let me know how it goes! > > Joe > > > > On Jan 6, 2015, at 1:40 AM, Rahul Bhardwaj &g

Re: Cassandra consuming whole RAM (64 G)

Service.java:164) ~[apache-cassandra-2.1.2.jar:2.1.2-SNAPSHOT] at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [apache-cassandra-2.1.2.jar:2.1.2-SNAPSHOT] at java.lang.Thread.run(Unknown Source) [na:1.7.0_71] Regards: Rahul Bhardwaj On Tue, Jan 6, 2015 at 12:08

Re: Cassandra consuming whole RAM (64 G)

Hi Joe, PFA heap dump regards: Rahul Bhardwaj On Tue, Jan 6, 2015 at 11:35 AM, Joe Ramsey wrote: > Did you try generating a heap dump so you can look through it to see > what’s actually happened? > > > On Jan 6, 2015, at 12:58 AM, Rahul Bhardwaj > wrote: > > Hi, &g

Cassandra consuming whole RAM (64 G)

Hi, We are using cassandra 2.1 version in a cluster of three machines each with 64 GB RAM The processes are killed by kernel, coz they are eating all memory (oom-killer). We have set JAVA heap to default (i.e. it is using 8G) because we have 64 GB RAM. Please help. Regards: Rahul Bhardwaj

subscribe me on this list

-- Follow IndiaMART.com for latest updates on this and more: Mobile Channel: