spurious /dev/shm related errors on insert

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:

Michael Charnoky <noky@noky.net> writes:

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

Offhand I do not believe that any part of the core PG code would attempt
to access such a file. Maybe you've got some extensions in there that
would do so?

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Fri, 2016-03-18 at 10:45 -0400, Michael Charnoky wrote:

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

Running 9.5.1 installed from Debian packages, when Postgres is started
it creates this file in /dev/shm

-rw------- 1 postgres postgres 2316 Mar 19 05:24 PostgreSQL.1804289383

It's binary.

Bye.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Mar 18, 2016 10:59 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

Offhand I do not believe that any part of the core PG code would attempt
to access such a file. Maybe you've got some extensions in there that
would do so?

Thanks Tom, thought this was a PG issue. I'll dig more into the guts of the
application