[pgpool-general: 3878] Re: PGPool-II 3.4.2 -- Not always unlinking local sockets on shutdown/restart
Alexandru Cardaniuc
cardaniuc at gmail.com
Sun Jul 19 13:22:12 JST 2015
Yes, the killproc one is the wrong one to use. Comment that one out and
uncomment the one below. Then it will work consistently.
That should probably be fixed in the published RPM at some point. The
published RPM does not have the recommended init script.
James Elsdon <jamesys at gmail.com> writes:
> Hi there,
>
> Sometimes when stopping PGPool-II, it fails to remove the socket files, preventing startup (socket already in use).
> /var/run/pgpool/.s.PGSQL.9898
> /var/run/pgpool/.s.PGSQL.9999
>
> I've taken a trace below. Unfortunately I wiped away my earlier traces showing the correct unlinking (I'll see about capturing these again) for comparison.
>
> This was done whilst pgpool was under mild load (not sure yet if it only occurs under load).
>
> 24036 select(8, [7], NULL, NULL, {0, 639203}) = 0 (Timeout)
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = 0 (Timeout)
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = ? ERESTARTNOHAND (To be restarted)
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 rt_sigreturn(0x2) = -1 EINTR (Interrupted system call)
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = 1 (in [7], left {2, 999998})
> 24036 read(7, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24071
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: worker child process with pid: 24071 exits with status 0\n", 95) = 95
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: worker child process with pid: 24071 exited with success and will not be restarted\n", 121) = 121
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24070
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: PCP child process with pid: 24070 exits with status 0\n", 92) = 92
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: PCP child process with pid: 24070 exited with success and will not be restarted\n", 118) = 118
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24068
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24068 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24068 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, 0x7fff4da2886c, WNOHANG, NULL) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 rt_sigreturn(0x2) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = 1 (in [7], left {2, 999998})
> 24036 read(7, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 wait4(-1, 0x7fff4da2886c, WNOHANG, NULL) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = ? ERESTARTNOHAND (To be restarted)
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 rt_sigreturn(0x2) = -1 EINTR (Interrupted system call)
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = 1 (in [7], left {2, 999998})
> 24036 read(7, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24065
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24065 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24065 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, 0x7fff4da2886c, WNOHANG, NULL) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = ? ERESTARTNOHAND (To be restarted)
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 rt_sigreturn(0x2) = -1 EINTR (Interrupted system call)
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 select(8, [7], NULL, NULL, {3, 0}) = 1 (in [7], left {2, 999998})
> 24036 read(7, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24061
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24061 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24061 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24063
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24063 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24063 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24056
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24056 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24056 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24058
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24058 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24058 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24060
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24060 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24060 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24057
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24057 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24057 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24053
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24053 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24053 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24054
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24054 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24054 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24055
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24055 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24055 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24052
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24052 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24052 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24049
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24049 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24049 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24064
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24064 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24064 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24050
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24050 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24050 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24046
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24046 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24046 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24051
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24051 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24051 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24047
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24047 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24047 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24043
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24043 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24043 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24048
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24048 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24048 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24044
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24044 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24044 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24045
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24045 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24045 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24040
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24040 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24040 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24042
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24042 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24042 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG, NULL) = 24041
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24041 exits with status 0\n", 88) = 88
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: child process with pid: 24041 exited with success and will not be restarted\n", 114) = 114
> 24036 wait4(-1, 0x7fff4da2886c, WNOHANG, NULL) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 --- SIGTERM (Terminated) @ 0 (0) ---
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 rt_sigreturn(0x2) = 0
> 24036 rt_sigreturn(0x2) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE SEGV ALRM TERM CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: received smart shutdown request\n", 70) = 70
> 24036 stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2197, ...}) = 0
> 24036 write(2, "2015-06-22 12:14:43: pid 24036: LOG: shutdown request. closing listen socket\n", 78) = 78
> 24036 close(4) = 0
> 24036 close(5) = 0
> 24036 close(6) = 0
> 24036 kill(24038, SIGTERM) = 0
> 24036 kill(24039, SIGTERM) = 0
> 24036 kill(24059, SIGTERM) = 0
> 24036 kill(24062, SIGTERM) = 0
> 24036 kill(24066, SIGTERM) = 0
> 24036 kill(24067, SIGTERM) = 0
> 24036 kill(24069, SIGTERM) = 0
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 --- SIGCHLD (Child exited) @ 0 (0) ---
> 24036 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], NULL, 8) = 0
> 24036 write(8, "\0", 1) = 1
> 24036 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> 24036 rt_sigreturn(0x2) = 0
> 24036 wait4(-1, NULL, 0, NULL) = 24038
> 24036 wait4(-1, NULL, 0, NULL) = 24039
> 24036 wait4(-1, <unfinished ...>
> 24036 +++ killed by SIGKILL +++
>
> pgpool-II log (I manually remove the socket files to get it starting):
>
> 2015-06-22 12:12:45: pid 23633: LOG: received smart shutdown request
> 2015-06-22 12:12:45: pid 23633: LOG: shutdown request. closing listen socket
> 2015-06-22 12:12:45: pid 23661: LOG: child process received shutdown request signal 15
> 2015-06-22 12:12:45: pid 23662: LOG: child process received shutdown request signal 15
> 2015-06-22 12:12:45: pid 23664: LOG: child process received shutdown request signal 15
> 2015-06-22 12:12:45: pid 23665: LOG: child process received shutdown request signal 15
> 2015-06-22 12:12:45: pid 23666: LOG: child process received shutdown request signal 15
> stdin: is not a tty
> stdin: is not a tty
> 2015-06-22 12:12:49: pid 23988: FATAL: failed to bind a socket: "/var/run/pgpool/.s.PGSQL.9999"
> 2015-06-22 12:12:49: pid 23988: DETAIL: bind socket failed with error: "Address already in use"
> stdin: is not a tty
> stdin: is not a tty
> 2015-06-22 12:13:08: pid 24036: LOG: Setting up socket for 0.0.0.0:9999
> 2015-06-22 12:13:08: pid 24036: LOG: Setting up socket for :::9999
> 2015-06-22 12:13:08: pid 24036: LOG: pgpool-II successfully started. version 3.4.2 (tataraboshi)
>
> I'm using the initscript supplied with the RPM which defines stop as
>
> stop(){
> echo -n $"Stopping ${NAME} service: "
> if [ $UID -ne 0 ]; then
> RETVAL=1
> failure
> else
> killproc /usr/bin/pgpool
> # $PGPOOLDAEMON stop & >> "$PGPOOLLOG" 2>&1 < /dev/null
> RETVAL=$?
> [ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/${NAME}
> fi;
> echo
> return $RETVAL
> }
>
> (I notice the native pool stop command has been commented out in favor of a rhel killproc -- it seems to work some of the time however).
>
> Is there a method to disable the local socket (similar to can be done with the network socket) -- I'm only communicating via tcp.
>
> Thanks and regards,
> James Elsdon
>
> _______________________________________________ pgpool-general mailing
> list pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
--
"The price of freedom is responsibility, but it's a bargain, because
freedom is priceless."
- Hugh Downs
More information about the pgpool-general
mailing list