From d9397d8a4a477772c10e6f4abc844ca329d2b6c1 Mon Sep 17 00:00:00 2001 From: "Jose M. Guisado" Date: Mon, 10 May 2021 10:48:19 +0200 Subject: #1045 Fix duplicate software profiles bug Sometimes a software profile creation does not fail although there is already an existing one with the same components. After some investigation, the reason seems to be that legacy code from ogAdmServer (deprecated) executes a SQL query using GROUP_CONCAT grouping all software components id in increasing order but this concatenated string ends up being truncated due to a maximul length variable in MySQL server. This variable is: "group_concat_max_len" and its default value is 1024. Fix this by increasing group_concat max length in MySQL. --- server/etc/mysqld-og.cnf | 1 + 1 file changed, 1 insertion(+) diff --git a/server/etc/mysqld-og.cnf b/server/etc/mysqld-og.cnf index 36641c65..356fc8c1 100644 --- a/server/etc/mysqld-og.cnf +++ b/server/etc/mysqld-og.cnf @@ -2,3 +2,4 @@ event_scheduler = ON character-set-server=utf8 collation-server=utf8_general_ci +group_concat_max_len = 8192 -- cgit v1.2.3-18-g5258