azuredatastudio: Select Top 1000 Records Stops working
Type: Bug
Right clicking on a table and selecting “Select Top 100 Records” only works the first time. Any subsequent attempts to use this command, on any table, does nothing. No response.
This is the developer tools logs after running the command the first, successful, time:
[Extension Host] (node:19636) [DEP0005] DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead.
(Use `azuredatastudio-insiders --trace-deprecation ...` to show where the warning was created) (at c:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\out\vs\workbench\api\node\extensionHostProcess.js:83:196474)
C @ console.ts:137
$logExtensionHostMessage @ mainThreadConsole.ts:39
_doInvokeHandler @ rpcProtocol.ts:457
_invokeHandler @ rpcProtocol.ts:442
_receiveRequest @ rpcProtocol.ts:370
_receiveOneMessage @ rpcProtocol.ts:296
(anonymous) @ rpcProtocol.ts:161
invoke @ event.ts:622
deliver @ event.ts:824
fire @ event.ts:785
fire @ ipc.net.ts:638
_receiveMessage @ ipc.net.ts:959
(anonymous) @ ipc.net.ts:832
invoke @ event.ts:622
deliver @ event.ts:824
fire @ event.ts:785
acceptChunk @ ipc.net.ts:382
(anonymous) @ ipc.net.ts:338
_ @ ipc.net.ts:70
emit @ node:events:526
addChunk @ node:internal/streams/readable:315
readableAddChunk @ node:internal/streams/readable:289
Readable.push @ node:internal/streams/readable:228
onStreamRead @ node:internal/stream_base_commons:190
log.ts:301 INFO Disconnect request sent for connection:providerName:MSSQL|authenticationType:Integrated|database:DigitalOptometrics_Auditing|server:usma8593\sqlexpress|user:|databaseDisplayName:DigitalOptometrics_Auditing|group:ffc8098d-5ec3-4f0b-9d4f-f64e8db56fd2 - deleting connection
log.ts:301 INFO Deleting connection connection:providerName:MSSQL|authenticationType:Integrated|database:DigitalOptometrics_Auditing|server:usma8593\sqlexpress|user:|databaseDisplayName:DigitalOptometrics_Auditing|group:ffc8098d-5ec3-4f0b-9d4f-f64e8db56fd2
log.ts:301 INFO Disconnect request sent for untitled:SQLQuery_2 - deleting connection
log.ts:301 INFO Deleting connection untitled:SQLQuery_2
log.ts:301 INFO Removing connection connection:providerName:MSSQL|authenticationType:Integrated|database:DigitalOptometrics_Auditing|server:usma8593\sqlexpress|user:|databaseDisplayName:DigitalOptometrics_Auditing|group:ffc8098d-5ec3-4f0b-9d4f-f64e8db56fd2
log.ts:313 ERR Cannot read properties of undefined (reading 'savePassword'): TypeError: Cannot read properties of undefined (reading 'savePassword')
at q.disconnectConnection (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2890:41423)
at vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2890:35010
at h.invoke (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:169:145)
at u.deliver (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:169:2266)
at r.fire (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:169:1844)
at ba._notifyDisconnected (vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2712:44065)
at vscode-file://vscode-app/c:/Users/jtsombakos/AppData/Local/Programs/Azure%20Data%20Studio%20-%20Insiders/resources/app/out/vs/workbench/workbench.desktop.main.js:2712:40643
at _ZoneDelegate.invoke (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:409:30)
at Zone.run (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:169:47)
at C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:1326:38
at _ZoneDelegate.invokeTask (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:443:35)
at Zone.runTask (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:214:51)
at drainMicroTaskQueue (C:\Users\jtsombakos\AppData\Local\Programs\Azure Data Studio - Insiders\resources\app\node_modules.asar\zone.js\dist\zone.js:632:39)
DevTools failed to load source map: Could not load content for https://sqlopsbuilds.blob.core.windows.net/sourcemaps/cdece24123139285de21ab25e9281786fca7d93b/node_modules/@vscode/vscode-languagedetection/dist/lib/index.js.map: Fetch through target failed: Target not supported; Fallback: Unknown error
Azure Data Studio version: azuredatastudio-insiders 1.45.0-insider (cdece24123139285de21ab25e9281786fca7d93b, 2023-06-19T05:36:45.774Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:
System Info
Item | Value |
---|---|
CPUs | Intel® Core™ i5-8500 CPU @ 3.00GHz (6 x 3000) |
GPU Status | 2d_canvas: enabled canvas_oop_rasterization: disabled_off direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_renderer: enabled_on video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: disabled_off |
Load (avg) | undefined |
Memory (System) | 31.78GB (16.21GB free) |
Process Argv | |
Screen Reader | no |
VM | 0% |
Extensions (7)
Extension | Author (truncated) | Version |
---|---|---|
dacpac | Mic | 1.13.0 |
import | Mic | 1.5.5 |
schema-compare | Mic | 1.19.0 |
sql-search | Red | 0.4.0 |
ADS-add-columns | sof | 0.0.12 |
vscodeintellicode | Vis | 1.2.1 |
poor-sql-formatter | WSR | 0.1.0 |
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 23 (9 by maintainers)
thanks for the feedback, I’ve fixed this just now, in case of error, the in progress indicator will be removed and a close button is added so you can close it.
@aasimkhan30 will look into the actual error here, he will let you know when the issue is fixed.
I have that setting on. I tried turning off (and restarting), but am getting the same incorrect behavior.