spurious /dev/shm related errors on insert

From: Michael Charnoky <noky(at)noky(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: spurious /dev/shm related errors on insert
Date: 2016-03-18 14:41:19
Message-ID: CAEWrP=mzKDLJ5uf=KGFnAMNF79QB-8TdFbp4YQpe534Yq1ugtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Charnoky 2016-03-18 14:45:50 Re: spurious /dev/shm related errors on insert
Previous Message Melvin Davidson 2016-03-18 14:37:43 Re: Drop only temporary table