INTERNAL_SERVER_ERROR - Issue Running products Query Using Bulk Operation

[captainpryce]

Hello,

Over the last few days I have been experiencing an issue when querying all products in my shop while using the Shopify Bulk Operation. I have tested this on the Shopify GraphQL app to reproduce the issue, and can confirm that after the status changes to “RUNNING” after some time the bulk operation fails, returning the following response:

{
  "data": {
    "currentBulkOperation": {
      "id": "gid://shopify/BulkOperation/4219092762756",
      "status": "FAILED",
      "errorCode": "INTERNAL_SERVER_ERROR",
      "createdAt": "2025-02-26T22:11:20Z",
      "completedAt": null,
      "objectCount": "0",
      "fileSize": null,
      "url": null,
      "partialDataUrl": null
    }
  },
  "extensions": {
    "cost": {
      "requestedQueryCost": 1,
      "actualQueryCost": 1,
      "throttleStatus": {
        "maximumAvailable": 2000,
        "currentlyAvailable": 1999,
        "restoreRate": 100
      }
    }
  }
}

Here is the query I am running:

mutation createBulkOperationQuery($query: String!) {
  bulkOperationRunQuery(
    query: $query
  ) {
    bulkOperation {
      id
      status
    }
    userErrors {
      field
      message
    }
  }
}

With the following variables:

{
  "query": "query getProduct($query: String) {\n  products(query: $query, first: 50) {\n    edges {\n      cursor\n      node {\n        id\n        createdAt\n        updatedAt\n        title\n        handle\n        descriptionHtml\n        productType\n        tags\n        totalInventory\n        vendor\n        featuredMedia {\n          ... on MediaImage {\n            image {\n              url\n            }\n          }\n        }\n        category {\n          fullName\n        }\n        variants(first: 50) {\n          edges {\n            node {\n              barcode\n              compareAtPrice\n              price\n              sku\n            }\n          }\n        }\n      }\n    }\n    pageInfo {\n      hasNextPage\n    }\n  }\n}"
}

This issue seems to be relatively new as previously I was able to query all items successfully. Any help or guidance on why this bulk operation is failing would be greatly appreciated.

Thank you for taking the time to read over this!

[Liam-Shopify]

Hi,

It sounds like this bulk query could be timing out - could you reduce the number of fields being queried and see if that runs successfully?

[captainpryce]

Hey Liam,

Thanks for getting back to me so quickly. I just tried re-running the query again but this time with only a single field, and I am still receiving the same error. I’ve pasted below the queries I ran:

mutation createBulkOperationQuery($query: String!) {
  bulkOperationRunQuery(
    query: $query
  ) {
    bulkOperation {
      id
      status
    }
    userErrors {
      field
      message
    }
  }
}

Variables:

{
  "query": "query getProduct($query: String) {\n  products(query: $query, first: 50) {\n    edges {\n      cursor\n      node {\n        id\n  \n}}}}"
}

Response:

{
  "data": {
    "currentBulkOperation": {
      "id": "gid://shopify/BulkOperation/4222135238788",
      "status": "FAILED",
      "errorCode": "INTERNAL_SERVER_ERROR",
      "createdAt": "2025-02-27T17:47:04Z",
      "completedAt": null,
      "objectCount": "0",
      "fileSize": null,
      "url": null,
      "partialDataUrl": null
    }
  },
  "extensions": {
    "cost": {
      "requestedQueryCost": 1,
      "actualQueryCost": 1,
      "throttleStatus": {
        "maximumAvailable": 2000,
        "currentlyAvailable": 1999,
        "restoreRate": 100
      }
    }
  }
}

I tried running it a number of times as well with different fields, but all of them are resulting in the same INTERNAL_SERVER_ERROR.

Let me know what the next steps might be.

Thanks again for your time.

[remy727]

I tested with the same query and variable but it worked for me.

[Liam-Shopify]

@captainpryce

Are you sure you have all the correct scopes? If you try running it in the GraphiQL app do you see the same issue?

[captainpryce]

Hey Liam,
Yes I double checked the scopes and have been only testing the query on the Shopify GraphQL app to ensure its not something related to my environment. From the looks of it, this issue seems to be isolated to my store, as it seems the query and its structure are fine and working for other users. Would you be able to look into this? The inability to query items in bulk is effecting majority of our pipelines for managing our inventory, and I haven’t been able to figure out what could be causing it aside from it being an internal issue with my store.

[Liam-Shopify]

Hi again - this could be store specific as you mentioned, could you test on a different store to confirm if the issue is not appearing there?

[captainpryce]

Hey Liam,
I just tested the query again but this time on my development store, and the issue is persisting there too. I’ve pasted some screen shots from the GraphQL app as reference. Could it be possible that this is an issue on an account level?

[Liam-Shopify]

That is quite strange - there shouldn’t be any config settings that would follow across from another store. Just to confirm though, is there a way you could test on a different partner linked store? I’m not able to replicate this on my own test store:

[captainpryce]

I could maybe try opening another partner account and testing on there, but I believe you when you say that it is working outside of my account. It seems localized to my account (which is both linked to my retail store and my partner store). I know the query was working, as our pipelines depended on being able to pull data in bulk from shopify and storing it in our local database. I’m really looking for a solution to resolve this issue for my specific account, as without it, I am unable to effectively manage my store, and as the days continue on, its becoming more and more of a burden on our operations. Is there anyway you can potentially escalate this issue, as I am unsure what the cause could be, but it’s definitely not user error.

Please let me know as soon as you can

[Liam-Shopify]

The best course of action in this case would be to reach out to partner support directly. You can send an email via your partner dashboard > support.