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

[Yutaka Tanida]

Hi James,

The error message as below shows that you failed to run pgpool.  

Oct  9 10:31:30 pgpool1 pengine: [1931]: WARN: unpack_rsc_op: Processing failed op resource_pgpool-II_service_start_0 on pgpool2: Error

We need to investigate why it can't start. 

- configuration files in /etc.
- "postgres" user.

Or could you please show me /var/log/pgpool.log? You can also paste
heartbeat log without "logfile" configuration on cib.xml. 



Kind Regards,  Yutaka Tanida.


> 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
> >>
> >>   
> > 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general

-- 
Yutaka Tanida <y.tanida at sra-europe.com>