[pgpool-general: 265] Re: Problem with syslog

[José Arthur Benetasso Villanova]

commit 49a36559ea7108119850519248a739d0d93eba9a
Author: Yugo Nagata <nagata at sraoss.co.jp>
Date:   Tue Feb 14 14:43:45 2012 +0900

   Fix up hangup during md5 authentication that occurs in daemon mode and
    log_destination is 'syslog'. (reported in [pgpool-hackers: 25]).

Found this just now. Sorry for the noise...

2012/3/2 José Arthur Benetasso Villanova <jose.arthur at gmail.com>

> 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
>



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