Message-ID: <gh-pgjdbc-pgjdbc-3902-c3705418862@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 02 Jan 2026 14:15:15 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3902: createBlob() not closing LargeObject.
In-Reply-To: <gh-pgjdbc-pgjdbc-3902@github.com>
References: <gh-pgjdbc-pgjdbc-3902@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3705418862
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3902
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3902#issuecomment-3705418862
Content-Type: text/plain; charset=utf-8

So there's a point where we probably leave the blob outputstream open due to an infinite loop. The best we can do is set it to null and wait for the GC to recover the memory
https://github.com/pgjdbc/pgjdbc/blob/e3ea9a3bfce6330aea67b3ff555cd7c32a755134/pgjdbc/src/main/java/org/postgresql/largeobject/LargeObject.java#L162-L174