Bulk GraphQL queries taking excessive time & failing status FAILED + errorCode INTERNAL_SERVER_ERROR

Retired Boards Appdev Graphql Basics And Troubleshooting
1

Over last 24 hours or more, bulk GraphQL query requests are failing and seemingly getting stuck for long periods of time beforehand. This is just one example and the latest instance in our testing…

After query ran for over an hour:
{
  "data": {
    "currentBulkOperation": {
      "id": "gid:\/\/shopify\/BulkOperation\/1563062501556",
      "status": "FAILED",
      "errorCode": "INTERNAL_SERVER_ERROR",
      "createdAt": "2022-08-30T17:00:42Z",
      "completedAt": null,
      "objectCount": "2958328",
      "rootObjectCount": "78846",
      "fileSize": null,
      "url": null,
      "partialDataUrl": "https:\/\/storage.googleapis.com\/shopify-tiers-assets-prod-us-east1\/id4qshd97y305eewlocol9w0x27t?GoogleAccessId=xxxxxxxxxxxxxxxxxxxREPLACED_ACTUAL_URL"
    }
  },
  "extensions": {
    "cost": {
      "requestedQueryCost": 1,
      "actualQueryCost": 1,
      "throttleStatus": {
        "maximumAvailable": 2000.0,
        "currentlyAvailable": 1999,
        "restoreRate": 100.0
      }
    }
  }
}
2

Having similar issues here, except in our case the operation won’t even start anymore, throws INTERNAL_SERVER_ERROR immediately.