Hi all.<div><br></div><div>I'm testing pgpool-II to help me to create a robust solution to my company. I've spent a day testing it and I get stucked after a while, pgpool-II stopped to work without reason.</div><div>
<br></div><div>After debugging a while I've found that pgpool-II worked when I called it using "-n" (do not detach). After that, I tried a strace in the process and compared both outputs.</div><div><br></div>
<div>When I start pgpool without flags, I got this strace fragment:</div><div><br></div><div><div>4177 open("/etc/pgpool-II-91/pool_passwd", O_RDWR) = 3</div><div>4177 semget(IPC_PRIVATE, 3, IPC_CREAT|IPC_EXCL|0600) = 6520852</div>
<div>4177 semctl(6520852, 0, SETVAL, 0x1) = 0</div><div>4177 semctl(6520852, 1, SETVAL, 0x1) = 0</div><div>4177 semctl(6520852, 2, SETVAL, 0x1) = 0</div><div>4177 open("/tmp/pgpool_status", O_RDONLY) = 4</div>
<div>4177 close(4) = 0</div><div>4177 unlink("/tmp/pgpool_status") = 0</div><div>4177 gettimeofday({1330727564, 132600}, NULL) = 0</div><div>4177 open("/etc/localtime", O_RDONLY) = 4</div>
<div>4177 fstat(4, {st_mode=S_IFREG|0644, st_size=2001, ...}) = 0</div><div>4177 fstat(4, {st_mode=S_IFREG|0644, st_size=2001, ...}) = 0</div><div>4177 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f02fe5f1000</div>
<div>4177 read(4, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\3\0\0\0\3\0\0\0\0"..., 4096) = 2001</div><div>4177 lseek(4, -1280, SEEK_CUR) = 721</div><div>4177 read(4, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\3\0\0\0\3\0\0\0\0"..., 4096) = 1280</div>
<div>4177 close(4) = 0</div><div>4177 munmap(0x7f02fe5f1000, 4096) = 0</div><div>4177 sendto(3, "<133>Mar 2 19:32:44 pgpool[4177"..., 83, MSG_NOSIGNAL, NULL, 0) = -1 ENOTSOCK (Socket operation on non-socket)</div>
<div>4177 close(3) </div></div><div><div><br></div><div>The first line it opens /etc/pgpool-II-91/pool_passwd. Almost in the end, it tries to log in the same file descriptor.</div><div><br></div><div>What caused this is:</div>
<div><br></div><div>log_destination = 'syslog' and daemonize togheter. Anyone get this before?</div><div><br></div><div>My system:</div><div><br></div><div><div>root@pgpool pgpool-II-91]# uname -a</div><div>Linux <a href="http://pgpool.pg">pgpool.pg</a> 2.6.32-220.4.2.el6.x86_64 #1 SMP Tue Feb 14 04:00:16 GMT 2012 x86_64 x86_64 x86_64 GNU/Linux</div>
<div>[root@pgpool pgpool-II-91]# rpm -qf /etc/pgpool-II-91/pgpool.conf.sample</div><div>pgpool-II-91-3.1-1.rhel6.x86_64</div></div><div><br></div><div>Thanks in advance.</div><div><br></div>-- <br>José Arthur Benetasso Villanova<br>
</div>