Re: spurious /dev/shm related errors on insert

I should have noted: the application is using PostgreSQL 9.5.0, running on
Ubuntu 14.04

Mike

On Fri, Mar 18, 2016 at 10:41 AM, Michael Charnoky <noky(at)noky(dot)net> wrote:

> Hi, I'm seeing random errors from an application that is performing DB
> inserts. The error happens spuriously and looks like this from the
> application side:
>
> could not open file "/dev/shm/postgres_apptable_47861701461760" for
> reading: No such file or directory
>
> The PostgreSQL logs show:
>
> 2016-03-18 07:25:01 UTC ERROR: could not open file
> "/dev/shm/postgres_apptable_47861701461760" for reading: No such file or
> directory
> 2016-03-18 07:25:01 UTC STATEMENT: COPY urltable FROM
> '/dev/shm/postgres_apptable_47861701461760' USING DELIMITERS '#' WITH NULL
> AS '\null';
>
> Any clues? I couldn't find any similar issues reported by other users.
> Thanks!
>
> Mike
>
>