search

CenturyLinkCloud / mdw

https://centurylinkcloud.github.io/mdw/
MIT License
46 stars 10 forks source link

Adapter completion time update error at performance level 5 #809

Closed donaldoakes closed 4 years ago

donaldoakes commented 4 years ago

Rest adapters in service processes invoked at performance level 5 exhibit the following stack trace. Run PerfLevel5RequestResponse.test to reproduce.

com.centurylink.mdw.dataaccess.DataAccessException: Failed to get request completion time
    at com.centurylink.mdw.services.process.ProcessExecutor.getRequestCompletionTime(ProcessExecutor.java:541)
    at com.centurylink.mdw.workflow.adapter.TextAdapterActivity.logResponse(TextAdapterActivity.java:569)
    at com.centurylink.mdw.workflow.adapter.TextAdapterActivity.execute(TextAdapterActivity.java:384)
    at com.centurylink.mdw.workflow.activity.DefaultActivityImpl.execute(DefaultActivityImpl.java:40)
    at com.centurylink.mdw.services.process.BaseActivity.execute(BaseActivity.java:229)
    at com.centurylink.mdw.services.process.BaseActivity.executeTimed(BaseActivity.java:245)
    at com.centurylink.mdw.services.process.ProcessEngineDriver.executeActivity(ProcessEngineDriver.java:385)
    at com.centurylink.mdw.services.process.ProcessEngineDriver.processEvent(ProcessEngineDriver.java:639)
    at com.centurylink.mdw.services.process.ProcessEngineDriver.executeServiceProcess(ProcessEngineDriver.java:858)
    at com.centurylink.mdw.services.process.ProcessEngineDriver.invokeService(ProcessEngineDriver.java:775)
    at com.centurylink.mdw.services.process.ProcessEngineDriver.invokeService(ProcessEngineDriver.java:711)
    at com.centurylink.mdw.services.workflow.WorkflowServicesImpl.invokeServiceProcess(WorkflowServicesImpl.java:968)
    at com.centurylink.mdw.services.rest.JsonRestService.invokeServiceProcess(JsonRestService.java:218)
    at com.centurylink.mdw.services.rest.ProcessInvoker.service(ProcessInvoker.java:123)
    at com.centurylink.mdw.services.rest.JsonRestService.getJson(JsonRestService.java:60)
    at com.centurylink.mdw.service.handler.ServiceRequestHandler.handleEventMessage(ServiceRequestHandler.java:92)
    at com.centurylink.mdw.listener.ListenerHelper.processEvent(ListenerHelper.java:439)
    at com.centurylink.mdw.hub.servlet.RestServlet.handleRequest(RestServlet.java:263)
    at com.centurylink.mdw.hub.servlet.RestServlet.doPost(RestServlet.java:148)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
    at com.centurylink.mdw.hub.servlet.RestServlet.service(RestServlet.java:228)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:438)
    at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:169)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.centurylink.mdw.hub.servlet.AccessFilter.doFilter(AccessFilter.java:343)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.centurylink.mdw.hub.servlet.CustomContentFilter.doFilter(CustomContentFilter.java:57)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Unable to find CREATE_DT for ADAPTER: 27
    at com.centurylink.mdw.dataaccess.db.CommonDataAccess.getRequestCompletionTime0(CommonDataAccess.java:945)
    at com.centurylink.mdw.service.data.process.EngineDataAccessDB.getRequestCompletionTime(EngineDataAccessDB.java:1288)
    at com.centurylink.mdw.service.data.process.EngineDataAccessCache.getRequestCompletionTime(EngineDataAccessCache.java:776)
    at com.centurylink.mdw.services.process.ProcessExecutor.getRequestCompletionTime(ProcessExecutor.java:534)
    ... 52 more