Call of stored procedures gives Commands out of sync error

[vanhry]

Hello everyone!
I have a lot of stored procedures call in my code. Now I am going to switch to pool library instead of regular DBI calls.
And I faced with the problem. The first run of code below works fine, but the second one gives me an error.

Error: Commands out of sync; you can't run this command now [2014]

My code that executes several times

query <- sqlInterpolate(con, "CALL GetInfo(?);", user)
df_result <- dbGetQuery(con, query)

Code with poolCheckout and poolReturn gives me the same error after first successful call

con_pool <- poolCheckout(con)
query <- sqlInterpolate(con_pool, "CALL GetInfo(?);", user)
df_result <- dbGetQuery(con_pool, query)
poolReturn(con_pool)

global initialization of pool in global.R:

con <- dbPool(drv=RMariaDB::MariaDB,
                        ...)
onStop(function() {
  poolClose(con)
})

I will appreciate any help from your side!

[vanhry]

I found the solution only for RMySQL (which deprecated and I don't want to use it) solution link

Here you can find similar issue in RMariaDB, and actually, I guess my problem more related to RMariaDB package
RMariaDB issue

[vanhry]

Reproducible example here

[jcheng5]

Yeah, this seems not solvable from pool. I made a comment on the RMariaDB issue.