Issue with Portal installation

Products

• CA API Developer Portal

Issue/Introduction

We are doing installation of portal 5.0 in production environment and seeing below exceptions in docker container logs

time="2021-01-11T19:58:49.879324445Z" level=error msg="fatal task error" error="task: non-zero exit (3)" module=node/agent/taskmanager node.id=r6yyojwezq3ul3mqx8gixzlny service.id=nes3wb43wovbyzbk3472fxjb7 task.id=a6tegkls8i1sdepa72pogqmyj
time="2021-01-11T19:58:52.097723015Z" level=info msg="NetworkDB stats peplvh50678(482cec3af659) - netID:u5nrk7feivetrmov4ey9hftgz leaving:false netPeers:1 entries:58 Queue qLen:0 netMsg/s:0"
time="2021-01-11T19:58:52.097796816Z" level=info msg="NetworkDB stats peplvh50678(482cec3af659) - netID:bk2dz5z9rvf2bbiv1t0wwddul leaving:false netPeers:1 entries:2 Queue qLen:0 netMsg/s:0"
time="2021-01-11T19:58:52.854678534Z" level=warning msg="Error (Unable to complete atomic operation, key modified) deleting object [endpoint u5nrk7feivetrmov4ey9hftgz d8987bfc1fa724e51baccd76c3ae6b5aa91a3be59bcafae46e63654c9d7edab8], retrying...."
time="2021-01-11T19:58:55.083863086Z" level=error msg="f504ab784672a36473b38d5b3ca424327772b286ea5f7a838a20ddb43c3e5a37 cleanup: failed to delete container from containerd: no such container"
time="2021-01-11T19:59:02.652015956Z" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
time="2021-01-11T19:59:03.593217396Z" level=error msg="fatal task error" error="task: non-zero exit (3)" module=node/agent/taskmanager node.id=r6yyojwezq3ul3mqx8gixzlny service.id=nes3wb43wovbyzbk3472fxjb7 task.id=c3ud7rf9snnxkkhgpbqnn3lfx
time="2021-01-11T19:59:06.580720490Z" level=warning msg="Error (Unable to complete atomic operation, key modified) deleting object [endpoint u5nrk7feivetrmov4ey9hftgz ff6f4134bbb6389ca05534509129bdd2d597df9057daf872f04908d736f2590a], retrying...."
time="2021-01-11T19:59:08.804900958Z" level=error msg="4cd5c0ae73112b4b200c51f87df68ea18f7489e648e784637d5ae819b57281bd cleanup: failed to delete container from containerd: no such container"
time="2021-01-11T19:59:16.552341264Z" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
time="2021-01-11T19:59:17.437266551Z" level=error msg="fatal task error" error="task: non-zero exit (3)" module=node/agent/taskmanager node.id=r6yyojwezq3ul3mqx8gixzlny service.id=nes3wb43wovbyzbk3472fxjb7 task.id=otjxhne1t1d9outmquzb0xz2n
time="2021-01-11T19:59:20.390854271Z" level=warning msg="Error (Unable to complete atomic operation, key modified) deleting object [endpoint u5nrk7feivetrmov4ey9hftgz 8c353863a91ce7a12afb050fdfd571847683be654840a8bed56ccea90acc9052], retrying...."
time="2021-01-11T19:59:22.596584126Z" level=error msg="c70d4fa91adf1aa84237861c44ed755922b016fe05783d17e12b4af641f9a5c0 cleanup: failed to delete container from containerd: no such container"
time="2021-01-11T19:59:30.576366067Z" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
time="2021-01-11T19:59:31.449320251Z" level=error msg="fatal task error" error="task: non-zero exit (3)" module=node/agent/taskmanager node.id=r6yyojwezq3ul3mqx8gixzlny service.id=nes3wb43wovbyzbk3472fxjb7 task.id=kgf64shgms07rz4m7nhdpjco6
time="2021-01-11T19:59:34.466119341Z" level=warning msg="Error (Unable to complete atomic operation, key modified) deleting object [endpoint u5nrk7feivetrmov4ey9hftgz 790e4ec41aa5c63bc950af081c9626eca9613a53d889bb4a8848d43e004e39c6], retrying...."
time="2021-01-11T19:59:36.679934033Z" level=error msg="97fba80ed8640edf1f925329465dac5e938dbc0cc16b295a56e6d30b715a3a8e cleanup: failed to delete container from containerd: no such container"

 

Environment

Release : 5.0

Component : API PORTAL

Cause

mysql in Azsure not configured properly 

 

Resolution

External DB for portal - yes
Portal in mysql deployed in Azure

Needed to update mysql parameters in Azure mysql

log_bin_trust_function_creators = ON
character-set-server=utf8
innodb_log_buffer_size=32M
innodb_log_file_size=80M
max_allowed_packet=8M
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Portal loaded as expected after making these changes