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
Query packet size limit in version ^0.2.0 ? #122
Comments
Do you have a simple, reproducible test case? As far as I know nothing has changed packet size-wise. If anything, it might be that the keepalive mechanism changed somewhat. |
I've added a small repo to reproduce this. The readme should be pretty self explanatory, but let me know if you have any questions. https://github.com/wreckloose/mariasql-query-size-test You'll have to use the screenshots.sql file to add a test table to one of your databases. Modify the db config in run.js to point to your database. Usage: Only the first test case runs successfully. Note that the unsuccessful test cases die almost immediately. In other words, they don't run for a long time and then die. Thanks again for your help. |
Ok, so the problem is on the server-side and its For example, when I start up mariadb 10.1.8 with |
My app uses phantomjs to take a screenshot and then stores the resulting base64 string in mysql. This had been working fine with node-mariasql v0.1.22 running on node v0.12, but now I'm getting the following error with node-mariasql ^0.2.0 running on node v4.2.1:
mysql error, reconnecting.. -> Error: MySQL server has gone away
This seems to point to either a timeout or packet size limitation. I suspect it's a size limitation, since smaller screenshots don't trigger the problem, only larger ones. I have reviewed the breaking changes list [https://github.com/mscdex/node-mariasql/wiki/Upgrading-v0.1.x-to-v0.2.x] and appear to have accounted for all other factors.
I'd really appreciate any help with this. Thanks very much.
The text was updated successfully, but these errors were encountered: