SPICE full refresh hanging – how to terminate import?

Hi,

I’m currently performing a full refresh to SPICE with ~7 million rows, and the import has been hanging for several hours without any progress at row 6191486. I haven’t seen this behavior before.

I tried canceling it by submitting another full refresh, but now I see a new status “Queued”, which I also haven’t encountered previously.

Could you please advise how I can properly terminate an import that is clearly stuck, so I can perform a clean fresh refresh afterward?

Thanks in advance for your help.

Just a quick follow-up: after a few hours, the import cleared by itself. However, it took around 3 hours longer than the same import performed earlier this morning.

As a potential feature improvement, I’d suggest adding an option for users to manually terminate a running or stuck import. This would be very helpful in cases like this, where an import appears to hang without providing any indication of progress or failure.

Thanks for taking a look.

Hi @matjazz

Use the Quick Suite’s API/CLI CancelIngestion operation to properly terminate a hanging SPICE ingestion. First, retrieve the IngestionId via ListIngestions for your DatasetId (filter for “Running” or “Queued” status), then call CancelIngestion with your AwsAccountId, DataSetId, and IngestionId.

I have tagged this as a feature request to promote visibility to the support team!

Please refer to the following Quick Suite documentations and community post this might be helpful for you.

1 Like