[Pgpool-general] pgpool segfaulting and dumping core

[Tatsuo Ishii]

> On Thu, Sep 22, 2011 at 5:18 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>> I checked a second of the coredumps, and it has the same backtrace.
>>> Let me know if you need anything else.  thanks!
>>
>> Thanks. Can you show me pgpool log when DNS failed and pgpool died in
>> segfaulting?

Ok. I think this is the cause of the problem:

> 2011-09-21 16:23:11 LOG:   pid 23588: find_primary_node:
> pgpool_walrecrunning does not exist

I think you did not install pgpool_walrecrunning() on DB node 2. In
this case find_primary_node() returns -1 and it is stored in 

Req_info->primary_node_id = find_primary_node();

It is used as the parameter for TSTAE macro, which actually accesses
out of array because of -1.

1250			state = TSTATE(backend,

So the solution would be installing pgpool_walrecrunning() on DB node 2.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp