Fwd: [BUGS] BUG #13900: stop standby failed with writer process hang(happen 3 times in 2 days)

[Jov]

Thanks Belousov! this is the output:
root at 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 at gmail.com>:

> On Sun, Jan 31, 2016 at 11:27:56PM +0800, Jov wrote:
> > root at 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.
>