Re: [GENERAL] spurious /dev/shm related errors on insert

2016-03-20 Thread Michael Charnoky
On Mar 18, 2016 10:59 AM, "Tom Lane" 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

Re: [GENERAL] spurious /dev/shm related errors on insert

2016-03-19 Thread Tom Lane
Michael Charnoky 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

[GENERAL] spurious /dev/shm related errors on insert

2016-03-19 Thread Michael Charnoky
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

Re: [GENERAL] spurious /dev/shm related errors on insert

2016-03-19 Thread Michael Charnoky
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 wrote: > Hi, I'm seeing random errors from an application that is performing DB > inserts. The error happens spuriously and looks like

Re: [GENERAL] spurious /dev/shm related errors on insert

2016-03-18 Thread rob stone
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 > wrote: > > Hi, I'm seeing random errors from an application