<div dir="ltr"><div><div>The log for
2023-07-07 is empty.<br></div>I have created user checker:<br><span style="color:rgb(0,0,255)">create user checker with password 'check123';<br>grant all on database "template1" to checker;</span><br><br></div><div>I have already granted trust to them, so this time it does not ask me password on postgresql:<br><span style="color:rgb(0,0,255)"># psql -h 172.17.0.2 -p 5432 -U checker template1</span><br></div><div>but the inquiry to pgpool failed again like before:<br><span style="color:rgb(0,0,255)"># psql -h 172.17.0.2 -p 9999 -U checker template1<br>psql: error: server closed the connection unexpectedly<br> This probably means the server terminated abnormally<br> before or while processing the request.</span><br></div><div>Log of postgres:<br><span style="color:rgb(0,0,255)">2023-07-12 16:09:59.586 CST [8680] LOG: received fast shutdown request<br>2023-07-12 16:09:59.587 CST [8680] LOG: aborting any active transactions<br>2023-07-12 16:09:59.592 CST [8680] LOG: background worker "logical replication launcher" (PID 8689) exited with exit code 1<br>2023-07-12 16:09:59.593 CST [8683] LOG: shutting down<br>2023-07-12 16:09:59.633 CST [8680] LOG: database system is shut down<br>2023-07-12 16:15:30.173 CST [48844] LOG: starting PostgreSQL 13.10 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 11.3.1 20221121 (Red Hat 11.3.1-4), 64-bit<br>2023-07-12 16:15:30.173 CST [48844] LOG: listening on IPv4 address "0.0.0.0", port 5432<br>2023-07-12 16:15:30.173 CST [48844] LOG: listening on IPv6 address "::", port 5432<br>2023-07-12 16:15:30.175 CST [48844] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"<br>2023-07-12 16:15:30.177 CST [48844] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"<br>2023-07-12 16:15:30.182 CST [48846] LOG: database system was shut down at 2023-07-12 16:09:59 CST<br>2023-07-12 16:15:30.188 CST [48844] LOG: database system is ready to accept connections</span><br></div><div>Log of pgpool:<br><span style="color:rgb(0,0,255)">2023-07-12 16:15:42.369: main pid 48855: LOG: health_check_stats_shared_memory_size: requested size: 12288<br>2023-07-12 16:15:42.369: main pid 48855: LOG: memory cache initialized<br>2023-07-12 16:15:42.369: main pid 48855: DETAIL: memcache blocks :64<br>2023-07-12 16:15:42.369: main pid 48855: LOG: allocating (136981824) bytes of shared memory segment<br>2023-07-12 16:15:42.369: main pid 48855: LOG: allocating shared memory segment of size: 136981824<br>2023-07-12 16:15:42.453: main pid 48855: LOG: health_check_stats_shared_memory_size: requested size: 12288<br>2023-07-12 16:15:42.453: main pid 48855: LOG: health_check_stats_shared_memory_size: requested size: 12288<br>2023-07-12 16:15:42.453: main pid 48855: LOG: memory cache initialized<br>2023-07-12 16:15:42.453: main pid 48855: DETAIL: memcache blocks :64<br>2023-07-12 16:15:42.458: main pid 48855: LOG: pool_discard_oid_maps: discarded memqcache oid maps<br>2023-07-12 16:15:42.472: main pid 48855: LOG: unix_socket_directories[0]: /run/.s.PGSQL.9999<br>2023-07-12 16:15:42.472: main pid 48855: LOG: listen address[0]: *<br>2023-07-12 16:15:42.472: main pid 48855: LOG: Setting up socket for <a href="http://0.0.0.0:9999">0.0.0.0:9999</a><br>2023-07-12 16:15:42.472: main pid 48855: LOG: Setting up socket for :::9999<br>2023-07-12 16:15:42.486: main pid 48855: LOG: listen address[0]: localhost<br>2023-07-12 16:15:42.487: main pid 48855: LOG: Setting up socket for ::1:9898<br>2023-07-12 16:15:42.487: main pid 48855: LOG: Setting up socket for <a href="http://127.0.0.1:9898">127.0.0.1:9898</a><br>2023-07-12 16:15:42.488: sr_check_worker pid 48893: LOG: process started<br>2023-07-12 16:15:42.488: pcp_main pid 48892: LOG: PCP process: 48892 started<br>2023-07-12 16:15:42.489: main pid 48855: LOG: pgpool-II successfully started. version 4.4.3 (nurikoboshi)<br>2023-07-12 16:16:58.780: child pid 48874: FATAL: pgpool is not accepting any new connections<br>2023-07-12 16:16:58.780: child pid 48874: DETAIL: all backend nodes are down, pgpool requires at least one valid node<br>2023-07-12 16:16:58.780: child pid 48874: HINT: repair the backend nodes and restart pgpool<br>2023-07-12 16:16:58.782: main pid 48855: LOG: reaper handler<br>2023-07-12 16:16:58.782: main pid 48855: LOG: reaper handler: exiting normally</span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 11, 2023 at 4:41 PM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: DEBUG: forwarding error message to frontend<br>
<br>
Could you check the PostgreSQL log for "2023-07-07 14:59:12.379"?<br>
<br>
If it is possible, could you try to set "host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> trust" in pg_hba.conf<br>
and restart pgpool and postgresql?<br>
<br>
Could you show the command and result when you connect to pgpool?<br>
<br>
On Tue, 11 Jul 2023 14:26:58 +0800<br>
Zhaoxun Yan <<a href="mailto:yan.zhaoxun@gmail.com" target="_blank">yan.zhaoxun@gmail.com</a>> wrote:<br>
<br>
> This is pg_hba.conf:<br>
> # TYPE DATABASE USER ADDRESS METHOD<br>
> <br>
> # "local" is for Unix domain socket connections only<br>
> local all all peer<br>
> # IPv4 local connections:<br>
> #host all all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> ident<br>
> # IPv6 local connections:<br>
> #host all all ::1/128 ident<br>
> # Allow replication connections from localhost, by a user with the<br>
> # replication privilege.<br>
> local replication all peer<br>
> #host replication all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> ident<br>
> #host replication all ::1/128 ident<br>
> host replication all <a href="http://172.17.0.0/16" rel="noreferrer" target="_blank">172.17.0.0/16</a> trust<br>
> #host template1 checker <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> trust<br>
> host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
> <br>
> And attached is the postgresql log for 2023-7-15<br>
> <br>
> On Mon, Jul 10, 2023 at 5:44 PM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> wrote:<br>
> <br>
> > Hi,<br>
> ><br>
> > > I changed the configuration to process_management_mode =static,<br>
> > > and everything related to it as commented, but the mal-function persists.<br>
> > > Here is the log in debug mode:<br>
> ><br>
> > > 2023-07-07 14:59:12.379: child pid 20684: DEBUG: forwarding error<br>
> > message<br>
> > > to frontend<br>
> ><br>
> > It seems PostgreSQL returns an error.<br>
> ><br>
> > I think it may be caused by authentication failure.<br>
> > Could you check the PostgreSQL log if any error occurs?<br>
> ><br>
> > On Fri, 7 Jul 2023 15:03:46 +0800<br>
> > Zhaoxun Yan <<a href="mailto:yan.zhaoxun@gmail.com" target="_blank">yan.zhaoxun@gmail.com</a>> wrote:<br>
> ><br>
> > > Hi Bo!<br>
> > ><br>
> > > I changed the configuration to process_management_mode =static,<br>
> > > and everything related to it as commented, but the mal-function persists.<br>
> > > Here is the log in debug mode:<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: BackendDesc: 113672<br>
> > bytes<br>
> > > requested for shared memo<br>
> > > ry<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: pool_coninfo_size:<br>
> > > num_init_children (32) * max_poo<br>
> > > l (4) * MAX_NUM_BACKENDS (128) * sizeof(ConnectionInfo) (160) = 2621440<br>
> > > bytes requested for shared m<br>
> > > emory<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: ProcessInfo:<br>
> > > num_init_children (32) * sizeof(Proces<br>
> > > sInfo) (48) = 1536 bytes requested for shared memory<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: UserSignalSlot: 24 bytes<br>
> > > requested for shared memor<br>
> > > y<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: POOL_REQUEST_INFO: 5272<br>
> > > bytes requested for shared<br>
> > > memory<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: stat_shared_memory_size:<br>
> > > 9216 bytes requested for s<br>
> > > hared memory<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: LOG:<br>
> > > health_check_stats_shared_memory_size: requested size<br>
> > > : 12288<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: SI_ManageInfo: 24 bytes<br>
> > > requested for shared memory<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: LOG: memory cache initialized<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DETAIL: memcache blocks :64<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG:<br>
> > shared_memory_cache_size:<br>
> > > 67108864<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG:<br>
> > shared_memory_fsmm_size: 64<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: pool_hash_size: 67108880<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: DEBUG: POOL_QUERY_CACHE_STATS:<br>
> > 24<br>
> > > bytes requested for shared memory<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: LOG: allocating (136981824)<br>
> > bytes<br>
> > > of shared memory segment<br>
> > > 2023-07-07 14:58:48.964: main pid 20671: LOG: allocating shared memory<br>
> > > segment of size: 136981824<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: DEBUG: pool_coninfo_size:<br>
> > > num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *<br>
> > > sizeof(ConnectionInfo) (160) = 2621440 bytes requested for shared memory<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: LOG:<br>
> > > health_check_stats_shared_memory_size: requested size: 12288<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: LOG:<br>
> > > health_check_stats_shared_memory_size: requested size: 12288<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: LOG: memory cache initialized<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: DETAIL: memcache blocks :64<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: DEBUG:<br>
> > shared_memory_cache_size:<br>
> > > 67108864<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: DEBUG: memory cache request<br>
> > size<br>
> > > : 67108864<br>
> > > 2023-07-07 14:58:49.041: main pid 20671: DEBUG:<br>
> > shared_memory_fsmm_size: 64<br>
> > > 2023-07-07 14:58:49.044: main pid 20671: LOG: pool_discard_oid_maps:<br>
> > > discarded memqcache oid maps<br>
> > > 2023-07-07 14:58:49.058: main pid 20671: LOG:<br>
> > unix_socket_directories[0]:<br>
> > > /run/.s.PGSQL.9999<br>
> > > 2023-07-07 14:58:49.059: main pid 20671: LOG: listen address[0]: *<br>
> > > 2023-07-07 14:58:49.059: main pid 20671: LOG: Setting up socket for<br>
> > > <a href="http://0.0.0.0:9999" rel="noreferrer" target="_blank">0.0.0.0:9999</a><br>
> > > 2023-07-07 14:58:49.059: main pid 20671: LOG: Setting up socket for<br>
> > :::9999<br>
> > > 2023-07-07 14:58:49.061: child pid 20680: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.061: child pid 20679: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.061: child pid 20678: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.061: child pid 20681: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.062: child pid 20677: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.062: child pid 20682: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.062: child pid 20683: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.062: child pid 20676: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.064: child pid 20684: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.064: child pid 20685: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.064: child pid 20686: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.064: child pid 20675: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.067: child pid 20697: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.067: child pid 20698: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.067: child pid 20699: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.067: child pid 20700: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.068: child pid 20674: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.069: main pid 20671: DEBUG:<br>
> > > find_primary_node_repeatedly: not in streaming replication mode<br>
> > > 2023-07-07 14:58:49.069: main pid 20671: LOG: listen address[0]:<br>
> > localhost<br>
> > > 2023-07-07 14:58:49.069: main pid 20671: LOG: Setting up socket for<br>
> > > ::1:9898<br>
> > > 2023-07-07 14:58:49.069: main pid 20671: LOG: Setting up socket for<br>
> > > <a href="http://127.0.0.1:9898" rel="noreferrer" target="_blank">127.0.0.1:9898</a><br>
> > > 2023-07-07 14:58:49.069: child pid 20701: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.070: child pid 20705: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.070: child pid 20704: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.070: sr_check_worker pid 20707: LOG: process started<br>
> > > 2023-07-07 14:58:49.070: pcp_main pid 20706: DEBUG: I am PCP child with<br>
> > > pid:20706<br>
> > > 2023-07-07 14:58:49.070: sr_check_worker pid 20707: DEBUG: I am 20707<br>
> > > 2023-07-07 14:58:49.070: main pid 20671: LOG: pgpool-II successfully<br>
> > > started. version 4.4.3 (nurikoboshi)<br>
> > > 2023-07-07 14:58:49.070: child pid 20703: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:58:49.070: pcp_main pid 20706: LOG: PCP process: 20706<br>
> > > started<br>
> > > 2023-07-07 14:58:49.071: child pid 20702: DEBUG: initializing backend<br>
> > > status<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: DEBUG: reading startup packet<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: DETAIL: Protocol Major: 1234<br>
> > > Minor: 5679 database: user:<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: DEBUG: forwarding error<br>
> > message<br>
> > > to frontend<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: FATAL: pgpool is not accepting<br>
> > > any new connections<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: DETAIL: all backend nodes are<br>
> > > down, pgpool requires at least one valid node<br>
> > > 2023-07-07 14:59:12.379: child pid 20684: HINT: repair the backend nodes<br>
> > > and restart pgpool<br>
> > > 2023-07-07 14:59:12.380: main pid 20671: LOG: reaper handler<br>
> > > 2023-07-07 14:59:12.380: main pid 20671: DEBUG: child process with pid:<br>
> > > 20684 exits with status 256<br>
> > > 2023-07-07 14:59:12.380: main pid 20671: DEBUG: fork a new child process<br>
> > > with pid: 20711<br>
> > > 2023-07-07 14:59:12.380: main pid 20671: LOG: reaper handler: exiting<br>
> > > normally<br>
> > > 2023-07-07 14:59:12.380: child pid 20711: DEBUG: initializing backend<br>
> > > status<br>
> > ><br>
> > > And attached is the new configuration.<br>
> > ><br>
> > > On Wed, Jul 5, 2023 at 3:58 PM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> wrote:<br>
> > ><br>
> > > > Hi,<br>
> > > ><br>
> > > > Thank you for sharing the configuration file.<br>
> > > ><br>
> > > > You are using "dynamic process management mode".<br>
> > > > It seems if max_spare_children is greater than num_init_children,<br>
> > > > segment fault occurs.<br>
> > > ><br>
> > > > I think it is a bug of pgpool.<br>
> > > > I will share your report with the developer who is in charge of dynamic<br>
> > > > process management mode.<br>
> > > ><br>
> > > > On Wed, 5 Jul 2023 13:39:51 +0800<br>
> > > > Zhaoxun Yan <<a href="mailto:yan.zhaoxun@gmail.com" target="_blank">yan.zhaoxun@gmail.com</a>> wrote:<br>
> > > ><br>
> > > > > On Wed, Jul 5, 2023 at 1:00 PM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> wrote:<br>
> > > > ><br>
> > > > > > Hi,<br>
> > > > > ><br>
> > > > > > I tested 4.4.3 and it should not happen normally.<br>
> > > > > > Could you share your pgpool.conf?<br>
> > > > > ><br>
> > > > > > On Wed, 5 Jul 2023 12:03:29 +0800<br>
> > > > > > Zhaoxun Yan <<a href="mailto:yan.zhaoxun@gmail.com" target="_blank">yan.zhaoxun@gmail.com</a>> wrote:<br>
> > > > > ><br>
> > > > > > > Hi guys!<br>
> > > > > > ><br>
> > > > > > > Is it a bug? I started local postgres as backend_hostname0 =<br>
> > > > > > '172.17.0.2'<br>
> > > > > > > And it is visitable:<br>
> > > > > > > # psql -h 172.17.0.2 -p 5432 -U checker template1<br>
> > > > > > > Password for user checker:<br>
> > > > > > > psql (13.10)<br>
> > > > > > > Type "help" for help.<br>
> > > > > > ><br>
> > > > > > > template1=> \q<br>
> > > > > > ><br>
> > > > > > > Although pgpool is listening on 9999:<br>
> > > > > > > # ss -tlnp<br>
> > > > > > > State Recv-Q Send-Q Local Address:Port<br>
> > > > > > > Peer Address:Port Process<br>
> > > > > > > LISTEN 0 244 <a href="http://0.0.0.0:5432" rel="noreferrer" target="_blank">0.0.0.0:5432</a><br>
> > > > > > > 0.0.0.0:* users:(("postgres",pid=8680,fd=6))<br>
> > > > > > > LISTEN 0 64 <a href="http://127.0.0.1:9898" rel="noreferrer" target="_blank">127.0.0.1:9898</a><br>
> > > > > > > 0.0.0.0:*<br>
> > > > > > ><br>
> > > > > ><br>
> > > ><br>
> > users:(("pgpool",pid=8780,fd=11),("pgpool",pid=8773,fd=11),("pgpool",pid=8720,fd=11))<br>
> > > > > > > LISTEN 0 64 <a href="http://0.0.0.0:9999" rel="noreferrer" target="_blank">0.0.0.0:9999</a><br>
> > > > > > > 0.0.0.0:*<br>
> > > > > > ><br>
> > > > > ><br>
> > > ><br>
> > users:(("pgpool",pid=8780,fd=5),("pgpool",pid=8773,fd=5),("pgpool",pid=8754,fd=5),("pgpool",pid=8753,fd=5),("pgpool",pid=8752,fd=5),("pgpool",pid=8751,fd=5),("pgpool",pid=8750,fd=5),("pgpool",pid=8749,fd=5),("pgpool",pid=8748,fd=5),("pgpool",pid=8747,fd=5),("pgpool",pid=8746,fd=5),("pgpool",pid=8745,fd=5),("pgpool",pid=8744,fd=5),("pgpool",pid=8742,fd=5),("pgpool",pid=8741,fd=5),("pgpool",pid=8740,fd=5),("pgpool",pid=8739,fd=5),("pgpool",pid=8738,fd=5),("pgpool",pid=8737,fd=5),("pgpool",pid=8736,fd=5),("pgpool",pid=8735,fd=5),("pgpool",pid=8734,fd=5),("pgpool",pid=8733,fd=5),("pgpool",pid=8732,fd=5),("pgpool",pid=8731,fd=5),("pgpool",pid=8730,fd=5),("pgpool",pid=8729,fd=5),("pgpool",pid=8728,fd=5),("pgpool",pid=8727,fd=5),("pgpool",pid=8726,fd=5),("pgpool",pid=8724,fd=5),("pgpool",pid=8723,fd=5),("pgpool",pid=8720,fd=5))<br>
> > > > > > > LISTEN 0 128 <a href="http://0.0.0.0:22" rel="noreferrer" target="_blank">0.0.0.0:22</a><br>
> > > > > > > 0.0.0.0:* users:(("sshd",pid=1395,fd=3))<br>
> > > > > > > LISTEN 0 244 [::]:5432<br>
> > > > > > > [::]:* users:(("postgres",pid=8680,fd=7))<br>
> > > > > > > LISTEN 0 64 [::1]:9898<br>
> > > > > > > [::]:*<br>
> > > > > > ><br>
> > > > > ><br>
> > > ><br>
> > users:(("pgpool",pid=8780,fd=10),("pgpool",pid=8773,fd=10),("pgpool",pid=8720,fd=10))<br>
> > > > > > > LISTEN 0 64 [::]:9999<br>
> > > > > > > [::]:*<br>
> > > > > > ><br>
> > > > > ><br>
> > > ><br>
> > users:(("pgpool",pid=8780,fd=6),("pgpool",pid=8773,fd=6),("pgpool",pid=8754,fd=6),("pgpool",pid=8753,fd=6),("pgpool",pid=8752,fd=6),("pgpool",pid=8751,fd=6),("pgpool",pid=8750,fd=6),("pgpool",pid=8749,fd=6),("pgpool",pid=8748,fd=6),("pgpool",pid=8747,fd=6),("pgpool",pid=8746,fd=6),("pgpool",pid=8745,fd=6),("pgpool",pid=8744,fd=6),("pgpool",pid=8742,fd=6),("pgpool",pid=8741,fd=6),("pgpool",pid=8740,fd=6),("pgpool",pid=8739,fd=6),("pgpool",pid=8738,fd=6),("pgpool",pid=8737,fd=6),("pgpool",pid=8736,fd=6),("pgpool",pid=8735,fd=6),("pgpool",pid=8734,fd=6),("pgpool",pid=8733,fd=6),("pgpool",pid=8732,fd=6),("pgpool",pid=8731,fd=6),("pgpool",pid=8730,fd=6),("pgpool",pid=8729,fd=6),("pgpool",pid=8728,fd=6),("pgpool",pid=8727,fd=6),("pgpool",pid=8726,fd=6),("pgpool",pid=8724,fd=6),("pgpool",pid=8723,fd=6),("pgpool",pid=8720,fd=6))<br>
> > > > > > > LISTEN 0 128 [::]:22<br>
> > > > > > > [::]:* users:(("sshd",pid=1395,fd=4))<br>
> > > > > > ><br>
> > > > > > > It is not visitable:<br>
> > > > > > > # psql -h 127.0.0.1 -p 9999 -U checker template1<br>
> > > > > > > psql: error: server closed the connection unexpectedly<br>
> > > > > > > This probably means the server terminated abnormally<br>
> > > > > > > before or while processing the request.<br>
> > > > > > > Checking out the log, any pgpool subprocess is killed by segment<br>
> > > > fault.<br>
> > > > > > > And I run it again using debug mode, the same thing happens.<br>
> > > > > > > Attached is the pgpool log. Thanks in advance.<br>
> > > > > ><br>
> > > > > ><br>
> > > > > > --<br>
> > > > > > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > > > > > SRA OSS LLC<br>
> > > > > > TEL: 03-5979-2701 FAX: 03-5979-2702<br>
> > > > > > URL: <a href="https://www.sraoss.co.jp/" rel="noreferrer" target="_blank">https://www.sraoss.co.jp/</a><br>
> > > > > ><br>
> > > ><br>
> > > ><br>
> > > > --<br>
> > > > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > > > SRA OSS LLC<br>
> > > > TEL: 03-5979-2701 FAX: 03-5979-2702<br>
> > > > URL: <a href="https://www.sraoss.co.jp/" rel="noreferrer" target="_blank">https://www.sraoss.co.jp/</a><br>
> > > ><br>
> ><br>
> ><br>
> > --<br>
> > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > SRA OSS LLC<br>
> > TEL: 03-5979-2701 FAX: 03-5979-2702<br>
> > URL: <a href="https://www.sraoss.co.jp/" rel="noreferrer" target="_blank">https://www.sraoss.co.jp/</a><br>
> ><br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS LLC<br>
TEL: 03-5979-2701 FAX: 03-5979-2702<br>
URL: <a href="https://www.sraoss.co.jp/" rel="noreferrer" target="_blank">https://www.sraoss.co.jp/</a><br>
</blockquote></div>