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

[Tatsuo Ishii]

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