@timestamp,@message,@logStream 2021-04-12 14:19:50.267,14:19:50.267 [vert.x-eventloop-thread-0] INFO LogUtil [1788826049eqId] org.folio.rest.RestVerticle start invoking postChangeManagerJobExecutionsRecordsById,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.267,14:19:50.267 [vert.x-eventloop-thread-0] INFO LogUtil [1788826049eqId] 127.0.0.1:38598 POST /change-manager/jobExecutions/14d5a063-f6aa-4861-9966-145f1c80d4ef/records defaultMapping=false& HTTP_1_1 204 0 2176 tid=fs00001019 No Content ,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"Apr 12, 2021 2:19:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"Apr 12, 2021 2:19:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"Apr 12, 2021 2:19:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"Apr 12, 2021 2:19:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.254,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.253,"Apr 12, 2021 2:19:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.253,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.253,"Apr 12, 2021 2:19:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:50.253,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.475,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"WARNING: Doing FT search without index for job_executions.jsonb->>'status', CQL >>> SQL: status = DISCARDED >>> get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_phrase(f_unaccent('DISCARDED'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"WARNING: Doing LIKE search without index for job_executions.jsonb->>'uiStatus', CQL >>> SQL: uiStatus == PREPARING_FOR_PREVIEW >>> lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('PREPARING\_FOR\_PREVIEW'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"WARNING: Doing LIKE search without index for job_executions.jsonb->>'uiStatus', CQL >>> SQL: uiStatus == READY_FOR_PREVIEW >>> lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('READY\_FOR\_PREVIEW'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.475,"WARNING: Doing LIKE search without index for job_executions.jsonb->>'uiStatus', CQL >>> SQL: uiStatus == RUNNING >>> lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('RUNNING'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = """" >>> job_executions.jsonb->>'subordinationType' ~ ''",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = PARENT_MULTIPLE >>> get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.474,"WARNING: Doing FT search without index for job_executions.jsonb->>'status', CQL >>> SQL: status = """" >>> job_executions.jsonb->>'status' ~ ''",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:48.345,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.345,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = """" >>> job_executions.jsonb->>'subordinationType' ~ ''",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.345,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.345,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = PARENT_MULTIPLE >>> get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.345,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.345,"WARNING: Doing FT search without index for job_executions.jsonb->>'status', CQL >>> SQL: status any ""COMMITTED ERROR"" >>> get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.344,"Apr 12, 2021 2:19:48 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.344,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:48.096,14:19:48.096 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788823878eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:47.679,14:19:47.679 [vert.x-eventloop-thread-0] INFO LogUtil [1788922140eqId] org.folio.rest.RestVerticle start invoking postChangeManagerJobExecutionsRecordsById,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.679,14:19:47.679 [vert.x-eventloop-thread-0] INFO LogUtil [1788922140eqId] 127.0.0.1:60798 POST /change-manager/jobExecutions/14d5a063-f6aa-4861-9966-145f1c80d4ef/records defaultMapping=false& HTTP_1_1 204 0 8222 tid=fs00001019 No Content ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.675,14:19:47.675 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788922136eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"Apr 12, 2021 2:19:47 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"Apr 12, 2021 2:19:47 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"Apr 12, 2021 2:19:47 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"Apr 12, 2021 2:19:47 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"Apr 12, 2021 2:19:47 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"Apr 12, 2021 2:19:47 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.674,"WARNING: Doing FT search without index for job_execution_source_chunks.jsonb->>'last', CQL >>> SQL: last = true >>> get_tsvector(f_unaccent(job_execution_source_chunks.jsonb->>'last')) @@ tsquery_phrase(f_unaccent('true'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.659,14:19:47.659 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788922120eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.595,14:19:47.595 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788922056eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.544,14:19:47.544 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788922005eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.502,14:19:47.502 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921963eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.329,14:19:47.329 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921790eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.298,14:19:47.298 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921759eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.296,14:19:47.296 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921757eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.294,14:19:47.294 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921755eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.294,14:19:47.294 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921755eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.294,14:19:47.294 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921755eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.292,14:19:47.291 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921752eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.292,14:19:47.292 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921753eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.292,14:19:47.292 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921753eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:47.291,14:19:47.291 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921752eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:46.980,14:19:46.980 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788921441eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.611,14:19:43.611 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788918072eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.536,14:19:43.536 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917997eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.399,14:19:43.399 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917860eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.356,14:19:43.356 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917817eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.281,14:19:43.281 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917742eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.269,14:19:43.269 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917730eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:43.188,14:19:43.188 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917649eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.937,14:19:42.937 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917398eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.936,14:19:42.936 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917397eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,14:19:42.933 [vert.x-eventloop-thread-0] WARN PostgresClient [1788917394eqId] EXPLAIN ANALYZE SELECT,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, CASE,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId',",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," 'total', job_execution_progress.jsonb -> 'total',",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," END as jsonb, (SELECT COUNT(id) FROM fs00001019_mod_source_record_manager.job_executions WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) ) AS total_rows",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,FROM fs00001019_mod_source_record_manager.job_executions,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,LEFT JOIN fs00001019_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,"ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,LIMIT 25 OFFSET 0;,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,Limit (cost=6346.40..6360.21 rows=25 width=104) (actual time=2147.921..2174.275 rows=25 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, InitPlan 1 (returns $0),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Aggregate (cost=3112.15..3112.16 rows=1 width=8) (actual time=805.068..805.068 rows=1 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Seq Scan on job_executions job_executions_1 (cost=0.00..3112.08 rows=29 width=16) (actual time=0.244..804.566 rows=2431 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE) AND (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, Rows Removed by Filter: 71,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Result (cost=3234.23..3250.26 rows=29 width=104) (actual time=2147.920..2174.266 rows=25 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Sort (cost=3234.23..3234.31 rows=29 width=463) (actual time=2147.918..2147.925 rows=25 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," Sort Key: (""left""(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, Sort Method: top-N heapsort Memory: 52kB,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Hash Right Join (cost=3112.44..3233.53 rows=29 width=463) (actual time=1666.514..2144.005 rows=2431 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Seq Scan on job_execution_progress (cost=0.00..99.70 rows=2170 width=199) (actual time=0.003..0.491 rows=2178 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Hash (cost=3112.08..3112.08 rows=29 width=208) (actual time=861.209..861.209 rows=2431 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 584kB,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, -> Seq Scan on job_executions (cost=0.00..3112.08 rows=29 width=208) (actual time=0.205..859.605 rows=2431 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE) AND (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934, Rows Removed by Filter: 71,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,Planning time: 1.393 ms,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.934,Execution time: 2174.656 ms,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.933,14:19:42.933 [vert.x-eventloop-thread-0] INFO LogUtil [1788917394eqId] 127.0.0.1:60790 GET /metadata-provider/jobExecutions query=(status%20any%20%22COMMITTED%20ERROR%22)%20sortBy%20completedDate/sort.descending&limit=25 HTTP_1_1 200 4369535 4779 tid=fs00001019 OK ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.799,14:19:42.799 [vert.x-eventloop-thread-0] INFO LogUtil [1788917260eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.608,14:19:42.608 [vert.x-eventloop-thread-0] ERROR tpClientResponseImpl [1788917069eqId] io.vertx.core.VertxException: Connection was closed,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,14:19:42.285 [vert.x-eventloop-thread-0] WARN PostgresClient [1788916746eqId] EXPLAIN ANALYZE SELECT,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, CASE,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285," ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId',",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285," 'total', job_execution_progress.jsonb -> 'total',",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285," 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285," END as jsonb, (SELECT COUNT(id) FROM fs00001019_mod_source_record_manager.job_executions WHERE (((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND ((job_executions.jsonb->>'status' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_phrase(f_unaccent('DISCARDED'))) IS NOT TRUE))) AND (((lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('PREPARING\_FOR\_PREVIEW'))) OR (lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('READY\_FOR\_PREVIEW')))) OR (lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('RUNNING')))) ) AS total_rows",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,FROM fs00001019_mod_source_record_manager.job_executions,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,LEFT JOIN fs00001019_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,WHERE (((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND ((job_executions.jsonb->>'status' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_phrase(f_unaccent('DISCARDED'))) IS NOT TRUE))) AND (((lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('PREPARING\_FOR\_PREVIEW'))) OR (lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('READY\_FOR\_PREVIEW')))) OR (lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('RUNNING')))) ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,LIMIT 50 OFFSET 0;,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,Limit (cost=10790.31..10897.74 rows=44 width=40) (actual time=2073.023..2073.023 rows=0 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, InitPlan 1 (returns $0),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, -> Aggregate (cost=5394.93..5394.94 rows=1 width=8) (never executed),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, -> Seq Scan on job_executions job_executions_1 (cost=0.00..5394.82 rows=44 width=16) (never executed),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((jsonb ->> 'status'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''discarded'''::tsquery) IS NOT TRUE) AND ((lower(f_unaccent((jsonb ->> 'uiStatus'::text))) ~~ 'preparing\_for\_preview'::text) OR (lower(f_unaccent((jsonb ->> 'uiStatus'::text))) ~~ 'ready\_for\_preview'::text) OR (lower(f_unaccent((jsonb ->> 'uiStatus'::text))) ~~ 'running'::text)))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, -> Hash Right Join (cost=5395.37..5502.80 rows=44 width=40) (actual time=2073.022..2073.022 rows=0 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, -> Seq Scan on job_execution_progress (cost=0.00..99.70 rows=2170 width=199) (never executed),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, -> Hash (cost=5394.82..5394.82 rows=44 width=208) (actual time=2073.016..2073.016 rows=0 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, Buckets: 1024 Batches: 1 Memory Usage: 8kB,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, -> Seq Scan on job_executions (cost=0.00..5394.82 rows=44 width=208) (actual time=2073.015..2073.015 rows=0 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((jsonb ->> 'status'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''discarded'''::tsquery) IS NOT TRUE) AND ((lower(f_unaccent((jsonb ->> 'uiStatus'::text))) ~~ 'preparing\_for\_preview'::text) OR (lower(f_unaccent((jsonb ->> 'uiStatus'::text))) ~~ 'ready\_for\_preview'::text) OR (lower(f_unaccent((jsonb ->> 'uiStatus'::text))) ~~ 'running'::text)))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285, Rows Removed by Filter: 2502,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,Planning time: 2.928 ms,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.285,Execution time: 2073.251 ms,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.284,14:19:42.284 [vert.x-eventloop-thread-0] INFO LogUtil [1788916745eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:42.284,14:19:42.284 [vert.x-eventloop-thread-0] INFO LogUtil [1788916745eqId] 127.0.0.1:60788 GET /metadata-provider/jobExecutions query=(status=%22%22%20NOT%20status=DISCARDED)%20AND%20(uiStatus==(%22PREPARING_FOR_PREVIEW%22%20OR%20%22READY_FOR_PREVIEW%22%20OR%20%22RUNNING%22))&limit=50 HTTP_1_1 200 49 4145 tid=fs00001019 OK ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.664,14:19:41.664 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788916125eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.664,14:19:41.664 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788916125eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.663,14:19:41.663 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788916124eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.662,14:19:41.662 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788916123eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.366,14:19:41.366 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788915827eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.196,14:19:41.196 [vert.x-eventloop-thread-0] INFO ngeEngineServiceImpl [1788915657eqId] Parsed 26 records out of 26,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.004,"Apr 12, 2021 2:19:41 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:41.004,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:40.162,14:19:40.162 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788914623eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:39.476,14:19:39.475 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788913936eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:39.272,14:19:39.272 [vert.x-eventloop-thread-0] INFO LogUtil [1788913733eqId] 127.0.0.1:60794 PUT /change-manager/jobExecutions/14d5a063-f6aa-4861-9966-145f1c80d4ef/jobProfile HTTP_1_1 200 469103 768 tid=fs00001019 OK ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:39.269,14:19:39.269 [vert.x-eventloop-thread-0] INFO LogUtil [1788913730eqId] org.folio.rest.RestVerticle start invoking putChangeManagerJobExecutionsJobProfileById,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:39.231,"Apr 12, 2021 2:19:39 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:39.231,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.462,14:19:38.462 [vert.x-eventloop-thread-0] INFO LogUtil [1788814244eqId] 127.0.0.1:38070 GET /change-manager/jobExecutions/14d5a063-f6aa-4861-9966-145f1c80d4ef HTTP_1_1 200 527 468 tid=fs00001019 OK ,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:38.461,14:19:38.461 [vert.x-eventloop-thread-0] INFO LogUtil [1788814243eqId] org.folio.rest.RestVerticle start invoking getChangeManagerJobExecutionsById,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:38.155,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.155,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = """" >>> job_executions.jsonb->>'subordinationType' ~ ''",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.155,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.155,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = PARENT_MULTIPLE >>> get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.155,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.155,"WARNING: Doing FT search without index for job_executions.jsonb->>'status', CQL >>> SQL: status any ""COMMITTED ERROR"" >>> get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.154,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.154,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = """" >>> job_executions.jsonb->>'subordinationType' ~ ''",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = PARENT_MULTIPLE >>> get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing FT search without index for job_executions.jsonb->>'status', CQL >>> SQL: status = """" >>> job_executions.jsonb->>'status' ~ ''",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing FT search without index for job_executions.jsonb->>'status', CQL >>> SQL: status = DISCARDED >>> get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_phrase(f_unaccent('DISCARDED'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing LIKE search without index for job_executions.jsonb->>'uiStatus', CQL >>> SQL: uiStatus == PREPARING_FOR_PREVIEW >>> lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('PREPARING\_FOR\_PREVIEW'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing LIKE search without index for job_executions.jsonb->>'uiStatus', CQL >>> SQL: uiStatus == READY_FOR_PREVIEW >>> lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('READY\_FOR\_PREVIEW'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.140,"WARNING: Doing LIKE search without index for job_executions.jsonb->>'uiStatus', CQL >>> SQL: uiStatus == RUNNING >>> lower(f_unaccent(job_executions.jsonb->>'uiStatus')) LIKE lower(f_unaccent('RUNNING'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.139,"Apr 12, 2021 2:19:38 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:38.139,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,14:19:07.978 [vert.x-eventloop-thread-0] INFO LogUtil [1788882439eqId] 127.0.0.1:60654 GET /metadata-provider/jobExecutions query=(jobProfileInfo.id==%22066f270f-66e6-47a6-9e34-37eee305c185%22)%20sortBy%20completedDate/sort.descending&limit=25 HTTP_1_1 200 11567942 2856 tid=fs00001019 OK ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,14:19:07.978 [vert.x-eventloop-thread-0] WARN PostgresClient [1788882439eqId] EXPLAIN ANALYZE SELECT,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, CASE,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId',",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," 'total', job_execution_progress.jsonb -> 'total',",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," END as jsonb, (SELECT COUNT(id) FROM fs00001019_mod_source_record_manager.job_executions WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (lower(f_unaccent(job_executions.jsonb->'jobProfileInfo'->>'id')) LIKE lower(f_unaccent('066f270f-66e6-47a6-9e34-37eee305c185'))) ) AS total_rows",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,FROM fs00001019_mod_source_record_manager.job_executions,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,LEFT JOIN fs00001019_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (lower(f_unaccent(job_executions.jsonb->'jobProfileInfo'->>'id')) LIKE lower(f_unaccent('066f270f-66e6-47a6-9e34-37eee305c185'))) ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,"ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,LIMIT 25 OFFSET 0;,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,Limit (cost=4885.28..4893.57 rows=15 width=104) (actual time=1011.534..1057.296 rows=25 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, InitPlan 1 (returns $0),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Aggregate (cost=2385.46..2385.47 rows=1 width=8) (actual time=477.890..477.890 rows=1 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Seq Scan on job_executions job_executions_1 (cost=0.00..2385.42 rows=15 width=16) (actual time=6.911..477.847 rows=30 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND (lower(f_unaccent(((jsonb -> 'jobProfileInfo'::text) ->> 'id'::text))) ~~ '066f270f-66e6-47a6-9e34-37eee305c185'::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, Rows Removed by Filter: 2472,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Result (cost=2499.81..2508.10 rows=15 width=104) (actual time=1011.532..1057.286 rows=25 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Sort (cost=2499.81..2499.85 rows=15 width=463) (actual time=1009.288..1009.299 rows=25 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," Sort Key: (""left""(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, Sort Method: quicksort Memory: 40kB,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Hash Right Join (cost=2385.61..2499.52 rows=15 width=463) (actual time=969.770..1009.200 rows=30 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Seq Scan on job_execution_progress (cost=0.00..99.70 rows=2170 width=199) (actual time=0.003..0.292 rows=2177 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Hash (cost=2385.42..2385.42 rows=15 width=208) (actual time=490.777..490.777 rows=30 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, Buckets: 1024 Batches: 1 Memory Usage: 10kB,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, -> Seq Scan on job_executions (cost=0.00..2385.42 rows=15 width=208) (actual time=6.799..490.715 rows=30 loops=1),hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND (lower(f_unaccent(((jsonb -> 'jobProfileInfo'::text) ->> 'id'::text))) ~~ '066f270f-66e6-47a6-9e34-37eee305c185'::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978, Rows Removed by Filter: 2472,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,Planning time: 1.016 ms,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.978,Execution time: 1057.494 ms,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:07.549,14:19:07.549 [vert.x-eventloop-thread-0] INFO LogUtil [1788882010eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"Apr 12, 2021 2:19:05 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"Apr 12, 2021 2:19:05 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = """" >>> job_executions.jsonb->>'subordinationType' ~ ''",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"Apr 12, 2021 2:19:05 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = PARENT_MULTIPLE >>> get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"Apr 12, 2021 2:19:05 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:05.122,"WARNING: Doing LIKE search without index for job_executions.jsonb->'jobProfileInfo'->>'id', CQL >>> SQL: jobProfileInfo.id == 066f270f-66e6-47a6-9e34-37eee305c185 >>> lower(f_unaccent(job_executions.jsonb->'jobProfileInfo'->>'id')) LIKE lower(f_unaccent('066f270f-66e6-47a6-9e34-37eee305c185'))",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:02.336,14:19:02.336 [vert.x-eventloop-thread-0] INFO LogUtil [1788876797eqId] org.folio.rest.RestVerticle start invoking putChangeManagerJobExecutionsStatusById,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:02.336,14:19:02.336 [vert.x-eventloop-thread-0] INFO LogUtil [1788876797eqId] 127.0.0.1:60648 PUT /change-manager/jobExecutions/14d5a063-f6aa-4861-9966-145f1c80d4ef/status HTTP_1_1 200 527 379 tid=fs00001019 OK ,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:02.184,"Apr 12, 2021 2:19:02 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema",hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:02.184,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK,hmsu/mod-source-record-manager/48ec2dfd5a884ddcaa9bdc16ecf80653 2021-04-12 14:19:01.462,14:19:01.462 [vert.x-eventloop-thread-0] INFO LogUtil [1788777244eqId] 127.0.0.1:37400 POST /change-manager/jobExecutions HTTP_1_1 201 650 146 tid=fs00001019 Created ,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:01.461,14:19:01.461 [vert.x-eventloop-thread-0] INFO LogUtil [1788777243eqId] org.folio.rest.RestVerticle start invoking postChangeManagerJobExecutions,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:01.360,14:19:01.359 [vert.x-eventloop-thread-0] WARN PgCommandCodec [1788777141eqId] PrepareStatementCommandCodec should handle message ParameterStatus,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,14:19:00.412 [vert.x-eventloop-thread-0] INFO LogUtil [1788776194eqId] 127.0.0.1:37378 GET /metadata-provider/jobExecutions query=(status%20any%20%22COMMITTED%20ERROR%22)%20sortBy%20completedDate/sort.descending&limit=25 HTTP_1_1 200 4369535 4142 tid=fs00001019 OK ,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,14:19:00.413 [vert.x-eventloop-thread-0] WARN PostgresClient [1788776195eqId] EXPLAIN ANALYZE SELECT,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, CASE,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, WHEN job_execution_progress.jsonb IS NULL THEN job_executions.jsonb,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," ELSE jsonb_set(job_executions.jsonb, '{progress}', jsonb_build_object('jobExecutionId', job_execution_progress.jsonb -> 'jobExecutionId',",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," 'total', job_execution_progress.jsonb -> 'total',",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," 'current', (job_execution_progress.jsonb ->> 'currentlySucceeded')::int + (job_execution_progress.jsonb ->> 'currentlyFailed')::int))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," END as jsonb, (SELECT COUNT(id) FROM fs00001019_mod_source_record_manager.job_executions WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) ) AS total_rows",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,FROM fs00001019_mod_source_record_manager.job_executions,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,LEFT JOIN fs00001019_mod_source_record_manager.job_execution_progress ON job_executions.id = (job_execution_progress.jsonb ->> 'jobExecutionId')::uuid,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,WHERE ((job_executions.jsonb->>'subordinationType' ~ '') AND ( (get_tsvector(f_unaccent(job_executions.jsonb->>'subordinationType')) @@ tsquery_phrase(f_unaccent('PARENT_MULTIPLE'))) IS NOT TRUE)) AND (get_tsvector(f_unaccent(job_executions.jsonb->>'status')) @@ tsquery_or(f_unaccent('COMMITTED ERROR'))) ,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,"ORDER BY left(lower(f_unaccent(job_executions.jsonb->>'completedDate')),600) DESC, lower(f_unaccent(job_executions.jsonb->>'completedDate')) DESC",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,LIMIT 25 OFFSET 0;,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,Limit (cost=6346.40..6360.21 rows=25 width=104) (actual time=1887.777..1906.621 rows=25 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, InitPlan 1 (returns $0),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Aggregate (cost=3112.15..3112.16 rows=1 width=8) (actual time=706.420..706.420 rows=1 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Seq Scan on job_executions job_executions_1 (cost=0.00..3112.08 rows=29 width=16) (actual time=0.249..705.976 rows=2431 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE) AND (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, Rows Removed by Filter: 70,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Result (cost=3234.23..3250.26 rows=29 width=104) (actual time=1887.776..1906.613 rows=25 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Sort (cost=3234.23..3234.31 rows=29 width=463) (actual time=1887.774..1887.780 rows=25 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," Sort Key: (""left""(lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text))), 600)) DESC, (lower(f_unaccent((job_executions.jsonb ->> 'completedDate'::text)))) DESC",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, Sort Method: top-N heapsort Memory: 52kB,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Hash Right Join (cost=3112.44..3233.53 rows=29 width=463) (actual time=1424.476..1884.195 rows=2431 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, Hash Cond: (((job_execution_progress.jsonb ->> 'jobExecutionId'::text))::uuid = job_executions.id),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Seq Scan on job_execution_progress (cost=0.00..99.70 rows=2170 width=199) (actual time=0.005..0.463 rows=2177 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Hash (cost=3112.08..3112.08 rows=29 width=208) (actual time=717.813..717.813 rows=2431 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 584kB,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, -> Seq Scan on job_executions (cost=0.00..3112.08 rows=29 width=208) (actual time=0.203..716.407 rows=2431 loops=1),hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413," Filter: (((jsonb ->> 'subordinationType'::text) ~ ''::text) AND ((to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'subordinationType'::text)), '&'::text, ','::text)) @@ '''parent'' <-> ''multiple'''::tsquery) IS NOT TRUE) AND (to_tsvector('simple'::regconfig, translate(f_unaccent((jsonb ->> 'status'::text)), '&'::text, ','::text)) @@ '''committed'' | ''error'''::tsquery))",hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413, Rows Removed by Filter: 70,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,Planning time: 1.378 ms,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.413,Execution time: 1906.853 ms,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121 2021-04-12 14:19:00.308,14:19:00.308 [vert.x-eventloop-thread-0] INFO LogUtil [1788776090eqId] org.folio.rest.RestVerticle start invoking getMetadataProviderJobExecutions,hmsu/mod-source-record-manager/6d79679957c3488fa3b5a8ee457d2121