[pgpool-general: 8591] Re: PGPool 4.3.3 hang when Postgres host stopped

Tatsuo Ishii ishii at sraoss.co.jp
Sat Feb 4 08:42:16 JST 2023


That's a system call trace, not stack trace.  I am not familiar with
Debian. So I don't know how to get a stack trace on Debian 11, but in
my Ubuntu case:

- Older Ubuntu:

Before starting enable coredump.
ulimit -c unlimited
start pgpool
got segfault
gdb pgpool core
bt

- Newer Ubuntu (probably 20 and after)
make sure to start apport (you can confirm by: systemctl status apport)
depending on how your installtion of pgpool, you should find core file
either /var/crash or /var/lib/apport/coredump
got segfault
gdb pgpool core
bt

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> Got it...attached.
> 
> 
> On Fri, Feb 3, 2023 at 9:18 AM Dave Sisk <dave.sisk at bullhorn.com> wrote:
> 
>> Hi Tatsuo,
>>
>> I'd be happy to provide a stack trace, if you would tell me how to do it
>> in Debian 11.
>>
>> Thanks for your reply!
>> Dave Sisk
>>
>> On Thu, Feb 2, 2023 at 5:36 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>
>>> > An update: I just realized I'm actually getting a seg fault from PGPool
>>> in
>>> > trying to troubleshoot this...image attached.
>>>
>>> Can you share the stack trace?
>>>
>>> Best reagards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS LLC
>>> English: http://www.sraoss.co.jp/index_en/
>>> <http://www.sraoss.co.jp/index_en>
>>> Japanese:http://www.sraoss.co.jp
>>> <http://www.sraoss.co.jp>
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>> <http://www.pgpool.net/mailman/listinfo/pgpool-general>
>>>
>>
>>
>> --
>>
>> *Dave Sisk*
>>
>> *Data Architect*
>>
>>
>> T:
>>
> 
> 
> -- 
> 
> *Dave Sisk*
> 
> *Data Architect*
> 
> 
> T:
> 
> -- 
> 
>  <https://www.linkedin.com/company/bullhorn> 
> <https://twitter.com/Bullhorn>
> 



More information about the pgpool-general mailing list