Re: Shared memory error - Mailing list pgsql-general

From Sonam Sharma
Subject Re: Shared memory error
Date
Msg-id CAM-M3Tkw17gHWEvW64nckiPAWKFjO+s8T2g2aUH6qzaWi9Xmog@mail.gmail.com
Whole thread Raw
In response to Re: Shared memory error  (Sonam Sharma <sonams1209@gmail.com>)
Responses Re: Shared memory error  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-general
Updated jdbc version also 

On Wed, Jun 3, 2020, 11:46 PM Sonam Sharma <sonams1209@gmail.com> wrote:


On Wed, Jun 3, 2020, 11:29 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/3/20 7:58 AM, Sonam Sharma wrote:
> Hi Team,
>
> Getting below error when any query is running from jdbc side :
>
> Error : could not open memory segment "/PostgreSQL.1511679208" : No such
> file or directory
>
> Yesterday I have extended the /dev/shm filesystem and the query ran. But
> today again the issue is repeating.
>
> Can someone please help


To get any useful help you will need to provide:

1) Postgres version : 11.2

2) JDBC driver version : spring-boot-starter-jdbc -1.5.0.Release

3) OS and version : Linux  Red Hat 7.6 

4) Is this only with one query and if so what is it doing? : No , few queries work, few fails .. mostly all are complex select queries.

Please let me know if any other info is required..

pgsql-general by date:

Previous
From: Sonam Sharma
Date:
Subject: Re: Shared memory error
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment