Forum Discussion
SqlPackage halts for 100 seconds without apparent reason
I ran into the same symptoms. The clue here is the 100 second delay, which is often a default HTTP timeout in .NET (which sqlpackage is written in). When running the container on my machine I received no delay, but remotly in a cluster I experienced the delay. In my case, the delay seemed to be related to sending telemetry to Microsoft, which is always on by default. After turning the telemetry off, the delays went away. I suspect this is due to the locked down network environment in which my container was running. You might also get around this issue by opening up appropriate networking to Microsoft, but I have not attempted this option.
Just add this line to your Dockerfile to disable telemetry send:
ENV DACFX_TELEMETRY_OPTOUT=truehttps://github.com/microsoft/DacFx/blob/f13dcbd26d15e1636335c25204a475909bde494c/src/Microsoft.Build.Sql/README.md#how-to-opt-out
Hi jbnumber1 !
You nailed it, thanks a lot. You are right, exactly hundred 100 seconds were suspicious but I would not think that:
1. The telemetry is on by default without notification (or did I miss something)
2. It will not timeout after 1 or 2 seconds.
This is a shame for the code owner.