kbss-cvut / aircraft-maintenance-planning-system

D2020+ project about Aircraft Mainenance Planning System.
GNU Lesser General Public License v3.0
0 stars 0 forks source link

Unable to import data from SPipes exception is thrown for presence #203

Open kostobog opened 1 year ago

kostobog commented 1 year ago

@blcham Log copied from grafana (view in grafana):

2023-03-11 07:06:22 
2023-03-11 06:06:22.940  INFO 7 --- [      Thread-89] c.c.s.monitor.service.UpdateService      : Importing presence.6438735278220799464.csv...
2023-03-11 16:21:36 
2023-03-11 15:21:36.166 ERROR 7 --- [      Thread-89] c.c.s.monitor.service.UpdateService      : Unable to import data from SPipes
2023-03-11 16:21:36 
org.springframework.web.client.HttpServerErrorException$InternalServerError: 500 : [<!doctype html><html lang="en"><head><title>HTTP Status 500 – Internal Server Error</title><style type="text/css">h1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size... (2133 bytes)]
2023-03-11 16:21:36 
2023-03-11 16:21:36 
    at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:188) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.HttpServerErrorException.create(HttpServerErrorException.java:100) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:819) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:125) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.postForEntity(RestTemplate.java:468) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:711) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.doExecute(Rest)Template.java:777) ~[spring-web-5.3.9.jar!/:5.3.9]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.importToUpdateFromUrl(UpdateService.java:212)
2023-03-11 16:21:36 
com.csat.support.monitor.exception.SPipesImportException: Unable to import data from SPipes service { url: "http://s-pipes-engine:8080/s-pipes/service?_pId=transform-presence-data&datasetResource=@presence.6438735278220799464.csv", status: "500 INTERNAL_SERVER_ERROR", statusText: "" }
2023-03-11 16:21:36 
    at com.csat.support.monitor.util.HttpUtils.sendMultipartFormFile(HttpUtils.java:44) ~[classes!/:0.0.1-SNAPSHOT]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.importToUpdateFromUrl(UpdateService.java:194) ~[classes!/:0.0.1-SNAPSHOT]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.updateDataTask(UpdateService.java:353)
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.updateDataTask(UpdateService.java:416)
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.lambda$1(UpdateService.java:254) ~[classes!/:0.0.1-SNAPSHOT]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.updateDataTask(UpdateService.java:348) ~[classes!/:0.0.1-SNAPSHOT]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.updateDataTask(UpdateService.java:353) ~[classes!/:0.0.1-SNAPSHOT]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.updateDataTask(UpdateService.java:416) ~[classes!/:0.0.1-SNAPSHOT]
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.updateDataTask(UpdateService.java:348)
2023-03-11 16:21:36 
2023-03-11 16:21:36 
    at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
2023-03-11 16:21:36 
Caused by: org.springframework.web.client.HttpServerErrorException$InternalServerError: 500 : [<!doctype html><html lang="en"><head><title>HTTP Status 500 – Internal Server Error</title><style type="text/css">h1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size... (2133 bytes)]
2023-03-11 16:21:36 
    at java.base/java.lang.Thread.run(Unknown Source)
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.lambda$1(UpdateService.java:254)
2023-03-11 16:21:36 
    at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:125)
2023-03-11 16:21:36 
    at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:188)
2023-03-11 16:21:36 
    at org.springframework.web.client.HttpServerErrorException.create(HttpServerErrorException.java:100)
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:777)
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:819)
2023-03-11 16:21:36 
    at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63)
2023-03-11 16:21:36 
    at com.csat.support.monitor.service.UpdateService.importToUpdateFromUrl(UpdateService.java:194)
2023-03-11 16:21:36 
    at com.csat.support.monitor.util.HttpUtils.sendMultipartFormFile(HttpUtils.java:44)
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.postForEntity(RestTemplate.java:468)
2023-03-11 16:21:36 
    at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:711)
2023-03-11 16:21:36 
    ... 5 more
blcham commented 1 year ago

This is 500 from SPipes server logs, so it is necessary to include Spipes server logs as well.

The issue is java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space

It is related to lakeage while using JOPA EntityManagerFactory -- still requires more investigation, related to: https://github.com/kbss-cvut/aircraft-maintenance-planning-system/issues/162 https://github.com/kbss-cvut/s-pipes/pull/147