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 of the application

[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 th