Thanks On Thu, Aug 24, 2017 at 6:23 PM, Michael Burman <mibur...@redhat.com> wrote:
> Hi, > > You could try something like (I tried to cleanup the code from other stuff > in the gist-editor, so it might not compile directly) the following for > your scheduling: > > https://gist.github.com/burmanm/230c306f88c69c62dfe737994444fc01 > > That should prevent pool getting full, instead using the old blocking > behavior for your code. Add your own twist of backpressure handling to the > code obviously. > > - Micke > > > > On 08/23/2017 09:40 PM, Avi Levi wrote: > >> Hi , >> I need to execute large amount (millions) of select queries. but I am >> getting BusyPoolExcption how can I avoid that ? I tried to configure the >> pooling options but couldn't see that it had any impact >> Any advice ? >> |Failed to execute query SELECT * FROM my_table WHERE id = 'some_uuid' >> AND x >= 1503501104 AND y < 1503501224; com.datastax.driver.core.excep >> tions.NoHostAvailableException: All host(s) tried for query failed >> (tried: localhost/0:0:0:0:0:0:0:1:9042 >> (com.datastax.driver.core.exceptions.BusyPoolException: >> [localhost/0:0:0:0:0:0:0:1] Pool is busy (no available connection and the >> queue has reached its max size 256)))| >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > >