[pgpool-general: 7112] Pooling doesn't appear to be working.

[Matthew Tice]

Hi Guys,

When I list the output of SHOW POOL_POOLS, all the pools have a pool_counter=1
and a distinct pool_backendpid.  To me this means that even though I have
the same users connecting, with the same major/minor, connection pools
aren't being reused.  Is that correct?  Here's a snippet (I have three
backends):

 141204   | 2020-07-01 11:04:21 | 0       | 0          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 12047           | 1
 141204   | 2020-07-01 11:04:21 | 0       | 1          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 60420           | 1
 141204   | 2020-07-01 11:04:21 | 0       | 2          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 137228          | 1
 141515   | 2020-07-01 11:04:21 | 1       | 0          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 12049           | 1
 141515   | 2020-07-01 11:04:21 | 1       | 1          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 60428           | 1
 141515   | 2020-07-01 11:04:21 | 1       | 2          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 137235          | 1
 173903   | 2020-07-01 12:11:17 | 0       | 0          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 12050           | 1
 173903   | 2020-07-01 12:11:17 | 0       | 1          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 60430           | 1
 173903   | 2020-07-01 12:11:17 | 0       | 2          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 137237          | 1
 173620   | 2020-07-01 12:10:42 | 0       | 0          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 12052           | 1
 173620   | 2020-07-01 12:10:42 | 0       | 1          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 60433           | 1
 173620   | 2020-07-01 12:10:42 | 0       | 2          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 137242          | 1
 173094   | 2020-07-01 12:09:36 | 0       | 0          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 12051           | 1
 173094   | 2020-07-01 12:09:36 | 0       | 1          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 60431           | 1
 173094   | 2020-07-01 12:09:36 | 0       | 2          | mobile-search-bff
              | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3
         | 0            | 1            | 137239          | 1

The only thing I can think of is that it may have something to do with the
user names (these are Vault-generated users).

I do have the connection cache parameter on:

connection_cache on

I'm using PgPool-II v. 4.1.1.

Thanks,

Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200701/bb216ab5/attachment.html>