30 Jul 2019 14:06:25:417 INFO LogUtil [1825367eqId] org.folio.rest.RestVerticle start invoking postInstanceStorageInstances 30 Jul 2019 14:06:25:430 INFO LogUtil [1825380eqId] 10.0.2.15:54488 POST /instance-storage/instances null HTTP_1_1 201 841 420 tid=diku Created 30 Jul 2019 14:06:25:511 INFO InstanceStorageAPI [1825461eqId] create wrapper[instance_relationship.jsonb] ------null Jul 30, 2019 2:06:25 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK Jul 30, 2019 2:06:25 PM org.folio.cql2pgjson.CQL2PgJSON initDbTable SEVERE: loadDbSchema(): No primary table name, can not load Jul 30, 2019 2:06:25 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'subInstanceId', CQL >>> SQL: subInstanceId == 480fd5d8-63de-496a-92d1-7fd6045d60df >>> lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df')) Jul 30, 2019 2:06:25 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'superInstanceId', CQL >>> SQL: superInstanceId == 480fd5d8-63de-496a-92d1-7fd6045d60df >>> lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df')) 30 Jul 2019 14:06:25:530 INFO CQLWrapper [1825480eqId] CQL >>> SQL: (subInstanceId==(480fd5d8-63de-496a-92d1-7fd6045d60df) or superInstanceId==(480fd5d8-63de-496a-92d1-7fd6045d60df)) >>> WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) LIMIT 10 OFFSET 0 30 Jul 2019 14:06:25:531 INFO InstanceStorageAPI [1825481eqId] SQL generated from CQL: WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) LIMIT 10 OFFSET 0 Jul 30, 2019 2:06:25 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'subInstanceId', CQL >>> SQL: subInstanceId == 480fd5d8-63de-496a-92d1-7fd6045d60df >>> lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df')) Jul 30, 2019 2:06:25 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike WARNING: Doing LIKE search without index for null->>'superInstanceId', CQL >>> SQL: superInstanceId == 480fd5d8-63de-496a-92d1-7fd6045d60df >>> lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df')) 30 Jul 2019 14:06:25:535 INFO CQLWrapper [1825485eqId] CQL >>> SQL: (subInstanceId==(480fd5d8-63de-496a-92d1-7fd6045d60df) or superInstanceId==(480fd5d8-63de-496a-92d1-7fd6045d60df)) >>> WHERE (lower(f_unaccent(null->>'subInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) LIMIT 10 OFFSET 0 30 Jul 2019 14:06:25:576 ERROR PostgresClient [1825526eqId] 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:06:25:635 ERROR PostgresClient [1825585eqId] 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('480fd5d8-63de-496a-92d1-7fd6045d60df'))) OR (lower(f_unaccent(null->>'superInstanceId')) LIKE lower(f_unaccent('480fd5d8-63de-496a-92d1-7fd6045d60df'))) 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:06:25:639 INFO LogUtil [1825589eqId] org.folio.rest.RestVerticle start invoking getInstanceStorageInstanceRelationships 30 Jul 2019 14:06:25:641 INFO LogUtil [1825591eqId] 10.0.2.15:54488 GET /instance-storage/instance-relationships query=(subInstanceId==(480fd5d8-63de-496a-92d1-7fd6045d60df)+or+superInstanceId==(480fd5d8-63de-496a-92d1-7fd6045d60df)) HTTP_1_1 500 299 133 tid=diku Internal Server Error