Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iIzHX-0005fo-O7 for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Oct 2019 18:04:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iIzHW-0007nE-Ex for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Oct 2019 18:04:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iIzHW-0007n5-5W for pgsql-hackers@lists.postgresql.org; Fri, 11 Oct 2019 18:04:50 +0000 Received: from mail-ot1-x342.google.com ([2607:f8b0:4864:20::342]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iIzHS-0007Ni-RK for pgsql-hackers@postgresql.org; Fri, 11 Oct 2019 18:04:49 +0000 Received: by mail-ot1-x342.google.com with SMTP id k32so8730849otc.4 for ; Fri, 11 Oct 2019 11:04:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=L3rGiXVKw8ngmri5/qc+6kYPHtBiZ/u6m4eybPNY29E=; b=q/uXA1bm78YtvNqdkMw3YM/FUGPD7YwJCViYOI/zn1cqH0ifp8WobLkAfdgKQU/nsU 64vthGBgOAPVm25qMn+/HW+YafKd3Guql8f7QTIH9N0ZeBMEe8axNb9VYIbkgZI5hzCG uSJL0hXXhoDftu+TPjeas57ChgRWM6tFpxqDoYdf7SXb6+NVwbTlE7xlymNOSZY7l03e 8MZ4UzLY9ur7+zowQy164yiizbyRoS22sbdSbxqW5W40DSB6Z4zAaUsQaJLgx/2t1ySN XN9+NodeB0v+iovuIr5EZc2oLLBNMbSsfcjLchlb8rsxXm9j1JbIlELEE5gVu4rjh8TX 5/Ew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-transfer-encoding:content-language; bh=L3rGiXVKw8ngmri5/qc+6kYPHtBiZ/u6m4eybPNY29E=; b=YYsC1ckvtVtoUmn/IlH/akyJ6qTwq84+lqRY8UQsTUBj1WJ/NODS90zT6Zojw2QoSA CyEnfpE3PdLbZ3dpySQo9JWhm0rYCncX9cN2MhR+/ovDVhfZEGGOJEIAiMLg05EEw0TH KdM91LhUb3i7bKBw54oWqQcDi0hIuAOr59pPXddaYJkfdPeXoh62Kffh2JmehCDZBZNc kaw1/yQ7UsH/ugmrSsDJ952PXQLoHnWCn2cHCwmUci3s9xlRsFLJ3vmnb/P26TIgR8i4 YxfVZ7/hYjFwUADLzWAGDHs78KtqwJ7Vs/DcYZsgpKV5nKszJqmnm+RsQ1TPZTle95hQ GH/w== X-Gm-Message-State: APjAAAUV8KdmL0Cg2fA8xUYENOoTFEW3RLTCE7YVSHpAznJbKvT7czjG nERni9kIPcMIaFNV4wALsbRbRT94E/Vm1IjgDivdfKy8WMYPpn8gOllTW2L/aPNKGlvcbuH/IeB esH0PATMqXeQm/7i4EMUKl1POwQaOdzV6LgAM02PE+UD18Twl8gQS+Hsh3DYZR8QtABaqoJsHQ0 i345tetodf9DoqBf8= X-Google-Smtp-Source: APXvYqyknQXqdzjIyCNc2WaBEuYYFmheTPPKBUz1VorNxRL3E2l3VzxxRaROhBuTjZ6t2YsICPKpQA== X-Received: by 2002:a9d:6858:: with SMTP id c24mr12890300oto.124.1570817084195; Fri, 11 Oct 2019 11:04:44 -0700 (PDT) Received: from [192.168.10.146] (99-10-92-30.lightspeed.rlghnc.sbcglobal.net. [99.10.92.30]) by smtp.gmail.com with ESMTPSA id q6sm2927696oth.76.2019.10.11.11.04.42 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 11 Oct 2019 11:04:42 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: stress test for parallel workers To: Tom Lane Cc: mark@2ndquadrant.com, Thomas Munro , Justin Pryzby , Andres Freund , pgsql-hackers References: <20190723162703.GM22387@telsasoft.com> <6762.1563902927@sss.pgh.pa.us> <20190723174222.GO22387@telsasoft.com> <32179.1563919918@sss.pgh.pa.us> <17389.1563945314@sss.pgh.pa.us> <31032.1565152159@sss.pgh.pa.us> <18537.1570421268@sss.pgh.pa.us> <5350.1570743291@sss.pgh.pa.us> <84813a30-8c34-9c32-7ad5-90d9eefba468@2ndQuadrant.com> <06d6be5a-7af2-ef78-0abc-6bfe500ead87@2ndQuadrant.com> <20032.1570808731@sss.pgh.pa.us> Openpgp: preference=signencrypt Autocrypt: addr=andrew.dunstan@2ndQuadrant.com; prefer-encrypt=mutual; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNL0FuZHJldyBEdW5zdGFuIDxhbmRyZXcuZHVuc3RhbkAybmRRdWFkcmFudC5jb20+wsCY BBMBAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAUJDyV6hBYhBOQ+WEYd/Hy/RGkV pZn6f8tZ/DuBBQJcH/EVAhkBAAoJEJn6f8tZ/DuB7BEH/iDWZEbVft2m2MT6SPjARzTupt/l xLLZ/Cl6n2US2hov5+fBbnR5xvECk/YCOfG9ICvKNlpFjceqNLRKStd8cmndnI+kDw91uNM2 hpL4aJMeW65XCHvqXlOLSwv5chBpXz9NG7FMaJ+q+59sWEWjcTNmjXgkEHn53y+1pc7nSLDe cr5ZI1aB3nGXRm1SoDY5PYZkUKMykW+YBZwgcs/Q5tRaE+siN7DKbz8E628+PerwAkmHPVXN MdJFD6gs4S0gDFA8IxcyIwZU2v4By+brzcJ9Se3FK5BYxBDHtaYZxgSrJAvOUOrLIZPQTQfL TtnVs3C3JTfrxCH1ceHtnA6dRuTOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oK Waqf+wmW4tpDe/VVcxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7 llV0xSSoFiieQBsrGvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8 BoVrRFcdzlIY/NFNhFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C 4R+M6w7o2PLGOjdZ+kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaY L++LAEOqrlvm2TvqQqZRtnEAEQEAAcLAZQQYAQIADwIbDAUCXA6fpAUJDyV6xAAKCRCZ+n/L Wfw7geU4B/9vFFsVmWxerDWgNjyiK80zIPmlw/iwdUlU6FIu0JWLMg4093kvxBs7RMZV9hBq n3ekBvD4IvFsVLJrw9qzSI2FH3UeYy5WXpEs01Ppia60NOlvRDqXbryzuvfe+iYo6bVP3Ikr TPTNYL/BePUTD2DPvSI82SbGTyzuA7SJv6NRqqQDMIy1fU6KyQFLmQJp/QJyhKWzm9jWh8ee w8jVaoMY0Kbq5N7RqisEx1Lu/Iw646UphdYzQNymf+kbiU5Kf4I6DhzV8w9sie1Bo1juNj3I c5/fFJsmxljbnaDbXPcnFsur1Oo9mIHFakgWgOBMuxoWfjONiLjjLh/9+ZIqSSLX Message-ID: Date: Fri, 11 Oct 2019 14:04:41 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.0 MIME-Version: 1.0 In-Reply-To: <20032.1570808731@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 10/11/19 11:45 AM, Tom Lane wrote: > Andrew Dunstan writes: >>> At least on F29 I have set /proc/sys/kernel/core_pattern and it works. > FWIW, I'm not excited about that as a permanent solution. It requires > root privilege, and it affects the whole machine not only the buildfarm, > and making it persist across reboots is even more invasive. OK, but I'm not keen to have to tussle with coredumpctl. Right now our logic says: for every core file in the data directory try to get a backtrace. Use of systemd-coredump means that gets blown out of the water, and we no longer even have a simple test to see if our program caused a core dump. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services