Dear community, Within our company we are developing a new project based on Jackrabbit Oak version 1.72.0. We are experiencing some issues when we try to create a session and login into the repository. An SQL exception occurs at the time of the login due to the LeasCheckDocumentStoreWrapper that tries to execute a query. Below you can find the stacktrace:
Caused by: javax.jcr.LoginException: org.apache.jackrabbit.oak.plugins.document.DocumentStoreException: SQL exception on query (cause: ORA-00933: SQL command not properly ended ) at org.apache.jackrabbit.oak.plugins.document.rdb.RDBJDBCTools.asDocumentStoreException(RDBJDBCTools.java:435) at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalQuery(RDBDocumentStore.java:1822) at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.query(RDBDocumentStore.java:296) at org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.query(RDBDocumentStore.java:285) at org.apache.jackrabbit.oak.plugins.document.util.LeaseCheckDocumentStoreWrapper.query(LeaseCheckDocumentStoreWrapper.java:78) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.readChildDocs(DocumentNodeStore.java:1575) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.readChildren(DocumentNodeStore.java:1514) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore$6.call(DocumentNodeStore.java:1466) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore$6.call(DocumentNodeStore.java:1463) at org.apache.jackrabbit.oak.cache.CacheLIRS$Segment.load(CacheLIRS.java:1019) at org.apache.jackrabbit.oak.cache.CacheLIRS$Segment.get(CacheLIRS.java:980) at org.apache.jackrabbit.oak.cache.CacheLIRS.get(CacheLIRS.java:291) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.getChildren(DocumentNodeStore.java:1463) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.getChildNodes(DocumentNodeStore.java:1600) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeState.getChildNodeEntries(DocumentNodeState.java:574) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeState$ChildNodeEntryIterator.fetchMore(DocumentNodeState.java:725) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeState$ChildNodeEntryIterator.<init>(DocumentNodeState.java:690) at org.apache.jackrabbit.oak.plugins.document.DocumentNodeState$2.iterator(DocumentNodeState.java:371) at org.apache.jackrabbit.oak.plugins.index.property.PropertyIndex.createPlan(PropertyIndex.java:126) at org.apache.jackrabbit.oak.plugins.index.property.PropertyIndex.getPlan(PropertyIndex.java:113) at org.apache.jackrabbit.oak.plugins.index.property.PropertyIndex.getCost(PropertyIndex.java:256) at org.apache.jackrabbit.oak.query.QueryImpl.getBestSelectorExecutionPlan(QueryImpl.java:1156) at org.apache.jackrabbit.oak.query.QueryImpl.getBestSelectorExecutionPlan(QueryImpl.java:1072) at org.apache.jackrabbit.oak.query.ast.SelectorImpl.prepare(SelectorImpl.java:311) at org.apache.jackrabbit.oak.query.QueryImpl.prepare(QueryImpl.java:733) at org.apache.jackrabbit.oak.query.QueryEngineImpl.prepareAndSelect(QueryEngineImpl.java:332) at org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:286) at org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:302) at org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:248) at org.apache.jackrabbit.oak.plugins.identifier.IdentifierManager.resolveUUIDToTree(IdentifierManager.java:345) at org.apache.jackrabbit.oak.plugins.identifier.IdentifierManager.getTree(IdentifierManager.java:135) at org.apache.jackrabbit.oak.security.user.AuthorizableBaseProvider.getByContentID(AuthorizableBaseProvider.java:59) at org.apache.jackrabbit.oak.security.user.AuthorizableBaseProvider.getByID(AuthorizableBaseProvider.java:54) at org.apache.jackrabbit.oak.security.user.UserProvider.getAuthorizable(UserProvider.java:209) at org.apache.jackrabbit.oak.security.user.UserManagerImpl.getAuthorizable(UserManagerImpl.java:125) at org.apache.jackrabbit.oak.security.user.UserAuthentication.getValidUser(UserAuthentication.java:163) at org.apache.jackrabbit.oak.security.user.UserAuthentication.authenticate(UserAuthentication.java:106) at org.apache.jackrabbit.oak.security.authentication.user.LoginModuleImpl.authenticate(LoginModuleImpl.java:261) at org.apache.jackrabbit.oak.security.authentication.user.LoginModuleImpl.login(LoginModuleImpl.java:130) at java.base/javax.security.auth.login.LoginContext.invoke(LoginContext.java:755) at java.base/javax.security.auth.login.LoginContext$4.run(LoginContext.java:679) at java.base/javax.security.auth.login.LoginContext$4.run(LoginContext.java:677) at java.base/java.security.AccessController.doPrivileged(AccessController.java:712) at java.base/javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:677) at java.base/javax.security.auth.login.LoginContext.login(LoginContext.java:587) at org.apache.jackrabbit.oak.core.ContentRepositoryImpl.login(ContentRepositoryImpl.java:170) at org.apache.jackrabbit.oak.jcr.repository.RepositoryImpl.login(RepositoryImpl.java:303) at org.apache.jackrabbit.oak.jcr.repository.RepositoryImpl.login(RepositoryImpl.java:246) at org.springframework.extensions.jcr.JcrSessionFactory.getSession(JcrSessionFactory.java:278) at org.springframework.extensions.jcr.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:87) at org.springframework.extensions.jcr.SessionFactoryUtils.getSession(SessionFactoryUtils.java:119) at org.springframework.extensions.jcr.support.JcrDaoSupport.getSession(JcrDaoSupport.java:115) at org.springframework.extensions.jcr.support.JcrDaoSupport.getSession(JcrDaoSupport.java:96) at be.cipalschaubroeck.csfilestore.core.adapter.out.jackrabbitoak.repository.api.JcrRepositorySupport.getNodeByPath(JcrRepositorySupport.java:62) The query it tries to execute and is not closed properly is the following: Caused by: Error : 933, Position : 160, Sql = select ID, MODIFIED, MODCOUNT, CMODCOUNT, HASBINARY, DELETEDONCE, VERSION, SDTYPE, SDMAXREVTIME, DATA, BDATA from NODES where ID > :1 and ID < :2 order by ID FETCH FIRST 101 ROWS ONLY, OriginalSql = select ID, MODIFIED, MODCOUNT, CMODCOUNT, HASBINARY, DELETEDONCE, VERSION, SDTYPE, SDMAXREVTIME, DATA, BDATA from NODES where ID > ? and ID < ? order by ID FETCH FIRST 101 ROWS ONLY, Error Msg = ORA-00933: SQL command not properly ended Any idea what triggers this problem or any solution for this problem? I'm looking forward to your response. Kind regards, [cid:db9729f5-2839-4339-9191-5ac98677d94a] Senne Wens Software Engineer M +32 492 84 82 05 Cipal Schaubroeck nv Zetel en vestiging Geel: Cipalstraat 3 | 2440 Geel Vestiging 2 Geel: Bell-Telephonelaan 2D | 2440 Geel Vestiging Nazareth: Steenweg Deinze 154 | 9810 Nazareth http://www.cipalschaubroeck.be<http://www.cipalschaubroeck.be/> [facebook 18x18px]<https://www.facebook.com/CipalSchaubroeck/> [Linkedin 18x18px] <https://www.linkedin.com/company/cipalschaubroeck> [Twitter 18x18px] <https://twitter.com/CipalSchaub> [youtube 18x18px] <https://www.youtube.com/channel/UCJch-7kD5eZNTCHjBqFyJrQ> **** DISCLAIMER **** http://www.cipalschaubroeck.be/disclaimer
