I'm inserting JSON documents trough the ASTRA DB Document API, All the documents have the same structure but someones are bigger than others, then I'm getting:
{
"description": "Server error: org.apache.cassandra.stargate.exceptions.WriteTimeoutException: Operation timed out - received only 0 responses.",
"code": 500
}
Is there a way to increase the timeout to avoid this problem?
Thank you in advance.
The quick answer is there isn't a way to increase the timeout because in a lot of cases, the timeouts are in place as a guard rail to prevent requests from inadvertently overloading the underlying database.
Depending on how "large" your documents are, Astra DB propagates a timeout to the Stargate API by design for self-preservation. I use the word "large" a bit loosely too because there's some nuances to it.
The obvious notion for "large documents" is the size of the payload and I think most users already understand that. But there's also the idea that documents can be large when there are several layers of nested values. The maximum levels of nesting is 45 so if you are adding documents that go beyond that limit, the operation will timeout. Cheers!
The nesting is about 2 levels, is a simple large document, I'm going to upload here a sample.AAL-quarterly.json.zip
The sheer volume of elements in your document confirms why you got a write timeout exception. Cheers!
6 People are following this question.
