Started by upstream project "policy-drools-pdp-master-merge-java" build number 510 originally caused by: Triggered by Gerrit: https://gerrit.onap.org/r/c/policy/drools-pdp/+/136806 Running as SYSTEM [EnvInject] - Loading node environment variables. Building remotely on prd-ubuntu1804-docker-8c-8g-4308 (ubuntu1804-docker-8c-8g) in workspace /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp [ssh-agent] Looking for ssh-agent implementation... [ssh-agent] Exec ssh-agent (binary ssh-agent on a remote machine) $ ssh-agent SSH_AUTH_SOCK=/tmp/ssh-e6I6fDWy7X8h/agent.2099 SSH_AGENT_PID=2101 [ssh-agent] Started. Running ssh-add (command line suppressed) Identity added: /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp@tmp/private_key_13561417001977800715.key (/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp@tmp/private_key_13561417001977800715.key) [ssh-agent] Using credentials onap-jobbuiler (Gerrit user) The recommended git tool is: NONE using credential onap-jenkins-ssh Wiping out workspace first. Cloning the remote Git repository Cloning repository git://cloud.onap.org/mirror/policy/docker.git > git init /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp # timeout=10 Fetching upstream changes from git://cloud.onap.org/mirror/policy/docker.git > git --version # timeout=10 > git --version # 'git version 2.17.1' using GIT_SSH to set credentials Gerrit user Verifying host key using manually-configured host key entries > git fetch --tags --progress -- git://cloud.onap.org/mirror/policy/docker.git +refs/heads/*:refs/remotes/origin/* # timeout=30 > git config remote.origin.url git://cloud.onap.org/mirror/policy/docker.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 Avoid second fetch > git rev-parse refs/remotes/origin/master^{commit} # timeout=10 Checking out Revision b688e1ed0c5780b8c4239ed72827913d48383137 (refs/remotes/origin/master) > git config core.sparsecheckout # timeout=10 > git checkout -f b688e1ed0c5780b8c4239ed72827913d48383137 # timeout=30 Commit message: "Update snapshot and/or references of policy/docker to latest snapshots" > git rev-list --no-walk b688e1ed0c5780b8c4239ed72827913d48383137 # timeout=10 provisioning config files... copy managed file [npmrc] to file:/home/jenkins/.npmrc copy managed file [pipconf] to file:/home/jenkins/.config/pip/pip.conf [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins13904696802950106268.sh ---> python-tools-install.sh Setup pyenv: * system (set by /opt/pyenv/version) * 3.8.13 (set by /opt/pyenv/version) * 3.9.13 (set by /opt/pyenv/version) * 3.10.6 (set by /opt/pyenv/version) lf-activate-venv(): INFO: Creating python3 venv at /tmp/venv-04rM lf-activate-venv(): INFO: Save venv in file: /tmp/.os_lf_venv lf-activate-venv(): INFO: Installing: lftools lf-activate-venv(): INFO: Adding /tmp/venv-04rM/bin to PATH Generating Requirements File Python 3.10.6 pip 23.3.1 from /tmp/venv-04rM/lib/python3.10/site-packages/pip (python 3.10) appdirs==1.4.4 argcomplete==3.2.1 aspy.yaml==1.3.0 attrs==23.1.0 autopage==0.5.2 Babel==2.13.1 beautifulsoup4==4.12.2 boto3==1.33.11 botocore==1.33.11 bs4==0.0.1 cachetools==5.3.2 certifi==2023.11.17 cffi==1.16.0 cfgv==3.4.0 chardet==5.2.0 charset-normalizer==3.3.2 click==8.1.7 cliff==4.4.0 cmd2==2.4.3 cryptography==3.3.2 debtcollector==2.5.0 decorator==5.1.1 defusedxml==0.7.1 Deprecated==1.2.14 distlib==0.3.7 dnspython==2.4.2 docker==4.2.2 dogpile.cache==1.2.2 email-validator==2.1.0.post1 filelock==3.13.1 future==0.18.3 gitdb==4.0.11 GitPython==3.1.40 google-auth==2.25.2 httplib2==0.22.0 identify==2.5.33 idna==3.6 importlib-metadata==7.0.0 importlib-resources==1.5.0 iso8601==2.1.0 Jinja2==3.1.2 jmespath==1.0.1 jsonpatch==1.33 jsonpointer==2.4 jsonschema==4.20.0 jsonschema-specifications==2023.11.2 keystoneauth1==5.4.0 kubernetes==28.1.0 lftools==0.37.8 lxml==4.9.3 MarkupSafe==2.1.3 msgpack==1.0.7 multi-key-dict==2.0.3 munch==4.0.0 netaddr==0.9.0 netifaces==0.11.0 niet==1.4.2 nodeenv==1.8.0 oauth2client==4.1.3 oauthlib==3.2.2 openstacksdk==0.62.0 os-client-config==2.1.0 os-service-types==1.7.0 osc-lib==2.9.0 oslo.config==9.2.0 oslo.context==5.3.0 oslo.i18n==6.2.0 oslo.log==5.4.0 oslo.serialization==5.2.0 oslo.utils==6.3.0 packaging==23.2 pbr==6.0.0 platformdirs==4.1.0 prettytable==3.9.0 pyasn1==0.5.1 pyasn1-modules==0.3.0 pycparser==2.21 pygerrit2==2.0.15 PyGithub==2.1.1 pyinotify==0.9.6 PyJWT==2.8.0 PyNaCl==1.5.0 pyparsing==2.4.7 pyperclip==1.8.2 pyrsistent==0.20.0 python-cinderclient==9.4.0 python-dateutil==2.8.2 python-heatclient==3.3.0 python-jenkins==1.8.2 python-keystoneclient==5.2.0 python-magnumclient==4.3.0 python-novaclient==18.4.0 python-openstackclient==6.0.0 python-swiftclient==4.4.0 pytz==2023.3.post1 PyYAML==6.0.1 referencing==0.32.0 requests==2.31.0 requests-oauthlib==1.3.1 requestsexceptions==1.4.0 rfc3986==2.0.0 rpds-py==0.13.2 rsa==4.9 ruamel.yaml==0.18.5 ruamel.yaml.clib==0.2.8 s3transfer==0.8.2 simplejson==3.19.2 six==1.16.0 smmap==5.0.1 soupsieve==2.5 stevedore==5.1.0 tabulate==0.9.0 toml==0.10.2 tomlkit==0.12.3 tqdm==4.66.1 typing_extensions==4.9.0 tzdata==2023.3 urllib3==1.26.18 virtualenv==20.25.0 wcwidth==0.2.12 websocket-client==1.7.0 wrapt==1.16.0 xdg==6.0.0 xmltodict==0.13.0 yq==3.2.3 zipp==3.17.0 [EnvInject] - Injecting environment variables from a build step. [EnvInject] - Injecting as environment variables the properties content SET_JDK_VERSION=openjdk17 GIT_URL="git://cloud.onap.org/mirror" [EnvInject] - Variables injected successfully. [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/sh /tmp/jenkins1772171538460769543.sh ---> update-java-alternatives.sh ---> Updating Java version ---> Ubuntu/Debian system detected update-alternatives: using /usr/lib/jvm/java-17-openjdk-amd64/bin/java to provide /usr/bin/java (java) in manual mode update-alternatives: using /usr/lib/jvm/java-17-openjdk-amd64/bin/javac to provide /usr/bin/javac (javac) in manual mode update-alternatives: using /usr/lib/jvm/java-17-openjdk-amd64 to provide /usr/lib/jvm/java-openjdk (java_sdk_openjdk) in manual mode openjdk version "17.0.4" 2022-07-19 OpenJDK Runtime Environment (build 17.0.4+8-Ubuntu-118.04) OpenJDK 64-Bit Server VM (build 17.0.4+8-Ubuntu-118.04, mixed mode, sharing) JAVA_HOME=/usr/lib/jvm/java-17-openjdk-amd64 [EnvInject] - Injecting environment variables from a build step. [EnvInject] - Injecting as environment variables the properties file path '/tmp/java.env' [EnvInject] - Variables injected successfully. [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/sh -xe /tmp/jenkins8755093519324919411.sh + /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/run-project-csit.sh drools-pdp + set +u + save_set + RUN_CSIT_SAVE_SET=ehxB + RUN_CSIT_SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:pipefail:xtrace + '[' 1 -eq 0 ']' + '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ']' + export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin + PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin + export SCRIPTS=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts + SCRIPTS=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts + export ROBOT_VARIABLES= + ROBOT_VARIABLES= + export PROJECT=drools-pdp + PROJECT=drools-pdp + cd /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp + rm -rf /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/archives/drools-pdp + mkdir -p /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/archives/drools-pdp + source_safely /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/prepare-robot-env.sh + '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/prepare-robot-env.sh ']' + relax_set + set +e + set +o pipefail + . /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/prepare-robot-env.sh ++ '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ']' +++ mktemp -d ++ ROBOT_VENV=/tmp/tmp.vYZV0IIhh7 ++ echo ROBOT_VENV=/tmp/tmp.vYZV0IIhh7 +++ python3 --version ++ echo 'Python version is: Python 3.6.9' Python version is: Python 3.6.9 ++ python3 -m venv --clear /tmp/tmp.vYZV0IIhh7 ++ source /tmp/tmp.vYZV0IIhh7/bin/activate +++ deactivate nondestructive +++ '[' -n '' ']' +++ '[' -n '' ']' +++ '[' -n /bin/bash -o -n '' ']' +++ hash -r +++ '[' -n '' ']' +++ unset VIRTUAL_ENV +++ '[' '!' nondestructive = nondestructive ']' +++ VIRTUAL_ENV=/tmp/tmp.vYZV0IIhh7 +++ export VIRTUAL_ENV +++ _OLD_VIRTUAL_PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin +++ PATH=/tmp/tmp.vYZV0IIhh7/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin +++ export PATH +++ '[' -n '' ']' +++ '[' -z '' ']' +++ _OLD_VIRTUAL_PS1= +++ '[' 'x(tmp.vYZV0IIhh7) ' '!=' x ']' +++ PS1='(tmp.vYZV0IIhh7) ' +++ export PS1 +++ '[' -n /bin/bash -o -n '' ']' +++ hash -r ++ set -exu ++ python3 -m pip install -qq --upgrade 'pip<=23.0' 'setuptools<=66.1.1' ++ echo 'Installing Python Requirements' Installing Python Requirements ++ python3 -m pip install -qq -r /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/pylibs.txt ++ python3 -m pip -qq freeze bcrypt==4.0.1 beautifulsoup4==4.12.2 bitarray==2.8.5 certifi==2023.11.17 cffi==1.15.1 charset-normalizer==2.0.12 cryptography==40.0.2 decorator==5.1.1 elasticsearch==7.17.9 elasticsearch-dsl==7.4.1 enum34==1.1.10 idna==3.6 importlib-resources==5.4.0 ipaddr==2.2.0 isodate==0.6.1 jmespath==0.10.0 jsonpatch==1.32 jsonpath-rw==1.4.0 jsonpointer==2.3 lxml==4.9.3 netaddr==0.8.0 netifaces==0.11.0 odltools==0.1.28 paramiko==3.3.1 pkg_resources==0.0.0 ply==3.11 pyang==2.6.0 pyangbind==0.8.1 pycparser==2.21 pyhocon==0.3.60 PyNaCl==1.5.0 pyparsing==3.1.1 python-dateutil==2.8.2 regex==2023.8.8 requests==2.27.1 robotframework==6.1.1 robotframework-httplibrary==0.4.2 robotframework-pythonlibcore==3.0.0 robotframework-requests==0.9.4 robotframework-selenium2library==3.0.0 robotframework-seleniumlibrary==5.1.3 robotframework-sshlibrary==3.8.0 scapy==2.5.0 scp==0.14.5 selenium==3.141.0 six==1.16.0 soupsieve==2.3.2.post1 urllib3==1.26.18 waitress==2.0.0 WebOb==1.8.7 WebTest==3.0.0 zipp==3.6.0 ++ mkdir -p /tmp/tmp.vYZV0IIhh7/src/onap ++ rm -rf /tmp/tmp.vYZV0IIhh7/src/onap/testsuite ++ python3 -m pip install -qq --upgrade --extra-index-url=https://nexus3.onap.org/repository/PyPi.staging/simple 'robotframework-onap==0.6.0.*' --pre ++ echo 'Uninstall docker-py and reinstall docker.' Uninstall docker-py and reinstall docker. ++ python3 -m pip uninstall -y -qq docker ++ python3 -m pip install -U -qq docker ++ python3 -m pip -qq freeze bcrypt==4.0.1 beautifulsoup4==4.12.2 bitarray==2.8.5 certifi==2023.11.17 cffi==1.15.1 charset-normalizer==2.0.12 cryptography==40.0.2 decorator==5.1.1 deepdiff==5.7.0 dnspython==2.2.1 docker==5.0.3 elasticsearch==7.17.9 elasticsearch-dsl==7.4.1 enum34==1.1.10 future==0.18.3 idna==3.6 importlib-resources==5.4.0 ipaddr==2.2.0 isodate==0.6.1 Jinja2==3.0.3 jmespath==0.10.0 jsonpatch==1.32 jsonpath-rw==1.4.0 jsonpointer==2.3 kafka-python==2.0.2 lxml==4.9.3 MarkupSafe==2.0.1 more-itertools==5.0.0 netaddr==0.8.0 netifaces==0.11.0 odltools==0.1.28 ordered-set==4.0.2 paramiko==3.3.1 pbr==6.0.0 pkg_resources==0.0.0 ply==3.11 protobuf==3.19.6 pyang==2.6.0 pyangbind==0.8.1 pycparser==2.21 pyhocon==0.3.60 PyNaCl==1.5.0 pyparsing==3.1.1 python-dateutil==2.8.2 PyYAML==6.0.1 regex==2023.8.8 requests==2.27.1 robotframework==6.1.1 robotframework-httplibrary==0.4.2 robotframework-onap==0.6.0.dev105 robotframework-pythonlibcore==3.0.0 robotframework-requests==0.9.4 robotframework-selenium2library==3.0.0 robotframework-seleniumlibrary==5.1.3 robotframework-sshlibrary==3.8.0 robotlibcore-temp==1.0.2 scapy==2.5.0 scp==0.14.5 selenium==3.141.0 six==1.16.0 soupsieve==2.3.2.post1 urllib3==1.26.18 waitress==2.0.0 WebOb==1.8.7 websocket-client==1.3.1 WebTest==3.0.0 zipp==3.6.0 ++ uname ++ grep -q Linux ++ sudo apt-get -y -qq install libxml2-utils + load_set + _setopts=ehuxB ++ echo braceexpand:hashall:interactive-comments:nounset:xtrace ++ tr : ' ' + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o braceexpand + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o hashall + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o interactive-comments + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o nounset + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o xtrace ++ echo ehuxB ++ sed 's/./& /g' + for i in $(echo "$_setopts" | sed 's/./& /g') + set +e + for i in $(echo "$_setopts" | sed 's/./& /g') + set +h + for i in $(echo "$_setopts" | sed 's/./& /g') + set +u + for i in $(echo "$_setopts" | sed 's/./& /g') + set +x + source_safely /tmp/tmp.vYZV0IIhh7/bin/activate + '[' -z /tmp/tmp.vYZV0IIhh7/bin/activate ']' + relax_set + set +e + set +o pipefail + . /tmp/tmp.vYZV0IIhh7/bin/activate ++ deactivate nondestructive ++ '[' -n /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin ']' ++ PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin ++ export PATH ++ unset _OLD_VIRTUAL_PATH ++ '[' -n '' ']' ++ '[' -n /bin/bash -o -n '' ']' ++ hash -r ++ '[' -n '' ']' ++ unset VIRTUAL_ENV ++ '[' '!' nondestructive = nondestructive ']' ++ VIRTUAL_ENV=/tmp/tmp.vYZV0IIhh7 ++ export VIRTUAL_ENV ++ _OLD_VIRTUAL_PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin ++ PATH=/tmp/tmp.vYZV0IIhh7/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/scripts:/bin ++ export PATH ++ '[' -n '' ']' ++ '[' -z '' ']' ++ _OLD_VIRTUAL_PS1='(tmp.vYZV0IIhh7) ' ++ '[' 'x(tmp.vYZV0IIhh7) ' '!=' x ']' ++ PS1='(tmp.vYZV0IIhh7) (tmp.vYZV0IIhh7) ' ++ export PS1 ++ '[' -n /bin/bash -o -n '' ']' ++ hash -r + load_set + _setopts=hxB ++ echo braceexpand:hashall:interactive-comments:xtrace ++ tr : ' ' + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o braceexpand + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o hashall + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o interactive-comments + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o xtrace ++ echo hxB ++ sed 's/./& /g' + for i in $(echo "$_setopts" | sed 's/./& /g') + set +h + for i in $(echo "$_setopts" | sed 's/./& /g') + set +x + export TEST_PLAN_DIR=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests + TEST_PLAN_DIR=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests + export TEST_OPTIONS= + TEST_OPTIONS= ++ mktemp -d + WORKDIR=/tmp/tmp.7B5x1vYVT6 + cd /tmp/tmp.7B5x1vYVT6 + docker login -u docker -p docker nexus3.onap.org:10001 WARNING! Using --password via the CLI is insecure. Use --password-stdin. WARNING! Your password will be stored unencrypted in /home/jenkins/.docker/config.json. Configure a credential helper to remove this warning. See https://docs.docker.com/engine/reference/commandline/login/#credentials-store Login Succeeded + SETUP=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh + '[' -f /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh ']' + echo 'Running setup script /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh' Running setup script /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh + source_safely /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh + '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh ']' + relax_set + set +e + set +o pipefail + . /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/setup-drools-pdp.sh ++ source /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose/start-compose.sh drools-pdp +++ '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ']' +++ COMPOSE_FOLDER=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose +++ grafana=false +++ gui=false +++ [[ 1 -gt 0 ]] +++ key=drools-pdp +++ case $key in +++ echo drools-pdp drools-pdp +++ component=drools-pdp +++ shift +++ [[ 0 -gt 0 ]] +++ cd /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose +++ echo 'Configuring docker compose...' Configuring docker compose... +++ source export-ports.sh +++ source get-versions.sh +++ '[' -z drools-pdp ']' +++ '[' -n drools-pdp ']' +++ '[' drools-pdp == logs ']' +++ '[' false = true ']' +++ '[' false = true ']' +++ echo 'Starting drools-pdp application' Starting drools-pdp application +++ docker-compose up -d drools-pdp Creating network "compose_default" with the default driver Pulling mariadb (nexus3.onap.org:10001/mariadb:10.10.2)... 10.10.2: Pulling from mariadb Digest: sha256:bfc25a68e113de43d0d112f5a7126df8e278579c3224e3923359e1c1d8d5ce6e Status: Downloaded newer image for nexus3.onap.org:10001/mariadb:10.10.2 Pulling simulator (nexus3.onap.org:10001/onap/policy-models-simulator:3.1.0-SNAPSHOT)... 3.1.0-SNAPSHOT: Pulling from onap/policy-models-simulator Digest: sha256:1d650b37ff309378612f041bffaa085be0dde5cddd6cce1becc722e06e665d03 Status: Downloaded newer image for nexus3.onap.org:10001/onap/policy-models-simulator:3.1.0-SNAPSHOT Pulling policy-db-migrator (nexus3.onap.org:10001/onap/policy-db-migrator:3.1.0-SNAPSHOT)... 3.1.0-SNAPSHOT: Pulling from onap/policy-db-migrator Digest: sha256:2cb91767d5c6ee47c5d2a9c1934f0f94c42ac8195f6bdc68f2074bff47bd42dc Status: Downloaded newer image for nexus3.onap.org:10001/onap/policy-db-migrator:3.1.0-SNAPSHOT Pulling api (nexus3.onap.org:10001/onap/policy-api:3.1.0-SNAPSHOT)... 3.1.0-SNAPSHOT: Pulling from onap/policy-api Digest: sha256:32a1ac5d483a14504c78b832b9351ddb75c277bc93c1976d4c5d9d338b0116cd Status: Downloaded newer image for nexus3.onap.org:10001/onap/policy-api:3.1.0-SNAPSHOT Pulling pap (nexus3.onap.org:10001/onap/policy-pap:3.1.0-SNAPSHOT)... 3.1.0-SNAPSHOT: Pulling from onap/policy-pap Digest: sha256:f505dc7849430e6314442a862645cc154eb56fb72ad718a090c808bf6ffb48fa Status: Downloaded newer image for nexus3.onap.org:10001/onap/policy-pap:3.1.0-SNAPSHOT Pulling drools-pdp (nexus3.onap.org:10001/onap/policy-drools:2.1.0-SNAPSHOT)... 2.1.0-SNAPSHOT: Pulling from onap/policy-drools Digest: sha256:30bbdae078bee76c351ea81e9ff290e12ed4c3324678cd13411797099db465b5 Status: Downloaded newer image for nexus3.onap.org:10001/onap/policy-drools:2.1.0-SNAPSHOT Creating simulator ... Creating mariadb ... Creating simulator ... done Creating mariadb ... done Creating policy-db-migrator ... Creating policy-db-migrator ... done Creating policy-api ... Creating policy-api ... done Creating policy-pap ... Creating policy-pap ... done Creating drools ... Creating drools ... done +++ cd /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ++ sleep 10 ++ unset http_proxy https_proxy ++ export SUITES=drools-pdp-test.robot ++ SUITES=drools-pdp-test.robot ++ /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/scripts/wait_for_rest.sh localhost 30216 Waiting for REST to come up on localhost port 30216... NAMES STATUS drools Up 10 seconds policy-pap Up 11 seconds policy-api Up 11 seconds simulator Up 14 seconds mariadb Up 13 seconds ++ sleep 15 ++ ROBOT_VARIABLES=' -v POLICY_DROOLS_IP:localhost:30216' + load_set + _setopts=hxB ++ echo braceexpand:hashall:interactive-comments:xtrace ++ tr : ' ' + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o braceexpand + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o hashall + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o interactive-comments + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o xtrace ++ echo hxB ++ sed 's/./& /g' + for i in $(echo "$_setopts" | sed 's/./& /g') + set +h + for i in $(echo "$_setopts" | sed 's/./& /g') + set +x + docker_stats ++ uname -s + '[' Linux == Darwin ']' + tee /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/archives/drools-pdp/_sysinfo-1-after-setup.txt + sh -c 'top -bn1 | head -3' top - 16:19:48 up 4 min, 0 users, load average: 2.37, 0.96, 0.38 Tasks: 192 total, 1 running, 114 sleeping, 0 stopped, 0 zombie %Cpu(s): 11.0 us, 2.1 sy, 0.0 ni, 83.3 id, 3.4 wa, 0.0 hi, 0.0 si, 0.1 st + echo + sh -c 'free -h' total used free shared buff/cache available Mem: 31G 2.1G 24G 1.1M 4.5G 28G Swap: 1.0G 0B 1.0G + echo + docker ps --format 'table {{ .Names }}\t{{ .Status }}' NAMES STATUS drools Up 25 seconds policy-pap Up 26 seconds policy-api Up 27 seconds simulator Up 30 seconds mariadb Up 29 seconds + echo + docker stats --no-stream CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS 83f8dc88e5d5 drools 0.08% 164.1MiB / 31.41GiB 0.51% 3.11kB / 2.97kB 0B / 0B 49 83e4252c2e08 policy-pap 404.43% 266.5MiB / 31.41GiB 0.83% 2.87kB / 2.68kB 0B / 182MB 36 db983621a8dc policy-api 0.12% 566.2MiB / 31.41GiB 1.76% 999kB / 710kB 0B / 0B 54 f1f8efe67357 simulator 0.37% 168.9MiB / 31.41GiB 0.53% 2.18kB / 448B 102kB / 0B 94 7d055e5d2d8d mariadb 0.01% 100.3MiB / 31.41GiB 0.31% 986kB / 1.18MB 11MB / 68.3MB 26 + echo + cd /tmp/tmp.7B5x1vYVT6 + echo 'Reading the testplan:' Reading the testplan: + echo drools-pdp-test.robot + egrep -v '(^[[:space:]]*#|^[[:space:]]*$)' + sed 's|^|/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests/|' + cat testplan.txt /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests/drools-pdp-test.robot ++ xargs + SUITES=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests/drools-pdp-test.robot + echo 'ROBOT_VARIABLES= -v POLICY_DROOLS_IP:localhost:30216' ROBOT_VARIABLES= -v POLICY_DROOLS_IP:localhost:30216 + echo 'Starting Robot test suites /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests/drools-pdp-test.robot ...' Starting Robot test suites /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests/drools-pdp-test.robot ... + relax_set + set +e + set +o pipefail + python3 -m robot.run -N drools-pdp -v WORKSPACE:/tmp -v POLICY_DROOLS_IP:localhost:30216 /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/resources/tests/drools-pdp-test.robot ============================================================================== drools-pdp ============================================================================== Alive :: Runs Policy PDP Alive Check | PASS | ------------------------------------------------------------------------------ Metrics :: Verify drools-pdp is exporting metrics | PASS | ------------------------------------------------------------------------------ drools-pdp | PASS | 2 tests, 2 passed, 0 failed ============================================================================== Output: /tmp/tmp.7B5x1vYVT6/output.xml Log: /tmp/tmp.7B5x1vYVT6/log.html Report: /tmp/tmp.7B5x1vYVT6/report.html + RESULT=0 + load_set + _setopts=hxB ++ tr : ' ' ++ echo braceexpand:hashall:interactive-comments:xtrace + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o braceexpand + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o hashall + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o interactive-comments + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o xtrace ++ echo hxB ++ sed 's/./& /g' + for i in $(echo "$_setopts" | sed 's/./& /g') + set +h + for i in $(echo "$_setopts" | sed 's/./& /g') + set +x + echo 'RESULT: 0' RESULT: 0 + exit 0 + on_exit + rc=0 + [[ -n /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ]] + docker ps --format 'table {{ .Names }}\t{{ .Status }}' NAMES STATUS drools Up 28 seconds policy-pap Up 29 seconds policy-api Up 30 seconds simulator Up 33 seconds mariadb Up 32 seconds + docker_stats ++ uname -s + '[' Linux == Darwin ']' + sh -c 'top -bn1 | head -3' top - 16:19:51 up 4 min, 0 users, load average: 2.37, 0.96, 0.38 Tasks: 190 total, 1 running, 112 sleeping, 0 stopped, 0 zombie %Cpu(s): 11.5 us, 2.1 sy, 0.0 ni, 82.9 id, 3.4 wa, 0.0 hi, 0.0 si, 0.1 st + echo + sh -c 'free -h' total used free shared buff/cache available Mem: 31G 2.2G 24G 1.1M 4.5G 28G Swap: 1.0G 0B 1.0G + echo + docker ps --format 'table {{ .Names }}\t{{ .Status }}' NAMES STATUS drools Up 28 seconds policy-pap Up 29 seconds policy-api Up 30 seconds simulator Up 33 seconds mariadb Up 32 seconds + echo + docker stats --no-stream CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS 83f8dc88e5d5 drools 0.10% 170MiB / 31.41GiB 0.53% 4.66kB / 15.8kB 0B / 0B 52 83e4252c2e08 policy-pap 438.67% 424.7MiB / 31.41GiB 1.32% 7.46kB / 8.81kB 0B / 182MB 41 db983621a8dc policy-api 0.12% 566.2MiB / 31.41GiB 1.76% 999kB / 710kB 0B / 0B 54 f1f8efe67357 simulator 0.29% 169.1MiB / 31.41GiB 0.53% 2.18kB / 448B 102kB / 0B 94 7d055e5d2d8d mariadb 0.02% 101.1MiB / 31.41GiB 0.31% 992kB / 1.18MB 11MB / 68.3MB 36 + echo + source_safely /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose/stop-compose.sh + '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose/stop-compose.sh ']' + relax_set + set +e + set +o pipefail + . /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose/stop-compose.sh ++ echo 'Shut down started!' Shut down started! ++ '[' -z /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ']' ++ COMPOSE_FOLDER=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose ++ cd /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/compose ++ source export-ports.sh ++ source get-versions.sh ++ echo 'Collecting logs from docker compose containers...' Collecting logs from docker compose containers... ++ docker-compose logs ++ cat docker_compose.log Attaching to drools, policy-pap, policy-api, policy-db-migrator, simulator, mariadb mariadb | 2023-12-11 16:19:19+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.10.2+maria~ubu2204 started. mariadb | 2023-12-11 16:19:19+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' mariadb | 2023-12-11 16:19:19+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.10.2+maria~ubu2204 started. mariadb | 2023-12-11 16:19:19+00:00 [Note] [Entrypoint]: Initializing database files mariadb | 2023-12-11 16:19:19 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required) mariadb | 2023-12-11 16:19:19 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF mariadb | 2023-12-11 16:19:19 0 [Warning] 'default-authentication-plugin' is MySQL 5.6 / 5.7 compatible option. To be implemented in later versions. mariadb | mariadb | mariadb | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! mariadb | To do so, start the server, then issue the following command: mariadb | mariadb | '/usr/bin/mysql_secure_installation' mariadb | mariadb | which will also give you the option of removing the test mariadb | databases and anonymous user created by default. This is mariadb | strongly recommended for production servers. mariadb | mariadb | See the MariaDB Knowledgebase at https://mariadb.com/kb mariadb | mariadb | Please report any problems at https://mariadb.org/jira mariadb | mariadb | The latest information about MariaDB is available at https://mariadb.org/. mariadb | mariadb | Consider joining MariaDB's strong and vibrant community: mariadb | https://mariadb.org/get-involved/ mariadb | mariadb | 2023-12-11 16:19:21+00:00 [Note] [Entrypoint]: Database files initialized mariadb | 2023-12-11 16:19:21+00:00 [Note] [Entrypoint]: Starting temporary server mariadb | 2023-12-11 16:19:21+00:00 [Note] [Entrypoint]: Waiting for server startup mariadb | 2023-12-11 16:19:21 0 [Note] mariadbd (server 10.10.2-MariaDB-1:10.10.2+maria~ubu2204) starting as process 99 ... mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: Number of transaction pools: 1 mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions mariadb | 2023-12-11 16:19:21 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) mariadb | 2023-12-11 16:19:21 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required) mariadb | 2023-12-11 16:19:21 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: Completed initialization of buffer pool mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: 128 rollback segments are active. mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. mariadb | 2023-12-11 16:19:21 0 [Note] InnoDB: log sequence number 46590; transaction id 14 mariadb | 2023-12-11 16:19:21 0 [Note] Plugin 'FEEDBACK' is disabled. mariadb | 2023-12-11 16:19:21 0 [Warning] 'default-authentication-plugin' is MySQL 5.6 / 5.7 compatible option. To be implemented in later versions. mariadb | 2023-12-11 16:19:21 0 [Warning] 'user' entry 'root@mariadb' ignored in --skip-name-resolve mode. mariadb | 2023-12-11 16:19:21 0 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode. mariadb | 2023-12-11 16:19:21 0 [Note] mariadbd: ready for connections. mariadb | Version: '10.10.2-MariaDB-1:10.10.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution mariadb | 2023-12-11 16:19:22+00:00 [Note] [Entrypoint]: Temporary server started. mariadb | 2023-12-11 16:19:24+00:00 [Note] [Entrypoint]: Creating user policy_user mariadb | 2023-12-11 16:19:24+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation) mariadb | mariadb | 2023-12-11 16:19:24+00:00 [Warn] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/db.conf mariadb | mariadb | 2023-12-11 16:19:24+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/db.sh mariadb | #!/bin/bash -xv drools | Waiting for mariadb port 3306... drools | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | Connection to mariadb (172.17.0.2) 3306 port [tcp/mysql] succeeded! drools | Waiting for message-router port 3904... drools | Connection to message-router (172.17.0.3) 3904 port [tcp/*] succeeded! drools | -- /opt/app/policy/bin/pdpd-entrypoint.sh boot -- drools | + operation=boot drools | + dockerBoot drools | + '[' y '=' y ] drools | -- dockerBoot -- drools | + echo '-- dockerBoot --' drools | + set -x drools | + set -e drools | + configure drools | -- configure -- drools | -- reload -- drools | + '[' y '=' y ] drools | + echo '-- configure --' drools | + set -x drools | + reload drools | + '[' y '=' y ] drools | + echo '-- reload --' drools | + set -x drools | + systemConfs drools | + '[' y '=' y ] drools | + echo '-- systemConfs --' drools | + set -x drools | + local confName drools | -- systemConfs -- drools | + ls '/tmp/policy-install/config/*.conf' drools | + return 0 drools | + maven drools | + '[' y '=' y ] drools | + echo '-- maven --' drools | -- maven -- drools | + set -x drools | + '[' -f /tmp/policy-install/config/settings.xml ] drools | + '[' -f /tmp/policy-install/config/standalone-settings.xml ] drools | + features drools | + '[' y '=' y ] drools | + echo '-- features --' mariadb | # Copyright 2019,2021 AT&T Intellectual Property. All rights reserved drools | -- features -- mariadb | # Modifications Copyright (c) 2022 Nordix Foundation. policy-api | Waiting for mariadb port 3306... drools | + set -x policy-pap | Waiting for mariadb port 3306... mariadb | # policy-api | mariadb (172.17.0.2:3306) open policy-db-migrator | Waiting for mariadb port 3306... drools | + ls '/tmp/policy-install/config/features*.zip' simulator | Policy simulator config file: /opt/app/policy/simulators/etc/mounted/simParameters.json policy-pap | mariadb (172.17.0.2:3306) open mariadb | # Licensed under the Apache License, Version 2.0 (the "License"); policy-api | Waiting for policy-db-migrator port 6824... policy-db-migrator | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | + return 0 simulator | overriding logback.xml policy-pap | Waiting for message-router port 3904... mariadb | # you may not use this file except in compliance with the License. policy-api | policy-db-migrator (172.17.0.4:6824) open drools | -- security -- simulator | 2023-12-11 16:19:18,958 INFO replacing 'HOST_NAME' with simulator in /opt/app/policy/simulators/etc/mounted/simParameters.json policy-pap | message-router (172.17.0.3:3904) open mariadb | # You may obtain a copy of the License at policy-api | Policy api config file: /opt/app/policy/api/etc/apiParameters.yaml policy-db-migrator | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | + security simulator | 2023-12-11 16:19:19,048 INFO org.onap.policy.models.simulators starting policy-pap | Waiting for api port 6969... mariadb | # policy-api | policy-db-migrator | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | + '[' y '=' y ] simulator | 2023-12-11 16:19:19,049 INFO org.onap.policy.models.simulators starting DMaaP provider policy-pap | api (172.17.0.5:6969) open mariadb | # http://www.apache.org/licenses/LICENSE-2.0 policy-api | . ____ _ __ _ _ policy-db-migrator | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | + echo '-- security --' simulator | 2023-12-11 16:19:19,050 INFO service manager starting policy-pap | Policy pap config file: /opt/app/policy/pap/etc/papParameters.yaml mariadb | # policy-api | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ policy-db-migrator | nc: connect to mariadb (172.17.0.2) port 3306 (tcp) failed: Connection refused drools | + set -x simulator | 2023-12-11 16:19:19,050 INFO service manager starting Topic Sweeper policy-pap | PDP group configuration file: /opt/app/policy/pap/etc/mounted/groups.json mariadb | # Unless required by applicable law or agreed to in writing, software policy-api | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ policy-db-migrator | Connection to mariadb (172.17.0.2) 3306 port [tcp/mysql] succeeded! drools | + '[' -f /tmp/policy-install/config/policy-keystore ] simulator | 2023-12-11 16:19:19,051 INFO service manager started policy-pap | mariadb | # distributed under the License is distributed on an "AS IS" BASIS, policy-api | \\/ ___)| |_)| | | | | || (_| | ) ) ) ) policy-db-migrator | 321 blocks drools | + '[' -f /tmp/policy-install/config/policy-truststore ] simulator | 2023-12-11 16:19:19,051 INFO org.onap.policy.models.simulators starting CDS gRPC Server Properties policy-pap | . ____ _ __ _ _ mariadb | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. policy-api | ' |____| .__|_| |_|_| |_\__, | / / / / policy-db-migrator | Preparing upgrade release version: 0800 drools | + '[' -f /tmp/policy-install/config/aaf-cadi.keyfile ] simulator | 2023-12-11 16:19:19,261 INFO org.onap.policy.models.simulators starting DMaaP simulator policy-pap | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ mariadb | # See the License for the specific language governing permissions and policy-api | =========|_|==============|___/=/_/_/_/ policy-db-migrator | Preparing upgrade release version: 0900 drools | + serverConfig properties simulator | 2023-12-11 16:19:19,358 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=DMaaP simulator, host=0.0.0.0, port=3904, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@fd8294b{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@5974109{/,null,STOPPED}, connector=DMaaP simulator@3e10dc6{HTTP/1.1, (http/1.1)}{0.0.0.0:3904}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: WAITED-START policy-pap | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ mariadb | # limitations under the License. policy-api | :: Spring Boot :: (v3.1.4) policy-db-migrator | Preparing upgrade release version: 1000 drools | + '[' y '=' y ] simulator | 2023-12-11 16:19:19,368 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=DMaaP simulator, host=0.0.0.0, port=3904, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@fd8294b{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@5974109{/,null,STOPPED}, connector=DMaaP simulator@3e10dc6{HTTP/1.1, (http/1.1)}{0.0.0.0:3904}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | \\/ ___)| |_)| | | | | || (_| | ) ) ) ) mariadb | policy-api | policy-db-migrator | Preparing upgrade release version: 1100 drools | -- serverConfig -- simulator | 2023-12-11 16:19:19,370 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=DMaaP simulator, host=0.0.0.0, port=3904, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@fd8294b{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@5974109{/,null,STOPPED}, connector=DMaaP simulator@3e10dc6{HTTP/1.1, (http/1.1)}{0.0.0.0:3904}, jettyThread=Thread[DMaaP simulator-3904,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | ' |____| .__|_| |_|_| |_\__, | / / / / mariadb | for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:33.856+00:00|INFO|PolicyApiApplication|main] Starting PolicyApiApplication using Java 17.0.9 with PID 21 (/app/api.jar started by policy in /opt/app/policy/api/bin) policy-db-migrator | Preparing upgrade release version: 1200 drools | + echo '-- serverConfig --' simulator | 2023-12-11 16:19:19,380 INFO jetty-11.0.18; built: 2023-10-27T02:14:36.036Z; git: 5a9a771a9fbcb9d36993630850f612581b78c13f; jvm 17.0.9+8-alpine-r0 policy-pap | =========|_|==============|___/=/_/_/_/ mariadb | do policy-api | [2023-12-11T16:19:33.857+00:00|INFO|PolicyApiApplication|main] No active profile set, falling back to 1 default profile: "default" policy-db-migrator | Preparing upgrade release version: 1300 drools | + set -x simulator | 2023-12-11 16:19:19,443 INFO Session workerName=node0 policy-pap | :: Spring Boot :: (v3.1.4) mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "CREATE DATABASE IF NOT EXISTS ${db};" policy-api | [2023-12-11T16:19:35.518+00:00|INFO|RepositoryConfigurationDelegate|main] Bootstrapping Spring Data JPA repositories in DEFAULT mode. policy-db-migrator | Done drools | + local 'configExtSuffix=properties' simulator | 2023-12-11 16:19:19,979 INFO Using GSON for REST calls policy-pap | mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "GRANT ALL PRIVILEGES ON \`${db}\`.* TO '${MYSQL_USER}'@'%' ;" policy-api | [2023-12-11T16:19:35.619+00:00|INFO|RepositoryConfigurationDelegate|main] Finished Spring Data repository scanning in 91 ms. Found 6 JPA repository interfaces. policy-db-migrator | name version drools | + ls /tmp/policy-install/config/engine-system.properties simulator | 2023-12-11 16:19:20,048 INFO Started o.e.j.s.ServletContextHandler@5974109{/,null,AVAILABLE} policy-pap | [2023-12-11T16:19:46.455+00:00|INFO|PolicyPapApplication|main] Starting PolicyPapApplication using Java 17.0.9 with PID 34 (/app/pap.jar started by policy in /opt/app/policy/pap/bin) mariadb | done policy-api | [2023-12-11T16:19:36.041+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.api.main.exception.ServiceExceptionHandler policy-db-migrator | policyadmin 0 drools | + ls /tmp/policy-install/config/engine-system.properties simulator | 2023-12-11 16:19:20,056 INFO Started DMaaP simulator@3e10dc6{HTTP/1.1, (http/1.1)}{0.0.0.0:3904} policy-pap | [2023-12-11T16:19:46.458+00:00|INFO|PolicyPapApplication|main] No active profile set, falling back to 1 default profile: "default" mariadb | + for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:36.042+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.api.main.exception.ServiceExceptionHandler policy-db-migrator | policyadmin: upgrade available: 0 -> 1300 drools | configuration properties: /tmp/policy-install/config/engine-system.properties simulator | 2023-12-11 16:19:20,064 INFO Started Server@fd8294b{STARTING}[11.0.18,sto=0] @1560ms policy-pap | [2023-12-11T16:19:48.327+00:00|INFO|RepositoryConfigurationDelegate|main] Bootstrapping Spring Data JPA repositories in DEFAULT mode. mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS migration;' policy-api | [2023-12-11T16:19:36.663+00:00|INFO|TomcatWebServer|main] Tomcat initialized with port(s): 6969 (http) policy-db-migrator | upgrade: 0 -> 1300 drools | + echo 'configuration properties: /tmp/policy-install/config/engine-system.properties' simulator | 2023-12-11 16:19:20,065 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}}, swaggerId=null, toString()=JettyServletServer(name=DMaaP simulator, host=0.0.0.0, port=3904, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@fd8294b{STARTED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@5974109{/,null,AVAILABLE}, connector=DMaaP simulator@3e10dc6{HTTP/1.1, (http/1.1)}{0.0.0.0:3904}, jettyThread=Thread[DMaaP simulator-3904,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-6821ea29==org.glassfish.jersey.servlet.ServletContainer@ad0b2472{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}})]: pending time is 4305 ms. policy-pap | [2023-12-11T16:19:48.444+00:00|INFO|RepositoryConfigurationDelegate|main] Finished Spring Data repository scanning in 104 ms. Found 7 JPA repository interfaces. mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `migration`.* TO '\''policy_user'\''@'\''%'\'' ;' policy-api | [2023-12-11T16:19:36.671+00:00|INFO|Http11NioProtocol|main] Initializing ProtocolHandler ["http-nio-6969"] policy-db-migrator | drools | + cp -f /tmp/policy-install/config/engine-system.properties /opt/app/policy/config simulator | 2023-12-11 16:19:20,069 INFO org.onap.policy.models.simulators starting org.onap.policy.simulators.AaiSimulatorJaxRs_RESOURCE_LOCATION policy-pap | [2023-12-11T16:19:48.910+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.pap.main.exception.ServiceExceptionHandler mariadb | + for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:36.673+00:00|INFO|StandardService|main] Starting service [Tomcat] policy-db-migrator | > upgrade 0100-jpapdpgroup_properties.sql drools | -- serverConfig -- simulator | 2023-12-11 16:19:20,069 INFO org.onap.policy.models.simulators starting A&AI simulator policy-pap | [2023-12-11T16:19:48.910+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.pap.main.exception.ServiceExceptionHandler mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS pooling;' policy-api | [2023-12-11T16:19:36.673+00:00|INFO|StandardEngine|main] Starting Servlet engine: [Apache Tomcat/10.1.16] policy-db-migrator | -------------- drools | + serverConfig xml simulator | 2023-12-11 16:19:20,072 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=A&AI simulator, host=0.0.0.0, port=6666, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4fc5e095{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@435871cb{/,null,STOPPED}, connector=A&AI simulator@6b9ce1bf{HTTP/1.1, (http/1.1)}{0.0.0.0:6666}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: WAITED-START policy-pap | [2023-12-11T16:19:49.575+00:00|INFO|TomcatWebServer|main] Tomcat initialized with port(s): 6969 (http) mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `pooling`.* TO '\''policy_user'\''@'\''%'\'' ;' policy-api | [2023-12-11T16:19:36.758+00:00|INFO|[/policy/api/v1]|main] Initializing Spring embedded WebApplicationContext policy-db-migrator | CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PROPERTIES VARCHAR(255) DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) DEFAULT NULL) drools | + '[' y '=' y ] simulator | 2023-12-11 16:19:20,072 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=A&AI simulator, host=0.0.0.0, port=6666, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4fc5e095{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@435871cb{/,null,STOPPED}, connector=A&AI simulator@6b9ce1bf{HTTP/1.1, (http/1.1)}{0.0.0.0:6666}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | [2023-12-11T16:19:49.585+00:00|INFO|Http11NioProtocol|main] Initializing ProtocolHandler ["http-nio-6969"] mariadb | + for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:36.758+00:00|INFO|ServletWebServerApplicationContext|main] Root WebApplicationContext: initialization completed in 2838 ms policy-db-migrator | -------------- drools | + echo '-- serverConfig --' simulator | 2023-12-11 16:19:20,073 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=A&AI simulator, host=0.0.0.0, port=6666, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4fc5e095{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@435871cb{/,null,STOPPED}, connector=A&AI simulator@6b9ce1bf{HTTP/1.1, (http/1.1)}{0.0.0.0:6666}, jettyThread=Thread[A&AI simulator-6666,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | [2023-12-11T16:19:49.586+00:00|INFO|StandardService|main] Starting service [Tomcat] mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS policyadmin;' policy-api | [2023-12-11T16:19:37.208+00:00|INFO|LogHelper|main] HHH000204: Processing PersistenceUnitInfo [name: default] policy-db-migrator | drools | + set -x simulator | 2023-12-11 16:19:20,074 INFO jetty-11.0.18; built: 2023-10-27T02:14:36.036Z; git: 5a9a771a9fbcb9d36993630850f612581b78c13f; jvm 17.0.9+8-alpine-r0 policy-pap | [2023-12-11T16:19:49.587+00:00|INFO|StandardEngine|main] Starting Servlet engine: [Apache Tomcat/10.1.16] mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `policyadmin`.* TO '\''policy_user'\''@'\''%'\'' ;' policy-api | [2023-12-11T16:19:37.278+00:00|INFO|Version|main] HHH000412: Hibernate ORM core version 6.3.0.CR1 policy-db-migrator | drools | + local 'configExtSuffix=xml' simulator | 2023-12-11 16:19:20,082 INFO Session workerName=node0 policy-pap | [2023-12-11T16:19:49.691+00:00|INFO|[/policy/pap/v1]|main] Initializing Spring embedded WebApplicationContext mariadb | + for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:37.281+00:00|INFO|Environment|main] HHH000406: Using bytecode reflection optimizer policy-db-migrator | > upgrade 0110-jpapdpstatistics_enginestats.sql drools | + ls '/tmp/policy-install/config/*.xml' simulator | 2023-12-11 16:19:20,152 INFO Using GSON for REST calls policy-pap | [2023-12-11T16:19:49.691+00:00|INFO|ServletWebServerApplicationContext|main] Root WebApplicationContext: initialization completed in 3144 ms mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS operationshistory;' policy-api | [2023-12-11T16:19:37.326+00:00|INFO|RegionFactoryInitiator|main] HHH000026: Second-level cache disabled policy-db-migrator | -------------- drools | + return 0 simulator | 2023-12-11 16:19:20,168 INFO Started o.e.j.s.ServletContextHandler@435871cb{/,null,AVAILABLE} policy-pap | [2023-12-11T16:19:50.128+00:00|INFO|LogHelper|main] HHH000204: Processing PersistenceUnitInfo [name: default] mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `operationshistory`.* TO '\''policy_user'\''@'\''%'\'' ;' policy-api | [2023-12-11T16:19:37.682+00:00|INFO|SpringPersistenceUnitInfo|main] No LoadTimeWeaver setup: ignoring JPA class transformer policy-db-migrator | CREATE TABLE IF NOT EXISTS jpapdpstatistics_enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL, ENGINEID VARCHAR(255) DEFAULT NULL, ENGINETIMESTAMP BIGINT DEFAULT NULL, ENGINEWORKERSTATE INT DEFAULT NULL, EVENTCOUNT BIGINT DEFAULT NULL, LASTENTERTIME BIGINT DEFAULT NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL, LASTSTART BIGINT DEFAULT NULL, UPTIME BIGINT DEFAULT NULL, timeStamp datetime DEFAULT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL) drools | + serverConfig json simulator | 2023-12-11 16:19:20,170 INFO Started A&AI simulator@6b9ce1bf{HTTP/1.1, (http/1.1)}{0.0.0.0:6666} policy-pap | [2023-12-11T16:19:50.219+00:00|INFO|Version|main] HHH000412: Hibernate ORM core version 6.3.0.CR1 mariadb | + for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:37.701+00:00|INFO|HikariDataSource|main] HikariPool-1 - Starting... policy-db-migrator | -------------- drools | + '[' y '=' y ] simulator | 2023-12-11 16:19:20,170 INFO Started Server@4fc5e095{STARTING}[11.0.18,sto=0] @1666ms policy-pap | [2023-12-11T16:19:50.222+00:00|INFO|Environment|main] HHH000406: Using bytecode reflection optimizer mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS clampacm;' policy-api | [2023-12-11T16:19:37.785+00:00|INFO|HikariPool|main] HikariPool-1 - Added connection org.mariadb.jdbc.Connection@2620e717 policy-db-migrator | drools | -- serverConfig -- simulator | 2023-12-11 16:19:20,170 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}}, swaggerId=null, toString()=JettyServletServer(name=A&AI simulator, host=0.0.0.0, port=6666, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4fc5e095{STARTED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@435871cb{/,null,AVAILABLE}, connector=A&AI simulator@6b9ce1bf{HTTP/1.1, (http/1.1)}{0.0.0.0:6666}, jettyThread=Thread[A&AI simulator-6666,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-75ed9710==org.glassfish.jersey.servlet.ServletContainer@cffad7c8{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}})]: pending time is 4903 ms. policy-pap | [2023-12-11T16:19:50.271+00:00|INFO|RegionFactoryInitiator|main] HHH000026: Second-level cache disabled mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `clampacm`.* TO '\''policy_user'\''@'\''%'\'' ;' policy-api | [2023-12-11T16:19:37.787+00:00|INFO|HikariDataSource|main] HikariPool-1 - Start completed. policy-db-migrator | drools | + echo '-- serverConfig --' simulator | 2023-12-11 16:19:20,171 INFO org.onap.policy.models.simulators starting SDNC simulator policy-pap | [2023-12-11T16:19:50.647+00:00|INFO|SpringPersistenceUnitInfo|main] No LoadTimeWeaver setup: ignoring JPA class transformer mariadb | + for db in migration pooling policyadmin operationshistory clampacm policyclamp policy-api | [2023-12-11T16:19:37.814+00:00|WARN|deprecation|main] HHH90000025: MariaDB103Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default) policy-db-migrator | > upgrade 0120-jpapdpsubgroup_policies.sql drools | + set -x simulator | 2023-12-11 16:19:20,174 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=SDNC simulator, host=0.0.0.0, port=6668, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4bef0fe3{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@62ea3440{/,null,STOPPED}, connector=SDNC simulator@79da1ec0{HTTP/1.1, (http/1.1)}{0.0.0.0:6668}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: WAITED-START policy-pap | [2023-12-11T16:19:50.668+00:00|INFO|HikariDataSource|main] HikariPool-1 - Starting... mariadb | + mysql -uroot -psecret --execute 'CREATE DATABASE IF NOT EXISTS policyclamp;' policy-api | [2023-12-11T16:19:37.816+00:00|WARN|deprecation|main] HHH90000026: MariaDB103Dialect has been deprecated; use org.hibernate.dialect.MariaDBDialect instead policy-db-migrator | -------------- drools | + local 'configExtSuffix=json' simulator | 2023-12-11 16:19:20,175 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=SDNC simulator, host=0.0.0.0, port=6668, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4bef0fe3{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@62ea3440{/,null,STOPPED}, connector=SDNC simulator@79da1ec0{HTTP/1.1, (http/1.1)}{0.0.0.0:6668}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | [2023-12-11T16:19:50.785+00:00|INFO|HikariPool|main] HikariPool-1 - Added connection org.mariadb.jdbc.Connection@2b03d52f mariadb | + mysql -uroot -psecret --execute 'GRANT ALL PRIVILEGES ON `policyclamp`.* TO '\''policy_user'\''@'\''%'\'' ;' policy-api | [2023-12-11T16:19:39.603+00:00|INFO|JtaPlatformInitiator|main] HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration) policy-db-migrator | CREATE TABLE IF NOT EXISTS jpapdpsubgroup_policies (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL) drools | + ls '/tmp/policy-install/config/*.json' simulator | 2023-12-11 16:19:20,175 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=SDNC simulator, host=0.0.0.0, port=6668, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4bef0fe3{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@62ea3440{/,null,STOPPED}, connector=SDNC simulator@79da1ec0{HTTP/1.1, (http/1.1)}{0.0.0.0:6668}, jettyThread=Thread[SDNC simulator-6668,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | [2023-12-11T16:19:50.787+00:00|INFO|HikariDataSource|main] HikariPool-1 - Start completed. mariadb | policy-api | [2023-12-11T16:19:39.607+00:00|INFO|LocalContainerEntityManagerFactoryBean|main] Initialized JPA EntityManagerFactory for persistence unit 'default' policy-db-migrator | -------------- drools | + return 0 simulator | 2023-12-11 16:19:20,176 INFO jetty-11.0.18; built: 2023-10-27T02:14:36.036Z; git: 5a9a771a9fbcb9d36993630850f612581b78c13f; jvm 17.0.9+8-alpine-r0 policy-pap | [2023-12-11T16:19:50.816+00:00|WARN|deprecation|main] HHH90000025: MariaDB103Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default) policy-pap | [2023-12-11T16:19:50.818+00:00|WARN|deprecation|main] HHH90000026: MariaDB103Dialect has been deprecated; use org.hibernate.dialect.MariaDBDialect instead policy-db-migrator | mariadb | mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;" drools | + scripts pre.sh simulator | 2023-12-11 16:19:20,179 INFO Session workerName=node0 policy-pap | [2023-12-11T16:19:52.814+00:00|INFO|JtaPlatformInitiator|main] HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration) policy-pap | [2023-12-11T16:19:52.818+00:00|INFO|LocalContainerEntityManagerFactoryBean|main] Initialized JPA EntityManagerFactory for persistence unit 'default' policy-db-migrator | mariadb | + mysql -uroot -psecret --execute 'FLUSH PRIVILEGES;' drools | + '[' y '=' y ] simulator | 2023-12-11 16:19:20,222 INFO Using GSON for REST calls policy-pap | [2023-12-11T16:19:53.455+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.pap.main.repository.PdpGroupRepository policy-pap | [2023-12-11T16:19:54.000+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.pap.main.repository.PolicyStatusRepository policy-db-migrator | > upgrade 0130-jpapdpsubgroup_properties.sql mariadb | mysql -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" -f policyclamp < /tmp/policy-clamp-create-tables.sql drools | -- scripts -- simulator | 2023-12-11 16:19:20,230 INFO Started o.e.j.s.ServletContextHandler@62ea3440{/,null,AVAILABLE} policy-pap | [2023-12-11T16:19:54.104+00:00|WARN|LocalVariableTableParameterNameDiscoverer|main] Using deprecated '-debug' fallback for parameter name resolution. Compile the affected code with '-parameters' instead or avoid its introspection: org.onap.policy.pap.main.repository.PolicyAuditRepository policy-pap | [2023-12-11T16:19:54.661+00:00|INFO|SingleThreadedDmaapTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=38aedeed-d446-4a18-b61a-2f130396c2ec, consumerInstance=policy-pap, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-PDP-PAP, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=0]]]]: INITTED policy-db-migrator | -------------- mariadb | + mysql -upolicy_user -ppolicy_user -f policyclamp drools | + echo '-- scripts --' simulator | 2023-12-11 16:19:20,232 INFO Started SDNC simulator@79da1ec0{HTTP/1.1, (http/1.1)}{0.0.0.0:6668} policy-pap | [2023-12-11T16:19:54.673+00:00|INFO|SingleThreadedDmaapTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=policy-pap, consumerInstance=aa1efea8-b350-4de1-9f41-cf74e359eb7f, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-HEARTBEAT, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=0]]]]: INITTED policy-pap | [2023-12-11T16:19:54.991+00:00|INFO|PapDatabaseInitializer|main] Created initial pdpGroup in DB - PdpGroups(groups=[PdpGroup(name=defaultGroup, description=The default group that registers all supported policy types and pdps., pdpGroupState=ACTIVE, properties=null, pdpSubgroups=[PdpSubGroup(pdpType=drools, supportedPolicyTypes=[onap.policies.controlloop.operational.common.Drools 1.0.0, onap.policies.native.drools.Controller 1.0.0, onap.policies.native.drools.Artifact 1.0.0], policies=[], currentInstanceCount=0, desiredInstanceCount=1, properties=null, pdpInstances=null)])]) from /opt/app/policy/pap/etc/mounted/groups.json policy-db-migrator | CREATE TABLE IF NOT EXISTS jpapdpsubgroup_properties (parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL, PROPERTIES VARCHAR(255) DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) DEFAULT NULL) mariadb | drools | + set -x simulator | 2023-12-11 16:19:20,232 INFO Started Server@4bef0fe3{STARTING}[11.0.18,sto=0] @1728ms policy-pap | [2023-12-11T16:19:55.142+00:00|WARN|JpaBaseConfiguration$JpaWebConfiguration|main] spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning policy-api | [2023-12-11T16:19:40.777+00:00|WARN|ApiDatabaseInitializer|main] Detected multi-versioned type: policytypes/onap.policies.monitoring.tcagen2.v2.yaml policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:24+00:00 [Note] [Entrypoint]: Stopping temporary server drools | + local 'scriptExtSuffix=pre.sh' simulator | 2023-12-11 16:19:20,232 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}}, swaggerId=null, toString()=JettyServletServer(name=SDNC simulator, host=0.0.0.0, port=6668, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@4bef0fe3{STARTED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@62ea3440{/,null,AVAILABLE}, connector=SDNC simulator@79da1ec0{HTTP/1.1, (http/1.1)}{0.0.0.0:6668}, jettyThread=Thread[SDNC simulator-6668,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-192d74fb==org.glassfish.jersey.servlet.ServletContainer@dd44a281{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}})]: pending time is 4943 ms. policy-pap | [2023-12-11T16:19:55.379+00:00|INFO|DefaultSecurityFilterChain|main] Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@2114eb1a, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@7e514482, org.springframework.security.web.context.SecurityContextHolderFilter@f83d121, org.springframework.security.web.header.HeaderWriterFilter@709d2a6c, org.springframework.security.web.authentication.logout.LogoutFilter@25e8a111, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@212c0aff, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2a19c36b, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@299ea986, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@1e5e3147, org.springframework.security.web.access.ExceptionTranslationFilter@5ff29e8b, org.springframework.security.web.access.intercept.AuthorizationFilter@5ac7550a] policy-api | [2023-12-11T16:19:41.561+00:00|INFO|ApiDatabaseInitializer|main] Multi-versioned Service Template [onap.policies.Monitoring, onap.policies.monitoring.tcagen2] policy-db-migrator | mariadb | 2023-12-11 16:19:24 0 [Note] mariadbd (initiated by: unknown): Normal shutdown drools | + ls /tmp/policy-install/config/noop.pre.sh simulator | 2023-12-11 16:19:20,233 INFO org.onap.policy.models.simulators starting SO simulator policy-pap | [2023-12-11T16:19:56.283+00:00|INFO|EndpointLinksResolver|main] Exposing 3 endpoint(s) beneath base path '' policy-api | [2023-12-11T16:19:42.709+00:00|WARN|JpaBaseConfiguration$JpaWebConfiguration|main] spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning policy-db-migrator | mariadb | 2023-12-11 16:19:24 0 [Note] InnoDB: FTS optimize thread exiting. drools | + source /opt/app/policy/etc/profile.d/env.sh simulator | 2023-12-11 16:19:20,239 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=SO simulator, host=0.0.0.0, port=6669, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@5bfa8cc5{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@666b83a4{/,null,STOPPED}, connector=SO simulator@556d0826{HTTP/1.1, (http/1.1)}{0.0.0.0:6669}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: WAITED-START policy-pap | [2023-12-11T16:19:56.357+00:00|INFO|Http11NioProtocol|main] Starting ProtocolHandler ["http-nio-6969"] policy-api | [2023-12-11T16:19:42.893+00:00|INFO|DefaultSecurityFilterChain|main] Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@44a1e5d2, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@48adb967, org.springframework.security.web.context.SecurityContextHolderFilter@3005133e, org.springframework.security.web.header.HeaderWriterFilter@6149184e, org.springframework.security.web.authentication.logout.LogoutFilter@90efbba, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@7b1466e3, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@22ccd80f, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@2986e26f, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@136cd71b, org.springframework.security.web.access.ExceptionTranslationFilter@729f8c5d, org.springframework.security.web.access.intercept.AuthorizationFilter@69765d94] policy-db-migrator | > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql mariadb | 2023-12-11 16:19:24 0 [Note] InnoDB: Starting shutdown... drools | + templateRegex='^\$\{\{POLICY_HOME}}$' policy-pap | [2023-12-11T16:19:56.387+00:00|INFO|TomcatWebServer|main] Tomcat started on port(s): 6969 (http) with context path '/policy/pap/v1' policy-api | [2023-12-11T16:19:43.766+00:00|INFO|EndpointLinksResolver|main] Exposing 3 endpoint(s) beneath base path '' policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:24 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool simulator | 2023-12-11 16:19:20,239 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=SO simulator, host=0.0.0.0, port=6669, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@5bfa8cc5{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@666b83a4{/,null,STOPPED}, connector=SO simulator@556d0826{HTTP/1.1, (http/1.1)}{0.0.0.0:6669}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING drools | + '[' -z /opt/app/policy ] policy-pap | [2023-12-11T16:19:56.405+00:00|INFO|ServiceManager|main] Policy PAP starting policy-api | [2023-12-11T16:19:43.830+00:00|INFO|Http11NioProtocol|main] Starting ProtocolHandler ["http-nio-6969"] policy-db-migrator | CREATE TABLE IF NOT EXISTS jpapdpsubgroup_supportedpolicytypes (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL) mariadb | 2023-12-11 16:19:24 0 [Note] InnoDB: Buffer pool(s) dump completed at 231211 16:19:24 simulator | 2023-12-11 16:19:20,240 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=SO simulator, host=0.0.0.0, port=6669, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@5bfa8cc5{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@666b83a4{/,null,STOPPED}, connector=SO simulator@556d0826{HTTP/1.1, (http/1.1)}{0.0.0.0:6669}, jettyThread=Thread[SO simulator-6669,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING drools | + set -a policy-pap | [2023-12-11T16:19:56.405+00:00|INFO|ServiceManager|main] Policy PAP starting Meter Registry policy-api | [2023-12-11T16:19:43.860+00:00|INFO|TomcatWebServer|main] Tomcat started on port(s): 6969 (http) with context path '/policy/api/v1' policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" simulator | 2023-12-11 16:19:20,240 INFO jetty-11.0.18; built: 2023-10-27T02:14:36.036Z; git: 5a9a771a9fbcb9d36993630850f612581b78c13f; jvm 17.0.9+8-alpine-r0 drools | + POLICY_HOME=/opt/app/policy policy-pap | [2023-12-11T16:19:56.406+00:00|INFO|ServiceManager|main] Policy PAP starting PAP parameters policy-api | [2023-12-11T16:19:43.879+00:00|INFO|PolicyApiApplication|main] Started PolicyApiApplication in 10.796 seconds (process running for 11.408) policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Shutdown completed; log sequence number 339856; transaction id 298 simulator | 2023-12-11 16:19:20,243 INFO Session workerName=node0 drools | + ls '/opt/app/policy/etc/profile.d/*.conf' policy-pap | [2023-12-11T16:19:56.406+00:00|INFO|ServiceManager|main] Policy PAP starting Pdp Heartbeat Listener policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Note] mariadbd: Shutdown complete simulator | 2023-12-11 16:19:20,299 INFO Using GSON for REST calls drools | + '[' -d /opt/app/policy/bin ] policy-pap | [2023-12-11T16:19:56.406+00:00|INFO|ServiceManager|main] Policy PAP starting Response Request ID Dispatcher policy-db-migrator | > upgrade 0150-jpatoscacapabilityassignment_attributes.sql mariadb | drools | + PATH=/opt/app/policy/bin:/usr/lib/jvm/default-jvm/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin simulator | 2023-12-11 16:19:20,312 INFO Started o.e.j.s.ServletContextHandler@666b83a4{/,null,AVAILABLE} policy-pap | [2023-12-11T16:19:56.407+00:00|INFO|ServiceManager|main] Policy PAP starting Heartbeat Request ID Dispatcher policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25+00:00 [Note] [Entrypoint]: Temporary server stopped drools | + '[' -d /usr/lib/jvm/java-17-openjdk/bin ] simulator | 2023-12-11 16:19:20,313 INFO Started SO simulator@556d0826{HTTP/1.1, (http/1.1)}{0.0.0.0:6669} policy-pap | [2023-12-11T16:19:56.407+00:00|INFO|ServiceManager|main] Policy PAP starting Response Message Dispatcher policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, ATTRIBUTES LONGTEXT DEFAULT NULL, ATTRIBUTES_KEY VARCHAR(255) DEFAULT NULL) mariadb | drools | + PATH=/usr/lib/jvm/java-17-openjdk/bin:/opt/app/policy/bin:/usr/lib/jvm/default-jvm/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin simulator | 2023-12-11 16:19:20,313 INFO Started Server@5bfa8cc5{STARTING}[11.0.18,sto=0] @1809ms policy-pap | [2023-12-11T16:19:56.413+00:00|INFO|TopicBase|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=38aedeed-d446-4a18-b61a-2f130396c2ec, consumerInstance=policy-pap, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-PDP-PAP, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=0]]]]: registering org.onap.policy.common.endpoints.listeners.MessageTypeDispatcher@6173863f policy-db-migrator | -------------- drools | + '[' -d /home/policy/bin ] policy-pap | [2023-12-11T16:19:56.413+00:00|INFO|SingleThreadedBusTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=38aedeed-d446-4a18-b61a-2f130396c2ec, consumerInstance=policy-pap, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=1, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-PDP-PAP, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=1]]]]: starting policy-db-migrator | mariadb | 2023-12-11 16:19:25+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up. simulator | 2023-12-11 16:19:20,313 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}}, swaggerId=null, toString()=JettyServletServer(name=SO simulator, host=0.0.0.0, port=6669, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@5bfa8cc5{STARTED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@666b83a4{/,null,AVAILABLE}, connector=SO simulator@556d0826{HTTP/1.1, (http/1.1)}{0.0.0.0:6669}, jettyThread=Thread[SO simulator-6669,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-55b5f5d2==org.glassfish.jersey.servlet.ServletContainer@f89816de{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}})]: pending time is 4927 ms. drools | + set +a policy-pap | [2023-12-11T16:19:56.413+00:00|INFO|SingleThreadedDmaapTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=38aedeed-d446-4a18-b61a-2f130396c2ec, consumerInstance=policy-pap, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=1, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-PDP-PAP, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=1]]]]: INITTED policy-db-migrator | mariadb | simulator | 2023-12-11 16:19:20,314 INFO org.onap.policy.models.simulators starting VFC simulator drools | + ls /tmp/policy-install/config/noop.pre.sh policy-db-migrator | > upgrade 0160-jpatoscacapabilityassignment_metadata.sql mariadb | 2023-12-11 16:19:25 0 [Note] mariadbd (server 10.10.2-MariaDB-1:10.10.2+maria~ubu2204) starting as process 1 ... simulator | 2023-12-11 16:19:20,316 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=VFC simulator, host=0.0.0.0, port=6670, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@2b95e48b{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@4a3329b9{/,null,STOPPED}, connector=VFC simulator@efde75f{HTTP/1.1, (http/1.1)}{0.0.0.0:6670}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: WAITED-START policy-pap | [2023-12-11T16:19:56.414+00:00|INFO|ServiceManager|main] Policy PAP starting Heartbeat Message Dispatcher drools | executing script: /tmp/policy-install/config/noop.pre.sh policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 simulator | 2023-12-11 16:19:20,316 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=VFC simulator, host=0.0.0.0, port=6670, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@2b95e48b{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@4a3329b9{/,null,STOPPED}, connector=VFC simulator@efde75f{HTTP/1.1, (http/1.1)}{0.0.0.0:6670}, jettyThread=null, servlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | [2023-12-11T16:19:56.414+00:00|INFO|TopicBase|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=policy-pap, consumerInstance=aa1efea8-b350-4de1-9f41-cf74e359eb7f, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-HEARTBEAT, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=0]]]]: registering org.onap.policy.common.endpoints.listeners.MessageTypeDispatcher@a08e41b drools | + echo 'executing script: /tmp/policy-install/config/noop.pre.sh' policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Number of transaction pools: 1 simulator | 2023-12-11 16:19:20,317 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}}, swaggerId=null, toString()=JettyServletServer(name=VFC simulator, host=0.0.0.0, port=6670, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@2b95e48b{STOPPED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@4a3329b9{/,null,STOPPED}, connector=VFC simulator@efde75f{HTTP/1.1, (http/1.1)}{0.0.0.0:6670}, jettyThread=Thread[VFC simulator-6670,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=false,async=true,src=EMBEDDED:null,STOPPED}})]: STARTING policy-pap | [2023-12-11T16:19:56.414+00:00|INFO|SingleThreadedBusTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=policy-pap, consumerInstance=aa1efea8-b350-4de1-9f41-cf74e359eb7f, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=1, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-HEARTBEAT, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=1]]]]: starting drools | + source /tmp/policy-install/config/noop.pre.sh policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions simulator | 2023-12-11 16:19:20,318 INFO jetty-11.0.18; built: 2023-10-27T02:14:36.036Z; git: 5a9a771a9fbcb9d36993630850f612581b78c13f; jvm 17.0.9+8-alpine-r0 policy-pap | [2023-12-11T16:19:56.414+00:00|INFO|SingleThreadedDmaapTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=policy-pap, consumerInstance=aa1efea8-b350-4de1-9f41-cf74e359eb7f, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=false, locked=false, uebThread=null, topicListeners=1, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-HEARTBEAT, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=1]]]]: INITTED drools | + sed -i s/^dmaap/noop/g /opt/app/policy/config/engine.properties /opt/app/policy/config/feature-lifecycle.properties policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) simulator | 2023-12-11 16:19:20,323 INFO Session workerName=node0 policy-pap | [2023-12-11T16:19:56.414+00:00|INFO|ServiceManager|main] Policy PAP starting topics policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required) simulator | 2023-12-11 16:19:20,359 INFO Using GSON for REST calls policy-pap | [2023-12-11T16:19:56.415+00:00|INFO|SingleThreadedBusTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=38aedeed-d446-4a18-b61a-2f130396c2ec, consumerInstance=policy-pap, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=true, locked=false, uebThread=Thread[DMAAP-source-POLICY-PDP-PAP,5,main], topicListeners=1, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-PDP-PAP, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=1]]]]: starting drools | + chmod 644 /opt/app/policy/config/engine.properties /opt/app/policy/config/feature-lifecycle.properties policy-db-migrator | > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql mariadb | 2023-12-11 16:19:25 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF simulator | 2023-12-11 16:19:20,368 INFO Started o.e.j.s.ServletContextHandler@4a3329b9{/,null,AVAILABLE} policy-pap | [2023-12-11T16:19:56.415+00:00|INFO|SingleThreadedBusTopicSource|main] SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=policy-pap, consumerInstance=aa1efea8-b350-4de1-9f41-cf74e359eb7f, fetchTimeout=15000, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=15000], alive=true, locked=false, uebThread=Thread[DMAAP-source-POLICY-HEARTBEAT,5,main], topicListeners=1, toString()=BusTopicBase [apiKey=null, apiSecret=null, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[message-router], topic=POLICY-HEARTBEAT, effectiveTopic=POLICY-PDP-PAP, #recentEvents=0, locked=false, #topicListeners=1]]]]: starting drools | -- db -- policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB simulator | 2023-12-11 16:19:20,370 INFO Started VFC simulator@efde75f{HTTP/1.1, (http/1.1)}{0.0.0.0:6670} policy-pap | [2023-12-11T16:19:56.416+00:00|INFO|CambriaConsumerImpl|DMAAP-source-POLICY-HEARTBEAT] UEB GET /events/POLICY-PDP-PAP/policy-pap/aa1efea8-b350-4de1-9f41-cf74e359eb7f?timeout=15000 drools | + db policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL) mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Completed initialization of buffer pool simulator | 2023-12-11 16:19:20,370 INFO Started Server@2b95e48b{STARTING}[11.0.18,sto=0] @1867ms drools | + '[' y '=' y ] policy-pap | [2023-12-11T16:19:56.415+00:00|INFO|InlineBusTopicSink|main] InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=49b57bb0-465e-461e-9e70-347cdb408796, alive=false, publisher=null]]: starting policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) simulator | 2023-12-11 16:19:20,371 INFO JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}}, swaggerId=null, toString()=JettyServletServer(name=VFC simulator, host=0.0.0.0, port=6670, sniHostCheck=false, user=null, password=null, contextPath=/, jettyServer=Server@2b95e48b{STARTED}[11.0.18,sto=0], context=o.e.j.s.ServletContextHandler@4a3329b9{/,null,AVAILABLE}, connector=VFC simulator@efde75f{HTTP/1.1, (http/1.1)}{0.0.0.0:6670}, jettyThread=Thread[VFC simulator-6670,5,main], servlets={/*=org.glassfish.jersey.servlet.ServletContainer-3b220bcb==org.glassfish.jersey.servlet.ServletContainer@2323602e{jsp=null,order=0,inst=true,async=true,src=EMBEDDED:null,STARTED}})]: pending time is 4946 ms. drools | + echo '-- db --' policy-pap | [2023-12-11T16:19:56.418+00:00|INFO|CambriaConsumerImpl|DMAAP-source-POLICY-PDP-PAP] UEB GET /events/POLICY-PDP-PAP/38aedeed-d446-4a18-b61a-2f130396c2ec/policy-pap?timeout=15000 policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: 128 rollback segments are active. simulator | 2023-12-11 16:19:20,372 INFO org.onap.policy.models.simulators starting Sink APPC-CL drools | + set -x policy-pap | [2023-12-11T16:19:56.421+00:00|INFO|InlineDmaapTopicSink|main] InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=49b57bb0-465e-461e-9e70-347cdb408796, alive=false, publisher=CambriaPublisherWrapper []]]: DMAAP SINK created policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... simulator | 2023-12-11 16:19:20,385 INFO InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=176e739b-5164-478e-814b-a451fd56e94c, alive=false, publisher=null]]: starting drools | + '[' -z mariadb ] policy-pap | [2023-12-11T16:19:56.421+00:00|INFO|InlineBusTopicSink|main] InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=a01e6be2-a78b-4635-a3cc-8c305c026839, alive=false, publisher=null]]: starting policy-db-migrator | > upgrade 0180-jpatoscacapabilityassignment_properties.sql mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. simulator | 2023-12-11 16:19:20,745 INFO InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=176e739b-5164-478e-814b-a451fd56e94c, alive=false, publisher=CambriaPublisherWrapper []]]: DMAAP SINK created drools | + '[' -z 3306 ] policy-pap | [2023-12-11T16:19:56.422+00:00|INFO|HttpClient|DMAAP-source-POLICY-PDP-PAP] GET http://message-router:3904/events/POLICY-PDP-PAP/38aedeed-d446-4a18-b61a-2f130396c2ec/policy-pap?timeout=15000 (anonymous) ... policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: log sequence number 339856; transaction id 299 simulator | 2023-12-11 16:19:20,746 INFO org.onap.policy.models.simulators starting Sink APPC-LCM-WRITE drools | + echo 'Waiting for mariadb:3306 ...' policy-pap | [2023-12-11T16:19:56.422+00:00|INFO|HttpClient|DMAAP-source-POLICY-HEARTBEAT] GET http://message-router:3904/events/POLICY-PDP-PAP/policy-pap/aa1efea8-b350-4de1-9f41-cf74e359eb7f?timeout=15000 (anonymous) ... policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool simulator | 2023-12-11 16:19:20,746 INFO InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=b586dd2d-1f9a-4797-9789-ff83625797c2, alive=false, publisher=null]]: starting drools | + timeout 120 sh -c 'until nc -vz -w 20 "${SQL_HOST}" "${SQL_PORT}"; do echo -n "."; sleep 1; done' policy-pap | [2023-12-11T16:19:56.425+00:00|INFO|InlineDmaapTopicSink|main] InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=a01e6be2-a78b-4635-a3cc-8c305c026839, alive=false, publisher=CambriaPublisherWrapper []]]: DMAAP SINK created policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] Plugin 'FEEDBACK' is disabled. simulator | 2023-12-11 16:19:20,747 INFO InlineDmaapTopicSink [userName=null, password=null, getTopicCommInfrastructure()=DMAAP, toString()=InlineBusTopicSink [partitionId=b586dd2d-1f9a-4797-9789-ff83625797c2, alive=false, publisher=CambriaPublisherWrapper []]]: DMAAP SINK created drools | Waiting for mariadb:3306 ... policy-pap | [2023-12-11T16:19:56.425+00:00|INFO|ServiceManager|main] Policy PAP starting PAP Activator policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Warning] 'default-authentication-plugin' is MySQL 5.6 / 5.7 compatible option. To be implemented in later versions. simulator | 2023-12-11 16:19:20,747 INFO org.onap.policy.models.simulators starting Source APPC-CL drools | Connection to mariadb (172.17.0.2) 3306 port [tcp/mysql] succeeded! policy-pap | [2023-12-11T16:19:56.425+00:00|INFO|ServiceManager|main] Policy PAP starting PDP publisher policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. simulator | 2023-12-11 16:19:20,751 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=b5244e8c-7115-40c4-ae41-7d54edfc06d8, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-CL, effectiveTopic=APPC-CL, #recentEvents=0, locked=false, #topicListeners=0]]]]: INITTED drools | + /opt/app/policy/bin/db-migrator -s ALL -o upgrade policy-pap | [2023-12-11T16:19:56.426+00:00|INFO|ServiceManager|main] Policy PAP starting Policy Notification publisher policy-db-migrator | > upgrade 0190-jpatoscacapabilitytype_metadata.sql mariadb | 2023-12-11 16:19:25 0 [Note] Server socket created on IP: '0.0.0.0'. simulator | 2023-12-11 16:19:20,764 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=b5244e8c-7115-40c4-ae41-7d54edfc06d8, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-CL, effectiveTopic=APPC-CL, #recentEvents=0, locked=false, #topicListeners=0]]]]: starting drools | -- /opt/app/policy/bin/db-migrator -s ALL -o upgrade -- policy-pap | [2023-12-11T16:19:56.427+00:00|INFO|ServiceManager|main] Policy PAP starting PDP update timers policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:25 0 [Note] Server socket created on IP: '::'. drools | + '[' -z -s ] simulator | 2023-12-11 16:19:20,765 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=b5244e8c-7115-40c4-ae41-7d54edfc06d8, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-CL, effectiveTopic=APPC-CL, #recentEvents=0, locked=false, #topicListeners=0]]]]: INITTED policy-pap | [2023-12-11T16:19:56.429+00:00|INFO|ServiceManager|main] Policy PAP starting PDP state-change timers policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) mariadb | 2023-12-11 16:19:25 0 [Note] mariadbd: ready for connections. drools | + shift simulator | 2023-12-11 16:19:20,765 INFO org.onap.policy.models.simulators starting Source APPC-LCM-READ policy-pap | [2023-12-11T16:19:56.430+00:00|INFO|TimerManager|Thread-9] timer manager update started policy-db-migrator | -------------- mariadb | Version: '10.10.2-MariaDB-1:10.10.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution drools | + SCHEMA=ALL simulator | 2023-12-11 16:19:20,765 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=403daa77-582c-4ffa-9a92-ddf0746c0efe, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-LCM-READ, effectiveTopic=APPC-LCM-READ, #recentEvents=0, locked=false, #topicListeners=0]]]]: INITTED policy-pap | [2023-12-11T16:19:56.435+00:00|INFO|ServiceManager|main] Policy PAP starting PDP modification lock policy-db-migrator | mariadb | 2023-12-11 16:19:25 0 [Note] InnoDB: Buffer pool(s) load completed at 231211 16:19:25 drools | + shift simulator | 2023-12-11 16:19:20,766 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=403daa77-582c-4ffa-9a92-ddf0746c0efe, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-LCM-READ, effectiveTopic=APPC-LCM-READ, #recentEvents=0, locked=false, #topicListeners=0]]]]: starting policy-pap | [2023-12-11T16:19:56.435+00:00|INFO|ServiceManager|main] Policy PAP starting PDP modification requests policy-db-migrator | mariadb | 2023-12-11 16:19:25 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.5' (This connection closed normally without authentication) drools | + '[' -z -o ] simulator | 2023-12-11 16:19:20,766 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=403daa77-582c-4ffa-9a92-ddf0746c0efe, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=false, locked=false, uebThread=null, topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-LCM-READ, effectiveTopic=APPC-LCM-READ, #recentEvents=0, locked=false, #topicListeners=0]]]]: INITTED policy-pap | [2023-12-11T16:19:56.435+00:00|INFO|TimerManager|Thread-10] timer manager state-change started policy-db-migrator | > upgrade 0200-jpatoscacapabilitytype_properties.sql mariadb | 2023-12-11 16:19:25 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.4' (This connection closed normally without authentication) drools | + shift simulator | 2023-12-11 16:19:20,766 INFO org.onap.policy.models.simulators starting APPC Legacy simulator policy-pap | [2023-12-11T16:19:56.436+00:00|INFO|ServiceManager|main] Policy PAP starting PDP expiration timer policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:26 41 [Warning] Aborted connection 41 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.7' (This connection closed normally without authentication) drools | + OPERATION=upgrade simulator | 2023-12-11 16:19:20,767 INFO UEB GET /events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator policy-pap | [2023-12-11T16:19:56.437+00:00|INFO|ServiceManager|main] Policy PAP started policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL) mariadb | 2023-12-11 16:19:26 44 [Warning] Aborted connection 44 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.7' (This connection closed normally without authentication) drools | + shift simulator | 2023-12-11 16:19:20,769 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=b5244e8c-7115-40c4-ae41-7d54edfc06d8, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=true, locked=false, uebThread=Thread[DMAAP-source-APPC-CL,5,main], topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-CL, effectiveTopic=APPC-CL, #recentEvents=0, locked=false, #topicListeners=0]]]]: registering org.onap.policy.simulators.AppcLegacyTopicServer@1c4ee95c policy-pap | [2023-12-11T16:19:56.438+00:00|INFO|PolicyPapApplication|main] Started PolicyPapApplication in 10.894 seconds (process running for 11.541) policy-db-migrator | -------------- mariadb | 2023-12-11 16:19:26 45 [Warning] Aborted connection 45 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.6' (This connection closed normally without authentication) drools | + '[' -z ] simulator | 2023-12-11 16:19:20,769 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=b5244e8c-7115-40c4-ae41-7d54edfc06d8, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=true, locked=false, uebThread=Thread[DMAAP-source-APPC-CL,5,main], topicListeners=1, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-CL, effectiveTopic=APPC-CL, #recentEvents=0, locked=false, #topicListeners=1]]]]: register: start not attempted policy-db-migrator | drools | + '[' -z ALL ] simulator | 2023-12-11 16:19:20,769 INFO org.onap.policy.models.simulators starting APPC-LCM simulator policy-db-migrator | drools | + source /opt/app/policy/etc/profile.d/env.sh simulator | 2023-12-11 16:19:20,770 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=403daa77-582c-4ffa-9a92-ddf0746c0efe, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=true, locked=false, uebThread=Thread[DMAAP-source-APPC-LCM-READ,5,main], topicListeners=0, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-LCM-READ, effectiveTopic=APPC-LCM-READ, #recentEvents=0, locked=false, #topicListeners=0]]]]: registering org.onap.policy.simulators.AppcLcmTopicServer@49bd54f7 policy-db-migrator | > upgrade 0210-jpatoscadatatype_constraints.sql drools | + templateRegex='^\$\{\{POLICY_HOME}}$' simulator | 2023-12-11 16:19:20,770 INFO SingleThreadedDmaapTopicSource [userName=null, password=-, getTopicCommInfrastructure()=DMAAP, toString()=SingleThreadedBusTopicSource [consumerGroup=403daa77-582c-4ffa-9a92-ddf0746c0efe, consumerInstance=simulator, fetchTimeout=-1, fetchLimit=-1, consumer=CambriaConsumerWrapper [fetchTimeout=-1], alive=true, locked=false, uebThread=Thread[DMAAP-source-APPC-LCM-READ,5,main], topicListeners=1, toString()=BusTopicBase [apiKey=some-key, apiSecret=some-secret, useHttps=false, allowSelfSignedCerts=false, toString()=TopicBase [servers=[simulator], topic=APPC-LCM-READ, effectiveTopic=APPC-LCM-READ, #recentEvents=0, locked=false, #topicListeners=1]]]]: register: start not attempted policy-db-migrator | -------------- drools | + '[' -z /opt/app/policy ] simulator | 2023-12-11 16:19:20,770 INFO org.onap.policy.models.simulators started policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscadatatype_constraints (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS VARCHAR(255) NULL) drools | + set -a simulator | 2023-12-11 16:19:20,772 INFO UEB GET /events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator policy-db-migrator | -------------- drools | + POLICY_HOME=/opt/app/policy simulator | 2023-12-11 16:19:20,791 WARN GET http://simulator:3904/events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator will send credentials over a clear channel. policy-db-migrator | drools | + ls '/opt/app/policy/etc/profile.d/*.conf' simulator | 2023-12-11 16:19:20,791 INFO GET http://simulator:3904/events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator (as some-key) ... policy-db-migrator | drools | + '[' -d /opt/app/policy/bin ] simulator | 2023-12-11 16:19:20,791 WARN GET http://simulator:3904/events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator will send credentials over a clear channel. policy-db-migrator | > upgrade 0220-jpatoscadatatype_metadata.sql drools | + : simulator | 2023-12-11 16:19:20,791 INFO GET http://simulator:3904/events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator (as some-key) ... policy-db-migrator | -------------- drools | + '[' -d /usr/lib/jvm/java-17-openjdk/bin ] simulator | 2023-12-11 16:19:20,882 INFO Topic APPC-LCM-READ: added policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + : simulator | 2023-12-11 16:19:20,882 INFO Topic APPC-CL: added drools | + '[' -d /home/policy/bin ] policy-db-migrator | -------------- simulator | 2023-12-11 16:19:20,883 INFO Topic APPC-LCM-READ: add consumer group: 403daa77-582c-4ffa-9a92-ddf0746c0efe drools | + set +a policy-db-migrator | simulator | 2023-12-11 16:19:20,883 INFO Topic APPC-CL: add consumer group: b5244e8c-7115-40c4-ae41-7d54edfc06d8 drools | + '[' -z mariadb ] policy-db-migrator | simulator | 2023-12-11 16:19:35,906 INFO --> HTTP/1.1 200 OK drools | + '[' -z policy_user ] policy-db-migrator | > upgrade 0230-jpatoscadatatype_properties.sql simulator | 2023-12-11 16:19:35,906 INFO --> HTTP/1.1 200 OK drools | + '[' -z policy_user ] policy-db-migrator | -------------- simulator | 2023-12-11 16:19:35,910 INFO UEB GET /events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator drools | + '[' -z 3306 ] policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscadatatype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL) simulator | 2023-12-11 16:19:35,910 INFO UEB GET /events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator drools | + '[' -z ] policy-db-migrator | -------------- simulator | 2023-12-11 16:19:35,911 WARN GET http://simulator:3904/events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator will send credentials over a clear channel. drools | + MYSQL_CMD=mysql policy-db-migrator | simulator | 2023-12-11 16:19:35,911 INFO GET http://simulator:3904/events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator (as some-key) ... drools | + MYSQL='mysql -upolicy_user -ppolicy_user -h mariadb -P 3306' policy-db-migrator | simulator | 2023-12-11 16:19:35,911 WARN GET http://simulator:3904/events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator will send credentials over a clear channel. drools | + mysql -upolicy_user -ppolicy_user -h mariadb -P 3306 --execute 'show databases;' policy-db-migrator | > upgrade 0240-jpatoscanodetemplate_metadata.sql simulator | 2023-12-11 16:19:35,911 INFO GET http://simulator:3904/events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator (as some-key) ... drools | + '[' ALL '=' ALL ] policy-db-migrator | -------------- drools | + SCHEMA='*' simulator | 2023-12-11 16:19:35,912 INFO 172.17.0.3 - - [11/Dec/2023:16:19:20 +0000] "GET /events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator HTTP/1.1" 200 2 "-" "Apache-HttpClient/4.5.14 (Java/17.0.9)" policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + ls -d '/opt/app/policy/etc/db/migration/*/' simulator | 2023-12-11 16:19:35,912 INFO 172.17.0.3 - - [11/Dec/2023:16:19:20 +0000] "GET /events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator HTTP/1.1" 200 2 "-" "Apache-HttpClient/4.5.14 (Java/17.0.9)" policy-db-migrator | -------------- drools | + SCHEMA_S= simulator | 2023-12-11 16:19:50,919 INFO --> HTTP/1.1 200 OK policy-db-migrator | drools | + '[' -z ] simulator | 2023-12-11 16:19:50,919 INFO --> HTTP/1.1 200 OK policy-db-migrator | drools | + echo 'error: no databases available' simulator | 2023-12-11 16:19:50,919 INFO UEB GET /events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator policy-db-migrator | > upgrade 0250-jpatoscanodetemplate_properties.sql drools | error: no databases available simulator | 2023-12-11 16:19:50,919 INFO 172.17.0.3 - - [11/Dec/2023:16:19:35 +0000] "GET /events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator HTTP/1.1" 200 2 "-" "Apache-HttpClient/4.5.14 (Java/17.0.9)" policy-db-migrator | -------------- drools | + exit 0 simulator | 2023-12-11 16:19:50,919 INFO UEB GET /events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) drools | + source /opt/app/policy/etc/profile.d/env.sh simulator | 2023-12-11 16:19:50,920 WARN GET http://simulator:3904/events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator will send credentials over a clear channel. policy-db-migrator | -------------- drools | + templateRegex='^\$\{\{POLICY_HOME}}$' simulator | 2023-12-11 16:19:50,920 INFO GET http://simulator:3904/events/APPC-CL/b5244e8c-7115-40c4-ae41-7d54edfc06d8/simulator (as some-key) ... policy-db-migrator | drools | + '[' -z /opt/app/policy ] simulator | 2023-12-11 16:19:50,920 INFO 172.17.0.3 - - [11/Dec/2023:16:19:35 +0000] "GET /events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator HTTP/1.1" 200 2 "-" "Apache-HttpClient/4.5.14 (Java/17.0.9)" policy-db-migrator | drools | + set -a simulator | 2023-12-11 16:19:50,920 WARN GET http://simulator:3904/events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator will send credentials over a clear channel. policy-db-migrator | > upgrade 0260-jpatoscanodetype_metadata.sql drools | + POLICY_HOME=/opt/app/policy simulator | 2023-12-11 16:19:50,920 INFO GET http://simulator:3904/events/APPC-LCM-READ/403daa77-582c-4ffa-9a92-ddf0746c0efe/simulator (as some-key) ... policy-db-migrator | -------------- drools | + ls '/opt/app/policy/etc/profile.d/*.conf' simulator | 2023-12-11 16:19:56,462 INFO Topic POLICY-PDP-PAP: added policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscanodetype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) simulator | 2023-12-11 16:19:56,463 INFO Topic POLICY-PDP-PAP: add consumer group: policy-pap policy-db-migrator | -------------- drools | + '[' -d /opt/app/policy/bin ] simulator | 2023-12-11 16:19:56,463 INFO Topic POLICY-PDP-PAP: add consumer group: 38aedeed-d446-4a18-b61a-2f130396c2ec policy-db-migrator | drools | + : policy-db-migrator | drools | + '[' -d /usr/lib/jvm/java-17-openjdk/bin ] policy-db-migrator | > upgrade 0270-jpatoscanodetype_properties.sql policy-db-migrator | -------------- drools | + : policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL) drools | + '[' -d /home/policy/bin ] policy-db-migrator | -------------- drools | + set +a policy-db-migrator | drools | + policy exec policy-db-migrator | drools | -- /opt/app/policy/bin/policy exec -- policy-db-migrator | > upgrade 0280-jpatoscapolicy_metadata.sql drools | + BIN_SCRIPT=bin/policy-management-controller policy-db-migrator | -------------- drools | + OPERATION=none drools | + '[' -z exec ] policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicy_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + OPERATION=exec policy-db-migrator | -------------- drools | + shift policy-db-migrator | drools | + '[' -z ] policy-db-migrator | drools | + '[' -z /opt/app/policy ] policy-db-migrator | > upgrade 0290-jpatoscapolicy_properties.sql drools | + policy_exec policy-db-migrator | -------------- drools | + '[' y '=' y ] policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicy_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) drools | + echo '-- policy_exec --' policy-db-migrator | -------------- drools | -- policy_exec -- policy-db-migrator | drools | + set -x policy-db-migrator | drools | + cd /opt/app/policy policy-db-migrator | > upgrade 0300-jpatoscapolicy_targets.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) drools | + check_x_file bin/policy-management-controller policy-db-migrator | -------------- drools | + '[' y '=' y ] policy-db-migrator | drools | + echo '-- check_x_file --' policy-db-migrator | drools | -- check_x_file -- policy-db-migrator | > upgrade 0310-jpatoscapolicytype_metadata.sql drools | + set -x policy-db-migrator | -------------- drools | + FILE=bin/policy-management-controller policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + '[[' '!' -f bin/policy-management-controller '||' '!' -x bin/policy-management-controller ]] policy-db-migrator | -------------- drools | + return 0 policy-db-migrator | drools | + bin/policy-management-controller exec policy-db-migrator | drools | -- bin/policy-management-controller exec -- policy-db-migrator | > upgrade 0320-jpatoscapolicytype_properties.sql drools | + _DIR=/opt/app/policy policy-db-migrator | -------------- drools | + _LOGS=/var/log/onap/policy/pdpd policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL) drools | + '[' -z /var/log/onap/policy/pdpd ] policy-db-migrator | -------------- drools | + CONTROLLER=policy-management-controller policy-db-migrator | drools | + RETVAL=0 policy-db-migrator | drools | + _PIDFILE=/opt/app/policy/PID policy-db-migrator | > upgrade 0330-jpatoscapolicytype_targets.sql drools | + exec_start policy-db-migrator | -------------- drools | + '[' y '=' y ] policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) drools | + echo '-- exec_start --' policy-db-migrator | -------------- drools | -- exec_start -- policy-db-migrator | drools | + set -x policy-db-migrator | drools | + status policy-db-migrator | > upgrade 0340-jpatoscapolicytype_triggers.sql drools | + '[' y '=' y ] policy-db-migrator | -------------- drools | + echo '-- status --' policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULL) drools | -- status -- policy-db-migrator | -------------- drools | + set -x policy-db-migrator | drools | + '[' -f /opt/app/policy/PID ] policy-db-migrator | drools | + '[' true ] policy-db-migrator | > upgrade 0350-jpatoscaproperty_constraints.sql drools | + pidof -s java policy-db-migrator | -------------- drools | + _PID= policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscaproperty_constraints (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, CONSTRAINTS VARCHAR(255) NULL) drools | + _STATUS='Policy Management (no pidfile) is NOT running' policy-db-migrator | -------------- drools | + _RUNNING=0 policy-db-migrator | drools | + '[' 0 '=' 1 ] policy-db-migrator | drools | + RETVAL=1 policy-db-migrator | > upgrade 0360-jpatoscaproperty_metadata.sql drools | + echo 'Policy Management (no pidfile) is NOT running' policy-db-migrator | -------------- drools | Policy Management (no pidfile) is NOT running policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscaproperty_metadata (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + '[' 0 '=' 1 ] policy-db-migrator | -------------- drools | + preRunning policy-db-migrator | drools | + '[' y '=' y ] policy-db-migrator | drools | + echo '-- preRunning --' policy-db-migrator | > upgrade 0370-jpatoscarelationshiptype_metadata.sql drools | -- preRunning -- policy-db-migrator | -------------- drools | + set -x policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + mkdir -p /var/log/onap/policy/pdpd policy-db-migrator | -------------- drools | + xargs -I X printf ':%s' X policy-db-migrator | policy-db-migrator | drools | + ls /opt/app/policy/lib/aaf-auth-client-2.7.4.jar /opt/app/policy/lib/aaf-cadi-aaf-2.7.4.jar /opt/app/policy/lib/aaf-cadi-client-2.7.4.jar /opt/app/policy/lib/aaf-cadi-core-2.7.4.jar /opt/app/policy/lib/aaf-misc-env-2.7.4.jar /opt/app/policy/lib/aaf-misc-rosetta-2.7.4.jar /opt/app/policy/lib/accessors-smart-2.4.9.jar /opt/app/policy/lib/angus-activation-2.0.1.jar /opt/app/policy/lib/annotations-13.0.jar /opt/app/policy/lib/ant-1.10.13.jar /opt/app/policy/lib/ant-launcher-1.10.13.jar /opt/app/policy/lib/antlr-2.7.7.jar /opt/app/policy/lib/antlr-runtime-3.5.2.jar /opt/app/policy/lib/antlr4-runtime-4.10.1.jar /opt/app/policy/lib/aopalliance-1.0.jar /opt/app/policy/lib/aopalliance-repackaged-3.0.4.jar /opt/app/policy/lib/asm-9.3.jar /opt/app/policy/lib/byte-buddy-1.12.18.jar /opt/app/policy/lib/caffeine-2.9.3.jar /opt/app/policy/lib/cambriaClient-1.2.1-oss.jar /opt/app/policy/lib/capabilities-2.1.0.jar /opt/app/policy/lib/checker-qual-3.37.0.jar /opt/app/policy/lib/classgraph-4.8.154.jar /opt/app/policy/lib/classmate-1.5.1.jar /opt/app/policy/lib/common-parameters-2.1.0.jar /opt/app/policy/lib/commons-beanutils-1.9.4.jar /opt/app/policy/lib/commons-cli-1.5.0.jar /opt/app/policy/lib/commons-codec-1.16.0.jar /opt/app/policy/lib/commons-collections4-4.4.jar /opt/app/policy/lib/commons-configuration2-2.8.0.jar /opt/app/policy/lib/commons-io-2.13.0.jar /opt/app/policy/lib/commons-lang3-3.14.0.jar /opt/app/policy/lib/commons-logging-1.2.jar /opt/app/policy/lib/commons-net-3.9.0.jar /opt/app/policy/lib/commons-text-1.10.0.jar /opt/app/policy/lib/dmaapClient-1.1.12.jar /opt/app/policy/lib/dme2-3.1.200-oss.jar /opt/app/policy/lib/dom4j-2.1.3.jar /opt/app/policy/lib/drools-base-8.44.0.Final.jar /opt/app/policy/lib/drools-canonical-model-8.44.0.Final.jar /opt/app/policy/lib/drools-codegen-common-8.44.0.Final.jar /opt/app/policy/lib/drools-commands-8.44.0.Final.jar /opt/app/policy/lib/drools-compiler-8.44.0.Final.jar /opt/app/policy/lib/drools-core-8.44.0.Final.jar /opt/app/policy/lib/drools-drl-ast-8.44.0.Final.jar /opt/app/policy/lib/drools-drl-extensions-8.44.0.Final.jar /opt/app/policy/lib/drools-drl-parser-8.44.0.Final.jar /opt/app/policy/lib/drools-ecj-8.44.0.Final.jar /opt/app/policy/lib/drools-engine-8.44.0.Final.jar /opt/app/policy/lib/drools-io-8.44.0.Final.jar /opt/app/policy/lib/drools-kiesession-8.44.0.Final.jar /opt/app/policy/lib/drools-model-codegen-8.44.0.Final.jar /opt/app/policy/lib/drools-model-compiler-8.44.0.Final.jar /opt/app/policy/lib/drools-mvel-8.44.0.Final.jar /opt/app/policy/lib/drools-mvel-compiler-8.44.0.Final.jar /opt/app/policy/lib/drools-mvel-parser-8.44.0.Final.jar /opt/app/policy/lib/drools-persistence-api-8.44.0.Final.jar /opt/app/policy/lib/drools-persistence-jpa-8.44.0.Final.jar /opt/app/policy/lib/drools-serialization-protobuf-8.44.0.Final.jar /opt/app/policy/lib/drools-tms-8.44.0.Final.jar /opt/app/policy/lib/drools-util-8.44.0.Final.jar /opt/app/policy/lib/drools-wiring-api-8.44.0.Final.jar /opt/app/policy/lib/drools-wiring-dynamic-8.44.0.Final.jar /opt/app/policy/lib/drools-wiring-static-8.44.0.Final.jar /opt/app/policy/lib/drools-xml-support-8.44.0.Final.jar /opt/app/policy/lib/ecj-3.33.0.jar /opt/app/policy/lib/error_prone_annotations-2.21.1.jar /opt/app/policy/lib/failureaccess-1.0.1.jar /opt/app/policy/lib/feature-lifecycle-2.1.0-SNAPSHOT.jar /opt/app/policy/lib/gson-2.1.0.jar /opt/app/policy/lib/gson-2.10.1.jar /opt/app/policy/lib/gson-javatime-serialisers-1.1.2.jar /opt/app/policy/lib/guava-32.1.3-jre.jar /opt/app/policy/lib/guice-4.2.2-no_aop.jar /opt/app/policy/lib/hibernate-commons-annotations-6.0.6.Final.jar /opt/app/policy/lib/hibernate-core-6.3.0.CR1.jar /opt/app/policy/lib/hibernate-core-jakarta-5.6.15.Final.jar /opt/app/policy/lib/hk2-api-3.0.4.jar /opt/app/policy/lib/hk2-locator-3.0.4.jar /opt/app/policy/lib/hk2-utils-3.0.4.jar /opt/app/policy/lib/httpclient-4.5.14.jar /opt/app/policy/lib/httpclient-cache-4.5.3.jar /opt/app/policy/lib/httpclient5-5.2.1.jar /opt/app/policy/lib/httpcore-4.4.15.jar /opt/app/policy/lib/httpcore5-5.2.2.jar /opt/app/policy/lib/httpcore5-h2-5.2.jar /opt/app/policy/lib/istack-commons-runtime-4.1.1.jar /opt/app/policy/lib/j2objc-annotations-2.8.jar /opt/app/policy/lib/jackson-annotations-2.15.2.jar /opt/app/policy/lib/jackson-core-2.15.2.jar /opt/app/policy/lib/jackson-databind-2.14.1.jar /opt/app/policy/lib/jackson-dataformat-yaml-2.15.2.jar /opt/app/policy/lib/jackson-datatype-jsr310-2.15.1.jar /opt/app/policy/lib/jackson-jakarta-rs-base-2.15.1.jar /opt/app/policy/lib/jackson-jakarta-rs-json-provider-2.15.1.jar /opt/app/policy/lib/jackson-module-jakarta-xmlbind-annotations-2.14.1.jar /opt/app/policy/lib/jackson-module-jaxb-annotations-2.15.2.jar /opt/app/policy/lib/jakarta.activation-api-2.1.2.jar /opt/app/policy/lib/jakarta.annotation-api-2.1.1.jar /opt/app/policy/lib/jakarta.ejb-api-3.2.6.jar /opt/app/policy/lib/jakarta.el-api-3.0.3.jar /opt/app/policy/lib/jakarta.enterprise.cdi-api-2.0.2.jar /opt/app/policy/lib/jakarta.inject-api-2.0.1.MR.jar /opt/app/policy/lib/jakarta.interceptor-api-1.2.5.jar /opt/app/policy/lib/jakarta.persistence-api-3.1.0.jar /opt/app/policy/lib/jakarta.servlet-api-6.0.0.jar /opt/app/policy/lib/jakarta.transaction-api-2.0.1.jar /opt/app/policy/lib/jakarta.validation-api-3.0.2.jar /opt/app/policy/lib/jakarta.ws.rs-api-3.1.0.jar /opt/app/policy/lib/jakarta.xml.bind-api-4.0.0.jar /opt/app/policy/lib/jandex-2.4.2.Final.jar /opt/app/policy/lib/jandex-3.1.2.jar /opt/app/policy/lib/javaparser-core-3.24.2.jar /opt/app/policy/lib/javassist-3.26.0-GA.jar /opt/app/policy/lib/javax.activation-api-1.2.0.jar /opt/app/policy/lib/javax.inject-1.jar /opt/app/policy/lib/javax.servlet-api-3.1.0.jar /opt/app/policy/lib/javax.ws.rs-api-2.0.1.jar /opt/app/policy/lib/jaxb-api-2.3.1.jar /opt/app/policy/lib/jaxb-core-4.0.2.jar /opt/app/policy/lib/jaxb-core-4.0.3.jar /opt/app/policy/lib/jaxb-impl-4.0.3.jar /opt/app/policy/lib/jaxb-runtime-4.0.2.jar /opt/app/policy/lib/jaxb-xjc-4.0.3.jar /opt/app/policy/lib/jboss-logging-3.5.0.Final.jar /opt/app/policy/lib/jcl-over-slf4j-1.7.30.jar /opt/app/policy/lib/jersey-client-3.1.3.jar /opt/app/policy/lib/jersey-common-3.1.3.jar /opt/app/policy/lib/jersey-container-servlet-3.1.3.jar /opt/app/policy/lib/jersey-container-servlet-core-3.1.3.jar /opt/app/policy/lib/jersey-entity-filtering-3.1.3.jar /opt/app/policy/lib/jersey-hk2-3.1.3.jar /opt/app/policy/lib/jersey-media-json-jackson-3.1.3.jar /opt/app/policy/lib/jersey-server-3.1.3.jar /opt/app/policy/lib/jetty-http-11.0.18.jar /opt/app/policy/lib/jetty-io-11.0.18.jar /opt/app/policy/lib/jetty-jakarta-servlet-api-5.0.2.jar /opt/app/policy/lib/jetty-security-11.0.18.jar /opt/app/policy/lib/jetty-server-11.0.18.jar /opt/app/policy/lib/jetty-servlet-11.0.12.jar /opt/app/policy/lib/jetty-util-11.0.18.jar /opt/app/policy/lib/jline-2.12.1.jar /opt/app/policy/lib/jna-5.12.1.jar /opt/app/policy/lib/jna-platform-5.12.1.jar /opt/app/policy/lib/json-20231013.jar /opt/app/policy/lib/json-path-2.8.0.jar /opt/app/policy/lib/json-smart-2.4.10.jar /opt/app/policy/lib/jsr305-3.0.2.jar /opt/app/policy/lib/kafka-clients-3.6.0.jar /opt/app/policy/lib/kie-api-8.44.0.Final.jar /opt/app/policy/lib/kie-ci-8.44.0.Final.jar /opt/app/policy/lib/kie-internal-8.44.0.Final.jar /opt/app/policy/lib/kie-memory-compiler-8.44.0.Final.jar /opt/app/policy/lib/kie-util-maven-integration-8.44.0.Final.jar /opt/app/policy/lib/kie-util-maven-support-8.44.0.Final.jar /opt/app/policy/lib/kie-util-xml-8.44.0.Final.jar /opt/app/policy/lib/kotlin-reflect-1.3.20.jar /opt/app/policy/lib/kotlin-stdlib-1.3.20.jar /opt/app/policy/lib/kotlin-stdlib-common-1.3.20.jar /opt/app/policy/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar /opt/app/policy/lib/logback-classic-1.4.8.jar /opt/app/policy/lib/logback-core-1.4.8.jar /opt/app/policy/lib/lombok-1.18.28.jar /opt/app/policy/lib/lz4-java-1.8.0.jar /opt/app/policy/lib/mariadb-java-client-3.1.4.jar /opt/app/policy/lib/maven-artifact-3.8.6.jar /opt/app/policy/lib/maven-builder-support-3.8.6.jar /opt/app/policy/lib/maven-compat-3.8.6.jar /opt/app/policy/lib/maven-core-3.8.6.jar /opt/app/policy/lib/maven-model-3.8.6.jar /opt/app/policy/lib/maven-model-builder-3.8.6.jar /opt/app/policy/lib/maven-plugin-api-3.8.6.jar /opt/app/policy/lib/maven-repository-metadata-3.8.6.jar /opt/app/policy/lib/maven-resolver-api-1.6.3.jar /opt/app/policy/lib/maven-resolver-connector-basic-1.7.3.jar /opt/app/policy/lib/maven-resolver-impl-1.6.3.jar /opt/app/policy/lib/maven-resolver-provider-3.8.6.jar /opt/app/policy/lib/maven-resolver-spi-1.6.3.jar /opt/app/policy/lib/maven-resolver-transport-file-1.7.3.jar /opt/app/policy/lib/maven-resolver-transport-http-1.7.3.jar /opt/app/policy/lib/maven-resolver-transport-wagon-1.7.3.jar /opt/app/policy/lib/maven-resolver-util-1.6.3.jar /opt/app/policy/lib/maven-settings-3.8.6.jar /opt/app/policy/lib/maven-settings-builder-3.8.6.jar /opt/app/policy/lib/maven-shared-utils-3.3.4.jar /opt/app/policy/lib/medeia-validator-core-1.1.1.jar /opt/app/policy/lib/medeia-validator-gson-1.1.1.jar /opt/app/policy/lib/mvel2-2.5.0.Final.jar /opt/app/policy/lib/mxparser-1.2.2.jar /opt/app/policy/lib/org.eclipse.sisu.inject-0.3.5.jar /opt/app/policy/lib/org.eclipse.sisu.plexus-0.3.5.jar /opt/app/policy/lib/osgi-resource-locator-1.0.3.jar /opt/app/policy/lib/plexus-cipher-2.0.jar /opt/app/policy/lib/plexus-classworlds-2.6.0.jar /opt/app/policy/lib/plexus-component-annotations-2.1.0.jar /opt/app/policy/lib/plexus-interpolation-1.26.jar /opt/app/policy/lib/plexus-sec-dispatcher-2.0.jar /opt/app/policy/lib/plexus-utils-3.5.0.jar /opt/app/policy/lib/policy-core-2.1.0-SNAPSHOT.jar /opt/app/policy/lib/policy-domains-2.1.0-SNAPSHOT.jar /opt/app/policy/lib/policy-endpoints-2.1.0.jar /opt/app/policy/lib/policy-management-2.1.0-SNAPSHOT.jar /opt/app/policy/lib/policy-models-base-3.1.0.jar /opt/app/policy/lib/policy-models-dao-3.1.0.jar /opt/app/policy/lib/policy-models-errors-3.1.0.jar /opt/app/policy/lib/policy-models-examples-3.1.0.jar /opt/app/policy/lib/policy-models-pdp-3.1.0.jar /opt/app/policy/lib/policy-models-tosca-3.1.0.jar /opt/app/policy/lib/policy-utils-2.1.0-SNAPSHOT.jar /opt/app/policy/lib/postgresql-42.6.0.jar /opt/app/policy/lib/protobuf-java-3.22.0.jar /opt/app/policy/lib/re2j-1.7.jar /opt/app/policy/lib/saClientLibrary-1.3.0-oss.jar /opt/app/policy/lib/saToolkit-1.2.0-oss.jar /opt/app/policy/lib/simpleclient-0.16.0.jar /opt/app/policy/lib/simpleclient_common-0.16.0.jar /opt/app/policy/lib/simpleclient_hotspot-0.16.0.jar /opt/app/policy/lib/simpleclient_logback-0.16.0.jar /opt/app/policy/lib/simpleclient_servlet_common-0.16.0.jar /opt/app/policy/lib/simpleclient_servlet_jakarta-0.16.0.jar /opt/app/policy/lib/simpleclient_tracer_common-0.16.0.jar /opt/app/policy/lib/simpleclient_tracer_otel-0.16.0.jar /opt/app/policy/lib/simpleclient_tracer_otel_agent-0.16.0.jar /opt/app/policy/lib/slf4j-api-2.0.7.jar /opt/app/policy/lib/snakeyaml-2.0.jar /opt/app/policy/lib/snappy-java-1.1.10.4.jar /opt/app/policy/lib/swagger-annotations-2.2.15.jar /opt/app/policy/lib/swagger-annotations-jakarta-2.2.15.jar /opt/app/policy/lib/swagger-core-jakarta-2.2.15.jar /opt/app/policy/lib/swagger-integration-jakarta-2.2.15.jar /opt/app/policy/lib/swagger-jaxrs2-jakarta-2.2.15.jar /opt/app/policy/lib/swagger-jaxrs2-servlet-initializer-v2-jakarta-2.2.15.jar /opt/app/policy/lib/swagger-models-jakarta-2.2.15.jar /opt/app/policy/lib/txw2-4.0.2.jar /opt/app/policy/lib/utils-2.1.0.jar /opt/app/policy/lib/waffle-jna-3.2.0.jar /opt/app/policy/lib/wagon-http-3.5.1.jar /opt/app/policy/lib/wagon-http-shared-3.5.1.jar /opt/app/policy/lib/wagon-provider-api-3.5.1.jar /opt/app/policy/lib/xmlpull-1.1.3.1.jar /opt/app/policy/lib/xstream-1.4.20.jar /opt/app/policy/lib/zstd-jni-1.5.5-1.jar policy-db-migrator | > upgrade 0380-jpatoscarelationshiptype_properties.sql policy-db-migrator | -------------- drools | + CP=:/opt/app/policy/lib/aaf-auth-client-2.7.4.jar:/opt/app/policy/lib/aaf-cadi-aaf-2.7.4.jar:/opt/app/policy/lib/aaf-cadi-client-2.7.4.jar:/opt/app/policy/lib/aaf-cadi-core-2.7.4.jar:/opt/app/policy/lib/aaf-misc-env-2.7.4.jar:/opt/app/policy/lib/aaf-misc-rosetta-2.7.4.jar:/opt/app/policy/lib/accessors-smart-2.4.9.jar:/opt/app/policy/lib/angus-activation-2.0.1.jar:/opt/app/policy/lib/annotations-13.0.jar:/opt/app/policy/lib/ant-1.10.13.jar:/opt/app/policy/lib/ant-launcher-1.10.13.jar:/opt/app/policy/lib/antlr-2.7.7.jar:/opt/app/policy/lib/antlr-runtime-3.5.2.jar:/opt/app/policy/lib/antlr4-runtime-4.10.1.jar:/opt/app/policy/lib/aopalliance-1.0.jar:/opt/app/policy/lib/aopalliance-repackaged-3.0.4.jar:/opt/app/policy/lib/asm-9.3.jar:/opt/app/policy/lib/byte-buddy-1.12.18.jar:/opt/app/policy/lib/caffeine-2.9.3.jar:/opt/app/policy/lib/cambriaClient-1.2.1-oss.jar:/opt/app/policy/lib/capabilities-2.1.0.jar:/opt/app/policy/lib/checker-qual-3.37.0.jar:/opt/app/policy/lib/classgraph-4.8.154.jar:/opt/app/policy/lib/classmate-1.5.1.jar:/opt/app/policy/lib/common-parameters-2.1.0.jar:/opt/app/policy/lib/commons-beanutils-1.9.4.jar:/opt/app/policy/lib/commons-cli-1.5.0.jar:/opt/app/policy/lib/commons-codec-1.16.0.jar:/opt/app/policy/lib/commons-collections4-4.4.jar:/opt/app/policy/lib/commons-configuration2-2.8.0.jar:/opt/app/policy/lib/commons-io-2.13.0.jar:/opt/app/policy/lib/commons-lang3-3.14.0.jar:/opt/app/policy/lib/commons-logging-1.2.jar:/opt/app/policy/lib/commons-net-3.9.0.jar:/opt/app/policy/lib/commons-text-1.10.0.jar:/opt/app/policy/lib/dmaapClient-1.1.12.jar:/opt/app/policy/lib/dme2-3.1.200-oss.jar:/opt/app/policy/lib/dom4j-2.1.3.jar:/opt/app/policy/lib/drools-base-8.44.0.Final.jar:/opt/app/policy/lib/drools-canonical-model-8.44.0.Final.jar:/opt/app/policy/lib/drools-codegen-common-8.44.0.Final.jar:/opt/app/policy/lib/drools-commands-8.44.0.Final.jar:/opt/app/policy/lib/drools-compiler-8.44.0.Final.jar:/opt/app/policy/lib/drools-core-8.44.0.Final.jar:/opt/app/policy/lib/drools-drl-ast-8.44.0.Final.jar:/opt/app/policy/lib/drools-drl-extensions-8.44.0.Final.jar:/opt/app/policy/lib/drools-drl-parser-8.44.0.Final.jar:/opt/app/policy/lib/drools-ecj-8.44.0.Final.jar:/opt/app/policy/lib/drools-engine-8.44.0.Final.jar:/opt/app/policy/lib/drools-io-8.44.0.Final.jar:/opt/app/policy/lib/drools-kiesession-8.44.0.Final.jar:/opt/app/policy/lib/drools-model-codegen-8.44.0.Final.jar:/opt/app/policy/lib/drools-model-compiler-8.44.0.Final.jar:/opt/app/policy/lib/drools-mvel-8.44.0.Final.jar:/opt/app/policy/lib/drools-mvel-compiler-8.44.0.Final.jar:/opt/app/policy/lib/drools-mvel-parser-8.44.0.Final.jar:/opt/app/policy/lib/drools-persistence-api-8.44.0.Final.jar:/opt/app/policy/lib/drools-persistence-jpa-8.44.0.Final.jar:/opt/app/policy/lib/drools-serialization-protobuf-8.44.0.Final.jar:/opt/app/policy/lib/drools-tms-8.44.0.Final.jar:/opt/app/policy/lib/drools-util-8.44.0.Final.jar:/opt/app/policy/lib/drools-wiring-api-8.44.0.Final.jar:/opt/app/policy/lib/drools-wiring-dynamic-8.44.0.Final.jar:/opt/app/policy/lib/drools-wiring-static-8.44.0.Final.jar:/opt/app/policy/lib/drools-xml-support-8.44.0.Final.jar:/opt/app/policy/lib/ecj-3.33.0.jar:/opt/app/policy/lib/error_prone_annotations-2.21.1.jar:/opt/app/policy/lib/failureaccess-1.0.1.jar:/opt/app/policy/lib/feature-lifecycle-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/gson-2.1.0.jar:/opt/app/policy/lib/gson-2.10.1.jar:/opt/app/policy/lib/gson-javatime-serialisers-1.1.2.jar:/opt/app/policy/lib/guava-32.1.3-jre.jar:/opt/app/policy/lib/guice-4.2.2-no_aop.jar:/opt/app/policy/lib/hibernate-commons-annotations-6.0.6.Final.jar:/opt/app/policy/lib/hibernate-core-6.3.0.CR1.jar:/opt/app/policy/lib/hibernate-core-jakarta-5.6.15.Final.jar:/opt/app/policy/lib/hk2-api-3.0.4.jar:/opt/app/policy/lib/hk2-locator-3.0.4.jar:/opt/app/policy/lib/hk2-utils-3.0.4.jar:/opt/app/policy/lib/httpclient-4.5.14.jar:/opt/app/policy/lib/httpclient-cache-4.5.3.jar:/opt/app/policy/lib/httpclient5-5.2.1.jar:/opt/app/policy/lib/httpcore-4.4.15.jar:/opt/app/policy/lib/httpcore5-5.2.2.jar:/opt/app/policy/lib/httpcore5-h2-5.2.jar:/opt/app/policy/lib/istack-commons-runtime-4.1.1.jar:/opt/app/policy/lib/j2objc-annotations-2.8.jar:/opt/app/policy/lib/jackson-annotations-2.15.2.jar:/opt/app/policy/lib/jackson-core-2.15.2.jar:/opt/app/policy/lib/jackson-databind-2.14.1.jar:/opt/app/policy/lib/jackson-dataformat-yaml-2.15.2.jar:/opt/app/policy/lib/jackson-datatype-jsr310-2.15.1.jar:/opt/app/policy/lib/jackson-jakarta-rs-base-2.15.1.jar:/opt/app/policy/lib/jackson-jakarta-rs-json-provider-2.15.1.jar:/opt/app/policy/lib/jackson-module-jakarta-xmlbind-annotations-2.14.1.jar:/opt/app/policy/lib/jackson-module-jaxb-annotations-2.15.2.jar:/opt/app/policy/lib/jakarta.activation-api-2.1.2.jar:/opt/app/policy/lib/jakarta.annotation-api-2.1.1.jar:/opt/app/policy/lib/jakarta.ejb-api-3.2.6.jar:/opt/app/policy/lib/jakarta.el-api-3.0.3.jar:/opt/app/policy/lib/jakarta.enterprise.cdi-api-2.0.2.jar:/opt/app/policy/lib/jakarta.inject-api-2.0.1.MR.jar:/opt/app/policy/lib/jakarta.interceptor-api-1.2.5.jar:/opt/app/policy/lib/jakarta.persistence-api-3.1.0.jar:/opt/app/policy/lib/jakarta.servlet-api-6.0.0.jar:/opt/app/policy/lib/jakarta.transaction-api-2.0.1.jar:/opt/app/policy/lib/jakarta.validation-api-3.0.2.jar:/opt/app/policy/lib/jakarta.ws.rs-api-3.1.0.jar:/opt/app/policy/lib/jakarta.xml.bind-api-4.0.0.jar:/opt/app/policy/lib/jandex-2.4.2.Final.jar:/opt/app/policy/lib/jandex-3.1.2.jar:/opt/app/policy/lib/javaparser-core-3.24.2.jar:/opt/app/policy/lib/javassist-3.26.0-GA.jar:/opt/app/policy/lib/javax.activation-api-1.2.0.jar:/opt/app/policy/lib/javax.inject-1.jar:/opt/app/policy/lib/javax.servlet-api-3.1.0.jar:/opt/app/policy/lib/javax.ws.rs-api-2.0.1.jar:/opt/app/policy/lib/jaxb-api-2.3.1.jar:/opt/app/policy/lib/jaxb-core-4.0.2.jar:/opt/app/policy/lib/jaxb-core-4.0.3.jar:/opt/app/policy/lib/jaxb-impl-4.0.3.jar:/opt/app/policy/lib/jaxb-runtime-4.0.2.jar:/opt/app/policy/lib/jaxb-xjc-4.0.3.jar:/opt/app/policy/lib/jboss-logging-3.5.0.Final.jar:/opt/app/policy/lib/jcl-over-slf4j-1.7.30.jar:/opt/app/policy/lib/jersey-client-3.1.3.jar:/opt/app/policy/lib/jersey-common-3.1.3.jar:/opt/app/policy/lib/jersey-container-servlet-3.1.3.jar:/opt/app/policy/lib/jersey-container-servlet-core-3.1.3.jar:/opt/app/policy/lib/jersey-entity-filtering-3.1.3.jar:/opt/app/policy/lib/jersey-hk2-3.1.3.jar:/opt/app/policy/lib/jersey-media-json-jackson-3.1.3.jar:/opt/app/policy/lib/jersey-server-3.1.3.jar:/opt/app/policy/lib/jetty-http-11.0.18.jar:/opt/app/policy/lib/jetty-io-11.0.18.jar:/opt/app/policy/lib/jetty-jakarta-servlet-api-5.0.2.jar:/opt/app/policy/lib/jetty-security-11.0.18.jar:/opt/app/policy/lib/jetty-server-11.0.18.jar:/opt/app/policy/lib/jetty-servlet-11.0.12.jar:/opt/app/policy/lib/jetty-util-11.0.18.jar:/opt/app/policy/lib/jline-2.12.1.jar:/opt/app/policy/lib/jna-5.12.1.jar:/opt/app/policy/lib/jna-platform-5.12.1.jar:/opt/app/policy/lib/json-20231013.jar:/opt/app/policy/lib/json-path-2.8.0.jar:/opt/app/policy/lib/json-smart-2.4.10.jar:/opt/app/policy/lib/jsr305-3.0.2.jar:/opt/app/policy/lib/kafka-clients-3.6.0.jar:/opt/app/policy/lib/kie-api-8.44.0.Final.jar:/opt/app/policy/lib/kie-ci-8.44.0.Final.jar:/opt/app/policy/lib/kie-internal-8.44.0.Final.jar:/opt/app/policy/lib/kie-memory-compiler-8.44.0.Final.jar:/opt/app/policy/lib/kie-util-maven-integration-8.44.0.Final.jar:/opt/app/policy/lib/kie-util-maven-support-8.44.0.Final.jar:/opt/app/policy/lib/kie-util-xml-8.44.0.Final.jar:/opt/app/policy/lib/kotlin-reflect-1.3.20.jar:/opt/app/policy/lib/kotlin-stdlib-1.3.20.jar:/opt/app/policy/lib/kotlin-stdlib-common-1.3.20.jar:/opt/app/policy/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/opt/app/policy/lib/logback-classic-1.4.8.jar:/opt/app/policy/lib/logback-core-1.4.8.jar:/opt/app/policy/lib/lombok-1.18.28.jar:/opt/app/policy/lib/lz4-java-1.8.0.jar:/opt/app/policy/lib/mariadb-java-client-3.1.4.jar:/opt/app/policy/lib/maven-artifact-3.8.6.jar:/opt/app/policy/lib/maven-builder-support-3.8.6.jar:/opt/app/policy/lib/maven-compat-3.8.6.jar:/opt/app/policy/lib/maven-core-3.8.6.jar:/opt/app/policy/lib/maven-model-3.8.6.jar:/opt/app/policy/lib/maven-model-builder-3.8.6.jar:/opt/app/policy/lib/maven-plugin-api-3.8.6.jar:/opt/app/policy/lib/maven-repository-metadata-3.8.6.jar:/opt/app/policy/lib/maven-resolver-api-1.6.3.jar:/opt/app/policy/lib/maven-resolver-connector-basic-1.7.3.jar:/opt/app/policy/lib/maven-resolver-impl-1.6.3.jar:/opt/app/policy/lib/maven-resolver-provider-3.8.6.jar:/opt/app/policy/lib/maven-resolver-spi-1.6.3.jar:/opt/app/policy/lib/maven-resolver-transport-file-1.7.3.jar:/opt/app/policy/lib/maven-resolver-transport-http-1.7.3.jar:/opt/app/policy/lib/maven-resolver-transport-wagon-1.7.3.jar:/opt/app/policy/lib/maven-resolver-util-1.6.3.jar:/opt/app/policy/lib/maven-settings-3.8.6.jar:/opt/app/policy/lib/maven-settings-builder-3.8.6.jar:/opt/app/policy/lib/maven-shared-utils-3.3.4.jar:/opt/app/policy/lib/medeia-validator-core-1.1.1.jar:/opt/app/policy/lib/medeia-validator-gson-1.1.1.jar:/opt/app/policy/lib/mvel2-2.5.0.Final.jar:/opt/app/policy/lib/mxparser-1.2.2.jar:/opt/app/policy/lib/org.eclipse.sisu.inject-0.3.5.jar:/opt/app/policy/lib/org.eclipse.sisu.plexus-0.3.5.jar:/opt/app/policy/lib/osgi-resource-locator-1.0.3.jar:/opt/app/policy/lib/plexus-cipher-2.0.jar:/opt/app/policy/lib/plexus-classworlds-2.6.0.jar:/opt/app/policy/lib/plexus-component-annotations-2.1.0.jar:/opt/app/policy/lib/plexus-interpolation-1.26.jar:/opt/app/policy/lib/plexus-sec-dispatcher-2.0.jar:/opt/app/policy/lib/plexus-utils-3.5.0.jar:/opt/app/policy/lib/policy-core-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/policy-domains-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/policy-endpoints-2.1.0.jar:/opt/app/policy/lib/policy-management-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/policy-models-base-3.1.0.jar:/opt/app/policy/lib/policy-models-dao-3.1.0.jar:/opt/app/policy/lib/policy-models-errors-3.1.0.jar:/opt/app/policy/lib/policy-models-examples-3.1.0.jar:/opt/app/policy/lib/policy-models-pdp-3.1.0.jar:/opt/app/policy/lib/policy-models-tosca-3.1.0.jar:/opt/app/policy/lib/policy-utils-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/postgresql-42.6.0.jar:/opt/app/policy/lib/protobuf-java-3.22.0.jar:/opt/app/policy/lib/re2j-1.7.jar:/opt/app/policy/lib/saClientLibrary-1.3.0-oss.jar:/opt/app/policy/lib/saToolkit-1.2.0-oss.jar:/opt/app/policy/lib/simpleclient-0.16.0.jar:/opt/app/policy/lib/simpleclient_common-0.16.0.jar:/opt/app/policy/lib/simpleclient_hotspot-0.16.0.jar:/opt/app/policy/lib/simpleclient_logback-0.16.0.jar:/opt/app/policy/lib/simpleclient_servlet_common-0.16.0.jar:/opt/app/policy/lib/simpleclient_servlet_jakarta-0.16.0.jar:/opt/app/policy/lib/simpleclient_tracer_common-0.16.0.jar:/opt/app/policy/lib/simpleclient_tracer_otel-0.16.0.jar:/opt/app/policy/lib/simpleclient_tracer_otel_agent-0.16.0.jar:/opt/app/policy/lib/slf4j-api-2.0.7.jar:/opt/app/policy/lib/snakeyaml-2.0.jar:/opt/app/policy/lib/snappy-java-1.1.10.4.jar:/opt/app/policy/lib/swagger-annotations-2.2.15.jar:/opt/app/policy/lib/swagger-annotations-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-core-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-integration-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-jaxrs2-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-jaxrs2-servlet-initializer-v2-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-models-jakarta-2.2.15.jar:/opt/app/policy/lib/txw2-4.0.2.jar:/opt/app/policy/lib/utils-2.1.0.jar:/opt/app/policy/lib/waffle-jna-3.2.0.jar:/opt/app/policy/lib/wagon-http-3.5.1.jar:/opt/app/policy/lib/wagon-http-shared-3.5.1.jar:/opt/app/policy/lib/wagon-provider-api-3.5.1.jar:/opt/app/policy/lib/xmlpull-1.1.3.1.jar:/opt/app/policy/lib/xstream-1.4.20.jar:/opt/app/policy/lib/zstd-jni-1.5.5-1.jar policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL) policy-db-migrator | -------------- drools | + source /opt/app/policy/etc/profile.d/env.sh policy-db-migrator | drools | + templateRegex='^\$\{\{POLICY_HOME}}$' policy-db-migrator | drools | + '[' -z /opt/app/policy ] policy-db-migrator | > upgrade 0390-jpatoscarequirement_metadata.sql drools | + set -a policy-db-migrator | -------------- drools | + POLICY_HOME=/opt/app/policy policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | + ls '/opt/app/policy/etc/profile.d/*.conf' policy-db-migrator | -------------- drools | + '[' -d /opt/app/policy/bin ] policy-db-migrator | drools | + : policy-db-migrator | drools | + '[' -d /usr/lib/jvm/java-17-openjdk/bin ] policy-db-migrator | > upgrade 0400-jpatoscarequirement_occurrences.sql drools | + : policy-db-migrator | -------------- drools | + '[' -d /home/policy/bin ] policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL) drools | + set +a policy-db-migrator | -------------- drools | + /opt/app/policy/bin/configure-maven policy-db-migrator | drools | + HOME_M2=/home/policy/.m2 policy-db-migrator | drools | + mkdir -p /home/policy/.m2 policy-db-migrator | > upgrade 0410-jpatoscarequirement_properties.sql drools | + '[' -z http://nexus:8081/nexus/content/repositories/snapshots/ ] policy-db-migrator | -------------- drools | + ln -s -f /opt/app/policy/etc/m2/settings.xml /home/policy/.m2/settings.xml policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) drools | + '[' -f /opt/app/policy/config/system.properties ] policy-db-migrator | -------------- drools | + sed -n -e 's/^[ \t]*\([^ \t#]*\)[ \t]*=[ \t]*\(.*\)$/-D\1=\2/p' /opt/app/policy/config/system.properties policy-db-migrator | drools | + systemProperties='-Dlogback.configurationFile=config/logback.xml' policy-db-migrator | drools | + cd /opt/app/policy policy-db-migrator | > upgrade 0420-jpatoscaservicetemplate_metadata.sql policy-db-migrator | -------------- drools | + exec /usr/lib/jvm/java-17-openjdk/bin/java -server -Xms512m -Xmx512m -cp /opt/app/policy/config:/opt/app/policy/lib::/opt/app/policy/lib/aaf-auth-client-2.7.4.jar:/opt/app/policy/lib/aaf-cadi-aaf-2.7.4.jar:/opt/app/policy/lib/aaf-cadi-client-2.7.4.jar:/opt/app/policy/lib/aaf-cadi-core-2.7.4.jar:/opt/app/policy/lib/aaf-misc-env-2.7.4.jar:/opt/app/policy/lib/aaf-misc-rosetta-2.7.4.jar:/opt/app/policy/lib/accessors-smart-2.4.9.jar:/opt/app/policy/lib/angus-activation-2.0.1.jar:/opt/app/policy/lib/annotations-13.0.jar:/opt/app/policy/lib/ant-1.10.13.jar:/opt/app/policy/lib/ant-launcher-1.10.13.jar:/opt/app/policy/lib/antlr-2.7.7.jar:/opt/app/policy/lib/antlr-runtime-3.5.2.jar:/opt/app/policy/lib/antlr4-runtime-4.10.1.jar:/opt/app/policy/lib/aopalliance-1.0.jar:/opt/app/policy/lib/aopalliance-repackaged-3.0.4.jar:/opt/app/policy/lib/asm-9.3.jar:/opt/app/policy/lib/byte-buddy-1.12.18.jar:/opt/app/policy/lib/caffeine-2.9.3.jar:/opt/app/policy/lib/cambriaClient-1.2.1-oss.jar:/opt/app/policy/lib/capabilities-2.1.0.jar:/opt/app/policy/lib/checker-qual-3.37.0.jar:/opt/app/policy/lib/classgraph-4.8.154.jar:/opt/app/policy/lib/classmate-1.5.1.jar:/opt/app/policy/lib/common-parameters-2.1.0.jar:/opt/app/policy/lib/commons-beanutils-1.9.4.jar:/opt/app/policy/lib/commons-cli-1.5.0.jar:/opt/app/policy/lib/commons-codec-1.16.0.jar:/opt/app/policy/lib/commons-collections4-4.4.jar:/opt/app/policy/lib/commons-configuration2-2.8.0.jar:/opt/app/policy/lib/commons-io-2.13.0.jar:/opt/app/policy/lib/commons-lang3-3.14.0.jar:/opt/app/policy/lib/commons-logging-1.2.jar:/opt/app/policy/lib/commons-net-3.9.0.jar:/opt/app/policy/lib/commons-text-1.10.0.jar:/opt/app/policy/lib/dmaapClient-1.1.12.jar:/opt/app/policy/lib/dme2-3.1.200-oss.jar:/opt/app/policy/lib/dom4j-2.1.3.jar:/opt/app/policy/lib/drools-base-8.44.0.Final.jar:/opt/app/policy/lib/drools-canonical-model-8.44.0.Final.jar:/opt/app/policy/lib/drools-codegen-common-8.44.0.Final.jar:/opt/app/policy/lib/drools-commands-8.44.0.Final.jar:/opt/app/policy/lib/drools-compiler-8.44.0.Final.jar:/opt/app/policy/lib/drools-core-8.44.0.Final.jar:/opt/app/policy/lib/drools-drl-ast-8.44.0.Final.jar:/opt/app/policy/lib/drools-drl-extensions-8.44.0.Final.jar:/opt/app/policy/lib/drools-drl-parser-8.44.0.Final.jar:/opt/app/policy/lib/drools-ecj-8.44.0.Final.jar:/opt/app/policy/lib/drools-engine-8.44.0.Final.jar:/opt/app/policy/lib/drools-io-8.44.0.Final.jar:/opt/app/policy/lib/drools-kiesession-8.44.0.Final.jar:/opt/app/policy/lib/drools-model-codegen-8.44.0.Final.jar:/opt/app/policy/lib/drools-model-compiler-8.44.0.Final.jar:/opt/app/policy/lib/drools-mvel-8.44.0.Final.jar:/opt/app/policy/lib/drools-mvel-compiler-8.44.0.Final.jar:/opt/app/policy/lib/drools-mvel-parser-8.44.0.Final.jar:/opt/app/policy/lib/drools-persistence-api-8.44.0.Final.jar:/opt/app/policy/lib/drools-persistence-jpa-8.44.0.Final.jar:/opt/app/policy/lib/drools-serialization-protobuf-8.44.0.Final.jar:/opt/app/policy/lib/drools-tms-8.44.0.Final.jar:/opt/app/policy/lib/drools-util-8.44.0.Final.jar:/opt/app/policy/lib/drools-wiring-api-8.44.0.Final.jar:/opt/app/policy/lib/drools-wiring-dynamic-8.44.0.Final.jar:/opt/app/policy/lib/drools-wiring-static-8.44.0.Final.jar:/opt/app/policy/lib/drools-xml-support-8.44.0.Final.jar:/opt/app/policy/lib/ecj-3.33.0.jar:/opt/app/policy/lib/error_prone_annotations-2.21.1.jar:/opt/app/policy/lib/failureaccess-1.0.1.jar:/opt/app/policy/lib/feature-lifecycle-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/gson-2.1.0.jar:/opt/app/policy/lib/gson-2.10.1.jar:/opt/app/policy/lib/gson-javatime-serialisers-1.1.2.jar:/opt/app/policy/lib/guava-32.1.3-jre.jar:/opt/app/policy/lib/guice-4.2.2-no_aop.jar:/opt/app/policy/lib/hibernate-commons-annotations-6.0.6.Final.jar:/opt/app/policy/lib/hibernate-core-6.3.0.CR1.jar:/opt/app/policy/lib/hibernate-core-jakarta-5.6.15.Final.jar:/opt/app/policy/lib/hk2-api-3.0.4.jar:/opt/app/policy/lib/hk2-locator-3.0.4.jar:/opt/app/policy/lib/hk2-utils-3.0.4.jar:/opt/app/policy/lib/httpclient-4.5.14.jar:/opt/app/policy/lib/httpclient-cache-4.5.3.jar:/opt/app/policy/lib/httpclient5-5.2.1.jar:/opt/app/policy/lib/httpcore-4.4.15.jar:/opt/app/policy/lib/httpcore5-5.2.2.jar:/opt/app/policy/lib/httpcore5-h2-5.2.jar:/opt/app/policy/lib/istack-commons-runtime-4.1.1.jar:/opt/app/policy/lib/j2objc-annotations-2.8.jar:/opt/app/policy/lib/jackson-annotations-2.15.2.jar:/opt/app/policy/lib/jackson-core-2.15.2.jar:/opt/app/policy/lib/jackson-databind-2.14.1.jar:/opt/app/policy/lib/jackson-dataformat-yaml-2.15.2.jar:/opt/app/policy/lib/jackson-datatype-jsr310-2.15.1.jar:/opt/app/policy/lib/jackson-jakarta-rs-base-2.15.1.jar:/opt/app/policy/lib/jackson-jakarta-rs-json-provider-2.15.1.jar:/opt/app/policy/lib/jackson-module-jakarta-xmlbind-annotations-2.14.1.jar:/opt/app/policy/lib/jackson-module-jaxb-annotations-2.15.2.jar:/opt/app/policy/lib/jakarta.activation-api-2.1.2.jar:/opt/app/policy/lib/jakarta.annotation-api-2.1.1.jar:/opt/app/policy/lib/jakarta.ejb-api-3.2.6.jar:/opt/app/policy/lib/jakarta.el-api-3.0.3.jar:/opt/app/policy/lib/jakarta.enterprise.cdi-api-2.0.2.jar:/opt/app/policy/lib/jakarta.inject-api-2.0.1.MR.jar:/opt/app/policy/lib/jakarta.interceptor-api-1.2.5.jar:/opt/app/policy/lib/jakarta.persistence-api-3.1.0.jar:/opt/app/policy/lib/jakarta.servlet-api-6.0.0.jar:/opt/app/policy/lib/jakarta.transaction-api-2.0.1.jar:/opt/app/policy/lib/jakarta.validation-api-3.0.2.jar:/opt/app/policy/lib/jakarta.ws.rs-api-3.1.0.jar:/opt/app/policy/lib/jakarta.xml.bind-api-4.0.0.jar:/opt/app/policy/lib/jandex-2.4.2.Final.jar:/opt/app/policy/lib/jandex-3.1.2.jar:/opt/app/policy/lib/javaparser-core-3.24.2.jar:/opt/app/policy/lib/javassist-3.26.0-GA.jar:/opt/app/policy/lib/javax.activation-api-1.2.0.jar:/opt/app/policy/lib/javax.inject-1.jar:/opt/app/policy/lib/javax.servlet-api-3.1.0.jar:/opt/app/policy/lib/javax.ws.rs-api-2.0.1.jar:/opt/app/policy/lib/jaxb-api-2.3.1.jar:/opt/app/policy/lib/jaxb-core-4.0.2.jar:/opt/app/policy/lib/jaxb-core-4.0.3.jar:/opt/app/policy/lib/jaxb-impl-4.0.3.jar:/opt/app/policy/lib/jaxb-runtime-4.0.2.jar:/opt/app/policy/lib/jaxb-xjc-4.0.3.jar:/opt/app/policy/lib/jboss-logging-3.5.0.Final.jar:/opt/app/policy/lib/jcl-over-slf4j-1.7.30.jar:/opt/app/policy/lib/jersey-client-3.1.3.jar:/opt/app/policy/lib/jersey-common-3.1.3.jar:/opt/app/policy/lib/jersey-container-servlet-3.1.3.jar:/opt/app/policy/lib/jersey-container-servlet-core-3.1.3.jar:/opt/app/policy/lib/jersey-entity-filtering-3.1.3.jar:/opt/app/policy/lib/jersey-hk2-3.1.3.jar:/opt/app/policy/lib/jersey-media-json-jackson-3.1.3.jar:/opt/app/policy/lib/jersey-server-3.1.3.jar:/opt/app/policy/lib/jetty-http-11.0.18.jar:/opt/app/policy/lib/jetty-io-11.0.18.jar:/opt/app/policy/lib/jetty-jakarta-servlet-api-5.0.2.jar:/opt/app/policy/lib/jetty-security-11.0.18.jar:/opt/app/policy/lib/jetty-server-11.0.18.jar:/opt/app/policy/lib/jetty-servlet-11.0.12.jar:/opt/app/policy/lib/jetty-util-11.0.18.jar:/opt/app/policy/lib/jline-2.12.1.jar:/opt/app/policy/lib/jna-5.12.1.jar:/opt/app/policy/lib/jna-platform-5.12.1.jar:/opt/app/policy/lib/json-20231013.jar:/opt/app/policy/lib/json-path-2.8.0.jar:/opt/app/policy/lib/json-smart-2.4.10.jar:/opt/app/policy/lib/jsr305-3.0.2.jar:/opt/app/policy/lib/kafka-clients-3.6.0.jar:/opt/app/policy/lib/kie-api-8.44.0.Final.jar:/opt/app/policy/lib/kie-ci-8.44.0.Final.jar:/opt/app/policy/lib/kie-internal-8.44.0.Final.jar:/opt/app/policy/lib/kie-memory-compiler-8.44.0.Final.jar:/opt/app/policy/lib/kie-util-maven-integration-8.44.0.Final.jar:/opt/app/policy/lib/kie-util-maven-support-8.44.0.Final.jar:/opt/app/policy/lib/kie-util-xml-8.44.0.Final.jar:/opt/app/policy/lib/kotlin-reflect-1.3.20.jar:/opt/app/policy/lib/kotlin-stdlib-1.3.20.jar:/opt/app/policy/lib/kotlin-stdlib-common-1.3.20.jar:/opt/app/policy/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/opt/app/policy/lib/logback-classic-1.4.8.jar:/opt/app/policy/lib/logback-core-1.4.8.jar:/opt/app/policy/lib/lombok-1.18.28.jar:/opt/app/policy/lib/lz4-java-1.8.0.jar:/opt/app/policy/lib/mariadb-java-client-3.1.4.jar:/opt/app/policy/lib/maven-artifact-3.8.6.jar:/opt/app/policy/lib/maven-builder-support-3.8.6.jar:/opt/app/policy/lib/maven-compat-3.8.6.jar:/opt/app/policy/lib/maven-core-3.8.6.jar:/opt/app/policy/lib/maven-model-3.8.6.jar:/opt/app/policy/lib/maven-model-builder-3.8.6.jar:/opt/app/policy/lib/maven-plugin-api-3.8.6.jar:/opt/app/policy/lib/maven-repository-metadata-3.8.6.jar:/opt/app/policy/lib/maven-resolver-api-1.6.3.jar:/opt/app/policy/lib/maven-resolver-connector-basic-1.7.3.jar:/opt/app/policy/lib/maven-resolver-impl-1.6.3.jar:/opt/app/policy/lib/maven-resolver-provider-3.8.6.jar:/opt/app/policy/lib/maven-resolver-spi-1.6.3.jar:/opt/app/policy/lib/maven-resolver-transport-file-1.7.3.jar:/opt/app/policy/lib/maven-resolver-transport-http-1.7.3.jar:/opt/app/policy/lib/maven-resolver-transport-wagon-1.7.3.jar:/opt/app/policy/lib/maven-resolver-util-1.6.3.jar:/opt/app/policy/lib/maven-settings-3.8.6.jar:/opt/app/policy/lib/maven-settings-builder-3.8.6.jar:/opt/app/policy/lib/maven-shared-utils-3.3.4.jar:/opt/app/policy/lib/medeia-validator-core-1.1.1.jar:/opt/app/policy/lib/medeia-validator-gson-1.1.1.jar:/opt/app/policy/lib/mvel2-2.5.0.Final.jar:/opt/app/policy/lib/mxparser-1.2.2.jar:/opt/app/policy/lib/org.eclipse.sisu.inject-0.3.5.jar:/opt/app/policy/lib/org.eclipse.sisu.plexus-0.3.5.jar:/opt/app/policy/lib/osgi-resource-locator-1.0.3.jar:/opt/app/policy/lib/plexus-cipher-2.0.jar:/opt/app/policy/lib/plexus-classworlds-2.6.0.jar:/opt/app/policy/lib/plexus-component-annotations-2.1.0.jar:/opt/app/policy/lib/plexus-interpolation-1.26.jar:/opt/app/policy/lib/plexus-sec-dispatcher-2.0.jar:/opt/app/policy/lib/plexus-utils-3.5.0.jar:/opt/app/policy/lib/policy-core-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/policy-domains-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/policy-endpoints-2.1.0.jar:/opt/app/policy/lib/policy-management-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/policy-models-base-3.1.0.jar:/opt/app/policy/lib/policy-models-dao-3.1.0.jar:/opt/app/policy/lib/policy-models-errors-3.1.0.jar:/opt/app/policy/lib/policy-models-examples-3.1.0.jar:/opt/app/policy/lib/policy-models-pdp-3.1.0.jar:/opt/app/policy/lib/policy-models-tosca-3.1.0.jar:/opt/app/policy/lib/policy-utils-2.1.0-SNAPSHOT.jar:/opt/app/policy/lib/postgresql-42.6.0.jar:/opt/app/policy/lib/protobuf-java-3.22.0.jar:/opt/app/policy/lib/re2j-1.7.jar:/opt/app/policy/lib/saClientLibrary-1.3.0-oss.jar:/opt/app/policy/lib/saToolkit-1.2.0-oss.jar:/opt/app/policy/lib/simpleclient-0.16.0.jar:/opt/app/policy/lib/simpleclient_common-0.16.0.jar:/opt/app/policy/lib/simpleclient_hotspot-0.16.0.jar:/opt/app/policy/lib/simpleclient_logback-0.16.0.jar:/opt/app/policy/lib/simpleclient_servlet_common-0.16.0.jar:/opt/app/policy/lib/simpleclient_servlet_jakarta-0.16.0.jar:/opt/app/policy/lib/simpleclient_tracer_common-0.16.0.jar:/opt/app/policy/lib/simpleclient_tracer_otel-0.16.0.jar:/opt/app/policy/lib/simpleclient_tracer_otel_agent-0.16.0.jar:/opt/app/policy/lib/slf4j-api-2.0.7.jar:/opt/app/policy/lib/snakeyaml-2.0.jar:/opt/app/policy/lib/snappy-java-1.1.10.4.jar:/opt/app/policy/lib/swagger-annotations-2.2.15.jar:/opt/app/policy/lib/swagger-annotations-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-core-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-integration-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-jaxrs2-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-jaxrs2-servlet-initializer-v2-jakarta-2.2.15.jar:/opt/app/policy/lib/swagger-models-jakarta-2.2.15.jar:/opt/app/policy/lib/txw2-4.0.2.jar:/opt/app/policy/lib/utils-2.1.0.jar:/opt/app/policy/lib/waffle-jna-3.2.0.jar:/opt/app/policy/lib/wagon-http-3.5.1.jar:/opt/app/policy/lib/wagon-http-shared-3.5.1.jar:/opt/app/policy/lib/wagon-provider-api-3.5.1.jar:/opt/app/policy/lib/xmlpull-1.1.3.1.jar:/opt/app/policy/lib/xstream-1.4.20.jar:/opt/app/policy/lib/zstd-jni-1.5.5-1.jar '-Dlogback.configurationFile=config/logback.xml' org.onap.policy.drools.system.Main policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) drools | Dec 11, 2023 4:19:27 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.SwaggerApi cannot be instantiated and will be ignored. policy-db-migrator | drools | Dec 11, 2023 4:19:27 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.TopicsApi cannot be instantiated and will be ignored. policy-db-migrator | > upgrade 0430-jpatoscatopologytemplate_inputs.sql drools | Dec 11, 2023 4:19:27 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.LegacyApi cannot be instantiated and will be ignored. policy-db-migrator | CREATE TABLE IF NOT EXISTS jpatoscatopologytemplate_inputs (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, INPUTS LONGBLOB DEFAULT NULL, INPUTS_KEY VARCHAR(255) NULL) drools | Dec 11, 2023 4:19:27 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.LifecycleApi cannot be instantiated and will be ignored. policy-db-migrator | drools | Dec 11, 2023 4:19:27 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.SwitchesApi cannot be instantiated and will be ignored. policy-db-migrator | > upgrade 0440-pdpgroup_pdpsubgroup.sql drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.EnvironmentApi cannot be instantiated and will be ignored. policy-db-migrator | CREATE TABLE IF NOT EXISTS pdpgroup_pdpsubgroup (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDPGROUP_PDPSUBGROUP (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName)) drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.ToolsApi cannot be instantiated and will be ignored. policy-db-migrator | drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.PropertiesApi cannot be instantiated and will be ignored. policy-db-migrator | > upgrade 0450-pdpgroup.sql drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.ControllersApi cannot be instantiated and will be ignored. policy-db-migrator | CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_PDPGROUP (name, version)) drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.DefaultApi cannot be instantiated and will be ignored. policy-db-migrator | drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.InputsApi cannot be instantiated and will be ignored. policy-db-migrator | > upgrade 0460-pdppolicystatus.sql drools | Dec 11, 2023 4:19:28 PM org.glassfish.jersey.server.ResourceModelConfigurator bindProvidersAndResources policy-db-migrator | -------------- drools | WARNING: Component of class interface org.onap.policy.drools.server.restful.FeaturesApi cannot be instantiated and will be ignored. policy-db-migrator | CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BOOLEAN DEFAULT 0, PDPGROUP VARCHAR(255) DEFAULT NULL, PDPTYPE VARCHAR(255) DEFAULT NULL, STATE INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PRIMARY KEY PK_PDPPOLICYSTATUS (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0470-pdp.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS pdp (HEALTHY INT DEFAULT NULL, MESSAGE VARCHAR(255) DEFAULT NULL, PDPSTATE INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDP (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0480-pdpstatistics.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS pdpstatistics (PDPGROUPNAME VARCHAR(120) NULL, PDPSUBGROUPNAME VARCHAR(120) NULL, POLICYDEPLOYCOUNT BIGINT DEFAULT NULL, POLICYDEPLOYFAILCOUNT BIGINT DEFAULT NULL, POLICYDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL, POLICYEXECUTEDCOUNT BIGINT DEFAULT NULL, POLICYEXECUTEDFAILCOUNT BIGINT DEFAULT NULL, POLICYEXECUTEDSUCCESSCOUNT BIGINT DEFAULT NULL, timeStamp datetime NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_PDPSTATISTICS (timeStamp, name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0490-pdpsubgroup_pdp.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS pdpsubgroup_pdp (pdpParentKeyName VARCHAR(120) NOT NULL, pdpParentKeyVersion VARCHAR(15) NOT NULL, pdpParentLocalName VARCHAR(120) NOT NULL, pdpLocalName VARCHAR(120) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDPSUBGROUP_PDP (pdpParentKeyName, pdpParentKeyVersion, pdpParentLocalName, pdpLocalName, parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0500-pdpsubgroup.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS pdpsubgroup (CURRENTINSTANCECOUNT INT DEFAULT NULL, DESIREDINSTANCECOUNT INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDPSUBGROUP (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0510-toscacapabilityassignment.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscacapabilityassignment (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, PRIMARY KEY PK_TOSCACAPABILITYASSIGNMENT(name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0520-toscacapabilityassignments.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCACAPABILITYASSIGNMENTS (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscacapabilityassignments_toscacapabilityassignment (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCACAPABILITYASSIGNMENTS_TOSCACAPABILITYASSIGNMENT (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0540-toscacapabilitytype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscacapabilitytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCACAPABILITYTYPE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0550-toscacapabilitytypes.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCACAPABILITYTYPES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscacapabilitytypes_toscacapabilitytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCACAPABILITYTYPES_TOSCACAPABILITYTYPE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0570-toscadatatype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscadatatype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCADATATYPE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0580-toscadatatypes.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCADATATYPES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0590-toscadatatypes_toscadatatype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCADATATYPES_TOSCADATATYPE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0600-toscanodetemplate.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscanodetemplate (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, capabilitiesName VARCHAR(120) NULL, capabilitiesVersion VARCHAR(20) NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, PRIMARY KEY PK_TOSCANODETEMPLATE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0610-toscanodetemplates.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCANODETEMPLATES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0620-toscanodetemplates_toscanodetemplate.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscanodetemplates_toscanodetemplate (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCANODETEMPLATES_TOSCANODETEMPLATE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0630-toscanodetype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscanodetype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, PRIMARY KEY PK_TOSCANODETYPE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0640-toscanodetypes.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCANODETYPES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0650-toscanodetypes_toscanodetype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscanodetypes_toscanodetype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCANODETYPES_TOSCANODETYPE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0660-toscaparameter.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscaparameter (VALUE VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCAPARAMETER (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0670-toscapolicies.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAPOLICIES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0680-toscapolicies_toscapolicy.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscapolicies_toscapolicy (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCAPOLICIES_TOSCAPOLICY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0690-toscapolicy.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscapolicy (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, PRIMARY KEY PK_TOSCAPOLICY (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0700-toscapolicytype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscapolicytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAPOLICYTYPE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0710-toscapolicytypes.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAPOLICYTYPES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0720-toscapolicytypes_toscapolicytype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscapolicytypes_toscapolicytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCAPOLICYTYPES_TOSCAPOLICYTYPE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0730-toscaproperty.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscaproperty (DEFAULTVALUE VARCHAR(255) DEFAULT NULL, `DESCRIPTION` VARCHAR(255) DEFAULT NULL, ENTRYSCHEMA LONGBLOB DEFAULT NULL, REQUIRED BOOLEAN DEFAULT 0, STATUS INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PRIMARY KEY PK_TOSCAPROPERTY (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0740-toscarelationshiptype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscarelationshiptype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCARELATIONSHIPTYPE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0750-toscarelationshiptypes.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCARELATIONSHIPTYPES (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscarelationshiptypes_toscarelationshiptype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCARELATIONSHIPTYPES_TOSCARELATIONSHIPTYPE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0770-toscarequirement.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscarequirement (CAPABILITY VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, NODE VARCHAR(255) NULL, RELATIONSHIP VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, PRIMARY KEY PK_TOSCAREQUIREMENT (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0780-toscarequirements.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAREQUIREMENTS (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0790-toscarequirements_toscarequirement.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscarequirements_toscarequirement (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PRIMARY KEY PK_TOSCAREQUIREMENTS_TOSCAREQUIREMENT (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0800-toscaservicetemplate.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscaservicetemplate (`DESCRIPTION` VARCHAR(255) NULL, TOSCADEFINITIONSVERSION VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, capabilityTypesVersion VARCHAR(20) NULL, capabilityTypesName VARCHAR(120) NULL, dataTypesName VARCHAR(120) NULL, dataTypesVersion VARCHAR(20) NULL, nodeTypesVersion VARCHAR(20) NULL, nodeTypesName VARCHAR(120) NULL, policyTypesName VARCHAR(120) NULL, policyTypesVersion VARCHAR(20) NULL, relationshipTypesVersion VARCHAR(20) NULL, relationshipTypesName VARCHAR(120) NULL, topologyTemplateLocalName VARCHAR(120) NULL, topologyTemplateParentKeyName VARCHAR(120) NULL, topologyTemplateParentKeyVersion VARCHAR(15) NULL, topologyTemplateParentLocalName VARCHAR(120) NULL, PRIMARY KEY PK_TOSCASERVICETEMPLATE (name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0810-toscatopologytemplate.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscatopologytemplate (`description` VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, nodeTemplatessVersion VARCHAR(20) NULL, nodeTemplatesName VARCHAR(120) NULL, policyVersion VARCHAR(20) NULL, policyName VARCHAR(120) NULL, PRIMARY KEY PK_TOSCATOPOLOGYTEMPLATE (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0820-toscatrigger.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS toscatrigger (ACTION VARCHAR(255) NULL, toscaCondition LONGBLOB DEFAULT NULL, toscaConstraint LONGBLOB DEFAULT NULL, `DESCRIPTION` VARCHAR(255) NULL, EVALUATIONS INT DEFAULT NULL, EVENTTYPE VARCHAR(255) NULL, METHOD VARCHAR(255) NULL, `PERIOD` LONGBLOB DEFAULT NULL, SCHEDULE LONGBLOB DEFAULT NULL, TARGETFILTER LONGBLOB DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_TOSCATRIGGER (parentLocalName, localName, parentKeyVersion, parentKeyName)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0850-FK_ToscaNodeType_requirementsName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0940-PdpPolicyStatus_PdpGroup.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0980-FK_ToscaNodeType_requirementsName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0100-pdp.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0110-idx_tsidx1.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0120-pk_pdpstatistics.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdpstatistics DROP PRIMARY KEY policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0130-pdpstatistics.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL, ADD COLUMN ID BIGINT NOT NULL policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0140-pk_pdpstatistics.sql policy-db-migrator | -------------- policy-db-migrator | UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0150-pdpstatistics.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0160-jpapdpstatistics_enginestats.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL AFTER UPTIME policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0170-jpapdpstatistics_enginestats.sql policy-db-migrator | -------------- policy-db-migrator | UPDATE jpapdpstatistics_enginestats a policy-db-migrator | JOIN pdpstatistics b policy-db-migrator | ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp policy-db-migrator | SET a.id = b.id policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0180-jpapdpstatistics_enginestats.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0190-jpapolicyaudit.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS jpapolicyaudit (ACTION INT DEFAULT NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_JPAPOLICYAUDIT (ID, name, version)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0210-sequence.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL, PRIMARY KEY PK_SEQUENCE (SEQ_NAME)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0220-sequence.sql policy-db-migrator | -------------- policy-db-migrator | INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0100-jpatoscapolicy_targets.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpatoscapolicy_targets ADD COLUMN toscaPolicyName VARCHAR(120) NOT NULL, ADD COLUMN toscaPolicyVersion VARCHAR(20) NOT NULL, ADD CONSTRAINT PK_JPATOSCAPOLICY_TARGETS PRIMARY KEY (toscaPolicyName, toscaPolicyVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0110-jpatoscapolicytype_targets.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpatoscapolicytype_targets ADD COLUMN toscaPolicyTypeName VARCHAR(120) NOT NULL, ADD COLUMN toscaPolicyTypeVersion VARCHAR(20) NOT NULL, ADD CONSTRAINT PK_JPATOSCAPOLICYTYPE_TARGETS PRIMARY KEY (toscaPolicyTypeName, toscaPolicyTypeVersion) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0120-toscatrigger.sql policy-db-migrator | -------------- policy-db-migrator | DROP TABLE IF EXISTS toscatrigger policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0130-jpatoscapolicytype_triggers.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpatoscapolicytype_triggers MODIFY COLUMN triggers LONGBLOB policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0140-toscaparameter.sql policy-db-migrator | -------------- policy-db-migrator | DROP TABLE IF EXISTS toscaparameter policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0150-toscaproperty.sql policy-db-migrator | -------------- policy-db-migrator | DROP TABLE IF EXISTS jpatoscaproperty_constraints policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | DROP TABLE IF EXISTS jpatoscaproperty_metadata policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | DROP TABLE IF EXISTS toscaproperty policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0160-jpapolicyaudit_pk.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpapolicyaudit DROP PRIMARY KEY policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0170-pdpstatistics_pk.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdpstatistics DROP PRIMARY KEY policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0180-jpatoscanodetemplate_metadata.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpatoscanodetemplate_metadata MODIFY COLUMN METADATA LONGTEXT policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0100-upgrade.sql policy-db-migrator | -------------- policy-db-migrator | select 'upgrade to 1100 completed' as msg policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | msg policy-db-migrator | upgrade to 1100 completed policy-db-migrator | policy-db-migrator | > upgrade 0100-jpapolicyaudit_renameuser.sql policy-db-migrator | -------------- policy-db-migrator | ALTER TABLE jpapolicyaudit RENAME COLUMN USER TO USERNAME policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0110-idx_tsidx1.sql policy-db-migrator | -------------- policy-db-migrator | DROP INDEX IDX_TSIDX1 ON pdpstatistics policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | CREATE INDEX IDXTSIDX1 ON pdpstatistics(timeStamp, name, version) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0120-audit_sequence.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS audit_sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL, PRIMARY KEY PK_SEQUENCE (SEQ_NAME)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | INSERT INTO audit_sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM jpapolicyaudit)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0130-statistics_sequence.sql policy-db-migrator | -------------- policy-db-migrator | CREATE TABLE IF NOT EXISTS statistics_sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL, PRIMARY KEY PK_SEQUENCE (SEQ_NAME)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | INSERT INTO statistics_sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | TRUNCATE TABLE sequence policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0100-pdpstatistics.sql policy-db-migrator | -------------- policy-db-migrator | DROP INDEX IDXTSIDX1 ON pdpstatistics policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | -------------- policy-db-migrator | DROP TABLE pdpstatistics policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0110-jpapdpstatistics_enginestats.sql policy-db-migrator | -------------- policy-db-migrator | DROP TABLE jpapdpstatistics_enginestats policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policy-db-migrator | > upgrade 0120-statistics_sequence.sql policy-db-migrator | -------------- policy-db-migrator | DROP TABLE statistics_sequence policy-db-migrator | -------------- policy-db-migrator | policy-db-migrator | policyadmin: OK: upgrade (1300) policy-db-migrator | name version policy-db-migrator | policyadmin 1300 policy-db-migrator | ID script operation from_version to_version tag success atTime policy-db-migrator | 1 0100-jpapdpgroup_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:25 policy-db-migrator | 2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:25 policy-db-migrator | 3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:25 policy-db-migrator | 4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:26 policy-db-migrator | 27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 36 0450-pdpgroup.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 37 0460-pdppolicystatus.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 38 0470-pdp.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 39 0480-pdpstatistics.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 41 0500-pdpsubgroup.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 42 0510-toscacapabilityassignment.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 43 0520-toscacapabilityassignments.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 45 0540-toscacapabilitytype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 46 0550-toscacapabilitytypes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 48 0570-toscadatatype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 49 0580-toscadatatypes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:27 policy-db-migrator | 50 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 51 0600-toscanodetemplate.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 52 0610-toscanodetemplates.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 53 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 54 0630-toscanodetype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 55 0640-toscanodetypes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 57 0660-toscaparameter.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 58 0670-toscapolicies.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 59 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 60 0690-toscapolicy.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 61 0700-toscapolicytype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 62 0710-toscapolicytypes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 63 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 64 0730-toscaproperty.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 65 0740-toscarelationshiptype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 66 0750-toscarelationshiptypes.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 67 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 68 0770-toscarequirement.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 69 0780-toscarequirements.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 70 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 71 0800-toscaservicetemplate.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 72 0810-toscatopologytemplate.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 73 0820-toscatrigger.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 74 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:28 policy-db-migrator | 75 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 76 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 77 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 78 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 79 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 80 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 82 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 84 0940-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 85 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 86 0960-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 87 0970-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 88 0980-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 89 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 90 1000-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 91 1010-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 92 1020-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:29 policy-db-migrator | 93 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:30 policy-db-migrator | 94 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:30 policy-db-migrator | 95 1050-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:30 policy-db-migrator | 96 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1112231619250800u 1 2023-12-11 16:19:30 policy-db-migrator | 97 0100-pdp.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 98 0110-idx_tsidx1.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 99 0120-pk_pdpstatistics.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 100 0130-pdpstatistics.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 101 0140-pk_pdpstatistics.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 102 0150-pdpstatistics.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 103 0160-jpapdpstatistics_enginestats.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 104 0170-jpapdpstatistics_enginestats.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 105 0180-jpapdpstatistics_enginestats.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 106 0190-jpapolicyaudit.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 107 0200-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 108 0210-sequence.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 109 0220-sequence.sql upgrade 0800 0900 1112231619250900u 1 2023-12-11 16:19:30 policy-db-migrator | 110 0100-jpatoscapolicy_targets.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:30 policy-db-migrator | 111 0110-jpatoscapolicytype_targets.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:30 policy-db-migrator | 112 0120-toscatrigger.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:30 policy-db-migrator | 113 0130-jpatoscapolicytype_triggers.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:31 policy-db-migrator | 114 0140-toscaparameter.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:31 policy-db-migrator | 115 0150-toscaproperty.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:31 policy-db-migrator | 116 0160-jpapolicyaudit_pk.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:31 policy-db-migrator | 117 0170-pdpstatistics_pk.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:31 policy-db-migrator | 118 0180-jpatoscanodetemplate_metadata.sql upgrade 0900 1000 1112231619251000u 1 2023-12-11 16:19:31 policy-db-migrator | 119 0100-upgrade.sql upgrade 1000 1100 1112231619251100u 1 2023-12-11 16:19:31 policy-db-migrator | 120 0100-jpapolicyaudit_renameuser.sql upgrade 1100 1200 1112231619251200u 1 2023-12-11 16:19:31 policy-db-migrator | 121 0110-idx_tsidx1.sql upgrade 1100 1200 1112231619251200u 1 2023-12-11 16:19:31 policy-db-migrator | 122 0120-audit_sequence.sql upgrade 1100 1200 1112231619251200u 1 2023-12-11 16:19:31 policy-db-migrator | 123 0130-statistics_sequence.sql upgrade 1100 1200 1112231619251200u 1 2023-12-11 16:19:31 policy-db-migrator | 124 0100-pdpstatistics.sql upgrade 1200 1300 1112231619251300u 1 2023-12-11 16:19:31 policy-db-migrator | 125 0110-jpapdpstatistics_enginestats.sql upgrade 1200 1300 1112231619251300u 1 2023-12-11 16:19:31 policy-db-migrator | 126 0120-statistics_sequence.sql upgrade 1200 1300 1112231619251300u 1 2023-12-11 16:19:31 policy-db-migrator | policyadmin: OK @ 1300 ++ echo 'Tearing down containers...' Tearing down containers... ++ docker-compose down -v --remove-orphans Stopping drools ... Stopping policy-pap ... Stopping policy-api ... Stopping simulator ... Stopping mariadb ... Stopping drools ... done Stopping policy-pap ... done Stopping mariadb ... done Stopping simulator ... done Stopping policy-api ... done Removing drools ... Removing policy-pap ... Removing policy-api ... Removing policy-db-migrator ... Removing simulator ... Removing mariadb ... Removing policy-api ... done Removing policy-db-migrator ... done Removing drools ... done Removing simulator ... done Removing mariadb ... done Removing policy-pap ... done Removing network compose_default ++ cd /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp + load_set + _setopts=hxB ++ echo braceexpand:hashall:interactive-comments:xtrace ++ tr : ' ' + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o braceexpand + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o hashall + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o interactive-comments + for i in $(echo "${SHELLOPTS}" | tr ':' ' ') + set +o xtrace ++ echo hxB ++ sed 's/./& /g' + for i in $(echo "$_setopts" | sed 's/./& /g') + set +h + for i in $(echo "$_setopts" | sed 's/./& /g') + set +x + [[ -n /tmp/tmp.7B5x1vYVT6 ]] + rsync -av /tmp/tmp.7B5x1vYVT6/ /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/csit/archives/drools-pdp sending incremental file list ./ log.html output.xml report.html testplan.txt sent 502,056 bytes received 95 bytes 1,004,302.00 bytes/sec total size is 501,623 speedup is 1.00 + rm -rf /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/models + exit 0 $ ssh-agent -k unset SSH_AUTH_SOCK; unset SSH_AGENT_PID; echo Agent pid 2101 killed; [ssh-agent] Stopped. Robot results publisher started... -Parsing output xml: Done! WARNING! Could not find file: **/log.html WARNING! Could not find file: **/report.html -Copying log files to build dir: Done! -Assigning results to build: Done! -Checking thresholds: Done! Done publishing Robot results. [PostBuildScript] - [INFO] Executing post build scripts. [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins984497080936779450.sh ---> sysstat.sh [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins2404393394731754754.sh ---> package-listing.sh ++ facter osfamily ++ tr '[:upper:]' '[:lower:]' + OS_FAMILY=debian + workspace=/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp + START_PACKAGES=/tmp/packages_start.txt + END_PACKAGES=/tmp/packages_end.txt + DIFF_PACKAGES=/tmp/packages_diff.txt + PACKAGES=/tmp/packages_start.txt + '[' /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ']' + PACKAGES=/tmp/packages_end.txt + case "${OS_FAMILY}" in + dpkg -l + grep '^ii' + '[' -f /tmp/packages_start.txt ']' + '[' -f /tmp/packages_end.txt ']' + diff /tmp/packages_start.txt /tmp/packages_end.txt + '[' /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp ']' + mkdir -p /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/archives/ + cp -f /tmp/packages_diff.txt /tmp/packages_end.txt /tmp/packages_start.txt /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/archives/ [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins11030201874522705406.sh ---> capture-instance-metadata.sh Setup pyenv: system 3.8.13 3.9.13 * 3.10.6 (set by /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/.python-version) lf-activate-venv(): INFO: Reuse venv:/tmp/venv-04rM from file:/tmp/.os_lf_venv lf-activate-venv(): INFO: Installing: lftools lf-activate-venv(): INFO: Adding /tmp/venv-04rM/bin to PATH INFO: Running in OpenStack, capturing instance metadata [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins10163601705454022476.sh provisioning config files... copy managed file [jenkins-log-archives-settings] to file:/w/workspace/policy-drools-pdp-master-project-csit-drools-pdp@tmp/config6911442396899727284tmp Regular expression run condition: Expression=[^.*logs-s3.*], Label=[] Run condition [Regular expression match] preventing perform for step [Provide Configuration files] [EnvInject] - Injecting environment variables from a build step. [EnvInject] - Injecting as environment variables the properties content SERVER_ID=logs [EnvInject] - Variables injected successfully. [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins16980867022805275863.sh ---> create-netrc.sh [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins13261533116404831474.sh ---> python-tools-install.sh Setup pyenv: system 3.8.13 3.9.13 * 3.10.6 (set by /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/.python-version) lf-activate-venv(): INFO: Reuse venv:/tmp/venv-04rM from file:/tmp/.os_lf_venv lf-activate-venv(): INFO: Installing: lftools lf-activate-venv(): INFO: Adding /tmp/venv-04rM/bin to PATH [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins6926023861864819465.sh ---> sudo-logs.sh Archiving 'sudo' log.. [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash /tmp/jenkins2979322077755802500.sh ---> job-cost.sh Setup pyenv: system 3.8.13 3.9.13 * 3.10.6 (set by /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/.python-version) lf-activate-venv(): INFO: Reuse venv:/tmp/venv-04rM from file:/tmp/.os_lf_venv lf-activate-venv(): INFO: Installing: zipp==1.1.0 python-openstackclient urllib3~=1.26.15 ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts. lftools 0.37.8 requires openstacksdk<1.5.0, but you have openstacksdk 2.0.0 which is incompatible. lf-activate-venv(): INFO: Adding /tmp/venv-04rM/bin to PATH INFO: No Stack... INFO: Retrieving Pricing Info for: v3-standard-8 INFO: Archiving Costs [policy-drools-pdp-master-project-csit-drools-pdp] $ /bin/bash -l /tmp/jenkins16219552561635910039.sh ---> logs-deploy.sh Setup pyenv: system 3.8.13 3.9.13 * 3.10.6 (set by /w/workspace/policy-drools-pdp-master-project-csit-drools-pdp/.python-version) lf-activate-venv(): INFO: Reuse venv:/tmp/venv-04rM from file:/tmp/.os_lf_venv lf-activate-venv(): INFO: Installing: lftools ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts. python-openstackclient 6.4.0 requires openstacksdk>=2.0.0, but you have openstacksdk 1.4.0 which is incompatible. lf-activate-venv(): INFO: Adding /tmp/venv-04rM/bin to PATH INFO: Nexus URL https://nexus.onap.org path production/vex-yul-ecomp-jenkins-1/policy-drools-pdp-master-project-csit-drools-pdp/1430 INFO: archiving workspace using pattern(s): -p **/target/surefire-reports/*-output.txt Archives upload complete. INFO: archiving logs to Nexus ---> uname -a: Linux prd-ubuntu1804-docker-8c-8g-4308 4.15.0-192-generic #203-Ubuntu SMP Wed Aug 10 17:40:03 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux ---> lscpu: Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 8 On-line CPU(s) list: 0-7 Thread(s) per core: 1 Core(s) per socket: 1 Socket(s): 8 NUMA node(s): 1 Vendor ID: AuthenticAMD CPU family: 23 Model: 49 Model name: AMD EPYC-Rome Processor Stepping: 0 CPU MHz: 2800.000 BogoMIPS: 5600.00 Virtualization: AMD-V Hypervisor vendor: KVM Virtualization type: full L1d cache: 32K L1i cache: 32K L2 cache: 512K L3 cache: 16384K NUMA node0 CPU(s): 0-7 Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm rep_good nopl xtopology cpuid extd_apicid tsc_known_freq pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy svm cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw topoext perfctr_core ssbd ibrs ibpb stibp vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 xsaves clzero xsaveerptr arat npt nrip_save umip rdpid arch_capabilities ---> nproc: 8 ---> df -h: Filesystem Size Used Avail Use% Mounted on udev 16G 0 16G 0% /dev tmpfs 3.2G 708K 3.2G 1% /run /dev/vda1 155G 13G 143G 8% / tmpfs 16G 0 16G 0% /dev/shm tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 16G 0 16G 0% /sys/fs/cgroup /dev/vda15 105M 4.4M 100M 5% /boot/efi tmpfs 3.2G 0 3.2G 0% /run/user/1001 ---> free -m: total used free shared buff/cache available Mem: 32167 836 26866 0 4463 30874 Swap: 1023 0 1023 ---> ip addr: 1: lo: mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: ens3: mtu 1458 qdisc mq state UP group default qlen 1000 link/ether fa:16:3e:13:55:e1 brd ff:ff:ff:ff:ff:ff inet 10.30.106.217/23 brd 10.30.107.255 scope global dynamic ens3 valid_lft 86054sec preferred_lft 86054sec inet6 fe80::f816:3eff:fe13:55e1/64 scope link valid_lft forever preferred_lft forever 3: docker0: mtu 1500 qdisc noqueue state DOWN group default link/ether 02:42:47:a7:a8:0f brd ff:ff:ff:ff:ff:ff inet 10.250.0.254/24 brd 10.250.0.255 scope global docker0 valid_lft forever preferred_lft forever ---> sar -b -r -n DEV: Linux 4.15.0-192-generic (prd-ubuntu1804-docker-8c-8g-4308) 12/11/23 _x86_64_ (8 CPU) 16:15:53 LINUX RESTART (8 CPU) 16:16:01 tps rtps wtps bread/s bwrtn/s 16:17:01 122.77 73.06 49.71 5247.28 43665.17 16:18:01 109.19 27.07 82.12 2068.39 15385.78 16:19:01 125.43 10.85 114.58 1693.72 22602.50 16:20:01 268.00 12.75 255.25 813.10 78374.93 16:21:10 39.42 1.23 38.19 93.40 6894.50 Average: 130.18 24.42 105.76 1936.34 32628.44 16:16:01 kbmemfree kbavail kbmemused %memused kbbuffers kbcached kbcommit %commit kbactive kbinact kbdirty 16:17:01 30353712 31701632 2585508 7.85 48856 1621496 1459488 4.29 839988 1478812 48196 16:18:01 29989616 31731128 2949604 8.95 77576 1966708 1414648 4.16 842348 1799312 169500 16:19:01 27588744 31670032 5350476 16.24 109844 4193584 1408188 4.14 993344 3925980 1938004 16:20:01 25821216 30097304 7118004 21.61 117472 4367728 5839224 17.18 2693232 3944376 27620 16:21:10 27583884 31680956 5355336 16.26 119804 4197040 1388572 4.09 1136044 3776348 40920 Average: 28267434 31376210 4671786 14.18 94710 3269311 2302024 6.77 1300991 2984966 444848 16:16:01 IFACE rxpck/s txpck/s rxkB/s txkB/s rxcmp/s txcmp/s rxmcst/s %ifutil 16:17:01 docker0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16:17:01 lo 1.51 1.51 0.15 0.15 0.00 0.00 0.00 0.00 16:17:01 ens3 337.50 223.75 913.87 55.33 0.00 0.00 0.00 0.00 16:18:01 docker0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16:18:01 lo 1.07 1.07 0.11 0.11 0.00 0.00 0.00 0.00 16:18:01 ens3 63.61 42.27 1057.28 9.15 0.00 0.00 0.00 0.00 16:19:01 br-f38bb3df05e6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16:19:01 docker0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16:19:01 lo 8.40 8.40 0.78 0.78 0.00 0.00 0.00 0.00 16:19:01 ens3 554.96 314.56 18979.95 24.70 0.00 0.00 0.00 0.00 16:20:01 br-f38bb3df05e6 0.40 0.45 0.23 0.04 0.00 0.00 0.00 0.00 16:20:01 docker0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16:20:01 vethd0f0dfb 0.20 0.65 0.01 0.05 0.00 0.00 0.00 0.00 16:20:01 veth9729bc5 26.88 25.00 11.56 16.27 0.00 0.00 0.00 0.00 16:21:10 docker0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16:21:10 lo 14.93 14.93 1.55 1.55 0.00 0.00 0.00 0.00 16:21:10 ens3 908.32 555.16 18266.80 99.69 0.00 0.00 0.00 0.00 Average: docker0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Average: lo 2.75 2.75 0.30 0.30 0.00 0.00 0.00 0.00 Average: ens3 199.07 122.97 4072.23 22.14 0.00 0.00 0.00 0.00 ---> sar -P ALL: Linux 4.15.0-192-generic (prd-ubuntu1804-docker-8c-8g-4308) 12/11/23 _x86_64_ (8 CPU) 16:15:53 LINUX RESTART (8 CPU) 16:16:01 CPU %user %nice %system %iowait %steal %idle 16:17:01 all 6.09 0.00 1.00 4.25 0.18 88.48 16:17:01 0 7.03 0.00 1.20 7.43 0.03 84.30 16:17:01 1 8.93 0.00 1.11 11.53 0.03 78.40 16:17:01 2 11.56 0.00 1.06 0.78 0.08 86.52 16:17:01 3 8.76 0.00 2.29 0.68 0.03 88.24 16:17:01 4 2.75 0.00 0.41 10.13 0.02 86.69 16:17:01 5 3.82 0.00 0.46 2.74 0.59 92.40 16:17:01 6 3.38 0.00 0.72 0.10 0.08 95.71 16:17:01 7 2.52 0.00 0.74 0.62 0.56 95.56 16:18:01 all 9.78 0.00 0.71 2.44 0.03 87.03 16:18:01 0 29.15 0.00 1.53 3.68 0.07 65.57 16:18:01 1 31.48 0.00 1.75 1.10 0.05 65.62 16:18:01 2 12.03 0.00 0.83 0.10 0.02 87.02 16:18:01 3 1.89 0.00 0.52 2.79 0.02 94.79 16:18:01 4 0.90 0.00 0.27 5.58 0.02 93.24 16:18:01 5 2.32 0.00 0.43 0.67 0.02 96.57 16:18:01 6 0.07 0.00 0.23 5.63 0.05 94.02 16:18:01 7 0.33 0.00 0.10 0.02 0.00 99.55 16:19:01 all 12.62 0.00 3.42 1.81 0.05 82.10 16:19:01 0 14.01 0.00 2.41 0.59 0.05 82.95 16:19:01 1 13.71 0.00 3.26 0.10 0.07 82.86 16:19:01 2 6.63 0.00 3.82 0.29 0.03 89.23 16:19:01 3 7.01 0.00 3.68 0.17 0.05 89.09 16:19:01 4 8.02 0.00 2.97 2.30 0.03 86.67 16:19:01 5 18.60 0.00 3.98 1.43 0.07 75.92 16:19:01 6 15.32 0.00 3.30 8.79 0.07 72.52 16:19:01 7 17.75 0.00 3.93 0.86 0.07 77.39 16:20:01 all 22.28 0.00 2.83 4.53 0.07 70.29 16:20:01 0 21.82 0.00 3.05 0.59 0.07 74.48 16:20:01 1 20.89 0.00 2.61 2.66 0.07 73.78 16:20:01 2 30.10 0.00 3.50 0.22 0.08 66.09 16:20:01 3 21.99 0.00 2.85 0.77 0.07 74.33 16:20:01 4 21.94 0.00 2.43 0.62 0.07 74.94 16:20:01 5 23.45 0.00 3.04 0.92 0.08 72.50 16:20:01 6 22.08 0.00 3.44 29.04 0.08 45.36 16:20:01 7 15.92 0.00 1.79 1.64 0.05 80.61 16:21:10 all 4.08 0.00 0.36 2.52 0.60 92.44 16:21:10 0 0.49 0.00 0.23 0.00 0.60 98.68 16:21:10 1 10.53 0.00 0.41 1.83 1.55 85.68 16:21:10 2 1.51 0.00 0.35 0.01 0.01 98.12 16:21:10 3 13.65 0.00 0.71 0.22 0.07 85.35 16:21:10 4 4.09 0.00 0.43 0.10 0.12 95.26 16:21:10 5 0.33 0.00 0.26 0.12 0.01 99.28 16:21:10 6 1.16 0.00 0.27 17.62 1.72 79.22 16:21:10 7 0.86 0.00 0.23 0.12 0.70 98.09 Average: all 10.73 0.00 1.62 3.10 0.20 84.35 Average: 0 14.05 0.00 1.64 2.40 0.18 81.74 Average: 1 16.88 0.00 1.78 3.41 0.39 77.55 Average: 2 12.03 0.00 1.86 0.27 0.05 85.79 Average: 3 10.74 0.00 1.97 0.90 0.05 86.34 Average: 4 7.41 0.00 1.27 3.66 0.05 87.61 Average: 5 9.38 0.00 1.59 1.15 0.15 87.74 Average: 6 8.13 0.00 1.54 12.39 0.45 77.49 Average: 7 7.22 0.00 1.31 0.63 0.29 90.54