[Pgpool-general] pgpool HA stuff kind of broken with heartbeat-2.1.3

[James Martin]

Yutaka,

This is the file I created through the hb_gui, trying to mimic what's 
included in the pgpool-ha package:   http://pastebin.com/m41a84c1a

Here's the output of my log as I attempt to start the pgpool_II resource 
group:  http://pastebin.com/m6d94ac62


When attempting to use the cib.xml as supplied in the pgpool-ha package 
(of course I've modified it to my systems) : http://pastebin.com/m769121b


Heartbeat starts rebooting my systems over and over again with a message 
like:


pgpool1 heartbeat: [1608]: EMERG: Rebooting system.  Reason: 
/usr/lib64/heartbeat/crmd



Thanks so much,

James

y.tanida wrote:
> Hi James,
> 
> I think pgpool-HA still runs with the latest version of heartbeat. My 
> friend sent a report to me 2 months ago.
> Can I have a look into your cib.xml and error log?
> 
> However, /etc/ha.d/resource.d is not correct place to put OCF script, as 
> you  found out. It is the place for LSB script.
> LSB do not support health check.
> 
> 
> Kind Regards, Yutaka Tanida.
>> I know the pgpool-ha stuff doesn't appear to have been maintained for 
>> awhile, but I'm running into all sorts of problems.
>>
>>
>> Firstly, the cib.xml file referenced in the documentation doesn't work 
>> with current versions of heartbeat.  It spits out all sorts of xml 
>> errors.
>>
>> Also, in trying to use the hb_gui to create my own cluster and 
>> referencing the pgpool ocf in /etc/ha.d/resource.d/pgpool_2, the 
>> service never starts correctly.
>>
>> The only way I'm able to use it with heartbeat is to configure 
>> heartbeat to use the standard lsb pgpool script.  Everything fails 
>> over fine with that, but I don't get the health checking that the 
>> pgpool-ha is supposed to provide.
>>
>> I'm using heartbeat-2.1.3.  I wouldn't mind looking at the ocf 
>> provided in the pgpool-ha and attempt to fix it, I'm just wondering if 
>> there's anything else I can do.
>>
>>
>> Thanks,
>>
>>
>> James
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>>   
>