ERROR: canceling statement due to user request

590 views
Skip to first unread message

Richard Rodseth

unread,
Feb 10, 2016, 11:48:04 PM2/10/16
to scala...@googlegroups.com

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 = sizestatementInit = 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?

Reply all
Reply to author
Forward
0 new messages