02-16-2022 07:30 AM
Hello All, I am trying to use Databricks SQL but somehow the SQL end point is not getting started. It is in starting state for long time and then session is getting expired.
Please note , the default SQL End point also not getting started. I am using Azure as a backend for Databricks and I have enough quota to create a sql end point. Any support will be highly appreciated.
Error Summary :Cluster is taking longer than 43 minutes to start up (cluster-id xxxx-***-***).
03-01-2022 06:11 AM
Hi @Bilal Aslam Sorry for the late response. Looks like that Issue was related to quota which Microsoft provide. I connected with Microsoft Azure support and they confirmed me below
"
But I will suggest Databricks give some error log like some SubscriptionType issue so that User can understand quickly.
Again Thank you for the support.
02-16-2022 07:43 AM
This is nearly ALWAYS an Azure VM supply issue.
We've seen in multiple times in the past 18-24 months. Ours (also in Azure East region) appear to all be fine at the moment. Do you know what region you're in/what VM series you're relying on? You likely need to reach out to Microsoft support via a support ticket/check for all related service health alerts in the Azure portal.
02-16-2022 08:13 AM
Hello Chris, Thank you for the response. I am using Azure EAST US region but I am not sure about VM series though.
Could you please let me know which region working fine. So that I can create one more resource and try the same.
02-16-2022 06:57 PM
Hello Chris,
One more point do we really need a VM for Azure DATABRICKS SQL? I guess only SQL End point enough to run the query. Please correct me.
02-17-2022 05:50 AM
when you launch a cluster . all worker and driver underneath will actually launch VMs associated your subscription. So, yes, VMs are needed
02-17-2022 06:45 AM
Thanks Atanu. Yes I do have Standard EDSv4 Family vCPUs VM and could see I have 500 Quota but still the SQL End point is not getting started.
02-19-2022 12:33 AM
Hi there, sorry about this! As Chris mentioned, this is indeed almost always a VM supply issue but let's get to the bottom of this.
03-01-2022 05:27 AM
@AMZ DUD did you get this working? With a quota of 500, 43 mins is a long time for a cluster to launch. Perhaps a something in the account isn’t set up correctly. Can you please email me your workspace ID please at bilal dot aslam at databricks dot com so I can investigate?
03-01-2022 06:11 AM
Hi @Bilal Aslam Sorry for the late response. Looks like that Issue was related to quota which Microsoft provide. I connected with Microsoft Azure support and they confirmed me below
"
But I will suggest Databricks give some error log like some SubscriptionType issue so that User can understand quickly.
Again Thank you for the support.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group