We are getting the below exception sometimes while inserting loads of data into Cassandra
Exception occurred while reading Inventory Location java.lang.RuntimeException: com.datastax.oss.driver.api.core.NoNodeAvailableException: No node was available to execute the query","origin":"rep","source_instance":"0","source_type":"APP/PROC/WEB","timestamp":1644006755885638164}
Is there a way to find out if this is happening because we saturated all the connections to the nodes in the cluster. Where do we setup the maximum connections that a node can take.
In this case, is it recommended to setup throttling and connection pooling. If we setup throttling, is there a scenario where we may lose some inserts to the database or will the requests be queued and later executed once the load comes down