Share via

Azure SQL Edge Streaming Job Hangs

Phil Andreoli 1 Reputation point Microsoft Employee
2022-08-08T20:09:56.56+00:00

I have a Azure SQL Edge database deployed as a container on IoT Edge. After a certain amount of time the job stops processing but when looking at the status it says that it is still processing. When this issue happens, I have to stop the job and then restart it. I have a couple issues:

  1. How do I prevent this from happening? Is this a bug?
  2. How do I monitor this job and then trigger a notification to be sent to IoT Hub that the job is hung?

Thanks

Azure IoT Edge
Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
576 questions
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
49 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Phil Andreoli 1 Reputation point Microsoft Employee
    2022-08-09T13:55:19.647+00:00

    @AshokPeddakotla-MSFT

    Having the issue right now and there are messages flowing into EdgeHub and subsequently IoT Hub. There are zero errors showing right now in the docker container and there are no messages processing right now.

    The status of the streaming job right now is now Processing. This streaming job is well within the limitations of set out within the documentation.

    The only way that I know of how to fix this is to execute sys.sp_stop_streaming_job and then sys.sp_start_streaming_job.

    Thanks
    Phil

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.