[pgpool-hackers: 3658] Issue while starting pgpool II head

Ahsan Hadi ahsan.hadi at gmail.com
Fri Jun 19 14:17:30 JST 2020


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200619/2d9b95cb/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf.sample
Type: application/octet-stream
Size: 43523 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200619/2d9b95cb/attachment-0001.obj>


More information about the pgpool-hackers mailing list