There is an debug port provided when 3DSpace tomee begins for every start. It will display all the current connection and related information used by this tomee. This will be very useful for performance issue investigations.
The below steps shows how to get this information.
First go to 3dspace/logs if you are using R2019x or below. Go to 3dspace/logsCAS is you are on R2020x or above.
tail -100 mxAudit.log
You found the debug port is 52413
Then telnet localhost 52413, and then press twice enter, below shows there is no connections at this time.
when there is an connection it will shows some information , below is one example for call from an jsp
you can check which jsp it is invoking and which mql it is executeing. how many time the conneciton is processing.
so below example shows emxSystemData.jsp is invoking mql 'print config !full' for 27 seconds.
[enovia@tdcvmlinczg01 logsCAS]\\\$ telnet localhost 52413
Trying ::1...
Connected to localhost.
Escape character is '^]'.
ENOVIA Server Thread Dump - Version 3DEXPERIENCE R2021x HotFix 4 - 03/06/2021 13:14:34 GMT:
Process 18345, monitor id: 11647925
Active: 7 days 6 hours 55 minutes 31.881819 seconds
Thread #1: t@1883576064, lwp=19274, ref=0x440119f0, session=6F21D1178A597825EDE3D572596F2D6A:mx-8788508760:(emxSystemData_jsp.java:456) , ms=0x45b87b40
db session id: 11647926
<1 - ADK Verbose Trace Entry>
stateless dispatch for executeCmd.bosMQLCommand executing
Active: 27.087680 seconds
User:
czg3
Tenant:
Session:
6F21D1178A597825EDE3D572596F2D6A:mx-8788508760:(emxSystemData_jsp.java:456)
Parameters:
bosContext _cntx:
user:
czg3
depth:
1
session id:
6F21D1178A597825EDE3D572596F2D6A:mx-8788508760:(emxSystemData_jsp.java:456)
bosString _cmd:
print config !full
uint8 _allowMultipleOverride:
0
uint8 _historyOff:
0
uint8 _triggerOff:
0
stacktrace:
at com.matrixone.jdl.rmi.bosMQLCommandImpl.executeCmd(bosMQLCommandImpl.java:46)
at matrix.db.MQLCommand.executeCommand(MQLCommand.java:222)
at com.matrixone.apps.domain.util.MqlUtil.mqlCommand(MqlUtil.java:164)
at com.matrixone.apps.domain.util.MqlUtil.mqlCommand(MqlUtil.java:117)
at com.matrixone.apps.domain.util.MqlUtil.mqlCommand(MqlUtil.java:100)
at com.matrixone.apps.domain.util.FrameworkUtil.getSystemData(FrameworkUtil.java:3794)
at org.apache.jsp.common.emxSystemData_jsp._jspService(emxSystemData_jsp.java:909)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
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:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.openejb.server.httpd.EEFilter.doFilter(EEFilter.java:65)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.matrixone.apps.domain.util.LicCheckFilter.doFilter(LicCheckFilter.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.matrixone.apps.domain.util.IECompatabilityFilter.doFilter(IECompatabilityFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.matrixone.apps.domain.util.XSSInputFilter.doFilter(XSSInputFilter.java:317)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.dassault_systemes.dspassport.cas.client.validation.BubbleKeepAliveFilter.doFilter(BubbleKeepAliveFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.dassault_systemes.dspassport.cas.client.authentication.DynamicServiceUrlAuthenticationFilter.doFilter(DynamicServiceUrlAuthenticationFilter.java:232)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.dassault_systemes.dspassport.cas.client.validation.DynamicServiceUrlAbstractTicketValidationFilter.doFilter(DynamicServiceUrlAbstractTicketValidationFilter.java:386)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.dassault_systemes.dspassport.cas.client.validation.CASProxyTicketValidationFilter.doFilter(CASProxyTicketValidationFilter.java:141)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.dassault_systemes.plmsecurity.ticket.servlet.LoginTicketAuthenticationFilter.doFilter(LoginTicketAuthenticationFilter.java:74)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.dassault_systemes.dspassport.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.matrixone.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:173)
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:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.tomee.catalina.OpenEJBSecurityListener\\\$RequestCapturer.invoke(OpenEJBSecurityListener.java:97)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
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:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol\\\$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint\\\$SocketProcessor.doRun(NioEndpoint.java:1589)
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:836)
Error Stack:
Error #1500097: Context user 'czg3' is not authorized for system administration
Error #1600000: "/u/lego/R423rel/BSF/ENOCppKernel/db.m/src/dbUpgrade.cpp":569
<2 - Executing MQL Command>
Active: 27.087304 seconds
Command:
print config !full
Error Stack:
Matrix Memory Manager:
Memory highwater (bytes): 300626348
Memory allocated (bytes): 260359695
Memory allocated (blocks): 22260
Memory reserved (bytes): 35864576
Memory reserved (blocks): 2189
Monitored 1 active ENOVIA thread, 214 contexts
Connection closed by foreign host.
