[JDBC Smart Driver] Incorrect host value being return in Kubernetes environment

[nchandrappa]

I'm submitting a ...

• [ X] bug report
• feature request

Describe the issue
Incorrect hostname being set in Kubernetes environment when server_broadcast_addresses gflag is set for tservers. When server_broadcast_addresses is set to hostnode ip, yb_servers() functions incorrectly returning broadcast_address as pod ip_address.

YCQL Output of system.peers table -

ycqlsh> select * from system.peers;

 peer        | data_center | host_id                              | preferred_ip | rack  | release_version | rpc_address | schema_version                       | tokens
-------------+-------------+--------------------------------------+--------------+-------+-----------------+-------------+--------------------------------------+--------------------------
 10.142.0.26 | datacenter1 | 08ecd821-12b3-6fbb-b742-c0496617e0b5 |   10.64.4.21 | rack1 |    3.9-SNAPSHOT | 10.142.0.26 | 00000000-0000-0000-0000-000000000000 |  {'6148820866244280320'}
 10.142.0.33 | datacenter1 | 111a14ca-12b0-77ba-734d-8c42a176dffd |   10.64.3.30 | rack1 |    3.9-SNAPSHOT | 10.142.0.33 | 00000000-0000-0000-0000-000000000000 | {'-6149102341220990976'}

YSQL yb_servers() output -

yugabyte=# select * from yb_servers();
    host     | port | num_connections | node_type | cloud  |   region    | zone  |  public_ip
-------------+------+-----------------+-----------+--------+-------------+-------+-------------
 10.142.0.32 | 5433 |               0 | primary   | cloud1 | datacenter1 | rack1 | 10.142.0.32
 10.142.0.26 | 5433 |               0 | primary   | cloud1 | datacenter1 | rack1 | 10.142.0.26
 10.142.0.33 | 5433 |               0 | primary   | cloud1 | datacenter1 | rack1 | 10.142.0.33
(3 rows)

host column should be set to pod ip_address. Refer to preferred_ip column in system.peers table.

To Reproduce
setup a YugabyteDB 2.7.2.0-b216 using Helm Chart and run SELECT * FROM yb_servers();

Expected behaviour
host value should be set to pod ip_address.

[kneeraj]

Fixed in revision: c09d3c8 of the yugabytedb core repository.