MySQL Forums
Forum List  »  Connector/C++

Re: CDK Error: Reply blocked by a previous one.
Posted by: Siddhant Kothari
Date: March 03, 2020 02:01PM

I am getting the same error in version 8.0.19 . (I have not tried on earlier versions)

Code:
auto res = mySession.sql("call abc.xyz();").execute(); //Line 1
int n = res.count();//Line 2
auto res2 = mySession.sql("commit;").execute();//Line 3

Only one thread running in the program.
abc.xyz is a stored procedure that starts a transaction.
I get the error at Line 3 when all 3 lines are present.
When Line 2 is removed, the error is gone.
Replacing "commit" by "rollback" does not remove the error.
Replacing procedure call with a select statement and adding "start transaction;" line before it removes the error.

Any ideas on what the problem is?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.