Could not find prepared statement with handle
sebastian-alfers opened this issue · 2 comments
sebastian-alfers commented
I am inserting a few rows concurrently (using scala future, 100 queries) and I am getting the following ErrorToken
:
[2024-01-16 10:40:58,815] [DEBUG] [io.r2dbc.mssql.client.ReactorNettyClient] [] [] [reactor-tcp-nio-6] - [cid: 0x11] Response: ErrorToken [number=8179, state=4, infoClass=16, message='Could not find prepared statement with handle 2.", serverName='ad4bc1cf0cd2", procName='", lineNumber=16777216]
I am using 1.0.2-RELEASE
and preferCursoredExecution=false
.
sebastian-alfers commented
This is how to reproduce it:
git clone git@github.com:sebastian-alfers/akka-persistence-r2dbc.git
cd akka-persistence-r2dbc
git checkout mssql-support-2nd
docker compose -f docker/docker-compose-sqlserver.yml up -d
sbt -Dconfig.resource=application-sqlserver.conf test
It uses sbt
and scala.
sebastian-alfers commented
It seems to make a difference when the root log level and / or the io.r2dbc.mssql.QUERY
to INFO
(where it works) or DEBUG
(where it fails).
Change can be done here to trigger the error.