Re: Postgres 9.2.8 crash sporadically on Windows

Hi,=20

We use several dblink functions (CREATE EXTENSION dblink), but only once an=
d during installation of Postgres database server. The crash happens few mi=
nutes later.=20

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.=20
I activated it for several times - Postgres didn't reports anything unusual=
.=20

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

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

Thanks,=20
Yuval

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

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

> Wouldn't a pl or library doing a exit(0); cause exactly that, because=20
> 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