[pgpool-general: 1118] Re: Configuring pgsql nodes

[Wolf Schwurack]

You have to set a sticky bit on the file that is in the error.  Are you running in Unix environment?

# chmod 1755 filename 

 As for Lonni comment seems like a bug. 

It's not I have it running without any errors. When I first set this up I would start in debug mode and would just fix any errors

Wolf


-----Original Message-----
From: martin.formanko at gmail.com [mailto:martin.formanko at gmail.com] On Behalf Of Mino Haluz
Sent: Wednesday, October 24, 2012 9:49 AM
To: Lonni J Friedman
Cc: Wolf Schwurack; pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 1111] Re: Configuring pgsql nodes

Ok ... I get another strange behavior. When the first pgpool boots up

2012-10-24 17:45:12 DEBUG: pid 3756: value: 0 kind: 2
2012-10-24 17:45:12 LOG:   pid 3756: wd_chk_sticky:
ifup[/sbin/ifconfig] doesn't have sticky bit
2012-10-24 17:45:15 LOG:   pid 3756: wd_escalation: escalated to master pgpool

it keeps on sending tons of strange packets and it nearly killed my router:

17:45:16.293836 Out 00:50:56:a2:00:6b ethertype Unknown (0x0003), length 58:
	0x0000:  ffff ffff ffff 0050 56a2 006b 0806 0001  .......PV..k....
	0x0010:  0800 0604 0001 0050 56a2 006b 0808 0822  .......PV..k..."
	0x0020:  0000 0000 0000 0808 0808

Could you please tell me, what are these packets?

On Wed, Oct 24, 2012 at 5:20 PM, Lonni J Friedman <netllama at gmail.com> wrote:
> If you try to start pgpool a 2nd time, does it come up?  If so, I've 
> seen this behavior as well.  Its annoying, and seems like a bug.
>
> On Wed, Oct 24, 2012 at 8:18 AM, Mino Haluz <mino.haluz at gmail.com> wrote:
>> Thanks for info. I configured two nodes and pgpools and the first 
>> pgpool boots up ok but second one cannot start because the first one 
>> creates the virtual IP address already:
>>
>> wd_init: delegate_IP already exists
>> 2012-10-24 17:12:08 ERROR: pid 665: watchdog: wd_init failed
>> 2012-10-24 17:12:08 ERROR: pid 665: wd_main error
>> 2012-10-24 17:12:08 ERROR: pid 665: unlink(/tmp/.s.PGSQL.9898) failed:
>> No such file or directory
>> 2012-10-24 17:12:08 DEBUG: pid 665: shmem_exit(1)
>>
>> Am I missing something or I just did not understand it well ? :) Thanks.
>>
>> On Wed, Oct 24, 2012 at 3:30 PM, Wolf Schwurack <wolf at uen.org> wrote:
>>> Take a look at this doc
>>>
>>> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/
>>> en.html
>>>
>>> Wolf
>>>
>>>
>>> -----Original Message-----
>>> From: pgpool-general-bounces at pgpool.net 
>>> [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Mino Haluz
>>> Sent: Wednesday, October 24, 2012 6:00 AM
>>> To: pgpool-general at pgpool.net
>>> Subject: [pgpool-general: 1106] Configuring pgsql nodes
>>>
>>> Hi,
>>>
>>> I want to test bit the replication mode of pgool-II, I configured 
>>> the pgpool.conf but is there any manual how should I configure pgsql nodes so they could connect to the pgpool host ? Thank you,
>>>