[SAL/Proactive] Can't define a cluster with many env variables

[Robert Sanfeliu]

When trying to define this cluster:

{
    "name": "17024-1",
    "master-node": "m17024-1-master",
    "nodes": [
        {
            "nodeName": "m17024-1-master",
            "nodeCandidateId": "8a74849d8f9af332018f9ba225100010",
            "cloudId": "aws-eurecat5"
        },
        {
            "nodeName": "n17024-1-dummy-app-worker-1-1",
            "nodeCandidateId": "8a74849d8f9af332018f9ba343840482",
            "cloudId": "aws-eurecat5"
        }
    ],
    "env-var": {
        "APPLICATION_ID": "1702402105automated-testing-mqtt-app-1716303760180",
        "BROKER_ADDRESS": "localhost",
        "ACTIVEMQ_HOST": "localhost",
        "BROKER_PORT": 5672,
        "ACTIVEMQ_PORT": 5672,
        "this_is_a_var": "23",
        "this_is_another": "hhh"
    }
}

SAL proactive complains about:

    <p><b>Root Cause</b></p>
    <pre>java.sql.SQLSyntaxErrorException: (conn=19) Data too long for column &#39;ENV&#39; at row 1
 org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
 org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:155)

If I remove all the env-vars but keep only

"APPLICATION_ID": "1702402105automated-testing-mqtt-app-1716303760180"

It works

This was tested in nebulous-cd environment using Postman.

[Ankica Barisic (akki55)]

You are right, I also get errors if trying to send more than 2 env vars.
How urgent is this?

Take care to send all the int values as string:
        "BROKER_PORT": "5672",
        "ACTIVEMQ_PORT": "5672",

[Ankica Barisic (akki55)]

activeeon/sal:dev-2024-05-22