3.16 - When ingesting data, "org.postgresql.util.PSQLException: ERROR" in server.log

[yvesgoupil]

On the GISC deployment with PostgreSQL 14.0 and wildfly-26.1.3.Final , when ingesting data, there are dozens of errors in ~/wildfly-26.1.3.Final/standalone/log/server.log.
The Dataservice don't stop but it's difficult to know if the data will be available in the GISC Cache.

One example:
2023-02-13 15:51:47,918 ERROR [org.jboss.as.ejb3.invocation] (Thread-33 (ActiveMQ-client-global-threads)) WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component ProductMetadataService for method public abstract java.lang.Long org.openwis.dataservice.common.service.ProductMetadataService.createStopGapMetadata(java.lang.String,java.lang.String,int): javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.ConstraintViolationException: could not execute statement
...
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "openwis_product_metadata_urn_key" Detail: Key (urn)=(urn:x-wmo:md:int.wmo.wis::SNVX51EGRR) already exists.
...
2023-02-13 15:51:47,923 INFO [org.openwis.dataservice.cache.CacheManagerImpl] (Thread-34 (ActiveMQ-client-global-threads)) +++ enforce file extension for A_SNVX51EGRR131400_C_EGRR_20230213140000.bin 2023-02-13 15:51:47,910 ERROR [org.jboss.as.ejb3.invocation] (Thread-32 (ActiveMQ-client-global-threads)) WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component ProductMetadataService for method public abstract java.lang.Long org.openwis.dataservice.common.service.ProductMetadataService.createStopGapMetadata(java.lang.String,java.lang.String,int): javax.ejb.EJBTransactionRolledbackException: A product with the same URN already exists
...

[abrmh]

This kind of PSQLException happened when two threads comes in same time and trying to duplicate data in product-metada table . but it is not blocking exception.

[yvesgoupil]

It is not blocking and the files are well ingested. So I suggest to close this issue.