[pgpool-general: 3374] show pool_nodes

Chris Beauchamp chris at chillibean.tv
Thu Dec 18 00:17:02 JST 2014


Hi

I've added in 12 backend nodes (number 0-11) - I'm experimenting currently
before putting something into production.

However, when I do "show pool_nodes" I get the following output:

 node_id |   hostname   | port | status | lb_weight |  role
---------+--------------+------+--------+-----------+---------
 0       | 10.10.50.229 | 5701 | 2      | 0.083333  | standby
 1       | 10.10.50.229 | 5702 | 2      | 0.083333  | standby
 2       | 10.10.50.229 | 5703 | 2      | 0.083333  | primary
 3       | 10.10.50.229 | 5704 | 2      | 0.083333  | standby
 4       | 10.10.50.229 | 5705 | 2      | 0.083333  | standby
 5       | 10.10.50.229 | 5706 | 2      | 0.083333  | standby
 6       | 10.10.50.228 | 5701 | 2      | 0.083333  | standby
 7       | 10.10.50.228 | 5702 | 2      | 0.083333  | standby
 8       | 10.10.50.228 | 5703 | 3      | 0.083333  | standby
 9       | 10.10.50.228 | 5704 | 3      | 0.083333  | standby
 1       | 10.10.50.228 | 5705 | 2      | 0.083333  | standby
 1       | 10.10.50.228 | 5706 | 3      | 0.083333  | standby

It's truncating the node_id down to 1 character - I've checked with
wireshark as to what's being transmitted, and it appears to actually be
sending that, so it looks like an issue within pgpool itself.

Is this a bug? A known bug? (I couldn't find anything in the mailing lists
or bug database)

Thanks

Chris

-- 

*Chris Beauchamp*
Systems Administrator
ChilliBean Ltd

22, D'Arblay Street, London, W1F 8EQ, United Kingdom
tel +44 (0)20 7479 7030  |  mobile +44 (0)7770 643582  |  email
chris at chillibean.tv

www.chillibean.tv  |  www.chillivault.tv  |  www.sohosoho.tv

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Chillibean Limited. If you are not the intended
 recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.

Chillibean Limited of 10 Livonia Street, London W1F 8AF, United Kingdom is
a limited company registered in England under No. 4775994 VAT Registration
No. 835 760 804.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141217/42fddaf5/attachment-0001.html>


More information about the pgpool-general mailing list