[pgpool-general: 3879] Re: PGPool-II 3.4.2 -- Not always unlinking local sockets on shutdown/restart
Tatsuo Ishii
ishii at postgresql.org
Sun Jul 19 19:17:51 JST 2015
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
More information about the pgpool-general
mailing list