Could not find prepared statement with handle

[sebastian-alfers]

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]

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.

Changing the dependency can be done here and settings here.

[sebastian-alfers]

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.

[mattmilleralbertsons]

WARNING: THIS LIBRARY HAS MAJOR ISSUES AND IT LOOKS LIKE DEVELOPMENT HAS BEEN DEAD FOR OVER A YEAR.

It appears you have fallen into the lucky version of this bug where you are at least getting an error when the library mixes up the prepared statements. Our team actually experienced the very dangerous version of this bug where it mixed up the prepared statements that had the same parameters and it actually queried the wrong data!