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

From Michael Charnoky
Subject Re: spurious /dev/shm related errors on insert
Date
Msg-id CAEWrP==zntovAmWcshA4Uy4Dk+vNeAp_FsRa4xgAj6tg_ZADGw@mail.gmail.com
Whole thread Raw
In response to spurious /dev/shm related errors on insert  (Michael Charnoky <noky@noky.net>)
Responses Re: spurious /dev/shm related errors on insert  (rob stone <floriparob@gmail.com>)
List pgsql-general
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!

Mike


pgsql-general by date:

Previous
From: Michael Charnoky
Date:
Subject: spurious /dev/shm related errors on insert
Next
From: "David G. Johnston"
Date:
Subject: Re: Drop only temporary table