[pgpool-general: 3950] Re: PGPool-II 3.4.2 -- Not always unlinking local sockets on shutdown/restart
Alexandru Cardaniuc
cardaniuc at gmail.com
Tue Aug 11 13:01:24 JST 2015
He must have used one from before. Before killproc has been used.
Was killproc removed from the postgresql yum repository RPMs? Are those
the same?
Tatsuo Ishii <ishii at postgresql.org> writes:
> What RPM are you talking about? The official RPM distributed at
> http://www.pgpool.net/yum/ do not use killproc.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
>> 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
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
--
"Violence is the last refuge of the incompetent."
- Isaak Asimov
More information about the pgpool-general
mailing list