-
Notifications
You must be signed in to change notification settings - Fork 465
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
MSSQL: SQL Tools Service not starting on latest VS Code Insider #718
Comments
I am running into the same problem, with the same VS Code and extension versions on Windows 10 Pro, although I noticed it on the previous build as well. |
Yes! I upgraded this morning the VS Code-Insider and MSSQL extension stopped working. |
I'm seeing the same thing. I'll investigate now and see what we need to do to roll-out a fix. |
It looks like the uri format of the textDocument/didOpen message has a breaking change where it is now prefixed with "git:/". Previously we where expecting this to be "file:/" and the new prefix isn't work with our file management code. We'll follow-up with VS Code team to find out if the change is intentional and if we need to take a fix on our side. The bold line in the payload below is causing the issue. "textDocument/didOpen" { { |
Here is the exception detail of the crash in SqlToolsService. Basically System.Path.GetFullPath doesn't know how to resolve git:/ URIs. {System.NotSupportedException: The given path's format is not supported.\r\n at System.IO.Path.GetFullPath(String path)} System.IO.Path.GetFullPath(string path) (\Unknown Source:0) |
I opened an issue with VS Code team to determine if this change is intentional. If it is then we'll include this in our upcoming 0.3.0 release. |
Thanks everyone for the quick attention. I had webinar yesterday where I was showing VS Code Insider working with MSSQL, Python, and PowerShell. Unfortunately the bug stop me from showing the T-SQL piece. But, eventually is going to get fix. Right! Greatly Appreciate the efforts, :) |
There is a fix on our side to ignore the new git:/ events in our extensions service at microsoft/sqltoolsservice#254. I'll wait to hear back on if this intended design change before merging. |
@kburtram 's fix is merged and the tools service release is updated. Therefore re-downloading and uninstalling / reinstalling https://github.com/Microsoft/vscode-mssql/releases/download/v0.3.0/mssql-0.3.0.vsix should pull down a version with this fix. I'll be updating the installers with an updated VSCode-MSSQL package shortly, or may just create a new 0.3.1 release to better capture this. |
All binaries have been updated in the 0.3.0 candidate release. This now includes fixes for newline copy, this issue, and updated release notes |
That's AWESOME! I'm looking forward to the next release of insider to test the changes. Thanks again, |
OK! In my case, I proceed to download and install mssql-0.3.0.vsix. Good job!! |
@MaximoTrinidad thanks for confirming! |
I'm still having a problem with this. Running Ubuntu Trusty. I was super excited to use Code to connect to my Azure SQL server without having to remote to my Win10 machine. I get the error as soon as I open an SQL file. After clearing that I enter my server details and it just spins without ever connecting or giving me an error message. Has it been fixed already? I don't mind being patient, I just wanted to make sure that my problem wasn't something else. Thanks! |
Hi @JudE2425 What's the extension version number? My issue the SQL Tools Service got corrected by manually installing mssql-0.3.0.vsix. Hope this helps, |
strange. That's the extension number I have. I installed the azure extension pack, so I assume all of the dependencies came with it. Anyway, thanks for the heads up! |
Hey @JudE2425, Hum! I'm curious!! Have you tried to using only the mssql extension (by itself) and see if it connect without the Azure Extension. There might be a chance these two extension may conflict each other. :) |
That's a great idea! So I tried it. I uninstalled all of my extensions and then installed the MSSQL extension only. I then clicked on an .sql file and the terminal/debugger window popped up on the bottom. It said it was downloading some files and right before it says it was successful, the little error message pops up at the top and says that it was unable to start. |
Does by any change... did you recreated the profiles before trying it? In my case I had to recreate my SQL profiles. I'm just saying! It did help in my case. |
@JudE2425 sorry to hear you're still having trouble. Perhaps we could help debug this to understand why it's failing? Steps that should help:
|
One more thing: could it be this issue https://github.com/Microsoft/vscode-mssql/wiki/windows10-universal-c-runtime-requirement? We need the Universal-C runtime to work on earlier versions of Windows. By any chance is that causing this problem for you? |
Good point @kevcunnane! I'm on the latest Windows 10 Insider build 15046. And VS Code Insider ver. 1.11.0. |
In reverse order, I'm running Ubuntu 14.04 in a chroot, so I sure hope it's not a windows issue :-P Here is the output from SQL ToolsService:
Here is the output from the Developer Tools when I select an SQL file:
|
Oh, there was one more message I forgot to paste in. I apologize.
This was also in the developer tools output. |
So the issue is definitely this:
Does this file exist at the specified location? I just downloaded the Ubuntu 14 package we're using (https://github.com/Microsoft/sqltoolsservice/releases/download/v0.3.0.5/microsoft.sqltools.servicelayer-ubuntu14-x64-netcoreapp1.0.tar.gz), unpackage and verified it is there. Can you try re-downloading (delete the sqltoolsservice directory and restart VSCode) and see if it "just works"? If the file is there, I'm not sure what might be going wrong, will need to dig in a bit more |
@MaximoTrinidad I think this is a VSCode Insiders build issue. I just updated to 1.11.0-insiders and after a few restarts, it now says my VSCode instance appears to be corrupt.If you can verify things still work OK on the standard VSCode install, I would recommend opening an issue against VSCode (https://github.com/Microsoft/vscode/issues). They are generally very good about fixing quickly. |
Thanks @kevcunnane! I will post this on the VS Code side. |
Hi @kevcunnane, Just installed VS Code (not Insider) ver 1.10.0 in Linux Ubuntu 16.04.1 and all the extensions works fine including mssql. :) |
Same errors here on Debian Stretch: |
Had the same issue in elementary OS 0.4
I figured that it wasn't the |
Thanks @thiagoabreu! I will try this tonight when I get home. By the way, I got side track on this one as the only problem still is with my Code Insider version on my main Linux system. I can't seem to uninstall the application. Can some help (or explain) how to completely remove the application? I tried everything I know. I tried the Ubuntu App, dpkg remove, and even search then "Move to Trash". Apparently, the application still stays loaded somewhere. Every time I install, what I think is a refresh application, it comes back with all of my previously installed extensions. I think somehow the installation got corrupted as I'm able to successfully install on a clean Linux VM. So, what are the proper way to uninstall to do a clean installation? Thanks, |
@MaximoTrinidad Have you tried to delete the |
I was having similar issues to @JudE2425 with the SQL tools service not starting in a chroot with Ubuntu 16 - the resolution was as @thiagoabreu suggested - installing libunwind8-dev.
|
@kevcunnane could you please confirm if there is anything we can do for this issue in the upcoming release? |
Also effects Ubuntu 17.04 Not sure if this is relevant but it appears to be downloading a tarball for Debian? It goes into the Debian directory under the extension but with 16.10 it was going into an Ubuntu16 directory.
SqlToolService output is
|
The Ubuntu 17.04 issue appears to be an issue with .Net Core 1.0. We're following up on how best to support this more recent distro, but we don't have a fix currently available. I'm going to clear the GA milestone and we'll need to fix in the next release or hotfix. I'll add a comment to the known issue list. |
Just fyi, latest release .Net Core seems to work fine (for me) on Ubuntu 17.04. |
@basabuber Could you please share what versions of VS Code / vscode-mssql / dotnet core you're having success with? I'm experiencing this issue on Ubuntu 17.04 with VS Code 1.12.2 / vscode-mssql / dotnet 2.0.0-preview2-006127 edit: It looks like there's a whole .net core runtime bundled in with sqltoolsservice! I'm assuming it was a decision made to ease the installation process, but it seems like it does make compatibility issues such as this one more likely... |
@ed-alertedh @basabuber the current extension is built using .Net Core 1 which doesn't support Ubuntu 17.04. We'll be upgrading to .Net Core 2 in the next release. I've posted an early test build based on .Net Core 2 at https://github.com/Microsoft/vscode-mssql/releases/tag/v1.0.0-alpha.10 that can be side-loaded into VS Code using the Install From VSIX option. The build has a couple known issues we'll be fixing in the next week or so, but should be mostly stable. It would be great if you can give it a try and let me know if you hit any issues. |
That's Awesome!! I'll give it try when I get a chance and let you know if anything is going on. Thanks, |
@kburtram The alpha version with .Net Core 2 support finally works for me! Thank you! 👍 (I am using Ubuntu 16.10) |
@kburtram The alpha version also works for me on Ubuntu 17.04! Thanks! 👍 |
@kburtram Yep, that's working for me too, thanks! As an aside, I'm still a little curious about the whole system of bundling a runtime with the sql service. Isn't the whole point of .NET that the code targets a certain framework and is decoupled from the runtime/host platform? |
Fixed for me too on Fedora 25, VS Code 1.13. Prior to taking the update I couldn't connect to a SQL instance in a local VM (with 1433 forwarded), even though sqlcmd could connect OK. I also got that "extension failed to load message >50% of the time when setting file type to SQL. |
I'll close this out as this version is now supported in the latest full release. |
I've had the same issue in Ubuntu 20.04, I downloaded the latest version of SQLToolsService at download sqltoolsservice and then extracted the file to "/home/user/.vscode/extensions/ms-mssql.mssql-1.9.0/sqltoolsservice/1.9.0/Ubuntu16/" |
Steps to Reproduce:
FYI - This was working fine on previous VS Code Insider version. Now, it doesn't connect to my existing profiles.
The text was updated successfully, but these errors were encountered: