30 Jul 2019 14:13:26:366 INFO LogUtil [2246316eqId] org.folio.rest.RestVerticle start invoking postInstanceStorageInstances 30 Jul 2019 14:13:26:368 INFO LogUtil [2246318eqId] 10.0.2.15:54542 POST /instance-storage/instances null HTTP_1_1 201 843 174 tid=diku Created 30 Jul 2019 14:13:26:406 INFO InstanceStorageAPI [2246356eqId] create wrapper[instance_relationship.jsonb] ------null Jul 30, 2019 2:13:26 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK Jul 30, 2019 2:13:26 PM org.folio.cql2pgjson.CQL2PgJSON initDbTable SEVERE: loadDbSchema(): No primary table name, can not load Jul 30, 2019 2:13:26 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'subInstanceId', CQL >>> SQL: subInstanceId == 150f8e3e-da01-40f0-b6a1-9cccd5a45b93 >>> lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93')) Jul 30, 2019 2:13:26 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'superInstanceId', CQL >>> SQL: superInstanceId == 150f8e3e-da01-40f0-b6a1-9cccd5a45b93 >>> lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93')) 30 Jul 2019 14:13:26:409 INFO CQLWrapper [2246359eqId] CQL >>> SQL: (subInstanceId==(150f8e3e-da01-40f0-b6a1-9cccd5a45b93) or superInstanceId==(150f8e3e-da01-40f0-b6a1-9cccd5a45b93)) >>> WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) LIMIT 10 OFFSET 0 30 Jul 2019 14:13:26:409 INFO InstanceStorageAPI [2246359eqId] SQL generated from CQL: WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) LIMIT 10 OFFSET 0 Jul 30, 2019 2:13:26 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'subInstanceId', CQL >>> SQL: subInstanceId == 150f8e3e-da01-40f0-b6a1-9cccd5a45b93 >>> lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93')) Jul 30, 2019 2:13:26 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'superInstanceId', CQL >>> SQL: superInstanceId == 150f8e3e-da01-40f0-b6a1-9cccd5a45b93 >>> lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93')) 30 Jul 2019 14:13:26:410 INFO CQLWrapper [2246360eqId] CQL >>> SQL: (subInstanceId==(150f8e3e-da01-40f0-b6a1-9cccd5a45b93) or superInstanceId==(150f8e3e-da01-40f0-b6a1-9cccd5a45b93)) >>> WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) LIMIT 10 OFFSET 0 30 Jul 2019 14:13:26:434 ERROR PostgresClient [2246384eqId] null net.sf.jsqlparser.JSQLParserException: null at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:56) ~[mod-inventory-storage-fat.jar:?] at org.folio.rest.persist.PostgresClient.parseQuery(PostgresClient.java:3557) ~[mod-inventory-storage-fat.jar:?] at org.folio.rest.persist.PostgresClient.prepareCountQuery(PostgresClient.java:1648) ~[mod-inventory-storage-fat.jar:?] at org.folio.rest.persist.PostgresClient.processQueryWithCount(PostgresClient.java:1599) ~[mod-inventory-storage-fat.jar:?] at org.folio.rest.persist.PostgresClient.lambda$27(PostgresClient.java:1427) ~[mod-inventory-storage-fat.jar:?] at io.vertx.core.impl.ContextImpl.lambda$wrapTask$2(ContextImpl.java:339) ~[mod-inventory-storage-fat.jar:?] at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:163) [mod-inventory-storage-fat.jar:?] at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:404) [mod-inventory-storage-fat.jar:?] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:463) [mod-inventory-storage-fat.jar:?] at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:886) [mod-inventory-storage-fat.jar:?] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [mod-inventory-storage-fat.jar:?] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181] Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 1, column 77. Was expecting one of: "AND" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... ")" ... at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16869) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16722) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:5014) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:4976) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:4947) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:4346) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:2691) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:2815) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:2572) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:2564) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:130) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81) ~[mod-inventory-storage-fat.jar:?] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:54) ~[mod-inventory-storage-fat.jar:?] ... 11 more 30 Jul 2019 14:13:26:437 ERROR PostgresClient [2246387eqId] query with count: ErrorMessage(fields=Map(Position -> 100, Line -> 720, Hint -> Could not choose a best candidate operator. You might need to add explicit type casts., File -> parse_oper.c, SQLSTATE -> 42725, Routine -> op_error, V -> ERROR, Message -> operator is not unique: unknown ->> unknown, Severity -> ERROR)) - SELECT COUNT(*) FROM diku_mod_inventory_storage.instance_relationship WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('150f8e3e-da01-40f0-b6a1-9cccd5a45b93'))) com.github.mauricio.async.db.postgresql.exceptions.GenericDatabaseException: ErrorMessage(fields=Map(Position -> 100, Line -> 720, Hint -> Could not choose a best candidate operator. You might need to add explicit type casts., File -> parse_oper.c, SQLSTATE -> 42725, Routine -> op_error, V -> ERROR, Message -> operator is not unique: unknown ->> unknown, Severity -> ERROR)) at com.github.mauricio.async.db.postgresql.PostgreSQLConnection.onError(PostgreSQLConnection.scala:175) [mod-inventory-storage-fat.jar:?] at com.github.mauricio.async.db.postgresql.codec.PostgreSQLConnectionHandler.channelRead0(PostgreSQLConnectionHandler.scala:206) [mod-inventory-storage-fat.jar:?] at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) [mod-inventory-storage-fat.jar:?] at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310) [mod-inventory-storage-fat.jar:?] at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:297) [mod-inventory-storage-fat.jar:?] at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:413) [mod-inventory-storage-fat.jar:?] at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:265) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) [mod-inventory-storage-fat.jar:?] at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1359) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) [mod-inventory-storage-fat.jar:?] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) [mod-inventory-storage-fat.jar:?] at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:935) [mod-inventory-storage-fat.jar:?] at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:141) [mod-inventory-storage-fat.jar:?] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) [mod-inventory-storage-fat.jar:?] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) [mod-inventory-storage-fat.jar:?] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) [mod-inventory-storage-fat.jar:?] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) [mod-inventory-storage-fat.jar:?] at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:886) [mod-inventory-storage-fat.jar:?] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [mod-inventory-storage-fat.jar:?] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181] 30 Jul 2019 14:13:26:439 INFO LogUtil [2246389eqId] org.folio.rest.RestVerticle start invoking getInstanceStorageInstanceRelationships 30 Jul 2019 14:13:26:440 INFO LogUtil [2246390eqId] 10.0.2.15:54542 GET /instance-storage/instance-relationships query=(subInstanceId==(150f8e3e-da01-40f0-b6a1-9cccd5a45b93)+or+superInstanceId==(150f8e3e-da01-40f0-b6a1-9cccd5a45b93)) HTTP_1_1 500 299 34 tid=diku Internal Server Error