[pgpool-general: 3827] PGPool-II 3.4.2 -- Not always unlinking local sockets on shutdown/restart
James Elsdon
jamesys at gmail.com
Mon Jun 22 11:55:57 JST 2015
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150622/42e24aea/attachment-0001.html>
More information about the pgpool-general
mailing list