search

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
199 stars 37 forks source link

Postgres connections left open #329

Closed angryjohnnie closed 1 year ago

angryjohnnie commented 2 years ago

Issue Type: Bug

  1. open a postgres connection to the server. make a simple query such as "select * from table test limit 10"
  2. force quit ads or ads crashes3.
  3. all connections related to the query remain open.
  4. multiple attempts to connect that either crash or are disconnected ungracefully leave 1 or 2 connections open. These accumulate and eventually reach the default mac connection limit in postgres

Azure Data Studio version: azuredatastudio 1.38.0 (dff93c4736269ef2a7e8a225737a0d8354bf0246, 2022-07-26T17:24:38.381Z) OS version: Darwin x64 21.6.0 Restricted Mode: No

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz (12 x 2600)| |GPU Status|2d_canvas: enabled
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
webgl: enabled
webgl2: enabled| |Load (avg)|3, 2, 2| |Memory (System)|32.00GB (0.65GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (1) Extension|Author (truncated)|Version ---|---|--- azuredatastudio-postgresql|Mic|0.2.7
nasc17 commented 1 year ago

Please update to latest stable release of PostgreSQL extension v0.4.2. We would appreciate your verification if this issue is still present.

nasc17 commented 1 year ago

Latest stable release of PostgreSQL extension v0.5.0 is currently out. Please reopen if issue is still present, thank you.