spurious /dev/shm related errors on insert - Mailing list pgsql-general

From Michael Charnoky
Subject spurious /dev/shm related errors on insert
Date
Msg-id CAEWrP=mzKDLJ5uf=KGFnAMNF79QB-8TdFbp4YQpe534Yq1ugtg@mail.gmail.com
Whole thread Raw
Responses Re: spurious /dev/shm related errors on insert  (Michael Charnoky <noky@noky.net>)
Re: spurious /dev/shm related errors on insert  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Drop only temporary table
Next
From: Michael Charnoky
Date:
Subject: Re: spurious /dev/shm related errors on insert