[CI] TransformInsufficientPermissionsIT testTransformPermissionsDeferUnattendedNoDest failing about elasticsearch HOT 5 CLOSED

Expected: a collection with size <2>
     but: collection size was <1>

{
  "checkpointing": {
    "last": {
      "checkpoint": "1",
      "timestamp_millis": "1708495449698",
      "time_upper_bound_millis": "1708495448698"
    }
  },
  "node": {
    "transport_address": "127.0.0.1:40149",
    "name": "javaRestTest-1",
    "attributes": {},
    "id": "mkiRJ3gTS7CPfwTEIHwrvA",
    "ephemeral_id": "sm-DQ1zAQWa_utYiFknKzA"
  },
  "stats": {
    "pages_processed": "1",
    "index_time_in_ms": "0",
    "documents_deleted": "0",
    "search_failures": "0",
    "index_failures": "0",
    "search_total": "1",
    "processing_total": "1",
    "delete_time_in_ms": "0",
    "documents_indexed": "0",
    "trigger_count": "2",
    "documents_processed": "0",
    "search_time_in_ms": "12",
    "index_total": "0",
    "exponential_avg_checkpoint_duration_ms": "53.0",
    "exponential_avg_documents_processed": "0.0",
    "processing_time_in_ms": "0",
    "exponential_avg_documents_indexed": "0.0"
  },
  "health": {
    "issues": [
      {
        "issue": "Privileges check failed",
        "count": "1",
        "details": "Cannot create transform [transform-permissions-defer-unattended] because user john_junior lacks the required permissions [transform-permissions-defer-unattended-dest:[create_index, index, read], transform-permissions-defer-unattended-index:[read, view_index_metadata]]",
        "type": "privileges_check_failed"
      }
    ],
    "status": "red"
  },
  "id": "transform-permissions-defer-unattended",
  "state": "started"
}

  1> [2024-02-14T14:32:59,181][INFO ][o.e.x.t.i.TransformInsufficientPermissionsIT] [testTransformPermissionsDeferUnattendedNoDest] Transform audit: [2024-02-14T14:32:58.747Z] [transform-permissions-defer-unattended] [Created transform.] [javaRestTest-1]	
  1> [2024-02-14T14:32:59,182][INFO ][o.e.x.t.i.TransformInsufficientPermissionsIT] [testTransformPermissionsDeferUnattendedNoDest] Transform audit: [2024-02-14T14:32:59.016Z] [transform-permissions-defer-unattended] [Updated transform state to [STARTED].] [javaRestTest-1]	
  1> [2024-02-14T14:32:59,182][INFO ][o.e.x.t.i.TransformInsufficientPermissionsIT] [testTransformPermissionsDeferUnattendedNoDest] Transform audit: [2024-02-14T14:32:59.037Z] [transform-permissions-defer-unattended] [Transform encountered an exception: [Could not create destination index [transform-permissions-defer-unattended-dest] for transform [transform-permissions-defer-unattended]]; Will automatically retry [1/-1]] [javaRestTest-1]	

  1> [2024-02-21T19:04:09,813][INFO ][o.e.x.t.i.TransformInsufficientPermissionsIT] [testTransformPermissionsDeferUnattendedNoDest] Transform audit: [2024-02-21T06:04:04.682Z] [transform-permissions-defer-unattended] [Transform encountered an exception: [Could not create destination index [transform-permissions-defer-unattended-dest] for transform [transform-permissions-defer-unattended]]; Will automatically retry [1/-1]] [javaRestTest-1]	

» [2024-02-21T06:04:04,663][ERROR][o.e.x.t.p.TransformIndex ] [javaRestTest-1] Could not create destination index [transform-permissions-defer-unattended-dest] for transform [transform-permissions-defer-unattended] org.elasticsearch.ElasticsearchSecurityException: action [indices:admin/create] is unauthorized for user [john_junior] with effective roles [transform_admin] on indices [transform-permissions-defer-unattended-dest], this action is granted by the index privileges [create_index,manage,all]
»  

» [2024-02-21T06:04:09,729][WARN ][o.e.x.t.t.TransformIndexer] [javaRestTest-1] [transform-permissions-defer-unattended] unable to load progress information for task. org.elasticsearch.ElasticsearchSecurityException: action [indices:data/read/search] is unauthorized for user [john_junior] with effective roles [transform_admin] on indices [transform-permissions-defer-unattended-index], this action is granted by the index privileges [read,all]