From: | Michael Charnoky <noky(at)noky(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: spurious /dev/shm related errors on insert |
Date: | 2016-03-18 14:45:50 |
Message-ID: | CAEWrP==zntovAmWcshA4Uy4Dk+vNeAp_FsRa4xgAj6tg_ZADGw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)noky(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-03-18 14:58:26 | Re: Drop only temporary table |
Previous Message | Michael Charnoky | 2016-03-18 14:41:19 | spurious /dev/shm related errors on insert |