lsp-mssql icon indicating copy to clipboard operation
lsp-mssql copied to clipboard
verified publisher icon emacs-lsp

MicrosoftSqlToolsServiceLayer seems to hang with 200% cpu, no output

Open unhammer opened this issue 6 years ago • 2 comments

As soon as I click the SQL server disconnected in the modeline, select my server and try connecting, MicrosoftSqlToolsServiceLayer starts using 200% cpu, but it still says "disconnected" (and of course nothing works). I did (setq lsp-mssql-log-debug-info t) but neither the *sql* nor *sql::stderr* buffers show any output.

If I click it again, I get

LSP :: Failed to connect with the following error error number: 0
nil

Is there a way to get more debug info?

unhammer avatar Dec 08 '19 20:12 unhammer

You may set lsp-print-io to t and check what the server has returned. My guess is that the service layer is unable to connect to your mssql instance. Use lsp-workspace-show-log after setting lsp-print-io to t to view the logs.

yyoncho avatar Dec 16 '19 12:12 yyoncho

Does mssql.log tell you anything? I don't see any clues :( The 100% cpu starts at line 273

unhammer avatar Dec 16 '19 12:12 unhammer