Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaPza-0001i1-BC for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2014 13:35:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WaPzZ-0002vI-Pf for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2014 13:35:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaPzX-0002tV-V2 for pgsql-hackers@postgresql.org; Wed, 16 Apr 2014 13:35:08 +0000 Received: from moutng.kundenserver.de ([212.227.126.131]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaPzU-0003NX-HM for pgsql-hackers@postgresql.org; Wed, 16 Apr 2014 13:35:07 +0000 Received: from [10.1.0.2] (190.84.broadband17.iol.cz [109.80.84.190]) by mrelayeu.kundenserver.de (node=mreue006) with ESMTP (Nemesis) id 0LlLtL-1X862z12Qx-00bMXZ; Wed, 16 Apr 2014 15:35:02 +0200 Message-ID: <534E8705.5040500@2ndquadrant.com> Date: Wed, 16 Apr 2014 15:35:01 +0200 From: Petr Jelinek User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 MIME-Version: 1.0 To: Andres Freund , Tom Lane CC: Robert Haas , Antonin Houska , "pgsql-hackers@postgresql.org" Subject: Re: bgworker crashed or not? References: <52EBE0E0.8040303@gmail.com> <30853.1391440857@sss.pgh.pa.us> <32224.1391444962@sss.pgh.pa.us> <20140416131052.GG17874@awork2.anarazel.de> In-Reply-To: <20140416131052.GG17874@awork2.anarazel.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:h9Nz5nRIoHgg++eFHuHrSQYU9uUUiDCvrd/RiS8ItcO vRX2XwlrUr2YQ3415JaP7kSpQ94nwRs1Op94i+RV8hO83HSn3o U1nVkcQA970AHSU4tEPV20l7KNqyTVhZPRutaGTcLKikJ80AyI uerBMchLh66SnNGWnPpp27T7Gqqphd3xDeYxByo5xwNsweih+8 A4NgUPGM6+2wj+kS3FE7U5Nsi3y74znbAQhST+zDVZE+F31Z5N jKA1SNccxEENWt8xC3kww5Mmz54rDiEwaoccfTVt8T+pMl6Jlj vkknLi+zg168KtNw5RIOuFqI+5RqhL4FPgY66dCfSiC53F+cVR T/aFtKVOPPcv8DmNNuQ1/K8vzslivgf8vDwFjU5MB X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 16/04/14 15:10, Andres Freund wrote: > > I think we really should bite the bullet and change this before 9.4 > comes out. The current static bgworker facility has only been out there > for one release, and dynamic bgworkers aren't released yet at all. If we > wait with this for 9.5, we'll annoy many more people. > +1 > On 2014-02-03 11:29:22 -0500, Tom Lane wrote: >> Robert Haas writes: >>> On Mon, Feb 3, 2014 at 10:20 AM, Tom Lane wrote: >>>> So >>>> exit(0) - done, permanently >>>> exit(1) - done until restart interval >>>> exit(other) - crash >>>> and there's no way to obtain the "restart immediately" behavior? >> Also I think if we do it this way, the incompatibility impact is rather small for most existing bgworkers, like Robert I haven't seen anybody actually using the exit code 0 currently - I am sure somebody does, but it seems to be very small minority. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers