Cassandra stops during large inserts

Question

I am inserting data in cassandra from a csv file using java driver.But after some inserts it throws NoHostAvailableException:java 65 :All host(s) tried for query failed (no host was tried). I am having cassandra on client machine (singlenode).Cassandra services are still running on client machine. Thanks in advance.I am a newbie.

@user3819405 Anything interesting from the server-side cassandra logs? Also how much memory have you given Cassandra / your app that is carrying out the inserts. — Lyuben Todorov, Oct 02 '14 at 01:13
Do you execute one statement per row to insert, or use batch statements? — Olivier Michallat, Oct 02 '14 at 09:53
@OlivierMichallat Yes I also tried creating batch statement.But the result is same. — user3819405, Oct 15 '14 at 05:59

score 0 · Answer 1 · answered Nov 05 '14 at 22:44

0

Here's some best practices for bulk ingestions using the java driver:

http://lostechies.com/ryansvihla/2014/08/28/cassandra-batch-loading-without-the-batch-keyword/

answered Nov 05 '14 at 22:44

phact

7,305
23
27

score 0 · Answer 2 · edited Nov 07 '14 at 06:13

0

I got this problem solved by using executeasync method present in the java driver.

edited Nov 07 '14 at 06:13

Russia Must Remove Putin

374,368
89
403
331

answered Nov 07 '14 at 05:56

user3819405

35
7

Could you elaborate on that? – Russia Must Remove Putin Nov 07 '14 at 06:14

Cassandra stops during large inserts

2 Answers2