| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>,Bruce Momjian <bruce(at)momjian(dot)us>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: emergency outage requiring database restart |
| Date: | 2016-10-26 18:45:52 |
| Message-ID: | EDB11909-6127-4629-9196-36D6780FA412@anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On October 26, 2016 9:38:49 PM GMT+03:00, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>On Wed, Oct 26, 2016 at 1:34 PM, Andres Freund <andres(at)anarazel(dot)de>
>wrote:
>> Any chance that plsh or the script it executes does anything with the
>file descriptors it inherits? That'd certainly one way to get into odd
>corruption issues.
>
>not sure. it's pretty small -- see
>https://github.com/petere/plsh/blob/master/plsh.c
Afaics that could also be in your script, not just plsh. The later doesn't seem to close all file handles above stderr, which means that all handles for relations etc week be open in your script. If you e.g. do any unusual redirections (2>&17 or such), that could end badly. But I'm just on my phone, in a taxi without seatbelts, at 60mph, so I didn't look carefully.
Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2016-10-26 18:49:12 | Re: emergency outage requiring database restart |
| Previous Message | Robert Haas | 2016-10-26 18:45:15 | Re: macaddr 64 bit (EUI-64) datatype support |