>> No problem. However, I have already provided a stacktrace for this >> problem. >> >> Your response to it was: >> >>> Thanks for the backtrace. Unfortunately the binary did not have the >>> symbol table and did not give me usefull info. BTW while looking at >>> the code, I found a nasty bug with pgpool-II which may or may not >>> cause the bug. If user name is long(32 bytes), pgpool-II will crash. >>> If this is the case, attached will fix it. If this does not work, can >>> you please run pgpool with -d (debug)option which might give us >>> usefull information. >> >> Essentially, the binary doesn't have debug symbols. >> >> It seems the packager from where I installed the binaries doesn't >> provide source-RPMs, so it may be tricky for me to build a debug >> version. >> >> Do you happen to have a RedHat 5/Centos/Fedora debug binary that might >> work? > > Where did you get the rpm binary?
If the rpm came from http://yum.pgrpms.org/9.0/redhat/rhel-5-i386/ or http://yum.pgrpms.org/9.0/redhat/rhel-5-x86_64/ You could obtain debuginfo packages to get stack trace. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp >> Here's the linked libraries from my current builds: >> >>> libpq.so.5 => /usr/pgsql-9.0/lib/libpq.so.5 (0x00002b9339eb7000) >>> libpcp.so.0 => /usr/pgpool-9.0/lib/libpcp.so.0 (0x00002b933a0de000) >>> libpam.so.0 => /lib64/libpam.so.0 (0x00000038cbc00000) >>> libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00000038c8800000) >>> libresolv.so.2 => /lib64/libresolv.so.2 (0x00000038c9c00000) >>> libnsl.so.1 => /lib64/libnsl.so.1 (0x00000038c9400000) >>> libm.so.6 => /lib64/libm.so.6 (0x00000038c8000000) >>> libc.so.6 => /lib64/libc.so.6 (0x00000038c6c00000) >>> libssl.so.6 => /lib64/libssl.so.6 (0x000000371aa00000) >>> libcrypto.so.6 => /lib64/libcrypto.so.6 (0x00000038c9800000) >>> libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2 >>> (0x000000371a200000) >>> libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0 >>> (0x00002b933a2e8000) >>> libpthread.so.0 => /lib64/libpthread.so.0 (0x00000038c7800000) >>> libdl.so.2 => /lib64/libdl.so.2 (0x00000038c7000000) >>> libaudit.so.0 => /lib64/libaudit.so.0 (0x00000038c9000000) >>> /lib64/ld-linux-x86-64.so.2 (0x00000038c6800000) >>> libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x0000003719e00000) >>> libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00000038ca800000) >>> libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 (0x000000371a600000) >>> libz.so.1 => /usr/lib64/libz.so.1 (0x00000038c8400000) >>> libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0 >>> (0x0000003719a00000) >>> libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00000038cb000000) >>> liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0 (0x000000371b200000) >>> libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x00000038ca400000) >>> libselinux.so.1 => /lib64/libselinux.so.1 (0x0000003cff000000) >>> libsepol.so.1 => /lib64/libsepol.so.1 (0x0000003d00400000) >> >> If you have a binary for these platforms, I might be able to mess with >> LD_LIBRARY_PATH to get it to work? >> >> Any other suggestions for what I can do to help fix this problem will >> be gratefully received. >> >> >> Many thanks >> >> Rob >> >> >> >> >> >> >> >> >> >> Tatsuo Ishii wrote: >>>>> As it is a unique non-production password, you can have it - for use >>>>> with these files, and we'll reset it accordingly. >>>>> >>>>> username: zetasafe2dba >>>>> password: wewRuwR9c4 >>>>> >>>> Thanks. >>>> >>>> >>>>> By the way: Have you seen this blog post on the matter? >>>>> http://abdulyadi.wordpress.com/2010/09/25/pgpool-ii-3-0-bug-fixes/ >>>>> >>>> No. I'll looking into it. >>>> >>> >>> I have tries several times but I couldn't reproduce your problem. >>> I need you to take gdb stack trace... >>> -- >>> Tatsuo Ishii >>> SRA OSS, Inc. Japan >>> English: http://www.sraoss.co.jp/index_en.php >>> Japanese: http://www.sraoss.co.jp >>> >>> >>>>> Many thanks Tatsuo, please let me know how I can help. >>>>> >>>>> Rob >>>>> >>>>> >>>>> >>>>> Tatsuo Ishii wrote: >>>>> >>>>>> Sorry for delay. I couldn't identify the cause of problem nor >>>>>> reproduce your problem. If possible, could you provide me a set of >>>>>> test data: >>>>>> >>>>>> pgpool.conf >>>>>> pool_passwd >>>>>> >>>>>> which can reproduce your problem. >>>>>> -- >>>>>> Tatsuo Ishii >>>>>> SRA OSS, Inc. Japan >>>>>> English: http://www.sraoss.co.jp/index_en.php >>>>>> Japanese: http://www.sraoss.co.jp >>>>>> >>>>>> >>>>>>> Tatsuo, >>>>>>> >>>>>>> Thanks for your help. >>>>>>> >>>>>>> I have now got back on this project for a few days. >>>>>>> >>>>>>> Here is the -d debug output from a failed request. >>>>>>> >>>>>>> >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: Protocol Major: 1234 Minor: 5679 >>>>>>>> database: user: >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: SSLRequest from client >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: pool_ssl: SSL requested but SSL >>>>>>>> support is not available >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: Protocol Major: 3 Minor: 0 >>>>>>>> database: ZetaSafe2 user: zetasafe2dba >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: new_connection: connecting 0 >>>>>>>> backend >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: pool_ssl: SSL requested but SSL >>>>>>>> support is not available >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: pool_read_message_length: slot: 0 >>>>>>>> length: 12 >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: pool_do_auth: auth kind:5 >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: trying md5 authentication >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3468: DB node id: 0 salt: 1e4dada >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3467: reap_handler called >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3467: reap_handler: call wait3 >>>>>>>> 2010-12-02 18:24:05 ERROR: pid 3467: Child process 3468 was terminated >>>>>>>> by segmentation fault >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3467: child 3468 exits with status 11 >>>>>>>> by signal 11 >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3480: I am 3480 >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3467: fork a new child pid 3480 >>>>>>>> 2010-12-02 18:24:05 DEBUG: pid 3467: reap_handler: normally exited >>>>>>>> >>>>>>> Please let me know what I can do to help with this issue. >>>>>>> >>>>>>> Best regards >>>>>>> >>>>>>> Rob >>>>>>> >>>>>>> >>>>>>> Tatsuo Ishii wrote: >>>>>>> >>>>>>>> Thanks for the backtrace. Unfortunately the binary did not have the >>>>>>>> symbol table and did not give me usefull info. BTW while looking at >>>>>>>> the code, I found a nasty bug with pgpool-II which may or may not >>>>>>>> cause the bug. If user name is long(32 bytes), pgpool-II will crash. >>>>>>>> If this is the case, attached will fix it. If this does not work, can >>>>>>>> you please run pgpool with -d (debug)option which might give us >>>>>>>> usefull information. >>>>>>>> -- >>>>>>>> Tatsuo Ishii >>>>>>>> SRA OSS, Inc. Japan >>>>>>>> English: http://www.sraoss.co.jp/index_en.php >>>>>>>> Japanese: http://www.sraoss.co.jp >>>>>>>> >>>>>>>> >>>>>>>>> Tatsuo, >>>>>>>>> >>>>>>>>> Many thanks for these steps. >>>>>>>>> >>>>>>>>> I hope it means something to you. Please let me know if I can do >>>>>>>>> anything else. >>>>>>>>> >>>>>>>>> Best regards >>>>>>>>> >>>>>>>>> Rob >>>>>>>>> >>>>>>>> -- >>>>>>>> Tatsuo Ishii >>>>>>>> SRA OSS, Inc. Japan >>>>>>>> English: http://www.sraoss.co.jp/index_en.php >>>>>>>> Japanese: http://www.sraoss.co.jp >>>>>>>> >>>>>>> -- >>>>>>> Rob Shepherd BEng PhD - Director / Senior Engineer - DataCymru Ltd >>>>>>> Reg. England and Wales - 06731289 - TechniumCAST, LL57 4HJ >>>>>>> [email protected] - 08452575006 - 07596154845 - www.datacymru.net >>>>>>> >>>>>>> >>>>> -- >>>>> Rob Shepherd BEng PhD - Director / Senior Engineer - DataCymru Ltd >>>>> Reg. England and Wales - 06731289 - TechniumCAST, LL57 4HJ >>>>> [email protected] - 08452575006 - 07596154845 - www.datacymru.net >>>>> >>>>> >> >> >> -- >> Rob Shepherd BEng PhD - Director / Senior Engineer - DataCymru Ltd >> Reg. England and Wales - 06731289 - TechniumCAST, LL57 4HJ >> [email protected] - 08452575006 - 07596154845 - www.datacymru.net >> _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
