Trying to install the RemoteCacheAssertion-1.5.0.saar file via policy manager fails with the following error:
Error while uploading Server Module:
Could not deserialize result from HTTP invoker remote service [https://securespangateway/ssg/manager/ClusterStatusAdmin]; nested exception is java.lang.classnotfoundexception: com.mysql.cj.jdbc.exceptions.packettoobigexception
We had already updated the following cluster wide property to 50 MB but the problem persists:
serverModuleFile.upload.maxSize = 52428800
CA API Gateway 10.1
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection.
We updated the following setting within the /etc/my.cnf file accordingly:
max_allowed_packet=100M
We then restarted mysql and attempted to upload the RemoteCacheAssertionxxx.saar file again and it was now successful.
We then reverted the change and set the max_allowed_packet value back to it's original value and restarted mysql once again so the original value would take place once again.