[pgpool-general: 2551] Re: pid not found

[Gintautas Sulskus]

Thank you.
Seems that I all my problems are related to tmp folders being cleared after
every reboot. SOme of them, like postgres locks are recreated with old
permissions.

Will have to write a script to solve this. To my surprise, pgpool install
does not take care of this. At least not in 10.04.

Thanks again.
Gintas


On Thu, Feb 6, 2014 at 4:56 PM, Lachezar Dobrev <l.dobrev at gmail.com> wrote:

>   Are you using a Debian or derivative?
>   Under Debian /var/run is sym-linked to /run, which is a mounted
> temporary in-memory file system, that does not survive between
> reboots. Typically such /var/run/whatever stuff is handled by an
> /etc/init.d/whatever script that is used to manage the service.
>
>   What I can suggest as an UGLY work-around is to use /tmp/pgpool/
> instead of /var/run/pgpool.
>
> 2014-02-06 16:45 GMT+02:00 Gintautas Sulskus <gingaz at gmail.com>:
> > Well, permissions seem to be fine. This occurs after the first
> > post-installation reboot.
> > The only action I perform are:
> > 1. install & cofing pgool according the tutorial
> > 2. install and condig pgpoolAdmin according the tutorial
> > 3. set load balancing & replication mode in pgpoolAdmin
> > 4. shut down one node to see how pgpool(Admin) behaves
> > 5. "sudo reboot"
> > 6. kaput :)
> >
> >
> > Gintas
> >
> >
> > On Thu, Feb 6, 2014 at 12:06 PM, Gintautas Sulskus <gingaz at gmail.com>
> wrote:
> >>
> >> after reboot I perform:
> >> sudo mkdir /var/run/pgpool (pgpool dir is deleted after every "sudo
> >> reboot")
> >> sudo chmod 777 /var/run/pgpool/ -R
> >> sudo chown www-data /var/run/pgpool/ -R
> >>
> >> Then pgpool complains about missing pgpool.pid.
> >> I think this is not a correct thing to do but I create pid file:
> >> sudo touch /var/run/pgpool/pgpool.pid
> >> sudo chmod 777 /var/run/pgpool/ -R
> >> sudo chown www-data /var/run/pgpool/ -R
> >>
> >> Then it throws "pcp_stop_pgpool command error occurred." error and stops
> >> reacting to any command.
> >>
> >> I will take a look at relevant permissions. All this started after
> reboot.
> >>
> >> Gintas
> >>
> >>
> >> On Thu, Feb 6, 2014 at 9:50 AM, Yugo Nagata <nagata at sraoss.co.jp>
> wrote:
> >>>
> >>> On Thu, 6 Feb 2014 09:33:42 +0000
> >>> Gintautas Sulskus <gingaz at gmail.com> wrote:
> >>>
> >>> > Thanks, Yugo.
> >>> >
> >>> > However, now I keep getting  "pgpool start failed. pgpool.pid not
> >>> > found" when
> >>> > i try to launch pgpool from pgpoolAdmin.
> >>> > Any ideas?
> >>>
> >>> Is pid_file_name's value 'var/run/pgpool/pgpool.pid'?
> >>>
> >>> >
> >>> > pgpool is not running.
> >>> >
> >>> > Regards,
> >>> > Gintas
> >>> >
> >>> >
> >>> > On Thu, Feb 6, 2014 at 8:25 AM, Yugo Nagata <nagata at sraoss.co.jp>
> >>> > wrote:
> >>> >
> >>> > > Hi,
> >>> > >
> >>> > > On Thu, 6 Feb 2014 07:41:22 +0000
> >>> > > Gintautas Sulskus <gingaz at gmail.com> wrote:
> >>> > >
> >>> > > > Hello,
> >>> > > >
> >>> > > > whenever I reboot my machine /var/run.pgpool dir gets removed and
> >>> > > > is not
> >>> > > > recreated on startup.
> >>> > > > If I create it manually and perform chmod 755 pgpoolAdmin
> >>> > > > complains:
> >>> > > >
> >>> > > > pgpool start failed. pgpool.pid not found
> >>> > > >
> >>> > > > 2014-02-06 07:33:31 ERROR: pid 1473: could not open pid file as
> >>> > > > /var/run/pgpool/pgpool.pid. reason: Permission denied
> >>> > >
> >>> > > If you use pgpoolAdmin, apache user should have permission to write
> >>> > > to /var/run/pgpool directory.Try
> >>> > >
> >>> > >  $ chomod 777 /var/run/pgpool
> >>> > >
> >>> > > or
> >>> > >
> >>> > >  $ chown apache /var/run/pgpool
> >>> > >
> >>> > > >
> >>> > > > Do you know what is the cause and what is the best way to solve
> it?
> >>> > > >
> >>> > > > I'm running Ubuntu 10.04.4 LTS 64 bit.
> >>> > > >
> >>> > > > Best Regards,
> >>> > > > Gintas
> >>> > >
> >>> > >
> >>> > > --
> >>> > > Yugo Nagata <nagata at sraoss.co.jp>
> >>> > >
> >>> >
> >>> >
> >>> >
> >>> > --
> >>> > Best Regards,
> >>> > Gintautas Sulskus
> >>>
> >>>
> >>> --
> >>> Yugo Nagata <nagata at sraoss.co.jp>
> >>
> >>
> >>
> >>
> >> --
> >> Best Regards,
> >> Gintautas Sulskus
> >
> >
> >
> >
> > --
> > Best Regards,
> > Gintautas Sulskus
> >
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> >
>



-- 
Best Regards,
Gintautas Sulskus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140210/1f11ef33/attachment.html>