I'm writing an Akka streams app using Slick 3, and getting the following error.
org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
I believe I have dialed down the parallelism to what should be manageable. I have also
added transactionally, a fetchSize, and query timeout:
filteredChannels.result.transactionally
.withStatementParameters(fetchSize = size, statementInit = st => st.setQueryTimeout(100))
The query timeout was a reaction to this
http://stackoverflow.com/questions/13114101/postgresql-error-canceling-statement-due-to-user-request
I do have two types of queries going on, one for channels, and one for intervals for a channel (using the akka streams flatMapConcat operator.
Has anyone else run into something similar?