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

sinejoe · ‎08-30-2022

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
      }
    }
  }
}

Saso-WD · ‎08-31-2022

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