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

[Lonni J Friedman]

On Wed, Oct 24, 2012 at 9:09 AM, Wolf Schwurack <wolf at uen.org> wrote:
> You have to set a sticky bit on the file that is in the error.  Are you running in Unix environment?
>
> # chmod 1755 filename

Actually the official dox specify 4755 rather than 1755.

>
>  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,
>>>>