Re: COPY command to export a table to CSV file

2015-04-19 Thread Kiran mk
Hi, Thanks for the info, Does the nproc,nofile,memlock settings in /etc/security/limits.d/cassandra.conf are set to optimum value ? What is the consistency level ? Best Regardds, Kiran.M.K. On Mon, Apr 20, 2015 at 11:55 AM, Neha Trivedi wrote: > hi, > > What is the count of records in the c

Re: COPY command to export a table to CSV file

2015-04-19 Thread Neha Trivedi
hi, What is the count of records in the column-family ? We have about 38,000 Rows in the column-family for which we are trying to export What is the Cassandra Version ? We are using Cassandra 2.0.11 MAX_HEAP_SIZE and HEAP_NEWSIZE is the default . The Server is 8 GB. regards Neha On

Re: COPY command to export a table to CSV file

2015-04-19 Thread Kiran mk
Hi, check the MAX_HEAP_SIZE configuration in cassandra-env.sh environment file Also HEAP_NEWSIZE ? What is the Consistency Level you are using ? Best REgards, Kiran.M.K. On Mon, Apr 20, 2015 at 11:13 AM, Kiran mk wrote: > Seems like the is related to JAVA HEAP Memory. > > What is the count

Re: COPY command to export a table to CSV file

2015-04-19 Thread Kiran mk
Seems like the is related to JAVA HEAP Memory. What is the count of records in the column-family ? What is the Cassandra Version ? Best Regards, Kiran.M.K. On Mon, Apr 20, 2015 at 11:08 AM, Neha Trivedi wrote: > Hello all, > > We are getting the OutOfMemoryError on one of the Node and the No

COPY command to export a table to CSV file

2015-04-19 Thread Neha Trivedi
Hello all, We are getting the OutOfMemoryError on one of the Node and the Node is down, when we run the export command to get all the data from a table. Regards Neha ERROR [ReadStage:532074] 2015-04-09 01:04:00,603 CassandraDaemon.java (line 199) Exception in thread Thread[ReadStage:532074,5

timeout creating table

2015-04-19 Thread Jimmy Lin
hi, we have some unit tests that run parallel that will create tmp keyspace, and tables and then drop them after tests are done. >From time to time, our create table statement run into "All hosts(s) for query failed... Timeout during read" (from datastax driver) error. We later turn on tracing, a

Re: Bookstrapping new node isn't pulling schema from cluster

2015-04-19 Thread Anuj Wadehra
As Eric said make sure that node is not present in its own seed list. Also make sure that auto_bootstrap property is not set to false explicitly in yaml of the node. If that doesnt work You can also try removing the node using nodetool remove node and then adding it back. Removenode will cause s

Re: Bookstrapping new node isn't pulling schema from cluster

2015-04-19 Thread Eric Stevens
Is it one of your seed nodes, or does it otherwise have itself as a seed? A node will not bootstrap if it is in its own seeds list. On Apr 18, 2015 2:53 PM, "Bill Miller" wrote: > I upgraded a 5 node cluster from 1.2.5 to 1.2.9, ran ugradesstables and > installed oracle java without issues. Then