cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "umang shah" <shahuma...@gmail.com>
Subject problem with copy command and heap size
Date Fri, 27 Jun 2014 04:01:40 GMT
 

1) i am using below commands for coping data

 

COPY events.standardevents (uuid, data, name, time, tracker, type, userid)
TO 'temp.csv'; 

 

truncate standardevents;

 

COPY event.standardeventstemp (uuid, data, name, time, tracker, type,
userid) FROM 'temp.csv';

 

if table is not containing any field with uuid data-type above commands are
working fine but if it is containig data-type as a uuid then it is giving me

below error

 

Bad Request: Invalid STRING constant (3a1ccec0-ef77-11e3-9e56-22000ae3163a)
for name of type uuid

 

aborting import at column #0, previously inserted values are still present. 

 

Below is the description of my column-family

 

CREATE TABLE standardevents (

  uuid uuid PRIMARY KEY,

  data text,

  name text,

  time text,

  tracker text,

  type text,

  userid text

) WITH

  bloom_filter_fp_chance=0.010000 AND

  caching='KEYS_ONLY' AND

  comment='' AND

  dclocal_read_repair_chance=0.000000 AND

  gc_grace_seconds=864000 AND

  read_repair_chance=0.100000 AND

  replicate_on_write='true' AND

  populate_io_cache_on_flush='false' AND

  compaction={'class': 'SizeTieredCompactionStrategy'} AND

  compression={'sstable_compression': 'SnappyCompressor'};

  

2) Facing problem of Heap is 0.8116662666877581 full

 

checked the logs getting below messages

 

GCInspector.java (line 142) Heap is 0.8116662666877581 full.  You may need
to reduce memtable and/or cache sizes.  Cassandra will now flush up to the
two largest memtables to free up memory.  Adjust flush_largest_memtables_at
threshold in cassandra.yaml if you don't want Cassandra to do this
automatically

StorageService.java (line 3512) Unable to reduce heap usage since there are
no dirty column families

 

i checked the cassandra-en.sh file currently it is occuping 

 

MAX_HEAP_SIZE="4G"

HEAP_NEWSIZE="800M" which i guess is maximum.

 

because of this constanly getting heap size error on every command.

 


Mime
View raw message