Re: [Pgpool-general] Is pgpool_walrecrunning needed in Master/Slave mode?

[Sandeep Thakkar]

Thanks Tatsuo.

By streaming replication mode, you mean the 'replication_mode = true' in 
pgpool.conf?If I use pgpool-II-3.0.3, and configure it in Master/Slave mode 
with sub mode as 'stream', then I do not need this function., right?
 
Sandeep.



From: Tatsuo Ishii 
To: sandee...@yahoo.com
Cc: pgpool-general@pgfoundry.org
Sent: Saturday, September 17, 2011 1:40 PM
Subject: Re: [Pgpool-general] Is pgpool_walrecrunning needed in Master/Slave 
mode?

> I read the 3.0.3 docs and found that pgpool_walrecrunning() should be used 
> only in replication mode, and that too when somebody is using the 
> failure/online recovery feature of pgPoll-II.

pgpool_walrecrunning is only usefull for streaming replication
mode in 3.0.x.

> At the same time, I found that this function has undergone some change:
> "
> 
> Now "pgpool_walrecrunning()" was not used. pgpool-II used to consider the 
> node that is promoted a primary node using the function. Now, pgpool-II waits 
> for completing of the promotion to primary node because it did not work as we 
> intended. But we still have a problem that pgpool-II waits while 
> recovery_timeout, when there is no primary node(Kitagawa)
>  "
> 
> Can someone elaborate this please? Also, I assume that I need this function 
> only when I setup pgPool-II in replication mode.

In pgpool-II 3.1 the function is not used anymore even in streaming
replication mode.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] seemingly hung pgpool process consuming 100% CPU

[Lonni J Friedman]

This happened again.  I ran the gdb command that you requested,
however it occurred to me that the output may not be all that useful
since I'm not running a debug build of pgpool:
###
# gdb pgpool 2343
GNU gdb (GDB) Red Hat Enterprise Linux (7.1-29.el6)
Copyright (C) 2010 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later 
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
...
Reading symbols from /usr/sbin/pgpool...(no debugging symbols found)...done.
Attaching to program: /usr/sbin/pgpool, process 2343
Reading symbols from /usr/lib64/libpq.so.5...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libpq.so.5
Reading symbols from /usr/lib64/libpcp.so.0...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libpcp.so.0
Reading symbols from /lib64/libpam.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib64/libpam.so.0
Reading symbols from /usr/lib64/libssl.so.10...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libssl.so.10
Reading symbols from /usr/lib64/libcrypto.so.10...(no debugging
symbols found)...done.
Loaded symbols for /usr/lib64/libcrypto.so.10
Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libcrypt.so.1
Reading symbols from /lib64/libresolv.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libresolv.so.2
Reading symbols from /lib64/libnsl.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libnsl.so.1
Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/libgssapi_krb5.so.2...(no debugging
symbols found)...done.
Loaded symbols for /lib64/libgssapi_krb5.so.2
Reading symbols from /usr/lib64/libldap_r-2.4.so.2...(no debugging
symbols found)...done.
Loaded symbols for /usr/lib64/libldap_r-2.4.so.2
Reading symbols from /lib64/libpthread.so.0...(no debugging symbols
found)...done.
[Thread debugging using libthread_db enabled]
Loaded symbols for /lib64/libpthread.so.0
Reading symbols from /lib64/libaudit.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libaudit.so.1
Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libkrb5.so.3...(no debugging symbols found)...done.
Loaded symbols for /lib64/libkrb5.so.3
Reading symbols from /lib64/libcom_err.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libcom_err.so.2
Reading symbols from /lib64/libk5crypto.so.3...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libk5crypto.so.3
Reading symbols from /lib64/libz.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libz.so.1
Reading symbols from /usr/lib64/libfreebl3.so...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libfreebl3.so
Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging
symbols found)...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /lib64/libkrb5support.so.0...(no debugging
symbols found)...done.
Loaded symbols for /lib64/libkrb5support.so.0
Reading symbols from /lib64/libkeyutils.so.1...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libkeyutils.so.1
Reading symbols from /usr/lib64/liblber-2.4.so.2...(no debugging
symbols found)...done.
Loaded symbols for /usr/lib64/liblber-2.4.so.2
Reading symbols from /usr/lib64/libsasl2.so.2...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libsasl2.so.2
Reading symbols from /lib64/libselinux.so.1...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libselinux.so.1
Reading symbols from /lib64/libnss_files.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /lib64/libnss_dns.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libnss_dns.so.2
0x0044790a in ?? ()
Missing separate debuginfos, use: debuginfo-install pgpool-II-3.0.4-1.el6.x86_64
(gdb) bt
#0  0x0044790a in ?? ()
#1  0x00414547 in ?? ()
#2  0x0041762e in ?? ()
#3  0x0040a4cd in ?? ()
#4  0x00405345 in ?? ()
#5  0x004068dc in ?? ()
#6  0x004076dc in ?? ()
#7  0x0031ae41ec5d in __libc_start_main () from /lib64/libc.so.6
#8  0x00403bf9 in ?? ()
#9  0x7fff0663cfc8 in ?? ()
#10 0x001c in ?? ()
#11 0x0004 in ?? ()
#12 0x7fff0663d90b in ?? ()
#13 0x7fff0663dfe6 in ?? ()
#14 0x7fff