Red Hat Bugzilla – Bug 1202499
Unable to set max_allowed_packet for MySQL
Last modified: 2015-04-06 13:06:39 EDT
+++ This bug was initially created as a clone of Bug #1197825 +++ Description of problem: It is not possible to the the MySQL variable "max_allowed_packet" in /etc/my.cnf Version-Release number of selected component (if applicable): How reproducible: Install MySQL, check the mysql cartridge Steps to Reproduce: 1. Install MySQL 2. 3. Actual results: n/a Expected results: There should be an environment variable OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET Additional info: --- Additional comment from Ben Parees on 2015-03-02 15:07:01 EST --- config option added here: https://github.com/openshift/origin-server/pull/6088 --- Additional comment from openshift-github-bot on 2015-03-02 15:51:19 EST --- Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/4fc13e4797e1fb0ae5521807c8d9967ec02e51db Bug 1197825 - Unable to set max_allowed_packet for MySQL https://bugzilla.redhat.com/show_bug.cgi?id=1197825 It is not possible to the the MySQL variable "max_allowed_packet" in /etc/my.cnf --- Additional comment from Wenjing Zheng on 2015-03-02 22:21:03 EST --- Verified on devenv_5455: 1. Create an app with mysql5.5/5.1 embbed 2. rhc env set OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET=123M -a app 3. Restart app 4. SSH to app and check the value of max_allowed_packet: mysql>show variables like 'max%' ; 5. It will display the updated value as below: +----------------------------+----------------------+ | Variable_name | Value | +----------------------------+----------------------+ | max_allowed_packet | 128974848 | Instead of its original value: +----------------------------+----------------------+ | Variable_name | Value | +----------------------------+----------------------+ | max_allowed_packet | 209715200 | --- Additional comment from Jens Reimann on 2015-03-03 08:11:26 EST --- Wow, that was fast! Thanks! :) --- Additional comment from Ben Parees on 2015-03-03 08:14:06 EST --- np, however due to our production release cycle this change won't be in openshift online for about 6 weeks.
Verify this bug with openshift-origin-cartridge-mysql-1.30.1.1-1.el6op.noarch 1. Create an app with mysql5.5/5.1 embedded 2. SSH into the app and check the default configuration of value 'max_allowed_packet' mysql> show variables like 'max_allowed_packet' ; +--------------------+-----------+ | Variable_name | Value | +--------------------+-----------+ | max_allowed_packet | 209715200 | 3. rhc env set OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET=512M -a rails 4. Restart app 5. SSH to app and check the value of max_allowed_packet: mysql> show variables like 'max_allowed_packet' ; +--------------------+-----------+ | Variable_name | Value | +--------------------+-----------+ | max_allowed_packet | 536870912 |
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHBA-2015-0779.html