This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
All latest versions on Mac fail to connect with a new or edited connection, but the latest Windows version works fine.
The most recent installed on local laptop that fails is: 1.42.0 (Universal)
ADS in Windows connects immediately with the same connection string and settings.
The behavior is it just spins when trying to connect to my database on a new or edited connection. When trying to connect to an existing/cached connection that normally works, it just spins, but closing the app and restarting allows for an existing connection to succeed. Trying to create a new connection, or editing a connection gets me spinning again, until I close the app.
I see no errors, just spinning - viewing all views in the OUTPUT tab.
Question: What can I do to see why it spins?
Version: 1.42.0 (Universal)
Commit: 22f384e569bc90d8b3231cc8c8cff99ea16c5052
Date: 2023-03-17T18:04:34.407Z (1 wk ago)
VS Code: 1.67.0
Electron: 19.1.8
Chromium: 102.0.5005.167
Node.js: 16.14.2
V8: 10.2.154.15-electron.0
OS: Darwin x64 22.3.0
After cancelling the spinning connection I see this in the OUTPUT Tab > Log Window.
I found the log files using the command palette > Developer:Open Logs Folder, but don't see any detail in any of the logs I open.
[2023-03-28 15:00:50.191] [renderer1] [error] An unknown error occurred. Please consult the log for more details.
@Jared Heelis Thank you for reaching out. Sorry to hear about this issue.
This is being investigated. I will reach ou to you shortly.
Regards,
Oury
@Jared Heelis - We received your feedback that the answer provided on the thread was not helpful.
Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.
Our engineer have provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.
Looking forward to you reply. Much appreciate your feedback!
Regards,
Please verify Azure Core extension is enabled as it might be disabled.
Please follow steps from the link below to enable builtin Azure Core extension, and restart ADS to try again.
Please let us know if that works.
Regards,
Oury
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
We haven’t heard from you on the last response and was just checking back to see if the solution provided helped in anyways.
I'm sorry for the late get-back. As I mentioned above there's no change to the behavior having verified the Azure (Core) plugin is installed and enabled.
Are there ways to debug, or a log file that would be informative?
Could you please capture the log as per the instructions below.
https://github.com/microsoft/azuredatastudio/issues/21948#issuecomment-1438900957
Azure: Logging Level and select the Verbose optionDeveloper: Open Logs Folder[default log folder]/exthost1/output_logging_[earliest timestamp]/#-Azure Acounts.logRegards,
Oury
Jared Heelis Please don't forget to attach the log file to the link above so we can check what exactly is the problem.
Regards,
Oury
After setting logs to "Verbose" I get zero byte log files:
I want to make it clear that the UI has a spinning icon that just spins and spins.
No error on the UI. I must cancel out of the spinning.
After doing so, no connections can be made to any databases. Further connection attempts just spin.
Also, I created the very same connection on a Windows laptop, side-by-side, and the connection is instantly successful in Windows' Azure Data Studio.
Jared Heelis Could you please capture the log as per the instructions below. https://github.com/microsoft/azuredatastudio/issues/21948#issuecomment-1438900957 and share it in the same github link above. Regards, Oury
Jared Heelis Could you please zip and upload your entire log folder that corresponds to "Developer> Open Logs folder" so we can take a close look?
Jared Heelis I will appreciate if you share a zip log folder to the Git Hub link, I shared above so we can further investigate. Regards, Oury
I've uploaded a zip of my logs to the github link above as user "tjhee".
In my local Mac's sqltools.log file I see the following lines at the bottom of my file:
23-04-14 10:26:25.3508010 pid:61573 tid:9 sqltools Verbose: 0 : eventTID:1045521 TdsParserStateObjectManaged.ReadSyncOverAsync | Info | State Object Id 1, Session Id 1b0a74b2-b881-4a06-8ff0-2f2ac1d9cef8
23-04-14 10:26:25.3541170 pid:61573 tid:9 sqltools Verbose: 0 : eventTID:1045521 SqlError.ctor | ERR | Info Number 0, Error State 0, Error Class 20, Error Message 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Undefined error: 0)', Procedure '', Line Number 0
23-04-14 10:26:25.3549140 pid:61573 tid:9 sqltools Verbose: 0 : eventTID:1045521 SqlConnection.OnError | Info | Object Id 1, Connection broken.
23-04-14 10:29:38.9927970 pid:61573 tid:3 sqltools Verbose: 0 : eventTID:1049116 <prov.DbConnectionPoolGroup.ClearInternal|RES|INFO|CPOOL> 1, Idle
23-04-14 10:26:25.3508010 pid:61573 tid:9 sqltools Verbose: 0 : eventTID:1045521 TdsParserStateObjectManaged.ReadSyncOverAsync | Info | State Object Id 1, Session Id 1b0a74b2-b881-4a06-8ff0-2f2ac1d9cef8
23-04-14 10:26:25.3541170 pid:61573 tid:9 sqltools Verbose: 0 : eventTID:1045521 SqlError.ctor | ERR | Info Number 0, Error State 0, Error Class 20, Error Message 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Undefined error: 0)', Procedure '', Line Number 0
23-04-14 10:26:25.3549140 pid:61573 tid:9 sqltools Verbose: 0 : eventTID:1045521 SqlConnection.OnError | Info | Object Id 1, Connection broken.
23-04-14 10:29:38.9927970 pid:61573 tid:3 sqltools Verbose: 0 : eventTID:1049116 <prov.DbConnectionPoolGroup.ClearInternal|RES|INFO|CPOOL> 1, Idle
The very same connection parms works on my Windows laptop, but gives the error you see above on my Mac.
Jared Heelis More information about this issue can be found here https://github.com/microsoft/azuredatastudio/issues/22767. Regards, Oury