Details
-
Bug
-
Status: Closed (View Workflow)
-
P1
-
Resolution: Done
-
None
-
None
-
-
Bama
-
Nolana (R3 2022) Bug Fix
-
!!!ALL!!!
-
Legitimate regression
Description
It is issue with data-migration during install operation for mod-calendar-2.3.0-SNAPSHOT.137
Install operation failed. https://folio-testing-sprint-okapi.ci.folio.org/_/proxy/tenants/diku/install?tenantParameters=loadReference%3Dfalse%2CloadSample%3Dfalse&reinstall=false Status code: 400 Response body: POST request for mod-calendar-2.3.0-SNAPSHOT.137 /_/tenant failed with 500: {"timestamp":"2022-11-29T12:30:58.098897388Z","status":500,"errors":[{"code":"internalServerError","message":"An internal server error occurred (TenantUpgradeException): liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set /db/changes/0060-drop-rmb-functions.yaml::0060-drop-rmb-functions::university-of-alabama/ncovercash:\n Reason: liquibase.exception.DatabaseException: ERROR: function name \"concat_array_object_values\" is not unique\n Hint: Specify the argument list to select the function unambiguously. [Failed SQL: (0) DROP FUNCTION IF EXISTS concat_array_object_values CASCADE]","_parameters":{},"_trace":["org.folio.calendar.controller.ApiExceptionHandler.handleAllOtherExceptions(ApiExceptionHandler.java:143)","java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)","java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)","java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)","java.base/java.lang.reflect.Method.invoke(Unknown Source)","org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)","org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)","org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)","org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:428)","org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:75)","org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:142)","org.springframework.web.servlet.handler.HandlerExceptionResolverComposite.resolveException(HandlerExceptionResolverComposite.java:80)","org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1331)","org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1142)","org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1088)","org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)","org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)","org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)","javax.servlet.http.HttpServlet.service(HttpServlet.java:696)","org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)","javax.servlet.http.HttpServlet.service(HttpServlet.java:779)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.folio.spring.filter.LoggingRequestFilter.filterWrapped(LoggingRequestFilter.java:66)","org.folio.spring.filter.LoggingRequestFilter.doFilter(LoggingRequestFilter.java:48)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.folio.spring.scope.filter.FolioExecutionScopeFilter.doFilter(FolioExecutionScopeFilter.java:34)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.folio.spring.filter.TenantOkapiHeaderValidationFilter.doFilter(TenantOkapiHeaderValidationFilter.java:41)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)","org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)","org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)","org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)","org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)","org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)","org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)","org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)","org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)","org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)","org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)","org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)","org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)","org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)","org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)","org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)","java.base/java.lang.Thread.run(Unknown Source)","----------------- CAUSED BY -----------------","liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set /db/changes/0060-drop-rmb-functions.yaml::0060-drop-rmb-functions::university-of-alabama/ncovercash:\n Reason: liquibase.exception.DatabaseException: ERROR: function name \"concat_array_object_values\" is not unique\n Hint: Specify the argument list to select the function unambiguously. [Failed SQL: (0) DROP FUNCTION IF EXISTS concat_array_object_values CASCADE]","org.folio.spring.service.TenantService.createOrUpdateTenant(TenantService.java:50)","org.folio.spring.controller.TenantController.postTenant(TenantController.java:40)","java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)","java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)","java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)","java.base/java.lang.reflect.Method.invoke(Unknown Source)","org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)","org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)","org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)","org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)","org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)","org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)","org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)","org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)","org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)","org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)","javax.servlet.http.HttpServlet.service(HttpServlet.java:696)","org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)","javax.servlet.http.HttpServlet.service(HttpServlet.java:779)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.folio.spring.filter.LoggingRequestFilter.filterWrapped(LoggingRequestFilter.java:66)","org.folio.spring.filter.LoggingRequestFilter.doFilter(LoggingRequestFilter.java:48)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.folio.spring.scope.filter.FolioExecutionScopeFilter.doFilter(FolioExecutionScopeFilter.java:34)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.folio.spring.filter.TenantOkapiHeaderValidationFilter.doFilter(TenantOkapiHeaderValidationFilter.java:41)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)","org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)","org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)","org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)","org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)","org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)","org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)","org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)","org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)","org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)","org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)","org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)","org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)","org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)","org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)","org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)","org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)","org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)","org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)","org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)","java.base/java.lang.Thread.run(Unknown Source)"]}]}
TestRail: Results
Attachments
Issue Links
- relates to
-
MODCAL-118 Schema differences between Nolana-bugfest and clean Nolana deployment: mod-calendar
-
- Closed
-