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 <n...@noky.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 > >
