Huge catalog bulk operation query never starts

GraphQL Admin API Troubleshooting
1

Hi there,

for a few days now, we are constantly receiving errors when trying to request a bulk operation catalog for a concrete store, whose product catalog is huge. This had never happened on a recurring basis before, and it does not happen with other stores. The bulk operation is created ok, but it is always RUNNING but with zero processed objects, and then it fails after a while.

The error is INTERNAL_SERVER_ERROR and the bulk operation status is FAILED.

Some of the last IDs:
gid://shopify/BulkOperation/7031128195243
gid://shopify/BulkOperation/7031091429547
gid://shopify/BulkOperation/7031058202795
gid://shopify/BulkOperation/7031029137579
gid://shopify/BulkOperation/7030982475947

Please could you take a look?

2 Likes
2

Hey @sinuhe do you have a timeframe on when those operations ran?

Has it ever worked for this shop?

Have you tested making any changes to the query to see if you get different results (ie request fewer fields, different search paramaters, etc)?

3

Hi @KyleG-Shopify ,

thanks for your response. This has always worked well with this store. It is failing from March 18th.

We have not tested with a different query as this seems a problem on Shopify’s side, as it always worked and we are strictly following documentation.

4

Thanks @sinuhe, from what I can find here, it looks like those queries are timing out.

I would recommend testing by simplifying the query to see if it works. That can help identify the specific resource that is causing the time out.

Since this was working previously and is only affecting a single shop, the next steps as well are to reach out to our support teams in the help center so we can look in to and discuss the details of the specific shop affected.

6

Hey @sinuhe were you able to run any of those tests or get in touch with our support team?

7

Hi @KyleG-Shopify ,

I could contact the Shopify support team and they finally deployed a fix for the issue, so everything is working now.