From owner-freebsd-hackers@freebsd.org Tue Feb 2 01:36:40 2016 Return-Path: Delivered-To: freebsd-hackers@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 77B05A9851A for ; Tue, 2 Feb 2016 01:36:40 +0000 (UTC) (envelope-from zhao6014@gmail.com) Received: from mail-yk0-x229.google.com (mail-yk0-x229.google.com [IPv6:2607:f8b0:4002:c07::229]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 33A941B39 for ; Tue, 2 Feb 2016 01:36:40 +0000 (UTC) (envelope-from zhao6014@gmail.com) Received: by mail-yk0-x229.google.com with SMTP id z13so68539431ykd.0 for ; Mon, 01 Feb 2016 17:36:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=VvPpj7lYqyddGkiPnpSaNWLTkIAvOvwmbWBo2Evdy5k=; b=RQlwPNp6YSjmWTB5xENWg7XYJ+ff7ab+e97RXL79F6rDl7dx1lxbx0zep8SJ3I2Ww7 jb6MPfVLQVofgkcuTR44NOfjr0XuPpZvHcczooUbaHHeSfj+rmz9jBBCHJPnFRMhR/as BcUwYPh3yfgSdhwl1v/uQ6HpSz+6QLKF8yFu6Y3lwmimZuLJQi0ujdha4ANXI6/JqVQ5 Mt0WzjuM2/CBzJaKpoStghwBVZknOgA/isBwxXKvo7TEI3SMxV0CrihnFWl42Uy9AcBT TzoERf586XvEqxSq6TyGE9NBUwKYy3M5w0/pW0yOMZBbAlA1IMxje2n6Q2aGR38DpMJB +qUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type; bh=VvPpj7lYqyddGkiPnpSaNWLTkIAvOvwmbWBo2Evdy5k=; b=aURvBHHrlLjAJydf1sOx9BK8Jv+ZkcYUYXWdJDakqjjRuX6dXL6YD/hrieHWpFRW5Q xnwHzD1io1MQNxZu/QBfNEl2ZgL/HD4ry1nnSc3r5IFMDRN89O5Xes++8PVTikYPNs9K RwMz3CfTBmCAidVAes26Lb+LJJG7ENWlsc18WgMVUV/O1pxc8IshaJ2wIYD5MTSsFFMd j8NxYEI385xCvdyR/ATc6proiBGtk535ixPreFPpe7Uza9/njnkxxxQtFpjleU3p8JG2 6hVZnX5v4nY6/haWgbjUI7CgR520qML4U3kLAHlmBKi9UY6lRfDtjlGCPjHrfQIFTXGs afew== X-Gm-Message-State: AG10YOQraNwo4nVZ74TNshhTSVo6grF9S5kLmKaPS09DrWoeDLHg68zWAMa84t2Na6aacIhlQb0ytsdEIC0dqA== X-Received: by 10.37.4.146 with SMTP id 140mr15584308ybe.18.1454376998610; Mon, 01 Feb 2016 17:36:38 -0800 (PST) MIME-Version: 1.0 Received: by 10.37.79.6 with HTTP; Mon, 1 Feb 2016 17:36:19 -0800 (PST) In-Reply-To: <20160201190415.GO91220@kib.kiev.ua> References: <20160130071346.31022.37189@wrigleys.postgresql.org> <20160131162929.GI91220@kib.kiev.ua> <20160201190415.GO91220@kib.kiev.ua> From: Jov Date: Tue, 2 Feb 2016 09:36:19 +0800 Message-ID: Subject: Re: Fwd: [BUGS] BUG #13900: stop standby failed with writer process hang(happen 3 times in 2 days) To: Konstantin Belousov Cc: freebsd-hackers@freebsd.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.20 X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Feb 2016 01:36:40 -0000 =E2=80=8BThanks for your info,Belousov. Would you please point which PR or which commit I can exam=EF=BC=9FI can no= t move to 10 stable now,maybe I can avoid trigger this bug or add some monitor=E2= =80=8B. Jov blog: http:amutu.com/blog 2016-02-02 3:04 GMT+08:00 Konstantin Belousov : > On Mon, Feb 01, 2016 at 10:07:18AM +0800, Jov wrote: > > Thanks Belousov! this is the output: > > root@fb:~ # ps axlHww | grep 979 > > 1001 979 1 0 4 0 196940 8236 - Ds - 0:06.0= 3 > > postgres: writer process (postgres) > > 0 48614 48587 0 20 0 18824 2252 piperd S+ 0 0:00.0= 0 > > grep 979 > > > > > > I use PostgreSQL on FreeBSD more than 3 years and this is the first tim= e > I > > have problems. > > I am suspicious of this problem related with the harden of the security > of > > the FreeBSD, I add these entry to all of my server aouble one month ago= : > I doubt that this is related. > > The problem you reported is somewhat known, I am not sure about the state > of it on stable/9. There were some fixes on HEAD and stable/10, there > were many attempts of changes. I currently believe that it is mostly > fixed, and ony pending fix is a minor patch I provided for several > people. But this is only for HEAD and 10. > > > > > > > security.bsd.see_other_uids=3D0 > > security.bsd.see_other_gids=3D0 > > security.bsd.unprivileged_read_msgbuf=3D0 > > security.bsd.unprivileged_proc_debug=3D0 > > security.bsd.hardlink_check_uid=3D1 > > security.bsd.hardlink_check_gid=3D1 > > > security.bsd.stack_guard_page=3D1 > This setting would do nothing for you. > > > security.bsd.unprivileged_mlock=3D0 > And this one causes less 'security' since programs like gpg no longer can > allocate non-swappable memory for sensitive data without setuid. >