Re: Postgres 9.2.8 crash sporadically on Windows

Hi,

We use several dblink functions (CREATE EXTENSION dblink), but only once and during installation of Postgres database server. The crash happens few minutes later.

Also, we use one homemade function, which is being activated more often (to get disk usage information, using Windows API).
Anyway, I don't think it is the problem - whenever I activate it, I get the expected results.
I activated it for several times - Postgres didn't reports anything unusual.

>>Is there another exit report for the same PID just above the quoted log extract?
No error reported above this message

Let me know if you need more info. I can send you any c code or the PL functions which using these contributions.

Thanks,
Yuval

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, April 07, 2014 6:39 PM
To: Andres Freund
Cc: Sofer, Yuval; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Postgres 9.2.8 crash sporadically on Windows

Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> On 2014-04-07 11:15:32 -0400, Tom Lane wrote:
>> The "exit code 0" bit reminds me of this:
>>
>> http://www.postgresql.org/message-id/21027.1393546453@sss.pgh.pa.us
>>
>> Is there another exit report for the same PID just above the quoted
>> log extract? Because if there isn't, the postmaster shouldn't be
>> thinking that status 0 represents a crash.

> Wouldn't a pl or library doing a exit(0); cause exactly that, because
> it will still be in PM_CHILD_ASSIGNED?

Oh, hm, that's a possibility, if the OP is using any untrusted PLs.
As you say, we lack sufficient context.

regards, tom lane