Skip to content

Instantly share code, notes, and snippets.

@passkeykz

passkeykz/gist:8123eab5b340b2769e4763794280bfd3 Secret

Created May 26, 2020 06:18
Show Gist options
  • Save passkeykz/8123eab5b340b2769e4763794280bfd3 to your computer and use it in GitHub Desktop.
Save passkeykz/8123eab5b340b2769e4763794280bfd3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
05-26/12:16:44 WARN [http-nio-9088-exec-3] AbstractExceptionHandler - Unhandled exception
org.apache.jasper.JasperException: An exception occurred processing [WEB-INF/custom/plugin/report/custom_missed_calls.jsp] at line [35]
32: <c:if test="${not empty datestart and not empty dateend}">
33:
34: <sql:setDataSource var="data" driver="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://10.254.252.21:3306/qstats?verifyServerCertificate=false&useSSL=false" user="psh" password="100500200"/>
35: <sql:query dataSource="${data}" var="result">
36: SELECT DATE_FORMAT(datetime,'%Y-%m-%d %H:%i:%s') AS TimeToCall, TIME_FORMAT(TIMEDIFF(datetimeend, datetimeconnect),'%i:%s') AS CallDuration, clid AS Number FROM queue_stats_mv WHERE event = 'ABANDON' AND queue = 'support' AND datetime >=? AND datetime <=? LIMIT 1000;
37:
38: <sql:param value="${datestart}"/>
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:607)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
at org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
at org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at ru.bgcrm.servlet.filter.SetRequestParamsFilter.doFilter(SetRequestParamsFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at ru.bgcrm.servlet.filter.AuthFilter.doFilter(AuthFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at ru.bgcrm.servlet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:38)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required"
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:667)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspService(custom_005fmissed_005fcalls_jsp.java:192)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:458)
... 49 more
Caused by: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required"
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:304)
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:157)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspx_meth_sql_005fquery_005f0(custom_005fmissed_005fcalls_jsp.java:441)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspx_meth_c_005fif_005f0(custom_005fmissed_005fcalls_jsp.java:363)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspService(custom_005fmissed_005fcalls_jsp.java:178)
... 52 more
05-26/12:16:44 WARN [http-nio-9088-exec-3] ExceptionCatcher - Exception from exceptionCommand 'servlet-exception'
org.apache.jasper.JasperException: An exception occurred processing [WEB-INF/custom/plugin/report/custom_missed_calls.jsp] at line [35]
32: <c:if test="${not empty datestart and not empty dateend}">
33:
34: <sql:setDataSource var="data" driver="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://10.254.252.21:3306/qstats?verifyServerCertificate=false&useSSL=false" user="psh" password="100500200"/>
35: <sql:query dataSource="${data}" var="result">
36: SELECT DATE_FORMAT(datetime,'%Y-%m-%d %H:%i:%s') AS TimeToCall, TIME_FORMAT(TIMEDIFF(datetimeend, datetimeconnect),'%i:%s') AS CallDuration, clid AS Number FROM queue_stats_mv WHERE event = 'ABANDON' AND queue = 'support' AND datetime >=? AND datetime <=? LIMIT 1000;
37:
38: <sql:param value="${datestart}"/>
Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:607)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
at org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
at org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at ru.bgcrm.servlet.filter.SetRequestParamsFilter.doFilter(SetRequestParamsFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at ru.bgcrm.servlet.filter.AuthFilter.doFilter(AuthFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at ru.bgcrm.servlet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:38)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required"
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:667)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspService(custom_005fmissed_005fcalls_jsp.java:192)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:458)
... 49 more
Caused by: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required"
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:304)
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:157)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspx_meth_sql_005fquery_005f0(custom_005fmissed_005fcalls_jsp.java:441)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspx_meth_c_005fif_005f0(custom_005fmissed_005fcalls_jsp.java:363)
at org.apache.jsp.WEB_002dINF.custom.plugin.report.custom_005fmissed_005fcalls_jsp._jspService(custom_005fmissed_005fcalls_jsp.java:178)
... 52 more
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment