Disk Fills Up Due to Infinite Logging Loop in PGSQL Tools Service

[daninfpj]

Type: Bug

After experiencing a connection hang to a PostgreSQL database in Azure Data Studio, I restarted the application. Shortly afterward, I noticed my disk space was rapidly decreasing. Upon investigation, I found that the log file at ~/Library/Application Support/sqlops/PGSQL/ossdbtoolsservice.log was growing indefinitely.

The log file was filled with repeated occurrences of the following error:

OSError: [Errno 9] Bad file descriptor
2025-02-01 14:47:49,771 ERROR Thread JSON_RPC_Input_Thread encountered exception [Errno 9] Bad file descriptor
Traceback (most recent call last):
  File "ossdbtoolsservice/hosting/json_rpc_server.py", line 208, in _consume_input
  File "ossdbtoolsservice/hosting/json_reader.py", line 70, in read_message
  File "ossdbtoolsservice/hosting/json_reader.py", line 122, in _read_next_chunk
OSError: [Errno 9] Bad file descriptor

This error kept repeating indefinitely, causing the log file to grow until my disk was nearly full.

These were the process that were running, even after closing Data Studio:

user            5984 100.0  0.1 411304192  11232   ??  R    10:38AM 194:50.87 /Users/user/.azuredatastudio/extensions/microsoft.azuredatastudio-postgresql-0.6.0/out/ossdbtoolsservice/OSX_ARM64/v1.10.0/pgsqltoolsservice/ossdbtoolsservice_main --log-dir=/Users/user/Library/Application Support/sqlops/PGSQL /Users/user/Library/Application Support/sqlops/PGSQL provider=PGSQL
user            5973   0.0  0.0 410270000    384   ??  S    10:38AM   0:00.19 /Users/user/.azuredatastudio/extensions/microsoft.azuredatastudio-postgresql-0.6.0/out/ossdbtoolsservice/OSX_ARM64/v1.10.0/pgsqltoolsservice/ossdbtoolsservice_main --log-dir=/Users/user/Library/Application Support/sqlops/PGSQL /Users/user/Library/Application Support/sqlops/PGSQL provider=PGSQL

Extension version: 0.6.0
Azure Data Studio version: azuredatastudio 1.51.0 (3e1c6f5aab3933dfdd9fa030e104211b9150a66a, 2025-01-27T22:04:07.577Z)
OS version: Darwin arm64 24.3.0
Restricted Mode: No
Preview Features: Disabled
Modes:

System Info

Item	Value
CPUs	Apple M1 Pro (10 x 2400)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on 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_graphite: disabled_off video_decode: enabled video_encode: enabled webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	5, 10, 9
Memory (System)	16.00GB (0.18GB free)
Process Argv
Screen Reader	no
VM	0%