Re: Shared memory error - Mailing list pgsql-general

From Sonam Sharma
Subject Re: Shared memory error
Date
Msg-id CAM-M3T=+eTLnqMMEHw-jZ9+ADzNM4EoXv-gSU4X9Mpu5Ni5tvw@mail.gmail.com
Whole thread Raw
In response to Re: Shared memory error  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Shared memory error  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general


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 : need to check on this

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: Chris Travers
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment
Next
From: Sonam Sharma
Date:
Subject: Re: Shared memory error