-
Bug
-
Resolution: Won't Do
-
Medium
-
None
-
El Alto Release
-
El Alto release
nexus3.onap.org:10001/onap/so/sdc-controller:1.5.3
Hi, I am getting the following error when distributing a service from SDC:
02/20/2020 7:41PM DISTRIBUTION_COMPLETE_ERROR Reason: could not execute statement; SQL [n/a]; constraint [PRIMARY]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
I can see the following in the sdc controller logs:
2020-02-20T19:41:48.632Z|017a1286-2792-490a-8d2a-50486736f511|org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1062, SQLState: 23000 2020-02-20T19:41:48.632Z|017a1286-2792-490a-8d2a-50486736f511|org.hibernate.engine.jdbc.spi.SqlExceptionHelper - (conn=528959) Duplicate entry '82486bdc-8799-495e-a3a7-51ceb01820b5-d6b62c88-d7ca-427c-add3-2ec' for key 'PRIMARY' 2020-02-20T19:41:48.633Z|017a1286-2792-490a-8d2a-50486736f511|org.hibernate.internal.ExceptionMapperStandardImpl - HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]
Here the catalogdb entries:
MariaDB [catalogdb]> select * from network_resource_customization_to_service; +--------------------------------------+--------------------------------------+ | SERVICE_MODEL_UUID | RESOURCE_MODEL_CUSTOMIZATION_UUID | +--------------------------------------+--------------------------------------+ | 82486bdc-8799-495e-a3a7-51ceb01820b5 | d6b62c88-d7ca-427c-add3-2ecb7c0d59ca | +--------------------------------------+--------------------------------------+
MariaDB [catalogdb]> select * from network_resource_customization;
+--------------------------------------+---------------------+--------------------+--------------+--------------+---------------+---------------------+--------------------------------------+----------------+
| MODEL_CUSTOMIZATION_UUID | MODEL_INSTANCE_NAME | NETWORK_TECHNOLOGY | NETWORK_TYPE | NETWORK_ROLE | NETWORK_SCOPE | CREATION_TIMESTAMP | NETWORK_RESOURCE_MODEL_UUID | RESOURCE_INPUT |
+--------------------------------------+---------------------+--------------------+--------------+--------------+---------------+---------------------+--------------------------------------+----------------+
| 2a957518-af42-4f8e-9233-42c92e195a66 | VnfVirtualLink | NULL | NULL | NULL | NULL | 2020-01-28 12:29:25 | 79934ec4-c4d7-4575-8b1b-53350a3418c6 | {} |
| b4126972-3b33-4862-981d-5ccfd2ec4878 | VnfVirtualLink | NULL | NULL | NULL | NULL | 2020-01-19 17:56:41 | 634dcf15-5d4a-4989-8cfe-de9584ff22e2 | {} |
| d6b62c88-d7ca-427c-add3-2ecb7c0d59ca | VnfVirtualLink | NULL | NULL | NULL | NULL | 2020-02-20 19:41:48 | 79934ec4-c4d7-4575-8b1b-53350a3418c6 | {} |
+--------------------------------------+---------------------+--------------------+--------------+--------------+---------------+---------------------+--------------------------------------+----------------+
service csar and complete so-sdc-controller logs attached to the ticket