It actually happens even after running the query immediately after inserting the data.
It's just that I need to have a way to get the data by chunks rather than the whole thing at once which causes the Out of memory issue. On Tue, Sep 1, 2015 at 9:31 AM, Hemika Kodikara <[email protected]> wrote: > Hi Sachith, > > Could you try running the same query in a 2.x version and see what error > is occurring ? As far as I know, it could be a tombstone issue, 1.x > versions doesnt show it. If it gives an error of tombstone overwhelming in > 2.x, then its the case what Madhawa has explained. > > You manually can get rid of tombstones using nodetool by running flush > command and then compaction. > > Regards, > Hemika > > Hemika Kodikara > Software Engineer > WSO2 Inc. > lean . enterprise . middleware > http://wso2.com > > Mobile : +94777688882 > > On Tue, Sep 1, 2015 at 9:26 AM, Madhawa Gunasekara <[email protected]> > wrote: > >> Hi Sachith, >> >> I'm not sure about this is the correct answer, but you can configure >> gc_grace_seconds. It will help you to skip the OOM exception. >> [1] http://docs.datastax.com/en/cql/3.0/cql/cql_reference/tabProp.html >> >> Thanks, >> Madhawa >> >> On Mon, Aug 31, 2015 at 8:36 AM, Sachith Withana <[email protected]> >> wrote: >> >>> Hi all, >>> >>> I need to read a whole column family from a previous version of >>> Cassandra (1.x). It works for a small result set ( for a CQL select * >>> query). But for a larger dataset ( around 1 million records) it throws an >>> out of memory exception (GC). >>> >>> Are there any mechanisms like paging for Cassandra 1.x? Or any other >>> workaround for this issue? >>> >>> I observed that paging is supported from Cassandra 2.0 and above but not >>> in the previous versions. >>> >>> >>> Thanks. >>> -- >>> Sachith Withana >>> Software Engineer; WSO2 Inc.; http://wso2.com >>> E-mail: sachith AT wso2.com >>> M: +94715518127 >>> Linked-In: <http://goog_416592669> >>> https://lk.linkedin.com/in/sachithwithana >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> *Madhawa Gunasekara* >> Software Engineer >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> mobile: +94 719411002 <+94+719411002> >> blog: *http://madhawa-gunasekara.blogspot.com >> <http://madhawa-gunasekara.blogspot.com>* >> linkedin: *http://lk.linkedin.com/in/mgunasekara >> <http://lk.linkedin.com/in/mgunasekara>* >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > -- Sachith Withana Software Engineer; WSO2 Inc.; http://wso2.com E-mail: sachith AT wso2.com M: +94715518127 Linked-In: <http://goog_416592669>https://lk.linkedin.com/in/sachithwithana
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
