[Pgpool-general] FW: Child process was terminated by segmentation fault

[Tatsuo Ishii]

Can you show me backtrace?

$ gdb pgpool core-file
(gdb)bt

I expect to get more usefull info because the core was generated by
your pgpool binary.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hello!
> 
> Could you please clarify what would be more useful info for further analysis? Thanks, 
> 
> silvio
> 
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
> Sent: 16. studeni 2011 2:03
> To: Silvio Svečnjak
> Cc: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] FW: Child process was terminated by segmentation fault
> 
> Silvio,
> 
> Thank you for sending cores. I got backtrace this:
> 
> gdb .libs/pgpool ~/core-pgpool-11-0-0-20473-1321347122 
> GNU gdb (GDB) 7.2
> 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-vine-linux".
> For bug reporting instructions, please see:
> <http://www.gnu.org/software/gdb/bugs/>...
> Reading symbols from /home/t-ishii/work/pgfoundry/pgpool-II-3.1/.libs/pgpool...done.
> 
> warning: exec file is newer than core file.
> [New Thread 20473]
> Reading symbols from /lib64/ld-linux-x86-64.so.2...done.
> Loaded symbols for /lib64/ld-linux-x86-64.so.2
> 
> warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fff50f70000
> Core was generated by `pgpool: vcms'.
> Program terminated with signal 11, Segmentation fault.
> #0  0x00000000004626ef in core_yylex_init (ptr_yy_globals=0x100) at scan.c:3444
> 3444	    memset(*ptr_yy_globals,0x00,sizeof(struct yyguts_t));
> (gdb) bt
> #0  0x00000000004626ef in core_yylex_init (ptr_yy_globals=0x100) at scan.c:3444
> #1  0x00000000000000b2 in ?? ()
> #2  0x0000000000000050 in ?? ()
> #3  0x000000001c1978b0 in ?? ()
> #4  0x0000000000000000 in ?? ()
> (gdb) 
> 
> It seems the backtrace does not show too much usefull info. I think
> this is because the stack frame was trashed badly by a overrun of
> memory copy. I'm looking into the problem anyway but it would be great
> if you or someone provide me more usefull info...
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
>> Thanks for your quick response. Dump/trace files are enclosed - I hope they contain the information you need - if not please let me know what else could help you.
>> Regards,
>> 
>> silvio
>> 
>> 
>> 
>> 
>> -----Original Message-----
>> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
>> Sent: 14. studeni 2011 16:05
>> To: Silvio Svečnjak
>> Cc: pgpool-general at pgfoundry.org
>> Subject: Re: [Pgpool-general] FW: Child process was terminated by segmentation fault
>> 
>>> We're using pgpool 3.1 with PostgreSQL 8.4.7 on RHEL 5.3 x64 where pgpool is configured for replication only on 2 backends. Pgpool is used by a real time java application which occasionally (without any visible pattern) catches an exception (org.postgresql.util.PSQLException: An I/O error occured while sending to the backend). 
>>> 
>>>  
>>> 
>>> We've determined that the exception is caused by pgpool as at the same time pgpool records the following error: 
>>> 
>>>  
>>> 
>>> 2011-11-14 14:14:45 ERROR: pid 10783: Child process 10812 was terminated by segmentation fault
>>> 
>>> 2011-11-14 14:14:45 DEBUG: pid 10783: child 10812 exits with status 11 by signal 11
>>> 
>>>  
>>> 
>>> Bigger chunk of  log file is enclosed as well as the pgpool configuration file.
>>> 
>>>  
>>> 
>>> After some research on the mailing lists, I found that some patches have been released for version 3.1 which may resolve the issue. So I downloaded and deployed the latest stable release pgpool2-V3_1_STABLE-8b47d55, but it didn't solve the problem. 
>>> 
>>>  
>>> 
>>> I would appreciate very much if someone could provide any help with this? Thank you in advance,
>> 
>> Can you take a core and show us the backtrace? It will be very helpfull.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp