8000 Question: Expected m_hasMoreResults to be false · Issue #1422 · mysql-net/MySqlConnector · GitHub
[go: up one dir, main page]
Skip to content

Question: Expected m_hasMoreResults to be false #1422

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
justdoitang opened this issue Dec 19, 2023 · 2 comments
Closed

Question: Expected m_hasMoreResults to be false #1422

justdoitang opened this issue Dec 19, 2023 · 2 comments
Labels
waiting for answer Needs more information from the bug reporter

Comments

@justdoitang
Copy link

System.InvalidOperationException: Expected m_hasMoreResults to be false

at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 463

at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 57

at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 358

at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350

at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
@justdoitang
Copy link
Author

When I was using version 2.2.7, I didn't encounter this issue. However, when I upgraded to 2.3.1, the problem occasionally occurs. What could be the cause of this issue, and how should I handle it? Thank you.

@bgrainger
Copy link
Member

It's possible this could be an underlying issue that's now being exposed as a side-effect of #1277.

What's your code that's being executed when this exception is thrown? Is it possible that you're reusing the same MySqlConnection on multiple threads at the same time? This is not permitted: https://mysqlconnector.net/troubleshooting/connection-reuse/.

@bgrainger bgrainger added the waiting for answer Needs more information from the bug reporter label Jan 14, 2024
@bgrainger bgrainger closed this as not planned Won't fix, can't repro, duplicate, stale Feb 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
waiting for answer Needs more information from the bug reporter
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bgrainger @justdoitang
0