odpi / egeria-connector-xtdb

Pluggable repository for Egeria, using XTDB (formerly "Crux") as the back-end to natively support historical metadata.
https://odpi.github.io/egeria-docs/connectors/repository/xtdb/
Apache License 2.0
15 stars 7 forks source link

OMRS-AUDIT-9014 The Open Metadata Repository Service has generated an unexpected org.apache.lucene.queryparser.classic.ParseException exception during method findEntitiesByPropertyValue. #484

Open dwolfson opened 1 year ago

dwolfson commented 1 year ago

XTDB is configured with postgres here. These messages arose when using the JDBC integration connector against another postgres database. It looks like there is an issue parsing ':' in the path names?

OMRS-AUDIT-9014 The Open Metadata Repository Service has generated an unexpected org.apache.lucene.queryparser.classic.ParseException exception during method findEntitiesByPropertyValue. The message was Cannot parse '/laz:postgres:coco_ods::jdbc:postgresql://host.rancher-desktop.internal:5442/coco_ods::connection::endpoint/': Encountered " ":" ": "" at line 1, column 86. Was expecting one of:

... "(" ... "*" ... ... ... ... ... ... "[" ... "{" ... ... Tue Jul 11 01:55:47 GMT 2023 cocoMDS2 Exception OMRS-AUDIT-9014 Supplementary information: log record id b48512c6-761d-429b-affd-8989613bbc07 org.apache.lucene.queryparser.classic.ParseException returned message of Cannot parse '/laz:postgres:coco_ods::jdbc:postgresql://host.rancher-desktop.internal:5442/coco_ods::connection::endpoint/': Encountered " ":" ": "" at line 1, column 86. Was expecting one of: ... "(" ... "*" ... ... ... ... ... ... "[" ... "{" ... ... and stacktrace of org.apache.lucene.queryparser.classic.ParseException: Cannot parse '/laz:postgres:coco_ods::jdbc:postgresql://host.rancher-desktop.internal:5442/coco_ods::connection::endpoint/': Encountered " ":" ": "" at line 1, column 86. Was expecting one of: ... "(" ... "*" ... ... ... ... ... ... "[" ... "{" ... ... at org.apache.lucene.queryparser.classic.QueryParserBase.parse(QueryParserBase.java:114) at xtdb.lucene.egeria$build_query_cs_wildcard.invokeStatic(egeria.clj:117) at xtdb.lucene.egeria$build_query_cs_wildcard.invoke(egeria.clj:110) at clojure.lang.Var.invoke(Var.java:388) at xtdb.lucene$pred_constraint$pred_lucene_constraint__18483.invoke(lucene.clj:155) at xtdb.query$build_sub_query$constrain_result_fn__14372$fn__14373.invoke(query.clj:1671) at clojure.core$every_QMARK_.invokeStatic(core.clj:2698) at clojure.core$every_QMARK_.invoke(core.clj:2689) at xtdb.query$build_sub_query$constrain_result_fn__14372.invokePrim(query.clj:1670) at xtdb.query$build_sub_query$constrain_result_fn__14372.invoke(query.clj) at xtdb.query$build_sub_query$fn__14376.invoke(query.clj:1680) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.RT.seq(RT.java:535) at clojure.core$seq__5467.invokeStatic(core.clj:139) at clojure.core$seq__5467.invoke(core.clj:139) at xtdb.query$compile_find$fn__14678$iter__14681__14685$fn__14686.invoke(query.clj:1900) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.RT.seq(RT.java:535) at clojure.core$seq__5467.invokeStatic(core.clj:139) at clojure.core$partition_all$fn__8629.invoke(core.clj:7337) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.LazySeq.next(LazySeq.java:80) at clojure.lang.RT.next(RT.java:713) at clojure.core$next__5451.invokeStatic(core.clj:64) at clojure.core$second__5457.invokeStatic(core.clj:98) at clojure.core$second__5457.invoke(core.clj:98) at xtdb.io$external_sort$fn__4698.invoke(io.clj:167) at xtdb.io$with_nippy_thaw_all_STAR_.invokeStatic(io.clj:154) at xtdb.io$with_nippy_thaw_all_STAR_.invoke(io.clj:152) at xtdb.io$external_sort.invokeStatic(io.clj:165) at xtdb.io$external_sort.invoke(io.clj:159) at xtdb.io$external_sort.invokeStatic(io.clj:163) at xtdb.io$external_sort.invoke(io.clj:159) at xtdb.query$query$fn__14774.invoke(query.clj:1977) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:58) at clojure.lang.RT.seq(RT.java:535) at clojure.lang.SeqIterator.hasNext(SeqIterator.java:38) at xtdb.io.Cursor.hasNext(io.clj:282) at org.odpi.egeria.connectors.juxt.xtdb.readops.AbstractSearchOperation.deduplicateAndPage(AbstractSearchOperation.java:401) at org.odpi.egeria.connectors.juxt.xtdb.readops.AbstractSearchOperation.searchXtdbText(AbstractSearchOperation.java:270) at org.odpi.egeria.connectors.juxt.xtdb.readops.FindEntitiesByPropertyValue.runQuery(FindEntitiesByPropertyValue.java:76) at org.odpi.egeria.connectors.juxt.xtdb.readops.AbstractEntitySearchOperation.getResults(AbstractEntitySearchOperation.java:78) at org.odpi.egeria.connectors.juxt.xtdb.repositoryconnector.XtdbOMRSMetadataCollection.findEntitiesByPropertyValue(XtdbOMRSMetadataCollection.java:485) at org.odpi.openmetadata.repositoryservices.localrepository.repositoryconnector.LocalOMRSMetadataCollection.findEntitiesByPropertyValue(LocalOMRSMetadataCollection.java:2378) at org.odpi.openmetadata.repositoryservices.rest.server.OMRSRepositoryRESTServices.findEntitiesByPropertyValue(OMRSRepositoryRESTServices.java:3075) at org.odpi.openmetadata.repositoryservices.rest.server.spring.LocalRepositoryServicesResource.findEntitiesByPropertyValue(LocalRepositoryServicesResource.java:1027) at jdk.internal.reflect.GeneratedMethodAccessor480.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:590) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) at org.odpi.openmetadata.http.HttpRequestHeadersFilter.doFilter(HttpRequestHeadersFilter.java:62)