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

[dwolfson]

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)