[pgpool-general: 264] Problem with syslog

José Arthur Benetasso Villanova jose.arthur at gmail.com
Sat Mar 3 08:07:15 JST 2012


Hi all.

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.

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.

When I start pgpool without flags, I got this strace fragment:

4177  open("/etc/pgpool-II-91/pool_passwd", O_RDWR) = 3
4177  semget(IPC_PRIVATE, 3, IPC_CREAT|IPC_EXCL|0600) = 6520852
4177  semctl(6520852, 0, SETVAL, 0x1)   = 0
4177  semctl(6520852, 1, SETVAL, 0x1)   = 0
4177  semctl(6520852, 2, SETVAL, 0x1)   = 0
4177  open("/tmp/pgpool_status", O_RDONLY) = 4
4177  close(4)                          = 0
4177  unlink("/tmp/pgpool_status")      = 0
4177  gettimeofday({1330727564, 132600}, NULL) = 0
4177  open("/etc/localtime", O_RDONLY)  = 4
4177  fstat(4, {st_mode=S_IFREG|0644, st_size=2001, ...}) = 0
4177  fstat(4, {st_mode=S_IFREG|0644, st_size=2001, ...}) = 0
4177  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x7f02fe5f1000
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
4177  lseek(4, -1280, SEEK_CUR)         = 721
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
4177  close(4)                          = 0
4177  munmap(0x7f02fe5f1000, 4096)      = 0
4177  sendto(3, "<133>Mar  2 19:32:44 pgpool[4177"..., 83, MSG_NOSIGNAL,
NULL, 0) = -1 ENOTSOCK (Socket operation on non-socket)
4177  close(3)

The first line it opens /etc/pgpool-II-91/pool_passwd. Almost in the end,
it tries to log in the same file descriptor.

What caused this is:

log_destination = 'syslog' and daemonize togheter. Anyone get this before?

My system:

root at pgpool pgpool-II-91]# uname -a
Linux pgpool.pg 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
[root at pgpool pgpool-II-91]# rpm -qf /etc/pgpool-II-91/pgpool.conf.sample
pgpool-II-91-3.1-1.rhel6.x86_64

Thanks in advance.

-- 
José Arthur Benetasso Villanova
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120302/fb45d230/attachment.html>


More information about the pgpool-general mailing list