-
Bug
-
Resolution: Won't Do
-
Medium
-
None
-
Casablanca Release
On performing the below steps, the last step doesn’t execute successfully
- Have a fresh ONAP installation
- Create a service in SDC and distribute it
- Check SO tables for entries and ensure that service etc are populated
- Populate a recipe entry
- Re-distribute the service from SDC
From the initial analysis done by us, this is what causes the issue
- Spring data decides to call em.merge because the ID is populated
- An interceptor in spring finds the entity to be detached and tries to query the DB for the entry
- The entry from DB has service in which recipe is populated
- The entry from toscainstaller doesn’t have recipe and this could be why it tries populating null (not sure why it doesn’t delete though !!)
We tried changing the cascade in Service.java for recipe to Cascade.REMOVE (just as a test), it still tries to update the record with null
As a workaround, we are looking for recipe if it exists (in ToscaInstaller) and set it back in the entity.
2019-04-18T14:26:25.548Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.so.asdc.client.ASDCController - Preparing to deploy Service: dd62f0ec-12ea-426a-93a0-b36a93aac483
2019-04-18T14:26:25.548Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.so.asdc.client.ASDCController - ASDC_START_DEPLOY_ARTIFACT
2019-04-18T14:26:25.552Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - VF Category is : Generic
2019-04-18T14:26:25.552Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - VFCustomizationUUID=d4f524f2-7a43-49c3-86df-213cb6b73ad4
2019-04-18T14:26:25.552Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - Checking if Notification VF ResourceCustomizationUUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4 matches Tosca VF Customization UUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4
2019-04-18T14:26:25.553Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - vfCustomizationUUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4 matches vfNotificationResource CustomizationUUID
2019-04-18T14:26:25.557Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - processProperties - property nf_function not found
2019-04-18T14:26:25.557Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - processProperties - property nf_naming_code not found
2019-04-18T14:26:25.557Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - processProperties - property nf_role not found
2019-04-18T14:26:25.558Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - processProperties - property nf_type not found
2019-04-18T14:26:25.558Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - processProperties - property multi_stage_design not found
2019-04-18T14:26:25.558Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - vfModuleStructure:org.onap.so.asdc.installer.VfModuleStructure@6db5adf7
2019-04-18T14:26:25.558Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - getVfModulesByVf - VF node template name vSmartViptelaSdwan 0, normalized name vsmartviptelasdwan0. Searching groups on service level starting with VF normalized name...
2019-04-18T14:26:25.558Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - Comparing Vf_Modules_Metadata CustomizationUUID : f2cb7910-5749-47ee-9344-b39de14695ab
2019-04-18T14:26:25.559Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - To Csar Group VFModuleModelCustomizationUUID f2cb7910-5749-47ee-9344-b39de14695ab
2019-04-18T14:26:25.562Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - iterateProcessPath - this input has no default
2019-04-18T14:26:25.564Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - VF Category is : Generic
2019-04-18T14:26:25.564Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - VFCustomizationUUID=a5175eb6-8b3a-4ea3-a173-0371368e26ca
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - Checking if Notification VF ResourceCustomizationUUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4 matches Tosca VF Customization UUID: a5175eb6-8b3a-4ea3-a173-0371368e26ca
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - Notification VF ResourceCustomizationUUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4 doesn't match Tosca VF Customization UUID: a5175eb6-8b3a-4ea3-a173-0371368e26ca
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - VF Category is : Generic
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - VFCustomizationUUID=0b490550-17c5-44d7-9594-d048ce605867
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - Checking if Notification VF ResourceCustomizationUUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4 matches Tosca VF Customization UUID: 0b490550-17c5-44d7-9594-d048ce605867
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.installer.heat.ToscaResourceInstaller - Notification VF ResourceCustomizationUUID: d4f524f2-7a43-49c3-86df-213cb6b73ad4 doesn't match Tosca VF Customization UUID: 0b490550-17c5-44d7-9594-d048ce605867
2019-04-18T14:26:25.565Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.sdc.tosca.parser.impl.SdcCsarHelperImpl - getAllottedResources - allotted resources not exist
2019-04-18T14:26:25.746Z|7a14d900-e774-4734-a093-a288f89017f8| org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1048, SQLState: 23000
2019-04-18T14:26:25.746Z|7a14d900-e774-4734-a093-a288f89017f8| org.hibernate.engine.jdbc.spi.SqlExceptionHelper - (conn:53) Column 'SERVICE_MODEL_UUID' cannot be null
Query is: update service_recipe set SERVICE_MODEL_UUID=null where SERVICE_MODEL_UUID=?, parameters ['dd62f0ec-12ea-426a-93a0-b36a93aac483']
2019-04-18T14:26:25.753Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.so.asdc.client.ASDCController - ASDC_GENERAL_EXCEPTION_ARG
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:278)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:765)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:734)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:518)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
at org.onap.so.asdc.installer.heat.ToscaResourceInstaller$$EnhancerBySpringCGLIB$$ac23da94.installTheResource(<generated>)
at org.onap.so.asdc.client.ASDCController.deployResourceStructure(ASDCController.java:447)
at org.onap.so.asdc.client.ASDCController.processResourceNotification(ASDCController.java:727)
at org.onap.so.asdc.client.ASDCController.treatNotification(ASDCController.java:576)
at org.onap.so.asdc.client.ASDCNotificationCallBack.activateCallback(ASDCNotificationCallBack.java:55)
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: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at org.hibernate.persister.collection.AbstractCollectionPersister.remove(AbstractCollectionPersister.java:1209)
at org.hibernate.action.internal.CollectionRemoveAction.execute(CollectionRemoveAction.java:96)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
... 20 common frames omitted
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn:53) Column 'SERVICE_MODEL_UUID' cannot be null
Query is: update service_recipe set SERVICE_MODEL_UUID=null where SERVICE_MODEL_UUID=?, parameters ['dd62f0ec-12ea-426a-93a0-b36a93aac483']
at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:133)
at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:413)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:362)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:351)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
... 38 common frames omitted
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Column 'SERVICE_MODEL_UUID' cannot be null
Query is: update service_recipe set SERVICE_MODEL_UUID=null where SERVICE_MODEL_UUID=?, parameters ['dd62f0ec-12ea-426a-93a0-b36a93aac483']
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:617)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:401)
... 43 common frames omitted
2019-04-18T14:26:25.753Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.tenantIsolation.WatchdogDistribution - Entered executePatchAAI method with distrubutionId: 7a14d900-e774-4734-a093-a288f89017f8 and distributionStatus: DISTRIBUTION_COMPLETE_ERROR
2019-04-18T14:26:25.765Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.tenantIsolation.WatchdogDistribution - Executed RequestDB getWatchdogServiceModVerIdLookup with distributionId: 7a14d900-e774-4734-a093-a288f89017f8 and serviceModelVersionId: dd62f0ec-12ea-426a-93a0-b36a93aac483
2019-04-18T14:26:25.765Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.tenantIsolation.WatchdogDistribution - ASDC Notification ServiceModelInvariantUUID : 5607b383-6387-4365-8a4e-6240c9d4c5b2
2019-04-18T14:26:25.974Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.tenantIsolation.WatchdogDistribution - Target A&AI Resource URI: /service-design-and-creation/models/model/5607b383-6387-4365-8a4e-6240c9d4c5b2/model-vers/model-ver/dd62f0ec-12ea-426a-93a0-b36a93aac483?depth=0
2019-04-18T14:26:26.046Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.so.client.RestClient - RestClientSSL using default SSL context!
2019-04-18T14:26:26.297Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.logging.jaxrs.filter.PayloadLoggingFilter - Making POST (overridden to PATCH) request to: http://aai.casaqa:8443/aai/v14/service-design-and-creation/models/model/5607b383-6387-4365-8a4e-6240c9d4c5b2/model-vers/model-ver/dd62f0ec-12ea-426a-93a0-b36a93aac483?depth=0
Request Headers:
{Authorization=[Basic YWFpQGFhaS5vbmFwLm9yZzpkZW1vMTIzNDU2IQ==], X-FromAppId=[MSO], X-TransactionId=[], X-HTTP-Method-Override=[PATCH], Accept=[application/json], Content-Type=[application/merge-patch+json], X-ONAP-RequestID=[7a14d900-e774-4734-a093-a288f89017f8], X-ONAP-InvocationID=[bc790c88-2d0c-46c6-93c8-47d796c8ba23], X-ONAP-PartnerName=[SO]}2019-04-18T14:26:26.326Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.logging.jaxrs.filter.PayloadLoggingFilter - {"distribution-status":"DISTRIBUTION_COMPLETE_ERROR"}
2019-04-18T14:26:26.498Z|7a14d900-e774-4734-a093-a288f89017f8| o.o.so.asdc.tenantIsolation.WatchdogDistribution - A&AI UPDATE MODEL Version is success!
2019-04-18T14:26:26.498Z|7a14d900-e774-4734-a093-a288f89017f8| org.onap.so.asdc.client.ASDCController - A&AI Updated succefully with Distribution Status of DISTRIBUTION_COMPLETE_ERROR