[pgpool-general: 3383] Re: show pool_nodes

[Muhammad Usama]

Hi Chris

Thanks for pointing out this bug. I have pushed the fix in all
branches from 3.2 onward.

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=30168327732c4981a52e917cf2679a481a12781f

Thanks
Kind regards,
Muhammad Usama


On Wed, Dec 17, 2014 at 8:17 PM, Chris Beauchamp <chris at chillibean.tv> wrote:
> 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.
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>