Bug #10020
closed
Table "DM_ENROLMENT" not found error when enrolling 1000 devices
Added by Arshana Atapattu over 2 years ago. Updated about 1 year ago.
0%
Description
Environment details
510 server
JMeter 5.5
Prerequisites
JMeter scripts1
Steps
start the server.
Once the server start run the JMeter script(If for super tenant, use super tenant reqs). Please note that in 510, to generate a token for a sub tenant you have to log into that sub tenant.
For load testing it is recommended to use CLI mode rather than GUI.
for generating reports you can use this command, execute it from where the jmeter bin folder.
jmeter -n -t "location of test file(.jmx)" -l "location of your result file" -e -o "location of reports folder"
Ex: sh jmeter -n -t /home/arshana/QA-scripts/Policy-test-case/01-Adding_devices.jmx -l "/home/arshana/Desktop/JMeter_reports/Reports/4_Adding_Devices/4_Adding_Devices.csv" -e -o /home/arshana/Desktop/JMeter_reports/Reports/4_Adding_Devices
The error2 is attached here.
Description
When enrolling 1000 devices it fails to enroll devices after some point. This happened with super tenant and sub-tenants.
This pattern3 was observed in both super and sub tenants.
the html report4 for this test is attached here.
[3]![[3]](/attachments/download/3093/Screenshot%20from%202023-03-22%2018-27-21.png "[3]")
Files
| 01-Adding_devices.jmx (57.9 KB) 01-Adding_devices.jmx | [1] | Arshana Atapattu, 22/03/2023 12:42 PM | |
| device enroll issue (10.3 KB) device enroll issue | [2] | Arshana Atapattu, 22/03/2023 12:42 PM | |
| Screenshot from 2023-03-22 18-27-21.png (120 KB) Screenshot from 2023-03-22 18-27-21.png | [3] | Arshana Atapattu, 22/03/2023 12:57 PM | |
| 4_Adding_Devices.zip (1.07 MB) 4_Adding_Devices.zip | [4] | Arshana Atapattu, 22/03/2023 12:58 PM | |
| device enroll issue_2 (9.2 KB) device enroll issue_2 | [5] | Arshana Atapattu, 22/03/2023 01:14 PM | |
| Screenshot from 2023-08-14 19-23-58.png (238 KB) Screenshot from 2023-08-14 19-23-58.png | [8] | Arshana Atapattu, 15/08/2023 01:19 PM |
Updated by Arshana Atapattu over 2 years ago
- File device enroll issue_2 device enroll issue_2 added
After running this test again, was able to enroll 997 devices on super tenant. but it gave a little different error [5] this time.
Updating the ticket with the new error.
Updated by Arshana Atapattu about 2 years ago
Tested on 5.2.4.2 SNAPSHOT
Without licensing, it enrolls 1000 devices. but sometimes it throws this error on some devices.
Error :
ERROR - DeviceTypePluginDAOImpl Error occurred while fetching device : '000-000-304' from AD_DEVICE
org.h2.jdbc.JdbcSQLTimeoutException: Timeout trying to lock table "AD_DEVICE"; SQL statement:
SELECT FCM_TOKEN, DEVICE_INFO, IMEI, IMSI, OS_VERSION, DEVICE_MODEL, VENDOR, LATITUDE, LONGITUDE, SERIAL, MAC_ADDRESS, DEVICE_NAME, OS_BUILD_DATE FROM AD_DEVICE WHERE DEVICE_ID = ? [50200-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:511) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.message.DbException.get(DbException.java:205) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.message.DbException.get(DbException.java:181) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.pagestore.db.PageStoreTable.doLock1(PageStoreTable.java:375) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.pagestore.db.PageStoreTable.lock(PageStoreTable.java:338) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.table.TableFilter.lock(TableFilter.java:207) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:819) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:201) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Query.query(Query.java:489) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Query.query(Query.java:451) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:285) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.Command.executeQuery(Command.java:195) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114) ~[h2_1.4.200.wso2v1.jar:?]
at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[jdbc-pool_9.0.35.wso2v1.jar:?]
at com.sun.proxy.$Proxy50.executeQuery(Unknown Source) ~[?:?]
at org.wso2.carbon.device.mgt.extensions.device.type.template.dao.DeviceTypePluginDAOImpl.getDevice(DeviceTypePluginDAOImpl.java:84) [org.wso2.carbon.device.mgt.extensions_5.0.25.jar:?]
at org.wso2.carbon.device.mgt.extensions.device.type.template.DeviceTypeManager.isEnrolled(DeviceTypeManager.java:436) [org.wso2.carbon.device.mgt.extensions_5.0.25.jar:?]
at org.wso2.carbon.device.mgt.extensions.device.type.template.DeviceTypeManager.enrollDevice(DeviceTypeManager.java:328) [org.wso2.carbon.device.mgt.extensions_5.0.25.jar:?]
at org.wso2.carbon.device.mgt.core.service.DeviceManagementProviderServiceImpl.enrollDevice(DeviceManagementProviderServiceImpl.java:386) [org.wso2.carbon.device.mgt.core_5.0.25.jar:?]
at io.entgra.proprietary.platform.android.core.impl.AndroidServiceImpl.enrollDevice(AndroidServiceImpl.java:1480) [io.entgra.proprietary.platform.android.core_5.0.26.1.jar:?]
at io.entgra.proprietary.platform.android.api.service.impl.DeviceManagementAPIImpl.enrollDevice(DeviceManagementAPIImpl.java:245) [classes/:?]
at sun.reflect.GeneratedMethodAccessor669.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201) [cxf-rt-frontend-jaxrs-3.5.0.jar:3.5.0]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:104) [cxf-rt-frontend-jaxrs-3.5.0.jar:3.5.0]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:265) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:225) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:304) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:217) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api_9.0.52.wso2v1.jar:?]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat_9.0.52.wso2v2.jar:?]
at io.entgra.proprietary.platform.android.addons.ApiOriginFilter.doFilter(ApiOriginFilter.java:42) [io.entgra.proprietary.platform.android.addons-5.0.26.1.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat_9.0.52.wso2v2.jar:?]
at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:107) [org.wso2.carbon.identity.context.rewrite.valve_1.4.25.jar:?]
at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:110) [org.wso2.carbon.identity.authz.valve_1.4.25.jar:?]
at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:105) [org.wso2.carbon.identity.auth.valve_1.4.25.14.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:101) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.webapp.authenticator.framework.WebappAuthenticationValve.processRequest(WebappAuthenticationValve.java:302) [org.wso2.carbon.webapp.authenticator.framework_5.0.25.jar:?]
at org.wso2.carbon.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:179) [org.wso2.carbon.webapp.authenticator.framework_5.0.25.jar:?]
at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:145) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat_9.0.52.wso2v2.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:59) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:126) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat_9.0.52.wso2v2.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Updated by Viranga Gunarathna about 2 years ago
- Project changed from product-uem 5.3.0 GA to 32
- Category deleted (
Backend)
Updated by Arshana Atapattu almost 2 years ago
Server was setup against mysql db and used only DM_DB.
when tried to enroll 1000 devices, process was failed due to "[2023-08-14 17:45:15,788] ERROR - AndroidServiceImpl Maximum device count is enrolled for your license. Therefore you are not allowed to enroll more devices until you upgrade the license."
This was tried on another device. Got the same outcome.
Error on carbon console [6]
some other errors came with log [6] and [7]
codes pattern during test [8]
Full error log can get ffrom here -> https://drive.google.com/file/d/1e-zSvsZo5W8NOdqGnhjS9solMnSzBRQZ/view?usp=drive_link
[6]
[2023-08-14 18:51:38,174] INFO - 256 Unpublished violations detected
[2023-08-14 18:51:38,174] INFO - 256 Unpublished violations detected
[2023-08-14 18:51:38,175] INFO - 256 Violation Payload : {"messages":[{"data":"eyJ1dWlkIjoiZTcxNWRkZDQtZTVhYy01ZTExLThhZjYtZDNhYjM1ZjM1M2IwIiwidmlvbGF0aW9ucyI6W3sidmlvbGF0aW9uVHlwZSI6IlJFQUNIRURfREVWSUNFX0NPVU5UIiwibWVzc2FnZSI6IkxpY2Vuc2luZyBleHBpcmVkIGR1ZSB0byBSRUFDSEVEX0RFVklDRV9DT1VOVCIsImRldGVjdGVkVGltZXN0YW1wIjoxNjkyMDE5Mjk4MTc0fSx7InZpb2xhdGlvblR5cGUiOiJDSEFOR0VfSEFSRFdBUkVfSUQiLCJtZXNzYWdlIjoiRGV0ZWN0ZWQgZnJhdWQuIFZpb2xhdGVkIGxpY2Vuc2luZyBjcml0ZXJpYSBDSEFOR0VfSEFSRFdBUkVfSUQiLCJkZXRlY3RlZFRpbWVzdGFtcCI6MTY5MjAxOTI5ODE3NH1dfQ\u003d\u003d"}]}
[2023-08-14 18:51:38,725] INFO - 256 Violation messages published {
"messageIds": [
"8086888382914485"
]
}
[7]
[2023-08-14 18:50:44,051] INFO - 46 Heartbeat payload: {"messages":[{"data":"eyJ1dWlkIjoiZTcxNWRkZDQtZTVhYy01ZTExLThhZjYtZDNhYjM1ZjM1M2IwIiwiZGV2aWNlQ291bnQiOjIxNiwiYXBwQ291bnQiOjAsImhhcmR3YXJlSWQiOiJhYTljNDdkMy1lZjA1YWM0YS04OGJkYmM2NS04LTE2NjIxODU0NzIwNzQzODUyZGIifQ\u003d\u003d"}]}
[8]![[8]](/attachments/download/3267/Screenshot%20from%202023-08-14%2019-23-58.png "[8]")
[9]
Failed while retrieving devices count from DBTable "DM_ENROLMENT" not found; SQL statement:
SELECT COUNT AS DEVICE_COUNT FROM DM_ENROLMENT e [42102-200]
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "DM_ENROLMENT" not found; SQL statement:
SELECT COUNT AS DEVICE_COUNT FROM DM_ENROLMENT e [42102-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7628)
at org.h2.command.Parser.readTableFilter(Parser.java:1970)
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2827)
at org.h2.command.Parser.parseSelect(Parser.java:2959)
at org.h2.command.Parser.parseQuerySub(Parser.java:2817)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649)
at org.h2.command.Parser.parseQuery(Parser.java:2620)
at org.h2.command.Parser.parsePrepared(Parser.java:868)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at io.entgra.proprietary.licensing.toolkit.eval.CountObserver.getTotalDevicesInSystem(CountObserver.java:168)
at io.entgra.proprietary.licensing.toolkit.service.impl.LicensingServiceImpl.isAllocatedDeviceCountReached(LicensingServiceImpl.java:21)
at io.entgra.proprietary.uem.platform.android.core.impl.AndroidServiceImpl.enrollDevice(AndroidServiceImpl.java:1446)
at io.entgra.proprietary.uem.platform.android.api.service.impl.DeviceManagementAPIImpl.enrollDevice(DeviceManagementAPIImpl.java:241)
at sun.reflect.GeneratedMethodAccessor924.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:104)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:265)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:225)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:304)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:217)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at io.entgra.proprietary.uem.platform.android.addons.ApiOriginFilter.doFilter(ApiOriginFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:107)
at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:110)
at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:105)
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:101)
at org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47)
at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.processRequest(WebappAuthenticationValve.java:301)
at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:178)
at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47)
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62)
at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:145)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:59)
at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:126)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Updated by Viranga Gunarathna over 1 year ago
- Project changed from 33 to Backlog
Updated by Pramila Niroshan over 1 year ago
- Status changed from New to QA
In here issue was my sql transaction isolation level is REPEATABLE READ
we need to change it to READ-COMMITTED
1. Locate your MySQL configuration file:
- On Linux systems - /etc/mysql/my.cnf.
2. Open the MySQL configuration file using a text editor.
3. Find or create the [mysqld] section:
- If you already have a [mysqld] section, locate it within the file.
- If you don't have one, you can create it at the end of the file.
4. Add the `transaction_isolation` parameter:
- Add the following line under the [mysqld] section:
transaction_isolation=READ-COMMITTED
5. Save the changes to the MySQL configuration file.
6. Restart the MySQL server:
sudo service mysql restartwe can temporarily set this using bellow commands
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
SELECT @@global.transaction_ISOLATION;