While running the ./demo-k8s.sh onap init script, when it comes to distributing
the services... it fails at distribution to sdnc.
I can see the following errors in SDN-C ueb-listener.log:
DEBUG 2019-08-01 12:57:19.113 +0000 CachedDataSource - SQL SUCCESS. rows
returned: 0, time(ms): 25
DEBUG 2019-08-01 12:57:19.113 +0000 DBResourceManager - writeData processing
time : sdnctldb01 25 miliseconds.
DEBUG 2019-08-01 12:57:19.182 +0000 SdcCsarHelperImpl - getAllottedResources -
allotted resources not exist
ERROR 2019-08-01 12:57:19.194 +0000 PropertyUtils - iterateProcessPath - Path
not Found
ERROR 2019-08-01 12:57:19.195 +0000 PropertyUtils - processProperties -
property nf_type is not found
ERROR 2019-08-01 12:57:19.195 +0000 PropertyUtils - processProperties -
property nf_role is not found
ERROR 2019-08-01 12:57:19.195 +0000 PropertyUtils - processProperties -
property nf_naming_code is not found
ERROR 2019-08-01 12:57:19.199 +0000 PropertyUtils - processProperties -
property nf_function is not found
ERROR 2019-08-01 12:57:19.199 +0000 PropertyUtils - processProperties -
property sdnc_model_name is not found
ERROR 2019-08-01 12:57:19.201 +0000 PropertyUtils - processProperties -
property sdnc_model_version is not found
ERROR 2019-08-01 12:57:19.201 +0000 PropertyUtils - processProperties -
property sdnc_artifact_name is not found
DEBUG 2019-08-01 12:57:19.220 +0000 CachedDataSource - Obtained connection
<sdnctldb01>:
ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@3af53c1b]]
DEBUG 2019-08-01 12:57:19.220 +0000 CachedDataSource - SQL Statement: SELECT *
from VF_MODEL where customization_uuid = "880b8d7d-59a4-415c-9a6c-fde5e25820ab";
DEBUG 2019-08-01 12:57:19.229 +0000 CachedDataSource - SQL SUCCESS. rows
returned: 0, time(ms): 9
DEBUG 2019-08-01 12:57:19.230 +0000 DBResourceManager - >> getData : sdnctldb01
12 miliseconds.
INFO 2019-08-01 12:57:19.230 +0000 SdncVFModel - Call insertToscaData for
VF_MODEL where customization_uuid = "880b8d7d-59a4-415c-9a6c-fde5e25820ab"
DEBUG 2019-08-01 12:57:19.230 +0000 SdncBaseModel - insertToscaData: INSERT
into VF_MODEL (customization_uuid, model_yaml, vendor, name,
ecomp_generated_naming, avail_zone_max_count, vendor_version, invariant_uuid,
uuid, version) values ("880b8d7d-59a4-415c-9a6c-fde5e25820ab", "null",
"b47b90d4-aef4-4ed1-8a3c", "vFWCL_vFWSNK 564404b3-27c6", "Y", 1, "1.0",
"89a1b18c-b327-4520-b148-929ad4002a04", "fbdd1389-255f-4d94-9e5f-44be67d2c4a4",
"1.0");
DEBUG 2019-08-01 12:57:19.230 +0000 CachedDataSource - Obtained connection
<sdnctldb01>:
ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@3af53c1b]]
DEBUG 2019-08-01 12:57:19.274 +0000 CachedDataSource - SQL SUCCESS. rows
returned: 0, time(ms): 44
DEBUG 2019-08-01 12:57:19.274 +0000 DBResourceManager - writeData processing
time : sdnctldb01 44 miliseconds.
DEBUG 2019-08-01 12:57:19.277 +0000 SdcCsarHelperImpl - getVfModulesByVf - VF
node template name vFWCL_vFWSNK 564404b3-27c6 0, normalized name
vfwcl_vfwsnk564404b327c60. Searching groups on service level starting with VF
normalized name...
ERROR 2019-08-01 12:57:19.278 +0000 PropertyUtils - processProperties -
property availability_zone_count is not found
ERROR 2019-08-01 12:57:19.278 +0000 PropertyUtils - processProperties -
property ecomp_generated_vm_assignments is not found
DEBUG 2019-08-01 12:57:19.279 +0000 CachedDataSource - Obtained connection
<sdnctldb01>:
ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@3af53c1b]]
DEBUG 2019-08-01 12:57:19.279 +0000 CachedDataSource - SQL Statement: SELECT *
from VF_MODULE_MODEL where customization_uuid =
"0995ee50-021d-49e7-a438-bec6535eebdd";
DEBUG 2019-08-01 12:57:19.298 +0000 CachedDataSource - SQL SUCCESS. rows
returned: 0, time(ms): 19
DEBUG 2019-08-01 12:57:19.299 +0000 DBResourceManager - >> getData : sdnctldb01
21 miliseconds.
DEBUG 2019-08-01 12:57:19.301 +0000 CachedDataSource - Obtained connection
<sdnctldb01>:
ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@3af53c1b]]
DEBUG 2019-08-01 12:57:19.301 +0000 CachedDataSource - SQL Statement: SELECT *
from VF_MODULE_TO_VFC_MAPPING where vf_module_customization_uuid =
"0995ee50-021d-49e7-a438-bec6535eebdd";
DEBUG 2019-08-01 12:57:19.343 +0000 CachedDataSource - SQL FAILURE. time(ms): 42
ERROR 2019-08-01 12:57:19.347 +0000 CachedDataSource - <sdnctldb01> Failed to
execute: SELECT * from VF_MODULE_TO_VFC_MAPPING where
vf_module_customization_uuid = "0995ee50-021d-49e7-a438-bec6535eebdd"; with no
arguments.
java.sql.SQLSyntaxErrorException: (conn=12779) Table
'sdnctl.VF_MODULE_TO_VFC_MAPPING' doesn't exist
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:158)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
at
org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
at
org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
at
org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
at
org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:173)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
at com.sun.proxy.$Proxy5.executeQuery(Unknown Source)
at
org.onap.ccsdk.sli.core.dblib.CachedDataSource.executePreparedStatement(CachedDataSource.java:181)
at
org.onap.ccsdk.sli.core.dblib.CachedDataSource.getData(CachedDataSource.java:139)
at
org.onap.ccsdk.sli.core.dblib.DBResourceManager.requestDataNoRecovery(DBResourceManager.java:548)
at
org.onap.ccsdk.sli.core.dblib.DBResourceManager.getData(DBResourceManager.java:462)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncBaseModel.cleanUpExistingToscaData(SdncBaseModel.java:1036)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel.insertVFModuleData(SdncVFModel.java:136)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel.insertData(SdncVFModel.java:97)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.processToscaCsar(SdncUebCallback.java:744)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleToscaArtifact(SdncUebCallback.java:631)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleSuccessfulDownload(SdncUebCallback.java:550)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleArtifact(SdncUebCallback.java:508)
at
org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.activateCallback(SdncUebCallback.java:308)
at org.onap.sdc.impl.NotificationConsumer.run(NotificationConsumer.java:71)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Table 'sdnctl.VF_MODULE_TO_VFC_MAPPING'
doesn't exist
Query is: SELECT * from VF_MODULE_TO_VFC_MAPPING where
vf_module_customization_uuid = "0995ee50-021d-49e7-a438-bec6535eebdd";
at
org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
at
org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
... 28 more
ERROR 2019-08-01 12:57:19.354 +0000 DBResourceManager - Generated alarm:
sdnctldb01 - (conn=12779) Table 'sdnctl.VF_MODULE_TO_VFC_MAPPING' doesn't exist
DEBUG 2019-08-01 12:57:19.354 +0000 DBResourceManager - >> getData : sdnctldb01
55 miliseconds.
ERROR 2019-08-01 12:57:19.354 +0000 SdncBaseModel - Could not clean up existing
VF_MODULE_TO_VFC_MAPPING for "0995ee50-021d-49e7-a438-bec6535eebdd"
java.sql.SQLSyntaxErrorException: (conn=12779) Table
'sdnctl.VF_MODULE_TO_VFC_MAPPING' doesn't exist
Is this because of the missing table: VF_MODULE_TO_VFC_MAPPING ... if so, is
there a way to manually create it?
Thanks.
-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#18390): https://lists.onap.org/g/onap-discuss/message/18390
Mute This Topic: https://lists.onap.org/mt/32680642/21656
Mute #sdc: https://lists.onap.org/mk?hashtag=sdc&subid=2740164
Mute #sdnc: https://lists.onap.org/mk?hashtag=sdnc&subid=2740164
Mute #robot: https://lists.onap.org/mk?hashtag=robot&subid=2740164
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-
