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!