2022-04-13T11:00:28.929Z 2022-04-13T11:00:28,929 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:00:28.929Z 2022-04-13T11:00:28,929 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58082 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:00:29.647Z 2022-04-13T11:00:29,647 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:00:29.648Z 2022-04-13T11:00:29,647 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58090 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:04:29.112Z 2022-04-13T11:04:29,112 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:04:29.112Z 2022-04-13T11:04:29,112 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59604 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:04:29.873Z 2022-04-13T11:04:29,873 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:04:29.873Z 2022-04-13T11:04:29,873 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59612 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:06:59.182Z 2022-04-13T11:06:59,182 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:06:59.182Z 2022-04-13T11:06:59,182 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60284 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:06:59.998Z 2022-04-13T11:06:59,998 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:06:59.998Z 2022-04-13T11:06:59,998 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60290 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:11:59.404Z 2022-04-13T11:11:59,404 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:11:59.405Z 2022-04-13T11:11:59,404 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33292 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:12:00.249Z 2022-04-13T11:12:00,249 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:12:00.249Z 2022-04-13T11:12:00,249 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33298 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:00:12.002Z 2022-04-13T11:00:12,002 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAcquisitionsUnitsStorageMemberships
2022-04-13T11:00:12.003Z Apr 13, 2022 11:00:12 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
2022-04-13T11:00:12.003Z INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2022-04-13T11:00:12.011Z 2022-04-13T11:00:12,011 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: userId==9eb67301-6f6e-468f-9b1a-6134dc39a684 >>>WHERE CASE WHEN length(lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')) ELSE left(lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')),600) LIKE left(lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')),600) AND lower(f_unaccent(acquisitions_unit_membership.jsonb->>'userId')) LIKE lower(f_unaccent('9eb67301-6f6e-468f-9b1a-6134dc39a684')) END LIMIT 2147483647 OFFSET 0
2022-04-13T11:00:12.018Z 2022-04-13T11:00:12,018 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57812 GET /acquisitions-units-storage/memberships offset=0&query=userId%3D%3D9eb67301-6f6e-468f-9b1a-6134dc39a684&limit=2147483647 HTTP_1_1 200 4076 16 tid=fs09000000 OK 
2022-04-13T11:00:12.034Z 2022-04-13T11:00:12,034 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAcquisitionsUnitsStorageUnits
2022-04-13T11:00:12.034Z Apr 13, 2022 11:00:12 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
2022-04-13T11:00:12.034Z INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2022-04-13T11:00:12.038Z 2022-04-13T11:00:12,038 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: (isDeleted==false) and (protectRead==false) >>>WHERE (CASE WHEN length(lower(f_unaccent('false'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')),600) LIKE lower(f_unaccent('false')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')),600) LIKE left(lower(f_unaccent('false')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')) LIKE lower(f_unaccent('false')) END) AND (CASE WHEN length(lower(f_unaccent('false'))) <= 600 THEN left(lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')),600) LIKE lower(f_unaccent('false')) ELSE left(lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')),600) LIKE left(lower(f_unaccent('false')),600) AND lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')) LIKE lower(f_unaccent('false')) END) LIMIT 2147483647 OFFSET 0
2022-04-13T11:00:12.047Z 2022-04-13T11:00:12,046 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57816 GET /acquisitions-units-storage/units offset=0&query=%28isDeleted%3D%3Dfalse%29+and+%28protectRead%3D%3Dfalse%29&limit=2147483647 HTTP_1_1 200 6403 12 tid=fs09000000 OK 
2022-04-13T11:00:12.091Z 2022-04-13T11:00:12,091 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStoragePoLines
2022-04-13T11:00:12.091Z Apr 13, 2022 11:00:12 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
2022-04-13T11:00:12.091Z INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2022-04-13T11:00:12.096Z 2022-04-13T11:00:12,096 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: (purchaseOrder.acqUnitIds=(9bfe4e3a-4f69-4fcd-b83a-46bf580cd162 or 6dbffc23-0db9-423c-97c8-7acdc52e354c or e1459b3d-5bed-4600-b120-c990c66ddd76 or 76c3ebdf-b7a3-493e-b7c0-3c5ed3208266 or b50828f9-84f6-457f-b078-d223bbe0e5e3 or 5a1edf37-49ec-46f6-8c21-af4d7f40815f or 703e1c03-0312-4820-a15b-2ccdf98a929b or 28d95f2e-eb65-4533-b345-efaefe18189f or 78e8896d-bd1a-4f78-baa5-15ec95508cb3 or feb88e13-70ea-4b7c-a520-760aedd9de61 or ddaec974-82a1-4516-a12a-97d6411d1ad5 or 03ea0c24-448a-4882-8b7f-032c5f303f55 or 0ebb1f7d-983f-3026-8a4c-5318e0ebc041 or 348aaa0b-7e95-4b9b-8153-38863f522191 or b5e377b9-dbbd-4e71-ac18-f5f0dca905dc or 038373fe-6405-40e0-b017-8e52a63adb1f or ac9f5d95-fa07-44f2-89e6-18e440a4a6a2 or b7bed201-caf9-448c-bb65-0a389ca9fe0c or 2528aa13-d105-42b9-ae43-d19970e2600c) or (cql.allRecords=1 not purchaseOrder.acqUnitIds <> [])) and (((contributors=="*twitter*" or poLineNumber=="*twitter*" or requester=="*twitter*" or titleOrPackage=="*twitter*" or publisher=="*twitter*" or vendorDetail.vendorAccount=="*twitter*" or vendorDetail.referenceNumbers=="*twitter*" or donor=="*twitter*" or selector=="*twitter*" or physical.volumes=="*twitter*" or details.productIds=="*twitter*"))) sortby metadata.updatedDate/sort.descending >>>WHERE ((((((((((((((((((((po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('9bfe4e3a-4f69-4fcd-b83a-46bf580cd162')))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('6dbffc23-0db9-423c-97c8-7acdc52e354c'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('e1459b3d-5bed-4600-b120-c990c66ddd76'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('76c3ebdf-b7a3-493e-b7c0-3c5ed3208266'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('b50828f9-84f6-457f-b078-d223bbe0e5e3'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('5a1edf37-49ec-46f6-8c21-af4d7f40815f'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('703e1c03-0312-4820-a15b-2ccdf98a929b'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('28d95f2e-eb65-4533-b345-efaefe18189f'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('78e8896d-bd1a-4f78-baa5-15ec95508cb3'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('feb88e13-70ea-4b7c-a520-760aedd9de61'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('ddaec974-82a1-4516-a12a-97d6411d1ad5'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('03ea0c24-448a-4882-8b7f-032c5f303f55'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('348aaa0b-7e95-4b9b-8153-38863f522191'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('b5e377b9-dbbd-4e71-ac18-f5f0dca905dc'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('038373fe-6405-40e0-b017-8e52a63adb1f'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('ac9f5d95-fa07-44f2-89e6-18e440a4a6a2'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('b7bed201-caf9-448c-bb65-0a389ca9fe0c'))))) OR (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('2528aa13-d105-42b9-ae43-d19970e2600c'))))) OR ((true) AND ( (po_line.purchaseOrderId IN  ( SELECT id FROM purchase_order WHERE CASE WHEN length(lower(f_unaccent('[]'))) <= 600 THEN left(lower(f_unaccent(purchase_order.jsonb->>'acqUnitIds')),600) NOT LIKE lower(f_unaccent('[]')) ELSE left(lower(f_unaccent(purchase_order.jsonb->>'acqUnitIds')),600) NOT LIKE left(lower(f_unaccent('[]')),600) OR lower(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) NOT LIKE lower(f_unaccent('[]')) END)) IS NOT TRUE))) AND (((((((((((lower(f_unaccent(po_line.jsonb->>'contributors')) LIKE lower(f_unaccent('%twitter%'))) OR (lower(f_unaccent(po_line.jsonb->>'poLineNumber')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->>'requester')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->>'titleOrPackage')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->>'publisher')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'vendorAccount')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->>'donor')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->>'selector')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->'physical'->>'volumes')) LIKE lower(f_unaccent('%twitter%')))) OR (lower(f_unaccent(po_line.jsonb->'details'->>'productIds')) LIKE lower(f_unaccent('%twitter%')))) ORDER BY left(lower(f_unaccent(po_line.jsonb->'metadata'->>'updatedDate')),600) DESC, lower(f_unaccent(po_line.jsonb->'metadata'->>'updatedDate')) DESC LIMIT 10 OFFSET 0
2022-04-13T11:01:28.990Z 2022-04-13T11:01:28,989 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:01:28.990Z 2022-04-13T11:01:28,989 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58232 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:01:29.706Z 2022-04-13T11:01:29,706 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:01:29.706Z 2022-04-13T11:01:29,706 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58238 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:02:59.046Z 2022-04-13T11:02:59,046 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:02:59.046Z 2022-04-13T11:02:59,046 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58994 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:02:59.782Z 2022-04-13T11:02:59,782 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:02:59.782Z 2022-04-13T11:02:59,782 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59000 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T10:58:58.861Z 2022-04-13T10:58:58,861 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T10:58:58.861Z 2022-04-13T10:58:58,861 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57640 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T10:58:59.600Z 2022-04-13T10:58:59,600 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T10:58:59.600Z 2022-04-13T10:58:59,600 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57648 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T10:59:58.922Z 2022-04-13T10:59:58,922 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T10:59:58.922Z 2022-04-13T10:59:58,922 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57778 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T10:59:59.645Z 2022-04-13T10:59:59,645 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T10:59:59.645Z 2022-04-13T10:59:59,645 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57786 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:01:59.017Z 2022-04-13T11:01:59,017 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:01:59.017Z 2022-04-13T11:01:59,017 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58312 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:01:59.737Z 2022-04-13T11:01:59,737 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:01:59.737Z 2022-04-13T11:01:59,737 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58320 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:04:59.122Z 2022-04-13T11:04:59,122 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:04:59.122Z 2022-04-13T11:04:59,122 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59690 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:04:59.902Z 2022-04-13T11:04:59,902 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:04:59.902Z 2022-04-13T11:04:59,902 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59694 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:05:29.139Z 2022-04-13T11:05:29,139 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:05:29.139Z 2022-04-13T11:05:29,139 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59758 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:05:29.911Z 2022-04-13T11:05:29,911 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:05:29.911Z 2022-04-13T11:05:29,911 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59764 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:06:29.179Z 2022-04-13T11:06:29,179 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:06:29.179Z 2022-04-13T11:06:29,179 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60172 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:06:29.967Z 2022-04-13T11:06:29,967 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:06:29.967Z 2022-04-13T11:06:29,967 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60184 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:08:29.245Z 2022-04-13T11:08:29,245 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:08:29.245Z 2022-04-13T11:08:29,245 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60786 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:08:30.076Z 2022-04-13T11:08:30,076 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:08:30.076Z 2022-04-13T11:08:30,076 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60798 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:09:29.304Z 2022-04-13T11:09:29,304 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:09:29.304Z 2022-04-13T11:09:29,304 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60928 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:09:30.124Z 2022-04-13T11:09:30,124 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:09:30.124Z 2022-04-13T11:09:30,124 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60936 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:10:59.348Z 2022-04-13T11:10:59,347 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:10:59.348Z 2022-04-13T11:10:59,348 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33148 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:11:00.185Z 2022-04-13T11:11:00,185 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:11:00.185Z 2022-04-13T11:11:00,185 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33156 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:11:29.374Z 2022-04-13T11:11:29,374 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:11:29.374Z 2022-04-13T11:11:29,374 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33218 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:11:30.216Z 2022-04-13T11:11:30,216 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:11:30.216Z 2022-04-13T11:11:30,216 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33228 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T10:59:28.891Z 2022-04-13T10:59:28,891 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T10:59:28.891Z 2022-04-13T10:59:28,891 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57710 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T10:59:29.630Z 2022-04-13T10:59:29,630 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T10:59:29.631Z 2022-04-13T10:59:29,630 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57716 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:02:29.035Z 2022-04-13T11:02:29,035 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:02:29.036Z 2022-04-13T11:02:29,035 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58914 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:02:29.751Z 2022-04-13T11:02:29,751 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:02:29.751Z 2022-04-13T11:02:29,751 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58920 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:07:18.604Z 2022-04-13T11:07:18,604 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStorageTitles
2022-04-13T11:07:18.605Z Apr 13, 2022 11:07:18 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
2022-04-13T11:07:18.605Z INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2022-04-13T11:07:18.611Z Apr 13, 2022 11:07:18 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:18.611Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == 34fb123f-fb2f-47c2-b009-9f1d3763cc76 >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('34fb123f-fb2f-47c2-b009-9f1d3763cc76'))
2022-04-13T11:07:18.611Z Apr 13, 2022 11:07:18 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:18.611Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == 34fb123f-fb2f-47c2-b009-9f1d3763cc76 >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('34fb123f-fb2f-47c2-b009-9f1d3763cc76'))
2022-04-13T11:07:18.611Z 2022-04-13T11:07:18,611 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: instanceId==34fb123f-fb2f-47c2-b009-9f1d3763cc76 >>>WHERE lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('34fb123f-fb2f-47c2-b009-9f1d3763cc76')) LIMIT 5000 OFFSET 0
2022-04-13T11:07:18.611Z Apr 13, 2022 11:07:18 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:18.611Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == 34fb123f-fb2f-47c2-b009-9f1d3763cc76 >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('34fb123f-fb2f-47c2-b009-9f1d3763cc76'))
2022-04-13T11:07:18.611Z Apr 13, 2022 11:07:18 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:18.611Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == 34fb123f-fb2f-47c2-b009-9f1d3763cc76 >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('34fb123f-fb2f-47c2-b009-9f1d3763cc76'))
2022-04-13T11:07:18.611Z Apr 13, 2022 11:07:18 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:18.611Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == 34fb123f-fb2f-47c2-b009-9f1d3763cc76 >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('34fb123f-fb2f-47c2-b009-9f1d3763cc76'))
2022-04-13T11:07:18.652Z 2022-04-13T11:07:18,651 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60326 GET /orders-storage/titles offset=0&query=instanceId%3D%3D34fb123f-fb2f-47c2-b009-9f1d3763cc76&limit=5000 HTTP_1_1 200 42 47 tid=fs09000000 OK 
2022-04-13T11:07:29.197Z 2022-04-13T11:07:29,197 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:07:29.197Z 2022-04-13T11:07:29,197 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60366 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:07:30.021Z 2022-04-13T11:07:30,021 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:07:30.021Z 2022-04-13T11:07:30,021 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60372 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:09:59.336Z 2022-04-13T11:09:59,335 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:09:59.336Z 2022-04-13T11:09:59,335 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:32770 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:10:00.152Z 2022-04-13T11:10:00,152 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:10:00.152Z 2022-04-13T11:10:00,152 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:32780 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:10:29.337Z 2022-04-13T11:10:29,337 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:10:29.337Z 2022-04-13T11:10:29,337 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33082 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:10:30.155Z 2022-04-13T11:10:30,155 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:10:30.155Z 2022-04-13T11:10:30,155 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33090 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:12:59.464Z 2022-04-13T11:12:59,464 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:12:59.465Z 2022-04-13T11:12:59,464 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33660 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:13:00.306Z 2022-04-13T11:13:00,306 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:13:00.306Z 2022-04-13T11:13:00,306 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33670 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:00:58.960Z 2022-04-13T11:00:58,960 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:00:58.961Z 2022-04-13T11:00:58,960 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58154 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:00:59.676Z 2022-04-13T11:00:59,675 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:00:59.676Z 2022-04-13T11:00:59,675 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:58156 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:03:59.107Z 2022-04-13T11:03:59,107 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:03:59.107Z 2022-04-13T11:03:59,107 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59256 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:03:59.843Z 2022-04-13T11:03:59,843 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:03:59.843Z 2022-04-13T11:03:59,843 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59264 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:07:59.226Z 2022-04-13T11:07:59,226 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:07:59.226Z 2022-04-13T11:07:59,226 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60446 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:08:00.048Z 2022-04-13T11:08:00,047 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:08:00.048Z 2022-04-13T11:08:00,048 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60454 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:00:22.500Z 2022-04-13T11:00:22,500 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:57820 GET /orders-storage/po-lines offset=0&query=%28purchaseOrder.acqUnitIds%3D%289bfe4e3a-4f69-4fcd-b83a-46bf580cd162+or+6dbffc23-0db9-423c-97c8-7acdc52e354c+or+e1459b3d-5bed-4600-b120-c990c66ddd76+or+76c3ebdf-b7a3-493e-b7c0-3c5ed3208266+or+b50828f9-84f6-457f-b078-d223bbe0e5e3+or+5a1edf37-49ec-46f6-8c21-af4d7f40815f+or+703e1c03-0312-4820-a15b-2ccdf98a929b+or+28d95f2e-eb65-4533-b345-efaefe18189f+or+78e8896d-bd1a-4f78-baa5-15ec95508cb3+or+feb88e13-70ea-4b7c-a520-760aedd9de61+or+ddaec974-82a1-4516-a12a-97d6411d1ad5+or+03ea0c24-448a-4882-8b7f-032c5f303f55+or+0ebb1f7d-983f-3026-8a4c-5318e0ebc041+or+348aaa0b-7e95-4b9b-8153-38863f522191+or+b5e377b9-dbbd-4e71-ac18-f5f0dca905dc+or+038373fe-6405-40e0-b017-8e52a63adb1f+or+ac9f5d95-fa07-44f2-89e6-18e440a4a6a2+or+b7bed201-caf9-448c-bb65-0a389ca9fe0c+or+2528aa13-d105-42b9-ae43-d19970e2600c%29+or+%28cql.allRecords%3D1+not+purchaseOrder.acqUnitIds+%3C%3E+%5B%5D%29%29+and+%28%28%28contributors%3D%3D%22*twitter*%22+or+poLineNumber%3D%3D%22*twitter*%22+or+requester%3D%3D%22*twitter*%22+or+titleOrPackage%3D%3D%22*twitter*%22+or+publisher%3D%3D%22*twitter*%22+or+vendorDetail.vendorAccount%3D%3D%22*twitter*%22+or+vendorDetail.referenceNumbers%3D%3D%22*twitter*%22+or+donor%3D%3D%22*twitter*%22+or+selector%3D%3D%22*twitter*%22+or+physical.volumes%3D%3D%22*twitter*%22+or+details.productIds%3D%3D%22*twitter*%22%29%29%29+sortby+metadata.updatedDate%2Fsort.descending&limit=10 HTTP_1_1 200 31017 10409 tid=fs09000000 OK 
2022-04-13T11:05:59.150Z 2022-04-13T11:05:59,150 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:05:59.150Z 2022-04-13T11:05:59,150 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59822 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:05:59.939Z 2022-04-13T11:05:59,939 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:05:59.939Z 2022-04-13T11:05:59,939 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59832 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:03:29.076Z 2022-04-13T11:03:29,076 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:03:29.076Z 2022-04-13T11:03:29,076 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59146 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:03:29.812Z 2022-04-13T11:03:29,812 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:03:29.812Z 2022-04-13T11:03:29,812 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:59152 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:08:59.273Z 2022-04-13T11:08:59,273 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:08:59.273Z 2022-04-13T11:08:59,273 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60858 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:09:00.095Z 2022-04-13T11:09:00,094 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:09:00.095Z 2022-04-13T11:09:00,095 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60866 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:07:36.055Z 2022-04-13T11:07:36,055 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getOrdersStorageTitles
2022-04-13T11:07:36.055Z Apr 13, 2022 11:07:36 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
2022-04-13T11:07:36.055Z INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2022-04-13T11:07:36.060Z Apr 13, 2022 11:07:36 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:36.060Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == b987d843-c42a-452c-bb40-70f0080769df >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('b987d843-c42a-452c-bb40-70f0080769df'))
2022-04-13T11:07:36.060Z Apr 13, 2022 11:07:36 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:36.060Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == b987d843-c42a-452c-bb40-70f0080769df >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('b987d843-c42a-452c-bb40-70f0080769df'))
2022-04-13T11:07:36.060Z 2022-04-13T11:07:36,060 INFO  [vert.x-eventloop-thread-1] CQLWrapper CQL >>> SQL: instanceId==b987d843-c42a-452c-bb40-70f0080769df >>>WHERE lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('b987d843-c42a-452c-bb40-70f0080769df')) LIMIT 5000 OFFSET 0
2022-04-13T11:07:36.060Z Apr 13, 2022 11:07:36 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:36.060Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == b987d843-c42a-452c-bb40-70f0080769df >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('b987d843-c42a-452c-bb40-70f0080769df'))
2022-04-13T11:07:36.060Z Apr 13, 2022 11:07:36 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:36.060Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == b987d843-c42a-452c-bb40-70f0080769df >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('b987d843-c42a-452c-bb40-70f0080769df'))
2022-04-13T11:07:36.060Z Apr 13, 2022 11:07:36 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
2022-04-13T11:07:36.060Z WARNING: Doing LIKE search without index for titles.jsonb->>'instanceId', CQL >>> SQL: instanceId == b987d843-c42a-452c-bb40-70f0080769df >>> lower(f_unaccent(titles.jsonb->>'instanceId')) LIKE lower(f_unaccent('b987d843-c42a-452c-bb40-70f0080769df'))
2022-04-13T11:07:36.101Z 2022-04-13T11:07:36,101 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:60392 GET /orders-storage/titles offset=0&query=instanceId%3D%3Db987d843-c42a-452c-bb40-70f0080769df&limit=5000 HTTP_1_1 200 42 46 tid=fs09000000 OK 
2022-04-13T11:12:29.434Z 2022-04-13T11:12:29,434 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:12:29.434Z 2022-04-13T11:12:29,434 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33584 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK 
2022-04-13T11:12:30.276Z 2022-04-13T11:12:30,276 INFO  [vert.x-eventloop-thread-1] RestRouting invoking getAdminHealth
2022-04-13T11:12:30.276Z 2022-04-13T11:12:30,276 INFO  [vert.x-eventloop-thread-1] LogUtil 127.0.0.1:33602 GET /admin/health null HTTP_1_1 200 4 0 tid=null OK