Description:
Similar to bug 41987
if you have about 1000 users with short passwords and the value of group_concat_max_len =
100001, the size of the data that the agent sends to the service manager it too large and
causes errors on the service manager and the events tab
How to repeat:
1- Install and start the service manager
2- Run this bash file to create 999 users with strong privileges
#!/bin/bash
i="0"
while [ $i -lt 1000 ]
do
mysql -h127.0.0.1 -P14040 -uroot -pmsandbox -e "grant all on *.* to 'shortpass$i' identified by 'co' ;"
echo "Created user user_$i"
i=$[$i+1]
done
=============================
2-a run from the mysql command client
mysql> SET global group_concat_max_len = 100001;
3- Install and start the agent
4- Schedule all the ""Security"" rules for interval 1
minute to see quick entries on the logs
5- Monitor the apache-tomcat/logs/mysql-monitor.log file and you will see a message like
" Could not execute JDBC batch update"
among others
Suggested fix:
Handle large results from the different group_concat() statements the agent runs
