openmonero
openmonero copied to clipboard
Mysql ERR: Commands out of sync; you can't run this command now
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?
Haven't encountered it. Could you provide some info when it occurs? I can try to replicate it.
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
https://github.com/ilie1988/bittube-light-wallet/commit/5a4dba937813072f950915c4ad5bed53df20a69a https://github.com/ilie1988/bittube-light-wallet/commit/3e948fc0b6222729e0c28abd24a04d530dfef860
Thanks for the link to commits. I will have a look.