Date: Mon, 1 Feb 2016 10:07:18 +0800 From: Jov <zhao6014@gmail.com> To: Konstantin Belousov <kostikbel@gmail.com> Cc: freebsd-hackers@freebsd.org Subject: Re: Fwd: [BUGS] BUG #13900: stop standby failed with writer process hang(happen 3 times in 2 days) Message-ID: <CADyrUxOw%2Bn-ZB9f71v9PFjB_Mk=x8-DMZWqsD0GXK0DYEVw2fA@mail.gmail.com> In-Reply-To: <20160131162929.GI91220@kib.kiev.ua> References: <20160130071346.31022.37189@wrigleys.postgresql.org> <CADyrUxM9jWVrUZYkUYP6vxgg_eWOuCqCQTqEERQ6iSq11DjUeA@mail.gmail.com> <20160131162929.GI91220@kib.kiev.ua>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <kostikbel@gmail.com>: > 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. >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CADyrUxOw%2Bn-ZB9f71v9PFjB_Mk=x8-DMZWqsD0GXK0DYEVw2fA>