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@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!