[root@conops2 log]# strace -frp 3526 Process 3526 attached - interrupt to quit 0.000000 select(6, [3 4 5], NULL, NULL, {1, 445000}) = 0 (Timeout) 1.446027 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0 0.000217 time(NULL) = 1099092340 0.000147 clone(Process 3683 attached child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xf70df748) = 3683 [pid 3526] 0.000920 utime("/tmp/.s.PGSQL.5432", NULL [pid 3683] 0.000124 close(3 [pid 3526] 0.000189 <... utime resumed> ) = 0 [pid 3683] 0.000068 <... close resumed> ) = 0 [pid 3526] 0.000070 utime("/tmp/.s.PGSQL.5432.lock", NULL [pid 3683] 0.000142 close(4) = 0 [pid 3683] 0.000097 close(5) = 0 [pid 3683] 0.000095 close(7) = 0 [pid 3683] 0.000113 close(8) = 0 [pid 3526] 0.000318 <... utime resumed> ) = 0 [pid 3526] 0.000209 rt_sigprocmask(SIG_SETMASK, [], [pid 3683] 0.000090 open("/var/lib/pgsql/data/PG_VERSION", O_RDONLY|O_LARGEFILE) = 3 [pid 3526] 0.000226 <... rt_sigprocmask resumed> NULL, 8) = 0 [pid 3683] 0.000084 fstat64(3, [pid 3526] 0.000080 select(6, [3 4 5], NULL, NULL, {60, 0} [pid 3683] 0.000228 <... fstat64 resumed> {st_mode=S_IFREG|0600, st_size=4, ...}) = 0 [pid 3683] 0.000213 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xf64c7000 [pid 3683] 0.000145 read(3, "7.4\n", 4096) = 4 [pid 3683] 0.000216 close(3) = 0 [pid 3683] 0.000106 munmap(0xf64c7000, 4096) = 0 [pid 3683] 0.000127 rt_sigaction(SIGHUP, {SIG_IGN}, {0x8157600, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000166 rt_sigaction(SIGINT, {SIG_IGN}, {0x81576d0, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000162 rt_sigaction(SIGTERM, {0x817dd50, [], SA_RESTART}, {0x81576d0, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000166 rt_sigaction(SIGQUIT, {0x817dca0, [], SA_RESTART}, {0x81576d0, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000180 rt_sigaction(SIGALRM, {SIG_IGN}, {SIG_IGN}, 8) = 0 [pid 3683] 0.000153 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_IGN}, 8) = 0 [pid 3683] 0.000151 rt_sigaction(SIGUSR1, {SIG_IGN}, {0x8158cb0, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000158 rt_sigaction(SIGUSR2, {SIG_IGN}, {0x8158e40, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000165 rt_sigaction(SIGCHLD, {SIG_DFL}, {0x8157a60, [], SA_RESTART}, 8) = 0 [pid 3683] 0.000158 rt_sigaction(SIGTTIN, {SIG_DFL}, {SIG_IGN}, 8) = 0 [pid 3683] 0.000188 rt_sigaction(SIGTTOU, {SIG_DFL}, {SIG_IGN}, 8) = 0 [pid 3683] 0.000152 rt_sigaction(SIGCONT, {SIG_DFL}, {SIG_DFL}, 8) = 0 [pid 3683] 0.000152 rt_sigaction(SIGWINCH, {SIG_DFL}, {SIG_DFL}, 8) = 0 [pid 3683] 0.000152 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 [pid 3683] 0.000315 semctl(3473447, 4, IPC_64|SETVAL, 0xfeea7a34) = 0 [pid 3683] 0.000358 time(NULL) = 1099092340 [pid 3683] 0.000770 exit_group(0) = ? Process 3683 detached 0.000709 <... select resumed> ) = ? ERESTARTNOHAND (To be restarted) 0.000133 --- SIGCHLD (Child exited) @ 0 (0) --- 0.000187 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0 0.000308 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 3683 0.000286 time(NULL) = 1099092340 0.000269 waitpid(-1, 0xfeea789c, WNOHANG) = 0 0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 0.000121 sigreturn() = ? (mask now []) 0.000204 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0 0.000141 time(NULL) = 1099092340 0.000117 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 0.000128 select(6, [3 4 5], NULL, NULL, {300, 0}) = 1 (in [4], left {297, 849000}) 2.150629 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0 0.000177 accept(4, {sa_family=AF_INET, sin_port=htons(32825), sin_addr=inet_addr("127.0.0.1")}, [16]) = 9 0.000431 getsockname(9, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0 0.000454 setsockopt(9, SOL_TCP, TCP_NODELAY, [1], 4) = 0 0.000285 setsockopt(9, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 0.000147 clone(Process 3686 attached child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xf70df748) = 3686 [pid 3526] 0.001056 close(9 [pid 3686] 0.000162 close(3 [pid 3526] 0.000062 <... close resumed> ) = 0 [pid 3686] 0.000072 <... close resumed> ) = 0 [pid 3686] 0.000062 close(4) = 0 [pid 3686] 0.000106 close(5) = 0 [pid 3526] 0.000114 time( [pid 3686] 0.000062 close(7) = 0 [pid 3686] 0.000113 close(8) = 0 [pid 3686] 0.000179 rt_sigaction(SIGTERM, {0x817dde0, [], SA_RESTART}, [pid 3526] 0.000105 <... time resumed> NULL) = 1099092342 [pid 3686] 0.000064 <... rt_sigaction resumed> {0x81576d0, [], SA_RESTART}, 8) = 0 [pid 3686] 0.000105 rt_sigaction(SIGQUIT, {0x817dde0, [], SA_RESTART}, [pid 3526] 0.000110 rt_sigprocmask(SIG_SETMASK, [], [pid 3686] 0.000083 <... rt_sigaction resumed> {0x81576d0, [], SA_RESTART}, 8) = 0 [pid 3686] 0.000104 rt_sigaction(SIGALRM, {0x817dde0, [], 0}, [pid 3526] 0.000090 <... rt_sigprocmask resumed> NULL, 8) = 0 [pid 3686] 0.000060 <... rt_sigaction resumed> {SIG_IGN}, 8) = 0 [pid 3526] 0.000098 select(6, [3 4 5], NULL, NULL, {298, 0} [pid 3686] 0.000224 rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE SEGV ALRM TERM CONT SYS RTMIN], NULL, 8) = 0 [pid 3686] 0.000372 socket(PF_FILE, SOCK_DGRAM, 0) = 3 [pid 3686] 0.000301 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0 [pid 3686] 0.000315 connect(3, {sa_family=AF_FILE, path="/dev/log"}, 16) = 0 [pid 3686] 0.000381 time([1099092342]) = 1099092342 [pid 3686] 0.000343 rt_sigaction(SIGPIPE, {0x36e450, [], 0}, {SIG_IGN}, 8) = 0 [pid 3686] 0.000339 send(3, "<134>Oct 29 19:25:42 postgres[36"..., 95, 0) = 95 [pid 3686] 0.000304 rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0 [pid 3686] 0.000168 write(2, "LOG: connection received: host="..., 53) = 53 [pid 3686] 0.000189 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={60, 0}}, NULL) = 0 [pid 3686] 0.000196 recv(9, "\0\0\0\10\4\322\26/", 8192, 0) = 8 [pid 3686] 0.000212 send(9, "N", 1, 0) = 1 [pid 3686] 0.000685 recv(9, "\0\0\0$\0\3\0\0user\0shawn\0database\0nagi"..., 8192, 0) = 36 [pid 3686] 0.000854 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4 [pid 3686] 0.000152 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0 [pid 3686] 0.000214 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0 [pid 3686] 0.000252 close(4) = 0 [pid 3686] 0.000135 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4 [pid 3686] 0.000127 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0 [pid 3686] 0.000148 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0 [pid 3686] 0.000256 close(4) = 0 [pid 3686] 0.000120 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 4 [pid 3686] 0.000126 connect(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0 [pid 3686] 0.000153 getsockname(4, {sa_family=AF_INET, sin_port=htons(32776), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0 [pid 3686] 0.000241 close(4) = 0 [pid 3686] 59.996233 --- SIGALRM (Alarm clock) @ 0 (0) --- [pid 3686] 0.000800 exit_group(0) = ? Process 3686 detached 0.000761 <... select resumed> ) = ? ERESTARTNOHAND (To be restarted) 0.000524 --- SIGCHLD (Child exited) @ 0 (0) --- 0.000117 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0 0.000169 waitpid(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], WNOHANG) = 3686 0.000287 send(6, "\2\0\0\0\30\0\0\0\0\0\0\0f\16\0\0\0\0\0\0\0\0\0\0", 24, 0) = 24 0.000650 waitpid(-1, 0xfeea789c, WNOHANG) = 0 0.000121 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 0.000117 sigreturn() = ? (mask now []) 0.000406 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN], NULL, 8) = 0 0.000224 time(NULL) = 1099092402 0.000125 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 0.000126 select(6, [3 4 5], NULL, NULL, {238, 0} Process 3526 detached