Performing tests for Check-In/ Check-Out with DB read-write split disabled and enabled warnings about search without indexes were observed.

• 14:40:58 [113717/accounts] [fs09000000] [9eb67301-6f6e-468f-9b1a-6134dc39a684] [mod_feesfines] WARN  CQL2PgJSON           Doing LIKE search without index for accounts.jsonb->>'itemId', CQL >>> SQL: itemId == da00ead2-960d-4c46-9b87-0e5466d981b9 >>> lower(f_unaccent(accounts.jsonb->>'itemId')) LIKE lower(f_unaccent('da00ead2-960d-4c46-9b87-0e5466d981b9'))

• 14:40:58 [113717/accounts] [fs09000000] [9eb67301-6f6e-468f-9b1a-6134dc39a684] [mod_feesfines] WARN  CQL2PgJSON           Doing LIKE search without index for accounts.jsonb->'status'>>'name', CQL >>> SQL: status.name == Open >>> lower(f_unaccent(accounts.jsonb>'status'->>'name')) LIKE lower(f_unaccent('Open'))

Environment:

https://ptf-nolana-2.int.aws.folio.org/

ncp3