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

sinejoe
Shopify Expert
64 0 15

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

 

 

Reply 1 (1)

Saso-WD
Shopify Partner
26 1 13

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