Red Hat Bugzilla – Bug 1292445
Error: Out of sort memory, consider increasing server sort buffer size
Last modified: 2017-05-31 14:22:11 EDT
OpenShift it's great product! I love it! But I can't use new SilverStripe application version I'm getting "Error: Out of sort memory, consider increasing server sort buffer size".
I suggest to increase the buffer size of mysql: in the my.cnf, sort_buffer_size to 256K.
To allow editing those settings I think best solution is to add new parameter like others ENV parameters. Example: max_allowed_packet = <%= ENV['OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET'] ? ENV['OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET'] : '200M' %>
Also found old bug report at: https://bugzilla.redhat.com/show_bug.cgi?id=1000167
Maybe you can solve this issue and help me and others who are using OpenShift and SilverStripe.
I have a PR currently in review to be merged to increase the sort buffer size and allow user to change the size via env variable as well. Stay tuned :D.
Thanks for reporting this issue to us.
Commit pushed to master at https://github.com/openshift/origin-server
Bug 1292445: Out of memory error due to insufficient mysql sort buffer size
The new SilverStripe CMS app using php and mysql cartridges fails due to out
of memory on mysql sort buffer which is currently set at 128K.
This commit increases the sort buffer size to 256K and also add the environment
variable OPENSHIFT_MYSQL_SORT_BUFFER_SIZE to allow user to modify the mysql sort
buffer size at their own choices without having modify the my.cnf directly.
Signed-off-by: Vu Dinh <email@example.com>
Verified in devenv_5778, in mysql/conf/my.cnf, sort_buffer_size is 256K now; and it also can be changed like this rhc env-set OPENSHIFT_MYSQL_SORT_BUFFER_SIZE=128K.
We apologize, however, we do not plan to address this report at this time. The majority of our active development is for the v3 version of OpenShift. If you would like for Red Hat to reconsider this decision, please reach out to your support representative. We are very sorry for any inconvenience this may cause.