diff options
| author | Jose M. Guisado <jguisado@soleta.eu> | 2021-05-10 10:48:19 +0200 |
|---|---|---|
| committer | OpenGnSys Support Team <soporte-og@soleta.eu> | 2021-05-10 13:28:03 +0200 |
| commit | d9397d8a4a477772c10e6f4abc844ca329d2b6c1 (patch) | |
| tree | 0315509df057b1b6b1b617fd1073aee5c6836a33 | |
| parent | 28b2541a02b30d04df19eb40bc058401d33f7469 (diff) | |
#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.
| -rw-r--r-- | server/etc/mysqld-og.cnf | 1 |
1 files changed, 1 insertions, 0 deletions
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 |