From owner-freebsd-hackers@freebsd.org Mon Feb 1 02:07:39 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 5DBEBA74E2F for ; Mon, 1 Feb 2016 02:07:39 +0000 (UTC) (envelope-from zhao6014@gmail.com) Received: from mail-yk0-x236.google.com (mail-yk0-x236.google.com [IPv6:2607:f8b0:4002:c07::236]) (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 1F3F911A9 for ; Mon, 1 Feb 2016 02:07:39 +0000 (UTC) (envelope-from zhao6014@gmail.com) Received: by mail-yk0-x236.google.com with SMTP id r207so87103250ykd.2 for ; Sun, 31 Jan 2016 18:07:39 -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=aTeCZ6nwT7OpwIh4rtdLVNs6SZTJ8ph/TgmUb+ZmS3Y=; b=hKqybCRThyMf0l2w3WoGOfV43nntfBx9iNC827kVfyGH+nvIhYumqfIyiSnMEd+zeT XmAn7EYPYeirbEDpRa7iUre52Co+N7qDJiwSMOqfml1LQXfy+2JpSmdP98VpKJJPqB1o z212K9in5+cCbjwj52r43zwnYdkhqcX6ZEl/nPDAsHa3RhsOVyoMdGTJE+0MzwlD8djd OU6yy0JzS3Gqxbh69Soo3GISzH1EMiciRz6O5EeSSePBbynXQqKrH1UlMGyPFsAxyiMp Pyxw27ytGgyu7gIu9EX6Z3lwqUXNmwALzO/QdfLZpFrLOdoUnU24nO4zo6QJ6EUVI9fj R4pg== 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=aTeCZ6nwT7OpwIh4rtdLVNs6SZTJ8ph/TgmUb+ZmS3Y=; b=caIlS64uE5uYQY26r90XNeb6hc8u7RyKh422ptInQbK5z0K6EEzZD8qtW4ew1lQ93Y 9ngPgFIMdhCAXMfJUXifM1yGRQ1/MbVq50v8aQNNiEDB/ehi9lHRlvY5DjaApiPAqKxI zl24os+9iO/I5qrzje+g/LlBxU4tCvXbWZFsrCGfbM2FAL4x4A+b8YQq/RhxNhWkurxP rWk/c2PYRRh8FfKMZM++fDv8p291Rl/kFDnrYWUEDKuhchBh4y65pTMvLRvbjT/PV+fM NvFVGMXYzm6n1wjd1pZ2ae8NXyp6eoZ/YmY75yrdATv96uuXx5mORNlJtLOvaL1FM0Gj bjOA== X-Gm-Message-State: AG10YOSeM5+RuTKK6GF4MLi0IbY4s0bO2bk6gYnAml/5+xJdt25C0FOh64F1nB8vJ9YA3lZmw5tTXqNdCIFHmg== X-Received: by 10.129.91.132 with SMTP id p126mr10354678ywb.188.1454292458185; Sun, 31 Jan 2016 18:07:38 -0800 (PST) MIME-Version: 1.0 Received: by 10.37.79.6 with HTTP; Sun, 31 Jan 2016 18:07:18 -0800 (PST) In-Reply-To: <20160131162929.GI91220@kib.kiev.ua> References: <20160130071346.31022.37189@wrigleys.postgresql.org> <20160131162929.GI91220@kib.kiev.ua> From: Jov Date: Mon, 1 Feb 2016 10:07:18 +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 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: Mon, 01 Feb 2016 02:07:39 -0000 Thanks Belousov! this is the output: root@fb:~ # ps axlHww | grep 979 1001 979 1 0 4 0 196940 8236 - Ds - 0:06.03 postgres: writer process (postgres) 0 48614 48587 0 20 0 18824 2252 piperd S+ 0 0:00.00 grep 979 I use PostgreSQL on FreeBSD more than 3 years and this is the first time 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: security.bsd.see_other_uids=0 security.bsd.see_other_gids=0 security.bsd.unprivileged_read_msgbuf=0 security.bsd.unprivileged_proc_debug=0 security.bsd.hardlink_check_uid=1 security.bsd.hardlink_check_gid=1 security.bsd.stack_guard_page=1 security.bsd.unprivileged_mlock=0 Jov blog: http:amutu.com/blog 2016-02-01 0:29 GMT+08:00 Konstantin Belousov : > On Sun, Jan 31, 2016 at 11:27:56PM +0800, Jov wrote: > > root@fb:~ # procstat -kk 979 > > PID TID COMM TDNAME KSTACK > > > > 979 100688 postgres - mi_switch+0xe1 > > sleepq_timedwait_sig+0x8b _cv_timedwait_sig_sbt+0x18b seltdwait+0xa4 > > kern_poll+0x464 sys_poll+0x61 amd64_syscall+0x357 Xfast_syscall+0xfb > > > Show me 'ps axlHww | grep 979' output. >