Bug 1197825

Summary: Unable to set max_allowed_packet for MySQL
Product: OpenShift Online Reporter: Jens Reimann <ctron>
Component: ImageAssignee: Ben Parees <bparees>
Status: CLOSED CURRENTRELEASE QA Contact: libra bugs <libra-bugs>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 2.xCC: jokerman, mmccomas, wzheng
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1202499 (view as bug list) Environment:
Last Closed: 2015-04-21 18:01:21 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1202499    

Description Jens Reimann 2015-03-02 16:56:37 UTC 
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:
Comment 1 Ben Parees 2015-03-02 20:07:01 UTC 
config option added here:
https://github.com/openshift/origin-server/pull/6088
Comment 2 openshift-github-bot 2015-03-02 20:51:19 UTC 
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
Comment 3 Wenjing Zheng 2015-03-03 03:21:03 UTC 
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            |
Comment 4 Jens Reimann 2015-03-03 13:11:26 UTC 
Wow, that was fast!

Thanks! :)
Comment 5 Ben Parees 2015-03-03 13:14:06 UTC 
np, however due to our production release cycle this change won't be in openshift online for about 6 weeks.