@timestamp,@logStream,@message 2020-12-08 19:55:57.702,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.702 [vert.x-eventloop-thread-0] INFO LogUtil [10081875510eqId] 127.0.0.1:39692 GET /data-import/uploadDefinitions query=(status%3D%3D(%22NEW%22%20OR%20%22IN_PROGRESS%22%20OR%20%22LOADED%22))%20sortBy%20createdDate%2Fsort.descending&limit=1 HTTP_1_1 200 53 10 tid=fs00001019 OK 2020-12-08 19:55:57.701,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.701 [vert.x-eventloop-thread-0] INFO LogUtil [10081875509eqId] org.folio.rest.RestVerticle start invoking getDataImportUploadDefinitions 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.693,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:57.692 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081875500eqId] CQL >>> SQL: (status==(""NEW"" OR ""IN_PROGRESS"" OR ""LOADED"")) sortBy createdDate/sort.descending >>>WHERE ((lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS')))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))) ORDER BY left(lower(f_unaccent(upload_definitions.jsonb->>'createdDate')),600) DESC, lower(f_unaccent(upload_definitions.jsonb->>'createdDate')) DESC LIMIT 1 OFFSET 0" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:57.692,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:57.658,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.658 [vert.x-eventloop-thread-0] ERROR ileChunkingProcessor [10081875466eqId] File processing finished with errors. Can not send chunks of the file ./storage/upload/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6/918aebfc-661a-408a-bb55-92832c584131/dec08a.mrc 2020-12-08 19:55:57.658,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,io.vertx.ext.web.handler.impl.HttpStatusException: Internal Server Error 2020-12-08 19:55:57.658,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.658 [vert.x-eventloop-thread-0] ERROR ileChunkingProcessor [10081875466eqId] File processing stopped. Can not send the last chunk of the file ./storage/upload/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6/918aebfc-661a-408a-bb55-92832c584131/dec08a.mrc 2020-12-08 19:55:57.658,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.658 [vert.x-eventloop-thread-0] ERROR ileChunkingProcessor [10081875466eqId] File was processed with errors ./storage/upload/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6/918aebfc-661a-408a-bb55-92832c584131/dec08a.mrc. Cause: io.vertx.core.impl.NoStackTraceThrowable: File processing stopped. Can not send the last chunk of the file ./storage/upload/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6/918aebfc-661a-408a-bb55-92832c584131/dec08a.mrc 2020-12-08 19:55:57.657,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.657 [vert.x-eventloop-thread-0] ERROR ileChunkingProcessor [10081875465eqId] Error posting chunk of raw records for JobExecution with id c26fb94b-4146-40a7-a9ab-5d83ed2b7d4a. Status code Internal Server Error 2020-12-08 19:55:57.652,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.652 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081875460eqId] CQL >>> SQL: id==b0f7990e-dcc0-4a45-9847-b5ab0b771fc6 >>>WHERE id='b0f7990e-dcc0-4a45-9847-b5ab0b771fc6' 2020-12-08 19:55:57.651,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:57 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:57.651,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:57.649,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.649 [vert.x-eventloop-thread-0] WARN torageServiceBuilder [10081875457eqId] Request to mod-configuration was failed or property for lookup service is not define. Try to use default Local Storage! 2020-12-08 19:55:57.626,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:57.625 [vert.x-eventloop-thread-0] INFO ileChunkingProcessor [10081875433eqId] All the child jobs have been updated by job profile, parent job c26fb94b-4146-40a7-a9ab-5d83ed2b7d4a" 2020-12-08 19:55:57.625,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.625 [vert.x-eventloop-thread-0] INFO ileChunkingProcessor [10081875433eqId] Job profile for job c26fb94b-4146-40a7-a9ab-5d83ed2b7d4a successfully updated. 2020-12-08 19:55:57.616,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,19:55:57.615 [vert.x-eventloop-thread-0] INFO LogUtil [3680286413eqId] 127.0.0.1:47864 POST /data-import-profiles/jobProfileSnapshots/22fafcc3-f582-493d-88b0-3c538480cd83 HTTP_1_1 201 979 14 tid=fs00001019 Created 2020-12-08 19:55:57.615,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,19:55:57.615 [vert.x-eventloop-thread-0] INFO LogUtil [3680286413eqId] org.folio.rest.RestVerticle start invoking postDataImportProfilesJobProfileSnapshotsById 2020-12-08 19:55:57.498,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.497 [vert.x-eventloop-thread-0] INFO LogUtil [10081875305eqId] 127.0.0.1:39656 POST /data-import/uploadDefinitions/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6/processFiles defaultMapping=true HTTP_1_1 204 0 1 tid=fs00001019 No Content 2020-12-08 19:55:57.497,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.497 [vert.x-eventloop-thread-0] INFO DataImportImpl [10081875305eqId] Starting file processing for upload definition b0f7990e-dcc0-4a45-9847-b5ab0b771fc6 2020-12-08 19:55:57.497,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.497 [vert.x-eventloop-thread-0] INFO LogUtil [10081875305eqId] org.folio.rest.RestVerticle start invoking postDataImportUploadDefinitionsProcessFilesByUploadDefinitionId 2020-12-08 19:55:57.332,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.331 [vert.x-eventloop-thread-0] INFO LogUtil [10081875139eqId] org.folio.rest.RestVerticle start invoking getDataImportUploadDefinitionsByUploadDefinitionId 2020-12-08 19:55:57.332,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.332 [vert.x-eventloop-thread-0] INFO LogUtil [10081875140eqId] 127.0.0.1:39642 GET /data-import/uploadDefinitions/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6 null HTTP_1_1 200 994 3 tid=fs00001019 OK 2020-12-08 19:55:57.329,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:57.328 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081875136eqId] CRITERION >>> SQL: WHERE (jsonb->>'id') = 'b0f7990e-dcc0-4a45-9847-b5ab0b771fc6' >>>WHERE (jsonb->>'id') = 'b0f7990e-dcc0-4a45-9847-b5ab0b771fc6' 2020-12-08 19:55:50.670,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,19:55:50.670 [vert.x-eventloop-thread-0] INFO LogUtil [3680279468eqId] 127.0.0.1:47838 GET /data-import-profiles/jobProfiles limit=5000&query=%28dataType%3D%3D%28%22MARC%22%29%29%20sortby%20name HTTP_1_1 200 1947 78 tid=fs00001019 OK 2020-12-08 19:55:50.669,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,19:55:50.669 [vert.x-eventloop-thread-0] INFO LogUtil [3680279467eqId] org.folio.rest.RestVerticle start invoking getDataImportProfilesJobProfiles 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"19:55:50.660 [vert.x-eventloop-thread-0] INFO CQLWrapper [3680279458eqId] CQL >>> SQL: (dataType==(""MARC"")) sortby name >>>WHERE (lower(f_unaccent(job_profiles.jsonb->>'dataType')) LIKE lower(f_unaccent('MARC'))) and lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false')) ORDER BY left(lower(f_unaccent(job_profiles.jsonb->>'name')),600), lower(f_unaccent(job_profiles.jsonb->>'name')) LIMIT 5000 OFFSET 0" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"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'))" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"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'))" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"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'))" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"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'))" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.661,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.660,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.660,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"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'))" 2020-12-08 19:55:50.660,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.660,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.660,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.660,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"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'))" 2020-12-08 19:55:50.607,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,19:55:50.607 [vert.x-eventloop-thread-0] INFO LogUtil [702281881eqId] 127.0.0.1:57776 GET /data-import-profiles/jobProfiles limit=5000 HTTP_1_1 200 1947 42 tid=fs00001019 OK 2020-12-08 19:55:50.606,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,19:55:50.606 [vert.x-eventloop-thread-0] INFO LogUtil [702281880eqId] org.folio.rest.RestVerticle start invoking getDataImportProfilesJobProfiles 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,19:55:50.598 [vert.x-eventloop-thread-0] INFO CQLWrapper [702281872eqId] NONE >>> SQL: null >>>WHERE lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false')) LIMIT 5000 OFFSET 0 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.599,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"WARNING: Doing LIKE search without index for job_profiles.jsonb->>'deleted', CQL >>> SQL: deleted == false >>> lower(f_unaccent(job_profiles.jsonb->>'deleted')) LIKE lower(f_unaccent('false'))" 2020-12-08 19:55:50.593,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.593,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.592,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.592,gmsu/mod-data-import-converter-storage/b2ce31c80354410f8c3bd252a7521b64,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.567,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.567,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.566,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.566,gmsu/mod-data-import-converter-storage/da9ca416071648d58f1dbcf6cdbacfc6,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.405,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.404 [vert.x-eventloop-thread-0] INFO LogUtil [10081868212eqId] 127.0.0.1:39604 POST /data-import/uploadDefinitions/b0f7990e-dcc0-4a45-9847-b5ab0b771fc6/files/918aebfc-661a-408a-bb55-92832c584131 null HTTP_1_1 200 994 36 tid=fs00001019 OK 2020-12-08 19:55:50.405,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.405,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.405,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.405 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081868213eqId] CQL >>> SQL: id==b0f7990e-dcc0-4a45-9847-b5ab0b771fc6 >>>WHERE id='b0f7990e-dcc0-4a45-9847-b5ab0b771fc6' 2020-12-08 19:55:50.404,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:50.404 [vert.x-eventloop-thread-0] INFO LogUtil [10081868212eqId] org.folio.rest.RestVerticle start invoking public void org.folio.rest.impl.DataImportImpl.postDataImportUploadDefinitionsFilesByUploadDefinitionIdAndFileId(java.lang.String,java.lang.String,java.io.InputStream,java.util.Map,io.vertx.core.Handler,io.vertx.core.Context)" 2020-12-08 19:55:50.400,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:50.400 [vert.x-eventloop-thread-0] INFO LogUtil [10081868208eqId] org.folio.rest.RestVerticle start invoking public void org.folio.rest.impl.DataImportImpl.postDataImportUploadDefinitionsFilesByUploadDefinitionIdAndFileId(java.lang.String,java.lang.String,java.io.InputStream,java.util.Map,io.vertx.core.Handler,io.vertx.core.Context)" 2020-12-08 19:55:50.400,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:50.400 [vert.x-eventloop-thread-0] INFO LogUtil [10081868208eqId] org.folio.rest.RestVerticle start invoking public void org.folio.rest.impl.DataImportImpl.postDataImportUploadDefinitionsFilesByUploadDefinitionIdAndFileId(java.lang.String,java.lang.String,java.io.InputStream,java.util.Map,io.vertx.core.Handler,io.vertx.core.Context)" 2020-12-08 19:55:50.399,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:50.399 [vert.x-eventloop-thread-0] INFO LogUtil [10081868207eqId] org.folio.rest.RestVerticle start invoking public void org.folio.rest.impl.DataImportImpl.postDataImportUploadDefinitionsFilesByUploadDefinitionIdAndFileId(java.lang.String,java.lang.String,java.io.InputStream,java.util.Map,io.vertx.core.Handler,io.vertx.core.Context)" 2020-12-08 19:55:50.370,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.370,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.370,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.370 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081868178eqId] CQL >>> SQL: id==b0f7990e-dcc0-4a45-9847-b5ab0b771fc6 >>>WHERE id='b0f7990e-dcc0-4a45-9847-b5ab0b771fc6' 2020-12-08 19:55:50.367,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.366 [vert.x-eventloop-thread-0] INFO LogUtil [10081868174eqId] org.folio.rest.RestVerticle start invoking getDataImportFileExtensions 2020-12-08 19:55:50.367,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.367 [vert.x-eventloop-thread-0] INFO LogUtil [10081868175eqId] 127.0.0.1:39600 GET /data-import/fileExtensions query=extension==%22.mrc%22 HTTP_1_1 200 657 4 tid=fs00001019 OK 2020-12-08 19:55:50.364,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:50.363 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081868171eqId] CQL >>> SQL: extension=="".mrc"" >>>WHERE lower(f_unaccent(file_extensions.jsonb->>'extension')) LIKE lower(f_unaccent('.mrc')) LIMIT 10 OFFSET 0" 2020-12-08 19:55:50.363,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.363,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.202,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.201 [vert.x-eventloop-thread-0] INFO LogUtil [10081868009eqId] org.folio.rest.RestVerticle start invoking getDataImportUploadDefinitions 2020-12-08 19:55:50.202,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.202 [vert.x-eventloop-thread-0] INFO LogUtil [10081868010eqId] 127.0.0.1:39590 GET /data-import/uploadDefinitions query=(status%3D%3D(%22NEW%22%20OR%20%22IN_PROGRESS%22%20OR%20%22LOADED%22))%20sortBy%20createdDate%2Fsort.descending&limit=1 HTTP_1_1 200 905 11 tid=fs00001019 OK 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.192,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:50.191 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081867999eqId] CQL >>> SQL: (status==(""NEW"" OR ""IN_PROGRESS"" OR ""LOADED"")) sortBy createdDate/sort.descending >>>WHERE ((lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS')))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))) ORDER BY left(lower(f_unaccent(upload_definitions.jsonb->>'createdDate')),600) DESC, lower(f_unaccent(upload_definitions.jsonb->>'createdDate')) DESC LIMIT 1 OFFSET 0" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:50 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:50.191,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:50.052,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.052 [vert.x-eventloop-thread-0] INFO LogUtil [10081867860eqId] 127.0.0.1:39568 POST /data-import/uploadDefinitions null HTTP_1_1 201 809 204 tid=fs00001019 Created 2020-12-08 19:55:50.051,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:50.051 [vert.x-eventloop-thread-0] INFO LogUtil [10081867859eqId] org.folio.rest.RestVerticle start invoking postDataImportUploadDefinitions 2020-12-08 19:55:49.848,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:49.847 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081867655eqId] CRITERION >>> SQL: WHERE (jsonb->>'extension') = '.mrc' >>>WHERE (jsonb->>'extension') = '.mrc' 2020-12-08 19:55:49.512,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:49.512 [vert.x-eventloop-thread-0] INFO LogUtil [10081867320eqId] 127.0.0.1:39552 GET /data-import/uploadDefinitions query=(status%3D%3D(%22NEW%22%20OR%20%22IN_PROGRESS%22%20OR%20%22LOADED%22))%20sortBy%20createdDate%2Fsort.descending&limit=1 HTTP_1_1 200 53 7 tid=fs00001019 OK 2020-12-08 19:55:49.511,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:49.511 [vert.x-eventloop-thread-0] INFO LogUtil [10081867319eqId] org.folio.rest.RestVerticle start invoking getDataImportUploadDefinitions 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:49.505 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081867313eqId] CQL >>> SQL: (status==(""NEW"" OR ""IN_PROGRESS"" OR ""LOADED"")) sortBy createdDate/sort.descending >>>WHERE ((lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS')))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))) ORDER BY left(lower(f_unaccent(upload_definitions.jsonb->>'createdDate')),600) DESC, lower(f_unaccent(upload_definitions.jsonb->>'createdDate')) DESC LIMIT 1 OFFSET 0" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.506,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:49 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:49.505,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.367,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:29.366 [vert.x-eventloop-thread-0] INFO LogUtil [10081847174eqId] org.folio.rest.RestVerticle start invoking getDataImportUploadDefinitions 2020-12-08 19:55:29.367,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,19:55:29.367 [vert.x-eventloop-thread-0] INFO LogUtil [10081847175eqId] 127.0.0.1:39404 GET /data-import/uploadDefinitions query=(status%3D%3D(%22NEW%22%20OR%20%22IN_PROGRESS%22%20OR%20%22LOADED%22))%20sortBy%20createdDate%2Fsort.descending&limit=1 HTTP_1_1 200 53 54 tid=fs00001019 OK 2020-12-08 19:55:29.353,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.353,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:29.353,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.353,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"19:55:29.352 [vert.x-eventloop-thread-0] INFO CQLWrapper [10081847160eqId] CQL >>> SQL: (status==(""NEW"" OR ""IN_PROGRESS"" OR ""LOADED"")) sortBy createdDate/sort.descending >>>WHERE ((lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS')))) OR (lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))) ORDER BY left(lower(f_unaccent(upload_definitions.jsonb->>'createdDate')),600) DESC, lower(f_unaccent(upload_definitions.jsonb->>'createdDate')) DESC LIMIT 1 OFFSET 0" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == LOADED >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('LOADED'))" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.352,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:29.351,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.351,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == NEW >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('NEW'))" 2020-12-08 19:55:29.351,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON queryByLike" 2020-12-08 19:55:29.351,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"WARNING: Doing LIKE search without index for upload_definitions.jsonb->>'status', CQL >>> SQL: status == IN_PROGRESS >>> lower(f_unaccent(upload_definitions.jsonb->>'status')) LIKE lower(f_unaccent('IN\_PROGRESS'))" 2020-12-08 19:55:29.313,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,"Dec 08, 2020 7:55:29 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema" 2020-12-08 19:55:29.313,gmsu/mod-data-import/794282bd-f3de-40ae-a172-90e4c48ade7b,INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK