@timestamp,@message 2020-07-08 18:57:50.681,"08 Jul 2020 18:57:50:681 INFO PgUtil [94984478eqId] optimized SQL generated from CQL: WITH headrecords AS ( SELECT jsonb, (lower(f_unaccent(jsonb->>'title')) ) AS data_column FROM fs09000000_mod_inventory_storage.instance WHERE (((CASE WHEN length(lower('folio')) <= 600 THEN left(lower(instance.jsonb->>'source'),600) LIKE lower('folio') ELSE left(lower(instance.jsonb->>'source'),600) LIKE left(lower('folio'),600) AND lower(instance.jsonb->>'source') LIKE lower('folio') END) AND (to_tsvector('simple', f_unaccent(instance.jsonb->>'languages')) @@ tsquery_phrase(f_unaccent('eng')))) AND (to_tsvector('simple', f_unaccent(concat_space_sql(instance.jsonb->>'title' , concat_array_object_values(instance.jsonb->'contributors','name') , concat_array_object_values(instance.jsonb->'identifiers','value')))) @@ tsquery_and(f_unaccent('\\ united states\\""""')))) AND left(lower(f_unaccent(jsonb->>'title')) ,600) < ( SELECT left(lower(f_unaccent(jsonb->>'title')) ,600) FROM fs09000000_mod_inventory_storage.instance ORDER BY left(lower(f_unaccent(jsonb->>'title')) ,600) OFFSET 10000 LIMIT 1 ) ORDER BY left(lower(f_unaccent(jsonb->>'title')) ,600) LIMIT 100 OFFSET 0 ), allrecords AS ( SELECT jsonb, lower(f_unaccent(jsonb->>'title')) AS data_column FROM fs09000000_mod_inventory_storage.instance WHERE (((CASE WHEN length(lower('folio')) <= 600 THEN left(lower(instance.jsonb->>'source'),600) LIKE lower('folio') ELSE left(lower(instance.jsonb->>'source'),600) LIKE left(lower('folio'),600) AND lower(instance.jsonb->>'source') LIKE lower('folio') END) AND (to_tsvector('simple', f_unaccent(instance.jsonb->>'languages')) @@ tsquery_phrase(f_unaccent('eng')))) AND (to_tsvector('simple', f_unaccent(concat_space_sql(instance.jsonb->>'title' , concat_array_object_values(instance.jsonb->'contributors','name') , concat_array_object_values(instance.jsonb->'identifiers','value')))) @@ tsquery_and(f_unaccent('\\ united states\\""""')))) AND (SELECT COUNT(*) FROM headrecords) < 100 ), totalCount AS (SELECT fs09000000_mod_inventory_storage.count_estimate(' SELECT lower(f_unaccent(jsonb->>''title'')) AS data_column FROM fs09000000_mod_inventory_storage.instance WHERE ((CASE WHEN length(lower(''folio'')) <= 600 THEN left(lower(instance.jsonb->>''source''),600) LIKE lower(''folio'') ELSE left(lower(instance.jsonb->>''source''),600) LIKE left(lower(''folio''),600) AND lower(instance.jsonb->>''source'') LIKE lower(''folio'') END) AND (to_tsvector(''simple'', f_unaccent(instance.jsonb->>''languages'')) @@ tsquery_phrase(f_unaccent(''eng'')))) AND (to_tsvector(''simple'', f_unaccent(concat_space_sql(instance.jsonb->>''title'' , concat_array_object_values(instance.jsonb->''contributors'',''name'') , concat_array_object_values(instance.jsonb->''identifiers'',''value'')))) @@ tsquery_and(f_unaccent(''\\ united states\\""""'')))') AS count) SELECT jsonb, data_column, (SELECT count FROM totalCount) FROM headrecords WHERE (SELECT COUNT(*) FROM headrecords) >= 100 UNION (SELECT jsonb, data_column, (SELECT count FROM totalCount) FROM allrecords ORDER BY data_column LIMIT 100 OFFSET 0 ) ORDER BY data_column " 2020-07-08 18:57:50.681,"08 Jul 2020 18:57:50:681 INFO PgUtil [94984478eqId] Optimized SQL generated. Source CQL: (source==folio and languages=eng and keyword all \""united states\"") sortby title" 2020-07-08 18:57:50.680,"Jul 08, 2020 6:57:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-07-08 18:57:50.680,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-07-08 18:57:50.680,"Jul 08, 2020 6:57:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-07-08 18:57:50.680,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-07-08 18:57:50.661,"Jul 08, 2020 6:57:50 PM org.folio.inventory.common.WebRequestDiagnostics" 2020-07-08 18:57:50.661,INFO: Handling GET /inventory/instances 2020-07-08 18:57:16.503,"10.23.36.138 - - [08/Jul/2020:18:57:15 +0000] ""GET /mod-inventory-storage/instance-storage/instances?query=%28source%3D%3Dfolio+and+languages+in+%28eng%29+and++keyword++all+%5C%22united+states%5C%22%29+sortby+title&limit=100&offset=0 HTTP/1.1"" 400 120 rt=0.005 uct=""0.000"" uht=""0.005"" urt=""0.005"" ""-"" ""fs09000000"" ""eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJtYWdkYXoiLCJ1c2VyX2lkIjoiZTk2NjE4YTktMDRlZS00ZmVhLWFhNjAtMzA2YThmNGRkODliIiwibW9kdWxlIjoibW9kLWludmVudG9yeS0xNi4wLjAiLCJleHRyYV9wZXJtaXNzaW9ucyI6WyJTWVMjbW9kLWludmVudG9yeS0xNi4wLjAjXC9pbnZlbnRvcnlcL2luc3RhbmNlcyNbR0VUXSJdLCJyZXF1ZXN0X2lkIjoiNDU5MzE5XC9pbnZlbnRvcnkiLCJ0ZW5hbnQiOiJmczA5MDAwMDAwIn0.0gJswuPYXIXsQ1Fki3ax4MZMarf9wX11JtLTWqV1BHs"" ""-""" 2020-07-08 18:57:15.911,"10.23.36.138 - - [08/Jul/2020:18:57:15 +0000] ""GET /mod-inventory/inventory/instances?limit=100&query=%28source%3D%3Dfolio%20and%20languages%20in%20%28eng%29%20and%20%20keyword%20%20all%20%5C%22united%20states%5C%22%29%20sortby%20title HTTP/1.1"" 400 120 rt=0.060 uct=""0.001"" uht=""0.060"" urt=""0.060"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0"" ""fs09000000"" ""eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJtYWdkYXoiLCJ1c2VyX2lkIjoiZTk2NjE4YTktMDRlZS00ZmVhLWFhNjAtMzA2YThmNGRkODliIiwibW9kdWxlIjoibW9kLWludmVudG9yeS0xNi4wLjAiLCJleHRyYV9wZXJtaXNzaW9ucyI6WyJTWVMjbW9kLWludmVudG9yeS0xNi4wLjAjXC9pbnZlbnRvcnlcL2luc3RhbmNlcyNbR0VUXSJdLCJyZXF1ZXN0X2lkIjoiNDU5MzE5XC9pbnZlbnRvcnkiLCJ0ZW5hbnQiOiJmczA5MDAwMDAwIn0.0gJswuPYXIXsQ1Fki3ax4MZMarf9wX11JtLTWqV1BHs"" ""-""" 2020-07-08 18:57:15.581,"08 Jul 2020 18:57:15:580 ERROR PgUtil [94949377eqId] org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.581,"org.folio.rest.persist.cql.CQLQueryValidationException: org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.getWhereThis(CQLWrapper.java:177) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.getWhereOp(CQLWrapper.java:204) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.getWhereClause(CQLWrapper.java:227) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.getWithoutLimOff(CQLWrapper.java:278) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.toString(CQLWrapper.java:288) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.buildQueryHelper(PostgresClient.java:1993) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.doStreamGetCount(PostgresClient.java:1843) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.streamGet(PostgresClient.java:1819) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.lambda$38(PostgresClient.java:1791) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.lambda$70(PostgresClient.java:3062) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.lambda$69(PostgresClient.java:3041) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.sqlclient.impl.PoolBase$ConnectionWaiter.handle(PoolBase.java:165) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.sqlclient.impl.PoolBase$ConnectionWaiter.handle(PoolBase.java:151) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.impl.FutureImpl.dispatch(FutureImpl.java:105) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.impl.FutureImpl.tryComplete(FutureImpl.java:150) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.impl.FutureImpl.complete(FutureImpl.java:111) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.sqlclient.impl.ConnectionPool.check(ConnectionPool.java:196) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.sqlclient.impl.ConnectionPool.acquire(ConnectionPool.java:75) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.sqlclient.impl.PoolBase.getConnection(PoolBase.java:65) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.getConnection(PostgresClient.java:3035) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.getSQLConnection(PostgresClient.java:3053) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PostgresClient.streamGet(PostgresClient.java:1790) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PgUtil.streamGet(PgUtil.java:641) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PgUtil.streamGet(PgUtil.java:589) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.PgUtil.streamGet(PgUtil.java:557) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.impl.InstanceStorageAPI.getInstanceStorageInstances(InstanceStorageAPI.java:97) ~[ms.jar:?] 2020-07-08 18:57:15.581, at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source) ~[?:?] 2020-07-08 18:57:15.581, at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_242] 2020-07-08 18:57:15.581, at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_242] 2020-07-08 18:57:15.581, at org.folio.rest.RestVerticle.invoke(RestVerticle.java:953) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.RestVerticle.route(RestVerticle.java:547) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.RestVerticle.lambda$1(RestVerticle.java:289) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.ext.web.impl.RouteState.handleContext(RouteState.java:1034) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.ext.web.impl.RoutingContextImplBase.iterateNext(RoutingContextImplBase.java:131) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.ext.web.impl.RoutingContextImpl.next(RoutingContextImpl.java:133) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.ext.web.impl.RouterImpl.handle(RouterImpl.java:54) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.ext.web.impl.RouterImpl.handle(RouterImpl.java:36) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.http.impl.WebSocketRequestHandler.handle(WebSocketRequestHandler.java:50) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.http.impl.WebSocketRequestHandler.handle(WebSocketRequestHandler.java:32) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.http.impl.Http1xServerConnection.handleMessage(Http1xServerConnection.java:136) ~[ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.impl.ContextImpl.executeTask(ContextImpl.java:366) [ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:43) [ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.impl.ContextImpl.executeFromIO(ContextImpl.java:229) [ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.net.impl.VertxHandler.channelRead(VertxHandler.java:173) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:93) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.handler.codec.http.websocketx.extensions.WebSocketServerExtensionHandler.channelRead(WebSocketServerExtensionHandler.java:101) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.581, at io.vertx.core.http.impl.Http1xUpgradeToH2CHandler.channelRead(Http1xUpgradeToH2CHandler.java:109) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.handler.codec.MessageToMessageCodec.channelRead(MessageToMessageCodec.java:111) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:324) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:296) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [ms.jar:?] 2020-07-08 18:57:15.581, at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 2020-07-08 18:57:15.581, at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242] 2020-07-08 18:57:15.581,"Caused by: org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.581, at org.folio.cql2pgjson.CQL2PgJSON.toSql(CQL2PgJSON.java:293) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.getWhereThis(CQLWrapper.java:175) ~[ms.jar:?] 2020-07-08 18:57:15.581, ... 78 more 2020-07-08 18:57:15.581,"Caused by: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.581, at org.z3950.zing.cql.CQLParser.parseQuery(CQLParser.java:182) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.z3950.zing.cql.CQLParser.parseTerm(CQLParser.java:228) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.z3950.zing.cql.CQLParser.parseQuery(CQLParser.java:163) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.z3950.zing.cql.CQLParser.parseTopLevelPrefixes(CQLParser.java:136) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.z3950.zing.cql.CQLParser.parse(CQLParser.java:119) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.cql2pgjson.CQL2PgJSON.toSql(CQL2PgJSON.java:290) ~[ms.jar:?] 2020-07-08 18:57:15.581, at org.folio.rest.persist.cql.CQLWrapper.getWhereThis(CQLWrapper.java:175) ~[ms.jar:?] 2020-07-08 18:57:15.581, ... 78 more 2020-07-08 18:57:15.580,"08 Jul 2020 18:57:15:578 ERROR PostgresClient [94949375eqId] org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.580,"org.folio.rest.persist.cql.CQLQueryValidationException: org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.getWhereThis(CQLWrapper.java:177) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.getWhereOp(CQLWrapper.java:204) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.getWhereClause(CQLWrapper.java:227) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.getWithoutLimOff(CQLWrapper.java:278) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.toString(CQLWrapper.java:288) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.buildQueryHelper(PostgresClient.java:1993) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.doStreamGetCount(PostgresClient.java:1843) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.streamGet(PostgresClient.java:1819) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.lambda$38(PostgresClient.java:1791) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.lambda$70(PostgresClient.java:3062) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.lambda$69(PostgresClient.java:3041) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.sqlclient.impl.PoolBase$ConnectionWaiter.handle(PoolBase.java:165) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.sqlclient.impl.PoolBase$ConnectionWaiter.handle(PoolBase.java:151) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.impl.FutureImpl.dispatch(FutureImpl.java:105) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.impl.FutureImpl.tryComplete(FutureImpl.java:150) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.impl.FutureImpl.complete(FutureImpl.java:111) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.sqlclient.impl.ConnectionPool.check(ConnectionPool.java:196) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.sqlclient.impl.ConnectionPool.acquire(ConnectionPool.java:75) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.sqlclient.impl.PoolBase.getConnection(PoolBase.java:65) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.getConnection(PostgresClient.java:3035) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.getSQLConnection(PostgresClient.java:3053) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PostgresClient.streamGet(PostgresClient.java:1790) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PgUtil.streamGet(PgUtil.java:641) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PgUtil.streamGet(PgUtil.java:589) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.PgUtil.streamGet(PgUtil.java:557) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.impl.InstanceStorageAPI.getInstanceStorageInstances(InstanceStorageAPI.java:97) ~[ms.jar:?] 2020-07-08 18:57:15.580, at sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source) ~[?:?] 2020-07-08 18:57:15.580, at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_242] 2020-07-08 18:57:15.580, at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_242] 2020-07-08 18:57:15.580, at org.folio.rest.RestVerticle.invoke(RestVerticle.java:953) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.RestVerticle.route(RestVerticle.java:547) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.RestVerticle.lambda$1(RestVerticle.java:289) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.ext.web.impl.RouteState.handleContext(RouteState.java:1034) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.ext.web.impl.RoutingContextImplBase.iterateNext(RoutingContextImplBase.java:131) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.ext.web.impl.RoutingContextImpl.next(RoutingContextImpl.java:133) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.ext.web.impl.RouterImpl.handle(RouterImpl.java:54) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.ext.web.impl.RouterImpl.handle(RouterImpl.java:36) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.http.impl.WebSocketRequestHandler.handle(WebSocketRequestHandler.java:50) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.http.impl.WebSocketRequestHandler.handle(WebSocketRequestHandler.java:32) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.http.impl.Http1xServerConnection.handleMessage(Http1xServerConnection.java:136) ~[ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.impl.ContextImpl.executeTask(ContextImpl.java:366) [ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:43) [ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.impl.ContextImpl.executeFromIO(ContextImpl.java:229) [ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.net.impl.VertxHandler.channelRead(VertxHandler.java:173) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:93) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.handler.codec.http.websocketx.extensions.WebSocketServerExtensionHandler.channelRead(WebSocketServerExtensionHandler.java:101) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.580, at io.vertx.core.http.impl.Http1xUpgradeToH2CHandler.channelRead(Http1xUpgradeToH2CHandler.java:109) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.handler.codec.MessageToMessageCodec.channelRead(MessageToMessageCodec.java:111) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:324) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:296) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [ms.jar:?] 2020-07-08 18:57:15.580, at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [ms.jar:?] 2020-07-08 18:57:15.580, at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242] 2020-07-08 18:57:15.580,"Caused by: org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.580, at org.folio.cql2pgjson.CQL2PgJSON.toSql(CQL2PgJSON.java:293) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.getWhereThis(CQLWrapper.java:175) ~[ms.jar:?] 2020-07-08 18:57:15.580, ... 78 more 2020-07-08 18:57:15.580,"Caused by: org.z3950.zing.cql.CQLParseException: expected boolean, got '('" 2020-07-08 18:57:15.580, at org.z3950.zing.cql.CQLParser.parseQuery(CQLParser.java:182) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.z3950.zing.cql.CQLParser.parseTerm(CQLParser.java:228) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.z3950.zing.cql.CQLParser.parseQuery(CQLParser.java:163) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.z3950.zing.cql.CQLParser.parseTopLevelPrefixes(CQLParser.java:136) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.z3950.zing.cql.CQLParser.parse(CQLParser.java:119) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.cql2pgjson.CQL2PgJSON.toSql(CQL2PgJSON.java:290) ~[ms.jar:?] 2020-07-08 18:57:15.580, at org.folio.rest.persist.cql.CQLWrapper.getWhereThis(CQLWrapper.java:175) ~[ms.jar:?] 2020-07-08 18:57:15.580, ... 78 more 2020-07-08 18:57:15.578,"Jul 08, 2020 6:57:15 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-07-08 18:57:15.578,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-07-08 18:57:15.526,"Jul 08, 2020 6:57:15 PM org.folio.inventory.common.WebRequestDiagnostics" 2020-07-08 18:57:15.526,INFO: Handling GET /inventory/instances 2020-07-08 18:56:26.103,"10.23.36.138 - - [08/Jul/2020:18:56:25 +0000] ""GET /mod-inventory-storage/instance-bulk/ids?limit=2147483647&query=%28source%3D%3Dfolio%20and%20keyword%20%20all%20%5C%22united%20states%5C%22%29%20sortby%20title HTTP/1.1"" 200 10455164 rt=62.060 uct=""0.000"" uht=""27.335"" urt=""62.060"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0"" ""fs09000000"" ""eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJtYWdkYXoiLCJ1c2VyX2lkIjoiZTk2NjE4YTktMDRlZS00ZmVhLWFhNjAtMzA2YThmNGRkODliIiwiaWF0IjoxNTkzMTI0NTYwLCJ0ZW5hbnQiOiJmczA5MDAwMDAwIn0.1L2okF21zKnI7fX1ltSqQJsXlt5nw4wg0_2Fi2vYZV4"" ""-""" 2020-07-08 18:55:23.749,"08 Jul 2020 18:55:23:748 INFO CQLWrapper [94837455eqId] CQL >>> SQL: (source==folio and keyword all \""united states\"") sortby title >>>WHERE (CASE WHEN length(lower('folio')) <= 600 THEN left(lower(instance.jsonb->>'source'),600) LIKE lower('folio') ELSE left(lower(instance.jsonb->>'source'),600) LIKE left(lower('folio'),600) AND lower(instance.jsonb->>'source') LIKE lower('folio') END) AND (to_tsvector('simple', f_unaccent(concat_space_sql(instance.jsonb->>'title' , concat_array_object_values(instance.jsonb->'contributors','name') , concat_array_object_values(instance.jsonb->'identifiers','value')))) @@ tsquery_and(f_unaccent('""united states""'))) ORDER BY left(lower(f_unaccent(instance.jsonb->>'title')),600), lower(f_unaccent(instance.jsonb->>'title'))" 2020-07-08 18:55:23.749,"Jul 08, 2020 6:55:23 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-07-08 18:55:23.749,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK