Re: Shared memory error

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..