[pgpool-general: 3952] Re: PGPool-II 3.4.2 -- Not always unlinking local sockets on shutdown/restart
Tatsuo Ishii
ishii at postgresql.org
Tue Aug 11 13:05:48 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?
I don't know. I am not the maintainer of the postgresql yum
repository.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list