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