We upgraded portal version from 3.5 -- 5.0.CR1 and then to 5.0.2
We are unable to add API to an application
Added an new API says (xyz) to plan "Gold" and while assigning the API to an application getting this error :
ERRORS(1)
* Request failed with status code 500
Release : 5.0.2
Component : API PORTAL
mysql is running on the same vm as the portal and the /tmp partition is configured for 512 MB (default). Which is not enough to manage the mysql request.
Troubleshooting
1. Prepare to use dispatcher and portal_data container logs for monitoring the test and check errors .
docker ps , check the container id for dispatcher and portal_data
for Dispatcher container Id , copy and paste into the following command:
docker inspect <container_id> |grep -i log
from the output, copy the LogPath and you can then use it on a tail command like :
tail -f “/apps/dockermount/containers/……….json.log
2. From the portal server df -h and check /tmp , if set to 512mb and % space used.
Due error message is a mysql Errcode: 28 - No space left on device :
{"log":"[portal.log] [2022-01-06 06:16:59,652] [ERROR] [o.h.e.j.s.SqlExceptionHelper] [http-nio-8080-exec-1] [b509a13012bc787eb8b68acb0a0991dd|2c341de5ba5f1186]
[portaldev|admin|Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36|49bca728381d$94839]
Error writing file '/tmp/MYFFB3GP' (Errcode: 28 - No space left on device) \n","stream":"stdout","time":"2022-01-06T06:16:59.65299043Z"}
which means there is not enough space left on the device.
ref: https://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28
From our docs
** we recommend a partition size of 16GB for /tmp.
3. Two options : Increase the partition size or change the /tmp directory to other partition with more free space. issue is resolved.