Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
14:45:06.476 [vert.x-eventloop-thread-0] INFO  CQLWrapper           [79965280eqId] NONE >>> SQL: null >>>WHERE to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery LIMIT 5000 OFFSET 0
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
14:45:06.483 [vert.x-eventloop-thread-0] INFO  LogUtil              [79965287eqId] org.folio.rest.RestVerticle start  invoking getDataImportProfilesJobProfiles
14:45:06.483 [vert.x-eventloop-thread-0] INFO  LogUtil              [79965287eqId] 10.42.16.131:42624 GET /data-import-profiles/jobProfiles limit=5000 HTTP_1_1 200 47 16 tid=tamu OK
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for job_profiles.jsonb->>'dataType', CQL >>> SQL: dataType == MARC >>> lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for job_profiles.jsonb->>'dataType', CQL >>> SQL: dataType == MARC >>> lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))
14:45:06.488 [vert.x-eventloop-thread-0] INFO  CQLWrapper           [79965292eqId] CQL >>> SQL: (dataType==("MARC")) sortby name >>>WHERE (lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))) and to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery ORDER BY lower(f_unaccent(job_profiles.jsonb->>'name')) LIMIT 5000 OFFSET 0
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for job_profiles.jsonb->>'dataType', CQL >>> SQL: dataType == MARC >>> lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for job_profiles.jsonb->>'dataType', CQL >>> SQL: dataType == MARC >>> lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for job_profiles.jsonb->>'dataType', CQL >>> SQL: dataType == MARC >>> lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for job_profiles.jsonb->>'dataType', CQL >>> SQL: dataType == MARC >>> lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))
Apr 21, 2020 2:45:06 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted = false >>> to_tsvector('simple', f_unaccent(job_profiles.jsonb->>'deleted')) @@ replace((to_tsquery('simple', f_unaccent('''false''')))::text, '&', '<->')::tsquery
14:45:06.491 [vert.x-eventloop-thread-0] INFO  LogUtil              [79965295eqId] org.folio.rest.RestVerticle start  invoking getDataImportProfilesJobProfiles
14:45:06.492 [vert.x-eventloop-thread-0] INFO  LogUtil              [79965296eqId] 10.42.16.131:42624 GET /data-import-profiles/jobProfiles limit=5000&query=%28dataType%3D%3D%28%22MARC%22%29%29%20sortby%20name HTTP_1_1 200 47 6 tid=tamu OK
14:45:11.076 [vert.x-eventloop-thread-0] ERROR eSnapshotServiceImpl [79969880eqId] Cannot build snapshot for Profile 22fafcc3-f582-493d-88b0-3c538480cd83
14:45:11.076 [vert.x-eventloop-thread-0] ERROR ExceptionHelper      [79969880eqId] Cannot build snapshot for Profile 22fafcc3-f582-493d-88b0-3c538480cd83
io.vertx.core.impl.NoStackTraceThrowable: Cannot build snapshot for Profile 22fafcc3-f582-493d-88b0-3c538480cd83
14:45:11.077 [vert.x-eventloop-thread-0] INFO  LogUtil              [79969881eqId] org.folio.rest.RestVerticle start  invoking postDataImportProfilesJobProfileSnapshotsById
14:45:11.077 [vert.x-eventloop-thread-0] INFO  LogUtil              [79969881eqId] 10.42.17.233:59384 POST /data-import-profiles/jobProfileSnapshots/22fafcc3-f582-493d-88b0-3c538480cd83  HTTP_1_1 500 71 7 tid=tamu Internal Server Error