Closed johnnychoque closed 2 weeks ago
Hi @johnnychoque,
Weird error, never seen this.
Can you send me the logs of the search service and PG / Timescale when you have the error?
Hi @bobeal,
In stellio-search-service, the following error message is displayed:
2024-05-24 10:09:48,208 [or-http-epoll-2] INFO c.e.stellio.shared.web.ExceptionHandler - generateErrorResponse - Returning error https://uri.etsi.org/ngsi-ld/errors/InternalError (reactor.netty.channel.AbortedException: Connection has been closed)
No error message is displayed in stellio-postgres.
Hi @johnnychoque Do you only have the postgres connexion issue on the "/ngsi-ld/v1/entityOperations/upsert" endpoint or is it a global issue?
The problem can come from the STELLIO_SEARCH_DB_DATABASE environment variable. (it should be ="stellio_search"). Can you check if the env variable SPRING_R2DBC_URL is equal to r2dbc:postgresql://postgres/stellio_search inside the stellio-search-service container? and restart your infra?
I have tried to create 1000 entities in one go and my upsert still works. If you tried the solution above and it did not work i could use your actual sensors entities to reproduce the issue.
Hi all,
I am trying to create entities for about 1000 sensors in bulk mode. At first, the entities are created correctly but then the following error is displayed at each attempt to create a new entity:
I have tried adding a delay of up to 3000 ms between each request but the error still appears. Setting a longer delay is not suitable for the system I am developing.
I am using the latest version of Stellio CB.
Could you give me some ideas to solve this issue?