[pgpool-hackers: 3668] Re: Issue while starting pgpool II head

[Ahsan Hadi]

Thanks Ishii-san...

I have added %a to log_line_prefix and also using the conf file for 4.2
(attached)

Ahsans-MacBook-Pro:bin ahsanhadi$ ./pgpool -f ~/pgpool.conf.sample_2 -n

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 2228224

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 1024

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 20

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 5264

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 4

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 6144

2020-06-22 21:38:17: pid 1471: process main:LOG:
health_check_stats_shared_memory_size: requested size: 12288

2020-06-22 21:38:17: pid 1471: process main:LOG:  creating shared memory
for request size: 12288

2020-06-22 21:38:17: pid 1471: process main:LOG:
health_check_stats_shared_memory_size: requested size: 12288

2020-06-22 21:38:17: pid 1471: process main:LOG:  Setting up socket for
:::9999

2020-06-22 21:38:17: pid 1471: process main:LOG:  Setting up socket for
0.0.0.0:9999

2020-06-22 21:38:17: pid 1471: process main:LOG:
find_primary_node_repeatedly: waiting for finding a primary node

2020-06-22 21:38:17: pid 1471: process main:LOG:  find_primary_node:
primary node is 0

2020-06-22 21:38:17: pid 1505: process main:LOG:  creating shared memory
for request size: 1

2020-06-22 21:38:17: pid 1505: process main:FATAL:  could not create shared
memory for request size: 1

2020-06-22 21:38:17: pid 1505: process main:DETAIL:  attach to shared
memory [id:917514] failed with reason: "Too many open files"

2020-06-22 21:38:17: pid 1471: process main:LOG:  pgpool-II successfully
started. version 4.2devel (chichiriboshi)

2020-06-22 21:38:17: pid 1471: process main:LOG:  node status[0]: 1

2020-06-22 21:38:17: pid 1471: process main:LOG:  PCP child process with
pid: 1505 exits with status 768

2020-06-22 21:38:17: pid 1471: process main:FATAL:  PCP child process exit
with fatal error. exiting pgpool-II

Ahsans-MacBook-Pro:bin ahsanhadi$


On Fri, Jun 19, 2020 at 10:50 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> It seems you are using pgpool.conf for Pgpool-II 4.1, rather than for
> master (4.2). I don't think this is directly related to the issue
> though.
>
> It might be helpful to add "%a" to the log_line_prefix to know what
> process spits the log:
>
> > 2020-06-19 09:42:33: pid 58219: FATAL:  could not create shared memory
> for
> > request size: 1
>
> > Hi pgpool hackers,
> >
> > I am trying to test the WIP ldap patch with pgpool II master branch
> > (essentially 4.2), I am running into an issue while trying to start
> pgpool.
> > I am not facing this issue with pgpool II 4.1 stable branch.
> >
> > I am attaching my sample pgpool configuration, the shared relcache is
> > disabled and i also reduced the number of num_jnit_childeren to 2 but
> still
> > no luck...
> >
> > Ahsans-MacBook-Pro:bin ahsanhadi$
> >
> > Ahsans-MacBook-Pro:bin ahsanhadi$ ./pgpool -f ~/pgpool.conf.sample -n
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 139264
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 64
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 20
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 5264
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 4
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 6144
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:
> > health_check_stats_shared_memory_size: requested size: 12288
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  creating shared memory for request
> > size: 12288
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:
> > health_check_stats_shared_memory_size: requested size: 12288
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  Setting up socket for :::9999
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  Setting up socket for 0.0.0.0:9999
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  find_primary_node_repeatedly:
> waiting
> > for finding a primary node
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  find_primary_node: primary node is
> 0
> >
> > 2020-06-19 09:42:33: pid 58219: LOG:  creating shared memory for request
> > size: 1
> >
> > 2020-06-19 09:42:33: pid 58219: FATAL:  could not create shared memory
> for
> > request size: 1
> >
> > 2020-06-19 09:42:33: pid 58219: DETAIL:  attach to shared memory
> > [id:589837] failed with reason: "Too many open files"
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  pgpool-II successfully started.
> > version 4.2devel (chichiriboshi)
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  node status[0]: 1
> >
> > 2020-06-19 09:42:33: pid 58215: LOG:  PCP child process with pid: 58219
> > exits with status 768
> >
> > 2020-06-19 09:42:33: pid 58215: FATAL:  PCP child process exit with fatal
> > error. exiting pgpool-II
> >
> > Ahsans-MacBook-Pro:bin ahsanhadi$ vim ~/pgpool.conf.sample
> >
> > Thanks,
> >
> > Ahsan
> > --
> > Highgo Software (Canada/China/Pakistan)
> > URL : http://www.highgo.ca
> > ADDR: 10318 WHALLEY BLVD, Surrey, BC
> > EMAIL: mailto: ahsan.hadi at highgo.ca
>


-- 
Highgo Software (Canada/China/Pakistan)
URL : http://www.highgo.ca
ADDR: 10318 WHALLEY BLVD, Surrey, BC
EMAIL: mailto: ahsan.hadi at highgo.ca
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200622/b592f5d2/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf.sample_2
Type: application/octet-stream
Size: 43591 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200622/b592f5d2/attachment-0001.obj>