2020-06-10T23:15:21.423-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:21.423-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T02:15:21.184 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' 2020-06-10T23:15:21.423-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:21.423-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T02:15:21.184 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' 2020-06-10T23:15:21.424-04:00 11 Jun 2020 03:15:21:423 INFO CQLWrapper [3191945299eqId] CQL >>> SQL: metadata.createdDate<2020-06-11T02:15:21.184 0000 >>>WHERE patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' LIMIT 10 OFFSET 0 2020-06-10T23:15:21.424-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:21.424-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T02:15:21.184 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' 2020-06-10T23:15:21.424-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:21.424-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T02:15:21.184 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' 2020-06-10T23:15:21.424-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:21.424-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T02:15:21.184 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' 2020-06-10T23:15:21.424-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:21.424-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T02:15:21.184 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T02:15:21.184 0000' 2020-06-10T23:15:21.425-04:00 11 Jun 2020 03:15:21:425 INFO LogUtil [3191945301eqId] org.folio.rest.RestVerticle start invoking getPatronActionSessionStoragePatronActionSessions 2020-06-10T23:15:21.426-04:00 11 Jun 2020 03:15:21:426 INFO LogUtil [3191945302eqId] 127.0.0.1:51988 GET /patron-action-session-storage/patron-action-sessions query=metadata.createdDate%3c2020-06-11T02:15:21.184+0000 HTTP_1_1 200 4711 3 tid=fs00001005 OK 2020-06-10T23:15:21.623-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:21.623-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:21.624-04:00 11 Jun 2020 03:15:21:624 INFO CQLWrapper [3191945500eqId] CQL >>> SQL: patronId=="4bafe1a0-d636-4f0d-b894-ee4f65ba8b29" and actionType=="Check-out" >>>WHERE (lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29'))) AND (lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out'))) LIMIT 200 OFFSET 0 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == 4bafe1a0-d636-4f0d-b894-ee4f65ba8b29 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == 4bafe1a0-d636-4f0d-b894-ee4f65ba8b29 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == 4bafe1a0-d636-4f0d-b894-ee4f65ba8b29 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == 4bafe1a0-d636-4f0d-b894-ee4f65ba8b29 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == 4bafe1a0-d636-4f0d-b894-ee4f65ba8b29 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == 4bafe1a0-d636-4f0d-b894-ee4f65ba8b29 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('4bafe1a0-d636-4f0d-b894-ee4f65ba8b29')) 2020-06-10T23:15:21.624-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.624-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.626-04:00 11 Jun 2020 03:15:21:625 INFO LogUtil [3191945501eqId] org.folio.rest.RestVerticle start invoking getPatronActionSessionStoragePatronActionSessions 2020-06-10T23:15:21.626-04:00 11 Jun 2020 03:15:21:626 INFO LogUtil [3191945502eqId] 127.0.0.1:51992 GET /patron-action-session-storage/patron-action-sessions query=patronId%3D%3D%224bafe1a0-d636-4f0d-b894-ee4f65ba8b29%22%20and%20actionType%3D%3D%22Check-out%22&limit=200 HTTP_1_1 200 521 3 tid=fs00001005 OK 2020-06-10T23:15:21.635-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:21.635-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.636-04:00 11 Jun 2020 03:15:21:636 INFO CQLWrapper [3191945512eqId] CQL >>> SQL: patronId=="f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b" and actionType=="Check-out" >>>WHERE (lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b'))) AND (lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out'))) LIMIT 200 OFFSET 0 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b')) 2020-06-10T23:15:21.636-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:21.636-04:00 WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) 2020-06-10T23:15:21.638-04:00 11 Jun 2020 03:15:21:638 INFO LogUtil [3191945514eqId] org.folio.rest.RestVerticle start invoking getPatronActionSessionStoragePatronActionSessions 2020-06-10T23:15:21.638-04:00 11 Jun 2020 03:15:21:638 INFO LogUtil [3191945514eqId] 127.0.0.1:51994 GET /patron-action-session-storage/patron-action-sessions query=patronId%3D%3D%22f01e2f5d-c5a3-4c2c-ba79-ddb7bfca568b%22%20and%20actionType%3D%3D%22Check-out%22&limit=200 HTTP_1_1 200 1919 2 tid=fs00001005 OK 2020-06-10T23:15:21.641-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:21.641-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:21.641-04:00 11 Jun 2020 03:15:21:641 INFO CQLWrapper [3191945517eqId] CQL >>> SQL: id==("7c74c321-486f-4493-ac28-a184481e29f8") >>>WHERE id='7c74c321-486f-4493-ac28-a184481e29f8' LIMIT 2147483647 OFFSET 0 2020-06-10T23:15:21.643-04:00 11 Jun 2020 03:15:21:642 INFO LogUtil [3191945518eqId] org.folio.rest.RestVerticle start invoking getLoanStorageLoans 2020-06-10T23:15:21.643-04:00 11 Jun 2020 03:15:21:643 INFO LogUtil [3191945519eqId] 127.0.0.1:51996 GET /loan-storage/loans query=id%3D%3D%28%227c74c321-486f-4493-ac28-a184481e29f8%22%29&limit=2147483647 HTTP_1_1 200 923 1 tid=fs00001005 OK 2020-06-10T23:15:21.656-04:00 Jun 11, 2020 3:15:21 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:21.656-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:21.656-04:00 11 Jun 2020 03:15:21:656 INFO CQLWrapper [3191945532eqId] CQL >>> SQL: id==("6379c012-7b99-4682-b154-ee0cf54f8a4b" or "6f236c29-dbeb-4bd6-998a-07e5a50d949a" or "209d7f3b-c575-40b5-bede-26fdd81b68b7" or "fcaa75ce-6d97-4f50-81b2-d0fbd6c811d7") >>>WHERE (((id='6379c012-7b99-4682-b154-ee0cf54f8a4b') OR (id='6f236c29-dbeb-4bd6-998a-07e5a50d949a')) OR (id='209d7f3b-c575-40b5-bede-26fdd81b68b7')) OR (id='fcaa75ce-6d97-4f50-81b2-d0fbd6c811d7') LIMIT 2147483647 OFFSET 0 2020-06-10T23:15:21.657-04:00 11 Jun 2020 03:15:21:657 INFO LogUtil [3191945533eqId] org.folio.rest.RestVerticle start invoking getLoanStorageLoans 2020-06-10T23:15:21.658-04:00 11 Jun 2020 03:15:21:657 INFO LogUtil [3191945533eqId] 127.0.0.1:51998 GET /loan-storage/loans query=id%3D%3D%28%226379c012-7b99-4682-b154-ee0cf54f8a4b%22%20or%20%226f236c29-dbeb-4bd6-998a-07e5a50d949a%22%20or%20%22209d7f3b-c575-40b5-bede-26fdd81b68b7%22%20or%20%22fcaa75ce-6d97-4f50-81b2-d0fbd6c811d7%22%29&limit=2147483647 HTTP_1_1 200 3848 2 tid=fs00001005 OK 2020-06-10T23:15:26.487-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:26.487-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:26.488-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.488-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:15:26.488-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.488-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:15:26.488-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.488-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:15:26.488-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.488-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:15:26.488-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.488-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:15:26.488-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.488-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:15:26.488-04:00 11 Jun 2020 03:15:26:488 INFO CQLWrapper [3191950364eqId] CQL >>> SQL: nextRunTime<"2020-06-11T00:00:00.000Z" and noticeConfig.sendInRealTime=="false" and triggeringEvent==("Due date") sortBy recipientUserId/sort.ascending noticeConfig.templateId/sort.ascending triggeringEvent/sort.ascending noticeConfig.format/sort.ascending noticeConfig.timing/sort.ascending >>>WHERE ((scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z') AND (lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')))) AND (lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date'))) ORDER BY left(lower(f_unaccent(scheduled_notice.jsonb->>'recipientUserId')),600), lower(f_unaccent(scheduled_notice.jsonb->>'recipientUserId')), left(lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'templateId')),600), lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'templateId')), left(lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')),600), lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')), left(lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'format')),600), lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'format')), left(lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'timing')),600), lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'timing')) LIMIT 100 OFFSET 0 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.489-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.489-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.489-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.489-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:15:26.489-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.489-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:15:26.491-04:00 11 Jun 2020 03:15:26:490 INFO LogUtil [3191950366eqId] org.folio.rest.RestVerticle start invoking getScheduledNoticeStorageScheduledNotices 2020-06-10T23:15:26.491-04:00 11 Jun 2020 03:15:26:491 INFO LogUtil [3191950367eqId] 127.0.0.1:52024 GET /scheduled-notice-storage/scheduled-notices query=nextRunTime%3C%222020-06-11T00%3A00%3A00.000Z%22%20and%20noticeConfig.sendInRealTime%3D%3D%22false%22%20and%20triggeringEvent%3D%3D%28%22Due%20date%22%29%20sortBy%20recipientUserId%2Fsort.ascending%20noticeConfig.templateId%2Fsort.ascending%20triggeringEvent%2Fsort.ascending%20noticeConfig.format%2Fsort.ascending%20noticeConfig.timing%2Fsort.ascending&limit=100 HTTP_1_1 200 52 3 tid=fs00001005 OK 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:26.990-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.990-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:15:26.980Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z' 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.990-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.990-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.990-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.990-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:15:26.980Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z' 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.990-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.990-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:15:26.990-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.990-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:15:26.991-04:00 11 Jun 2020 03:15:26:990 INFO CQLWrapper [3191950866eqId] CQL >>> SQL: nextRunTime<"2020-06-11T03:15:26.980Z" and noticeConfig.sendInRealTime=="true" and triggeringEvent==("Hold expiration" or "Request expiration") sortBy nextRunTime/sort.ascending >>>WHERE ((scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z') AND (lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')))) AND ((lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration'))) OR (lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')))) ORDER BY left(lower(f_unaccent(scheduled_notice.jsonb->>'nextRunTime')),600), lower(f_unaccent(scheduled_notice.jsonb->>'nextRunTime')) LIMIT 100 OFFSET 0 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.991-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:15:26.980Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z' 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.991-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:15:26.980Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z' 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.991-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:15:26.980Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z' 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:15:26.991-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:15:26.980Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:15:26.980Z' 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:15:26.991-04:00 Jun 11, 2020 3:15:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:15:26.991-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:15:26.992-04:00 11 Jun 2020 03:15:26:992 INFO LogUtil [3191950868eqId] org.folio.rest.RestVerticle start invoking getScheduledNoticeStorageScheduledNotices 2020-06-10T23:15:26.993-04:00 11 Jun 2020 03:15:26:992 INFO LogUtil [3191950868eqId] 127.0.0.1:52026 GET /scheduled-notice-storage/scheduled-notices query=nextRunTime%3C%222020-06-11T03%3A15%3A26.980Z%22%20and%20noticeConfig.sendInRealTime%3D%3D%22true%22%20and%20triggeringEvent%3D%3D%28%22Hold%20expiration%22%20or%20%22Request%20expiration%22%29%20sortBy%20nextRunTime%2Fsort.ascending&limit=100 HTTP_1_1 200 52 3 tid=fs00001005 OK 2020-06-10T23:15:36.984-04:00 11 Jun 2020 03:15:36:983 INFO LogUtil [3191960859eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:15:36.986-04:00 11 Jun 2020 03:15:36:985 INFO LogUtil [3191960861eqId] 127.0.0.1:52056 GET /admin/health null HTTP_1_1 200 4 2 tid=null OK 2020-06-10T23:15:37.012-04:00 Jun 11, 2020 3:15:37 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:15:37.012-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:15:37.013-04:00 11 Jun 2020 03:15:37:012 INFO CQLWrapper [3191960888eqId] CQL >>> SQL: status.name=="Closed" and userId="" >>>WHERE (lower(f_unaccent(loan.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Closed'))) AND (loan.jsonb->>'userId' ~ '') LIMIT 5000 OFFSET 0 2020-06-10T23:15:37.014-04:00 11 Jun 2020 03:15:37:013 INFO LogUtil [3191960889eqId] org.folio.rest.RestVerticle start invoking getLoanStorageLoans 2020-06-10T23:15:37.014-04:00 11 Jun 2020 03:15:37:014 INFO LogUtil [3191960890eqId] 127.0.0.1:52066 GET /loan-storage/loans query=status.name%3D%3D%22Closed%22%20and%20userId%3D%22%22&limit=5000 HTTP_1_1 200 41 2 tid=fs00001005 OK 2020-06-10T23:15:48.248-04:00 11 Jun 2020 03:15:48:247 INFO LogUtil [3191972123eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:15:48.248-04:00 11 Jun 2020 03:15:48:247 INFO LogUtil [3191972123eqId] 127.0.0.1:52088 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:16:07.010-04:00 11 Jun 2020 03:16:07:006 INFO LogUtil [3191990882eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:16:07.010-04:00 11 Jun 2020 03:16:07:006 INFO LogUtil [3191990882eqId] 127.0.0.1:52150 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:16:18.268-04:00 11 Jun 2020 03:16:18:266 INFO LogUtil [3192002142eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:16:18.268-04:00 11 Jun 2020 03:16:18:266 INFO LogUtil [3192002142eqId] 127.0.0.1:52168 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:16:29.959-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:16:29.959-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:16:29.960-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:29.960-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:29.960-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:29.960-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:29.960-04:00 11 Jun 2020 03:16:29:960 INFO CQLWrapper [3192013836eqId] CQL >>> SQL: (metadata.createdDate<2020-06-11T01:39:54.218 0000) >>>WHERE patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' LIMIT 10 OFFSET 0 2020-06-10T23:16:29.960-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:29.960-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:29.960-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:29.960-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:29.960-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:29.960-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:29.960-04:00 Jun 11, 2020 3:16:29 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:29.960-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:29.961-04:00 11 Jun 2020 03:16:29:961 INFO LogUtil [3192013837eqId] org.folio.rest.RestVerticle start invoking getPatronActionSessionStoragePatronActionSessions 2020-06-10T23:16:29.962-04:00 11 Jun 2020 03:16:29:962 INFO LogUtil [3192013838eqId] 127.0.0.1:52204 GET /patron-action-session-storage/patron-action-sessions query=%28metadata.createdDate%3c2020-06-11T01:39:54.218+0000%29 HTTP_1_1 200 4711 2 tid=fs00001005 OK 2020-06-10T23:16:36.995-04:00 Jun 11, 2020 3:16:36 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:16:36.995-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:16:36.996-04:00 11 Jun 2020 03:16:36:995 INFO CQLWrapper [3192020871eqId] CQL >>> SQL: status.name=="Closed" and userId="" >>>WHERE (lower(f_unaccent(loan.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Closed'))) AND (loan.jsonb->>'userId' ~ '') LIMIT 5000 OFFSET 0 2020-06-10T23:16:36.997-04:00 11 Jun 2020 03:16:36:996 INFO LogUtil [3192020872eqId] org.folio.rest.RestVerticle start invoking getLoanStorageLoans 2020-06-10T23:16:36.997-04:00 11 Jun 2020 03:16:36:997 INFO LogUtil [3192020873eqId] 127.0.0.1:52236 GET /loan-storage/loans query=status.name%3D%3D%22Closed%22%20and%20userId%3D%22%22&limit=5000 HTTP_1_1 200 41 2 tid=fs00001005 OK 2020-06-10T23:16:37.039-04:00 11 Jun 2020 03:16:37:038 INFO LogUtil [3192020914eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:16:37.040-04:00 11 Jun 2020 03:16:37:040 INFO LogUtil [3192020916eqId] 127.0.0.1:52238 GET /admin/health null HTTP_1_1 200 4 1 tid=null OK 2020-06-10T23:16:37.506-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:16:37.506-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:16:37.507-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:37.507-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:37.507-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:37.507-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:37.507-04:00 11 Jun 2020 03:16:37:507 INFO CQLWrapper [3192021383eqId] CQL >>> SQL: (metadata.createdDate<2020-06-11T01:39:54.218 0000) >>>WHERE patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' LIMIT 10 OFFSET 0 2020-06-10T23:16:37.507-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:37.507-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:37.507-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:37.507-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:37.507-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:37.507-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:37.507-04:00 Jun 11, 2020 3:16:37 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:16:37.507-04:00 WARNING: Doing SQL query without index for patron_action_session.jsonb->'metadata'->>'createdDate', CQL >>> SQL: metadata.createdDate < "2020-06-11T01:39:54.218 0000" >>> patron_action_session.jsonb->'metadata'->>'createdDate' <'2020-06-11T01:39:54.218 0000' 2020-06-10T23:16:37.508-04:00 11 Jun 2020 03:16:37:508 INFO LogUtil [3192021384eqId] org.folio.rest.RestVerticle start invoking getPatronActionSessionStoragePatronActionSessions 2020-06-10T23:16:37.509-04:00 11 Jun 2020 03:16:37:509 INFO LogUtil [3192021385eqId] 127.0.0.1:52250 GET /patron-action-session-storage/patron-action-sessions query=%28metadata.createdDate%3c2020-06-11T01:39:54.218+0000%29 HTTP_1_1 200 4711 2 tid=fs00001005 OK 2020-06-10T23:16:48.294-04:00 11 Jun 2020 03:16:48:294 INFO LogUtil [3192032170eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:16:48.295-04:00 11 Jun 2020 03:16:48:294 INFO LogUtil [3192032170eqId] 127.0.0.1:52270 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:17:07.067-04:00 11 Jun 2020 03:17:07:062 INFO LogUtil [3192050938eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:17:07.067-04:00 11 Jun 2020 03:17:07:063 INFO LogUtil [3192050939eqId] 127.0.0.1:52334 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:17:18.324-04:00 11 Jun 2020 03:17:18:324 INFO LogUtil [3192062200eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:17:18.325-04:00 11 Jun 2020 03:17:18:325 INFO LogUtil [3192062201eqId] 127.0.0.1:52366 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:17:26.492-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:17:26.492-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:17:26.492-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.492-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:17:26.492-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.492-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:17:26.492-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.492-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:17:26.492-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.492-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:17:26.492-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.492-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:17:26.493-04:00 11 Jun 2020 03:17:26:493 INFO CQLWrapper [3192070369eqId] CQL >>> SQL: nextRunTime<"2020-06-11T00:00:00.000Z" and noticeConfig.sendInRealTime=="false" and triggeringEvent==("Due date") sortBy recipientUserId/sort.ascending noticeConfig.templateId/sort.ascending triggeringEvent/sort.ascending noticeConfig.format/sort.ascending noticeConfig.timing/sort.ascending >>>WHERE ((scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z') AND (lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')))) AND (lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date'))) ORDER BY left(lower(f_unaccent(scheduled_notice.jsonb->>'recipientUserId')),600), lower(f_unaccent(scheduled_notice.jsonb->>'recipientUserId')), left(lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'templateId')),600), lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'templateId')), left(lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')),600), lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')), left(lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'format')),600), lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'format')), left(lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'timing')),600), lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'timing')) LIMIT 100 OFFSET 0 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.493-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.493-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.493-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.493-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T00:00:00.000Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T00:00:00.000Z' 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == false >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('false')) 2020-06-10T23:17:26.493-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.493-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:17:26.494-04:00 11 Jun 2020 03:17:26:494 INFO LogUtil [3192070370eqId] org.folio.rest.RestVerticle start invoking getScheduledNoticeStorageScheduledNotices 2020-06-10T23:17:26.495-04:00 11 Jun 2020 03:17:26:495 INFO LogUtil [3192070371eqId] 127.0.0.1:52392 GET /scheduled-notice-storage/scheduled-notices query=nextRunTime%3C%222020-06-11T00%3A00%3A00.000Z%22%20and%20noticeConfig.sendInRealTime%3D%3D%22false%22%20and%20triggeringEvent%3D%3D%28%22Due%20date%22%29%20sortBy%20recipientUserId%2Fsort.ascending%20noticeConfig.templateId%2Fsort.ascending%20triggeringEvent%2Fsort.ascending%20noticeConfig.format%2Fsort.ascending%20noticeConfig.timing%2Fsort.ascending&limit=100 HTTP_1_1 200 52 3 tid=fs00001005 OK 2020-06-10T23:17:26.993-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:17:26.993-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.994-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:17:26.983Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z' 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.994-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:17:26.983Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z' 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:17:26.994-04:00 11 Jun 2020 03:17:26:994 INFO CQLWrapper [3192070870eqId] CQL >>> SQL: nextRunTime<"2020-06-11T03:17:26.983Z" and noticeConfig.sendInRealTime=="true" and triggeringEvent==("Hold expiration" or "Request expiration") sortBy nextRunTime/sort.ascending >>>WHERE ((scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z') AND (lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')))) AND ((lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration'))) OR (lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')))) ORDER BY left(lower(f_unaccent(scheduled_notice.jsonb->>'nextRunTime')),600), lower(f_unaccent(scheduled_notice.jsonb->>'nextRunTime')) LIMIT 100 OFFSET 0 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.994-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:17:26.983Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z' 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:17:26.994-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.994-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.995-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:17:26.983Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z' 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.995-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:17:26.983Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z' 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:17:26.995-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:17:26.983Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:17:26.983Z' 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Hold expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Hold expiration')) 2020-06-10T23:17:26.995-04:00 Jun 11, 2020 3:17:26 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:17:26.995-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Request expiration" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Request expiration')) 2020-06-10T23:17:26.996-04:00 11 Jun 2020 03:17:26:996 INFO LogUtil [3192070872eqId] org.folio.rest.RestVerticle start invoking getScheduledNoticeStorageScheduledNotices 2020-06-10T23:17:26.996-04:00 11 Jun 2020 03:17:26:996 INFO LogUtil [3192070872eqId] 127.0.0.1:52394 GET /scheduled-notice-storage/scheduled-notices query=nextRunTime%3C%222020-06-11T03%3A17%3A26.983Z%22%20and%20noticeConfig.sendInRealTime%3D%3D%22true%22%20and%20triggeringEvent%3D%3D%28%22Hold%20expiration%22%20or%20%22Request%20expiration%22%29%20sortBy%20nextRunTime%2Fsort.ascending&limit=100 HTTP_1_1 200 52 3 tid=fs00001005 OK 2020-06-10T23:17:36.998-04:00 Jun 11, 2020 3:17:36 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:17:36.998-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:17:36.999-04:00 11 Jun 2020 03:17:36:999 INFO CQLWrapper [3192080875eqId] CQL >>> SQL: status.name=="Closed" and userId="" >>>WHERE (lower(f_unaccent(loan.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Closed'))) AND (loan.jsonb->>'userId' ~ '') LIMIT 5000 OFFSET 0 2020-06-10T23:17:37.000-04:00 11 Jun 2020 03:17:37:000 INFO LogUtil [3192080876eqId] org.folio.rest.RestVerticle start invoking getLoanStorageLoans 2020-06-10T23:17:37.000-04:00 11 Jun 2020 03:17:37:000 INFO LogUtil [3192080876eqId] 127.0.0.1:52426 GET /loan-storage/loans query=status.name%3D%3D%22Closed%22%20and%20userId%3D%22%22&limit=5000 HTTP_1_1 200 41 2 tid=fs00001005 OK 2020-06-10T23:17:37.092-04:00 11 Jun 2020 03:17:37:091 INFO LogUtil [3192080967eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:17:37.092-04:00 11 Jun 2020 03:17:37:092 INFO LogUtil [3192080968eqId] 127.0.0.1:52430 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:17:48.336-04:00 11 Jun 2020 03:17:48:335 INFO LogUtil [3192092211eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:17:48.336-04:00 11 Jun 2020 03:17:48:336 INFO LogUtil [3192092212eqId] 127.0.0.1:52454 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:18:07.100-04:00 11 Jun 2020 03:18:07:099 INFO LogUtil [3192110975eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:18:07.102-04:00 11 Jun 2020 03:18:07:100 INFO LogUtil [3192110976eqId] 127.0.0.1:52516 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:18:18.344-04:00 11 Jun 2020 03:18:18:344 INFO LogUtil [3192122220eqId] org.folio.rest.RestVerticle start invoking getAdminHealth 2020-06-10T23:18:18.344-04:00 11 Jun 2020 03:18:18:344 INFO LogUtil [3192122220eqId] 127.0.0.1:52542 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 2020-06-10T23:18:20.360-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema 2020-06-10T23:18:20.360-04:00 INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-06-10T23:18:20.360-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:18:20.360-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:18:20.343Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z' 2020-06-10T23:18:20.360-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.360-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:18:20.360-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.360-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:18:20.360-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:18:20.360-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:18:20.343Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z' 2020-06-10T23:18:20.360-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.360-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:18:20.361-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.361-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:18:20.361-04:00 11 Jun 2020 03:18:20:361 INFO CQLWrapper [3192124237eqId] CQL >>> SQL: nextRunTime<"2020-06-11T03:18:20.343Z" and noticeConfig.sendInRealTime=="true" and triggeringEvent==("Due date") sortBy nextRunTime/sort.ascending >>>WHERE ((scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z') AND (lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')))) AND (lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date'))) ORDER BY left(lower(f_unaccent(scheduled_notice.jsonb->>'nextRunTime')),600), lower(f_unaccent(scheduled_notice.jsonb->>'nextRunTime')) LIMIT 100 OFFSET 0 2020-06-10T23:18:20.361-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:18:20.361-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:18:20.343Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z' 2020-06-10T23:18:20.361-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.361-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:18:20.361-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.361-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:18:20.361-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:18:20.361-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:18:20.343Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z' 2020-06-10T23:18:20.361-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.361-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:18:20.362-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.362-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:18:20.362-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:18:20.362-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:18:20.343Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z' 2020-06-10T23:18:20.362-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.362-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:18:20.362-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.362-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->>'triggeringEvent', CQL >>> SQL: triggeringEvent == "Due date" >>> lower(f_unaccent(scheduled_notice.jsonb->>'triggeringEvent')) LIKE lower(f_unaccent('Due date')) 2020-06-10T23:18:20.362-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryBySql 2020-06-10T23:18:20.362-04:00 WARNING: Doing SQL query without index for scheduled_notice.jsonb->>'nextRunTime', CQL >>> SQL: nextRunTime < 2020-06-11T03:18:20.343Z >>> scheduled_notice.jsonb->>'nextRunTime' <'2020-06-11T03:18:20.343Z' 2020-06-10T23:18:20.363-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike 2020-06-10T23:18:20.363-04:00 WARNING: Doing LIKE search without index for scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime', CQL >>> SQL: noticeConfig.sendInRealTime == true >>> lower(f_unaccent(scheduled_notice.jsonb->'noticeConfig'->>'sendInRealTime')) LIKE lower(f_unaccent('true')) 2020-06-10T23:18:20.363-04:00 Jun 11, 2020 3:18:20 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike