Docker Community Forums

Share and learn in the Docker community.

MySql container isn't picking up modified max_allowed_packet value from custom my.conf file


(Ramizrshaik) #1

Hi

I am using MySQL:5.7 image for my sonarqube db. recently upgraded sonarqube version from 6.4 to 7.0 version. After that MySQL db global variable ‘max_allowed_packet’ isnt picking up my new change. Any thoughts on this?

my compose file:

sonarqube-db:
image: mysql:5.7
networks:
- front
ports:
- “3306”
environment:
- MYSQL_ROOT_PASSWORD=********
- MYSQL_DATABASE=********
- MYSQL_USER=*****
- MYSQL_PASSWORD=******
- constraint:node-type==**********
labels:
- maintainer=****************
volumes:
- sonarqube-mysql-data:/var/lib/mysql
- sonarqube-mysql-data-conf:/etc/mysql/conf.d (created my.conf file here)
mem_limit: 900m
restart: always

while i am using sonarqube version 6.4 I got this exception ‘package was too large’. From that time I used this custom my.conf file to increase the packet size. After the sonarqube upgrade it started failing again. I tried to change this value from MySql workbench but i am getting an error saying ‘I dont have super access to update the global variable’

#mysql #sonarqube


(Ramizrshaik) #2

Nevermind, this is resolved