Re: [Pgpool-general] seemingly hung pgpool process consuming 100% CPU
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 http://gnu.org/licenses/gpl.html 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: http://www.gnu.org/software/gdb/bugs/... 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 0x7fff0663dfe6
Re: [Pgpool-general] Is pgpool_walrecrunning needed in Master/Slave mode?
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 is...@sraoss.co.jp 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
