Getting Connection errors due to memory allocation?

[KevinG1002]

Hi all,

I'm running into the following error when trying to establish a LibPQ connection with some db.

PostgreSQL connection (CONNECTION_BAD) with parameters:[error | LibPQ]: LibPQ.Errors.JLConnectionError("libpq could not allocate memory for connection info")

Have any of you run into this before? My client setup is:

function get_client_openshift()
    if _client === nothing || !isopen(_client)
        global _client = LibPQ.Connection("postgresql://admin:admin@10.x.xx.xx:xxxx/dbname")
    end
    return _client
end

I'm running this on a 2020 Macbook Pro with an intel chip and on Julia version: 1.11.1
I've checked out the Activity Monitor and I'm not seeing anything out of the ordinary (~1 GB of RAM for my Julia process; plenty of storage and memory left).

Any help would be much appreciated!

Kevin

[iamed2]

Is that function being run in a precompiled module, where you then try to reuse that connection after precompilation? I'm somewhat concerned by the use of a global connection there.

Can you replicate with a guaranteed-fresh connection?

[KevinG1002]

@iamed2 – This is resolved now. Issue emerged due to high volume and frequency of opening-and-closing of client connections. Changed my code to carefully close connections using try-finally blocks and everything worked again.