[Pgpool-general] Segfault when using MD5 auth

Tatsuo Ishii ishii at sraoss.co.jp
Tue Dec 14 00:45:39 UTC 2010 

>> 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
>>>>>>> rs at datacymru.net - 08452575006 - 07596154845 - www.datacymru.net
>>>>>>>
>>>>>>>               
>>>>> -- 
>>>>> Rob Shepherd BEng PhD - Director / Senior Engineer - DataCymru Ltd
>>>>> Reg. England and Wales - 06731289 - TechniumCAST, LL57 4HJ
>>>>> rs at datacymru.net - 08452575006 - 07596154845 - www.datacymru.net
>>>>>
>>>>>       
>> 
>> 
>> -- 
>> Rob Shepherd BEng PhD - Director / Senior Engineer - DataCymru Ltd
>> Reg. England and Wales - 06731289 - TechniumCAST, LL57 4HJ
>> rs at datacymru.net - 08452575006 - 07596154845 - www.datacymru.net
>>

More information about the Pgpool-general mailing list