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

[Tatsuo Ishii]

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

The process trying to get the 1 byte shared memory is pcp child. I
suspect your OS does not allow to allocate 1 byte shared memory,
because it's too small. What kind of OS are you using?

> 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