Skip to content
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.

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

Mysql ERR: Commands out of sync; you can't run this command now #171

Open
ilie1988 opened this issue Mar 26, 2020 · 3 comments
Open

Mysql ERR: Commands out of sync; you can't run this command now #171

ilie1988 opened this issue Mar 26, 2020 · 3 comments

Comments

@ilie1988
Copy link

When it runs many threads like 30+ after a while i get this error

| # ERR: Commands out of sync; you can't run this command now | # ERR: SQLException in | ....../src/db/MySqlAccounts.cpp | ( | select | ) on line | 269 | # ERR: | Commands out of sync; you can't run this command now | # ERR: SQLException in | ....../src/db/MySqlAccounts.cpp | ( | select | ) on line | 269 | # ERR: | Commands out of sync; you can't run this command now | # ERR: SQLException in | ....../src/db/MySqlAccounts.cpp | ( | select | ) on line | 269 | # ERR: | Commands out of sync; you can't run this command now | # ERR: SQLException in ....../src/db/MySqlAccounts.cpp(select) on line 269 | # ERR: Commands out of sync; you can't run this command now | # ERR: SQLException in ....../src/db/MySqlAccounts.cpp(select) on line 269 | # ERR: Commands out of sync; you can't run this command now | # ERR: SQLException in ....../src/db/MySqlAccounts.cpp(select) on line 269 | # ERR: Commands out of sync; you can't run this command now | # ERR: SQLException in ....../src/db/MySqlAccounts.cpp(select) on line 269 | # ERR: Commands out of sync; you can't run this command now

did you get this issue?

@moneroexamples
Copy link
Owner

Haven't encountered it. Could you provide some info when it occurs? I can try to replicate it.

@ilie1988
Copy link
Author

Haven't encountered it. Could you provide some info when it occurs? I can try to replicate it.

Basicaly after to many connections the mysql select gets out of sync, i got it solved with this 2 commits

ilie1988@5a4dba9
ilie1988@3e948fc

@moneroexamples
Copy link
Owner

Thanks for the link to commits. I will have a look.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants